OK, I've confirmed that this same case exists for 7.0.1 (squeezecenter -
7.0.1-0.1.19177) and SBC jive_7.0.1_r2287.bin.
The MySQL slow query log says:
Code:
--------------------
# Time: 080426 16:51:08
# [EMAIL PROTECTED]: [slimserver] @ localhost [127.0.0.1]
# Query_time: 52 Lock_time: 0 Rows_sent: 1 Rows_examined: 6891039
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 16:52:01
# [EMAIL PROTECTED]: [slimserver] @ localhost [127.0.0.1]
# Query_time: 53 Lock_time: 0 Rows_sent: 43 Rows_examined: 6891125
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;
--------------------
..so, tardy results from MySQL queries seem to be breaking the
connection between the SBC and SC in both 7.0.1 and 7.1. Presumably,
some timeout value in the SBC code gets exceeded and the SBC gives up,
but not very gracefully.
I've opened bug 7992: http://bugs.slimdevices.com/show_bug.cgi?id=7992
I've included instructions on how to turn on slow query logging in that
bug report.
--
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
