MySQL ib_logfile current_lsn < page_lsn 导致一查询就崩，如何恢复
问题描述
MySQL 5.7.21 业务表无法访问，select 业务表直接导致mysql crash，errorlog 里记录 [ERROR] InnoDB: Page [page id: space=49, page number=3] log sequence number 89266322606 is in the future! Current system log sequence number 89266322472.
此处为个人环境模拟复现的错误日志
2024-03-28T20:07:50.690100+08:00 0 [ERROR] InnoDB: Page [page id: space=49, page number=3] log sequence number 89266322606 is in the future! Current system log sequence number 89266322472.
2024-03-28T20:07:50.690140+08:00 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery.
