-
Title
mysqld:InnoDB: Your database may be corrupt message -
Description
When checking the "Management server log the following messages appear:
"2012-11-28 13:44:57.077 INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:121128 13:44:57 InnoDB: Error: page 782885 log sequence number 76 2769370785
2012-11-28 13:44:57.077 INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:InnoDB: is in the future! Current system log sequence number 34 1811365340.
2012-11-28 13:44:57.077 INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:InnoDB: Your database may be corrupt or you may have copied the InnoDB
2012-11-28 13:44:57.077 INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:InnoDB: tablespace but not the InnoDB log files. See
2012-11-28 13:44:57.077 INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
2012-11-28 13:44:57.077 INFO [STDIN/mysqld] com.quest.nitro.db.EmbeddedDatabaseManager - STDIN/mysqld:InnoDB: for more information."Is the database corrupted?
-
Resolution
The above indicate a database corruption, the options are
1. To use db recovery tools - The DBA should have tools to test/repair integrity of the DB such as DBCC CHECKDB,
2. To restore from backup
3. Re-install if the above options failed.