Bug 576836 – Banshee crashes right after start (SQL logic error or missing database)

After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.

Bug 576836 - Banshee crashes right after start (SQL logic error or missing database)


Summary:	Banshee crashes right after start (SQL logic error or missing database)


Status:	RESOLVED DUPLICATE of bug 547218

Product:	banshee
Classification:	Other
Component:	general
Version:	1.4.3
Hardware:	Other Linux

Importance:	Normal critical
Target Milestone:	1.x
Assigned To:	Banshee Maintainers
QA Contact:	Banshee Maintainers

URL:
Whiteboard:

Depends on:
Blocks:

Reported:	2009-03-26 10:11 UTC by Matthias Brennwald
Modified:	2009-03-26 19:03 UTC

See Also:
GNOME target:	---
GNOME version:	---

Description Matthias Brennwald 2009-03-26 10:11:32 UTC

Banshee crashes right after starting. A message windows appears, saying an "Exception has been thrown by the target of an invocation". This is with Banshee 1.4.3 on Ubuntu 8.10 or 9.04 running on an Apple PowerBook G4. I haven't tried on other versions of Ubuntu or other computer platforms.

I've read reports of similar issues that could be resolved by deleting the banshee stuff in ~/.config and ~/.cache. I've tried these fixes without success. I also tried to add a new user to my system and to run Banshee from this virgin user account. The problem persisted.

I also ran Banshee from the terminal with the --debug-sql option. Here's the output:

