After upgrading to 6.3, suddenly unable to create indexes. Strange

Translated
1

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

Original topic: 升级到6.3 突然发现无法创建索引了。奇怪

| username: tidb狂热爱好者

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Encountered Problem]
After upgrading to 6.3, suddenly unable to create indexes. Strange.
[Reproduction Path] What operations were performed to encounter the problem
[Problem Phenomenon and Impact]
MySQL [futures]> create index idx_ctime_bid_id_ask_id on co_trade_e(ctime,bid_id,ask_id);
ERROR 8214 (HY000): Cancelled DDL job

[Attachment]

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: zzzzzz | Original post link

The error code information: 错误码与故障诊断 | PingCAP 文档中心

It looks like it was canceled? You can check with admin show ddl jobs.

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

No one canceled.

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

Is there anyone who can help take a look?

5
| username: zzzzzz | Original post link

Try switching the TiDB DDL owner using the API: curl -X POST http://{TiDBIP}:10080/ddl/owner/resign

6
| username: Meditator | Original post link

You need to check the logs to see if it was indeed canceled?

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

This has been confirmed as a bug. Unable to create an index. But after deleting and re-importing the table, it works fine.