Public bug reported:

Two days ago, I made some small changes to my music library in Banshee,
removing some songs, adding others, etc. But not on a large scale.

Anyways, since then I have the problem that after every song (I'm
playing a playlist, in shuffle mode) Banshee freezes for several
seconds, the window graying out after a few of them, until playback
resumes normally with the next song. The same upon initially starting
playback and when skipping ahead to the next song.

I activated --debug and got the following output when Banshee freezes:

[5 Warn  18:24:58.416] Executed in 18321ms 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.TitleSort,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.SampleRate,CoreTracks.BitsPerSample,CoreTracks.Score,CoreTracks.PlayCount,CoreTracks.SkipCount,CoreTracks.ExternalID,CoreTracks.LastPlayedStamp,CoreTracks.LastSkippedStamp,CoreTracks.DateAddedStamp,CoreTracks.DateUpdatedStamp,CoreTracks.Uri,CoreArtists.Name,CoreArtists.NameSort,CoreAlbums.Title,CoreAlbums.TitleSort,CoreAlbums.ArtistName,CoreAlbums.ArtistNameSort,CoreAlbums.IsCompilation,CoreAlbums.MusicBrainzID,CoreArtists.MusicBrainzID
 , OrderID, CoreCache.ItemID  FROM CoreTracks,CoreArtists,CoreAlbums
                        INNER JOIN CorePlaylistEntries
                            ON CoreTracks.TrackID = CorePlaylistEntries.TrackID
                        INNER JOIN CoreCache
                            ON CorePlaylistEntries.EntryID = CoreCache.ItemID 
                        WHERE
                            CoreCache.ModelID = 131 AND CoreArtists.ArtistID = 
CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID 
                        AND 1=1
                        AND LastStreamError = 0
                        AND (LastPlayedStamp < 1410024153 OR LastPlayedStamp IS 
NULL)
                        AND (LastSkippedStamp < 1410024153 OR LastSkippedStamp 
IS NULL)
                        ORDER BY RANDOM () LIMIT 1

So, apparently, there is a really slow SQL query executed for finding
out the next song. What I don't understand, though, is why this problem
suddenly occurred, since I only added a few songs to that playlist –
also, there are now only 365 songs in that list, so really nothing that
should lead to such lags.

Ubuntu version: Ubuntu 14.04.1 LTS
Package version banshee: 2.9.0+really2.6.2-2ubuntu2.1

** Affects: banshee (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1366357

Title:
  Banshee freezes shortly (about 5–10s) between songs

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/banshee/+bug/1366357/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to