Re: [Banshee-List] Banshee crashes with "An unhandled exception was thrown: SQL logic error or missing database"
- From: OliverH <oliverhorn gmx net>
- To: Banshee-list gnome org
- Subject: Re: [Banshee-List] Banshee crashes with "An unhandled exception was thrown: SQL logic error or missing database"
- Date: Mon, 23 Mar 2009 03:41:20 -0700 (PDT)
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.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]