Open Lily2025 opened 1 month ago
Please answer these questions before submitting your issue. Thanks!
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
admin check success
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
sbtest1
index_test_1729177017422
c
./tidb-server -V Release Version: v8.4.0 Edition: Community Git Commit Hash: ff1206c7799cf9c0cf422498bc9b3dc8a5d44013 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
/type bug /severity critical
Lily2025
commented
1 month ago Lily2025
commented
1 month ago
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
sbtest1ADD INDEXindex_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 TABLEsbtest1ADD INDEXindex_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_17291770174224. What is your TiDB version? (Required)
./tidb-server -V Release Version: v8.4.0 Edition: Community Git Commit Hash: ff1206c7799cf9c0cf422498bc9b3dc8a5d44013 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