MySQL 无法启动 missing MLOG_CHECKPOINT between the checkpoint 785612362695 and the end 78561236
2021-09-14 07:59:26+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started.
2021-09-14 07:59:26+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2021-09-14 07:59:26+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started.
2021-09-14T07:59:27.119045Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-09-14T07:59:27.121110Z 0 [Note] mysqld (mysqld 5.7.28) starting as process 1 ...
2021-09-14T07:59:27.124357Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-09-14T07:59:27.124388Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-09-14T07:59:27.124393Z 0 [Note] InnoDB: Uses event mutexes
2021-09-14T07:59:27.124396Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-09-14T07:59:27.124400Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-14T07:59:27.124403Z 0 [Note] InnoDB: Using Linux native AIO
2021-09-14T07:59:27.124716Z 0 [Note] InnoDB: Number of pools: 1
2021-09-14T07:59:27.124883Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-09-14T07:59:27.126939Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-09-14T07:59:27.135691Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-14T07:59:27.138390Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-14T07:59:27.150766Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-09-14T07:59:27.152382Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 785612362695 and the end 785612362676.
2021-09-14T07:59:27.152413Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-09-14T07:59:27.752928Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-09-14T07:59:27.752962Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-09-14T07:59:27.752969Z 0 [ERROR] Failed to initialize builtin plugins
2021-09-14T07:59:27.752974Z 0 [ERROR] Aborting
2021-09-14T07:59:27.752991Z 0 [Note] Binlog end
2021-09-14T07:59:27.753080Z 0 [Note] Shutting down plugin 'CSV'
2021-09-14T07:59:27.755524Z 0 [Note] mysqld: Shutdown complete
删除data目录下的ib_logfile0和ib_logfile1重新启动就可以了