MySQL Forums
Forum List  »  InnoDB

table space id
Posted by: Jacky Shu
Date: August 27, 2013 08:43AM

Hi, I'm trying to an InnoDB tablespace problem. I managed to created a new table has (in .ibd file) the same tablespace id as what's in InnoDB data dictionary. But now the error message is saying a different tablespace id in "memory cache"

* Tried drop db1, but that didn't solve the problem.
* Any way to clear the so called "tablesapce memory cache"?

Thanks.

Here is the error message:
130827 10:07:54 InnoDB: error: space object of table db1/tb1,
InnoDB: space id 581 did not exist memory. Retrying an open.
130827 10:07:54 InnoDB: Warning: trying to init to the tablespace memory cache
InnoDB: a tablespace 581 of name './db1/tb1.ibd',
InnoDB: but a tablespace 624 of the same name
InnoDB: already exists in the tablespace memory cache!

Options: ReplyQuote


Subject
Views
Written By
Posted
table space id
5830
August 27, 2013 08:43AM
2219
August 30, 2013 09:31AM
1595
August 30, 2013 09:48AM
1532
August 30, 2013 09:48AM
1335
August 30, 2013 01:41PM


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.