Bugzilla – Bug 10358
Scanner in 7.3 fails more than 90% of the time
Last modified: 2008-12-17 09:07:00 UTC
Ever since I've updated to 7.3 the scanner has been behaving *extremely* poorly. Basically, almost every time I try to rescan the library I get the following error. It is the same error every time. I tried rescanning just the playlists and have 20/20 failures scanning with exactly the same error. When I rescanned the entire library I have 4/5 failures once and 6/7 failures the second time I tried it. Once this error occurs the entire music library becomes unavailable and clicking on links in SqueezeCenter cause hangs until you can do a successful scan. This is under Windows Vista Ulitmate 64 bit. ************************************************************************ [08-12-16 23:15:15.1365] Slim::Schema::throw_exception (228) Error: Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( me.compilation IS NULL ) GROUP BY me.id': DBD::mysql::st execute failed: Can't create/write to file 'C:\Users\brusseau\AppData\Local\Temp\#sql_290_0.MYD' (Errcode: 17) at /<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771. [08-12-16 23:15:15.1367] Slim::Schema::throw_exception (228) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 228) frame 1: Slim::Schema::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Schema.pm line 606) frame 2: DBIx::Class::Schema::txn_do (scanner.pl line 235) frame 3: (eval) (scanner.pl line 235) frame 4: main::main (scanner.pl line 363) [08-12-16 23:20:00.4114] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id': DBD::mysql::st execute failed: Can't create/write to file 'C:\Users\brusseau\AppData\Local\Temp\#sql_290_0.MYD' (Errcode: 17) at /<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771. [08-12-16 23:20:00.4118] Slim::Schema::Storage::throw_exception (70) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 70) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 826) frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 852) frame 4: DBIx::Class::Storage::DBI::select_single (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 511) frame 5: DBIx::Class::ResultSet::single (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2346) frame 6: Slim::Schema::_postCheckAttributes (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 977) frame 7: Slim::Schema::newTrack (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 340) frame 8: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79) frame 9: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 494) frame 10: Slim::Music::Import::runImporter (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 323) frame 11: Slim::Music::Import::runScan (scanner.pl line 223) frame 12: (eval) (scanner.pl line 217) frame 13: main::main (scanner.pl line 363)
Note, scanning has worked fine for me for quite a while. This is new behavior in 7.3.
...Can't create/write to file 'C:\Users\brusseau\AppData\Local\Temp\#sql_290_0.MYD' (Errcode: 17) ... this looks like bug 10329 and similar forum threads: http://forums.slimdevices.com/showthread.php?t=56411 http://forums.slimdevices.com/showthread.php?t=56420 http://forums.slimdevices.com/showthread.php?t=53918 It's rather unlikely it's a scanner error.
This is your antivirus scanner blocking access to *.my* files (most likely McAfee?). Please configure it to ignore those file types. Contact support for details on how to do this (if Markus' links don't help). Thanks.
I was able to resolve the issue by reconfiguring my virus protection software.
Great! Thanks for the feedback!
It does seem a bit strange though that I have to disable virus scanning for a whole class of file extensions to get the scanner to work. I have dozens of applications and not a single one of them has required this sort of work-around. It seems like maybe something you are doing is something that is similar to what known viruses do. Perhaps rethinking the scanner's implementation to be less "virus-like" would save everyone a bit of bother. Anyway, this is just an observation and perhaps food-for-thought rather than an action item. Thanks for the quick response.
(In reply to comment #3) > ... (most likely McAfee?). Actually, I use ESET NOD32 in case you get others people using that.