Note
This view is available starting with V4.1.0.
Overview
Accessible only to the system tenant, this view displays the history of arbitration service tasks executed by all tenants.
Columns
field |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| LS_ID | bigint(20) | NO | Log Stream ID |
| TASK_ID | bigint(20) | NO | Task ID |
| EXECUTE_RESULT | varchar(2048) | NO | Task execution result and duration, in the format of "[ret:0; elapsed:72160;]" |
| CREATE_TIME | datetime | NO | Task Generation Time |
| FINISH_TIME | datetime | NO | Task completion time |
| TRACE_ID | varchar(200) | NO | The trace ID of this task execution in the log |
| TASK_TYPE | varchar(32) | NO | Task type:
|
| ARBITRATION_SERVICE | varchar(512) | NO | Arbitration service address |
| ARBITRATION_SERVICE_TYPE | varchar(64) | NO | Arbitration service type. Currently, only the following value is supported:ADDR |
| COMMENT | varchar(2048) | YES | Task description |
Sample query
The system 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