Bug #31379 | Incorrect error ERROR 1114 (HY000): The table '' is full | ||
---|---|---|---|
Submitted: | 3 Oct 2007 16:43 | Modified: | 20 May 2008 1:29 |
Reporter: | Diego Medina | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.41,5.0.45,5.1.22 | OS: | Linux (Fedora 7 i686) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[3 Oct 2007 16:43]
Diego Medina
[3 Oct 2007 16:54]
Diego Medina
I uploaded a compressed file under the name bug-data-31379.tar.gz
[3 Oct 2007 17:08]
Diego Medina
I saw that bug report and that's why I updated MySQL server to 5.0.45 and as I saw a different error I imagine it was not the same as on bug 27643 *********************** [3 Oct 18:59] Shane Bester possible duplicate of bug #27643 ?
[3 Oct 2007 23:11]
MySQL Verification Team
Thank you for the bug report. That error message with empty table name still happens with current source server: mysql> select version(); +--------------+ | version() | +--------------+ | 5.0.52-debug | +--------------+ 1 row in set (0.00 sec) mysql> UPDATE `data` -> RIGHT JOIN `temp` -> ON `data`.`item_id`=`temp`.`internal_part` -> -> JOIN `items` -> ON `items`.`internal_part`=`data`.`item_id` -> JOIN `temp` as `altkey_temp` -> ON altkey_temp.`altkey`=`items`.`altkey` -> SET `data`.`quantity_on_hand`=`data`.`quantity_on_hand`; ERROR 1022 (23000): Can't write; duplicate key in table '' mysql>
[4 Oct 2007 17:48]
Diego Medina
I just downloaded MySQL 5.1.22-rc and run the same test and this time it did give me a table name Error: 1000 Can't Write: duplicate key in table '/tmp/#sql_6007_0' I hope this may help you find / fix the bug.
[10 Oct 2007 1:50]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/35248 ChangeSet@1.2530, 2007-10-10 03:50:20+02:00, tnurnberg@sin.intern.azundris.com +3 -0 Bug#31379: Incorrect error ERROR 1114 (HY000): The table '' is full Table alias could be empty for tempory tables, making the error message look broken. We now print the path to the table in such cases.
[19 May 2008 19:50]
Sergey Petrunya
See also BUG#36676
[19 May 2008 20:23]
Sergey Petrunya
Trying on 5.0.60-debug, tip cset: ChangeSet@1.2609, 2008-04-19 22:21:51+05:00, gluh@mysql.com +1 -0 Bug#5299 Remove SHOW COLUMN TYPES result fix I get this: ERROR 1022 (23000): Can't write; duplicate key in table ''