Bug #16322 DD: drop tablespace before alter tablespace drop leaves cluster unstable
Submitted: 10 Jan 2006 0:04 Modified: 10 Jan 2006 7:44
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1.5-alpha OS:Linux (Linux)
Assigned to: Jonas Oreland CPU Architecture:Any

[10 Jan 2006 0:04] Jonathan Miller
Description:
Test Case:
mysql> CREATE LOGFILE GROUP lg1
    -> ADD UNDOFILE 'undofile.dat'
    -> INITIAL_SIZE 16M
    -> UNDO_BUFFER_SIZE = 1M
    -> ENGINE=NDB;
Query OK, 0 rows affected (1.44 sec)

mysql> CREATE TABLESPACE ts1
    -> ADD DATAFILE 'datafile.dat'
    -> USE LOGFILE GROUP lg1
    -> INITIAL_SIZE 12M
    -> ENGINE NDB;
Query OK, 0 rows affected (1.72 sec)

mysql> drop tablespace ts1 engine = ndb;
ERROR 1503 (HY000): Failed to drop TABLESPACE
mysql> alter tablespace ts1 drop datafile 'datafile.dat' engine = ndb;
ERROR 1507 (HY000): Failed to alter:  NO SUCH FILE

Time: Tuesday 10 January 2006 - 00:49:53
Status: Temporary error, restart node
Message: Internal program error (failed ndbassert) (Internal error, programming error or missing error message, please report a bug)
Error: 2343
Error data: tsman.cpp
Error object: TSMAN (Line: 393) 0x0000000c
Program: /home/ndbdev/jmiller/builds/libexec/ndbd
Pid: 746
Trace: /space/run/ndb_4_trace.log.1
Version: Version 5.1.5 (alpha)
***EOM***

Current byte-offset of file-pointer is: 568

Time: Tuesday 10 January 2006 - 00:49:54
Status: Temporary error, restart node
Message: Internal program error (failed ndbassert) (Internal error, programming error or missing error message, please report a bug)
Error: 2343
Error data: tsman.cpp
Error object: TSMAN (Line: 393) 0x0000000c
Program: /home/ndbdev/jmiller/builds/libexec/ndbd
Pid: 1116
Trace: /space/run/ndb_5_trace.log.1
Version: Version 5.1.5 (alpha)
***EOM***

How to repeat:
See Above

Suggested fix:
drop tablespace should return error when files have not been drop.
[10 Jan 2006 7:44] 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/837