ERROR 8214 (HY000): Cancelled DDL job, index creation was cancelled

Translated
1

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

Original topic: ERROR 8214 (HY000): Cancelled DDL job，创建索引被取消

| username: xingzhenxiang

[TiDB Usage Environment] Production Environment
[TiDB Version]
[Reproduction Path]
[Encountered Issues: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]
72d83f9a3ad07e08e02d2f1355c5e0a

2
| username: zhanggame1 | Original post link

First, check the logs.
Run admin show ddl jobs to see the DDL status.

3
| username: xingzhenxiang | Original post link

The image you provided is not accessible, and the attachment link appears to be broken or incomplete. Please provide the text content directly for translation.

4
| username: changpeng75 | Original post link

This return message is the information returned when the admin cancels the DDL operation. Is there an automated script that will cancel DDLs that run for too long?

5
| username: xingzhenxiang | Original post link

Thank you for the reminder, I killed the script myself.

6
| username: tidb狂热爱好者 | Original post link

That’s good.

7
| username: tidb狂热爱好者 | Original post link

You need to restart each TiDB node; it’s not possible to elect a DDL master.

8
| username: dba远航 | Original post link

It feels like a manual cancellation action.

9
| username: system | Original post link

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