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

more than one add index ddl jobs triggered with ingest type #42903

Closed
seiya-annie opened this issue Apr 10, 2023 · 0 comments · Fixed by #43210
Closed

more than one add index ddl jobs triggered with ingest type #42903

seiya-annie opened this issue Apr 10, 2023 · 0 comments · Fixed by #43210
Assignees
Labels
affects-6.6 affects-7.0 affects-7.1 This bug affects the 7.1.x(LTS) versions. severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@seiya-annie
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

triggered add index ddl for 64 tables in very short time

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

only one ddl will use ingest type to add index

3. What did you see instead (Required)

mysql> admin show ddl jobs;
+--------+-------------------+------------+------------------------+----------------------+-----------+----------+-----------+---------------------+---------------------+---------------------+----------+
| JOB_ID | DB_NAME           | TABLE_NAME | JOB_TYPE               | SCHEMA_STATE         | SCHEMA_ID | TABLE_ID | ROW_COUNT | CREATE_TIME         | START_TIME          | END_TIME            | STATE    |
+--------+-------------------+------------+------------------------+----------------------+-----------+----------+-----------+---------------------+---------------------+---------------------+----------+
|    444 | sysbench_64_7000w | sbtest56   | add index /* ingest */ | write reorganization |        89 |      251 |  68420064 | 2023-04-10 07:11:06 | 2023-04-10 07:11:06 | NULL                | running  |
|    445 | sysbench_64_7000w | sbtest58   | add index /* ingest */ | write reorganization |        89 |      305 |  41898210 | 2023-04-10 07:11:06 | 2023-04-10 07:11:06 | NULL                | running  |
|    446 | sysbench_64_7000w | sbtest63   | add index /* ingest */ | write reorganization |        89 |      268 |         0 | 2023-04-10 07:11:06 | 2023-04-10 07:11:06 | NULL                | running  |
|    447 | sysbench_64_7000w | sbtest19   | add index /* ingest */ | delete only          |        89 |      247 |         0 | 2023-04-10 07:11:06 | 2023-04-10 07:11:06 | NULL                | running  |
|    448 | sysbench_64_7000w | sbtest57   | add index /* ingest */ | delete only          |        89 |      339 |         0 | 2023-04-10 07:11:06 | 2023-04-10 07:11:06 | NULL                | running  |
|    449 | sysbench_64_7000w | sbtest15   | add index /* ingest */ | delete only          |        89 |      232 |         0 | 2023-04-10 07:11:06 | 2023-04-10 07:11:06 | NULL                | running  |

4. What is your TiDB version? (Required)

master

@seiya-annie seiya-annie added the type/bug The issue is confirmed as a bug. label Apr 10, 2023
@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. 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 labels Apr 10, 2023
@seiya-annie seiya-annie added sig/sql-infra SIG: SQL Infra affects-6.6 affects-7.0 and removed may-affects-4.0 This bug maybe affects 4.0.x versions. 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-5.0 This bug maybe affects 5.0.x versions. may-affects-6.1 may-affects-6.5 labels Apr 10, 2023
@tangenta tangenta added affects-7.1 This bug affects the 7.1.x(LTS) versions. severity/major and removed severity/moderate labels Apr 20, 2023
@ti-chi-bot ti-chi-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. labels Apr 20, 2023
@ti-chi-bot ti-chi-bot added 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 labels Apr 20, 2023
@tangenta tangenta removed 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 labels Apr 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-6.6 affects-7.0 affects-7.1 This bug affects the 7.1.x(LTS) versions. severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants