Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 一个ddl job 无法选取leader 就一直卡着了 我等了一天
Bug Report
Clearly and accurately describe the issue you found. Providing any steps to reproduce the problem can help the development team address the issue promptly.
The program backend is executing create table.
One of the two TiDB nodes in the cluster restarted itself a few days ago due to OOM.
A DDL job couldn’t select a leader and was stuck for a whole day.
Later, after restarting the two TiDB servers, it returned to normal.
show admin ddl job
You can see the table being created, but the table name is not visible, and the status shows canceling.
[TiDB Version]
6.3.0
[Impact of the Bug]
The corresponding table cannot be deleted or created.
Other tables are not affected.
[Possible Steps to Reproduce the Issue]
[Observed Unexpected Behavior]
[Expected Behavior]
[Related Components and Specific Versions]
[Other Background Information or Screenshots]
Such as cluster topology, system and kernel version, application app information, etc.; if the issue is related to SQL, please provide the SQL statements and related table schema information; if there are critical errors in the node logs, please provide the relevant node log content or files; if some business-sensitive information is inconvenient to provide, please leave contact information, and we will communicate with you privately.