| Bug #32662 | Missleading error message when trying to create already existing tablespace | ||
|---|---|---|---|
| Submitted: | 23 Nov 2007 15:04 | Modified: | 10 Feb 2009 18:12 |
| Reporter: | Hartmut Holzgraefe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Cluster: Disk Data | Severity: | S3 (Non-critical) |
| Version: | 5.1.22, 5.1.18-ndb-6.2.2 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[22 Apr 2008 8:29]
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/45802 ChangeSet@1.2574, 2008-04-22 16:01:26+00:00, lzhou@dev3-63.(none) +3 -0 BUG#32662 Return correct error message when creating an existed tablespace
[12 Dec 2008 6:35]
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/61440 2772 Leonard Zhou 2008-12-12 BUG#32662 Return correct error message when creating an existed tablespace
[5 Feb 2009 13:04]
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/65332 2811 Tomas Ulin 2009-02-05 Bug #32662 Missleading error message when trying to create already existing tablespace
[5 Feb 2009 13:06]
Jon Stephens
Is there some reason we can't say "Tablespace already exists"? This fix makes it sound like you can't have any two DB objects with the same name, regardless of their types.
[9 Feb 2009 13:31]
Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090209132830-w61mvtd1a2msoqyn) (version source revid:tomas.ulin@sun.com-20090205130337-xhecf3w4zefiz714) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[10 Feb 2009 6:56]
Bugs System
Pushed into 5.1.31-ndb-6.3.23 (revid:jonas@mysql.com-20090210065305-s4i2e8obj0rhwfaq) (version source revid:jonas@mysql.com-20090210065305-s4i2e8obj0rhwfaq) (merge vers: 5.1.31-ndb-6.3.23) (pib:6)
[10 Feb 2009 7:00]
Tomas Ulin
6.2.17, 6.3.23, 6.4.3
[10 Feb 2009 16:23]
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/65774 2814 Martin Skold 2009-02-10 [merge] Merge
[10 Feb 2009 18:12]
Jon Stephens
Documented bugfix in the NDB-6.2.17, 6.3.23, and 6.4.3 changelogs as follows:
When attempting to create a tablespace that already existed, the
error message returned was Table or index with given
name already exists.
[10 Feb 2009 20:12]
Bugs System
Pushed into 6.0.10-alpha (revid:alik@sun.com-20090210194937-s7xshv5l3m1v7wi9) (version source revid:tomas.ulin@sun.com-20090209133412-hcxtkl63t1xcwj1t) (merge vers: 6.0.10-alpha) (pib:6)
[11 Feb 2009 12:34]
Bugs System
Pushed into 5.1.31-ndb-6.4.3 (revid:jonas@mysql.com-20090211123309-bda03zblogm4r2eu) (version source revid:jonas@mysql.com-20090211123309-bda03zblogm4r2eu) (merge vers: 5.1.31-ndb-6.4.3) (pib:6)
[11 Feb 2009 15:17]
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/65920 3252 Martin Skold 2009-02-11 [merge] Merge
[12 Feb 2009 10:06]
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/66011 2814 He Zhenxing 2009-02-12 [merge] Auto merge 6.0 -> 6.0-rpl

Description: An attempt to create an already existing tablespace fails as expected, the returned cluster error message is misleading though: Got error 721 'Table or index with given name already exists' from NDB It should probably be changed to "Object with given name already exists" as tables and indexes are not the only SQL objects within cluster anymore? How to repeat: CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE 2M ENGINE NDB; CREATE TABLESPACE ts_1 ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 32M ENGINE NDB; CREATE TABLESPACE ts_1 ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 32M ENGINE NDB; SHOW WARNINGS; Suggested fix: Change error message text to "Object with given name already exists"