Aurora Serverless V2在DROP操作时不会删除数据库。

Question

【以下的问题经过翻译处理】 你好，

我尝试在Aurora上删除一个数据库，但是请求一直挂起。我已经尝试过几次，最后一次尝试已经运行了600秒。
这是一个20MB压缩的小型数据库。

* 运行 `show databases;` 在列表中返回了 borken\_db。
* 现在运行 `use broken_db;` 也挂起了。
* 运行 `show processlist` 返回如下结果：

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

Answer

【以下的回答经过翻译处理】 我通过杀死所有与 `kill {ID}` 相关的 broken\_db 进程来解决了这个问题。然后我重新启动了 Aurora，现在 drop 成功了。我不知道为什么/原因是什么。

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

Aurora Serverless V2在DROP操作时不会删除数据库。

Relevanter Inhalt