GNOME Bugzilla – Bug 625617
banshee hangs because of long sql queries
Last modified: 2010-08-04 19:54:53 UTC
after upgrade from 1.7.1 to 1.7.3 (package from Debian experimental) banshee just hangs showing empty window with window manager decorations. After half of hour (give or take) rest of interface shows. Running with --debug-sql gives me unusual long time for some queries for example: [2 Debug 22:30:24.241] Executed in 346950ms DELETE FROM CoreCache WHERE ModelID = 31; INSERT INTO CoreCache (ModelID, ItemID) SELECT 31, CoreArtists.ArtistID FROM CoreArtists WHERE CoreArtists.ArtistID IN (SELECT CoreTracks.ArtistID FROM CoreTracks, CoreCache WHERE CoreCache.ModelID = 37 AND CoreCache.ItemID = CoreTracks.TrackID ) ORDER BY NameSortKey [2 Debug 22:36:12.771] Executed in 348510ms DELETE FROM CoreCache WHERE ModelID = 33; INSERT INTO CoreCache (ModelID, ItemID) SELECT 33, CoreAlbums.AlbumID FROM CoreAlbums WHERE CoreAlbums.AlbumID IN (SELECT CoreTracks.AlbumID FROM CoreTracks, CoreCache WHERE CoreCache.ModelID = 37 AND CoreCache.ItemId = CoreTracks.TrackID ) ORDER BY CoreAlbums.TitleSortKey, CoreAlbums.ArtistNameSortKey I'll include full log ASAP
Created attachment 166801 [details] debug log debug log from banshee --debug --debug-sql
Which version of sqlite3 do you have on your system ? If it's 3.7.0, then this is a duplicate of bug #625783, which is in fact a bug in sqlite itself. Downgrading to sqlite 3.6.23 should workaround the issue.
connected to sqlite 3.7.0 issue *** This bug has been marked as a duplicate of bug 625783 ***
actually either downgrading to 3.6.23.1 or upgrading to 3.7.0.1 doesn't help
downgrading to 3.6.23.1 with reboot is helping. upgrading to 3.7.0.1 even with reboot is not helping. *** This bug has been marked as a duplicate of bug 625783 ***