tidb: client stuck when create table in metrics_schema

[D3Hunter]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use metrics_schema;
create table t(id int);

mysql> mysql> kill 7139;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>
mysql>
mysql> show processlist;
+------+------+-----------------+----------------+---------+------+------------+------------------------+
| Id   | User | Host            | db             | Command | Time | State      | Info                   |
+------+------+-----------------+----------------+---------+------+------------+------------------------+
| 7141 | root | 127.0.0.1:53157 | NULL           | Query   |    0 | autocommit | show processlist       |
| 7139 | root | 127.0.0.1:53044 | metrics_schema | Query   |  489 | autocommit | create table t(id int) |
+------+------+-----------------+----------------+---------+------+------------+------------------------+
2 rows in set (0.00 sec)

2. What did you expect to see? (Required)

success if tidb permit it, or fail

3. What did you see instead (Required)

stuck, and cannot be killed

4. What is your TiDB version? (Required)

tiup playground v5.4.0 --host 0.0.0.0 --without-monitor --tiflash 0

[D3Hunter]

client stuck too when create table in PERFORMANCE_SCHEMA