Bug #29520 Drop tablespace appears to work, but doesn't when objects are in tablespace

• Submitted: 3 Jul 2007 13:41
• Modified: 11 Jul 2007 21:48
• Reporter: Robin Schumacher
• Status: Can't repeat
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[3 Jul 2007 13:41] Robin Schumacher

Description:
Attempt to drop tablespace with data in it appears to work, but really doesn't drop tablespace.  Should at least give error message. 

How to repeat:
*** tablespace rmstest2 has objects in it ***

mysql> drop tablespace rmstest2 engine=falcon;
Query OK, 0 rows affected (0.00 sec)

mysql> create table tester (c1 int) engine=falcon tablespace rmstest2;
Query OK, 0 rows affected (0.13 sec)

mysql> insert into tester values (1), (2);
Query OK, 2 rows affected (0.03 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from tester;
+------+
| c1   |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0.00 sec)

[3 Jul 2007 18:40] MySQL Verification Team

Thank you for the bug report. I was not able to repeat the behavior reported
with latest source server (see below), however the message error within the
mysql client is unknown error so maybe would be another bug report regarding
the error message:

c:\dev\6.0>bin\mysql -uroot gimf
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 6.0.1-alpha-nt Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create tablespace gimfdata1
    -> add datafile 'c:/dev/gimf1.fts'
    -> engine=falcon;
Query OK, 0 rows affected (0.17 sec)

mysql> create table tb1 (id serial, col1 char(20))
    -> tablespace gimfdata1 engine=falcon;
Query OK, 0 rows affected (0.37 sec)

mysql> insert into tb1 values (NULL,'test');
Query OK, 1 row affected (0.02 sec)

mysql> select * from tb1;
+----+------+
| id | col1 |
+----+------+
|  1 | test |
+----+------+
1 row in set (0.00 sec)

mysql> drop tablespace gimfdata1 engine=falcon;
ERROR 65433 (HY000): Unknown error -103
mysql>

070703 15:31:42 [Note] Event Scheduler: Loaded 0 events
070703 15:31:42 [Note] bin\mysqld-nt: ready for connections.
Version: '6.0.1-alpha-nt'  socket: ''  port: 3306  Source distribution
Exception: can't open file "c:\dev\6.0\data\falcon_master.fts": No such file or directory (2)
Exception: RegSetValue failed setting "c:\dev\6.0\data\falcon_master.fts"
IO::createFile: creating file "falcon_master.fts"
IO::createFile: creating file "c:\dev\6.0\data\falcon_user.fts"
IO::createFile: creating file "c:\dev\6.0\data\falcon_temporary.fts"
IO::createFile: creating file "c:\dev\gimf1.fts"
Transactions: 67 committed, 0 rolled back, 0 active, 0 post-commit
SerialLog: 0 reads, 68 writes, 4 transactions, 65 completed, 5 blocks, 1 windows
Activity on falcon_master.fts: 4945 fetches, 0 reads, 226 writes
Activity on c:\dev\gimf1.fts: 23 fetches, 0 reads, 12 writes
Activity on c:\dev\6.0\data\falcon_temporary.fts: 0 fetches, 0 reads, 4 writes
Activity on c:\dev\6.0\data\falcon_user.fts: 0 fetches, 0 reads, 4 writes
SerialLog: 0 reads, 1 writes, 1 transactions, 0 completed, 2 blocks, 1 windows
Activity on falcon_master.fts: 0 fetches, 0 reads, 2 writes
Exception: table space "GIMFDATA1" is not empty