Note
This view is available starting with V4.1.0.
Purpose
This view displays the history of arbitration service tasks executed by the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| LS_ID | NUMBER(38) | NO | The log stream ID. |
| TASK_ID | NUMBER(38) | NO | The task ID. |
| EXECUTE_RESULT | VARCHAR2(2048) | NO | The task execution result and duration. The result is in the format of "[ret:0; elapsed:72160;]". |
| CREATE_TIME | TIMESTAMP(6) | NO | The time when the task was generated. |
| FINISH_TIME | TIMESTAMP(6) | NO | The time when the task was completed. |
| TRACE_ID | VARCHAR2(200) | NO | The trace ID of the task execution in the log. |
| TASK_TYPE | VARCHAR2(32) | NO | The task type. Valid values:
|
| ARBITRATION_SERVICE | VARCHAR2(512) | NO | The address of the arbitration service. |
| ARBITRATION_SERVICE_TYPE | VARCHAR2(64) | NO | The type of the arbitration service. At present, only ADDR is supported. |
| COMMENT | VARCHAR2(2048) | YES | The task description. |
Sample query
Query the history of arbitration service tasks executed by the current tenant.
obclient[SYS]> SELECT * FROM SYS.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY;
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 |
+-----------+-------+------------------+-------------------------+------------------------------+------------------------------+-----------------------------------+----------------+---------------------+--------------------------+--------------------------------------------+
| 1004 | 1 | 1746770907292794 | [ret:0; elapsed:63299;] | 09-MAY-25 02.08.27.294339 PM | 09-MAY-25 02.08.27.357638 PM | YB4**************************-0-0 | REMOVE REPLICA | 172.xx.xxx.xxx:2882 | ADDR | remove arbitration replica service replica |
| 1004 | 1001 | 1746770907363876 | [ret:0; elapsed:62482;] | 09-MAY-25 02.08.27.365296 PM | 09-MAY-25 02.08.27.427778 PM | YB4**************************-0-0 | REMOVE REPLICA | 172.xx.xxx.xxx:2882 | ADDR | remove arbitration replica service replica |
+-----------+-------+------------------+-------------------------+------------------------------+------------------------------+-----------------------------------+----------------+---------------------+--------------------------+--------------------------------------------+
2 rows in set