---------------------------------
[Info  10:51:23.306] Running Banshee 1.4.3: [Ubuntu jaunty (development branch) (linux-gnu, powerpc) @ 2009-03-22 18:34:40 UTC]
[Debug 10:51:26.253] Bus.Session.RequestName ('org.bansheeproject.Banshee') replied with PrimaryOwner
[Debug 10:51:26.270] Core service started (DBusServiceManager, 0.00529s)
[Debug 10:51:26.277] Registering remote object /org/bansheeproject/Banshee/DBusCommandService (Banshee.ServiceStack.DBusCommandService) on org.bansheeproject.Banshee
[Debug 10:51:26.301] Core service started (DBusCommandService, 0.028896s)
[Debug 10:51:26.406] Opened SQLite connection to /home/mbrennwa/.config/banshee-1/banshee.db
[Debug 10:51:26.407] Core service started (DbConnection, 0.105609s)
[Debug 10:51:26.412] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreConfiguration'
[Debug 10:51:26.412] Executed in 1ms SELECT Value FROM CoreConfiguration WHERE Key = 'DatabaseVersion'
[Debug 10:51:26.422] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreConfiguration'
[Debug 10:51:26.423] Executed in 0ms SELECT Value FROM CoreConfiguration WHERE Key = 'DatabaseVersion'
[Debug 10:51:26.423] Database version 22 is up to date
[Debug 10:51:26.424] Executed in 0ms SELECT Value FROM CoreConfiguration WHERE Key = 'MetadataVersion'
[Debug 10:51:26.424] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreConfiguration'
[Debug 10:51:26.427] Executed in 0ms SELECT Value FROM CoreConfiguration WHERE Key = 'DatabaseVersion'
[Debug 10:51:26.456] Core service started (PreferenceService, 0.027425s)
[Debug 10:51:26.462] Registering remote object /org/bansheeproject/Banshee/SourceManager (Banshee.Sources.SourceManager) on org.bansheeproject.Banshee
[Debug 10:51:26.463] Core service started (SourceManager, 0.006038s)
[Debug 10:51:26.822] Core service started (MediaProfileManager, 0.359281s)
[Debug 10:51:26.826] Registering remote object /org/bansheeproject/Banshee/PlayerEngine (Banshee.MediaEngine.PlayerEngineService) on org.bansheeproject.Banshee
[Debug 10:51:26.829] Core service started (PlayerEngine, 0.006219s)
[Debug 10:51:26.847] Configuration client extension loaded (Banshee.GnomeBackend.GConfConfigurationClient)
[Debug 10:51:26.957] IO provider extension loaded (Banshee.IO.Unix.Provider)
[Debug 10:51:26.972] Core service started (TranscoderService, 0.022311s)
[Debug 10:51:26.977] Registering remote object /org/bansheeproject/Banshee/PlaybackController (Banshee.PlaybackController.PlaybackControllerService) on org.bansheeproject.Banshee
[Debug 10:51:26.979] Core service started (PlaybackController, 0.005451s)
[Debug 10:51:26.980] Core service started (ImportSourceManager, 0.001266s)
[Debug 10:51:26.995] Core service started (LibraryImportManager, 0.014357s)
[Debug 10:51:26.997] Core service started (UserJobManager, 0.001287s)
[Debug 10:51:27.036] Core service started (HardwareManager, 0.038476s)
[Debug 10:51:27.048] Bus.Session.RequestName ('org.bansheeproject.CollectionIndexer') replied with PrimaryOwner
[Debug 10:51:27.052] Registering remote object /org/bansheeproject/Banshee/CollectionIndexerService (Banshee.Collection.Indexer.CollectionIndexerService) on org.bansheeproject.CollectionIndexer
[Debug 10:51:27.054] Core service started (CollectionIndexerService, 0.016817s)
[Debug 10:51:27.108] Adding icon theme search path: /usr/share/banshee-1/icons
[Debug 10:51:27.110] Core service started (GtkElementsService, 0.056004s)
[Debug 10:51:27.227] Core service started (InterfaceActionService, 0.117128s)
[Debug 10:51:27.232] Album artwork path set to /home/mbrennwa/.cache/album-art
[Debug 10:51:27.232] Core service started (ArtworkManager, 0.004289s)
[Debug 10:51:28.493] Registering remote object /org/bansheeproject/Banshee/ClientWindow (Nereid.PlayerInterface) on org.bansheeproject.Banshee
[Debug 10:51:28.494] Core service started (NereidPlayerInterface, 1.261338s)
[Debug 10:51:28.505] Using GNOME 2.22 API for Multimedia Keys
[Debug 10:51:28.507] Extension service started (MultimediaKeysService, 0.011092s)
[Debug 10:51:28.512] Extension service started (DaapService, 0.003764s)
[Debug 10:51:28.513] Extension service started (DapService, 0.000965s)
[Debug 10:51:28.518] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='Bookmarks'
[Debug 10:51:28.540] Executed in 1ms SELECT BookmarkID, TrackID, Position, CreatedAt FROM Bookmarks
[Debug 10:51:28.542] Extension service started (BookmarksService, 0.02894s)
[Debug 10:51:28.726] GStreamer pipeline does not run: audioconvert ! lame mode=4 bitrate=128 ! id3v2mux
[Debug 10:51:28.731] GStreamer pipeline does not run: audioconvert ! xingenc bitrate=128 ! id3v2mux
[Debug 10:51:28.873] GStreamer pipeline does not run: audioconvert ! fluwmaenc bitrate=64000 vbr=false ! fluasfmux
[Debug 10:51:28.875] Extension service started (GStreamerCoreService, 0.331814s)
[Debug 10:51:28.940] Player state change: NotReady -> Ready
[Debug 10:51:28.964] Player state change: Ready -> Idle
[Debug 10:51:29.085] (libbanshee:player) Disabled ReplayGain
[Debug 10:51:29.112] Extension service started (GnomeService, 0.025882s)
[Debug 10:51:29.265] Extension service started (AudioCdService, 0.126531s)
[Debug 10:51:29.270] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoverArtDownloads'
[Debug 10:51:29.271] Extension service started (CoverArtService, 0.005143s)
[Debug 10:51:29.433] Extension service started (NotificationAreaService, 0.162074s)
[Debug 10:51:29.531] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='HyenaModelVersions'
[Debug 10:51:29.533] Executed in 0ms SELECT version FROM HyenaModelVersions WHERE name='PodcastSyndications'
[Debug 10:51:29.536] Executed in 1ms SELECT version FROM HyenaModelVersions WHERE name='hyena_database_master'
[Debug 10:51:29.540] Executed in 1ms SELECT sql FROM sqlite_master WHERE Name='PodcastSyndications'
[Debug 10:51:29.550] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='HyenaModelVersions'
[Debug 10:51:29.552] Executed in 0ms SELECT version FROM HyenaModelVersions WHERE name='PodcastItems'
[Debug 10:51:29.553] Executed in 0ms SELECT version FROM HyenaModelVersions WHERE name='hyena_database_master'
[Debug 10:51:29.555] Executed in 0ms SELECT sql FROM sqlite_master WHERE Name='PodcastItems'
[Debug 10:51:29.557] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='index' AND Name='PodcastItemsFeedIDIndex'
[Debug 10:51:29.558] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='index' AND Name='PodcastItemsGuidIndex'
[Debug 10:51:29.558] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='index' AND Name='PodcastItemIsReadIndex'
[Debug 10:51:29.569] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='HyenaModelVersions'
[Debug 10:51:29.571] Executed in 1ms SELECT version FROM HyenaModelVersions WHERE name='PodcastEnclosures'
[Debug 10:51:29.571] Executed in 1ms SELECT version FROM HyenaModelVersions WHERE name='hyena_database_master'
[Debug 10:51:29.574] Executed in 1ms SELECT sql FROM sqlite_master WHERE Name='PodcastEnclosures'
[Debug 10:51:29.574] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='index' AND Name='PodcastEnclosuresItemIDIndex'
[Debug 10:51:29.620] Executed in 1ms SELECT Value FROM CoreConfiguration WHERE Key='CoreTracks.ModelVersion'
[Debug 10:51:29.622] Executed in 1ms SELECT Value FROM CoreConfiguration WHERE Key='Database.Version'
[Debug 10:51:29.624] Executed in 0ms SELECT sql FROM sqlite_master WHERE Name='CoreTracks'
[Debug 10:51:29.635] Executed in 0ms SELECT PrimarySourceID FROM CorePrimarySources WHERE StringID = 'PodcastSource-PodcastLibrary'
[Debug 10:51:29.637] Executed in 1ms SELECT CachedCount FROM CorePrimarySources WHERE PrimarySourceID = 2
[Debug 10:51:29.653] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:29.654] Executed in 1ms SELECT COUNT(*) FROM sqlite_temp_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:29.655] Executed in 1ms 
                    CREATE TEMP TABLE CoreCache (
                        OrderID INTEGER PRIMARY KEY,
                        ModelID INTEGER,
                        ItemID INTEGER)
