Bugzilla – Bug 4268
Random Mix crashes slimserver
Last modified: 2006-09-30 20:04:02 UTC
In the web UI, clicking the + sign next to "Random Years" will crash slimserver (no response on port 9000). To reproduce: 1. Open the web interface 2. Under Browse, click Random Mix. 3. Next to Random Years, click the "+" button to add to your playlist. 4. Web browser (Firefox on Linux) reports: The connection was reset The connection to the server was reset while the page was loading. 5. The slimserver has crashed. "telnet myserver 9000" reports "connection refused". 6. Stopping and starting slimserver from the Mac System Preferences fixes the problem. Other facts: - My playlist is initially empty - My only selected genres (for random mix) are Progressive Rock and Fusion. - The selected slim client is a slimserver 2. - I have about 17,000 MP3s. - Server is Mac Mini (non-Intel) Other version info: SlimServer Version: 6.5.0 - 9916 - Mac OS X 10.4.7 (8J135) - EN - utf8 Server IP address: 192.168.0.27 Perl Version: 5.8.6 darwin-thread-multi-2level MySQL Version: 5.0.22-standard
I wrote my client is a "slimserver 2". I meant "Squeezebox 2".
Here's the log output of the crash (slimserver.pl actually dies): 2006-09-30 20:54:21.4594 ERROR: Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me .audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( ( ( genreTracks.genre = ? ) OR ( genreTracks.genre = ? ) ) )': DBD::mysql::st execute failed: Unk nown column 'genreTracks.genre' in 'where clause' at /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 771. 2006-09-30 20:54:21.4597 ERROR: Backtrace follows: 2006-09-30 20:54:21.4602 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 1: DBIx::Class::Storage::DBI::_execute (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 2: DBIx::Class::Storage::DBI::_select (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 852) frame 3: DBIx::Class::Storage::DBI::select_single (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Schema/Storage.pm line 50) frame 4: Slim::Schema::Storage::select_single (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/ResultSet.pm line 509) frame 5: DBIx::Class::ResultSet::single (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Plugins/RandomPlay/Plugin.pm line 172) frame 6: Plugins::RandomPlay::Plugin::getRandomYear (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Plugins/RandomPlay/Plugin.pm line 291) frame 7: Plugins::RandomPlay::Plugin::playRandom (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Plugins/RandomPlay/Plugin.pm line 758) frame 8: Plugins::RandomPlay::Plugin::handleWebMix (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Plugins/RandomPlay/Plugin.pm line 796) frame 9: Plugins::RandomPlay::Plugin::handleWebSettings (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Web/HTTP.pm line 811) frame 10: Slim::Web::HTTP::generateHTTPResponse (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Web/HTTP.pm line 677) frame 11: Slim::Web::HTTP::processURL (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Web/HTTP.pm line 523) frame 12: Slim::Web::HTTP::processHTTP (/Library/PreferencePanes/SlimServer.prefPane/Contents/server/Slim/Networking/Select.pm line 238) frame 13: Slim::Networking::Select::select (./slimserver.pl line 487) frame 14: main::idle (./slimserver.pl line 440) frame 15: main::main (./slimserver.pl line 1039) Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_o ffset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musi cbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( ( ( genreTracks.genre = ? ) OR ( genreTracks.genre = ? ) ) )': DBD::mysql::st execute failed: Unknown col umn 'genreTracks.genre' in 'where clause' at /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 771. 2006-09-30 20:54:21.4620 Got to the END.
This was already fixed at change 10099, and is already available in the nightly builds. http://www.slimdevices.com/downloads/nightly/latest/6.5/