Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.0.3
-
Fix Version/s: 10.0.4
-
Component/s: None
-
Labels:None
-
Environment: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'>.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Elena,
Yes every time a temporary table is dropped. I've attached the files.
Thanks.
Daisy
Is there any progress on this one? Thanks.
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!
Great!
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.