[Debug 10:51:29.656] Executed in 1ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCacheModels'
[Debug 10:51:29.658] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'PodcastFeeds-PodcastSource-PodcastLibrary-Feed'
[Debug 10:51:29.659] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'PodcastFeeds-PodcastSource-PodcastLibrary-Feed-Selection'
[Debug 10:51:29.680] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:29.681] Executed in 0ms SELECT COUNT(*) FROM sqlite_temp_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:29.682] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCacheModels'
[Debug 10:51:29.684] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'PodcastSource-PodcastLibrary-DatabaseTrackInfo'
[Debug 10:51:29.685] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'PodcastSource-PodcastLibrary-DatabaseTrackInfo-Selection'
[Debug 10:51:29.696] Executed in 0ms 
                    BEGIN TRANSACTION;
                        DELETE FROM CorePlaylistEntries WHERE PlaylistID IN (SELECT PlaylistID FROM CorePlaylists WHERE IsTemporary = 1);
                        DELETE FROM CorePlaylists WHERE IsTemporary = 1;
                    COMMIT TRANSACTION
[Debug 10:51:29.697] Executed in 1ms SELECT PlaylistID, Name, SortColumn, SortType, PrimarySourceID, CachedCount, IsTemporary FROM CorePlaylists 
                    WHERE Special = 0 AND PrimarySourceID = 2
