KBEC-00140 - MySQL - Antivirus Conflict on Windows

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:

1. http://dev.mysql.com/doc/refman/4.1/en/cannot-create.html
2. http://bugs.mysql.com/bug.php?id=25872http://bugs.mysql.com/bug.php?id=9551
3. https://confluence.atlassian.com/display/JIRA040/Data+Access+Exception+-+Errcode+-+17
4. http://bugs.mysql.com/bug.php?id=14325
5. http://forums.alfresco.com/viewtopic.php?t=5305&postdays=0&postorder=asc&start=15&sid=8d7b3fb1baff18a45478c1196311f93d