pingcap / pingcap/tidb

add index rollback when kill ddl owner

Open
#62,826 3 comments 0 reactions 1 assignee Claimed by @joechenrh View on GitHub
affects-7.5 affects-8.1 affects-8.5 affects-9.0 component/ddl contribution severity/major type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)
1、run sysbench
2、add index for one table without DXF
3、kill ddl owner

### 2. What did you expect to see? (Required)
add index can succeed

### 3. What did you see instead (Required)
add index failed with rollback

the state of ddl job is not synced (now: 2025-08-04 16:21:34, jobId: 417, job type: add index /* ingest */, state: rollback done)
operatorLogs:
[2025-08-04 15:47:58] ###### start adding index
ALTER TABLE `sbtest1` ADD INDEX `index_test_1754293678324`(`c`)
[2025-08-04 15:47:58] ###### wait for ddl job finish
[2025-08-04 16:21:34] ###### ddl job failed
select job_id, db_name, table_name, job_type, create_time, start_time, end_time, state, query from information_schema.ddl_jobs where query = 'ALTER TABLE `sbtest1` ADD INDEX `index_test_1754293678324`(`c`)'
jobId: 417, job type: add index /* ingest */, state: rollback done"

### 4. What is your TiDB version? (Required)
./tikv-server -V
TiKV
Release Version: 7.5.7
Edition: Community
Git Commit Hash: 3d2fddcc78618dec5aa1f4a29eba4ccf209e590e
Git Commit Branch: HEAD
UTC Build Time: 2025-08-01 11:34:37
Rust Version: rustc 1.67.0-nightly (96ddd32c4 2022-11-14)
Enable Features: pprof-fp jemalloc mem-profiling portable sse test-engine-kv-rocksdb test-engine-raft-raft-engine cloud-aws cloud-gcp cloud-azure
Profile: dist_release
2025-08-04T15:32:37.552+0800

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.