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

drop index blocked and caused that adding index job always queueing #52335

Closed
Lily2025 opened this issue Apr 3, 2024 · 2 comments · Fixed by #52381 or #52504
Closed

drop index blocked and caused that adding index job always queueing #52335

Lily2025 opened this issue Apr 3, 2024 · 2 comments · Fixed by #52381 or #52504
Assignees
@wjhuang2016
Labels
affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. priority/release-blocker This issue blocks a release. Please solve it ASAP. severity/critical type/bug The issue is confirmed as a bug.

Comments

@Lily2025
Copy link

Lily2025 commented Apr 3, 2024 •
edited
Loading

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1、run sysbench
2、inject one of tikv network partition during adding index and then drop index
from the tidb logs，may there was some fault on pd

logs：
endless-ha-test-add-index-tps-7563381-1-794.tar.gz

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

add index and drop index can success

3. What did you see instead (Required)

drop index blocked and caused that add index job queueing
img_v3_029j_e6e7b4c1-e210-4646-b2bb-50405b121deg

img_v3_029j_1338fe4a-eed5-4ea2-ae41-5409394a287g

4. What is your TiDB version? (Required)

./tidb-server -V
Release Version: v8.1.0-alpha
Edition: Community
Git Commit Hash: 3cfea6a
Git Branch: heads/refs/tags/v8.1.0-alpha
UTC Build Time: 2024-04-01 13:19:27
GoVersion: go1.21.6
Race Enabled: false
Check Table Before Drop: false
Store: unistore
@Lily2025 Lily2025 added the type/bug The issue is confirmed as a bug. label Apr 3, 2024
@Lily2025 Lily2025 changed the title drop index blocked and caused that add index job queueing drop index blocked and caused that adding index job queueing Apr 3, 2024
@Lily2025 Lily2025 changed the title drop index blocked and caused that adding index job queueing drop index blocked and caused that adding index job always queueing Apr 3, 2024
@Lily2025
Copy link
Author

Lily2025 commented Apr 3, 2024

/assign wjhuang2016

@Lily2025
Copy link
Author

Lily2025 commented Apr 3, 2024

/type bug
/severity critical

@jebter jebter added the component/ddl This issue is related to DDL of TiDB. label Apr 3, 2024
@wjhuang2016 wjhuang2016 mentioned this issue Apr 8, 2024
Merged
13 tasks
@wjhuang2016 wjhuang2016 added affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. and removed 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 Apr 8, 2024
@ti-chi-bot ti-chi-bot added the affects-8.1 This bug affects the 8.1.x(LTS) versions. label Apr 9, 2024
@ti-chi-bot ti-chi-bot bot closed this as completed in 312b69f Apr 9, 2024
This was referenced Apr 10, 2024
Merged
Merged
Merged
Merged
@wjhuang2016 wjhuang2016 added the priority/release-blocker This issue blocks a release. Please solve it ASAP. label Apr 10, 2024
@wjhuang2016 wjhuang2016 mentioned this issue Apr 12, 2024
Merged
13 tasks
3AceShowHand pushed a commit to 3AceShowHand/tidb that referenced this issue Apr 16, 2024
@wjhuang2016 @3AceShowHand
ddl: make sure put key into ETCD monotonously (pingcap#52381)
66f93c3 
close pingcap#47060, close pingcap#52335
ti-chi-bot bot pushed a commit that referenced this issue Apr 16, 2024
@wjhuang2016
ddl: fix unexpected delete ETCD value (#52504)
5bb8ed7 
close #47060, close #52335
@ti-chi-bot ti-chi-bot mentioned this issue Apr 16, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Apr 16, 2024
@ti-chi-bot
ddl: make sure put key into ETCD monotonously (#52381) (#52480)
43222f7 
close #47060, close #52335
ti-chi-bot bot pushed a commit that referenced this issue Apr 16, 2024
@ti-chi-bot
ddl: fix unexpected delete ETCD value (#52504) (#52651)
5009883 
close #47060, close #52335
This was referenced May 6, 2024
Merged
Merged
ti-chi-bot bot pushed a commit that referenced this issue May 9, 2024
@ti-chi-bot
ddl: fix unexpected delete ETCD value (#52504) (#53021)
c191831 
close #47060, close #52335
ti-chi-bot bot pushed a commit that referenced this issue May 9, 2024
@ti-chi-bot
ddl: make sure put key into ETCD monotonously (#52381) (#52483)
64ca76e 
close #47060, close #52335
ti-chi-bot bot pushed a commit that referenced this issue May 21, 2024
@ti-chi-bot
ddl: fix unexpected delete ETCD value (#52504) (#53022)
7af62de 
close #47060, close #52335
ti-chi-bot bot pushed a commit that referenced this issue May 28, 2024
@ti-chi-bot
ddl: make sure put key into ETCD monotonously (#52381) (#52482)
389e73c 
close #47060, close #52335
@ti-chi-bot ti-chi-bot mentioned this issue Jun 3, 2024
Merged
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jun 5, 2024
@ti-chi-bot
ddl: make sure put key into ETCD monotonously (#52381) (#52481)
60e6e0b 
close #47060, close #52335
ti-chi-bot bot pushed a commit that referenced this issue Jun 5, 2024
@ti-chi-bot
ddl: fix unexpected delete ETCD value (#52504) (#53738)
19731df 
close #47060, close #52335
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@wjhuang2016 wjhuang2016

Labels
affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.5 This bug affects the 7.5.x(LTS) versions. affects-8.1 This bug affects the 8.1.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. priority/release-blocker This issue blocks a release. Please solve it ASAP. severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
4 participants
@jebter @wjhuang2016 @ti-chi-bot @Lily2025