I've been using the new DynamicPlaylist plugin with the new alarm system in 7.2 for a while now without any hitches, until this morning!
I'm using a DynamicPlaylist version of a regular playlist (basically to randomize it as I have the DP setting "randomize playlists"), normally works great, but this morning the box switched on but nothing played. I found that playlist wouldn't play at all, including manually. Rebooting SC then trying cured the problem. Upon looking in the SC logs I saw a few unusual errors over the last few days, see below for details (didn't have DynamicPlaylist debug on unfortunately). Now, the 2 things I did last night which I suspect the latter is the problem are as follows: 1) Installed a Squeezebox Boom 2) Rescanned after ripping some new CD's Could it be that upon a rescan DynamicPlaylist loses the id of the playlist selected or something? If this is the cause could I create my own SQLPlaylist based on a "real" playlist? Ideally I'd like to do that as I'd like to add some extra clauses like don't repeat in 3 days. I tried once before but kept ending up with parameterized playlists, which of course don't make sense in an alarm! This is the log snippets: [08-09-29 19:46:37.9083] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Got error 28 from storage engine at /share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-09-29 19:46:38.1392] Slim::Schema::Storage::throw_exception (70) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/share/HDA_DATA/SqueezeCenter/Slim/Schema/Storage.pm line 70) frame 1: Slim::Schema::Storage::throw_exception (/share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 3: DBIx::Class::Storage::DBI::_select (/share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 852) frame 4: DBIx::Class::Storage::DBI::select_single (/share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Class/ResultSet.pm line 509) frame 5: DBIx::Class::ResultSet::single (/share/HDA_DATA/SqueezeCenter/Slim/Schema/Track.pm line 101) frame 6: Slim::Schema::Track::artist (/volume1/SqueezeCenter/Cache/templates//share/HDA_DATA/SqueezeCenter/HTML/Classic/status_header.html line 603) frame 7: (eval) (/volume1/SqueezeCenter/Cache/templates//share/HDA_DATA/SqueezeCenter/HTML/Classic/status_header.html line 603) frame 8: (eval) (/volume1/SqueezeCenter/Cache/templates//share/HDA_DATA/SqueezeCenter/HTML/Classic/status_header.html line 16) frame 9: Template::Provider::__ANON__ (/share/HDA_DATA/SqueezeCenter/CPAN/Template/Document.pm line 155) frame 10: (eval) (/share/HDA_DATA/SqueezeCenter/CPAN/Template/Document.pm line 153) frame 11: Template::Document::process (/share/HDA_DATA/SqueezeCenter/CPAN/Template/Context.pm line 346) frame 12: (eval) (/share/HDA_DATA/SqueezeCenter/CPAN/Template/Context.pm line 320) frame 13: Template::Context::process (/share/HDA_DATA/SqueezeCenter/Slim/Web/Template/Context.pm line 40) frame 14: Slim::Web::Template::Context::process (/share/HDA_DATA/SqueezeCenter/CPAN/Template/Service.pm line 97) frame 15: (eval) (/share/HDA_DATA/SqueezeCenter/CPAN/Template/Service.pm line 94) frame 16: Template::Service::process (/share/HDA_DATA/SqueezeCenter/CPAN/Template.pm line 71) frame 17: Template::process (/share/HDA_DATA/SqueezeCenter/Slim/Web/HTTP.pm line 2406) frame 18: Slim::Web::HTTP::_generateContentFromFile (/share/HDA_DATA/SqueezeCenter/Slim/Web/HTTP.pm line 2359) frame 19: Slim::Web::HTTP::filltemplatefile (/share/HDA_DATA/SqueezeCenter/Slim/Web/Pages/Status.pm line 178) frame 20: Slim::Web::Pages::Status::status (/share/HDA_DATA/SqueezeCenter/Slim/Web/Pages/Status.pm line 38) frame 21: Slim::Web::Pages::Status::status_header (/share/HDA_DATA/SqueezeCenter/Slim/Web/HTTP.pm line 1101) frame 22: Slim::Web::HTTP::generateHTTPResponse (/share/HDA_DATA/SqueezeCenter/Slim/Web/HTTP.pm line 969) frame 23: Slim::Web::HTTP::processURL (/share/HDA_DATA/SqueezeCenter/Slim/Web/HTTP.pm line 780) frame 24: Slim::Web::HTTP::processHTTP (/share/HDA_DATA/SqueezeCenter/Slim/Networking/IO/Select.pm line 248) frame 25: (eval) (/share/HDA_DATA/SqueezeCenter/Slim/Networking/IO/Select.pm line 248) frame 26: Slim::Networking::IO::Select::select (/volume1/SqueezeCenter/slimserver.pl line 531) frame 27: main::idle (/volume1/SqueezeCenter/slimserver.pl line 481) frame 28: main::main (/volume1/SqueezeCenter/slimserver.pl line 1043) [08-09-29 19:46:38.3523] Slim::Web::HTTP::_generateContentFromFile (2406) Error: undef error - Carp::Clan::__ANON__(): Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Got error 28 from storage engine at /share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-09-29 23:33:59.1191] Slim::Player::Source::errorOpening (1759) Error: While opening current track, so mark it as already played! [08-09-29 23:33:59.1396] Slim::Player::Source::errorOpening (1759) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/share/HDA_DATA/SqueezeCenter/Slim/Player/Source.pm line 1759) frame 1: Slim::Player::Source::errorOpening (/share/HDA_DATA/SqueezeCenter/Slim/Player/Squeezebox2.pm line 646) frame 2: Slim::Player::Squeezebox2::failedDirectStream (/share/HDA_DATA/SqueezeCenter/Slim/Networking/Slimproto.pm line 612) frame 3: Slim::Networking::Slimproto::_disco_handler (/share/HDA_DATA/SqueezeCenter/Slim/Networking/Slimproto.pm line 421) frame 4: Slim::Networking::Slimproto::client_readable (/share/HDA_DATA/SqueezeCenter/Slim/Networking/IO/Select.pm line 248) frame 5: (eval) (/share/HDA_DATA/SqueezeCenter/Slim/Networking/IO/Select.pm line 248) frame 6: Slim::Networking::IO::Select::select (/volume1/SqueezeCenter/slimserver.pl line 531) frame 7: main::idle (/volume1/SqueezeCenter/slimserver.pl line 481) frame 8: main::main (/volume1/SqueezeCenter/slimserver.pl line 1043) [08-09-30 07:30:39.3134] Slim::Player::Source::errorOpening (1759) Error: While opening current track, so mark it as already played! [08-09-30 07:30:39.3825] Slim::Player::Source::errorOpening (1759) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/share/HDA_DATA/SqueezeCenter/Slim/Player/Source.pm line 1759) frame 1: Slim::Player::Source::errorOpening (/share/HDA_DATA/SqueezeCenter/Slim/Player/Squeezebox2.pm line 646) frame 2: Slim::Player::Squeezebox2::failedDirectStream (/share/HDA_DATA/SqueezeCenter/Slim/Networking/Slimproto.pm line 612) frame 3: Slim::Networking::Slimproto::_disco_handler (/share/HDA_DATA/SqueezeCenter/Slim/Networking/Slimproto.pm line 421) frame 4: Slim::Networking::Slimproto::client_readable (/share/HDA_DATA/SqueezeCenter/Slim/Networking/IO/Select.pm line 248) frame 5: (eval) (/share/HDA_DATA/SqueezeCenter/Slim/Networking/IO/Select.pm line 248) frame 6: Slim::Networking::IO::Select::select (/volume1/SqueezeCenter/slimserver.pl line 531) frame 7: main::idle (/volume1/SqueezeCenter/slimserver.pl line 481) frame 8: main::main (/volume1/SqueezeCenter/slimserver.pl line 1043) -- sk33ve ------------------------------------------------ QNAP TS-109Pro: (Firmware: 2.1.0 build: 0624), SqueezeCenter: v7.2.0 (build: 22900) - Plugins: DynamicPlaylist, TrackStat, SQLPlaylist Squeezeboxes: 2x Classics, 1x Duet ------------------------------------------------ ------------------------------------------------------------------------ sk33ve's Profile: http://forums.slimdevices.com/member.php?userid=16580 View this thread: http://forums.slimdevices.com/showthread.php?t=53278 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
