I'm currently running SlimServer on an NLU2 (unslung) V2.3R63-uNSLUng-6.8-beta, with SlimServer version info as follows:
SlimServer Version: 6.5.1 - 11206 - Linux - EN - iso-8859-1 Server IP address: 192.168.1.77 Perl Version: 5.8.8 armv5b-softfloat-linux MySQL Version: 4.1.20 I've included the complete trace below. Is there any more information I can collcet to provide greater detail on the failure? 2007-12-09 20:37:45.9031 Connected to database dbi:mysql:hostname=127.0.0.1;port=9092;database=slimserver - schema version: [3] 2007-12-09 20:37:55.6384 loading types config file... 2007-12-09 20:37:56.7181 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' 2007-12-09 20:37:57.5296 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' 2007-12-09 20:37:57.7860 UPDATE metainformation SET value = ? WHERE ( name = ? ): '1', 'isScanning' 2007-12-09 20:37:57.9938 forceCommit: syncing to the database. 2007-12-09 20:37:58.1038 Executing SQL file /opt/share/ss65/SQL/mysql/schema_clear.sql 2007-12-09 20:37:58.1611 Executing SQL statement: [SET foreign_key_checks = 0;] 2007-12-09 20:37:58.1654 Executing SQL statement: [DELETE FROM tracks;] 2007-12-09 20:37:58.2697 Executing SQL statement: [DELETE FROM playlist_track;] 2007-12-09 20:37:58.4145 Executing SQL statement: [DELETE FROM albums;] 2007-12-09 20:37:58.4509 Executing SQL statement: [DELETE FROM years;] 2007-12-09 20:37:58.4700 Executing SQL statement: [DELETE FROM contributors;] 2007-12-09 20:37:58.4882 Executing SQL statement: [DELETE FROM contributor_track;] 2007-12-09 20:37:58.4992 Executing SQL statement: [DELETE FROM contributor_album;] 2007-12-09 20:37:58.5102 Executing SQL statement: [DELETE FROM genres;] 2007-12-09 20:37:58.5094 Executing SQL statement: [DELETE FROM genre_track;] 2007-12-09 20:37:58.6092 Couldn't execute SQL statement: [DELETE FROM genre_track;] : [DBD::mysql::db do failed: Can't open file: 'genre_track.MYI' (errno: 144) at /opt/share/ss65/Slim/Utils/SQLHelper.pm line 83, <$fh> line 30. ] 2007-12-09 20:37:58.6110 Executing SQL statement: [DELETE FROM comments;] 2007-12-09 20:37:58.6214 Executing SQL statement: [DELETE FROM pluginversion;] 2007-12-09 20:37:58.6321 Executing SQL statement: [DELETE FROM unreadable_tracks;] 2007-12-09 20:37:58.6567 Executing SQL statement: [UPDATE metainformation SET value = 0 WHERE name = 'lastRescanTime';] 2007-12-09 20:37:58.6700 Executing SQL statement: [SET foreign_key_checks = 1;] 2007-12-09 20:37:58.7572 Connected to database dbi:mysql:hostname=127.0.0.1;port=9092;database=slimserver - schema version: [3] 2007-12-09 20:37:58.7657 Executing SQL file /opt/share/ss65/SQL/mysql/schema_optimize.sql 2007-12-09 20:37:58.7865 Executing SQL statement: [OPTIMIZE TABLE tracks;] 2007-12-09 20:37:58.8283 Executing SQL statement: [OPTIMIZE TABLE playlist_track;] 2007-12-09 20:37:58.8270 Executing SQL statement: [OPTIMIZE TABLE albums;] 2007-12-09 20:37:58.8385 Executing SQL statement: [OPTIMIZE TABLE years;] 2007-12-09 20:37:58.8365 Executing SQL statement: [OPTIMIZE TABLE contributors;] 2007-12-09 20:37:58.8477 Executing SQL statement: [OPTIMIZE TABLE contributor_track;] 2007-12-09 20:37:58.8455 Executing SQL statement: [OPTIMIZE TABLE contributor_album;] 2007-12-09 20:37:58.8565 Executing SQL statement: [OPTIMIZE TABLE genres;] 2007-12-09 20:37:58.8565 Executing SQL statement: [OPTIMIZE TABLE genre_track;] 2007-12-09 20:37:58.8663 Executing SQL statement: [OPTIMIZE TABLE comments;] 2007-12-09 20:37:58.8843 Executing SQL statement: [OPTIMIZE TABLE pluginversion;] 2007-12-09 20:37:58.8894 Executing SQL statement: [OPTIMIZE TABLE unreadable_tracks;] 2007-12-09 20:37:59.0235 scanPathOrURL: Finding valid files in: /public/LACIE320 Music/ABBA 2007-12-09 20:37:59.2630 About to look for files in /public/LACIE320 Music/ABBA 2007-12-09 20:37:59.3644 For files with extensions in: [(?i-xsm:\.(?:ape|wma|asf|wax|asx|lnk|wpl|shn|wav|wave|mp3|mp2|m3u|pls|xspf|flc|flac|m4a|mov|m4b|mp4|cue|mp+|mpc|ogg|aif|aiff)$)] 2007-12-09 20:37:59.3609 findFilesForRescan: Generating file list from disk & database... 2007-12-09 20:37:59.9561 findNewAndChangedFiles: Comparing file list between disk & database to generate rescan list... 2007-12-09 20:37:59.9837 SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'lastRescanTime' 2007-12-09 20:38:00.1257 Found 20 files in /public/LACIE320 Music/ABBA 2007-12-09 20:38:02.3420 flc file type for file:///public/LACIE320%20Music/ABBA/ABBA%20Gold%20Greatest%20Hits/14.%20Gimme!%20Gimme!%20Gimme!%20(A%20Man%20After%20Midnight)%20.flac 2007-12-09 20:38:02.3997 ScanDirectory: Adding file:///public/LACIE320%20Music/ABBA/ABBA%20Gold%20Greatest%20Hits/14.%20Gimme!%20Gimme!%20Gimme!%20(A%20Man%20After%20Midnight)%20.flac to database. 2007-12-09 20:38:02.4020 2007-12-09 20:38:02.4036 newTrack(): New Track: [file:///public/LACIE320%20Music/ABBA/ABBA%20Gold%20Greatest%20Hits/14.%20Gimme!%20Gimme!%20Gimme!%20(A%20Man%20After%20Midnight)%20.flac] 2007-12-09 20:38:02.4052 newTrack(): readTags is 1 2007-12-09 20:38:02.4722 flc file type for /public/LACIE320 Music/ABBA/ABBA Gold Greatest Hits/14. Gimme! Gimme! Gimme! (A Man After Midnight) .flac 2007-12-09 20:38:02.4686 Trying to load Slim::Formats::FLAC 2007-12-09 20:38:09.8704 INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, replay_gain, replay_peak, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '31181200', '864595.618818745', '2', 'flc', '0', '31181200', '1', '0', '0', '+0.39', '0.93093872', '44100', '288.506666666667', '1179065410', 'Gimme! Gimme! Gimme! (A Man After Midnight)', 'GIMME GIMME GIMME A MAN AFTER MIDNIGHT', 'GIMME GIMME GIMME A MAN AFTER MIDNIGHT', '14', 'file:///public/LACIE320%20Music/ABBA/ABBA%20Gold%20Greatest%20Hits/14.%20Gimme!%20Gimme!%20Gimme!%20(A%20Man%20After%20Midnight)%20.flac', '1992' 2007-12-09 20:38:10.2149 newTrack(): Created track 'Gimme! Gimme! Gimme! (A Man After Midnight)' (id: [9709]) 2007-12-09 20:38:10.2649 -- Track is a local track 2007-12-09 20:38:10.3333 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'POP' 2007-12-09 20:38:10.9581 INSERT INTO genres (name, namesearch, namesort) VALUES (?, ?, ?): 'Pop', 'POP', 'POP' 2007-12-09 20:38:11.1759 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '216', '9709', '216', '9709' 2007-12-09 20:38:11.2378 ERROR: Error executing 'SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) )': DBD::mysql::st execute failed: Can't open file: 'genre_track.MYI' (errno: 144) at /opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 771. 2007-12-09 20:38:11.2329 ERROR: Backtrace follows: 2007-12-09 20:38:11.2744 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 1: DBIx::Class::Storage::DBI::_execute (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 2: DBIx::Class::Storage::DBI::_select (/opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 852) frame 3: DBIx::Class::Storage::DBI::select_single (/opt/share/ss65/Slim/Schema/Storage.pm line 94) frame 4: Slim::Schema::Storage::select_single (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 509) frame 5: DBIx::Class::ResultSet::single (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 353) frame 6: DBIx::Class::ResultSet::find (/opt/share/ss65/CPAN/DBIx/Class/ResultSet.pm line 1380) frame 7: DBIx::Class::ResultSet::find_or_create (/opt/share/ss65/Slim/Schema/Genre.pm line 83) frame 8: Slim::Schema::Genre::add (/opt/share/ss65/Slim/Schema.pm line 1795) frame 9: Slim::Schema::_postCheckAttributes (/opt/share/ss65/Slim/Schema.pm line 844) frame 10: Slim::Schema::newTrack (/opt/share/ss65/Slim/Utils/Scanner.pm line 322) frame 11: Slim::Utils::Scanner::scanDirectory (/opt/share/ss65/Slim/Utils/Scanner.pm line 90) frame 12: Slim::Utils::Scanner::scanPathOrURL (./scanner.pl line 168) frame 13: (eval) (./scanner.pl line 168) frame 14: main::main (./scanner.pl line 312) 2007-12-09 20:38:11.2861 ERROR: Scanner: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) )': DBD::mysql::st execute failed: Can't open file: 'genre_track.MYI' (errno: 144) at /opt/share/ss65/CPAN/DBIx/Class/Storage/DBI.pm line 771. ] 2007-12-09 20:38:11.2884 ERROR: Scanner: Skipping post-process & Not updating lastRescanTime! 2007-12-09 20:38:11.4910 SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' 2007-12-09 20:38:11.5248 UPDATE metainformation SET value = ? WHERE ( name = ? ): '0', 'isScanning' 2007-12-09 20:38:11.5414 forceCommit: syncing to the database. COMMIT COMMIT COMMIT -- paulclo ------------------------------------------------------------------------ paulclo's Profile: http://forums.slimdevices.com/member.php?userid=14323 View this thread: http://forums.slimdevices.com/showthread.php?t=40902 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/unix
