*Issue migrated from trac ticket # 871 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-01 19:07:21: smith created the issue

abc=# show processlist;
WARNING:  Compute node (6) unreachable
WARNING:  Compute node (7) unreachable
   Pid    | User |      Host       | db  | State  |        Query         | Wait_event | xact_sec | query_sec | backend_sec | state_change
----------+------+-----------------+-----+--------+----------------------+------------+----------+-----------+-------------+--------------
 33554435 | abc  | 127.0.0.1:37468 | abc | active | show processlist;    |            | 0.001078 | 0.001081  | 19.942973   | 0.00108
 37748755 | test | 127.0.0.1:42688 | abc | active | select pg_sleep(10); | PgSleep    | 0.909864 | 0.909871  | 8.103594    | 0.909871
(2 rows)

-- mysql的kill命令
abc=# kill 37748755;
KILL QUERY
abc=#

-- cancel协议
abc=# select pg_sleep(10);
^CCancel request sent
ERROR:  canceling statement due to user request
abc=#

测试要点：在多个计算节点加一个ha_proxy进行测试。