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>
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) called
ib_logfileXwhere X is represented by a number under
C:\ProgramData\MySQL\MySQLServer\Data\ (for Linux:
InnoDB performs a checkpoint which helps determine which log files should be flushed.
Suggestion to fix:
- Restart the database service