wampmariadb not started Error code: 1057
Posted by: RFreund (---.lightspeed.cicril.sbcglobal.net)
Date: February 11, 2018 04:20PM

I just installed Wamp (new install) and I have an orange icon. I've went through the troubleshooting tips and all seems well except that the wampmariadb is not running and I receive error code: 1057.

Any assistance would be great. Let me know what other information you might need.

Thanks

Options: ReplyQuote
Re: wampmariadb not started Error code: 1057
Posted by: Otomatic (Moderator)
Date: February 11, 2018 05:23PM

Hi,

Please READ (and answer) BEFORE YOU ASK A QUESTION

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
PhPMyAdmin 4.7.7 - 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: wampmariadb not started Error code: 1057
Posted by: RFreund (---.lightspeed.cicril.sbcglobal.net)
Date: February 11, 2018 08:27PM

Sorry, got it.

1- Windows 10.0.16299 - 64bit
2- WAMP 3.1.0_x86
3- Apache 2.4.27
4- PHP 5.6.31
5- MySQL 5.7.19
5a- MariaDB 10.2.8
6- Wamp is Orange
6a- Apache Error Log: No errors reported. Last command is AH00354: Starting 64 worker threads.
6a- Apache access.log: no errors shown.
6b- MySQL error log:
2018-02-11T19:05:45.280342Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to [dev.mysql.com] for how to resolve the issue.
2018-02-11T19:05:45.285346Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2018-02-11T19:05:45.287348Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-02-11T19:05:45.591639Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-02-11T19:05:45.592640Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-02-11T19:05:45.593641Z 0 [ERROR] Failed to initialize plugins.
2018-02-11T19:05:45.594642Z 0 [ERROR] Aborting

6b1- MariaDB error log:
2018-02-11 13:05:45 11348 [Warning] InnoDB: Retry attempts for reading partial data failed.
2018-02-11 13:05:45 11348 [ERROR] InnoDB: Tried to read 512 bytes at offset 0, but was only able to read 0
2018-02-11 13:05:45 11348 [ERROR] InnoDB: File (unknown): 'read' returned OS error 0. Cannot continue operation
180211 13:05:45 [ERROR] mysqld got exception 0x80000003 ;

6c- No errors
7- local host is active
8- Yes, I have access to localhost
8a - no message at bottom
9 - No access to phpMyAdmin
Error: #2002 - No connection could be made because the target machine actively refused it. — The server is not responding (or the local server's socket is not correctly configured).
10 - OK
11 - Antivirus is Endpoint by ESET
12 - D:\wamp\ (note that this is my "storage drive" not my main hard drive that the OS is stored on)
13 - no virtual hosts yet.

Thanks again!

Options: ReplyQuote
Re: wampmariadb not started Error code: 1057
Posted by: RiggsFolly (Moderator)
Date: February 12, 2018 12:16AM

Hi,

Did you read the first dialog that the install shows to you?

Read all of this, but specifically the first page or so that talks about installing all Microsoft Visual C/C++ Redistributables

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.1.1 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.2/7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.19/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.7.7> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: wampmariadb not started Error code: 1057
Posted by: RFreund (---.lightspeed.cicril.sbcglobal.net)
Date: February 15, 2018 04:10AM

Hi thanks for the Reply Riggs.
I went back an reinstalled/repaired all MS VC redist. However, I still receive the same error.
Any further ideas?

Options: ReplyQuote
Re: wampmariadb not started Error code: 1057
Posted by: Otomatic (Moderator)
Date: February 15, 2018 09:12AM

Hi,

As your Wampserver install is d:\wamp\ do that:

Open a command windows "as an administrator" (The word administrator MUST be in the title bar) and type:
fsutil fsinfo volumeinfo d:
There MUST be the word "NTFS" in the result.
If there is no NTFS, it is not worth continuing, Wampserver can only work on an NTFS disk

We will now look at the characteristics of NTFS formatting as the sizes of physical and logical sectors, with the command:
fsutil fsinfo ntfsinfo d:
What is the result ?

To be able to give you a solution, do the same thing, but replace d: by c:

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
PhPMyAdmin 4.7.7 - 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 »



Edited 1 time(s). Last edit at 02/15/2018 12:10PM by Otomatic.

Options: ReplyQuote
Re: wampmariadb not started Error code: 1057
Posted by: RFreund (---.lightspeed.cicril.sbcglobal.net)
Date: February 17, 2018 04:41PM

Thanks for the reply. Below is the information that you requested.
D:\>fsutil fsinfo volumeinfo d:
Volume Name : Storage space
Volume Serial Number : 0xe08c9915
Max Component Length : 255
File System Name : NTFS
Is ReadWrite
Supports Case-sensitive filenames
Preserves Case of filenames
Supports Unicode in filenames
Preserves & Enforces ACL's
Supports file-based Compression
Supports Disk Quotas
Supports Sparse files
Supports Reparse Points
Returns Handle Close Result Information
Supports POSIX-style Unlink and Rename
Supports Object Identifiers
Supports Encrypted File System
Supports Named Streams
Supports Transactions
Supports Hard Links
Supports Extended Attributes
Supports Open By FileID
Supports USN Journal

D:\>fsutil fsinfo ntfsinfo d:
NTFS Volume Serial Number :        0x02e08c9de08c9915
NTFS Version   :                   3.1
LFS Version    :                   2.0
Number Sectors :                   0x000000002b857efa
Total Clusters :                   0x000000002b857efa
Free Clusters  :                   0x000000002a206974
Total Reserved :                   0x00000000000012be
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 :            0x000000002ff00000
Mft Start Lcn  :                   0x00000000000c0000
Mft2 Start Lcn :                   0x0000000000000002
Mft Zone Start :                   0x00000000010cf8e0
Mft Zone End   :                   0x00000000010d3b80
Max Device Trim Extent Count :     4294967295
Max Device Trim Byte Count :       0xffffffff
Max Volume Trim Extent Count :     62
Max Volume Trim Byte Count :       0xffffffff
Resource Manager Identifier :      81D66B64-4C2E-11E2-BE66-BC5FF46904E4

D:\>fsutil fsinfo ntfsinfo c:
NTFS Volume Serial Number :        0xa41a83641a83327a
NTFS Version   :                   3.1
LFS Version    :                   2.0
Number Sectors :                   0x000000000eceafff
Total Clusters :                   0x0000000001d9d5ff
Free Clusters  :                   0x000000000028f826
Total Reserved :                   0x0000000000002b97
Bytes Per Sector  :                512
Bytes Per Physical Sector :        512
Bytes Per Cluster :                4096
Bytes Per FileRecord Segment    :  1024
Clusters Per FileRecord Segment :  0
Mft Valid Data Length :            0x000000002b740000
Mft Start Lcn  :                   0x00000000000c0000
Mft2 Start Lcn :                   0x0000000000000002
Mft Zone Start :                   0x0000000001a7aa80
Mft Zone End   :                   0x0000000001a7b1e0
Max Device Trim Extent Count :     1024
Max Device Trim Byte Count :       0xffffffff
Max Volume Trim Extent Count :     62
Max Volume Trim Byte Count :       0x40000000
Resource Manager Identifier :      409013E0-4C2D-11E2-BBA8-9A59775E367F
 

Options: ReplyQuote
Re: wampmariadb not started Error code: 1057
Posted by: Otomatic (Moderator)
Date: February 17, 2018 07:14PM

Hi,

For your drive D:
Bytes Per Sector  :                4096
Bytes Per Physical Sector :        4096
Bytes Per Cluster :                4096
The size of logical sectors is the same as physical sectors and is 4096 bytes. This is called "4K native" and is called low-level formatting or factory formatting and cannot be changed by the user.
In many cases of native 4K formatting, Mysql and/or MariaDB can't work, especially for the InnoDB engine; don't ask me why, I don't know; that's a fact. It would seem that this is a misalignment between the beginning of the clusters and the beginning of the innoDB files.
It seems that Microsoft has corrected this problem with MySQL server, but it is unfortunately not the case with MySQL or MariaDB.

