Home > database >  Mysql start, stop, an error: InnoDB: an Assertion failure
Mysql start, stop, an error: InnoDB: an Assertion failure

Time:09-15

Version 8.0.12
Problem: mysql start, stop
Online information is mostly 5.7 processing method, the comparison method to modify my. Ini or cannot be started,


Log:
The T01:2019-12-05 kinds. The 401656 z 0 [System] [MY - 010116] [Server] D: \ soft \ mysql8.0.12 \ bin \ mysqld (mysqld 8.0.12) starting as the process of 4864
The 2019-12-05 T01:32:55. 432782 z 0 [ERROR] [MY - 000000] [InnoDB] InnoDB: an Assertion failure: trx0purge. Cc: 165: purge_sys - & gt; Iter. Trx_no & lt;=purge_sys - & gt; Rseg - & gt; Last_trx_no
InnoDB: thread 5892
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/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
01:32:55 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=131072
Max_used_connections=0
Max_threads=200
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=86998 K bytes of memory
Hope that 's ok. If not, decrease some variables in the equation.
  • Related