Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 执行ddl严重bug
|
username: mono
[TiDB Usage Environment] Production Environment
[TiDB Version] 5.4.2
[Encountered Problem: Phenomenon and Impact]
All DDL executions indicate an exception, but they succeed. Checking DDL jobs reveals many in the queue. As follows:
mysql> create table t10 like t1;
ERROR 1317 (70100): Query execution was interrupted
mysql> show tables;
±---------------+
| Tables_in_mydb |
±---------------+
| t1 |
| t10 |
mysql> drop table t10;
ERROR 1317 (70100): Query execution was interrupted
mysql> show tables like ‘t10’;
Empty set (0.00 sec)
mysql> admin show ddl jobs;
±-------±---------±--------------------------------------±--------------±-------------±----------±---------±----------±--------------------±--------------------±----------+
| JOB_ID | DB_NAME | TABLE_NAME | JOB_TYPE | SCHEMA_STATE | SCHEMA_ID | TABLE_ID | ROW_COUNT | START_TIME | END_TIME | STATE |
±-------±---------±--------------------------------------±--------------±-------------±----------±---------±----------±--------------------±--------------------±----------+
| 502 | mydb | t10 | drop table | queueing | 63 | 500 | 0 | 2024-03-29 16:57:25 | 2024-03-29 16:57:25 | synced |
|
username: 
|
username: