Banshee

Handle database corruption more gracefully

Bug #582743 reported by René Brandenburger on 2010-05-19

This bug affects 7 people

Affects		Status	Importance	Assigned to	Milestone
	Banshee	Confirmed	Medium	gnome-bugs #621057
	banshee (Ubuntu)	Triaged	Medium	Unassigned

Bug Description

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]

Revision history for this message

Alexander Kojevnikov (alexk) wrote on 2010-05-19:

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

Revision history for this message

René Brandenburger (rene-brandenburger) wrote on 2010-05-19:

thanks - worked for me.

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

regards

Chow Loong Jin (hyperair) on 2010-06-09

Changed in banshee (Ubuntu):
status:	New → Confirmed

Bug Watch Updater (bug-watch-updater) on 2010-06-09

Changed in banshee:
status:	Unknown → In Progress

Revision history for this message

Victor Vargas (kamus) wrote on 2010-08-17:

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.

Changed in banshee (Ubuntu):
importance:	Undecided → Medium
status:	Confirmed → Incomplete

Revision history for this message

Yuriy Voziy (yuretsz) wrote on 2010-09-14:

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

Bug Watch Updater (bug-watch-updater) on 2010-09-16

Changed in banshee:
importance:	Unknown → Medium

Revision history for this message

Abdusamed Ahmed (sir508) wrote on 2010-10-29:

banshee.log Edit (265.2 KiB, text/plain)

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...

Revision history for this message

Abdusamed Ahmed (sir508) wrote on 2010-10-29:

I'm on ubuntu 10.04.1 Lucid Lynx

Michael Martin-Smucker (mmartinsmucker) on 2010-10-29

Changed in banshee (Ubuntu):
status:	Incomplete → Confirmed

Revision history for this message

Michael Martin-Smucker (mmartinsmucker) wrote on 2010-10-29:

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