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:
    IdUserHostdbCommandTimeStateInfo
    5event_schedulerlocalhostDaemon8310Waiting on empty queue
    19rdsadminlocalhostSleep0
    21rdsadminlocalhostSleep1
    22rdsadminlocalhostSleep1
    25rdsadminlocalhostSleep252
    36root_user10.0.0.48:36768broken_dbSleep2404
    38root_user10.0.0.48:36788mysqlQuery2736Waiting for schema metadata lockDROP DATABASE broken_db
    47root_user10.0.0.48:36826mysqlQuery2346Waiting for schema metadata lockdrop DATABASE broken_db
    50root_user10.0.0.48:36854Query1990Waiting for schema metadata lockUSE broken_db
    51root_user10.0.0.48:36874mysqlQuery0initshow processlist
    52root_user10.0.0.48:36894mysqlQuery1042Waiting for schema metadata lockuse broken_db
    58root_user10.0.0.48:36922Query178Waiting for schema metadata lockuse broken_db
    59rdsadminlocalhostSleep7

where do I go from there?

1 Antwort
0
Akzeptierte Antwort

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.

beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen