Bugzilla – Bug 11559
Access problems in Cache
Last modified: 2009-03-30 22:09:54 UTC
Created attachment 5002 [details] The scanner log file that shows the inability to write a specific cache file. Fresh install on Windows Vista. Default everything. Squeezecenter notices there is not a database and creates one. Along the way the log file shows an error [09-03-30 13:59:52.7330] Slim::Schema::Storage::throw_exception (81) Error: Error executing 'SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc': DBD::mysql::st execute failed: Can't create/write to file 'C:\ProgramData\SqueezeCenter\Cache\MySQL\#sql_1180_0.MYI' (Errcode: 13) at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~1.EXE>DBIx/Class/Storage/DBI.pm line 771. The result of this problem is that the scan results page shows that the scan is complete but the final artist merge step seems to still be running, stuck on the first artist. The album list seems to be complete but no artwork is shown. I can play music normally. I use iTunes integration, don't use embedded artwork. This is with version 25723 of 7.3.3, but I have a similar problem with 7.3.2. I've checked permissions in the directories mentioned in the logs, they seem ok.
This is a known issue. It is due to an interraction with anti-virus programs that block the mysql temp files during on-access scans. Set you AV software to ignore *.MYD and *.MYI files. see also: bug 3890 bug 3777 bug 10329 bug 4284 bug 10492 bug 7052 and a number of forum threads covering the subject of this very error message.
KDF is right. Sorry I missed the explanation elsewhere for the solution. *** This bug has been marked as a duplicate of bug 3777 ***