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 625617 - banshee hangs because of long sql queries
banshee hangs because of long sql queries
Status: RESOLVED DUPLICATE of bug 625783
Product: banshee
Classification: Other
Component: Smart Playlists
1.7.3
Other Linux
: Normal normal
: 1.x
Assigned To: Banshee Maintainers
Banshee Maintainers
Depends on:
Blocks:
 
 
Reported: 2010-07-29 20:43 UTC by Krzysztof Krzyżaniak
Modified: 2010-08-04 19:54 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
debug log (194.59 KB, text/plain)
2010-07-29 21:27 UTC, Krzysztof Krzyżaniak
Details

Description Krzysztof Krzyżaniak 2010-07-29 20:43:37 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
Comment 1 Krzysztof Krzyżaniak 2010-07-29 21:27:47 UTC
Created attachment 166801 [details]
debug log

debug log from banshee --debug --debug-sql
Comment 2 Bertrand Lorentz 2010-08-04 17:12:31 UTC
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.
Comment 3 Krzysztof Krzyżaniak 2010-08-04 17:40:43 UTC
connected to sqlite 3.7.0 issue

*** This bug has been marked as a duplicate of bug 625783 ***
Comment 4 Krzysztof Krzyżaniak 2010-08-04 19:50:36 UTC
actually either downgrading to 3.6.23.1 or upgrading to 3.7.0.1 doesn't help
Comment 5 Krzysztof Krzyżaniak 2010-08-04 19:54:53 UTC
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 ***