But, for your C: drire there is:
Bytes Per Sector  :                512
Bytes Per Physical Sector :        512
Bytes Per Cluster :                4096
This is called 512 Native (512N) formatting and is fully compatible with MySQL and MariaDB.
I can only advise you to uninstall Wampserver from your D: drive and install it on your c: drive.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
PhPMyAdmin 4.7.7 - 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 »



Edited 1 time(s). Last edit at 02/18/2018 05:52PM by Otomatic.

Options: ReplyQuote
Re: wampmariadb not started Error code: 1057
Posted by: RFreund (---.lightspeed.cicril.sbcglobal.net)
Date: February 18, 2018 01:23AM

Huh, interesting. So this 'formatting' would be dependent on the hard drive that I buy? or does it involve the operating system?

Thank you!

Options: ReplyQuote
Re: wampmariadb not started Error code: 1057
Posted by: Otomatic (Moderator)
Date: February 18, 2018 09:31AM

Hi,

> So this 'formatting' would be dependent on the hard drive that I buy?
Yes. it is "factory formatting".
Very few sellers, either online or in stores, give this information.
And this cannot be changed by the user.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
PhPMyAdmin 4.7.7 - 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: wampmariadb not started Error code: 1057
Posted by: Otomatic (Moderator)
Date: February 18, 2018 10:56AM

Hi,

To try to understand and solve this problem (I don't have a 4K Native hard drive), please do the following on your Wampserver installation on D: 4K native. I thank you for that.

We can try to create the MySQL data folder "by hand" and see what happens and, to avoid being bothered by MariaDB, we can start by not using it (temporarily) with Wampserver, so:
- Right-Click Wampmanager tray icon -> Wamp settings -> Allow MariaDB to uncheck it
We will now delete the MySQL service
- Left-Click Wampmanager tray icon -> MySQL -> Service administration -> Stop service
- Left-Click Wampmanager tray icon -> MySQL -> Service administration -> Remove service
And, to avoid having to spend time sorting out information from log files, we will empty them:
- Right-Click Wampmanager tray icon -> Tools -> Empty logs -> Empty all log files (Then y + Enter)

Exit Wampserver.

With Files Explorer, delete the totality of files and folders into wamp\bin\mysql\mysql5.7.19\data\ and the folder data itself.
Note: We delete the data folder because it was created by MySQL itself.
With Files explorer (Right-Click New) we create the data folder wamp\bin\mysql\mysql5.7.19\data\
Note: We create the data folder by the Windows system and not by MySQL
Exit Files Explorer

Open a command windows "as an administrator" (The word administrator MUST be in the title bar) on the folder wamp\bin\mysql\mysql5.7.19\bin\
In this command windows type :
mysqld.exe --initialize-insecure

This will recreate the content of data folder

Launch Wampserver (Icon will be not green)
(mysql.log should be empty)
Install MySQL service
- Left-Click Wampmanager tray icon -> MySQL -> Service administration -> Install service
(mysql.log should be empty)
Start MySQL service
- Left-Click Wampmanager tray icon -> MySQL -> Service administration -> Start/Resume service
Icon should be green now and there is no error in mysql.log
2018-02-18T10:01:37.841538Z 0 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=2539324
2018-02-18T10:01:37.950738Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2018-02-18T10:01:37.997538Z 0 [Warning] InnoDB: New log files created, LSN=2539324

This has just been done in real time on my J: disk, but it is not 4K native.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12
PhPMyAdmin 4.7.7 - 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 »



Edited 2 time(s). Last edit at 02/18/2018 05:54PM by Otomatic.

Options: ReplyQuote


Sorry, only registered users may post in this forum.