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 has unexpected timezone handling #52803

Closed
dveeden opened this issue Apr 22, 2024 · 3 comments
Closed

TTL has unexpected timezone handling #52803

dveeden opened this issue Apr 22, 2024 · 3 comments
Assignees
@lcwangchao
Labels
severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@dveeden
Copy link
Contributor

dveeden commented Apr 22, 2024 •
edited
Loading

Bug Report

When creating a table with TTL set to created_at + INTERVAL 1 MINUTE I would expect rows to be expired after a minute.

To make it easier to see what happens I have lowered the TTL_JOB_INTERVAL to one minute.

I have inserted rows with a created_at that are created:

  • now
  • 1, 2 and 3 hours in the future
  • 1, 2 and 3 hours in the past

Observations:

  1. The rows that have a created_at that are one or more hours in the past are removed directly
  2. The row that was created "now" is removed after 1 hour.
  3. The ttl_expire column of the mysql.tidb_ttl_job_history table is one hour in the past.

Note that system_time_zone is set to Europe/Amsterdam, which is UTC+0200 (CEST).

1. Minimal reproduce step (Required)

mysql> CREATE TABLE t1 (id INT PRIMARY KEY, created_at TIMESTAMP) TTL=created_at + INTERVAL 1 MINUTE TTL_ENABLE='ON' TTL_JOB_INTERVAL='1m';
Query OK, 0 rows affected (0.10 sec)

