Bug #33216 DROP TABLESPACE containing tables results in a vague error
Submitted: 13 Dec 2007 14:43 Modified: 5 May 2008 14:39
Reporter: Philip Stoev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.4 OS:Any
Assigned to: Sergey Vojtovich CPU Architecture:Any

[13 Dec 2007 14:43] Philip Stoev
Description:
DROP TABLESPACE fails, as it should, if the tablespace contains actual tables. However the error message is vague.

How to repeat:
mysql> create tablespace q add datafile 'z' engine = falcon;
Query OK, 0 rows affected (0.03 sec)
mysql> create table q1 (f1 integer) engine = falcon tablespace q;
Query OK, 0 rows affected (0.04 sec)
mysql> drop tablespace q engine = falcon;
ERROR 308 (HY000): Unknown error 308

Suggested fix:
Maybe there is an existing error code about "resource not empty" that this can be assigned to.
[13 Dec 2007 14:44] Philip Stoev
May be connected with last comment on Bug #29520.
[23 Jan 2008 11:37] 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/41145

ChangeSet@1.2787, 2008-01-23 15:35:05+04:00, svoj@mysql.com +6 -0
  BUG#33216 - DROP TABLESPACE containing tables results in a vague error
  
  Dropping Falcon tablespace that contains tables returns vague error.
  With this fix "Tablespace busy" message is returned.
[23 Jan 2008 16:52] Kevin Lewis
Sergey, Please change the error to say that the tablespace is not empty.  If we say that the tablespace is busy, it suggests that there is a transaction active in the tablespace.  But that is not the case. It is just that the tablespace is not empty.
[9 Apr 2008 11:05] 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/45118

ChangeSet@1.2633, 2008-04-09 15:02:59+05:00, svoj@mysql.com +7 -0
  BUG#33216 - DROP TABLESPACE containing tables results in a vague error
  
  Dropping Falcon tablespace that contains tables returns vague error.
  With this fix "Tablespace not empty" message is returned.
[10 Apr 2008 19:14] Bugs System
Pushed into 6.0.5-alpha
[5 May 2008 14:39] Paul DuBois
Noted in 6.0.5 changelog.

The error message was vague for attempts to drop a Falcon tablespace
that contained tables. Now the message "Tablespace busy" is returned.