PDA

View Full Version : SC 7.0.1 Scanner Crashes



Wigster
2008-05-19, 05:09
Running official SC 7.0.1 under XP SP3.

When I try to do a scan of my library, the Directory Scan and Playlist Scan completes and then the scanner stops scanning during "Merging Various Artists" on the first album. This happens under all circumstances: when just looking for changes, clearing and building a new library and even deleting the database completely and starting afresh. The artwork is not scanned for at all. The timer continues going while the Status says it has completed.

I have the on-access virus scanner switched off completely. The music is sitting on a network drive mapped through UNC.

This used to happen sometimes previously (I was still running 7.0.1 beta and SP2 last time I scanned), but usually somewhere halfway through the Merging task rather than the beginning and switching off the virus checker solved the problem.

I include the relevant part of the log below.

Is anyone else seeing this?

Thanks.

--------------------------

[08-05-18 19:34:57.1241] Slim::Schema::Storage::throw_exception (70) 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.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.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_94c_0.MYD' (Errcode: 13) at C:\PROGRA~1\Media\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-05-18 19:34:57.1248] Slim::Schema::Storage::throw_exception (70) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (C:/PROGRA~1/Media/SQUEEZ~1/server/Slim/Schema/Storage.pm line 70)
frame 1: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\Media\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage::DBI::_execute (C:\PROGRA~1\Media\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage::DBI::_select (C:\PROGRA~1\Media\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 4: DBIx::Class::Storage::DBI::Cursor::next (C:\PROGRA~1\Media\SQUEEZ~1\server\CPAN/DBIx/Class/ResultSet.pm line 701)
frame 5: DBIx::Class::ResultSet::next (/<C:\PROGRA~1\Media\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1261)
frame 6: Slim::Schema::mergeVariousArtistsAlbums (/<C:\PROGRA~1\Media\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 354)
frame 7: Slim::Music::Import::runScanPostProcessing (scanner.pl line 217)
frame 8: main::__ANON__ (/<C:\PROGRA~1\Media\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 584)
frame 9: (eval) (/<C:\PROGRA~1\Media\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 572)
frame 10: DBIx::Class::Schema::txn_do (scanner.pl line 217)
frame 11: (eval) (scanner.pl line 217)
frame 12: main::main (scanner.pl line 345)

[08-05-18 19:34:57.1810] Slim::Schema::throw_exception (217) 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.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.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_94c_0.MYD' (Errcode: 13) at C:\PROGRA~1\Media\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-05-18 19:34:57.1816] Slim::Schema::throw_exception (217) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\Media\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 217)
frame 1: Slim::Schema::throw_exception (/<C:\PROGRA~1\Media\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 606)
frame 2: DBIx::Class::Schema::txn_do (scanner.pl line 217)
frame 3: (eval) (scanner.pl line 217)
frame 4: main::main (scanner.pl line 345)

mherger
2008-05-19, 05:16
> 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_94c_0.MYD' (Errcode: 13) at

This is a known issue with some AV scanners. If you're running McAfee, please tell it to ignore *.my* files. This should fix this problem.

--

Michael

Wigster
2008-05-19, 05:45
Thanks,

I have MY* files set to ignore in McAfee and *also* I completely switch off the on-access scanner through the VirusScan console. Is there something else I should be switching off?

bobkoure
2008-05-19, 06:09
Have you ever had a Symantec anti virus product installed on this machine?
I had a very similar (possibly the exact same) problem and it turns out that Symantec A/V products don't completely uninstall. I ended up doing a complete reformat/re-install, which solved the problem.

Wigster
2008-05-19, 06:12
No, never. I've always had the Enterprise version of McAfee.