Knowledgebase
Portal Home > Knowledgebase > Articles Database > InnoDB: MySQL and InnoDB data dictionaries are out of sync.
InnoDB: MySQL and InnoDB data dictionaries are out of sync.
Posted by o-dog, 04-04-2013, 02:22 AM Dear all, I can't connect to MySQL for a specific database, even from phpMyAdmin, i get the following error: #2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) The server is not responding (or the local server's socket is not correctly configured). In MySQL logs I see: 130404 1:18:09 InnoDB: MySQL and InnoDB data dictionaries are out of sync. InnoDB: Unable to find the AUTOINC column id in the InnoDB table strangedb/table. InnoDB: We set the next AUTOINC column value to 0, InnoDB: in effect disabling the AUTOINC next value generation. InnoDB: You can either set the next AUTOINC value explicitly using ALTER TABLE InnoDB: or fix the data dictionary by recreating the table. 130404 1:25:13 InnoDB: MySQL and InnoDB data dictionaries are out of sync. InnoDB: Unable to find the AUTOINC column id in the InnoDB table strangedb/table. InnoDB: We set the next AUTOINC column value to 0, InnoDB: in effect disabling the AUTOINC next value generation. InnoDB: You can either set the next AUTOINC value explicitly using ALTER TABLE InnoDB: or fix the data dictionary by recreating the table. 130404 1:25:13 InnoDB: Assertion failure in thread 139934538761984 in file handler/ha_innodb.cc line 8290 InnoDB: Failing assertion: auto_inc > 0 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/...-recovery.html InnoDB: about forcing recovery. I can confirm MySQL is working OK for all other tables. I have gone through the link about forcing recovery but I am not an MySQL ninja, I can `select * from strangedb.table;` OK and the content is listed, what would be the next steps to dump the data and reimport it to a fresh table? Is there anything else i need to look out for? Thanks in advance Last edited by o-dog; 04-04-2013 at 02:30 AM.
Posted by ClaudiuPopescu, 04-04-2013, 08:08 AM Maybe this will help: http://www.serveridol.com/2012/07/02...-innodb-table/ First of all backup your entire database. After you can start playing around with it.
Add to Favourites Print this Article
Also Read