Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Your database may be corrupt or you may have copied the InnoDB

Status
Not open for further replies.

darwin101

Programmer
Mar 7, 2001
156
US
I am seeing the below message in the log file. The only reference I can find about it points to a bug. The link provided confuses me more.
I do not know what happened, I have just inherited this database and the entire error log file contains this message. I have not seen any other issues.

Do I have a problem or not is my question. and how do I fix it. Much thanks!

Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: InnoDB: for more information.



071128 8:23:15 InnoDB: Error: page 306 log sequence number 0 162040719
InnoDB: is in the future! Current system log sequence number 0 19295526.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: InnoDB: for more information.
 
Well, I cannot tell you what has happened either, but the URL the help is pointing to is clear enough. You may have some corrupt tables, so you would do good to the perform the suggested dump. You may (I do not know what state your server is in) be able to use the ANALYZE statement to see which tables are corrupt and which are not.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top