-
Notifications
You must be signed in to change notification settings - Fork 5.9k
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
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
/type bug |
ti-chi-bot
bot
added
severity/critical
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
may-affects-7.5
may-affects-8.1
labels
Oct 21, 2024
Benjamin2037
removed
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
labels
Oct 21, 2024
13 tasks
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
13 tasks
This was referenced Dec 9, 2024
13 tasks
13 tasks
13 tasks
This was referenced Dec 10, 2024
This was referenced Jan 6, 2025
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.
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 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 TABLE
sbtest1
ADD 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_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
The text was updated successfully, but these errors were encountered: