Banshee just crashed on me with the following error message:
<br /> [Info 20:44:59.949] Running Banshee 1.6.1: [Ubuntu 10.04 LTS (linux-gnu, x86_64) @ 2010-06-18 18:47:49 UTC]<br /> [Info 20:45:01.043] All services are started 0.949921<br /> Exception has been thrown by the target of an invocation.<br /> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Mono.Data.Sqlite.SqliteException: <strong>The database disk image is malformed</strong><br /> database disk image is malformed<br /> at Mono.Data.Sqlite.Sqlite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00000]<br /> at Mono.Data.Sqlite.Sqlite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x00000]<br /> at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000]<br /> at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand:ExecuteNonQuery ()<br /> at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Mono.Data.Sqlite.SqliteConnection connection) [0x00000]<br /> --- End of inner exception stack trace ---<br />
I think this is how it happened. My computer hanged while Banshee was running, and I had to force reboot it. Hence, the Banshee database file was corrupted. Thanks to boombox1387 from Ubuntu forum, this problem can be fixed as the following:
Install sqlite3:
<br /> sudo apt-get install sqlite3
Then run:
<br /> cd ~/.config/banshee-1
Dump the database in an SQL text format:
<br /> sqlite3 banshee.db ".dump" > dump
Backup the (corrupted) database:
<br /> mv banshee.db banshee.db.backup
Create and restore a database from dump file:
<br /> cat dump | sqlite3 banshee.db
Banshee started up again. Both files: dump and banshee.db can be removed.
Credit: [ubuntu] Banshee Crashed