Skip to content

data inconsistency after adding index with ingest method #39308

@Lily2025

Description

@Lily2025

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
image

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

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions