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.

Sign up for GitHub

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

Jump to bottom

data inconsistency in table after upgrade tidb from 7.5 to nightly with enable tidb_enable_dist_task add index #48724

Closed
aytrack opened this issue Nov 20, 2023 · 0 comments · Fixed by #48737
Closed

data inconsistency in table after upgrade tidb from 7.5 to nightly with enable tidb_enable_dist_task add index #48724

aytrack opened this issue Nov 20, 2023 · 0 comments · Fixed by #48737
Labels
affects-7.5 component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development severity/critical type/bug The issue is confirmed as a bug.

Comments

@aytrack
Copy link
Contributor

aytrack commented Nov 20, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. deploy a 7.5 cluster with 3 tidb instances
  2. set global tidb_ddl_enable_fast_reorg=1; set global tidb_enable_dist_task=1;
  3. add index
  4. upgrade to nighty during add index
  5. admin check index

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

check index pass

3. What did you see instead (Required)

MySQL [(none)]> admin check index xxxxl idx1;
ERROR 8223 (HY000): data inconsistency in table: xxxxl, index: idx1, handle: 1224979098646354856, index-values:"handle: 1224979098646354856, values: [KindMysqlTime 2023-05-19 00:28:46 KindMysqlTime 2023-05-19 00:28:46 KindString 24f9537c-2448-4281-9a82-25e5f51701e3-1684398526273978778 KindString 909b17de-4305-4334-b38e-c902d6751638909b17de-4305-4334-b38 KindString 80 KindString f5f75195-d4ca-4ee2-adf7-b2852429fb7cf5f75195-d4ca-4ee2-ad KindString 2f5f650a-acde-4bb9-b773-be7be8f164512f5f650a-acd KindString fedf43

4. What is your TiDB version? (Required)

v7.5.0
nightly 3f94666
@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 Nov 20, 2023
@ti-chi-bot ti-chi-bot bot added 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 may-affects-7.5 labels Nov 20, 2023
@Benjamin2037 Benjamin2037 removed 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 Nov 20, 2023
@tangenta tangenta mentioned this issue Nov 21, 2023
Merged
13 tasks
@tangenta tangenta added feature/developing the related feature is in development affects-7.5 and removed may-affects-7.5 labels Nov 21, 2023
ti-chi-bot bot pushed a commit that referenced this issue Nov 21, 2023
@tangenta
ddl: init internal session with reorg info for dist tasks (#48737)
36e68a0 
close #48724
@ti-chi-bot ti-chi-bot mentioned this issue Nov 21, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Nov 21, 2023
@ti-chi-bot
ddl: init internal session with reorg info for dist tasks (#48737) (#…
8ff82ca 
…48747)

close #48724
@wjhuang2016 wjhuang2016 mentioned this issue Nov 22, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Nov 22, 2023
@wjhuang2016
ddl: fix add wrong timezone during adding index (#48805)
1cf2826 
ref #48724
@ti-chi-bot ti-chi-bot mentioned this issue Nov 22, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Nov 23, 2023
@ti-chi-bot
ddl: fix add wrong timezone during adding index (#48805) (#48819)
2b88d04 
ref #48724
@tangenta tangenta mentioned this issue Jul 12, 2024
Merged
18 tasks
@qiancai qiancai mentioned this issue Jul 17, 2024
Merged
18 tasks
This was referenced Jul 17, 2024
Merged
Merged
This was referenced Jul 25, 2024
Merged
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-7.5 component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ddl: init internal session with reorg info for dist tasks tangenta/tidb
3 participants
@aytrack @Benjamin2037 @tangenta