Note
This view is available starting with V4.1.0.
Purpose
This view displays the arbitration service tasks running for the current tenant and its corresponding user tenants.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| LS_ID | bigint(20) | NO | The log stream ID. |
| TASK_ID | bigint(20) | NO | The task ID. |
| CREATE_TIME | datetime | NO | The time when the task was created. |
| MODIFY_TIME | datetime | NO | The time when the task was last modified. |
| TRACE_ID | varchar(200) | NO | The trace ID of the task in the log. |
| TASK_TYPE | varchar(32) | NO | The task type. Valid values: ADD REPLICA and REMOVE REPLICA. ADD REPLICA indicates an add replica task. REMOVE REPLICA indicates a remove replica task. |
| ARBITRATION_SERVICE | varchar(512) | NO | The address of the arbitration service. |
| ARBITRATION_SERVICE_TYPE | varchar(64) | NO | The type of the arbitration service. Currently, only ADDR is supported. |
| COMMENT | varchar(2048) | YES | The task description. |
Sample query
Query the arbitration service tasks running for all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS;
The query result is as follows:
+-----------+-------+------------------+---------------------+---------------------+-----------------------------------+----------------+---------------------+--------------------------+--------------------------------------------+
| TENANT_ID | LS_ID | TASK_ID | CREATE_TIME | MODIFY_TIME | TRACE_ID | TASK_TYPE | ARBITRATION_SERVICE | ARBITRATION_SERVICE_TYPE | COMMENT |
+-----------+-------+------------------+---------------------+---------------------+-----------------------------------+----------------+---------------------+--------------------------+--------------------------------------------+
| 1 | 1 | 1747029983106562 | 2025-05-12 14:06:23 | 2025-05-12 14:06:23 | YB4**************************-0-0 | REMOVE REPLICA | 172.xx.xxx.xxx:2882 | ADDR | remove arbitration replica service replica |
| 1001 | 1 | 1747029840080096 | 2025-05-12 14:04:00 | 2025-05-12 14:04:00 | YB4**************************-0-0 | REMOVE REPLICA | 172.xx.xxx.xxx:2882 | ADDR | remove arbitration replica service replica |
| 1002 | 1 | 1747029840161991 | 2025-05-12 14:04:00 | 2025-05-12 14:04:00 | YB4**************************-0-0 | REMOVE REPLICA | 172.xx.xxx.xxx:2882 | ADDR | remove arbitration replica service replica |
| 1002 | 1001 | 1747029840233786 | 2025-05-12 14:04:00 | 2025-05-12 14:04:00 | YB4**************************-0-0 | REMOVE REPLICA | 172.xx.xxx.xxx:2882 | ADDR | remove arbitration replica service replica |
| 1002 | 1004 | 1747029840308182 | 2025-05-12 14:04:00 | 2025-05-12 14:04:00 | YB4**************************-0-0 | REMOVE REPLICA | 172.xx.xxx.xxx:2882 | ADDR | remove arbitration replica service replica |
+-----------+-------+------------------+---------------------+---------------------+-----------------------------------+----------------+---------------------+--------------------------+--------------------------------------------+
5 rows in set