mysql 启动不了,报错InnoDB相关

2020-06-21T09:25:11.039291Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-06-21T09:25:11.048581Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29) starting as process 6440 ...
2020-06-21T09:25:11.058169Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-06-21T09:25:11.058289Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-06-21T09:25:11.058306Z 0 [Note] InnoDB: Uses event mutexes
2020-06-21T09:25:11.058318Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-06-21T09:25:11.058329Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-21T09:25:11.058341Z 0 [Note] InnoDB: Using Linux native AIO
2020-06-21T09:25:11.059280Z 0 [Note] InnoDB: Number of pools: 1
2020-06-21T09:25:11.059657Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-06-21T09:25:11.067945Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-06-21T09:25:11.100119Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-21T09:25:11.106322Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-06-21T09:25:11.135220Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-06-21T09:25:11.138564Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 1589128843 and the end 1589128704.
2020-06-21T09:25:11.138631Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-06-21T09:25:11.743088Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-06-21T09:25:11.743161Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-06-21T09:25:11.743178Z 0 [ERROR] Failed to initialize builtin plugins.
2020-06-21T09:25:11.743189Z 0 [ERROR] Aborting

删除/var/lib/mysql目录下的ib_logfile0和ib_logfile1重新启动就可以了

参考

https://spin.atomicobject.com/2011/05/09/mysql-failed-registration-of-innodb-as-a-storage-engine/

 

posted @ 2020-06-22 09:27  xuefy  阅读(1546)  评论(0编辑  收藏  举报