Initial DB setup needed?
Posted by: gregss (---.wb04.wa.asp.telstra.net)
Date: August 01, 2018 01:26PM

I've installed WampServer64 3.1.3 and neither of the DB servers will run. They are failing to read some sort of data file. MySQL complains that "InnoDB: Header page consists of zero bytes in datafile: .\ibdata1", MariaDB is similar with "InnoDB: File (unknown): 'read' returned OS error 0."

Is there something that needs to be done to properly initialize these files? I haven't done anything after installing WampServer. I did verify that for MySQL, the ./ibdata1 file exists, but I can't tell if the contents are correct.

Gory details:
1 - Windows 10 Pro 1803 (build 17134.191) x64
2 - wampserver3.1.3_x64.exe was used to do the install.
3 - apache2.4.33
4 - PHP Version - there seem to be several; I can't tell if one of them is "active" or not
5 - mysql5.7.21
5a - 10.2.14-MariaDB
6 - WampServer icon is orange
a - Apache error log - no errors
b - MySQL error log
2018-08-01T10:28:24.749065Z 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-08-01T10:28:24.753371Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2018-08-01T10:28:24.757151Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2018-08-01T10:28:25.082768Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2018-08-01T10:28:25.084244Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-08-01T10:28:25.085780Z 0 [ERROR] Failed to initialize builtin plugins.
2018-08-01T10:28:25.087137Z 0 [ERROR] Aborting
b1 - MariaDB error log
2018-08-01 17:27:34 11416 [ERROR] InnoDB: Tried to read 512 bytes at offset 0, but was only able to read 0
2018-08-01 17:27:34 11416 [ERROR] InnoDB: File (unknown): 'read' returned OS error 0. Cannot continue operation
180801 17:27:34 [ERROR] mysqld got exception 0x80000003 ;
c - PHP error log - contains only "No error - Only to create the file"
d - The windows event viewer only had the same errors as above for MariaDB
7 - In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines?
127.0.0.1 localhost
::1 localhost
8 - n/a
9 - phpMyAdmin works but can't do anything because the db servers are not there
10 - exact errors quoted above
11 - Bitdefender AV, built-in Windows firewall
12 - E:\wamp64\
13 - No virtual hosts defined

Options: ReplyQuote
Re: Initial DB setup needed?
Posted by: RiggsFolly (Moderator)
Date: August 01, 2018 02:08PM

Hi,

Can I ask, did you do the installation under an Admin account?


See Point 2 of TROUBLESHOOTING TIPS

And also mentioned in WAMPServer 3 All you need to know

and I am fairly sure it is also mentioned in the first Install dialog

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.3 32bit & 64bit)
<Apache 2.4.29/2.2.31> <PHP 7.2/7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.19/5.6.39/5.5.28>
<MariaDB 10.2.14> <phpMyAdmin4.8.1> <MySQL Workbench 6.3.10>

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 MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Initial DB setup needed?
Posted by: gregss (---.wb04.wa.asp.telstra.net)
Date: August 02, 2018 05:01AM

Yes, the account I used is in the Administrators group.

I also right-clicked the install exe and selected "Run as Administrator." I got the UAC prompt, and answered yes, so as far as I can tell, it was done as an administrator.

Options: ReplyQuote
Re: Initial DB setup needed?
Posted by: Otomatic (Moderator)
Date: August 02, 2018 09:31AM

Hi,

Open a command windows as an administrator (The word Administrator must be in the title bar) and in this command windows, type:
fsutil fsinfo ntfsinfo e:
Put the result here.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.4 32 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
Wampserver 3.1.4 64 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
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: Initial DB setup needed?
Posted by: gregss (---.wb04.wa.asp.telstra.net)
Date: August 02, 2018 09:34AM

Here is the result:

NTFS Volume Serial Number : 0x54d8d96ad8d94abe
NTFS Version : 3.1
LFS Version : 1.1
Number Sectors : 0x000000002ba9f2ff
Total Clusters : 0x000000002ba9f2ff
Free Clusters : 0x00000000161784ce
Total Reserved : 0x000000000000137f
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 : 0x0000000017d00000
Mft Start Lcn : 0x00000000000c0000
Mft2 Start Lcn : 0x0000000015d4f97f
Mft Zone Start : 0x00000000146fdae0
Mft Zone End : 0x0000000014702a00
Max Device Trim Extent Count : 0
Max Device Trim Byte Count : 0x0
Max Volume Trim Extent Count : 62
Max Volume Trim Byte Count : 0x40000000
Resource Manager Identifier : 586A14E1-574D-11E5-AEE7-F46D04D0935D

Options: ReplyQuote
Re: Initial DB setup needed?
Posted by: Otomatic (Moderator)
Date: August 02, 2018 10:07AM

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.

In some very limited cases, MariaDB (which comes from MySQL) can run on a 4KN disk, but for you, this is not the case.
The only solution is to install Wampserver on a 512N or 512E disk. There is no other.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.4 32 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
Wampserver 3.1.4 64 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
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: Initial DB setup needed?
Posted by: gregss (---.wb04.wa.asp.telstra.net)
Date: August 02, 2018 10:24AM

Aha! That would explain it perfectly. The disk (a Western Digital My Passport Ultra 3TB USB disk) is indeed a 4K sector disk.

Options: ReplyQuote
Re: Initial DB setup needed?
Posted by: Otomatic (Moderator)
Date: August 02, 2018 12:17PM

Hi,

Could you give the exact and complete references of this hard disk.
I am looking for a 4KN disk to be able to carry out tests, but all those which I found so far are of very big capacity (8 to 15 Tcool smiley and are very expensive.
In addition, manufacturers do not put the factory format type (4KN, 512E or 512N) in the specifications. You need Sioux tricks to find that kind of information.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.4 32 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
Wampserver 3.1.4 64 bit - Apache 2.4.35 - PHP 7.2.11/7.1.23/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
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: Initial DB setup needed?
Posted by: gregss (---.wb04.wa.asp.telstra.net)
Date: August 02, 2018 05:10PM

Sure- I bought it on Amazon three years ago, here is the product page

[www.amazon.com]

The model number is WDBBKD0030BBK-NESN

There's a newer model that's cheaper, but it would be guessing to assume it's 4KN, although that seems to be the way the industry is headed, so it's probably a good guess.

Options: ReplyQuote


Sorry, only registered users may post in this forum.