Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Mysql InnoDB "error 32" on Windows

Tags:

mysql

innodb

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.

like image 464
Cédric Girard Avatar asked Nov 12 '08 11:11

Cédric Girard


1 Answers

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.

like image 90
Greg Avatar answered Sep 28 '22 20:09

Greg