Description:
There is a table based ndb_dd. Insert data into one until getting error 1114 'Table is full'.
Drop that table and recreate one again.
Try to insert same data.
Error 'Table is full', but in fact table is empty.
After dropping a table its data was not removed from tablespace.
How to repeat:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.14-beta-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create logfile group lg1 add undofile 'undofile.dat' initial_size 20M un
do_buffer_size 1M engine=ndb;
Query OK, 0 rows affected (9.65 sec)
mysql> create tablespace ts1 add datafile 'datafile.dat' use logfile group lg1
initial_size 1K engine=ndb;
Query OK, 0 rows affected (1.55 sec)
mysql> use test;
Database changed
mysql> create table t1 (a int not null primary key, b varchar(500)) tablespace
ts1 storage disk engine=ndb;
Query OK, 0 rows affected (1.39 sec)
mysql> insert into t1 values(1, 'a');
Query OK, 1 row affected (0.02 sec)
mysql> insert into t1 values(2, 'b');
Query OK, 1 row affected (0.00 sec)
mysql> insert into t1 values(3, 'c');
ERROR 1114 (HY000): The table 't1' is full
mysql> drop table t1;
Query OK, 0 rows affected (3.15 sec)
mysql> create table t1 (a int not null primary key, b varchar(500)) tablespace
ts1 storage disk engine=ndb;
Query OK, 0 rows affected (1.48 sec)
mysql> insert into t1 values(1, 'a');
ERROR 1114 (HY000): The table 't1' is full
mysql>
