Skip to content

data inconsistency in table after injection one of tikv network partition during adding index #56733

@Lily2025

Description

@Lily2025

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1、enable tidb_enable_dist_task and global sort
2、run sysbench
3、add index for one table
4、injection one of tikv network partition

logs:
logs.zip

2. What did you expect to see? (Required)

admin check success

3. What did you see instead (Required)

admin check failed
admin check failed (Error 8223 (HY000): data inconsistency in table: sbtest1, index: index_test_1729177017422, handle: 34904611, index-values:"" != record-values:"handle: 34904611, values: [KindString 22819232683-65590422292-63271134372-34697476090-61344961071-33702946624-01334278487-33665526949-83071148098-02089169179]")
operatorLogs:
[2024-10-17 22:56:57] ###### start adding index
ALTER TABLE sbtest1 ADD INDEX index_test_1729177017422(c)
[2024-10-17 22:56:57] ###### wait for ddl job finish
[2024-10-17 23:29:24] ###### ddl job finished
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_1729177017422(c)'
jobId: 491, job type: add index /* ingest cloud */, state: synced
add index done, it takes: 32m27.423231672s
[2024-10-17 23:29:24] ###### start admin check
admin check index sbtest1 index_test_1729177017422

4. What is your TiDB version? (Required)

./tidb-server -V
Release Version: v8.4.0
Edition: Community
Git Commit Hash: ff1206c
Git Branch: HEAD
UTC Build Time: 2024-10-17 01:59:30
GoVersion: go1.23.2
Race Enabled: false
Check Table Before Drop: false
Store: unistore
2024-10-17T22:56:48.981+0800

Metadata

Metadata

Assignees

Labels

affects-7.5This bug affects the 7.5.x(LTS) versions.affects-8.1This bug affects the 8.1.x(LTS) versions.affects-8.4affects-8.5This bug affects the 8.5.x(LTS) versions.component/ddlThis issue is related to DDL of TiDB.impact/inconsistencyincorrect/inconsistency/inconsistentseverity/criticaltype/bugThe issue is confirmed as a bug.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions