Description
MySQL temp files can have a problem if users run antivirus software. There is a well-documented MySQL conflict with the “On Access Scan” feature of McAfee.
Symptom
The symptom is the following message in the virus scanner log:
Can't create/write to file 'C:\DOCUME~1\spg\LOCALS~1\Temp\#sql_d30_0.MYD' (Errcode: 17)
The message may be present in the commander.log file as a metadata message only:
2010-04-13T13:06:40.229 | DEBUG | bootstrap | | | upgradeData | OperationInvoker | OperationException: InvalidSchema: Unable to validate the database schema: could not get table metadata: ec_procedure_step_credentials
or
2010-04-13T13:06:40.229 | DEBUG | bootstrap | | | upgradeData | OperationInvoker | OperationException: InvalidSchema: Unable to validate the database schema: could not get table metadata: ec_state
Solution
Turn off virus checking for the directory in the error message or for the MySQL temp file extensions.
For more information from the MySQL site and other industry sites, see:
- http://dev.mysql.com/doc/refman/4.1/en/cannot-create.html
- http://bugs.mysql.com/bug.php?id=25872http://bugs.mysql.com/bug.php?id=9551
- https://confluence.atlassian.com/display/JIRA040/Data+Access+Exception+-+Errcode+-+17
- http://bugs.mysql.com/bug.php?id=14325
- http://forums.alfresco.com/viewtopic.php?t=5305&postdays=0&postorder=asc&start=15&sid=8d7b3fb1baff18a45478c1196311f93d
0 Comments