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 in table after injection one of tikv network partition during adding index #56733

Closed
Lily2025 opened this issue Oct 21, 2024 · 1 comment · Fixed by #57964
Assignees
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.4 affects-8.5 This bug affects the 8.5.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. impact/inconsistency incorrect/inconsistency/inconsistent severity/critical type/bug The issue is confirmed as a bug.

Comments

@Lily2025
Copy link

Lily2025 commented Oct 21, 2024

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 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

4. What is your TiDB version? (Required)

./tidb-server -V
Release Version: v8.4.0
Edition: Community
Git Commit Hash: ff1206c
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

@Lily2025 Lily2025 added the type/bug The issue is confirmed as a bug. label Oct 21, 2024
@Lily2025
Copy link
Author

/type bug
/severity critical

@jebter jebter added affects-8.4 component/ddl This issue is related to DDL of TiDB. labels Oct 21, 2024
@lance6716 lance6716 added affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. labels Oct 22, 2024
ti-chi-bot bot pushed a commit that referenced this issue Oct 22, 2024
@ti-chi-bot ti-chi-bot added the affects-8.5 This bug affects the 8.5.x(LTS) versions. label Nov 1, 2024
@ti-chi-bot ti-chi-bot bot closed this as completed in 6b17068 Dec 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. affects-8.4 affects-8.5 This bug affects the 8.5.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. impact/inconsistency incorrect/inconsistency/inconsistent severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants