Description:
mysql> show create table t;
nothing happens ... I pressed ctrl-c after 3 minutes
mysql> select count(*) from t;
also nothing happens for more then 3 minutes
mysql> delete from t;
nothing happens ...
mysql> drop table t;
nothing
mysql> \q
$ bin/mysql mydb
mysql> show create table t;
the same ... waiting until the end of the world. Also for "DROP" or "DELETE".
Looking to the data directory shows that table t exists.
Only a daemon restart let me drop the table.
How to repeat:
Tested with 5.1-bk:
mysql> create table t(id serial, num integer, t text);
mysql> insert into t(num, t) values(rand()*1000, 'abc');
mysql> insert into t(num, t) select rand()*1000, t from t;
do this until you have round about 4*10^6 rows in the table.
mysql> select * from t into outfile 'test';
mysql> delete from t;
This only needs a few seconds ...
mysql> load data infile 'test' into table t;
During this process:
$ kill -9 PID_FOR_MYSQL_CLI
$ bin/mysql mydb
mysql>show create table t;
you will see this hangs.
Suggested fix:
No idea
