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

TTL task will not be taken by other tidb after a failover #45022

Closed
lcwangchao opened this issue Jun 28, 2023 · 0 comments · Fixed by #45023
Closed

TTL task will not be taken by other tidb after a failover #45022

lcwangchao opened this issue Jun 28, 2023 · 0 comments · Fixed by #45023
Labels
affects-7.0 affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.2 severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@lcwangchao
Copy link
Collaborator

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. create TTL table
> set @@global.tidb_ttl_running_tasks=1;
> create table ttl(t timestamp default current_timestamp) TTL=`t`+interval 1 HOUR;

  1. Run select * from mysql.tidb_ttl_task to check whether the task is scheduled and in running state, kill the current tidb.

  2. Restart tidb to wait TTL job finished

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

The task should be taken by the restarted tidb and continue to run.

3. What did you see instead (Required)

The task will never recover and the TTL job will not finish forever

4. What is your TiDB version? (Required)

master
@lcwangchao lcwangchao added type/bug The issue is confirmed as a bug. severity/major labels Jun 28, 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 Jun 28, 2023
@lcwangchao lcwangchao added affects-7.0 affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-6.6 affects-7.2 sig/sql-infra SIG: SQL Infra 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 affects-6.6 labels Jun 28, 2023
@lcwangchao lcwangchao mentioned this issue Jun 28, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jun 28, 2023
@lcwangchao
ttl: fix a bug that a TTL task will not be taken by other tidb after …
8658a98 
…failover sometimes (#45023)

close #45022
@ti-chi-bot ti-chi-bot mentioned this issue Jun 28, 2023
Merged
12 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jun 29, 2023
@ti-chi-bot
ttl: fix a bug that a TTL task will not be taken by other tidb after …
44d13a3 
…failover sometimes (#45023) (#45039)

close #45022
@tiancaiamao tiancaiamao mentioned this issue Jul 18, 2023
Merged
17 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-7.0 affects-7.1 This bug affects the 7.1.x(LTS) versions. affects-7.2 severity/major sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
1 participant
@lcwangchao