Canceled a DDL but it won't finish, does anyone have a solution?

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

Original topic: 取消了一个ddl,一直结束不了,大家有啥解决方案没

| username: Running

| username: h5n1 | Original post link

admin show ddl to see if there are any errors?

| username: Running | Original post link

No errors.

| username: weixiaobing | Original post link

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.

| username: h5n1 | Original post link

It is estimated that this will require restarting all TiDB servers to resolve.

| username: tidb菜鸟一只 | Original post link

Which version of TiDB are you using?

| username: WalterWj | Original post link

Restarting the tidb-server can cause DDL to get stuck in several versions…

| username: Jellybean | Original post link

It looks like this is the case. After the preceding tasks are completed, the subsequent cancelling should become cancelled.

| username: Running | Original post link

The DDL for deletion is also in the queue.

| username: Running | Original post link

Oh, the business was almost paralyzed due to the lag, but it was finally resolved by a restart.

| username: h5n1 | Original post link

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.

| username: system | Original post link

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