Bugzilla – Bug 17286
Scanner crashes with MySQL error
Last modified: 2011-07-03 12:58:49 UTC
Created attachment 7316 [details] server.log and scanner.log from latest scan I'm using the 7.5.3 scanner with a 7.5.4 installation due to bug 17173. When I do a clear & rescan or a new & changed scan, the scanner crashes each time with a MySQL error: [11-06-12 22:14:36.9981] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Can't create/write to file 'C:\Documents and Settings\All Users.WINDOWS\Application Data\Squeezebox\Cache\MySQL\#sql_470_0.MYI' (Errcode: 17) [for Statement "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"] And in server.log I see this error: [11-06-12 20:34:49.6150] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Table 'slimserver.dbix_migration' doesn't exist [for Statement "SELECT value FROM dbix_migration WHERE name = ?; "] Version: 7.5.4 - r32171 @ Thu Apr 14 09:19:34 PDT 2011 Operating system: Windows XP - EN - cp1252 Platform Architecture: 586 Perl Version: 5.10.0 - MSWin32-x86-multi-thread MySQL Version: 5.0.22-community-nt Logs attached.
Created attachment 7317 [details] 7.5.5 scanner log
Tried upgrading to 7.5.5, did another clear & rescan with the latest scanner (rather than using the 7.5.3 scanner.exe), same result. Log attached.
Scanner crashes with same MySQL err msg in log upon every subsequent "new and changed" scan. Up to 10 scans so far and still not through the whole music folder.
In most cases known this is due to antivirus products blocking access to the DB's file. Make sure your scanner doesn't scan *.my* files. What scanner are you using? Best known for this issue are McAfee and MS AV Essentials (or whatever it's called)
I'm using Trend Micro Internet Security. Haven't upgraded or changed its settings lately; Squeeze scans used to run fine for the most part. I can set it to specifically exclude explicit files & folders, but I don't see a setting to skip types of files, i.e. *.my* files.
Michael, I found the setting where I told Trend Micro to explicitly ignore the SB "Cache" folder, and I made sure nothing in that folder was set to read-only as well, and now it's working! Thanks a lot for the suggestion.