DDL statement stuck, ADMIN CANCEL failed

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

Original topic: ddl语句卡住,ADMIN CANCEL失败

| username: 像风一样的男子

I found that there are several DDLs in the database that have been stuck for several days.
ADMIN SHOW DDL JOBS; The result is shown in the figure below.


Using ADMIN CANCEL DDL JOBS 2972 to cancel the DDL reports an error: [admin:8224] DDL Job: 2972 not found
image

| username: lemonade010 | Original post link

Hasn’t this already been executed? The end_time column is the end time.

| username: 像风一样的男子 | Original post link

Indeed, I was mistaken…

| username: 濱崎悟空 | Original post link

Execution completed.

| username: zhanggame1 | Original post link

This works too.

| username: Kongdom | Original post link

  • synced: Indicates that the operation has been successfully executed and all TiDB instances have synchronized this state.

| username: ziptoam | Original post link

Execution completed.