Handle database corruption more gracefully

[René Brandenburger]

Binary package hint: banshee

since a few days, banshee crashes when i move on to the next title

the console shows the following entry:

(Banshee:4378): Gtk-WARNING **: gtk_scrolled_window_add(): cannot add non scrollable widget use gtk_scrolled_window_add_with_viewport() instead

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]

[Alexander Kojevnikov (alexk)]

See the last question in the FAQ: http://banshee-project.org/support/faq/

[René Brandenburger (rene-brandenburger)]

thanks - worked for me.

wouldn't it be good to catch that exception and tell the user about this?

regards

[Victor Vargas (kamus)]

What version of banshee do you use? is this issue still affecting you under latest release of banshee included in Ubuntu Maverick? Thanks in advance.

[Yuriy Voziy (yuretsz)]

Have the same problem. Banshee definitely should give user some help with this.

[Abdusamed Ahmed (sir508)]

I can confirm this on

Linux 2.6.32-25-generic #45-Ubuntu SMP Sat Oct 16 19:52:42 UTC 2010 x86_64 GNU/Linux'

running "Banshee 1.8.0 (1.8.0)"

Log attached

Crashes when I click in my case.. 'unwatched' or just crashes by itself...

[Abdusamed Ahmed (sir508)]

I'm on ubuntu 10.04.1 Lucid Lynx

[Michael Martin-Smucker (mmartinsmucker)]

Just for the sake of clarity, it's safe to assume that this issue exists in all versions of Banshee (including even the most recent packages for Ubuntu) until the upstream bug report is marked as fixed. The problem is not specific to any certain version of Banshee; it happens when the SQLite database that Banshee uses gets corrupted -- probably as the result of a system crash or a loss of power while Banshee is running.

The good news is, as Alexander said in the first comment, the database (including all of your playlists, ratings, etc) can generally be recovered in a few simple steps. Developers are working on a solution that should eventually automate this database recovery process.

Thanks to everyone who has taken the time to track this down and confirm it! No more confirmations are necessary at this point, but if you're interested in helping out or following the progress, please see the upstream report: https://bugzilla.gnome.org/show_bug.cgi?id=621057

[Victor Vargas (kamus)]

Thanks for all the feedback Michael.