首批通过分布式安全可靠测评，为关键业务系统打造
划线反馈
如何 KILL OceanBase 的会话
更新时间：2026-05-14 08:46
分享
适用版本：V2.1.x、V2.2.x、V3.1.x、V3.2.x内容类型：How-to
适用版本
OceanBase 数据库 V2.x 和 V3.x 版本
操作步骤
登录 OceanBase 集群的 SYS 租户，查询所有的 OceanBase 会话信息。
obclient > select * from oceanbase.__all_virtual_processlist;返回结果如下：
obclient [(none)]> select * from oceanbase.__all_virtual_processlist; +------------+------+----------+-----------------------+------+---------+------+--------+---------------------------------------------------+-----------------+----------+----------+--------------+---------------+-----------------+-----------+----------------------+-----------+------------+-------------------------------+-------------+ | id | user | tenant | host | db | command | time | state | info | svr_ip | svr_port | sql_port | proxy_sessid | master_sessid | user_client_ip | user_host | trans_id | thread_id | ssl_cipher | trace_id | trans_state | +------------+------+----------+-----------------------+------+---------+------+--------+---------------------------------------------------+-----------------+----------+----------+--------------+---------------+-----------------+-----------+----------------------+-----------+------------+-------------------------------+-------------+ | 3221644091 | root | mysql001 | xxx.xxx.xxx.xxx:21683 | test | Sleep | 6903 | SLEEP | NULL | xxx.xxx.xxx.xxx | 2882 | 2881 | NULL | NULL | xxx.xxx.xxx.xxx | % | 17316708323080480493 | 0 | NULL | NULL | TIMEOUT | | 3221667548 | root | sys | xxx.xxx.xxx.xxx:50546 | NULL | Sleep | 24 | SLEEP | NULL | xxx.xxx.xxx.xxx | 2882 | 2881 | NULL | NULL | xxx.xxx.xxx.xxx | % | 0 | 0 | NULL | NULL | | | 3221655222 | root | sys | xxx.xxx.xxx.xxx:50215 | NULL | Query | 0 | ACTIVE | select * from oceanbase.__all_virtual_processlist | xxx.xxx.xxx.xxx | 2882 | 2881 | NULL | NULL | xxx.xxx.xxx.xxx | % | 0 | 71448 | NULL | YB42AC1E87E5-00060BE57E0D7A12 | | +------------+------+----------+-----------------------+------+---------+------+--------+---------------------------------------------------+-----------------+----------+----------+--------------+---------------+-----------------+-----------+----------------------+-----------+------------+-------------------------------+-------------+ 3 rows in set找到需要删除的会话信息，并通过其 svr_ip 地址，及 sql_port 端口，登录该主机。
根据查询的会话 ID，删除对应的会话。
obclient > kill 3221667548;
