I'm curious if anyone else has seen or dealt with something like this before. I have a MySQL 5 server that's started misbehaving in the last two weeks, throwing a bogus error like this:

« Execution of a query to the database failed - Can't create/write to file 'D:\tmp\mysql\#sql_658_0.MYD' (Errcode: 17) »

This is on a Windows 2003 Server, IIS, PHP5, etc. The MYD file exists whenever this error occurs, and I can manipulate it just fine, so it doesn't SEEM like it's locked or anything. There's plenty of disk space, too.

From what I've read elsewhere, others have had problems with AV software causing transient file locks. I've gone so far as to eliminate AV software from this box, and the error still occurs.

Any thoughts?

9/24/2009 7:51:39 AM

what version? have you tried clearing out the temp folder and running the query again? if clearing it out doesn't work, create a new temp directory and change tmpdir to point to the new one...see if that does it

any antivirus running on the server? i've heard AV can cause problems if the directory's not exempt...i've never experienced that myself, though

[Edited on September 24, 2009 at 8:30 AM. Reason : .]

9/24/2009 8:25:00 AM

Have you tried creating a separate temp directory for MySQL and pointing to it in the my.ini configuration file?

[Edited on September 24, 2009 at 9:10 AM. Reason : ^ What he said]

9/24/2009 8:44:57 AM

symantec endpoint protection was installed on here previously, but i removed it (and rebooted) as a part of my own investigating. i'd already added both tmp folder and *.myd file exceptions, but that didn't make a difference.

it's mysql 5.0.67-community. i'm a liiiiiiiiiiittle reluctant to upgrade the version just yet, since it was set up by someone else.

the funny thing is that the tmp folder is already a separate folder, on a different drive. i'll try moving it to a new location, to see what happens.

9/24/2009 9:24:18 AM

this is happening because you touch yourself at night

true story

9/24/2009 10:29:59 AM

but but but it happens even on nights when i don't!

9/24/2009 10:41:10 AM

have you tried touching yourself in a different room while pointing your load towards said room?

9/24/2009 10:55:02 AM

end point is a BEAST to get off. I'd run some sort of complete uninstall program to make sure it's all gone. We currently have it on our server here and i just don't feel like fucking with the removal.

9/24/2009 11:10:31 AM

^ it's gone, nothing active running anymore. i had no problems with the uninstall, thankfully. i haven't run cleanwipe or anything at this point, since i needed to get the box back in service quickly. and i'm planning to put SEP back on later anyway, because i'm very uncomfortable leaving this server w/o AV protection.

9/24/2009 11:23:23 AM

seems to be stable again (for now, I guess). i changed the tmpdir variable to a non-RAID drive, which doesn't seem like it'd make a difference in other circumstances.

9/25/2009 2:00:08 PM