New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
MYSQL InnoDB: Missing MLOG_CHECKPOINT
Hello,
I'm facing that issues. I tried remove the ib_logfile0 vs ib_logfile1 and restart mysql but still failed. Someone can help me? Thanks.
Error log
2020-09-01 17:30:49 0 [Note] InnoDB: Using Linux native AIO
2020-09-01 17:30:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-09-01 17:30:49 0 [Note] InnoDB: Uses event mutexes
2020-09-01 17:30:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-09-01 17:30:49 0 [Note] InnoDB: Number of pools: 1
2020-09-01 17:30:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-09-01 17:30:49 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2020-09-01 17:30:49 0 [Note] InnoDB: Completed initialization of buffer pool
2020-09-01 17:30:49 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-09-01 17:30:49 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 973050640940 between the checkpoint 973050599515 and the end 973050640896.
2020-09-01 17:30:49 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-09-01 17:30:49 0 [Note] InnoDB: Starting shutdown...
2020-09-01 17:30:50 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-09-01 17:30:50 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-09-01 17:30:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-09-01 17:30:50 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-09-01 17:30:50 0 [ERROR] Aborting
Regards,
Comments
Mmm, did you compiled SQL with InnoDB support by hand or just package installed?
i installed MariaDB via aapanel.com
Re-install MariaDB. If you can connect to mysql run this:
SHOW ENGINES\G
After restart. i got this error