Bug #33213 Wrong CREATE TABLESPACE error when using existing DATAFILE
Submitted: 13 Dec 2007 14:43 Modified: 8 Jan 11:22
Reporter: Philip Stoev
Status: Closed
Category:Server: Falcon Severity:S3 (Non-critical)
Version:6.0.4-BK OS:Any
Assigned to: Sergey Vojtovich Target Version:
Triage: D4 (Minor) / R3 (Medium) / E2 (Low)

[13 Dec 2007 14:43] Philip Stoev 
Description:
CREATE TABLESPACE with ENGINE = Falcon where DATAFILE already existed fails with error
"tablespace already exists", even if the tablespace did not exist before.

In addition, it is a gray area whether a file can be moved between tablespaces having
different names, so extra clarifications in the manual may be a good idea.

Possible leftover after BUG#29511.

How to repeat:
mysql> CREATE TABLESPACE t1 ADD DATAFILE 'f1' ENGINE = Falcon;
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLESPACE t2 ADD DATAFILE 'f1' ENGINE = Falcon;
ERROR 1656 (HY000): Tablespace 't2' already exists

Suggested fix:
Change error message to a more specific one stating the fact that the DATAFILE, rather
than the tablespace, already exists.

If neeeded, a clarification should be added to the manual if datafile migration from one
tablespace into another is supported.
[13 Dec 2007 17:31] Kevin Lewis 
Sergey, This is a 'wrong error message' bug in Falcon Tablespaces
[18 Apr 2008 14:03] 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/45600

ChangeSet@1.2643, 2008-04-18 16:00:35+05:00, svoj@mysql.com +13 -0
  BUG#33213 - Wrong CREATE TABLESPACE error when using existing DATAFILE
  
  Creating a tablespace with data file that already exist returns an
  error which states that the tablespace exist.
  
  With this fix error message states that the data file exist.
[22 Apr 2008 12:22] 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/45809

ChangeSet@1.2643, 2008-04-22 14:19:03+05:00, svoj@mysql.com +13 -0
  BUG#33213 - Wrong CREATE TABLESPACE error when using existing DATAFILE
  
  Creating a tablespace with data file that already exist returns an
  error which states that the tablespace exist.
  
  With this fix error message states that the data file exist.
[5 Aug 2008 18:44] Sergey Vojtovich 
Was pushed to 6.0.6.
[8 Jan 11:22] MC Brown 
A note has been added to the 6.0.6 changelog: 

When creating a new tablespace and specifying the name of an existing tablespace file, an
incorrect error message would be reported specifying that the tablespace already existed.
The error message has been updated to reflect the actual error.