List:General Discussion« Previous MessageNext Message »
From:walter harms Date:January 28 2013 12:01pm
Subject:log sequence number InnoDB: is in the future!?
View as plain text  
hi list,

i am using mysql 5.1.53.
after a crash i have the follwing error in my log:

130128 10:45:25  InnoDB: Error: page 61 log sequence number 0 2871649158
InnoDB: is in the future! Current system log sequence number 0 2494349480.
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.1/en/forcing-recovery.html
InnoDB: for more information.

according to the doc's at
http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
I need to restore the database from scratch (short version). What i do not understand is
what
exactly is broken ?  Whole DBM ? One Instance ? (mysqlcheck says all tables are ok).

Not all tables are INNODB. Is is possible to restore only immodb tables ? (Having fun with
forgein keys)

Or is there a better way to handle this ?

re,
 wh
Thread
log sequence number InnoDB: is in the future!?walter harms28 Jan
  • Re: log sequence number InnoDB: is in the future!?Andrew Moore28 Jan
    • Re: log sequence number InnoDB: is in the future!?walter harms28 Jan
      • Re: log sequence number InnoDB: is in the future!?Reindl Harald28 Jan
  • Re: log sequence number InnoDB: is in the future!?Manuel Arostegui28 Jan
    • Re: log sequence number InnoDB: is in the future!?walter harms28 Jan
      • Re: log sequence number InnoDB: is in the future!?Andrew Moore28 Jan
        • Re: log sequence number InnoDB: is in the future!?walter harms29 Jan
  • Re: log sequence number InnoDB: is in the future!?Larry Martell2 Feb
    • Re: log sequence number InnoDB: is in the future!?walter harms3 Feb
      • Re: log sequence number InnoDB: is in the future!?Larry Martell3 Feb
        • Re: log sequence number InnoDB: is in the future!?Reindl Harald3 Feb
        • Re: log sequence number InnoDB: is in the future!?Manuel Arostegui4 Feb
          • RE: log sequence number InnoDB: is in the future!?Benjamin Stillman4 Feb