[Debug 10:51:29.703] Executed in 1ms SELECT Value FROM CoreConfiguration WHERE Key = 'SmartPlaylistVersion'
[Debug 10:51:29.708] Exception executing command: BEGIN
[Debug 10:51:29.710] Executed in 0ms ROLLBACK
[Error 10:51:29.711] Unable to Migrate Smart Playlists - Please file a bug with this error: 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 10:51:29.715] Executed in 0ms 
                    BEGIN TRANSACTION;
                        DELETE FROM CoreSmartPlaylistEntries WHERE SmartPlaylistID IN (SELECT SmartPlaylistID FROM CoreSmartPlaylists WHERE IsTemporary = 1);
                        DELETE FROM CoreSmartPlaylists WHERE IsTemporary = 1;
                    COMMIT TRANSACTION
[Debug 10:51:29.716] Executed in 1ms SELECT SmartPlaylistID, Name, Condition, OrderBy, LimitNumber, LimitCriterion, PrimarySourceID, CachedCount, IsTemporary
                    FROM CoreSmartPlaylists WHERE PrimarySourceID = 2
[Debug 10:51:29.717] Executed in 0ms SELECT Value FROM CoreConfiguration WHERE Key='HaveCreatedSmartPlaylists.PodcastSource-PodcastLibrary'
[Debug 10:51:29.859] Extension service started (PodcastService, 0.425032s)
[Debug 10:51:29.910] Extension service started (LastfmRecommendationService, 0.050206s)
[Debug 10:51:29.946] Core service started (Network, 0.010686s)
[Debug 10:51:29.948] Audioscrobbler state: connected
[Debug 10:51:29.953] Extension service started (AudioscrobblerService, 0.041638s)
[Info  10:51:29.955] All services are started 3.698584s
[Debug 10:51:29.971] Executed in 0ms SELECT Value FROM CoreConfiguration WHERE Key='CoreArtists.ModelVersion'
[Debug 10:51:29.973] Executed in 0ms SELECT EntryID FROM CoreConfiguration WHERE Key='CoreArtists.ModelVersion'
[Debug 10:51:29.974] Executed in 0ms INSERT INTO CoreConfiguration VALUES (NULL, 'CoreArtists.ModelVersion', '1')
[Debug 10:51:29.975] Executed in 0ms SELECT Value FROM CoreConfiguration WHERE Key='Database.Version'
[Debug 10:51:29.977] Executed in 0ms SELECT sql FROM sqlite_master WHERE Name='CoreArtists'
[Debug 10:51:29.991] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:29.992] Executed in 1ms SELECT COUNT(*) FROM sqlite_temp_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:29.993] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCacheModels'
[Debug 10:51:29.995] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'MusicLibrarySource-Library-DatabaseArtistInfo'
[Debug 10:51:29.995] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('MusicLibrarySource-Library-DatabaseArtistInfo')
[Debug 10:51:29.996] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'MusicLibrarySource-Library-DatabaseArtistInfo-Selection'
[Debug 10:51:29.996] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('MusicLibrarySource-Library-DatabaseArtistInfo-Selection')
[Debug 10:51:30.012] Executed in 0ms SELECT Value FROM CoreConfiguration WHERE Key='CoreAlbums.ModelVersion'
[Debug 10:51:30.014] Executed in 0ms SELECT EntryID FROM CoreConfiguration WHERE Key='CoreAlbums.ModelVersion'
[Debug 10:51:30.015] Executed in 0ms INSERT INTO CoreConfiguration VALUES (NULL, 'CoreAlbums.ModelVersion', '1')
[Debug 10:51:30.015] Executed in 1ms SELECT Value FROM CoreConfiguration WHERE Key='Database.Version'
[Debug 10:51:30.018] Executed in 1ms SELECT sql FROM sqlite_master WHERE Name='CoreAlbums'
[Debug 10:51:30.032] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:30.033] Executed in 0ms SELECT COUNT(*) FROM sqlite_temp_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:30.034] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCacheModels'
[Debug 10:51:30.035] Executed in 1ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'MusicLibrarySource-Library-DatabaseAlbumInfo'
[Debug 10:51:30.036] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('MusicLibrarySource-Library-DatabaseAlbumInfo')
[Debug 10:51:30.037] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'MusicLibrarySource-Library-DatabaseAlbumInfo-Selection'
[Debug 10:51:30.037] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('MusicLibrarySource-Library-DatabaseAlbumInfo-Selection')
[Debug 10:51:30.055] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:30.056] Executed in 0ms SELECT COUNT(*) FROM sqlite_temp_master WHERE Type='table' AND Name='CoreCache'
[Debug 10:51:30.057] Executed in 0ms SELECT COUNT(*) FROM sqlite_master WHERE Type='table' AND Name='CoreCacheModels'
[Debug 10:51:30.059] Executed in 1ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'MusicLibrarySource-Library-genre-QueryFilterInfo`1'
[Debug 10:51:30.059] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('MusicLibrarySource-Library-genre-QueryFilterInfo`1')
[Debug 10:51:30.060] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'MusicLibrarySource-Library-genre-QueryFilterInfo`1-Selection'
[Debug 10:51:30.060] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('MusicLibrarySource-Library-genre-QueryFilterInfo`1-Selection')
[Debug 10:51:30.062] Executed in 0ms SELECT PrimarySourceID FROM CorePrimarySources WHERE StringID = 'MusicLibrarySource-Library'
[Debug 10:51:30.062] Executed in 0ms SELECT CachedCount FROM CorePrimarySources WHERE PrimarySourceID = 1
[Debug 10:51:30.063] Executed in 0ms SELECT PlaylistID, Name, SortColumn, SortType, PrimarySourceID, CachedCount, IsTemporary FROM CorePlaylists 
                    WHERE Special = 0 AND PrimarySourceID = 1
