Bugzilla – Bug 4284
Scanner,exe ends abnormally with error
Last modified: 2008-12-18 11:12:53 UTC
Just did a fresh install and the scan terminated normally 10,000+ files access via Windows UNC stored in a server. However, when tried running Sanner.exe from a command to scan a directory with 14 files, I got the follow from the command prompt. End result is Slimserver failed to record songs in database. I did the scan a second time and it went through normally. System is a T40p Thinkpad laptop with 1GB RAM The follow is a log of the failed attempt. ------------------------------Begin------------------------------ scanner --progress \\trinity\FLACS\Samantha 2006-10-04 23:59:37.5448 scanPathOrURL: Finding valid files in: \\trinity\FLACS\Samantha 2006-10-04 23:59:37.5499 About to look for files in \\trinity\FLACS\Samantha 2006-10-04 23:59:37.5523 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|lnk)$)] 2006-10-04 23:59:39.4075 Found 18 files in \\trinity\FLACS\Samantha 100% [=========================================] 4.01 tracks/sec 00m04s DONE 20% [======== ] 16.72 tracks/sec 02m12s LEFT20 06-10-05 00:00:18.8859 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, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role =? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8b8_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm li ne 771. 2006-10-05 00:00:18.8861 ERROR: Backtrace follows: 2006-10-05 00:00:18.8864 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79) frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 701) frame 4: DBIx::Class::ResultSet::next (/PerlApp/Slim/Schema.pm line 1173) frame 5: Slim::Schema::mergeVariousArtistsAlbums (/PerlApp/Slim/Music/Import.pm line 283) frame 6: Slim::Music::Import::runScanPostProcessing (scanner.pl line 191) frame 7: main::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584) frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572) frame 9: DBIx::Class::Schema::txn_do (scanner.pl line 191) frame 10: (eval) (scanner.pl line 191) frame 11: main::main (scanner.pl line 330) 2006-10-05 00:00:19.2442 ERROR: 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_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.music magic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8b8_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. 2006-10-05 00:00:19.2446 ERROR: Backtrace follows: 2006-10-05 00:00:19.2447 Backtrace: frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 60 6) frame 1: DBIx::Class::Schema::txn_do (scanner.pl line 191) frame 2: (eval) (scanner.pl line 191) frame 3: main::main (scanner.pl line 330) ------------------------------End------------------------------ I did the scan a second time and it went through normally. System is a T40p Thinkpad laptop with 1GB RAM
see bug 3777, and bug 3890
oh, and targets should not be set when creating new bug report. please leave undefined for review.
I notice the actual error at the heart of all this is: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8b8_0.MYI' Have you noticed any filesystem problems recently? Unless you notice the problem more repeatedly, I'll probably just let this bug hang out for a while to see if any other users see it, too, before putting in a lot of effort to try to reproduce.
Disable any virus scanner on your system, and see if that helps.
thanks it helped. disabling virscan seems a little risky, so i just excluded .myo files as adviced however, slim.exe did terminate itself once, will keep watching.
This bug is being closed since it was resolved for a version which is now released! Please download the new version of SqueezeCenter (formerly SlimServer) at http://www.slimdevices.com/su_downloads.html If you are still seeing this bug, please re-open it and we will consider it for a future release.