admin check failed with “Error 8223 (HY000): data inconsistency in table” after tidb rolling restart during adding index #53910
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
1、tidb_enable_dist_task='on'
2、run sysbench
3、add index for one of table
4、tidb rolling restart
5、admin check index when adding index finish
2. What did you expect to see? (Required)
admin check success
3. What did you see instead (Required)
admin check failed with “Error 8223 (HY000): data inconsistency in table” after tidb rolling restart during adding index
operator logs：
admin check failed (Error 8223 (HY000): data inconsistency in table: sbtest5, index: index_test_1718052600990, handle: 35905355, index-values:"" != record-values:"handle: 35905355, values: [KindString 38761834057-51189930219-13436187456-78745883518-32558835324-50564221187-36700127441-77553179797-78566774399-28838186753]")
operatorLogs:
[2024-06-11 04:50:00] ###### start adding index
ALTER TABLE sbtest5 ADD INDEX index_test_1718052600990(c)
[2024-06-11 04:50:00] ###### wait for ddl job finish
[2024-06-11 04:52:31] ###### ddl job finished
select job_id, job_type, state from information_schema.ddl_jobs where query = 'ALTER TABLE sbtest5 ADD INDEX index_test_1718052600990(c)'
jobId: 597, job type: add index /* ingest */, state: synced
add index done, it takes: 2m30.304123625s
[2024-06-11 04:52:31] ###### start admin check
admin check index sbtest5 index_test_1718052600990
4. What is your TiDB version? (Required)
./tidb-server -V
Release Version: v8.2.0-alpha
Edition: Community
Git Commit Hash: 5c0d737
Git Branch: heads/refs/tags/v8.2.0-alpha
UTC Build Time: 2024-06-09 11:44:25
GoVersion: go1.21.10
Race Enabled: false
Check Table Before Drop: false
Store: unistore
2024-06-11T05:26:05.590+0800