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 index inconsistent after DDL owner change several times (at least twice) #44619

Closed
aytrack opened this issue Jun 13, 2023 · 0 comments · Fixed by #44760
Closed

data index inconsistent after DDL owner change several times (at least twice) #44619

aytrack opened this issue Jun 13, 2023 · 0 comments · Fixed by #44760
Assignees
@tangenta
Labels
affects-7.1 affects-7.2 severity/critical sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@aytrack
Copy link
Contributor

aytrack commented Jun 13, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. deploy a cluter with 3 tidb instance
  2. create a partition table and insert some data
  3. add index for the table use ingest mode.
  4. during add index, upgrade the cluster or resign the ddl owner several times, at least twice
  5. after cluster upgraded, admin check index

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

admin check index pass

3. What did you see instead (Required)

check index failed

error="[admin:8003]table count 10000800 != index(idx1) count 4666669"

图片

4. What is your TiDB version? (Required)

v7.1.0
@aytrack aytrack added type/bug The issue is confirmed as a bug. sig/sql-infra SIG: SQL Infra severity/critical labels Jun 13, 2023
@ti-chi-bot ti-chi-bot bot added 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.1 may-affects-6.5 may-affects-7.1 labels Jun 13, 2023
@aytrack aytrack added affects-7.1 and 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 may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. labels Jun 13, 2023
@tangenta tangenta mentioned this issue Jun 19, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jun 21, 2023
@tangenta
ddl/ingest: fix checkpoint resume when owner changes several times (#…
4ea0bc7 
…44760)

close #44619
This was referenced Jun 21, 2023
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue Jun 21, 2023
@ti-chi-bot
ddl/ingest: fix checkpoint resume when owner changes several times (#…
206ad38 
…44760) (#44863)

close #44619
ti-chi-bot bot pushed a commit that referenced this issue Jul 10, 2023
@ti-chi-bot
ddl/ingest: fix checkpoint resume when owner changes several times (#…
b774a1f 
…44760) (#44859)

close #44619
@tiancaiamao tiancaiamao mentioned this issue Jul 18, 2023
Merged
17 tasks
@tangenta tangenta mentioned this issue Nov 23, 2023
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tangenta tangenta

Labels
affects-7.1 affects-7.2 severity/critical sig/sql-infra SIG: SQL Infra 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/ingest: fix checkpoint resume when owner changes several times tangenta/tidb
3 participants
@aytrack @tangenta @ti-chi-bot