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

The query may hang in IndexMerge executor when it's killed #45279

Closed
xzhangxian1008 opened this issue Jul 11, 2023 · 2 comments · Fixed by #45284
Closed

The query may hang in IndexMerge executor when it's killed #45279

xzhangxian1008 opened this issue Jul 11, 2023 · 2 comments · Fixed by #45284
Labels
affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.0 affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.2 severity/major sig/execution SIG execution type/bug The issue is confirmed as a bug.

Comments

@xzhangxian1008
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE reproduce (
    c1 int primary key,
    c2 int,
    c3 int,
    key ci2(c2),
    key ci3(c3)
);
  1. insert lots of rows about 100 million
  2. select * from reproduce where c1 in (0, 10, 20, 30, ...., 10000) or c2 in (0, 10, 20, 30, ...., 10000) // make this query run for a long time
  3. kill the query executed in step 3

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

Query should be successfully killed

3. What did you see instead (Required)

Query hang can not be successfully killed.

4. What is your TiDB version? (Required)

Commit Hash: dd60929

@xzhangxian1008 xzhangxian1008 added the type/bug The issue is confirmed as a bug. label Jul 11, 2023
@ti-chi-bot ti-chi-bot bot added 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 Jul 11, 2023
@guo-shaoge guo-shaoge added affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.0 affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.2 and removed 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 Jul 13, 2023
@guo-shaoge
Copy link
Collaborator

ignore some DMR(5.3, 6.3, 6.3)

@xzhangxian1008
Copy link
Contributor Author

/open

@seiya-annie seiya-annie removed affects-5.4 This bug affects the 5.4.x(LTS) versions. affects-6.1 This bug affects the 6.1.x(LTS) versions. labels Jul 27, 2023
@windtalker windtalker added the affects-6.1 This bug affects the 6.1.x(LTS) versions. label Mar 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-6.1 This bug affects the 6.1.x(LTS) versions. affects-6.5 This bug affects the 6.5.x(LTS) versions. affects-7.0 affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.2 severity/major sig/execution SIG execution type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants