MySQL InnoDB log sequence number is in the future

Posted on November 29, 2021 at 12:58 pm

If you see this on /var/log/daemon.log:

[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
 
[ERROR] InnoDB: Page [page id: space=128, page number=621786] log sequence number 403934013668 is in the future! Current system log sequence number 36929011435.

According to this:

https://dba.stackexchange.com/a/46197

The only correct solution is to reinstall and restore from a backup.

The database cannot be modified, such as you may not be able to delete rows from a table.

You’re only real solution is to recover an old backup or reset the database.

Receive updates via email

Other Posts

Updated Posts