View Full Version : Random Mix Problem

2006-07-21, 02:58
I hope that someone will be able to help me with this.

I am running SlimServer (Currently Ver 6.3.1) on a Linkstation II Mipsel 12,000 songs all mp3, and have been for about a year. It works fine except for one problem with Random Play. When I select Random Play (Song) no playlist of songs is set up. If I select Random Play (Artist), one song from one artist will be put on the playlist and nothing else. This is the same for Album and Year.

If I look into the debugging log I see the following

2006-07-21 10:35:52.1042 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.
2006-07-21 10:35:52.1977 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 25] - [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.
2006-07-21 10:35:52.2354 Backtrace:

frame 0: Slim::DataStores::DBI::DataModel::find (/mnt/hda/share/Slimserver/Slim/DataStores/DBI/DBIStore.pm line 302)
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 248)
frame 3: Plugins::RandomPlay::Plugin::playRandom (/mnt/hda/share/Slimserver/Plugins/RandomPlay/Plugin.pm line 588)
frame 4: Plugins::RandomPlay::Plugin::handleWebMix (/mnt/hda/share/Slimserver/Plugins/RandomPlay/Plugin.pm line 625)
frame 5: Plugins::RandomPlay::Plugin::handleWebSettings (/mnt/hda/share/Slimserver/Slim/Web/HTTP.pm line 796)
frame 6: Slim::Web::HTTP::generateHTTPResponse (/mnt/hda/share/Slimserver/Slim/Web/HTTP.pm line 697)
frame 7: Slim::Web::HTTP::processURL (/mnt/hda/share/Slimserver/Slim/Web/HTTP.pm line 551)
frame 8: Slim::Web::HTTP::processHTTP (/mnt/hda/share/Slimserver/Slim/Networking/Select.pm line 141)
frame 9: Slim::Networking::Select::select (./slimserver.pl line 705)
frame 10: main::idle (./slimserver.pl line 641)
frame 11: main::main (./slimserver.pl line 1281)

This has been happening with various versions of SlimServer. I have removed and re installed Slimserver, SlimData, re scanned music, but with no luck.

The only way in the past I have solved the problem has been to re-load the Linkstation Firmware. This has solved the problem for a couple of months and then it has happened again (can't see what has happened or changed). This time re-loading the firmware has not worked. I have built the required Modules for the Linkstation again with no joy.

One other thing, when I do a rescan (either full or just new music) the SB2 display will show Now Playing even if the player was off.

Has anyone any ideas?

Thanks in advance

2006-07-21, 03:18
> 2006-07-21 10:35:52.1042 DBD::SQLite::st execute failed: disk I/O
> error(1) at dbdimp.c line 419 at

Are you running out of diskspace on the partition where slimserver is
installed? Or /tmp (where slimserver.log will grow over time)?



Help translate SlimServer by using the
SlimString Translation Helper (http://www.herger.net/slim/)

2006-07-21, 03:34
Where Slimserver is installed I have used 59% (94gb free) and where /tmp is 67% used (117mb free)