This is a problem I've been seeing consistently for the past week.
I've updated the SBC to jive_7.1_r2360.bin via the sd card and I'm
running SC7.1 trunk svn at revision 19185.
When I go to browse a genre on the SBC: Music Library->Genres->German
Baroque (or any other genre with lots of artists and albums) I'll get
the spinning ">" symbol but nothing else happens until the SBC reports
that it's trying to connect to the music source and then reports that
there is a problem connecting to it. The "try again" fails and if I
then go to the home screen, the wifi icon has turned blue. At this
point, I need to hard-restart the SBC to get connected to the SC
again.
In every other respect, the SBC seems to be working just fine. If I
have an actively playing playlist on my transporter, the SBC shows the
correct information, can pause, restart play, adjust volume, etc.
But attempting to browse by genre will reliably kill the SBC's
connection.
I'm not seeing anything in the SC's server log.
The MySQL slow query log does show:
Code:
--------------------
# Time: 080426 9:58:19
# [EMAIL PROTECTED]: squeezecenter[squeezecenter] @ localhost [127.0.0.1]
# Query_time: 37 Lock_time: 0 Rows_sent: 1 Rows_examined: 4801573
SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN
contributor_track contributorTracks ON ( contributorTracks.contributor = me.id
) JOIN tracks track ON ( track.id = contributorTracks.track ) LEFT JOIN
genre_track genreTracks ON ( genreTracks.track = track.id ) LEFT JOIN
contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id
) WHERE ( ( ( genreTracks.genre = '7' ) AND ( contributorAlbums.role IN ( '1',
'5' ) ) ) );
# Time: 080426 9:58:57
# [EMAIL PROTECTED]: squeezecenter[squeezecenter] @ localhost [127.0.0.1]
# Query_time: 38 Lock_time: 0 Rows_sent: 43 Rows_examined: 4801659
SELECT me.id, me.name, me.namesort, me.musicmagic_mixable, me.namesearch,
me.musicbrainz_id FROM contributors me LEFT JOIN contributor_track
contributorTracks ON ( contributorTracks.contributor = me.id ) JOIN tracks
track ON ( track.id = contributorTracks.track ) LEFT JOIN genre_track
genreTracks ON ( genreTracks.track = track.id ) LEFT JOIN contributor_album
contributorAlbums ON ( contributorAlbums.contributor = me.id ) WHERE ( ( (
genreTracks.genre = '7' ) AND ( contributorAlbums.role IN ( '1', '5' ) ) ) )
GROUP BY me.id ORDER BY me.namesort LIMIT 43;
--------------------
Notice that MySQL just had to look through 4.8 MILLION rows TWICE
(!!!!) and took 37 and 38 seconds, respectivly to do so. Also, those
look like absurd querys just to enumerate and return the artists
present in a genre.
Is the SBC dropping the connection because of a timeout caused by these
slow queries?
My library, as reported by Settings->Status is:
Code:
--------------------
Total Tracks: 38,996
Total Albums: 2,069
Total Artists: 807
Total Genres: 36
Total Playing Time: 2795:55:35
--------------------
If this happens while music is playing, the music stops at least a
couple of times while the SBC is attempting the connection. A "ps ax"
shows the flac to flac transcoding process still present, but SC seems
to be otherwise occupied so the playback hangs.
Is there anything I should try in order to further diagnose and debug
this problem?
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=46850
_______________________________________________
jive mailing list
[email protected]
http://lists.slimdevices.com/cgi-bin/mailman/listinfo/jive
