data inconsistency after adding index with ingest method #39308
Labels
feature/developing
the related feature is in development
severity/major
type/bug
The issue is confirmed as a bug.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
1、set @@global.tidb_ddl_enable_fast_reorg=1;
2、run tpcc or sysbench read_write
3、add index and after 1min,restart tidb1
4、stop workload
select count(1) from t use index (idx);
select count(1) from t ignore index (idx);
5、the count is inconsist
2. What did you expect to see? (Required)
use index and ignore index is inconsistent for table sbtest12, use index: 10007147, ignore index: 10003873

the count is the same of step 4
3. What did you see instead (Required)
the count is not the same of step 4
http://perf.pingcap.net:3000/d/WOw1JWmVk/ha-test-case-detail?orgId=1&refresh=10s&var-case_id=750084
4. What is your TiDB version? (Required)
./tidb-server -V
Release Version: v6.5.0-alpha
Edition: Community
Git Commit Hash: 028c5eb
Git Branch: heads/refs/tags/v6.5.0-alpha
UTC Build Time: 2022-11-21 11:13:49
GoVersion: go1.19.2
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: unistore
The text was updated successfully, but these errors were encountered: