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

[Jakub Lopuszanski]

> 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.