Link to home
Start Free TrialLog in
Avatar of ASP-TIMS
ASP-TIMS

asked on

mysql wont start afer power failure

Hi,
our mysql database server wont start after an unsuspected system shutdown. I can start the database with innodb_force_recovery = 4 and then i get the following lines on the .err file.

InnoDB: for more information.
121115 21:49:39  InnoDB: Error: page 1196090 log sequence number
366303858209
InnoDB: is in the future! Current system log sequence number 363674086422.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: for more information.
121115 21:49:39  InnoDB: Error: page 1196059 log sequence number
367805782117
InnoDB: is in the future! Current system log sequence number 363674086422.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: for more information.
Avatar of Chakravarthi Ayyala
Chakravarthi Ayyala
Flag of United States of America image

Did you refer the metalink note: InnoDB Error: "log sequence number is in the future" [ID 1416063.1]?
Looks like your situation is matching what is quoted there.
Avatar of ASP-TIMS
ASP-TIMS

ASKER

hi,
i dont really know what steps t otake next. Those logs were from the error file. Please advice.
ASKER CERTIFIED SOLUTION
Avatar of Chakravarthi Ayyala
Chakravarthi Ayyala
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi, im trying to use the query you mentioned but the database service stops when i run it. I found a table with problems but i cannot export it because the database stops unexpectedly