Banshee crashes: The database disk image is malformed

Banshee just crashed on me with the following error message:

[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]
[Info  20:45:01.043] All services are started 0.949921
Exception has been thrown by the target of an invocation.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> 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]
--- End of inner exception stack trace ---

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:

sudo apt-get install sqlite3

Then run:

cd ~/.config/banshee-1

Dump the database in an SQL text format:

sqlite3 banshee.db ".dump" > dump

Backup the (corrupted) database:

mv banshee.db banshee.db.backup

Create and restore a database from dump file:

cat dump | sqlite3 banshee.db

Banshee started up again. Both files: dump and banshee.db can be removed.

Credit: [ubuntu] Banshee Crashed

About these ads
Tagged , ,

17 thoughts on “Banshee crashes: The database disk image is malformed

  1. Toby says:

    Just what I needed! Thanks.

  2. Frederic says:

    Very helpful!

  3. Thomas says:

    Thanks so much! Same thing happened to me. Worked perfectly!

  4. Kenno says:

    I’m glad to hear this post has helped 3 people so far. :)

  5. Marquis says:

    Thanks! Finally got my music to work!

  6. Max says:

    This worked, thanks for sharing.

  7. Ty says:

    Thanks! Worked for me. Sharing as well.

  8. Thank you for sharing. queue, death metal

  9. mrlee says:

    Worked as well… nice.

  10. Aaron says:

    Nice!!!, This is still working ,, i thought all hope was lost on my new ubuntu for music =(.. This fixed it, ha smooth stuff nice work!

  11. Ken says:

    Great job, I run Ubuntu in a VM and it kept crashing while playing music off a usb drive (my phone). Did realize there was corruption till I ran strace and saw the error. Your restore worked like a charm, so thanks.

  12. nate says:

    This works perfectly in fedora as well, just replace ‘sudo apt-get install sqlite3′ with ‘sudo yum install sqlite’, the rest of the steps are exactly the same.

  13. DC says:

    Yep, worked for me! Thank you, awesome!

  14. Alyaxey says:

    Worked for me, thanks.

  15. David says:

    Awesome, didn’t have to lose all my metadata

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

%d bloggers like this: