Mysql Community server do not start on WIN10
Posted by: Filippo Berardo
Date: March 06, 2017 08:47AM

Hello i have a macbook with windows 10 on.

I try to install Mysql 64 bit through installer but when the service has to start, it doesen't starts.

this is my log, can you help me?
thank you.

LOG
2017-03-06T14:30:19.046438Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-06T14:30:19.046438Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-03-06T14:30:19.048443Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.17-log) starting as process 7316 ...
2017-03-06T14:30:19.060476Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-03-06T14:30:19.061479Z 0 [Note] InnoDB: Uses event mutexes
2017-03-06T14:30:19.062482Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-03-06T14:30:19.063484Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-06T14:30:19.064487Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2017-03-06T14:30:19.065490Z 0 [Note] InnoDB: Number of pools: 1
2017-03-06T14:30:19.066492Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-03-06T14:30:19.069500Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2017-03-06T14:30:19.071506Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-03-06T14:30:19.087553Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-03-06T14:30:19.090060Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2017-03-06T14:30:19.091422Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2017-03-06T14:30:19.296887Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-03-06T14:30:19.297890Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-03-06T14:30:19.298893Z 0 [ERROR] Failed to initialize plugins.
2017-03-06T14:30:19.299894Z 0 [ERROR] Aborting

2017-03-06T14:30:19.300897Z 0 [Note] Binlog end
2017-03-06T14:30:19.301900Z 0 [Note] Shutting down plugin 'CSV'
2017-03-06T14:30:19.302903Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete

2017-03-06T14:31:01.134514Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-06T14:31:01.134514Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-03-06T14:31:01.137285Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.17-log) starting as process 5476 ...
2017-03-06T14:31:01.147339Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-03-06T14:31:01.148342Z 0 [Note] InnoDB: Uses event mutexes
2017-03-06T14:31:01.149354Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-03-06T14:31:01.150352Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-06T14:31:01.151355Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2017-03-06T14:31:01.153360Z 0 [Note] InnoDB: Number of pools: 1
2017-03-06T14:31:01.154363Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-03-06T14:31:01.159021Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2017-03-06T14:31:01.160824Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-03-06T14:31:01.174281Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-03-06T14:31:01.175233Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2017-03-06T14:31:01.175233Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2017-03-06T14:31:01.378271Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-03-06T14:31:01.379278Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-03-06T14:31:01.380280Z 0 [ERROR] Failed to initialize plugins.
2017-03-06T14:31:01.380280Z 0 [ERROR] Aborting

2017-03-06T14:31:01.381283Z 0 [Note] Binlog end
2017-03-06T14:31:01.381283Z 0 [Note] Shutting down plugin 'CSV'
2017-03-06T14:31:01.383287Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete

2017-03-06T14:31:55.713146Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-06T14:31:55.713146Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-03-06T14:31:55.716159Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.17-log) starting as process 7676 ...
2017-03-06T14:31:55.723209Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-03-06T14:31:55.723209Z 0 [Note] InnoDB: Uses event mutexes
2017-03-06T14:31:55.724180Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-03-06T14:31:55.724180Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-06T14:31:55.725213Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2017-03-06T14:31:55.726184Z 0 [Note] InnoDB: Number of pools: 1
2017-03-06T14:31:55.726184Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-03-06T14:31:55.729192Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2017-03-06T14:31:55.730229Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-03-06T14:31:55.745544Z 0 [ERROR] InnoDB: Header page consists of zero bytes in datafile: .\ibdata1, Space ID:0, Flags: 0. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-03-06T14:31:55.746551Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.
2017-03-06T14:31:55.747553Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2017-03-06T14:31:55.949322Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-03-06T14:31:55.949322Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-03-06T14:31:55.950327Z 0 [ERROR] Failed to initialize plugins.
2017-03-06T14:31:55.950327Z 0 [ERROR] Aborting

2017-03-06T14:31:55.950327Z 0 [Note] Binlog end
2017-03-06T14:31:55.951364Z 0 [Note] Shutting down plugin 'CSV'
2017-03-06T14:31:55.951364Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql Community server do not start on WIN10
3499
March 06, 2017 08:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.