Following up on myself with some log entries (plugins and sql). Using MySQL. On 11:37 pressed next song on slimserver. Next song starts playing right away, but then pauses for a couple of seconds after about 10 seconds into the song. Let the song play for a minute or so and skipped to the next song. Again hiccup after 10seconds. In the Windows Task Manager I see the mysqld-nt.exe take up the highest CPU (after System Idle) of about 10-40% from the moment I press skip to the end of the break in the song...
2006-01-28 11:37:00.1099 RandomPlay: received command open file:///F:/Maho%20Backup/Music/All%20Music/Music/VA/Harley-Davidson/Harley-Davidson%20Road%20Songs%20Vol.%201%20(Disc%201)%20-%201994/04%20-%20Lynyrd%20Skynyrd%20-%20Call%20Me%20The%20Breeze.mp3 2006-01-28 11:37:00.1106 RandomPlay: No client! 2006-01-28 11:37:00.1111 Backtrace: frame 0: Plugins::RandomPlay::Plugin::commandCallback (/PerlApp/Slim/Control/Command.pm line 1439) frame 1: Slim::Control::Command::executeCallback (/PerlApp/Slim/Player/Source.pm line 1691) frame 2: Slim::Player::Source::openSong (/PerlApp/Slim/Player/Source.pm line 412) frame 3: Slim::Player::Source::playmode (/PerlApp/Slim/Player/Source.pm line 823) frame 4: Slim::Player::Source::jumpto (/PerlApp/Slim/Control/Command.pm line 950) frame 5: Slim::Control::Command::execute (/PerlApp/Slim/Web/HTTP.pm line 674) frame 6: Slim::Web::HTTP::processURL (/PerlApp/Slim/Web/HTTP.pm line 539) frame 7: Slim::Web::HTTP::processHTTP (/PerlApp/Slim/Networking/Select.pm line 111) frame 8: Slim::Networking::Select::select (slimserver.pl line 634) frame 9: main::idle (slimserver.pl line 38) frame 10: PerlSvc::Startup (perlsvc.pl line 1481) frame 11: PerlSvc::_startup (slimserver.pl line 0) frame 12: (eval) (slimserver.pl line 0) 2006-01-28 11:37:00.3561 RandomPlay: received command playlist jump +1 2006-01-28 11:37:00.3570 RandomPlay: while in mode: track, from Squeezebox 2006-01-28 11:37:00.9619 RandomPlay: received command newsong 2006-01-28 11:37:00.9628 RandomPlay: No client! 2006-01-28 11:37:00.9634 Backtrace: frame 0: Plugins::RandomPlay::Plugin::commandCallback (/PerlApp/Slim/Control/Command.pm line 1439) frame 1: Slim::Control::Command::executeCallback (/PerlApp/Slim/Player/Source.pm line 1212) frame 2: Slim::Player::Source::trackStartEvent (/PerlApp/Slim/Networking/Slimproto.pm line 524) frame 3: Slim::Networking::Slimproto::process_slimproto_frame (/PerlApp/Slim/Networking/Slimproto.pm line 244) frame 4: Slim::Networking::Slimproto::client_readable (/PerlApp/Slim/Networking/Select.pm line 111) frame 5: Slim::Networking::Select::select (slimserver.pl line 634) frame 6: main::idle (slimserver.pl line 38) frame 7: PerlSvc::Startup (perlsvc.pl line 1481) frame 8: PerlSvc::_startup (slimserver.pl line 0) frame 9: (eval) (slimserver.pl line 0) 2006-01-28 11:37:01.6219 RandomPlay: received command newsong 2006-01-28 11:37:01.6229 RandomPlay: while in mode: track, from Squeezebox 2006-01-28 11:37:01.6237 RandomPlay: new song detected (1) 2006-01-28 11:37:01.6241 RandomPlay: Stripping off completed track(s) 2006-01-28 11:37:01.6245 RandomPlay: playRandom called with type track 2006-01-28 11:37:01.6249 RandomPlay: 8 songs remaining, songIndex = 1 2006-01-28 11:37:01.6277 Running SQL query: [SELECT DISTINCT genres.id AS id,genres.name AS name,genres.namesort AS namesort,genres.moodlogic_id AS moodlogic_id,genres.moodlogic_mixable AS moodlogic_mixable,genres.musicmagic_mixable AS musicmagic_mixable FROM genres ] 2006-01-28 11:37:01.6882 RandomPlay: Starting random selection of 1 items for type: track 2006-01-28 11:37:01.6908 Start and End node: [default:default] 2006-01-28 11:37:01.6930 Start and End node: [genre:default] 2006-01-28 11:37:01.6939 Field query. Need additional join. start and End node: [genre:genre] 2006-01-28 11:37:01.7010 Running SQL query: [SELECT DISTINCT tracks.id AS id,tracks.multialbumsortkey AS multialbumsortkey,tracks.thumb AS thumb,tracks.age AS age,tracks.remote AS remote,tracks.ct AS ct,tracks.audio AS audio,tracks.titlesort AS titlesort,tracks.album AS album,tracks.tracknum AS tracknum,tracks.url AS url,tracks.tag AS tag,tracks.title AS title,tracks.disc AS disc,tracks.fs AS fs FROM tracks, genre_track, genres WHERE genre_track.track = tracks.id AND genres.id = genre_track.genre AND ( genres.name IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND tracks.audio = ? ) ORDER BY RAND() LIMIT 1] 2006-01-28 11:37:01.7018 Bind arguments: [College Rock, Top 40, Chanson, Christmas, New Wave, Speech, Miscellaneous, Slow Rock, Jazz, Sonata, Post-Grunge, Alternative, New Country, Neo - Soul, Salsa, Comedy, Celtic, Tango, Latin Balad, Cuban, National Folk, AlternRock, Hip-Hop, Rock, Folk-Rock, Electronica, Adult Alternative, Electronic, Teen Pop, Bossa Nova, R&B, Children's, Classic Rock, Indie, Easy Listening, Teen Beat, Hard Rock, Southern Rock, Disco, Rock & Roll, Singer/Songwriter, Proto-Punk, Classical, Big Band, Samba, Psychedelic Rock, Rap, Ska, Folk Revival, Pop/Funk, Instrumental, Kids, Nu Jazz, Funk, Lounge, Latin, Punk, African, Alternative-Rock, CHR, Jazz+Funk, Holiday, Ballad, BritPop, World, Jazz Blues, Contemporary R&B, Tribal, Folk, Calypso, Reggae, Mixed Genres, Vocal, Folk/Rock, Adult Alternative Pop/Rock, Brazilian, Blues-Rock, Hard Rock, Heavy Metal, Synthpop, Darkwave, Cabaret, Soca, Oldies, Soundtrack, Worldbeat, Pop-Folk, Acoustic, Ethnic, Brazilian Folk, Other, Pop, Latin Jazz, Opera, Progressive Rock, Merengue, Rock & Roll, Blues, New Age, Country, Acid Jazz, Dance, Punk Pop, Alt. Rock, Soul, 1] 2006-01-28 11:37:19.4535 RandomPlay: Find returned 1 items 2006-01-28 11:37:19.4535 RandomPlay: Adding track: Head Over Heels / Broken [Live], 10735 2006-01-28 11:37:19.4564 Start and End node: [default:default] 2006-01-28 11:37:19.4574 Start and End node: [default:default] 2006-01-28 11:37:19.4593 Running SQL query: [SELECT DISTINCT tracks.id AS id,tracks.album AS album,tracks.url AS url,tracks.multialbumsortkey AS multialbumsortkey,tracks.ct AS ct FROM tracks WHERE ( tracks.audio = ? AND tracks.id = ? ) ORDER BY tracks.disc, tracks.tracknum, tracks.titlesort] 2006-01-28 11:37:19.4600 Bind arguments: [1, 10735] 2006-01-28 11:37:19.8158 RandomPlay: Playing continuous track mode with 11 items 2006-01-28 11:38:25.3760 RandomPlay: received command open file:///F:/Maho%20Backup/Music/All%20Music/Music/%27%20U%20V%20W%20X%20Y%20Z/Zap%20Mama/1999%20-%20A%20Ma%20Zone/01%20-%20Rafiki.mp3 2006-01-28 11:38:25.3766 RandomPlay: No client! 2006-01-28 11:38:25.3774 Backtrace: frame 0: Plugins::RandomPlay::Plugin::commandCallback (/PerlApp/Slim/Control/Command.pm line 1439) frame 1: Slim::Control::Command::executeCallback (/PerlApp/Slim/Player/Source.pm line 1691) frame 2: Slim::Player::Source::openSong (/PerlApp/Slim/Player/Source.pm line 412) frame 3: Slim::Player::Source::playmode (/PerlApp/Slim/Player/Source.pm line 823) frame 4: Slim::Player::Source::jumpto (/PerlApp/Slim/Control/Command.pm line 950) frame 5: Slim::Control::Command::execute (/PerlApp/Slim/Web/HTTP.pm line 674) frame 6: Slim::Web::HTTP::processURL (/PerlApp/Slim/Web/HTTP.pm line 539) frame 7: Slim::Web::HTTP::processHTTP (/PerlApp/Slim/Networking/Select.pm line 111) frame 8: Slim::Networking::Select::select (slimserver.pl line 634) frame 9: main::idle (slimserver.pl line 38) frame 10: PerlSvc::Startup (perlsvc.pl line 1481) frame 11: PerlSvc::_startup (slimserver.pl line 0) frame 12: (eval) (slimserver.pl line 0) 2006-01-28 11:38:25.5986 RandomPlay: received command playlist jump +1 2006-01-28 11:38:25.5993 RandomPlay: while in mode: track, from Squeezebox 2006-01-28 11:38:26.9820 RandomPlay: received command newsong 2006-01-28 11:38:26.9828 RandomPlay: No client! 2006-01-28 11:38:26.9838 Backtrace: frame 0: Plugins::RandomPlay::Plugin::commandCallback (/PerlApp/Slim/Control/Command.pm line 1439) frame 1: Slim::Control::Command::executeCallback (/PerlApp/Slim/Player/Source.pm line 1212) frame 2: Slim::Player::Source::trackStartEvent (/PerlApp/Slim/Networking/Slimproto.pm line 524) frame 3: Slim::Networking::Slimproto::process_slimproto_frame (/PerlApp/Slim/Networking/Slimproto.pm line 244) frame 4: Slim::Networking::Slimproto::client_readable (/PerlApp/Slim/Networking/Select.pm line 111) frame 5: Slim::Networking::Select::select (slimserver.pl line 666) frame 6: main::idleStreams (/PerlApp/Slim/Web/Pages.pm line 572) frame 7: Slim::Web::Pages::playlist (/PerlApp/Slim/Web/HTTP.pm line 769) frame 8: Slim::Web::HTTP::generateHTTPResponse (/PerlApp/Slim/Web/HTTP.pm line 678) frame 9: Slim::Web::HTTP::processURL (/PerlApp/Slim/Web/HTTP.pm line 539) frame 10: Slim::Web::HTTP::processHTTP (/PerlApp/Slim/Networking/Select.pm line 111) frame 11: Slim::Networking::Select::select (slimserver.pl line 634) frame 12: main::idle (slimserver.pl line 38) frame 13: PerlSvc::Startup (perlsvc.pl line 1481) frame 14: PerlSvc::_startup (slimserver.pl line 0) frame 15: (eval) (slimserver.pl line 0) 2006-01-28 11:38:27.1296 RandomPlay: received command newsong 2006-01-28 11:38:27.1305 RandomPlay: while in mode: track, from Squeezebox 2006-01-28 11:38:27.1310 RandomPlay: new song detected (2) 2006-01-28 11:38:27.1312 RandomPlay: Stripping off completed track(s) 2006-01-28 11:38:27.1323 RandomPlay: playRandom called with type track 2006-01-28 11:38:27.1329 RandomPlay: 8 songs remaining, songIndex = 2 -- treble ------------------------------------------------------------------------ treble's Profile: http://forums.slimdevices.com/member.php?userid=2797 View this thread: http://forums.slimdevices.com/showthread.php?t=20494 _______________________________________________ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
