kill tidb session,but it doesn't work-v6.5.1

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)
log on the actual tidb server:10.xxx.xxx.236 which the long query excutes on.
[root@10.xxx.xxx.236][4000][(none)][10:43:26]> select * FROM INFORMATION_SCHEMA.CLUSTER_PROCESSLIST where user ='root' and time >3600\G
*************************** 1. row ***************************
INSTANCE: 10.xxx.xxx.236:10080
ID: 5313049092622920637
USER: root
HOST: 10.xxx.xxx.231:48346
DB: dlshisdb
COMMAND: Query
TIME: 1031339
STATE: autocommit
INFO: show table t_txx_p2019 regions
DIGEST: 5b88eacbdcc92c783184fa5d9ff84ff9310992fa76e75bcae33ef77e93255050
MEM: 0
DISK: 0
TxnStart:
1 row in set (0.01 sec)

[root@10.xxx.xxx.236][4000][(none)][10:43:34]> kill tidb 5313049092622920637;
Query OK, 0 rows affected (0.00 sec)

[root@10.xxx.xxx.236][4000][(none)][10:43:45]> select * FROM INFORMATION_SCHEMA.CLUSTER_PROCESSLIST where user ='root' and time >3600\G
*************************** 1. row ***************************
INSTANCE: 10.xxx.xxx.236:10080
ID: 5313049092622920637
USER: root
HOST: 10.xxx.xxx.231:48346
DB: dlshisdb
COMMAND: Query
TIME: 1031352
STATE: autocommit
INFO: show table t_txx_p2019 regions
DIGEST: 5b88eacbdcc92c783184fa5d9ff84ff9310992fa76e75bcae33ef77e93255050
MEM: 0
DISK: 0
TxnStart:

### 2. What did you expect to see? (Required)
the session 5313049092622920637 would be killed,

### 3. What did you see instead (Required)
the session 5313049092622920637 is still in query command.

### 4. What is your TiDB version? (Required)

| tidb_version()
| Release Version: v6.5.1
Edition: Community
Git Commit Hash: 4084b077d615f9dc0a41cf2e30bc6e1a02332df2
Git Branch: heads/refs/tags/v6.5.1
UTC Build Time: 2023-03-07 16:12:08
GoVersion: go1.19.5
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: tikv |