MySQL 启动报错 Plugin 'InnoDB' init function returned error 解决方法

文章

林里克斯

排错能力。

报错信息

2020-11-15T11:51:34.188501Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-11-15T11:51:34.400868Z 0 [Note] mysqld (mysqld 5.7.22) starting as process 1 ...
2020-11-15T11:51:34.403721Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-11-15T11:51:34.403732Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-11-15T11:51:34.403734Z 0 [Note] InnoDB: Uses event mutexes
2020-11-15T11:51:34.403736Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-11-15T11:51:34.403737Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-11-15T11:51:34.403756Z 0 [Note] InnoDB: Using Linux native AIO
2020-11-15T11:51:34.403905Z 0 [Note] InnoDB: Number of pools: 1
2020-11-15T11:51:34.404012Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-11-15T11:51:34.404901Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-11-15T11:51:34.409392Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-15T11:51:34.410912Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-11-15T11:51:34.421908Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-11-15T11:51:34.422606Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3401589875
2020-11-15T11:51:34.422611Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3401590399
2020-11-15T11:51:34.422629Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 3401589875 and the end 3401590399.
2020-11-15T11:51:34.422634Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-11-15T11:51:35.023030Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-11-15T11:51:35.023042Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-11-15T11:51:35.023045Z 0 [ERROR] Failed to initialize builtin plugins.
2020-11-15T11:51:35.023046Z 0 [ERROR] Aborting

2020-11-15T11:51:35.023052Z 0 [Note] Binlog end
2020-11-15T11:51:35.023078Z 0 [Note] Shutting down plugin 'CSV'
2020-11-15T11:51:35.023610Z 0 [Note] mysqld: Shutdown complete

解决报错

$ pwd
/data/mysql/

$ ls -ltr
total 119884
-rw-r--r-- 1 mysql mysql       56 Aug 27  2019 auto.cnf
-rw-r--r-- 1 mysql mysql     1675 Aug 27  2019 server-key.pem
-rw-r--r-- 1 mysql mysql     1107 Aug 27  2019 server-cert.pem
-rw-r--r-- 1 mysql mysql      451 Aug 27  2019 public_key.pem
-rw-r--r-- 1 mysql mysql     1679 Aug 27  2019 private_key.pem
-rw-r--r-- 1 mysql mysql     1675 Aug 27  2019 client-key.pem
-rw-r--r-- 1 mysql mysql     1107 Aug 27  2019 client-cert.pem
-rw-r--r-- 1 mysql mysql     1107 Aug 27  2019 ca.pem
-rw-r--r-- 1 mysql mysql     1675 Aug 27  2019 ca-key.pem
drwxr--r-- 1 mysql mysql     2298 Aug 28  2019 mysql
drwxr--r-- 1 mysql mysql     6656 Aug 28  2019 sys
drwxr--r-- 1 mysql mysql     5638 Aug 28  2019 performance_schema
drwxr--r-- 1 mysql mysql     5932 Mar 29  2020 nextcloud
drwxr--r-- 1 mysql mysql      752 May 26 18:00 wordpress
drwxr--r-- 1 mysql mysql     4006 Jun  9 12:07 chevereto
drwxr--r-- 1 mysql mysql     3908 Aug 10 22:03 owncloud
drwxr--r-- 1 mysql mysql      828 Aug 11 17:22 typecho
drwxr--r-- 1 mysql mysql     2924 Aug 19 21:00 guacamole
drwxr--r-- 1 mysql mysql     9428 Aug 21 16:27 jumpserver
-rw-r----- 1 mysql mysql     2693 Nov  8 00:00 ib_buffer_pool
-rw-r----- 1 mysql mysql 50331648 Nov 15 19:54 ib_logfile1
-rw-r----- 1 mysql mysql 12582912 Nov 15 19:58 ibtmp1
-rw-r--r-- 1 mysql mysql 79691776 Nov 15 20:19 ibdata1
-rw-r----- 1 mysql mysql 50331648 Nov 15 20:19 ib_logfile0

ib_logfile0 ib_logfile1
将这两个文件删除再启动
$ rm /data/mysql/ib_logfile0
$ rm /data/mysql/ib_logfile1