Re: InnoDB “log sequence in the future!” crashing, won't start

2011-11-07 Thread Karen Abgarian
Log sequence in the future means that, for whatever reason, the update in the data pages happened but update in the Innodb's log didn't.The InnoDB by itself, without backups, is not protected against media failures, and this happens to be just that. Innodb_force_recovery is not really a re

Re: InnoDB “log sequence in the future!” crashing, won't start

2011-11-06 Thread Reindl Harald
Am 06.11.2011 06:05, schrieb Kevin Wang: > I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql > start only outputs . . . . . . failed. I've narrowed it down to an issue > with InnoDB. The database starts when innodb_force_recovery = 5 and nothing > lower. When I "check

InnoDB “log sequence in the future!” crashing, won't start

2011-11-05 Thread Kevin Wang
I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when innodb_force_recovery = 5 and nothing lower. When I "check table" for my MyISAM tables, they check fine, but t