KILL

Purpose

You can use this statement to terminate server connections.

Required privileges

By default, a normal user can terminate only sessions of the current user, and sessions in other tenants are invisible to the user. Whether a normal user can terminate sessions of other users in the same tenant depends on the privileges of the current tenant. In OceanBase Database, the sys tenant can terminate any session in the current tenant. The super administrator (root@proxysys) of OceanBase Database Proxy (ODP) can terminate sessions in all clusters and tenants.

Syntax

KILL PROXYSESSION {cs_id | connection_id} ss_id;

Parameters

Examples

1. Log in to OceanBase Database through ODP as the root@sys user.

   obclient -h10.10.10.1 -uroot@sys#obdemo -P2883 -p -c -A
   

   The preceding command is only an example. You need to modify the parameter values based on the actual situation. For more information, see Connect to an OceanBase Database tenant by using OBClient in MySQL mode.

2. View the client session and query the client session ID.

   SHOW PROCESSLIST;
   

   The output is as follows, where the value of Id is the client session ID:

   +------------+-------------+---------------------+-----------+---------+------+--------+------------------+
   | Id         | User        | Host                | db        | Command | Time | State  | Info             |
   +------------+-------------+---------------------+-----------+---------+------+--------+------------------+
   | 1607729164 | proxyro     | 10.10.10.1:47366    | oceanbase | Sleep   |    2 | SLEEP  | NULL             |
   | 1607729162 | root        | 10.10.10.1:47362    | oceanbase | Query   |    0 | ACTIVE | SHOW PROCESSLIST |
   +------------+-------------+---------------------+-----------+---------+------+--------+------------------+
   

3. Query the server session ID based on the client session ID.

   SHOW PROXYSESSION ATTRIBUTE 1607729162 LIKE "%id%";
   

   The output is as follows:

   +------------------------+--------------------+----------------+
   | attribute_name         | value              | info           |
   +------------------------+--------------------+----------------+
   | proxy_sessid           | 838175719856210097 | cs common      |
   | cs_id                  | 1607729162         | cs common      |
   | tid                    | 108071             | cs common      |
   | pid                    | 108071             | cs common      |
   | idc_name               |                    | cs common      |
   | last_insert_id_version | 0                  | cs var version |
   | server_sessid          | 3221555468         | last used ss   |
   | ss_id                  | 299                | last used ss   |
   | last_insert_id_version | 0                  | last used ss   |
   +------------------------+--------------------+----------------+
   

4. Terminate the server session for the client session.

   KILL PROXYSESSION 64940 16;