MySQL Forums
Forum List  »  InnoDB

Failed to start mysql due to start_lsn and ens_lsn issue
Posted by: Hanru Jacobs
Date: August 03, 2022 10:49AM

I had a unexpected reboot which after mysql does not want to start.

There are not many resources regarding the issue most are for backup/incremental backup issues. This was just a plain server power issue.

I was doing a restore on a table while this happened.

It seems to be the start_lsn and end_lsn issue that is stopping the mysql service from starting but it could be that I am mistaken.

Below is an excerpt from the error.log . This error just repeat in the log file.

2022-08-03T16:12:13.712370Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.22.04.1) starting as process 82787
2022-08-03T16:12:13.741801Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-08-03T16:12:13.993798Z 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).
2022-08-03T16:12:13.993905Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2022-08-03T16:12:14.391098Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2022-08-03T16:12:14.391463Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-03T16:12:14.391540Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-03T16:12:14.392751Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.22.04.1) (Ubuntu).

Options: ReplyQuote

Written By
Failed to start mysql due to start_lsn and ens_lsn issue
August 03, 2022 10:49AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.