Tuesday, 27 August 2013

unable to drop database in mysql

unable to drop database in mysql

When I try to drop a database it hangs up. The processlist shows:
20045 | root | localhost | NULL | Query | 4 | Waiting for table metadata
lock | drop database dbname1
There is no foreign key in entire database and there is no locking. Below
are the details for the same:
mysql>
mysql> select * from INNODB_LOCKS ;
Empty set (0.00 sec)
mysql> select * from INNODB_LOCK_WAITS ;
Empty set (0.01 sec)
I don't know why this happens, anyone has any ideas on the issue? I am
using MySQL 5.5.31-0ubuntu0.12.04.1-log (Ubuntu).

No comments:

Post a Comment