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.
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.
[/LIST] Is there anything else I can do here?
Thanks, in advance!