MySQL fails on startup
Posted by: GaryMeer (---.lightspeed.livnmi.sbcglobal.net)
Date: March 24, 2015 11:04PM

I just installed the Wampserver on my computer. As per the instructions in reply to the posting by Tohoma of 2/16/2015. (I added a default-storage-engine=MYISAM" to my.ini).
I am still getting errors on the startup of MySQL. The errors in the mysql.log file are:

2015-03-24 17:40:54 7344 [Note] Plugin 'FEDERATED' is disabled.
2015-03-24 17:40:54 7344 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-24 17:40:54 7344 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-24 17:40:54 7344 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-24 17:40:54 7344 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-24 17:40:54 7344 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-24 17:40:54 7344 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-24 17:40:54 7344 [Note] InnoDB: Completed initialization of buffer pool
2015-03-24 17:40:54 7344 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-24 17:40:54 330 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2015-03-24 17:40:54 7344 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation

The errors in the php_error.log file are:
[24-Mar-2015 21:39:13 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'D:/wamp/bin/php/php5.5.12/ext/php_intl.dll' - The specified module could not be found.

in Unknown on line 0

[24-Mar-2015 21:39:13 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'D:/wamp/bin/php/php5.5.12/ext/php_ldap.dll' - The specified module could not be found.

in Unknown on line 0

[24-Mar-2015 21:39:13 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'D:/wamp/bin/php/php5.5.12/ext/php_intl.dll' - The specified module could not be found.

in Unknown on line 0

[24-Mar-2015 21:39:13 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'D:/wamp/bin/php/php5.5.12/ext/php_ldap.dll' - The specified module could not be found.

in Unknown on line 0


I am running Windows 8.1, 32 bit, Apache 2.4.9. MySQL 5.6.17 and PHP 5.5.12, all 32 bit and from the WAMP bundle I just downloaded and installed from [sourceforge.net]. The Wamp icon never appeared in the task bar.

Can someone let me know how to fix this?

Options: ReplyQuote
Re: MySQL fails on startup
Posted by: RiggsFolly (---.as43234.net)
Date: March 25, 2015 01:28AM

Hi,

Is this the first time you have started WAMPServer?

It looks like you have a INNODB database corruptio, setting default-storage-engine=MYISAM will not sure this.

Please state the full situation.

---------------------------------------------------------------------------------------------
(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-

Options: ReplyQuote
Re: MySQL fails on startup
Posted by: GaryMeer (---.lightspeed.livnmi.sbcglobal.net)
Date: March 25, 2015 03:04AM

Yes, this is the 1st time I have tried to use it. Prior to this my computer did not have php, apache, or MySQL. I am running win 8.1 on a custom built computer with an ASUS Z87-plus motherboard, an intel I7-47870K CPU, 2 Balistik sport 4Gb memory modules, and an assortment of disks, organized into a mirrored 1Tb C drive and a 1.5Tb raid D drive. I am up to date on all windows patches.The only database operations are those from the installation of WAMP and the attempts to run it.

Options: ReplyQuote
Re: MySQL fails on startup
Posted by: RiggsFolly (---.as43234.net)
Date: March 25, 2015 10:25AM

OK

You can try this, as you have nothing to loose database wise.

Make sure wampserver is stopped and that the 'wampmysqld' or 'wampmysqld64' service is not running.


delete these files



\wamp2.5vanilla\bin\mysql\mysql5.6.17\data\ib_logfile0
\wamp2.5vanilla\bin\mysql\mysql5.6.17\data\ib_logfile1
\wamp2.5vanilla\bin\mysql\mysql5.6.17\data\ibdata1
and any files of this type
\wamp2.5vanilla\bin\mysql\mysql5.6.17\data\mysql-bin.000001
\wamp2.5vanilla\bin\mysql\mysql5.6.17\data\mysql-bin.000002
etc


Launch WAMPServer, check it goes green, and then check the mysql error log again for errors.

---------------------------------------------------------------------------------------------
(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-

Options: ReplyQuote


Sorry, only registered users may post in this forum.