Hello there,
I'm trying to drop a DB on the Aurora, but the requests just hangs. I've tried several times and the last attempt has been runnning for 600 seconds.
it's a tiny DB of 20MB gzipped.
- running
show databases;
returns the borken_db in the list.
- running
use broken_db;
now hangs too.
- running
show processlist
returns the following:
Id | User | Host | db | Command | Time | State | Info |
---|
5 | event_scheduler | localhost | | Daemon | 8310 | Waiting on empty queue | |
19 | rdsadmin | localhost | | Sleep | 0 | | |
21 | rdsadmin | localhost | | Sleep | 1 | | |
22 | rdsadmin | localhost | | Sleep | 1 | | |
25 | rdsadmin | localhost | | Sleep | 252 | | |
36 | root_user | 10.0.0.48:36768 | broken_db | Sleep | 2404 | | |
38 | root_user | 10.0.0.48:36788 | mysql | Query | 2736 | Waiting for schema metadata lock | DROP DATABASE broken_db |
47 | root_user | 10.0.0.48:36826 | mysql | Query | 2346 | Waiting for schema metadata lock | drop DATABASE broken_db |
50 | root_user | 10.0.0.48:36854 | | Query | 1990 | Waiting for schema metadata lock | USE broken_db |
51 | root_user | 10.0.0.48:36874 | mysql | Query | 0 | init | show processlist |
52 | root_user | 10.0.0.48:36894 | mysql | Query | 1042 | Waiting for schema metadata lock | use broken_db |
58 | root_user | 10.0.0.48:36922 | | Query | 178 | Waiting for schema metadata lock | use broken_db |
59 | rdsadmin | localhost | | Sleep | 7 | | |
where do I go from there?