Bug #32662 Missleading error message when trying to create already existing tablespace
Submitted: 23 Nov 2007 16:04 Modified: 10 Feb 19:12
Reporter: Hartmut Holzgraefe
Status: Closed
Category:Server: ClusterDD Severity:S3 (Non-critical)
Version:5.1.22, 5.1.18-ndb-6.2.2 OS:Any
Assigned to: Target Version:
Triage: Triaged: D4 (Minor)

[23 Nov 2007 16: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 10: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 7: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 14: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 14: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 14: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 7: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 8:00] Tomas Ulin
6.2.17, 6.3.23, 6.4.3
[10 Feb 17: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 19: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 21: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 13: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 16: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 11: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