admin check failed with “Error 8223 (HY000): data inconsistency in table” after injection ddl owner network partition during adding index #54897
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
1、tidb_enable_dist_task='on' and use local sort
2、run sysbench
3、add index for one of table
4、injection ddl owner network partition during adding index
5、admin check index when adding index finish
operatorLogs:
[2024-07-25 01:21:36] ###### start adding index
ALTER TABLE sbtest1 ADD INDEX index_test_1721841696410(c)
[2024-07-25 01:21:36] ###### wait for ddl job finish
[2024-07-25 01:32:21] ###### ddl job finished
select job_id, job_type, state from information_schema.ddl_jobs where query = 'ALTER TABLE sbtest1 ADD INDEX index_test_1721841696410(c)'
jobId: 592, job type: add index /* ingest */, state: synced
add index done, it takes: 10m44.902441801s
[2024-07-25 01:32:21] ###### start admin check
admin check index sbtest1 index_test_1721841696410
2. What did you expect to see? (Required)
add can success and data correct
3. What did you see instead (Required)
data inconsistency after injection ddl owner network partition during adding index
admin check failed (Error 8223 (HY000): data inconsistency in table: sbtest1, index: index_test_1721841696410, handle: 35156822, index-values:"handle: 35156822, values: [KindString 75526682157-01257366551-39747214380-53310925015-19751162425-74886418288-77605459295-59361560241-00641688684-13158278592]" != record-values:"handle: 35156822, values: [KindString 68508141783-95917702052-94553662448-15398694339-20156684966-89431718493-64538361712-25100449307-05824713827-68668904998]")
4. What is your TiDB version? (Required)
./tidb-server -V
Release Version: v7.5.3
Edition: Community
Git Commit Hash: 710538b
Git Branch: HEAD
UTC Build Time: 2024-07-24 11:33:21
GoVersion: go1.21.10
Race Enabled: false
Check Table Before Drop: false
Store: unistore
2024-07-25T01:21:27.798+0800