Hi guys,
InnoDB: Error: trying to load index PRIMARY for table tmp/#sqlb96_11856_13e
InnoDB: but the index tree has been freed!
InnoDB: Index is corrupt but forcing load into data dictionary
InnoDB: Error: trying to load index “idx_cell_email_message_group_id” for table “tmp”."#sqlb96_11856_13e"
InnoDB: but the first index is not clustered!
I had an issue recently on one of our reporting servers where a reset (potentially whilst performing alters) occurred due to the server being completely starved of memory. In the process there were a few corrupted (normal) tables, and the temporary table above. I’ve managed to fix the other issues, but that one, I just can’t for the life of me fix.
I keep being redirected back to the InnoDB recovery page on MySQL (http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html), however the section on temporary tables doesn’t say much short of looking through the table monitor.
I’ve:
[LIST]
[]checked the filesystem to just in case the temp table existed on disk somewhere
[]checked the full output of InnoDB Table Monitor (as instructed in the URL above, however there was no mention of this table in its output)
[]tried creating a temporary table (as a long shot, and I’m guessing completely incorrect), with the same name.
[]tried innodb_force_recovery
[/LIST] Is there anything else I can do here?
Thanks, in advance!