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 upgrade cluster during add index #46306

Closed
aytrack opened this issue Aug 22, 2023 · 0 comments · Fixed by #47818 or #47915
Closed

data inconsistency after upgrade cluster during add index #46306

aytrack opened this issue Aug 22, 2023 · 0 comments · Fixed by #47818 or #47915
Assignees
Labels
affects-7.4 affects-7.5 component/ddl This issue is related to DDL of TiDB. severity/critical type/bug The issue is confirmed as a bug.

Comments

@aytrack
Copy link
Contributor

aytrack commented Aug 22, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. deploy v7.1.1 cluster
  2. use sysbench prepare some data
  3. add index for table like alter table sbtest1.sbtest2 add index idxc (c, pad);
  4. upgrade cluster to nightly during there are some add index ddl jobs
  5. admin check table

2. What did you expect to see? (Required)

admin check table pass

3. What did you see instead (Required)

data inconsistency

 Error 8223 (HY000): data inconsistency in table: sbtest1, index: idxc, handle: 5124754, index-values:"" != record-values:"handle: 5124754, values: [KindString 38673002528-25600971624-71948429324
-58659400639-39619674072-72689661940-46931619766-35485836720-65999045955-23729785321 KindString 77020567172-40219855864-19765858460-92878780258-24513375010]"

4. What is your TiDB version? (Required)

before: v7.1.1
after: nightly 0c3bbc1

@aytrack aytrack added type/bug The issue is confirmed as a bug. severity/critical component/ddl This issue is related to DDL of TiDB. labels Aug 22, 2023
@ti-chi-bot ti-chi-bot bot added 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.1 may-affects-6.5 may-affects-7.1 labels Aug 22, 2023
@zimulala zimulala added affects-7.4 and removed 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.1 may-affects-6.5 affects-7.1 affects-7.4 labels Oct 20, 2023
@zimulala zimulala self-assigned this Oct 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.4 affects-7.5 component/ddl This issue is related to DDL of TiDB. severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
4 participants