KILL TIDB Query执行后,查询依旧还能查询到『TiDB V5.1版本』

可以看到按照KILL TIDB语法执行后,查询依旧还在

tidb@prod-asset-tipd-e01:~$ mysql -h 172.18.244.30 -P 4000 -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 643287
Server version: 5.7.25-TiDB-v5.1.0 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from information_schema.CLUSTER_PROCESSLIST where id=2375\G
*************************** 1. row ***************************
INSTANCE: 172.18.244.30:10080
      ID: 2375
    USER: asset-user
    HOST: 172.18.37.1:54598
      DB: db_name
 COMMAND: Query
    TIME: 252073
   STATE: in transaction
    INFO: select t2.id from ( select  ROW_NUMBER() over() as  'idx', t1.id from ( select c.id id from tb_name c order by c.id) t1  )t2 where t2.idx % 5096 = 1 order by t2.idx
  DIGEST: 9ff1ce262b1a5f7d7c50b42f4c88ddb0a10f04311d2f848e0b1a48895700214c
     MEM: 1186719
    DISK: 0
TxnStart: 08-24 18:38:02.369(427242679794139138)
1 row in set (0.01 sec)

mysql> KILL TIDB 2375;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from information_schema.CLUSTER_PROCESSLIST where id=2375\G
*************************** 1. row ***************************
INSTANCE: 172.18.244.30:10080
      ID: 2375
    USER: asset-user
    HOST: 172.18.37.1:54598
      DB: db_name
 COMMAND: Query
    TIME: 252089
   STATE: in transaction
    INFO: select t2.id from ( select  ROW_NUMBER() over() as  'idx', t1.id from ( select c.id id from tb_name c order by c.id) t1  )t2 where t2.idx % 5096 = 1 order by t2.idx
  DIGEST: 9ff1ce262b1a5f7d7c50b42f4c88ddb0a10f04311d2f848e0b1a48895700214c
     MEM: 1186719
    DISK: 0
TxnStart: 08-24 18:38:02.369(427242679794139138)
1 row in set (0.01 sec)

这个问题,当前应该是一个已知问题,目前仍然在定位处理中,如果有进度,会跟帖回复,感谢反馈 ~

1 个赞

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。