[Debug 10:51:30.065] Executed in 0ms SELECT SmartPlaylistID, Name, Condition, OrderBy, LimitNumber, LimitCriterion, PrimarySourceID, CachedCount, IsTemporary
                    FROM CoreSmartPlaylists WHERE PrimarySourceID = 1
[Debug 10:51:30.067] Executed in 1ms SELECT Value FROM CoreConfiguration WHERE Key='HaveCreatedSmartPlaylists.MusicLibrarySource-Library'
[Debug 10:51:30.158] Executed in 0ms 
                INSERT INTO CoreSmartPlaylists
                    (Name, Condition, OrderBy, LimitNumber, LimitCriterion, PrimarySourceID, IsTemporary)
                    VALUES ('Favorites', '<request><query banshee-version="1"><greaterThanEquals><field name="rating" /><int>4</int></greaterThanEquals></query></request>', NULL, NULL, NULL, 1, 0)
[Debug 10:51:30.161] Executed in 1ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'SmartPlaylistSource-1-DatabaseArtistInfo'
[Debug 10:51:30.162] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('SmartPlaylistSource-1-DatabaseArtistInfo')
[Debug 10:51:30.163] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'SmartPlaylistSource-1-DatabaseArtistInfo-Selection'
[Debug 10:51:30.163] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('SmartPlaylistSource-1-DatabaseArtistInfo-Selection')
[Debug 10:51:30.164] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'SmartPlaylistSource-1-DatabaseAlbumInfo'
[Debug 10:51:30.164] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('SmartPlaylistSource-1-DatabaseAlbumInfo')
[Debug 10:51:30.165] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'SmartPlaylistSource-1-DatabaseAlbumInfo-Selection'
[Debug 10:51:30.165] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('SmartPlaylistSource-1-DatabaseAlbumInfo-Selection')
[Debug 10:51:30.166] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'SmartPlaylistSource-1-genre-QueryFilterInfo`1'
[Debug 10:51:30.167] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('SmartPlaylistSource-1-genre-QueryFilterInfo`1')
[Debug 10:51:30.167] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'SmartPlaylistSource-1-genre-QueryFilterInfo`1-Selection'
[Debug 10:51:30.168] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('SmartPlaylistSource-1-genre-QueryFilterInfo`1-Selection')
[Debug 10:51:30.171] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'SmartPlaylistSource-1-DatabaseTrackInfo'
[Debug 10:51:30.172] Executed in 1ms INSERT INTO CoreCacheModels (ModelID) VALUES ('SmartPlaylistSource-1-DatabaseTrackInfo')
[Debug 10:51:30.173] Executed in 0ms SELECT CacheID FROM CoreCacheModels WHERE ModelID = 'SmartPlaylistSource-1-DatabaseTrackInfo-Selection'
[Debug 10:51:30.174] Executed in 0ms INSERT INTO CoreCacheModels (ModelID) VALUES ('SmartPlaylistSource-1-DatabaseTrackInfo-Selection')
[Debug 10:51:30.182] Executed in 1ms DELETE FROM CoreSmartPlaylistEntries WHERE SmartPlaylistID = 1;
                  INSERT INTO CoreSmartPlaylistEntries 
                    SELECT NULL, 1 as SmartPlaylistID, TrackId FROM CoreTracks,CoreAlbums,CoreArtists
                        WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND CoreTracks.PrimarySourceID = 1
                        AND ((CoreTracks.Rating >= 4 AND CoreTracks.Rating IS NOT NULL))  
