Re: [Banshee-List] Banshee crashes with "An unhandled exception was thrown: SQL logic error or missing database"

[OliverH <oliverhorn gmx net>]

Same for me using Banshee 1.4.3 on Intrepid. I start a song but when it comes
to play the next song it crashes. Here is my "banshee --debug-sql", it
starts while playing the first song:

[Debug 11:35:34.194] TrackInfoDisplay RenderAnimation: 28,00 FPS
[Debug 11:35:34.224] TrackInfoDisplay RenderAnimation: 29,00 FPS
[Debug 11:35:48.325] Executed in 0ms SELECT
CoreTracks.Rating,CoreTracks.LastStreamError,CoreTracks.TrackID,CoreTracks.PrimarySourceID,CoreTracks.ArtistID,CoreTracks.AlbumID,CoreTracks.TagSetID,CoreTracks.MusicBrainzID,CoreTracks.MimeType,CoreTracks.FileSize,CoreTracks.FileModifiedStamp,CoreTracks.LastSyncedStamp,CoreTracks.Attributes,CoreTracks.Title,CoreTracks.TrackNumber,CoreTracks.TrackCount,CoreTracks.Disc,CoreTracks.DiscCount,CoreTracks.Duration,CoreTracks.Year,CoreTracks.Genre,CoreTracks.Composer,CoreTracks.Conductor,CoreTracks.Grouping,CoreTracks.Copyright,CoreTracks.LicenseUri,CoreTracks.Comment,CoreTracks.BPM,CoreTracks.BitRate,CoreTracks.PlayCount,CoreTracks.SkipCount,CoreTracks.ExternalID,CoreTracks.LastPlayedStamp,CoreTracks.LastSkippedStamp,CoreTracks.DateAddedStamp,CoreTracks.DateUpdatedStamp,CoreTracks.Uri,CoreTracks.UriType,CoreArtists.Name,CoreAlbums.Title,CoreAlbums.ArtistName,CoreAlbums.IsCompilation
FROM CoreTracks,CoreAlbums,CoreArtists WHERE CoreArtists.ArtistID =
CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND
CoreTracks.TrackID = 9169
[Debug 11:35:48.364] Executed in 32ms UPDATE CoreTracks SET Rating =
0,LastStreamError = 0,PrimarySourceID = 1,ArtistID = 1187,AlbumID =
2470,TagSetID = 0,MusicBrainzID = NULL,MimeType = 'taglib/mp3',FileSize =
8823368,FileModifiedStamp = 1166034374,LastSyncedStamp =
1234521205,Attributes = 5,Title = 'Talk',MetadataHash =
'b66d782377989c2cebd9e40804b1d975',TrackNumber = 5,TrackCount = 13,Disc =
0,DiscCount = 0,Duration = 311301,Year = 2005,Genre = 'Rock',Composer =
NULL,Conductor = NULL,Grouping = NULL,Copyright = NULL,LicenseUri =
NULL,Comment = NULL,BPM = 0,BitRate = 128,PlayCount = 1,SkipCount =
1,ExternalID = 0,LastPlayedStamp = 1237715607,LastSkippedStamp =
1237804548,DateAddedStamp = 1233776584,DateUpdatedStamp = 1237804548,Uri =
'Rock/X  Y - 05 - Coldplay - Talk.mp3',UriType = 1,TitleLowered = 'talk'
WHERE TrackID = 9169
[Debug 11:35:48.368] Querying model for track to play in Song:Next mode
[Debug 11:35:48.370] Executed in 1ms SELECT
CoreTracks.Rating,CoreTracks.LastStreamError,CoreTracks.TrackID,CoreTracks.PrimarySourceID,CoreTracks.ArtistID,CoreTracks.AlbumID,CoreTracks.TagSetID,CoreTracks.MusicBrainzID,CoreTracks.MimeType,CoreTracks.FileSize,CoreTracks.FileModifiedStamp,CoreTracks.LastSyncedStamp,CoreTracks.Attributes,CoreTracks.Title,CoreTracks.TrackNumber,CoreTracks.TrackCount,CoreTracks.Disc,CoreTracks.DiscCount,CoreTracks.Duration,CoreTracks.Year,CoreTracks.Genre,CoreTracks.Composer,CoreTracks.Conductor,CoreTracks.Grouping,CoreTracks.Copyright,CoreTracks.LicenseUri,CoreTracks.Comment,CoreTracks.BPM,CoreTracks.BitRate,CoreTracks.PlayCount,CoreTracks.SkipCount,CoreTracks.ExternalID,CoreTracks.LastPlayedStamp,CoreTracks.LastSkippedStamp,CoreTracks.DateAddedStamp,CoreTracks.DateUpdatedStamp,CoreTracks.Uri,CoreTracks.UriType,CoreArtists.Name,CoreAlbums.Title,CoreAlbums.ArtistName,CoreAlbums.IsCompilation,
CoreCache.ItemID FROM CoreTracks,CoreAlbums,CoreArtists
                        INNER JOIN CoreCache 
                            ON CoreTracks.TrackID = CoreCache.ItemID
                        WHERE
                            CoreCache.ModelID = 19 AND CoreArtists.ArtistID
= CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND
(LastPlayedStamp < 1237804503 OR LastPlayedStamp IS NULL) AND
(LastSkippedStamp < 1237804503 OR LastSkippedStamp IS NULL) ORDER BY
RANDOM() LIMIT 1
[Debug 11:35:48.371] (libbanshee:player) bp_stop: setting state to
GST_STATE_NULL
[Debug 11:35:48.385] Player state change: Playing -> Idle
[Debug 11:35:48.387] Player state change: Idle -> Loading
[Debug 11:35:48.449] Executed in 11ms SELECT
CoreTracks.Rating,CoreTracks.LastStreamError,CoreTracks.TrackID,CoreTracks.PrimarySourceID,CoreTracks.ArtistID,CoreTracks.AlbumID,CoreTracks.TagSetID,CoreTracks.MusicBrainzID,CoreTracks.MimeType,CoreTracks.FileSize,CoreTracks.FileModifiedStamp,CoreTracks.LastSyncedStamp,CoreTracks.Attributes,CoreTracks.Title,CoreTracks.TrackNumber,CoreTracks.TrackCount,CoreTracks.Disc,CoreTracks.DiscCount,CoreTracks.Duration,CoreTracks.Year,CoreTracks.Genre,CoreTracks.Composer,CoreTracks.Conductor,CoreTracks.Grouping,CoreTracks.Copyright,CoreTracks.LicenseUri,CoreTracks.Comment,CoreTracks.BPM,CoreTracks.BitRate,CoreTracks.PlayCount,CoreTracks.SkipCount,CoreTracks.ExternalID,CoreTracks.LastPlayedStamp,CoreTracks.LastSkippedStamp,CoreTracks.DateAddedStamp,CoreTracks.DateUpdatedStamp,CoreTracks.Uri,CoreTracks.UriType,CoreArtists.Name,CoreAlbums.Title,CoreAlbums.ArtistName,CoreAlbums.IsCompilation,
CoreCache.ItemID FROM CoreTracks,CoreAlbums,CoreArtists
                        INNER JOIN CoreCache 
                            ON CoreTracks.TrackID = CoreCache.ItemID
                        WHERE
                            CoreCache.ModelID = 19 AND CoreArtists.ArtistID
= CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID LIMIT 0,
20
[Debug 11:35:48.458] Executed in 0ms SELECT
CoreArtists.ArtistID,CoreArtists.Name,CoreArtists.MusicBrainzID,
CoreCache.ItemID FROM CoreArtists
                        INNER JOIN CoreCache 
                            ON CoreArtists.ArtistID = CoreCache.ItemID
                        WHERE
                            CoreCache.ModelID = 5   LIMIT 0, 40
[Debug 11:35:48.460] Executed in 0ms SELECT
CoreAlbums.AlbumID,CoreAlbums.ArtistID,CoreAlbums.MusicBrainzID,CoreAlbums.ReleaseDate,CoreAlbums.IsCompilation,CoreAlbums.Title,CoreAlbums.ArtistName,
CoreCache.ItemID FROM CoreAlbums
                        INNER JOIN CoreCache 
                            ON CoreAlbums.AlbumID = CoreCache.ItemID
                        WHERE
                            CoreCache.ModelID = 7   LIMIT 0, 40
[Debug 11:35:48.563] Exception executing command: DELETE FROM
CoreSmartPlaylistEntries WHERE SmartPlaylistID = 4;
                  INSERT INTO CoreSmartPlaylistEntries 
                    SELECT NULL, 4 as SmartPlaylistID, TrackId FROM
CoreTracks,CoreAlbums,CoreArtists
                        WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND
CoreAlbums.AlbumID = CoreTracks.AlbumID AND CoreTracks.PrimarySourceID = 1
                        AND (((CoreTracks.PlayCount = 0 AND
CoreTracks.PlayCount IS NOT NULL) And (CoreTracks.SkipCount = 0 AND
CoreTracks.SkipCount IS NOT NULL)))  

Unhandled Exception: Mono.Data.SqliteClient.SqliteExecutionException: SQL
logic error or missing database
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt,
System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName)
[0x00000] 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt)
[0x00000] 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior
behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery () [0x00000] 
  at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute
(Hyena.Data.Sqlite.HyenaSqliteConnection hconnection,
Mono.Data.SqliteClient.SqliteConnection connection) [0x00000] 
[Debug 11:35:48.567] Player state change: Loading -> Loaded


-- 
View this message in context: http://www.nabble.com/Banshee-crashes-with-%22An-unhandled-exception-was-thrown%3A-SQL-logic-error-or-missing-database%22-tp20663833p22657632.html
Sent from the Banshee mailing list archive at Nabble.com.