mysql> INSERT INTO t1 VALUES (1, CURRENT_TIMESTAMP);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO t1 VALUES (2, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO t1 VALUES (3, CURRENT_TIMESTAMP + INTERVAL 2 HOUR);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO t1 VALUES (4, CURRENT_TIMESTAMP + INTERVAL 3 HOUR);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO t1 VALUES (5, CURRENT_TIMESTAMP - INTERVAL 1 HOUR);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO t1 VALUES (6, CURRENT_TIMESTAMP - INTERVAL 2 HOUR);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO t1 VALUES (7, CURRENT_TIMESTAMP - INTERVAL 3 HOUR);
Query OK, 1 row affected (0.01 sec)

mysql> SELECT id, created_at, created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP, created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP, created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP FROM t1;
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
| id | created_at          | created_at + INTERVAL 1 MINUTE | CURRENT_TIMESTAMP   | created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP | created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
|  1 | 2024-04-22 08:34:38 | 2024-04-22 08:35:38            | 2024-04-22 08:35:35 |                                                  1 |                                                  1 |
|  2 | 2024-04-22 09:34:55 | 2024-04-22 09:35:55            | 2024-04-22 08:35:35 |                                                  1 |                                                  1 |
|  3 | 2024-04-22 10:35:02 | 2024-04-22 10:36:02            | 2024-04-22 08:35:35 |                                                  1 |                                                  1 |
|  4 | 2024-04-22 11:35:08 | 2024-04-22 11:36:08            | 2024-04-22 08:35:35 |                                                  1 |                                                  1 |
|  5 | 2024-04-22 07:35:19 | 2024-04-22 07:36:19            | 2024-04-22 08:35:35 |                                                  0 |                                                  0 |
|  6 | 2024-04-22 06:35:25 | 2024-04-22 06:36:25            | 2024-04-22 08:35:35 |                                                  0 |                                                  0 |
|  7 | 2024-04-22 05:35:31 | 2024-04-22 05:36:31            | 2024-04-22 08:35:35 |                                                  0 |                                                  0 |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
7 rows in set (0.00 sec)

mysql> SELECT id, created_at, created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP, created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP, created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP FROM t1;
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
| id | created_at          | created_at + INTERVAL 1 MINUTE | CURRENT_TIMESTAMP   | created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP | created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
|  1 | 2024-04-22 08:34:38 | 2024-04-22 08:35:38            | 2024-04-22 08:37:14 |                                                  0 |                                                  0 |
|  2 | 2024-04-22 09:34:55 | 2024-04-22 09:35:55            | 2024-04-22 08:37:14 |                                                  1 |                                                  1 |
|  3 | 2024-04-22 10:35:02 | 2024-04-22 10:36:02            | 2024-04-22 08:37:14 |                                                  1 |                                                  1 |
|  4 | 2024-04-22 11:35:08 | 2024-04-22 11:36:08            | 2024-04-22 08:37:14 |                                                  1 |                                                  1 |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
4 rows in set (0.00 sec)

mysql> SELECT id, created_at, created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP, created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP, created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP FROM t1;
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
| id | created_at          | created_at + INTERVAL 1 MINUTE | CURRENT_TIMESTAMP   | created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP | created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
|  1 | 2024-04-22 08:34:38 | 2024-04-22 08:35:38            | 2024-04-22 09:07:01 |                                                  0 |                                                  0 |
|  2 | 2024-04-22 09:34:55 | 2024-04-22 09:35:55            | 2024-04-22 09:07:01 |                                                  1 |                                                  1 |
|  3 | 2024-04-22 10:35:02 | 2024-04-22 10:36:02            | 2024-04-22 09:07:01 |                                                  1 |                                                  1 |
|  4 | 2024-04-22 11:35:08 | 2024-04-22 11:36:08            | 2024-04-22 09:07:01 |                                                  1 |                                                  1 |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
4 rows in set (0.00 sec)

mysql> SELECT id, created_at, created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP, created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP, created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP FROM t1;
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
| id | created_at          | created_at + INTERVAL 1 MINUTE | CURRENT_TIMESTAMP   | created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP | created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
|  1 | 2024-04-22 08:34:38 | 2024-04-22 08:35:38            | 2024-04-22 09:19:43 |                                                  0 |                                                  0 |
|  2 | 2024-04-22 09:34:55 | 2024-04-22 09:35:55            | 2024-04-22 09:19:43 |                                                  1 |                                                  1 |
|  3 | 2024-04-22 10:35:02 | 2024-04-22 10:36:02            | 2024-04-22 09:19:43 |                                                  1 |                                                  1 |
|  4 | 2024-04-22 11:35:08 | 2024-04-22 11:36:08            | 2024-04-22 09:19:43 |                                                  1 |                                                  1 |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
4 rows in set (0.00 sec)

mysql> SELECT id, created_at, created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP, created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP, created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP FROM t1;
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
| id | created_at          | created_at + INTERVAL 1 MINUTE | CURRENT_TIMESTAMP   | created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP | created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
|  2 | 2024-04-22 09:34:55 | 2024-04-22 09:35:55            | 2024-04-22 09:39:59 |                                                  0 |                                                  0 |
|  3 | 2024-04-22 10:35:02 | 2024-04-22 10:36:02            | 2024-04-22 09:39:59 |                                                  1 |                                                  1 |
|  4 | 2024-04-22 11:35:08 | 2024-04-22 11:36:08            | 2024-04-22 09:39:59 |                                                  1 |                                                  1 |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
3 rows in set (0.01 sec)

mysql> SELECT CURRENT_TIMESTAMP, CONVERT_TZ(CURRENT_TIMESTAMP,'Europe/Amsterdam','UTC');
+---------------------+--------------------------------------------------------+
| CURRENT_TIMESTAMP   | CONVERT_TZ(CURRENT_TIMESTAMP,'Europe/Amsterdam','UTC') |
+---------------------+--------------------------------------------------------+
| 2024-04-22 09:41:18 | 2024-04-22 07:41:18.000000                             |
+---------------------+--------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT @@global.time_zone, @@global.system_time_zone;
+--------------------+---------------------------+
| @@global.time_zone | @@global.system_time_zone |
+--------------------+---------------------------+
| SYSTEM             | Europe/Amsterdam          |
+--------------------+---------------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM mysql.tidb_ttl_job_history WHERE summary_text->'$.total_rows' > 0\G
*************************** 1. row ***************************
           job_id: b57c0baa673b4cc99170f09d6b6ab4f5
         table_id: 107
  parent_table_id: 107
     table_schema: test
       table_name: t1
   partition_name: NULL
      create_time: 2024-04-22 08:36:25
      finish_time: 2024-04-22 08:36:31
       ttl_expire: 2024-04-22 07:35:25
     summary_text: {"total_rows":3,"success_rows":3,"error_rows":0,"total_scan_task":1,"scheduled_scan_task":1,"finished_scan_task":1}
     expired_rows: 3
     deleted_rows: 3
error_delete_rows: 0
           status: finished
*************************** 2. row ***************************
           job_id: 488f67cca5f24afa951c01c63d1db892
         table_id: 107
  parent_table_id: 107
     table_schema: test
       table_name: t1
   partition_name: NULL
      create_time: 2024-04-22 09:36:25
      finish_time: 2024-04-22 09:36:31
       ttl_expire: 2024-04-22 08:35:25
     summary_text: {"total_rows":1,"success_rows":1,"error_rows":0,"total_scan_task":1,"scheduled_scan_task":1,"finished_scan_task":1}
     expired_rows: 1
     deleted_rows: 1
error_delete_rows: 0
           status: finished
4 rows in set (0.00 sec)

mysql> show create table t1\G
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin /*T![ttl] TTL=`created_at` + INTERVAL 1 MINUTE */ /*T![ttl] TTL_ENABLE='ON' */ /*T![ttl] TTL_JOB_INTERVAL='1m' */
1 row in set (0.00 sec)

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

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

mysql> SELECT TIDB_VERSION()\G
*************************** 1. row ***************************
TIDB_VERSION(): Release Version: v8.0.0
Edition: Community
Git Commit Hash: 43cf9a2245b91c647b46816ad3d5424ef90f1070
Git Branch: HEAD
UTC Build Time: 2024-03-27 09:37:44
GoVersion: go1.21.4
Race Enabled: false
Check Table Before Drop: false
Store: tikv
1 row in set (0.00 sec)
@dveeden dveeden added type/bug The issue is confirmed as a bug. severity/moderate labels Apr 22, 2024
@dveeden
Copy link
Contributor Author

dveeden commented Apr 22, 2024

@lcwangchao @xhebox can you help to check if this is a bug or just something that we need to document on https://docs.pingcap.com/tidb/stable/time-to-live ?

@jebter jebter added the sig/sql-infra SIG: SQL Infra label Apr 23, 2024
@lcwangchao
Copy link
Collaborator

I think it's the same issue with #51675. The MySQL cannot handle time add for DST time zone correctly:

mysql> set @@time_zone='Europe/Amsterdam';
Query OK, 0 rows affected (0.03 sec)

mysql> SELECT NOW(),FROM_UNIXTIME(0) + INTERVAL UNIX_TIMESTAMP() SECOND;
+---------------------+-----------------------------------------------------+
| NOW()               | FROM_UNIXTIME(0) + INTERVAL UNIX_TIMESTAMP() SECOND |
+---------------------+-----------------------------------------------------+
| 2024-04-26 09:25:52 | 2024-04-26 08:25:52                                 |
+---------------------+-----------------------------------------------------+
1 row in set (0.01 sec)

And we computes expire time by adding a interval to UNIX time 0:

tidb/pkg/ttl/cache/table.go

Lines 199 to 201 in e271864

// FROM_UNIXTIME does not support negative value, so we use `FROM_UNIXTIME(0) + INTERVAL <current_ts>`
// to present current time
fmt.Sprintf("SELECT FROM_UNIXTIME(0) + INTERVAL %d SECOND - INTERVAL %s %s", now.Unix(), expireExpr, unit.String()),

We have fixed it in PR #51863

@dveeden
Copy link
Contributor Author

dveeden commented Apr 26, 2024

@lcwangchao I can no longer reproduce this on master. So looks like that indeed fixes it.

CREATE TABLE t1 (
	id INT PRIMARY KEY,
	created_at TIMESTAMP
) TTL=created_at + INTERVAL 1 MINUTE TTL_ENABLE='ON' TTL_JOB_INTERVAL='1m';
INSERT INTO t1 VALUES (1, CURRENT_TIMESTAMP);
INSERT INTO t1 VALUES (2, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
INSERT INTO t1 VALUES (3, CURRENT_TIMESTAMP + INTERVAL 2 HOUR);
INSERT INTO t1 VALUES (4, CURRENT_TIMESTAMP + INTERVAL 3 HOUR);
INSERT INTO t1 VALUES (5, CURRENT_TIMESTAMP - INTERVAL 1 HOUR);
INSERT INTO t1 VALUES (6, CURRENT_TIMESTAMP - INTERVAL 2 HOUR);
INSERT INTO t1 VALUES (7, CURRENT_TIMESTAMP - INTERVAL 3 HOUR);
SELECT
  id,
  created_at,
  created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP,
  created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP,
  created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP
FROM
  t1;
DO SLEEP(180);
SELECT
  id,
  created_at,
  created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP,
  created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP,
  created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP
FROM
  t1;
mysql> CREATE TABLE t1 (id INT PRIMARY KEY, created_at TIMESTAMP) TTL=created_at + INTERVAL 1 MINUTE TTL_ENABLE='ON' TTL_JOB_INTERVAL='1m';
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO t1 VALUES (1, CURRENT_TIMESTAMP);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO t1 VALUES (2, CURRENT_TIMESTAMP + INTERVAL 1 HOUR);
Query OK, 1 row affected (0.01 sec)

mysql> INSERT INTO t1 VALUES (3, CURRENT_TIMESTAMP + INTERVAL 2 HOUR);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO t1 VALUES (4, CURRENT_TIMESTAMP + INTERVAL 3 HOUR);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO t1 VALUES (5, CURRENT_TIMESTAMP - INTERVAL 1 HOUR);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO t1 VALUES (6, CURRENT_TIMESTAMP - INTERVAL 2 HOUR);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO t1 VALUES (7, CURRENT_TIMESTAMP - INTERVAL 3 HOUR);
Query OK, 1 row affected (0.00 sec)

mysql> SELECT id, created_at, created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP, created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP, created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP FROM t1;
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
| id | created_at          | created_at + INTERVAL 1 MINUTE | CURRENT_TIMESTAMP   | created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP | created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
|  1 | 2024-04-26 10:10:24 | 2024-04-26 10:11:24            | 2024-04-26 10:10:24 |                                                  1 |                                                  1 |
|  2 | 2024-04-26 11:10:24 | 2024-04-26 11:11:24            | 2024-04-26 10:10:24 |                                                  1 |                                                  1 |
|  3 | 2024-04-26 12:10:24 | 2024-04-26 12:11:24            | 2024-04-26 10:10:24 |                                                  1 |                                                  1 |
|  4 | 2024-04-26 13:10:24 | 2024-04-26 13:11:24            | 2024-04-26 10:10:24 |                                                  1 |                                                  1 |
|  5 | 2024-04-26 09:10:24 | 2024-04-26 09:11:24            | 2024-04-26 10:10:24 |                                                  0 |                                                  0 |
|  6 | 2024-04-26 08:10:24 | 2024-04-26 08:11:24            | 2024-04-26 10:10:24 |                                                  0 |                                                  0 |
|  7 | 2024-04-26 07:10:24 | 2024-04-26 07:11:24            | 2024-04-26 10:10:24 |                                                  0 |                                                  0 |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
7 rows in set (0.00 sec)

mysql> DO SLEEP(180);

Query OK, 0 rows affected (3 min 0.00 sec)

mysql> SELECT id, created_at, created_at + INTERVAL 1 MINUTE, CURRENT_TIMESTAMP, created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP, created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP FROM t1;
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
| id | created_at          | created_at + INTERVAL 1 MINUTE | CURRENT_TIMESTAMP   | created_at + INTERVAL 1 MINUTE > CURRENT_TIMESTAMP | created_at + INTERVAL 2 MINUTE > CURRENT_TIMESTAMP |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
|  2 | 2024-04-26 11:10:24 | 2024-04-26 11:11:24            | 2024-04-26 10:13:24 |                                                  1 |                                                  1 |
|  3 | 2024-04-26 12:10:24 | 2024-04-26 12:11:24            | 2024-04-26 10:13:24 |                                                  1 |                                                  1 |
|  4 | 2024-04-26 13:10:24 | 2024-04-26 13:11:24            | 2024-04-26 10:13:24 |                                                  1 |                                                  1 |
+----+---------------------+--------------------------------+---------------------+----------------------------------------------------+----------------------------------------------------+
3 rows in set (0.00 sec)

mysql> SELECT CURRENT_TIMESTAMP, CONVERT_TZ(CURRENT_TIMESTAMP,'Europe/Amsterdam','UTC');
+---------------------+--------------------------------------------------------+
| CURRENT_TIMESTAMP   | CONVERT_TZ(CURRENT_TIMESTAMP,'Europe/Amsterdam','UTC') |
+---------------------+--------------------------------------------------------+
| 2024-04-26 10:13:49 | 2024-04-26 08:13:49.000000                             |
+---------------------+--------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT @@global.time_zone, @@global.system_time_zone;
+--------------------+---------------------------+
| @@global.time_zone | @@global.system_time_zone |
+--------------------+---------------------------+
| SYSTEM             | Europe/Amsterdam          |
+--------------------+---------------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM mysql.tidb_ttl_job_history WHERE summary_text->'$.total_rows' > 0\G
*************************** 1. row ***************************
           job_id: 51fd801c6580448f82774be049fb1c3c
         table_id: 104
  parent_table_id: 104
     table_schema: test
       table_name: t1
   partition_name: NULL
      create_time: 2024-04-26 10:10:25
      finish_time: 2024-04-26 10:10:31
       ttl_expire: 2024-04-26 10:09:25
     summary_text: {"total_rows":3,"success_rows":3,"error_rows":0,"total_scan_task":1,"scheduled_scan_task":1,"finished_scan_task":1}
     expired_rows: 3
     deleted_rows: 3
error_delete_rows: 0
           status: finished
*************************** 2. row ***************************
           job_id: 468e2a885f604d8f81ab6caaa07ff02e
         table_id: 104
  parent_table_id: 104
     table_schema: test
       table_name: t1
   partition_name: NULL
      create_time: 2024-04-26 10:11:25
      finish_time: 2024-04-26 10:11:31
       ttl_expire: 2024-04-26 10:10:25
     summary_text: {"total_rows":1,"success_rows":1,"error_rows":0,"total_scan_task":1,"scheduled_scan_task":1,"finished_scan_task":1}
     expired_rows: 1
     deleted_rows: 1
error_delete_rows: 0
           status: finished
2 rows in set (0.00 sec)

mysql> SELECT TIDB_VERSION()\G
*************************** 1. row ***************************
TIDB_VERSION(): Release Version: v8.2.0-alpha-50-g10971ea5b0
Edition: Community
Git Commit Hash: 10971ea5b0d0ca48792751801954c301e2f9fe08
Git Branch: master
UTC Build Time: 2024-04-26 08:07:00
GoVersion: go1.22.2
Race Enabled: false
Check Table Before Drop: false
Store: unistore
1 row in set (0.00 sec)

@dveeden dveeden closed this as completed Apr 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lcwangchao lcwangchao

Labels
severity/moderate sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@lcwangchao @dveeden @jebter