Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

data inconsistency after adding index with ingest method #39308

Closed
Lily2025 opened this issue Nov 22, 2022 · 1 comment · Fixed by #39382 or #39473
Closed

data inconsistency after adding index with ingest method #39308

Lily2025 opened this issue Nov 22, 2022 · 1 comment · Fixed by #39382 or #39473
Assignees
Labels
feature/developing the related feature is in development severity/major type/bug The issue is confirmed as a bug.

Comments

@Lily2025
Copy link

Lily2025 commented Nov 22, 2022

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

@Lily2025 Lily2025 added the type/bug The issue is confirmed as a bug. label Nov 22, 2022
@Lily2025
Copy link
Author

/type bug
/severity major
/assign tangenta

@ti-chi-bot ti-chi-bot added severity/major may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 may-affects-6.4 labels Nov 22, 2022
@tangenta tangenta added feature/developing the related feature is in development and removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-6.0 may-affects-6.1 may-affects-6.2 may-affects-6.3 may-affects-6.4 labels Nov 22, 2022
@tangenta tangenta changed the title data inconsistency after adding index with ingest method and inject tidb restart data inconsistency after adding index with ingest method Nov 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature/developing the related feature is in development severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
3 participants