WampServer
Apache, PHP, MySQL
on Windows
Wamp Orange MySQL problem
Posted by:
Tohoma
(---.socal.res.rr.com)
Date: February 26, 2015 07:37AM
It is my first time installing and the MySQL services won't start. The error I get according to the event viewer is "InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation". Any thoughts on how to correct this?
Re: Wamp Orange MySQL problem
Posted by:
RiggsFolly
(---.as43234.net)
Date: February 26, 2015 10:38AM
I have seen a few of these reported recently, so I had a bit of a think and a good look around.
The MySQL people decided to make INNODB the default database engine in MySQL 5.5.5
Unfortunately the guys at AlterWay seem to have missed that fact and the my.ini file is still delivered with the INNODB parameter commented out like when MYISAM was the default database engine.
Also the INNODB database engine though superior in many ways to MYISAM does require that the person using it actually understands it and how to ensure its continued smooth operation, backups/restores and recovery.
So it is a little dangerous to deliver it in this way to a large part of their target audience i.e. total beginners.
Anyway, to a solution :
As you have just installed WAMPServer I suggest you UnInstall it, using the WIndows Uninstall
Then manually delete the \wamp folder and all its contents.
Then reinstall it.
Do not tick the "Start Now" option at the end of the install, just finish the install
With an editor, edit \wamp\bin\mysql\mysql5.6.17\my.ini
Add this line, after the [wampmysqld] or [wampmysqld64] section heading
Then try and start WAMPServer again.
This does not stop you using INNODB database, but it does mean you will have to specify that engine type on a CTEATE statement otherwise it shoudl use MYISAM.
---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-
The MySQL people decided to make INNODB the default database engine in MySQL 5.5.5
Unfortunately the guys at AlterWay seem to have missed that fact and the my.ini file is still delivered with the INNODB parameter commented out like when MYISAM was the default database engine.
Also the INNODB database engine though superior in many ways to MYISAM does require that the person using it actually understands it and how to ensure its continued smooth operation, backups/restores and recovery.
So it is a little dangerous to deliver it in this way to a large part of their target audience i.e. total beginners.
Anyway, to a solution :
As you have just installed WAMPServer I suggest you UnInstall it, using the WIndows Uninstall
Then manually delete the \wamp folder and all its contents.
Then reinstall it.
Do not tick the "Start Now" option at the end of the install, just finish the install
With an editor, edit \wamp\bin\mysql\mysql5.6.17\my.ini
Add this line, after the [wampmysqld] or [wampmysqld64] section heading
[wampmysqld64] #My local changes default-storage-engine=MYISAM
Then try and start WAMPServer again.
This does not stop you using INNODB database, but it does mean you will have to specify that engine type on a CTEATE statement otherwise it shoudl use MYISAM.
---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-
Re: Wamp Orange MySQL problem
Posted by:
Tohoma
(---.socal.res.rr.com)
Date: February 27, 2015 08:50AM
I tried it and unfortunately it still does not work. However I toyed around a bit and added an older version of MySQL. I was able to get an error log.
2015-02-26 07:47:20 9220 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 07:47:20 9220 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 07:47:20 9220 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 07:47:20 9220 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 07:47:20 9220 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 07:47:20 9220 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 07:47:20 9220 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 07:47:20 9220 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 07:47:20 1030 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 07:47:20 1030 InnoDB: File name .\ib_logfile0
2015-02-26 07:47:20 1030 InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 07:47:20 1030 InnoDB: Cannot continue operation.
2015-02-26 07:47:35 5808 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 07:47:35 5808 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 07:47:35 5808 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 07:47:35 5808 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 07:47:35 5808 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 07:47:35 5808 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 07:47:35 5808 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 07:47:36 5808 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 07:47:36 222c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 07:47:36 222c InnoDB: File name .\ib_logfile0
2015-02-26 07:47:36 222c InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 07:47:36 222c InnoDB: Cannot continue operation.
2015-02-26 07:49:18 9572 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 07:49:18 9572 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 07:49:18 9572 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 07:49:18 9572 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 07:49:18 9572 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 07:49:18 9572 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 07:49:18 9572 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 07:49:18 9572 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 07:49:18 2120 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 07:49:18 2120 InnoDB: File name .\ib_logfile0
2015-02-26 07:49:18 2120 InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 07:49:18 2120 InnoDB: Cannot continue operation.
2015-02-26 07:49:49 7720 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 07:49:49 7720 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 07:49:49 7720 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 07:49:50 7720 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 07:49:50 7720 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 07:49:50 7720 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 07:49:50 7720 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 07:49:50 7720 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 07:49:50 244c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 07:49:50 244c InnoDB: File name .\ib_logfile0
2015-02-26 07:49:50 244c InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 07:49:50 244c InnoDB: Cannot continue operation.
150226 7:49:56 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
150226 7:49:56 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
150226 7:49:56 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
150226 7:49:56 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
150226 7:49:56 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio write'.
InnoDB: Cannot continue operation.
150226 7:50:07 [Note] Plugin 'FEDERATED' is disabled.
150226 7:50:07 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.
2015-02-26 22:25:42 4192 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 22:25:42 4192 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 22:25:42 4192 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 22:25:42 4192 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 22:25:42 4192 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 22:25:42 4192 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 22:25:43 4192 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 22:25:43 4192 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 22:25:43 17d8 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 22:25:43 17d8 InnoDB: File name .\ib_logfile0
2015-02-26 22:25:43 17d8 InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 22:25:43 17d8 InnoDB: Cannot continue operation.
2015-02-26 22:34:49 9968 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 22:34:49 9968 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 22:34:49 9968 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 22:34:49 9968 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 22:34:49 9968 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 22:34:49 9968 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 22:34:49 9968 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 22:34:49 9968 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 22:34:49 1514 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 22:34:49 1514 InnoDB: File name .\ib_logfile0
2015-02-26 22:34:49 1514 InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 22:34:49 1514 InnoDB: Cannot continue operation.
150226 22:34:57 [Note] Plugin 'FEDERATED' is disabled.
150226 22:34:57 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.
2015-02-26 07:47:20 9220 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 07:47:20 9220 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 07:47:20 9220 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 07:47:20 9220 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 07:47:20 9220 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 07:47:20 9220 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 07:47:20 9220 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 07:47:20 9220 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 07:47:20 1030 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 07:47:20 1030 InnoDB: File name .\ib_logfile0
2015-02-26 07:47:20 1030 InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 07:47:20 1030 InnoDB: Cannot continue operation.
2015-02-26 07:47:35 5808 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 07:47:35 5808 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 07:47:35 5808 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 07:47:35 5808 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 07:47:35 5808 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 07:47:35 5808 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 07:47:35 5808 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 07:47:36 5808 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 07:47:36 222c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 07:47:36 222c InnoDB: File name .\ib_logfile0
2015-02-26 07:47:36 222c InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 07:47:36 222c InnoDB: Cannot continue operation.
2015-02-26 07:49:18 9572 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 07:49:18 9572 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 07:49:18 9572 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 07:49:18 9572 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 07:49:18 9572 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 07:49:18 9572 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 07:49:18 9572 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 07:49:18 9572 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 07:49:18 2120 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 07:49:18 2120 InnoDB: File name .\ib_logfile0
2015-02-26 07:49:18 2120 InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 07:49:18 2120 InnoDB: Cannot continue operation.
2015-02-26 07:49:49 7720 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 07:49:49 7720 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 07:49:49 7720 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 07:49:50 7720 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 07:49:50 7720 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 07:49:50 7720 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 07:49:50 7720 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 07:49:50 7720 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 07:49:50 244c InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 07:49:50 244c InnoDB: File name .\ib_logfile0
2015-02-26 07:49:50 244c InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 07:49:50 244c InnoDB: Cannot continue operation.
150226 7:49:56 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
150226 7:49:56 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
150226 7:49:56 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
150226 7:49:56 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
150226 7:49:56 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio write'.
InnoDB: Cannot continue operation.
150226 7:50:07 [Note] Plugin 'FEDERATED' is disabled.
150226 7:50:07 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.
2015-02-26 22:25:42 4192 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 22:25:42 4192 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 22:25:42 4192 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 22:25:42 4192 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 22:25:42 4192 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 22:25:42 4192 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 22:25:43 4192 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 22:25:43 4192 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 22:25:43 17d8 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 22:25:43 17d8 InnoDB: File name .\ib_logfile0
2015-02-26 22:25:43 17d8 InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 22:25:43 17d8 InnoDB: Cannot continue operation.
2015-02-26 22:34:49 9968 [Note] Plugin 'FEDERATED' is disabled.
2015-02-26 22:34:49 9968 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-26 22:34:49 9968 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-26 22:34:49 9968 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-26 22:34:49 9968 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-26 22:34:49 9968 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-26 22:34:49 9968 [Note] InnoDB: Completed initialization of buffer pool
2015-02-26 22:34:49 9968 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-26 22:34:49 1514 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-02-26 22:34:49 1514 InnoDB: File name .\ib_logfile0
2015-02-26 22:34:49 1514 InnoDB: File operation call: 'aio read' returned OS error 187.
2015-02-26 22:34:49 1514 InnoDB: Cannot continue operation.
150226 22:34:57 [Note] Plugin 'FEDERATED' is disabled.
150226 22:34:57 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.
Re: Wamp Orange MySQL problem
Posted by:
RiggsFolly
(---.as43234.net)
Date: February 27, 2015 10:23AM
As we missed these questions in your initial questions woudl you answer them now please. [forum.wampserver.com]
---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-
---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-
Sorry, only registered users may post in this forum.