[Debug 10:51:30.188] Executed in 0ms SELECT COUNT(*), SUM(CoreTracks.FileSize) FROM CoreTracks,CoreAlbums,CoreArtists, CoreSmartPlaylistEntries WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID  AND  CoreSmartPlaylistEntries.TrackID = CoreTracks.TrackID AND CoreSmartPlaylistEntries.SmartPlaylistID = 1 
[Debug 10:51:30.200] Exception executing command: BEGIN; 
                    DELETE FROM CoreCache WHERE ModelID = 17;
                        INSERT INTO CoreCache (ModelID, ItemID) SELECT 17, CoreTracks.TrackID FROM CoreTracks,CoreAlbums,CoreArtists, CoreSmartPlaylistEntries WHERE CoreArtists.ArtistID = CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID  AND  CoreSmartPlaylistEntries.TrackID = CoreTracks.TrackID AND CoreSmartPlaylistEntries.SmartPlaylistID = 1  ORDER BY 
                        CoreArtists.NameLowered ASC, 
                        CoreAlbums.TitleLowered ASC,
                        CoreTracks.Disc ASC,
                        CoreTracks.TrackNumber ASC; COMMIT
Exception has been thrown by the target of an invocation.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> 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] 
  --- End of inner exception stack trace ---
  at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] 
  at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] 
  at System.Reflection.ConstructorInfo.Invoke (System.Object[] parameters) [0x00000] 
  at System.Activator.CreateInstance (System.Type type, Boolean nonPublic) [0x00000] 
  at System.Activator.CreateInstance (System.Type type) [0x00000] 
  at Banshee.Gui.GtkBaseClient.Startup () [0x00000] 
  at Hyena.Gui.CleanRoomStartup.Startup (Hyena.Gui.StartupInvocationHandler startup) [0x00000] 
[Debug 10:51:30.754] Creating Pango.Layout, configuring Cairo.Context
[Debug 10:51:30.759] Creating Pango.Layout, configuring Cairo.Context
[Debug 10:51:30.777] Creating Pango.Layout, configuring Cairo.Context
---------------------------------

Matthias

Comment 1 Bertrand Lorentz 2009-03-26 19:03:06 UTC

Thanks for the bug report. This particular bug has already been reported into our bug tracking system, but please feel free to report any further bugs you find.


*** This bug has been marked as a duplicate of 547218 ***