mysql 5.7启动报错:
2024-05-19T02:02:14.453082Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-05-19T02:02:14.453139Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-05-19T02:02:14.453543Z 0 [Note] D:\...\mysql-5.7.33-winx64\bin\mysqld (mysqld 5.7.33-log) starting as process 5544 ...
2024-05-19T02:02:14.498135Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-05-19T02:02:14.498510Z 0 [Note] InnoDB: Uses event mutexes
2024-05-19T02:02:14.498725Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2024-05-19T02:02:14.499030Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-19T02:02:14.499501Z 0 [Note] InnoDB: Number of pools: 1
2024-05-19T02:02:14.499804Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2024-05-19T02:02:14.502418Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-05-19T02:02:14.507594Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-19T02:02:14.534570Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-05-19T02:02:14.537235Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2500634944
2024-05-19T02:02:14.537573Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2500635022
2024-05-19T02:02:14.537901Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 2500634944 and the end 2500635022.
2024-05-19T02:02:14.538335Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-05-19T02:02:14.756294Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-05-19T02:02:14.756730Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-05-19T02:02:14.757020Z 0 [ERROR] Failed to initialize builtin plugins.
2024-05-19T02:02:14.757395Z 0 [ERROR] Aborting2024-05-19T02:02:14.757585Z 0 [Note] Binlog end
2024-05-19T02:02:14.757837Z 0 [Note] Shutting down plugin 'CSV'
2024-05-19T02:02:14.758262Z 0 [Note] D:\...\mysql-5.7.33-winx64\bin\mysqld: Shutdown complete
解决:
mysql-5.7.33-winx64\Data 下的 ib_logfile0、ib_logfile1 重命名ib_logfile0.bak、ib_logfile1.bak 然后启动就对了
网上说原因是:
1、突然断电关机或者不正常关机之后,DataEase 服务中的 MySQL 容器无法启动
标签:02,Note,end,05,checkpoint,报错,ERROR,InnoDB,19T02 From: https://www.cnblogs.com/xiaoruilin/p/18200098