Bug 4284 - Scanner,exe ends abnormally with error
: Scanner,exe ends abnormally with error
Status: CLOSED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 6.5.0
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-10-04 09:31 UTC by J Yow
Modified: 2008-12-18 11:12 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description J Yow 2006-10-04 09:31:37 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
Comment 1 KDF 2006-10-04 09:41:14 UTC
see bug 3777, and bug 3890
Comment 2 KDF 2006-10-04 09:43:08 UTC
oh, and targets should not be set when creating new bug report.  please leave undefined for review.
Comment 3 Chris Owens 2006-10-04 10:18:35 UTC
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.
Comment 4 Andy Grundman 2006-10-04 10:31:40 UTC
Disable any virus scanner on your system, and see if that helps.
Comment 5 J Yow 2006-10-06 21:12:01 UTC
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.
Comment 6 Chris Owens 2008-03-07 09:03:53 UTC
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.