Issue:
A faulted MySQL or MariaDB Database connection due to a startup error. The gateway's logs show the following error:
Error: InnoDB Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint <some log sequence number> and the end <another log sequence number>
Background:
A SQL database can fault for numerous reasons, but this error is specific to MySQL and MariaDB database connections.
InnoDB is a storage engine for the MySQL and MariaDB relational databases.
The redo log is a disk-based data structure in the InnoDB used during crash recovery to correct data written by incomplete transactions. This log records encoded requests to make changes to table data.
The redo log is represented by file(s) calledib_logfileX
where X is represented by a number under C:\ProgramData\MySQL\MySQLServer\Data\
(for Linux: /var/lib/mysql/
)
InnoDB performs a checkpoint which helps determine which log files should be flushed.
Suggestion to fix:
- Remove
ib_logfileX
files - Restart the database service
Sources:
https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log.html
Comments
0 comments
Please sign in to leave a comment.