Note
This view is available starting with V4.1.0.
Purpose
This view displays the arbitration service tasks that are running for the current tenant and its corresponding user tenants. It is accessible only to the sys tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CREATE_TIME | datetime | NO | The time when the task was created. |
| MODIFY_TIME | datetime | NO | The time when the task was last modified. |
| 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. |
| TRACE_ID | varchar(200) | NO | The trace ID of the task in the log. |
| TASK_TYPE | varchar(32) | NO | The task type. Valid values:
|
| 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 description of the task. |
Sample query
Query all arbitration service tasks that are 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