Re: [Banshee-List] Major performance issue

["Andrés G. Aragoneses" <knocte gmail com>]

El 24/05/10 15:55, David Nielsen escribió:
> I'm seeing a rather major performance issue with Banshee currently. With
> the library watcher enabled as well as full metadata writeback to files
> and move on change (probably my single favorite Banshee feature since
> this allows me to have every thing with the right metadata in the right
> place, many kudos for that one people) I can have the interface block
> for literally hours when I update a few items. I left it overnight just
> to see if it would recover and to my surprise it was unblocked when I
> woke up. However that quickly changed when I did another library change
> (In this case correcting the metadata for the Thud! audiobook).
> 
> This debug output is near endless repetition of something like this:
> 
> [1 Warn  15:46:45.623] HyenaSqliteConnection command issued from the
> main thread
> [2 Debug 15:46:46.026] Executed in 403ms 
>                 SELECT CoreTracks.TrackID, CoreArtists.Name,
> CoreTracks.Title, CoreTracks.Uri
>                     FROM CoreTracks, CoreArtists
>                     WHERE
>                         CoreTracks.PrimarySourceID = 1 AND
>                         CoreTracks.ArtistID = CoreArtists.ArtistID AND
>                         CoreTracks.TrackID NOT IN (
>                             SELECT TrackID from LyricsDownloads)
> [13 Debug 15:46:47.021] Error: ConnectFailure (Connection refused),
> http://api.leoslyrics.com/api_search.php?auth=duane&artist=Terry_Pratchett&songtitle=Cd4
> <http://api.leoslyrics.com/api_search.php?auth=duane&artist=Terry_Pratchett&songtitle=Cd4>
> [13 Debug 15:46:47.861] The remote server returned an error: (404) Not
> Found., http://www.lyriki.com/Terry_Pratchett:cd4
> [2 Debug 15:46:48.063] Executed in 2036ms 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.Arti
stNameSort,CoreAlbums.IsCompilation
> FROM CoreTracks,CoreArtists,CoreAlbums WHERE CoreArtists.ArtistID =
> CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND
> CoreTracks.Uri =
> 'file:///home/david/Musik/Terry%20Pratchett/Book%2034%20-%20Thud/05Thud.mp3'
> LIMIT 1
> [2 Debug 15:46:48.065] Executed in 1ms INSERT INTO AnonymousUsageData
> (MetricName,Stamp,Value) VALUES
> ('Banshee/LongSqliteCommand',1274712405,'2011ms -- 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.Arti
stNameSort,CoreAlbums.IsCompilation
> FROM CoreTracks,CoreArtists,CoreAlbums WHERE CoreArtists.ArtistID =
> CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND
> CoreTracks.Uri = ? LIMIT 1')
> [1 Warn  15:46:48.071] HyenaSqliteConnection command issued from the
> main thread
> [13 Debug 15:46:49.923] The remote server returned an error: (404) Not
> Found., http://lyricwiki.org/Terry_Pratchett:cd4
> [2 Debug 15:46:50.106] Executed in 2040ms 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.Arti
stNameSort,CoreAlbums.IsCompilation
> FROM CoreTracks,CoreArtists,CoreAlbums WHERE CoreArtists.ArtistID =
> CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND
> CoreTracks.Uri =
> 'file:///home/david/Musik/Terry%20Pratchett/Book%2034%20-%20Thud/05Thud.mp3'
> LIMIT 1
> [2 Debug 15:46:50.109] Executed in 1ms INSERT INTO AnonymousUsageData
> (MetricName,Stamp,Value) VALUES
> ('Banshee/LongSqliteCommand',1274712408,'2051ms -- 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.Arti
stNameSort,CoreAlbums.IsCompilation
> FROM CoreTracks,CoreArtists,CoreAlbums WHERE CoreArtists.ArtistID =
> CoreTracks.ArtistID AND CoreAlbums.AlbumID = CoreTracks.AlbumID AND
> CoreTracks.Uri = ? LIMIT 1')
> [1 Warn  15:46:50.109] HyenaSqliteConnection command issued from the
> main thread
> 
> Now my question is where do I start tracking this down, I would love to
> be helpful here since it renders Banshee pretty defunct. I'd also love
> to learn how to track these down to create better bug reports (and
> hopefulyl patches) in the future.
> 
> (x86_64, da_DK.UTF-8, Ubuntu 10.04 + the stable Banshee PPA is used in
> this case though the problem should be reproducable on git tip as well).


The log only shows 15 seconds of operation. Can you send the one that
has the big gap in it?

	Andrés

--