Since a few days ago, MySQL server on my Windows machine was not successful on closing itself. I found multiple instance of these lines in the MySQL error log:
InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
I have plenty of free spaces, the server is installed for months, the version is 5.1.22-rc-community-log on Windows XP SP3, and I have used only one Windows account to create and execute MySQL service.
Following Greg's answer, I found through ProcessExplorer
that there's another MySQL service running with a different name. I kill it and all run fine.
If the file is in use by another program then Process Explorer could help you track down which one has it open. I assume you've checked you only have one copy of MySQL running.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With