Wamp2.4 - wampmysqld not starting on WIn10
Posted by: MotanuBob (---.iasi.fiberlink.ro)
Date: February 24, 2018 12:19PM

Hello,

I am using Wamp on different machines with Windows 10 Pro (installed on macbookpro with bootcamp) but now I have a strange issue with Wamp 2.4 64 bit (MySQL 5.6.12) on Win 10 Pro/Home (licenced).
- installed all Visual C++ packages
- run check_vcredist which says Äll VC++ packages needed for wampserver are installed correctly
- install WampServer as administrator in C:\wamp (clean install)
- run wampserver as administrator
result:
- tray icon is yellow
- wampapache service is running
- wampmysqld in not running

What I have tried:
- stop all services, delete files ib_logfile0, ib_logfile1, ib_data1, restart the services. No result
- make sure I have only one line 127.0.0.1 localhost
- IIS stoped
- adding innodb_flush_method=unbuffered in my.ini - no result
- adding innodb_flush_method=normal - no result


MySQL log looks as following:
2018-02-24 11:01:57 3536 [Note] Plugin 'FEDERATED' is disabled.
2018-02-24 11:01:57 3536 [Note] InnoDB: The InnoDB memory heap is disabled
2018-02-24 11:01:57 3536 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-02-24 11:01:57 3536 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-02-24 11:01:57 3536 [Note] InnoDB: Not using CPU crc32 instructions
2018-02-24 11:01:57 3536 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-02-24 11:01:57 3536 [Note] InnoDB: Completed initialization of buffer pool
2018-02-24 11:01:57 3536 [Note] InnoDB: Highest supported file format is Barracuda.
2018-02-24 11:01:57 2314  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
2018-02-24 11:01:57 2314  InnoDB: File name .\ib_logfile0
2018-02-24 11:01:57 2314  InnoDB: File operation call: 'aio read' returned OS error 187.
2018-02-24 11:01:57 2314  InnoDB: Cannot continue operation.


What else can I do?

Thank you!

Options: ReplyQuote
Re: Wamp2.4 - wampmysqld not starting on WIn10
Posted by: Otomatic (Moderator)
Date: February 24, 2018 04:50PM

Hi,

Wampserver 2.4 is no longer supported for a long time!

Is the disk on which Wampserver is installed properly formatted NTFS?

Suppose the letter assigned to the disk on which Wampserver is installed is C:
Open a command window "as administrator" (The word "administrator" must be in the title bar of the window.
In this window type the command:

fsutil fsinfo ntfsinfo c:

What is the result of this command?

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.35 - PHP 7.2.10/7.1.22/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.9
Wampserver 3.1.3 64 bit - Apache 2.4.35 - PHP 7.2.10/7.1.22/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.9
PhPMyadmin 4.8.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Wamp2.4 - wampmysqld not starting on WIn10
Posted by: MotanuBob (---.iasi.fiberlink.ro)
Date: February 24, 2018 05:18PM

Yes, I know is an old version but I have two productive machines running this version and is hard to change the version...

This is the result:

Microsoft Windows [Version 10.0.16299.15]
(c) 2017 Microsoft Corporation. All rights reserved.

C:\Windows\system32>fsutil fsinfo ntfsinfo c:
NTFS Volume Serial Number :        0x34f5ee1202469ff7
NTFS Version   :                   3.1
LFS Version    :                   2.0
Number Sectors :                   0x00000000017713ff
Total Clusters :                   0x00000000017713ff
Free Clusters  :                   0x00000000012b6822
Total Reserved :                   0x0000000000000d49
Bytes Per Sector  :                4096
Bytes Per Physical Sector :        4096
Bytes Per Cluster :                4096
Bytes Per FileRecord Segment    :  4096
Clusters Per FileRecord Segment :  1
Mft Valid Data Length :            0x000000001d600000
Mft Start Lcn  :                   0x0000000000000004
Mft2 Start Lcn :                   0x0000000000bb89ff
Mft Zone Start :                   0x00000000003e95e0
Mft Zone End   :                   0x00000000003f2d60
Max Device Trim Extent Count :     256
Max Device Trim Byte Count :       0xffffffff
Max Volume Trim Extent Count :     62
Max Volume Trim Byte Count :       0x40000000
Resource Manager Identifier :      6E5DD4BF-1942-11E8-80EC-AFA3A7DD8DCB

C:\Windows\system32>

Options: ReplyQuote
Re: Wamp2.4 - wampmysqld not starting on WIn10
Posted by: Otomatic (Moderator)
Date: February 24, 2018 05:30PM

Hi,

Bytes Per Sector  :                4096
Bytes Per Physical Sector :        4096

This is a factory formatted 4K Native type disc. (4KN)
MySQL does not work on this type of disk, only on 512 Native (512N - Bytes per sector 512, Bytes Per Physical Sector 512) or 512 Extended (512E - Bytes per sector 512, Bytes Per Physical Sector 4096).
Microsoft has made the necessary corrections for MySQL Server, but MySQL has still not done anything to make it work, even on recent versions (4.7.21 for example).

It may work with the latest versions of MariaDB, but since you are using Wampserver 2.4, you cannot install Wampserver 3 addons.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.35 - PHP 7.2.10/7.1.22/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.9
Wampserver 3.1.3 64 bit - Apache 2.4.35 - PHP 7.2.10/7.1.22/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.9
PhPMyadmin 4.8.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Wamp2.4 - wampmysqld not starting on WIn10
Posted by: MotanuBob (---.iasi.fiberlink.ro)
Date: February 24, 2018 06:00PM

Thank you very much!
I could not imagine this reason...

My temp solution is to use a 64GB USB flash drive where I installed Wamp. It works so far and hopefully I will not crash something and I wont have performance issues.

Options: ReplyQuote


Sorry, only registered users may post in this forum.