Mani's Blog

March 30, 2012

InnoDB: Database page corruption on disk or a failed

Filed under: MySQL — mani @ 4:20 pm

I  ran into Database page corruption  error while I was restoring MySQL Xtrabackup.  Tried previous day backup then same errors.

Errors:

InnoDB: End of page dump
120329 17:59:38 InnoDB: Page checksum 1255360450, prior-to-4.0.14-form checksum 1044442903
InnoDB: stored checksum 1255360450, prior-to-4.0.14-form stored checksum 1429906423
InnoDB: Page lsn 512 461193189, low 4 bytes of lsn at page end 461874216
InnoDB: Page number (if stored to page already) 964,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 411
InnoDB: Page may be an index page where index id is 0 853
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 964.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption.
InnoDB: See also InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.
innobackupex-1.5.1: Error:
innobackupex-1.5.1: ibbackup failed at /usr/bin/innobackupex-1.5.1 line 464.

Solution:

Edit the file /etc/my.cnf and add parameter or variables  innodb_force_recovery=2 then apply the logs.  Everything went well.

Edit the file /etc/my.cnf and comment or remove innodb_force_recovery=2 then restart the mysql.

This seems to be fixed the issue.

 

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: