MySQL Forums
Forum List  »  InnoDB

Problems with temporary InnoDB tables after Crash
Posted by: Erich Jakubczyk
Date: September 18, 2012 01:20AM

I need help for a problem in InnoDB data dictionary....

For some time, the following messages appear in the error log after Server was crashed:

120914 2:47:43 InnoDB: Error: table 'tmp/#sql10e4_30dd_c'
InnoDB: in InnoDB data dictionary has tablespace id 610507,
InnoDB: but tablespace with that id or name does not exist. Have
InnoDB: you deleted or moved .ibd files?
InnoDB: This may also be a table created with CREATE TEMPORARY TABLE
InnoDB: whose .ibd and .frm files MySQL automatically removed, but the
InnoDB: table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.

I have read the instructions for the solution on the specified page.

I have created a file # sql10e4_30dd_c.frm in the directory /tmp of mysql and

"drop temporary table '#sql10e4_30dd_c' " performed.

But it did'nt work and mysql said that an Error occured and tablename is an unknown table in `information_schema`

How can I solve this Problem and clean up the entry.

Version of Mysql: 5.1.45
OS: Windows Server 2003

Thank you in advance for help



Edited 1 time(s). Last edit at 09/18/2012 01:37AM by Erich Jakubczyk.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems with temporary InnoDB tables after Crash
1944
September 18, 2012 01:20AM


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.