Skip navigation links

MySQL Forums :: MySQL Administrator :: ERROR 1033 (HY000): Incorrect information in file


Advanced Search

Re: ERROR 1033 (HY000): Incorrect information in file
Posted by: Boyd Hemphill ()
Date: November 18, 2008 10:52AM

I just encountered this problem after increasing the size of my innodb logs.

Here are some comments that may add up to a bug over time:

Version 5.0.45

1. I stopped MySQL
2. I changed the size of the innodb logs
3. I started MySQL (service mysqld start on Centos 5)

First problem
The startup failed and appeared to die after the creating of the first log. The message was that it timed out. It is interesting to note there was nothing in the error log.

Second problem
I repeat the action (service mysqld start). The second log is now there, and the server starts up. I log in and show databases. All is right and good in the world. I select * from an innodb table and "poof" I get the 1033 error.

Solution (not a very good one)
On a hunch I reboot the server. I then start mysql (service mysqld start) and viola .. all is truly right and good in the world.

The hunch I had was that the innodb dictionary was cached in memory and that restarting the server would completely clear it out.

I have successfully changed the size of my logs on two different hosts this way now. I am not sure it is a bug b/c my experience here is light and I am may be missing some esoteric step. So, if you experience the same thing, please consider a bug report.

Options: ReplyQuote


Subject Written By Posted
ERROR 1033 (HY000): Incorrect information in file Anuj Goel 10/11/2007 07:52AM
Re: ERROR 1033 (HY000): Incorrect information in file Stu Derby 10/28/2007 02:14PM
Re: ERROR 1033 (HY000): Incorrect information in file Boyd Hemphill 11/18/2008 10:52AM
Re: ERROR 1033 (HY000): Incorrect information in file Mohid Khan 03/19/2009 10:41PM


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.