database corruption (InnoDB: Error: page n:o stored in the page read in is 538976288, should be 3!)
Hi there,
woke up to this and no mysql server don't know what to do.
here is the full error:
InnoDB: ##########################################################
InnoDB: WARNING!
InnoDB: The log sequence number in ibdata files is higher
InnoDB: than the log sequence number in the ib_logfiles! Are you sure
InnoDB: you are using the right ib_logfiles to start up the database?
InnoDB: Log sequence number in ib_logfiles is 0 142154154, log
InnoDB: sequence numbers stamped to ibdata file headers are between
InnoDB: 1869768036 543780384 and 1869768036 543780384.
InnoDB: ##########################################################
081217 14:30:27 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
081217 14:30:27 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 142154154.
InnoDB: Doing recovery: scanned up to log sequence number 0 142154154
InnoDB: Error: page n:o stored in the page read in is 538976288, should be 3!
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 3.
InnoDB: You may have to recover from a backup.
081217 14:30:27 InnoDB: Page dump in ascii and hex (16384 bytes):
Subject
Views
Written By
Posted
database corruption (InnoDB: Error: page n:o stored in the page read in is 538976288, should be 3!)
3549
December 17, 2008 02:35PM
Sorry, you can't reply to this topic. It has been closed.
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.