Bug #32662 Missleading error message when trying to create already existing tablespace
Submitted: 23 Nov 2007 16:04 Modified: 12 Dec 2008 7:35
Reporter: Hartmut Holzgraefe
Status: Patch pending
Category:Server: ClusterDD Severity:S3 (Non-critical)
Version:5.1.22, 5.1.18-ndb-6.2.2 OS:Any
Assigned to: li zhou Target Version:6.0
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