Posts Tagged ‘ERROR’

ERROR 1033 (HY000): Incorrect information in file

February 26th, 2011

I got this error while restoring data from Netapp snapshot backup , I restored the last days backup

on a new directory on the NFS , after the restoring the MySQL data files from Netapp I tried to start

the mysql , MySQL Started , I noticed that queries are failing , on checking the error log

I got the error ERROR 1033 (HY000): Incorrect information in file for an Innodb table

I realised that I had not created the tmp file as per given in the my.cnf , I created the /tmp

file made mysql owner of the /tmp file , restarted the MySQL and error was gone.

the other possible reasons are
1) actual corruption of the table
2) Innodb plugin regsitration failed. reasons may be various

View Comments »

Posted in Mysql

Tags:

InnoDB: The InnoDB memory heap is disabled

July 29th, 2010

I enabled the innodb_plugin-1.0.4 made the necessary changes into the my.cnf file to bring the innodb plugin into the effect . Restarted MySQL and got the log entry into the MySQL error log InnoDB: The InnoDB memory heap is disabled , on some checking I got in this page (http://www.innodb.com/doc/innodb_plugin-1.0-doc-single/innodb-plugin.html#innodb-performance-use_sys_malloc) that I need to set
The value of innodb_use_sys_malloc as 0. so I made this entry innodb_use_sys_malloc =0 into the my.cnf and restarted the MySQL and the error was gone , happy MySQling

Thanks
Pankaj Joshi

View Comments »

Posted in Linux, Mysql

Tags: