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. Only the sys tenant can access this view.
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 the 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