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개 답변
0
수락된 답변

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.

답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