I've been running UniServer Zero for quite a while without problems. I run it from an external hard drive. I am running version UniServer Zero XI 11.0.7 with UniController XI V1.0.6. (On WinXP).
Today when I started the controller, (in the same environment as usual, no changes to system since last run), I clicked 'Start Apache' as usual without problem. Then when I clicked 'Start MySQL', I got Warning: Failed to start MySQL
I looked in mysql.err error log and found:
140917 13:06:38 [Note] Plugin 'FEDERATED' is disabled.
140917 13:06:38 InnoDB: The InnoDB memory heap is disabled
140917 13:06:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140917 13:06:38 InnoDB: Compressed tables use zlib 1.2.3
140917 13:06:38 InnoDB: Initializing buffer pool, size = 16.0M
140917 13:06:38 InnoDB: Completed initialization of buffer pool
140917 13:06:40 InnoDB: highest supported file format is Barracuda.
140917 13:06:40 InnoDB: Waiting for the background threads to start
140917 13:06:41 InnoDB: 5.5.35 started; log sequence number 1595675
140917 13:06:41 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
140917 13:06:42 [Note] - '127.0.0.1' resolves to '127.0.0.1';
140917 13:06:42 [Note] Server socket created on IP: '127.0.0.1'.
140917 13:06:43 [Note] Event Scheduler: Loaded 0 events
140917 13:06:43 [Note] E:\UniServerZ\core\mysql\bin\mysqld_z.exe: ready for connections.
Version: '5.5.35' socket: '' port: 3306 MySQL Community Server (GPL)
140917 13:07:07 [Note] Plugin 'FEDERATED' is disabled.
140917 13:07:07 InnoDB: The InnoDB memory heap is disabled
140917 13:07:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140917 13:07:07 InnoDB: Compressed tables use zlib 1.2.3
140917 13:07:08 InnoDB: Initializing buffer pool, size = 16.0M
140917 13:07:08 InnoDB: Completed initialization of buffer pool
140917 13:07:08 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.
From a command prompt I ran:
netstat -b -p TCP
but I couldn't find anything that was using the port.
After clicking the 'Start MySQL' button a few more times, I also got:
MySQL port = 3306
Application PID = 3136
Application Name = MYSQLD_Z.EXE
Application Path = E:\UniServerZ\core\mysql\bin\mysql_z.exe
I found MYSQLD_Z.EXE in Windows Task Manager (Multiple instances) and used 'end process' to terminate them. But still no luck.
I restarted windows but still found the same problem. I can't start MySQL.
Please help! What can I do?
I've attached a copy of the complete error log.