MySQL Forums
Forum List  »  InnoDB

Re: Failed to start mysql due to start_lsn and ens_lsn issue
Posted by: Jakub Lopuszanski
Date: August 10, 2022 08:55AM

> As I mentioned before it looks like all the data is there in the DB. Is it not possible to reset the counters on innodb and just start the innodb from scratch? Just removing the files does not have the desired result as the DB still knows about the #ib_redo#### files that is supposed to be in the var/lib/mysql/#innodb_redo# directory and does not boot. Is there no way that I can tell mysql to just start innodb from fresh?

*IF* you are sure that the tablespace contains all the changes from redolog (which I am not sure how you could establish, but say, you know you weren't doing any queries for several hours before the crash, or checked the contents of tables in the read-only mode and they seem consistent and up to date)
*THEN* you can remove all the redo log files from #innodb_redo directory, but *keep* the (empty) #innodb_redo directory itself.
Then you should be able to start the mysqld without any problem.
If this is not working, then please paste the error log.

As for the LVM configuration, thanks for sharing, I'll look into it later.

Options: ReplyQuote

Written By
Re: Failed to start mysql due to start_lsn and ens_lsn issue
August 10, 2022 08:55AM

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.