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

add index for system tables takes a long time while upgrade cluster #49679

Closed
aytrack opened this issue Dec 21, 2023 · 0 comments · Fixed by #49629
Closed

add index for system tables takes a long time while upgrade cluster #49679

aytrack opened this issue Dec 21, 2023 · 0 comments · Fixed by #49629
Assignees
@zimulala
Labels
component/ddl This issue is related to DDL of TiDB. type/enhancement The issue or PR belongs to an enhancement.

Comments

@aytrack
Copy link
Contributor

aytrack commented Dec 21, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. deploy a v7.5.0 cluster and create a table with 5000 partition
  2. truncate the table
  3. during truncate the table , upgrade cluster to nightly

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

  1. upgrade cluster success

3. What did you see instead (Required)

  1. the system table add index takes a long time led tiup upgrade faied.
  2. you can see the user ddl are paused, but the system table add index takes about 2min.
    img_v3_0269_138ec116-0a84-4889-b066-4799c1332dcg

4. What is your TiDB version? (Required)

v7.5.0
@aytrack aytrack added type/bug The issue is confirmed as a bug. component/ddl This issue is related to DDL of TiDB. labels Dec 21, 2023
@zimulala zimulala self-assigned this Dec 21, 2023
@zimulala zimulala added type/enhancement The issue or PR belongs to an enhancement. and removed type/bug The issue is confirmed as a bug. labels Dec 21, 2023
@zimulala zimulala mentioned this issue Dec 21, 2023
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Dec 26, 2023
@zimulala
ddl: fix the optimization for the empty table(speed up) (#49629)
dc694a1 
close #49679, close #49682
This was referenced Dec 26, 2023
Closed
Merged
Merged
@MyonKeminta MyonKeminta mentioned this issue Jan 15, 2024
Closed
ti-chi-bot bot pushed a commit that referenced this issue Feb 18, 2024
@ti-chi-bot
ddl: fix the optimization for the empty table(speed up) (#49629) (#49816
5113789 
)

close #49679, close #49682
ti-chi-bot bot pushed a commit that referenced this issue Feb 22, 2024
@ti-chi-bot
ddl: fix the optimization for the empty table(speed up) (#49629) (#49815
99e2a21 
)

close #49679, close #49682
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@zimulala zimulala

Labels
component/ddl This issue is related to DDL of TiDB. type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ddl: fix the optimization for the empty table(speed up) zimulala/tidb
2 participants
@zimulala @aytrack