Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 取消了一个ddl,一直结束不了,大家有啥解决方案没

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 取消了一个ddl,一直结束不了,大家有啥解决方案没
From the screenshot, it seems that there are unfinished DDL tasks before this one. It is unclear whether the previous DDL has not finished, causing the canceled DDL to also be queued.
It is estimated that this will require restarting all TiDB servers to resolve.
Restarting the tidb-server can cause DDL to get stuck in several versions…
It looks like this is the case. After the preceding tasks are completed, the subsequent cancelling should become cancelled.
Oh, the business was almost paralyzed due to the lag, but it was finally resolved by a restart.
The status of Job 312 has always been “done” and cannot change to “synced,” which basically means the DDL is stuck and can only be resolved by restarting.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.