[SOLVED] Banshee crashed

You’ll probably laugh your heads off at this one…
I let our Alsation in and he rushed past the PC, wagging his tail and hit the power button which caused the PC to reboot but it didn’t do a propper reboot (it kind of shut itself down but didn’t come back properly) so I had to press it again to make it reboot properly.
When it rebooted, I tried running Banshee but it came up with ‘Fatal Error’

[spoiler]An unhandled exception was thrown: Sqlite error 11: database disk image is malformed (SQL: SELECT COUNT(*) FROM CoreTracks)

at Hyena.Data.Sqlite.Connection.CheckError (Int32 errorCode, System.String sql) [0x00000] in :0
at Hyena.Data.Sqlite.Statement.CheckError (Int32 code) [0x00000] in :0
at Hyena.Data.Sqlite.QueryReader.Read () [0x00000] in :0
at Hyena.Data.Sqlite.Statement.Query[Object] () [0x00000] in :0
at Hyena.Data.Sqlite.Connection.Query[Object] (System.String sql) [0x00000] in :0
at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Hyena.Data.Sqlite.Connection connection) [0x00000] in :0
Exception has been thrown by the target of an invocation.

at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
at System.Reflection.ConstructorInfo.Invoke (System.Object parameters) [0x00000] in :0
at System.Activator.CreateInstance (System.Type type, Boolean nonPublic) [0x00000] in :0
at System.Activator.CreateInstance (System.Type type) [0x00000] in :0
at Banshee.ServiceStack.ServiceManager.RegisterService (System.Type type) [0x00000] in :0
Exception has been thrown by the target of an invocation.

at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object parameters, System.Globalization.CultureInfo culture) [0x00000] in :0
at System.Reflection.ConstructorInfo.Invoke (System.Object parameters) [0x00000] in :0
at System.Activator.CreateInstance (System.Type type, Boolean nonPublic) [0x00000] in :0
at System.Activator.CreateInstance (System.Type type) [0x00000] in :0
at Banshee.Gui.GtkBaseClient.Startup () [0x00000] in :0
at Hyena.Gui.CleanRoomStartup.Startup (Hyena.Gui.StartupInvocationHandler startup) [0x00000] in :0

.NET Version: 4.0.30319.1
OS Version: Unix 3.0.0.23

Assembly Version Information:

System.Configuration (4.0.0.0)
gconf-sharp (2.24.0.0)
Banshee.Gnome (2.4.0.0)
Banshee.NowPlaying (2.4.0.0)
System.Xml (4.0.0.0)
Banshee.Core (2.4.0.0)
Hyena.Data.Sqlite (2.4.0.0)
gdk-sharp (2.12.0.0)
Mono.Addins (0.6.0.0)
atk-sharp (2.12.0.0)
Hyena.Gui (2.4.0.0)
Mono.Posix (4.0.0.0)
gtk-sharp (2.12.0.0)
Banshee.ThickClient (2.4.0.0)
Nereid (2.4.0.0)
DBus.Proxies (0.0.0.0)
dbus-sharp-glib (1.0.0.0)
System.Core (4.0.0.0)
Hyena (2.4.0.0)
dbus-sharp (1.0.0.0)
glib-sharp (2.12.0.0)
System (4.0.0.0)
Banshee.Services (2.4.0.0)
Banshee (2.4.0.0)
mscorlib (4.0.0.0)

Platform Information: Linux 3.0.0-23-generic x86_64 x86_64 GNU/Linux

Disribution Information:

[/etc/lsb-release]
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=11.10
DISTRIB_CODENAME=oneiric
DISTRIB_DESCRIPTION=“Ubuntu 11.10”

[/etc/debian_version]
wheezy/sid

[/spoiler]

Did a bit of searching and saw ‘debug’ and how to use it and here is the result;

peter@Petes-ubuntu-pc:~$ banshee --debug
** Running Mono with --debug **
[1 Debug 22:34:31.365] Bus.Session.RequestName (‘org.bansheeproject.Banshee’) replied with PrimaryOwner
[1 Info 22:34:31.385] Running Banshee 2.4.1: [Ubuntu 11.10 (linux-gnu, x86_64) @ 2012-07-05 20:42:53 UTC]
[1 Debug 22:34:31.414] Initializing GTK
[1 Debug 22:34:32.559] Post-Initializing GTK
[1 Debug 22:34:32.571] Configuration client extension loaded (Banshee.GnomeBackend.GConfConfigurationClient)
[1 Debug 22:34:32.574] Using default gconf-base-key
[1 Debug 22:34:32.660] Core service started (DBusServiceManager, 0.001411)
[1 Debug 22:34:32.663] Registering remote object /org/bansheeproject/Banshee/DBusCommandService (Banshee.ServiceStack.DBusCommandService) on org.bansheeproject.Banshee
[1 Debug 22:34:32.670] Core service started (DBusCommandService, 0.008613)
[4 Debug 22:34:32.699] Exception executing command: SELECT COUNT() FROM CoreTracks
[4 Warn 22:34:32.703] Caught an exception - Hyena.Data.Sqlite.SqliteException: Sqlite error 11: database disk image is malformed (SQL: SELECT COUNT(
) FROM CoreTracks) (in `Hyena.Data.Sqlite’)
at Hyena.Data.Sqlite.Connection.CheckError (Int32 errorCode, System.String sql) [0x00000] in :0
at Hyena.Data.Sqlite.Statement.CheckError (Int32 code) [0x00000] in :0
at Hyena.Data.Sqlite.QueryReader.Read () [0x00000] in :0
at Hyena.Data.Sqlite.Statement.Query[Object] () [0x00000] in :0
at Hyena.Data.Sqlite.Connection.Query[Object] (System.String sql) [0x00000] in :0
at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Hyena.Data.Sqlite.Connection connection) [0x00000] in :0
[1 Error 22:34:32.704] Error initializing required service Banshee.Database.BansheeDbConnection
Exception has been thrown by the target of an invocation.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> Hyena.Data.Sqlite.SqliteException: Sqlite error 11: database disk image is malformed (SQL: SELECT COUNT(*) FROM CoreTracks)
at Hyena.Data.Sqlite.Connection.CheckError (Int32 errorCode, System.String sql) [0x00000] in :0
at Hyena.Data.Sqlite.Statement.CheckError (Int32 code) [0x00000] in :0
at Hyena.Data.Sqlite.QueryReader.Read () [0x00000] in :0
at Hyena.Data.Sqlite.Statement.Query[Object] () [0x00000] in :0

See this wiki:
https://wiki.edubuntu.org/DebuggingBanshee
Look at Database Corrupted if your logfile has texts like: “Sqlite error 11: database disk image is malformed”
You might need to install sqlite3:

sudo apt-get install sqlite3

Just tried that and it says it’s already installed…
Will take a look at the link you posted.

peter@Petes-ubuntu-pc:~$ sudo apt-get install sqlite3
[sudo] password for peter:
Reading package lists… Done
Building dependency tree
Reading state information… Done
sqlite3 is already the newest version.
sqlite3 set to manually installed.
The following packages were automatically installed and are no longer required:
libzemberek-tr-java tsocks socat libsexy2 libzemberek-java
Use ‘apt-get autoremove’ to remove them.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
peter@Petes-ubuntu-pc:~$

Solved how?

Check the bottom of the page…

It turned out to be the library database