Search the Community
Showing results for tags 'MySQL problem'.
Found 1 result
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. mysql-err.txt