数据库断电无法重启
报错内容
[root@ctl01 ~]# more /var/log/mariadb/mariadb.log
2024-03-13 11:23:59 0 [Note] InnoDB: Using Linux native AIO
2024-03-13 11:23:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-03-13 11:23:59 0 [Note] InnoDB: Uses event mutexes
2024-03-13 11:23:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2024-03-13 11:23:59 0 [Note] InnoDB: Number of pools: 1
2024-03-13 11:23:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-13 11:23:59 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-03-13 11:23:59 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-13 11:24:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of
setpriority().
2024-03-13 11:24:00 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 135649212 between the checkpoint 135649212 and the end 135648768.
2024-03-13 11:24:00 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-03-13 11:24:00 0 [Note] InnoDB: Starting shutdown...
2024-03-13 11:24:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-03-13 11:24:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-03-13 11:24:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-13 11:24:00 0 [ERROR] Unknown/unsupported storage engine: innodb
2024-03-13 11:24:00 0 [ERROR] Aborting问题解决，尝试以下几点：
- 在主从上设置
innodb_log_checksums = ON - 删除
rm /var/lib/mysql/ib_logfile* - 重新启动