DynamicPlaylist in Alarms on rescan not working

[sk33ve]

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:BI::_execute (/share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage:BI::_select (/share/HDA_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 852)
frame 4: DBIx::Class::Storage:BI::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:ocument:rocess (/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:rocess (/share/HDA_DATA/SqueezeCenter/Slim/Web/Template/Context.pm line 40)
frame 14: Slim::Web::Template::Context:rocess (/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:rocess (/share/HDA_DATA/SqueezeCenter/CPAN/Template.pm line 71)
frame 17: Template:rocess (/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:rocessURL (/share/HDA_DATA/SqueezeCenter/Slim/Web/HTTP.pm line 780)
frame 24: Slim::Web::HTTP:rocessHTTP (/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)

[erland]

Could it be that upon a rescan DynamicPlaylist loses the id of the playlist selected or something?

Yes this could definitely be the case, I think I need to change this so it uses the name instead of the identifier. The problem is just that the name isn't unique because you can have two saved playlists with exactly the same name.

It might be possible to use id but detect rescans and reconnect it to the correct id after the rescan.

Thanks for reporting

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!

I've created a new playlist type "Random playlist songs" that allows you do this. It will be available in the next SQL Playlist release, but if you like to use it already now you can use the download links in the SQL Playlist web interface.

[sk33ve]

Thats brilliant Erland, thanks!

Presumably from what you are saying the SQLPlaylist based playlist might have the same problem anyway, as presumably it uses ID? It will still be v.handy to tweak the settings though, so I'll swap to using that tonight

[erland]

Presumably from what you are saying the SQLPlaylist based playlist might have the same problem anyway, as presumably it uses ID?

The new "Random playlist songs" playlist uses playlist name instead of playlist id, so it should survive rescans correctly. It will probably not work correctly if you have two saved playlists with exactly the same playlist name.

[sk33ve]

Excellent -thanks again Erland!