Bugzilla – Bug 2756
Random Mix Of Songs Not Working
Last modified: 2008-09-15 14:37:04 UTC
I'm running the following version on a MIPS Linkstation. SlimServer Version: 6.2.2 - 5427 - Linux - EN - iso-8859-1 When I select the Random Mix of songs a playlist is not created. Nothing happens in the playlist section of the web page. The player (either SB2 or Softsqueeze)shows now playing Random Mix then a playlist of nothing. If I select Random Artist, a playlist of two songs is created, with a further 1 to 2 added when the last song in the play list is reached. I have looked at the log and get the following when I go to ues the Random Song "2005-12-27 01:31:52.1489 DBD::SQLite::st execute failed: disk I/O error(1) at dbdimp.c line 419 at /mnt/hda/share/Slimserver/CPAN/DBIx/ContextualFetch.pm line 51. 2005-12-27 01:31:52.2622 Whoops! prepare_cached() or execute() failed on sql: [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 RANDOM() LIMIT 20] - [DBD::SQLite::st execute failed: disk I/O error(1) at dbdimp.c line 419 at /mnt/hda/share/Slimserver/CPAN/DBIx/ContextualFetch.pm line 51. ] 2005-12-27 01:31:52.2930 Backtrace: frame 0: Slim::DataStores::DBI::DataModel::find (/mnt/hda/share/Slimserver/Slim/DataStores/DBI/DBIStore.pm line 307) frame 1: Slim::DataStores::DBI::DBIStore::find (/mnt/hda/share/Slimserver/Plugins/RandomPlay/Plugin.pm line 44) frame 2: Plugins::RandomPlay::Plugin::findAndAdd (/mnt/hda/share/Slimserver/Plugins/RandomPlay/Plugin.pm line 246) frame 3: Plugins::RandomPlay::Plugin::playRandom (/mnt/hda/share/Slimserver/Plugins/RandomPlay/Plugin.pm line 387) frame 4: Plugins::RandomPlay::Plugin::handlePlayOrAdd (/mnt/hda/share/Slimserver/Plugins/RandomPlay/Plugin.pm line 410) frame 5: Plugins::RandomPlay::Plugin::__ANON__ (/mnt/hda/share/Slimserver/Slim/Buttons/Input/Choice.pm line 187) frame 6: Slim::Buttons::Input::Choice::callCallback (/mnt/hda/share/Slimserver/Slim/Buttons/Input/Choice.pm line 156) frame 7: Slim::Buttons::Input::Choice::__ANON__ (/mnt/hda/share/Slimserver/Slim/Hardware/IR.pm line 662) frame 8: Slim::Hardware::IR::executeButton (/mnt/hda/share/Slimserver/Slim/Control/Command.pm line 252) frame 9: Slim::Control::Command::execute (/mnt/hda/share/Slimserver/Slim/Player/Client.pm line 990) frame 10: Slim::Player::Client::execute (/mnt/hda/share/Slimserver/Slim/Hardware/IR.pm line 675) frame 11: Slim::Hardware::IR::processCode (/mnt/hda/share/Slimserver/Slim/Hardware/IR.pm line 493) frame 12: Slim::Hardware::IR::processIR (/mnt/hda/share/Slimserver/Slim/Control/Command.pm line 252) frame 13: Slim::Control::Command::execute (/mnt/hda/share/Slimserver/Slim/Player/Client.pm line 990) frame 14: Slim::Player::Client::execute (/mnt/hda/share/Slimserver/Slim/Hardware/IR.pm line 88) frame 15: Slim::Hardware::IR::idle (./slimserver.pl line 611) frame 16: main::idle (./slimserver.pl line 570) frame 17: main::main (./slimserver.pl line 1226)
Disk I/O error? Dan, is this as scary as it sounds?
There's some issue with the disk / OS interaction on your linkstation. It might be as simple as removing the slimserversql.db and rescanning.
I have removed the slimserversql.db and done a rescan, but it is still the same. Everthing else works just fine. It is only the Ramdom Mix that I have problems with.
I have re-flashed the Linkstation, re-installed Slimserver and the Slimserver Modules (from the linkstation wiki, without them I get SQL errors), and it all now works OK. Do I now have to change the bug status to fixed, or do you? Thanks for your help Tony
thanks for the update. I'll mark as fixed. in future, you may mark any bug you have reported as fixed if you feel that the issue is resolved to your satisfaction. as most bug require patches, the bugs tend to get marked fixed when the patch is applied. please re-open if this problem appears again, and more details are available.
There are 536 bugs in the database with targets of '---' that were fixed prior to new year 2006. I am setting them to targets of 6.2.1 to keep them from showing up in my queries.