Re: [Banshee-List] Banshee fatal error ("database disk image is malformed") (Xubuntu 14.04 64bit)

[Adam Tauno Williams <awilliam whitemice org>]

On Mon, 2015-09-14 at 20:54 +0100, IBBoard wrote:
> On 14/09/15 00:16, KirillDeVries wrote:
> > After an unexpected shutdown, I get the following fatal error 
> > message whenever I try to launch Banshee:

What type of "unexpected shutdown"?  Of the host, or of Banshee? 
 Smashing an sqlite database is very unusual.

> > An unhandled exception was thrown: Sqlite error 11: database disk
> > image is
> > malformed (SQL: 
> >                     DELETE FROM CoreCache WHERE ModelID = 21;
> >                         INSERT INTO CoreCache (ModelID, ItemID)
> > SELECT 21,
> > CoreTracks.TrackID 
> >                 FROM (SELECT MIN(CoreTracks.TrackID) AS TrackID,
> > CoreTracks.Year FROM CoreTracks GROUP BY CoreTracks.Year) AS
> > CoreTracks
> >                 WHERE CoreTracks.Year IN
> >                     (SELECT CoreTracks.Year FROM CoreTracks,
> > CoreCache
> >                         WHERE CoreCache.ModelID = 83 AND
> >                               CoreCache.ItemID = CoreTracks.TrackID
> > )
> >                     ORDER BY Year)
> >   at Hyena.Data.Sqlite.Connection.CheckError (Int32 errorCode,
> > System.String
> > sql) [0x00000] in <filename unknown>:0 
> >   at Hyena.Data.Sqlite.Connection.Execute (System.String sql)
> > [0x00000] in
> > <filename unknown>:0 
> >   at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute
> > (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection,
> > Hyena.Data.Sqlite.Connection connection) [0x00000] in <filename
> > unknown>:0 
> > Exception has been thrown by the target of an invocation.

I suspect the real error has been eaten by the database abstraction
layer,  opening the database 'directly' [using sqlite3] will likely
tell you more plainly what is wrong.

> > And after displaying the message, the program quits.
> > How can I solve this problem?
> > When I use the sudo banshee command, it starts; however, even if it
> > starts,

"sudo banshee" ??? ... I do not understand why you are doing that.

> > my stats (playlists, the number of times I played a certain song
> > and when I
> > played it) are no longer there! So unless I solve the problem, I
> > can no
> > longer access my listening data and stuff.

First thing you should do is make a copy of the database; if it is
damaged attempting to use it could only make the problem worse.

You should be able to open the database with the sqlite3 command.

-- 
Adam Tauno Williams <mailto:awilliam whitemice org> GPG D95ED383
Systems Administrator, Python Developer, LPI / NCLA