Re: Failed to start mysql due to start_lsn and ens_lsn issue

[Hanru Jacobs]

Hi Peter,

No, I have not followed "Point-in-Time Recovery Using Binary Log".

MySQL did not want to start after a power outage and I could not get it started at all so could not get into MySQL to do anything.

I have now started the server with innodb_force_recovery=6 , which is risky at best, all the tables and data seems to be there. If I restart with innodb_force_recovery=5 or less the same error is logged:
2022-08-04T13:42:01.248079Z 1 [ERROR] [MY-013881] [InnoDB] The redo log file ./#innodb_redo/#ib_redo27250 has start_lsn 445543588864 but expected 445648380928 (end_lsn of the previous redo log file).

From here I'm currently stuck, I did read somewhere that I can see and change the start_lsn number from within mysql but now that I'm in at least I can try to find that doc and see if I can find anything that might help.

If you perhaps have any idea what I should do next I'm all ears. :)

Regards
Hanru