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:
None 
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

[23 Nov 2007 15:04] Hartmut Holzgraefe
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"
[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