A DDL job is stuck because it cannot select a leader, and I've been waiting for a day

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 一个ddl job 无法选取leader 就一直卡着了 我等了一天

| username: tidb狂热爱好者

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.

| username: WalterWj | Original post link

How about manually restarting the tidb-server? :thinking:

| username: dxss-lee | Original post link

The issue I’m experiencing is very similar to yours.

| username: Billmay表妹 | Original post link

BUG confirmed

| username: wjhuang2016-PINGCAP | Original post link

Hello @tidb enthusiast, what exactly is the phenomenon of “unable to select leader”?

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.