Note
This view is available starting with V4.1.0.
Purpose
This view is accessible only to the sys tenant and displays the history of arbitration service tasks executed by all 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. |
| EXECUTE_RESULT | varchar(2048) | NO | The task execution result and duration, in the format of "[ret:0; elapsed:72160;]". |
| CREATE_TIME | datetime | NO | The task generation time. |
| FINISH_TIME | datetime | NO | The task completion time. |
| TRACE_ID | varchar(200) | NO | The trace_id of the task execution 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. Only ADDR is supported. |
| COMMENT | varchar(2048) | YES | The task description. |
Sample query
The sys tenant queries the arbitration service history of the tenant with ID 1002.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY WHERE TENANT_ID=1002;
The query result is as follows:
+-----------+-------+------------------+-------------------------+---------------------+---------------------+-----------------------------------+----------------+---------------------+--------------------------+--------------------------------------------+
| TENANT_ID | LS_ID | TASK_ID | EXECUTE_RESULT | CREATE_TIME | FINISH_TIME | TRACE_ID | TASK_TYPE | ARBITRATION_SERVICE | ARBITRATION_SERVICE_TYPE | COMMENT |
+-----------+-------+------------------+-------------------------+---------------------+---------------------+-----------------------------------+----------------+---------------------+--------------------------+--------------------------------------------+
| 1002 | 1 | 1747029840161991 | [ret:0; elapsed:63458;] | 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 | [ret:0; elapsed:66408;] | 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 | [ret:0; elapsed:63357;] | 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 |
+-----------+-------+------------------+-------------------------+---------------------+---------------------+-----------------------------------+----------------+---------------------+--------------------------+--------------------------------------------+
3 rows in set