Home > OS >  Windows2012_mysql start up service, process terminated unexpectedly, at 1067, and here is the error
Windows2012_mysql start up service, process terminated unexpectedly, at 1067, and here is the error

Time:10-04

The 2017-08-17 T01:50:44. 770345 z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO SQL modes should be 2 with strict mode. They will be merged with strict mode in a future release.
The 2017-08-17 T01:50:44. 770345 z 0 [Note] C: \ Program Files \ MySQL \ MySQL Server 5.7 \ bin \ mysqld exe (mysqld 5.7.17 - log) starting as the process of 6024...
The 2017-08-17 T01:50:44. 770345 z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions provides
The 2017-08-17 T01:50:44. 770345 z 0 [Note] InnoDB: Uses the event mutexes
The 2017-08-17 T01:50:44. 770345 z 0 [Note] InnoDB: _mm_lfence () and _mm_sfence () are 2 for the memory barrier
The 2017-08-17 T01:50:44. 770345 z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
The 2017-08-17 T01:50:44. 770345 z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
The 2017-08-17 T01:50:44. 770345 z 0 [Note] InnoDB: Number of pools: 1
The 2017-08-17 T01:50:44. 770345 z 0 [Note] InnoDB: Not using CPU crc32 instructions
The 2017-08-17 T01:50:44. 785950 z 0 [Note] InnoDB: Initializing buffer pool, the total size=8 m, the instances=1, the chunk size=8 m
The 2017-08-17 T01:50:44. 785950 z 0 [Note] InnoDB: Completed initialization of buffer pool
The 2017-08-17 T01:50:44. 801575 z 0 [Note] InnoDB: Highest supported file format is Barracuda.
The 2017-08-17 T01:50:44. 801575 z 0 [Note] InnoDB: Log scan progressed past the checkpoint LSN 16369721
The 2017-08-17 T01:50:44. 801575 z 0 [Note] InnoDB: Doing recovery: scanned one log sequence number 16369749
The 2017-08-17 T01:50:44. 801575 z 0 [Note] InnoDB: Doing recovery: scanned one log sequence number 16369749
The 2017-08-17 T01:50:44. 801575 z 0 InnoDB [Note] : the Database was not shutdown normally!
The 2017-08-17 T01:50:44. 801575 z 0 [Note] InnoDB: Starting crash recovery.
The 2017-08-17 09:50:44 0 x66c InnoDB: an Assertion failure thread in 1644 in the file fut0lst. IC line 85
InnoDB: Failing an assertion: addr. Page==FIL_NULL | | addr. Boffset & gt;=FIL_PAGE_DATA
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated an assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB in tablespace. Both Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
01:50:44 UTC - mysqld got exception 0 x80000003;
This could be because you hit a bug. It is also possible that This binary
Or one of the libraries it was linked against is corrupt, improperly built,
Or misconfigured. This error can also be under caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
The collection process took fail.

Key_buffer_size=8388608
Read_buffer_size=16384
Max_used_connections=0
Max_threads=151
Thread_count=0
Connection_count=0
It is possible that mysqld could use one
Key_buffer_size + (read_buffer_size + sort_buffer_size) * max_threads=51099 K bytes of memory
Hope that 's ok. If not, decrease some variables in the equation.

Thread pointer: 0 x0
Attempting backtrace. You can use the following information to find out
Where mysqld died. If you see no messages after this, something went
Terribly wrong...
7 ff7f052fde2 mysqld. Exe! My_errno ()
7 ff7f08d9fc9 mysqld. Exe! My_wildcmp_mb ()
7 ff7f08d8ec0 mysqld. Exe! My_wildcmp_mb ()
7 ff7f0640f78 mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7f0794cf4 mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7f0797a96 mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7f07971de mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7f079f521 mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7f079ec73 mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7f069b1a0 mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7f06157fc mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7f0569bdc mysqld. Exe! ? Reserve @? $vector @ EV? @ STD @ @ @ $allocator @ E STD @ @ QEAAX_K @ Z ()
7 ff7efdf07fe mysqld. Exe! ? Ha_initialize_handlerton @ @ YAHPEAUst_plugin_int @ @ @ Z ()
7 ff7eff03d68 mysqld. Exe! ? Plugin_init @ @ YAHPEAHPEAPEADH @ Z ()
7 ff7eff0391b mysqld. Exe! ? Plugin_init @ @ YAHPEAHPEAPEADH @ Z ()
7 ff7efdc1015 mysqld. Exe! ? Init_connection_acceptor @? $Connection_acceptor @ VShared_mem_listener @ @ @ @ QEAA_NXZ ()
7 ff7efdc5e8e mysqld. Exe! ? Win_main @ @ YAHHPEAPEAD @ Z ()
7 ff7efdc3847 mysqld. Exe! ? Mysql_service @ @ YAHPEAX @ Z ()
7 ff7f08cbf93 mysqld. Exe! My_wildcmp_mb ()
7 ff7f08cc04c mysqld. Exe! nullnullnullnullnullnullnullnullnullnullnull
  • Related