Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.3
-
None
-
None
-
Linux pa1-lda-001.dev.tradingscreen.com 2.6.32-220.el6.x86_64 #1 SMP Tue Dec 6 19:48:22 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux
Description
After a temp table is created
mysql 23:45:02 [PA DEV 001] [tempdb] [3108]> create temporary table x ( a int);
|
Query OK, 0 rows affected (0.04 sec)
|
Dropping it like this
mysql 23:45:14 [PA DEV 001] [tempdb] [3108]> drop table x;
|
Query OK, 0 rows affected (0.00 sec)
|
seems to generate a warning message in the log
InnoDB: We removed now the InnoDB internal data dictionary entry
|
InnoDB: of table 130814 23:44:43 [Warning] Invalid (old?) table or database name '#sql577f_15c2_0'
|
`mysql_tmp`.<result 2 when explaining filename '#sql577f_15c2_0'>.
|
Attachments
Activity
Elena,
Yes every time a temporary table is dropped. I've attached the files.
Thanks.
Daisy
Hi,
Is it still reproducible on 10.0.4? There have been a lot of changes and bugfixes, including InnoDB-related, in that version, it might have fixed the problem you were experiencing.
Oh I just tested on 10.0.4 and it's gone. Looks like it's fixed in this version. Thanks!
Hi,
Do you mean that it happens every time when you create/drop a temporary table?
Please attach your cnf file(s) and the whole error log from the server start.
Thanks.