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

concurrently truncating the same partition hangs DDL #26229

Closed
tangenta opened this issue Jul 14, 2021 · 1 comment · Fixed by #26232
Closed

concurrently truncating the same partition hangs DDL #26229

tangenta opened this issue Jul 14, 2021 · 1 comment · Fixed by #26232
Labels
affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. fixes-5.1.2 severity/major type/bug The issue is confirmed as a bug.

Comments

@tangenta
Copy link
Contributor

tangenta commented Jul 14, 2021

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Owner TiDB:

create table test.t (a int primary key) partition by range (a) (
  partition p0 values less than (10),
  partition p1 values less than (maxvalue)
);

Non-owner TiDBs run the following SQL concurrently:

alter table test.t truncate partition p0;

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

All the TRUNCATE statements can be executed successfully.

3. What did you see instead (Required)

DDL hangs. ADMIN SHOW DDL:

Err:[table:1735]Unknown partition 'drop?' in table 't', ErrCount:373, SnapshotVersion:0

4. What is your TiDB version? (Required)

master

commit 9abf9d0bb4f69b54a0282a7d9e89e23b91a54422 (upstream/master)
Author: tiancaiamao <tiancaiamao@gmail.com>
Date:   Tue Jul 13 18:33:32 2021 +0800

    *: reduce NewRuntimeStatsColl() object allocation (#26164)
@ti-srebot
Copy link
Contributor

Please edit this comment or add a new comment to complete the following information

Not a bug

  1. Remove the 'type/bug' label
  2. Add notes to indicate why it is not a bug

Duplicate bug

  1. Add the 'type/duplicate' label
  2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. fixes-5.1.2 severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants