Skip to content

Aurora Serverless V2 doesn't drop the database on DROP.

0

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 processlistreturns 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?

1 Answer
0
Accepted Answer

I've solved the issue by killing all the processes with kill {ID} related to broken_db. I've then rebooted Aurora, and now the drop worked.

I don't have answer how/why it happened originally.

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.