Re: [Banshee-List] Banshee crashes, errors about database disk

[Gabriel Burt <gabriel burt gmail com>]

One way that seems to work pretty well is to dump the database's
contents, then recreate it:

$ sqlite3 ~/.config/banshee-1/banshee.db ".dump" > dump
$ mv ~/.config/banshee-1/banshee.db banshee.db.backup
$ cat dump | sqlite3 ~/.config/banshee-1/banshee.db

Gabriel

On Thu, Dec 10, 2009 at 8:14 AM, Daniel <nix tek12 com> wrote:
> I've got an interesting issue with Banshee... just started happening
> yesterday. I'm running 1.5.3 on ubuntu 9.10 and I noticed that one of my
> smart playlists has almost twice as many songs as it did before. The
> criteria for the smart playlist is based on 5 star ratings.
>
> Now, when I play anything in that playlist - Bashee crashes. I launched from
> the command line to try to capture some output (I pasted output at the
> bottom of the email). The main errors that I'm noticing are:
>
> [Warn  10:21:45.831] Error determining if ANALYZE is necessary - The
> database disk image is malformed
> database disk image is malformed (in `Mono.Data.Sqlite')
>
> [Warn  10:21:53.792] Caught an exception - Whitespace is required between
> PUBLIC id and SYSTEM id.  Line 1, position 49. (in `System.Xml')
>
> Unhandled Exception: Mono.Data.Sqlite.SqliteException: The database disk
> image is malformed
> database disk image is malformed
>
> Is there any way to recover the database without just deleting
> ~/.config/banshee-1 and letting it recreate everything.
>
> Thanks,
> Daniel
>
>
>
> ################
> Complete Output:
>
> [Info  10:21:45.200] Running Banshee 1.5.3:
> [Ubuntu 9.10 b171cd3 (linux-gnu, x86_64) @ 2009-12-06 20:05:37 UTC]
> (/usr/lib/banshee-1/Banshee.exe:22110): GLib-WARNING **: g_set_prgname()
> called multiple times
> [Warn  10:21:45.831] Error determining if ANALYZE is necessary - The
> database disk image is malformed
> database disk image is malformed (in `Mono.Data.Sqlite')
>   at Mono.Data.Sqlite.Sqlite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt)
> [0x00000]
>   at Mono.Data.Sqlite.Sqlite3.Step (Mono.Data.Sqlite.SqliteStatement stmt)
> [0x00000]
>   at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000]
>   at (wrapper remoting-invoke-with-check)
> Mono.Data.Sqlite.SqliteCommand:ExecuteNonQuery ()
>   at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute
> (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection,
> Mono.Data.Sqlite.SqliteConnection connection) [0x00000]
> [Info  10:21:46.511] All services are started 1.195908s
> [Info  10:21:51.076] nereid Client Started
> [Warn  10:21:53.289] Caught an exception - Whitespace is required between
> PUBLIC id and SYSTEM id.  Line 1, position 55. (in `System.Xml')
>   at Mono.Xml2.XmlTextReader.ReadDoctypeDecl () [0x00000]
>   at Mono.Xml2.XmlTextReader.ReadDeclaration () [0x00000]
>   at Mono.Xml2.XmlTextReader.ReadContent () [0x00000]
>   at Mono.Xml2.XmlTextReader.Read () [0x00000]
>   at System.Xml.XmlTextReader.Read () [0x00000]
>   at System.Xml.XmlDocument.ReadNodeCore (System.Xml.XmlReader reader)
> [0x00000]
>   at System.Xml.XmlDocument.ReadNode (System.Xml.XmlReader reader) [0x00000]
>   at System.Xml.XmlDocument.Load (System.Xml.XmlReader xmlReader) [0x00000]
>   at System.Xml.XmlDocument.LoadXml (System.String xml) [0x00000]
>   at Migo.Syndication.RssParser..ctor (System.String url, System.String xml)
> [0x00000]
> [Warn  10:21:53.289] Caught an exception - Invalid XML document. (in `Migo')
>   at Migo.Syndication.RssParser..ctor (System.String url, System.String xml)
> [0x00000]
>   at Migo.Syndication.FeedUpdateTask.OnDownloadDataReceived (System.Object
> sender, Migo.Net.DownloadStringCompletedEventArgs args) [0x00000]
> [Warn  10:21:53.792] Caught an exception - Whitespace is required between
> PUBLIC id and SYSTEM id.  Line 1, position 49. (in `System.Xml')
>   at Mono.Xml2.XmlTextReader.ReadDoctypeDecl () [0x00000]
>   at Mono.Xml2.XmlTextReader.ReadDeclaration () [0x00000]
>   at Mono.Xml2.XmlTextReader.ReadContent () [0x00000]
>   at Mono.Xml2.XmlTextReader.Read () [0x00000]
>   at System.Xml.XmlTextReader.Read () [0x00000]
>   at System.Xml.XmlDocument.ReadNodeCore (System.Xml.XmlReader reader)
> [0x00000]
>   at System.Xml.XmlDocument.ReadNode (System.Xml.XmlReader reader) [0x00000]
>   at System.Xml.XmlDocument.Load (System.Xml.XmlReader xmlReader) [0x00000]
>   at System.Xml.XmlDocument.LoadXml (System.String xml) [0x00000]
>   at Migo.Syndication.RssParser..ctor (System.String url, System.String xml)
> [0x00000]
> [Warn  10:21:53.792] Caught an exception - Invalid XML document. (in `Migo')
>   at Migo.Syndication.RssParser..ctor (System.String url, System.String xml)
> [0x00000]
>   at Migo.Syndication.FeedUpdateTask.OnDownloadDataReceived (System.Object
> sender, Migo.Net.DownloadStringCompletedEventArgs args) [0x00000]
>
> Unhandled Exception: Mono.Data.Sqlite.SqliteException: The database disk
> image is malformed
> database disk image is malformed
>   at Mono.Data.Sqlite.Sqlite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt)
> [0x00000]
>   at Mono.Data.Sqlite.Sqlite3.Step (Mono.Data.Sqlite.SqliteStatement stmt)
> [0x00000]
>   at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000]
>   at (wrapper remoting-invoke-with-check)
> Mono.Data.Sqlite.SqliteCommand:ExecuteNonQuery ()
>   at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute
> (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection,
> Mono.Data.Sqlite.SqliteConnection connection) [0x00000]
>
> --
> Regards,
> Daniel
>
> _______________________________________________
> banshee-list mailing list
> banshee-list gnome org
> http://mail.gnome.org/mailman/listinfo/banshee-list
>
>