Feature
This view displays the replica-level disaster recovery tasks that are running. You can check this view only from a sys tenant.
Related tables/views
oceanbase.__ALL_VIRTUAL_LS_REPLICA_TASK
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| LS_ID | bigint(20) | NO | The log stream ID. |
| TASK_TYPE | varchar(64) | NO | The type of the task. Valid values:
|
| TASK_ID | varchar(200) | NO | The ID of the task. |
| TASK_STATUS | varchar(2048) | YES | The status of the task. Valid value:
|
| PRIORITY | varchar(5) | NO | The priority of the task. Valid values:
|
| TARGET_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the machine where the destination replica resides. |
| TARGET_REPLICA_SVR_PORT | bigint(20) | YES | The port number of the machine where the destination replica resides. |
| TARGET_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The quorum of the Paxos group for the destination replica. |
| TARGET_REPLICA_TYPE | varchar(16) | YES | The type of the destination replica. |
| SOURCE_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the machine where the source replica resides. For tasks such as deleting replicas and modifying the quorum of the Paxos group, this field is invalid and is NULL. |
| SOURCE_REPLICA_SVR_PORT | bigint(20 | YES | The port number of the machine where the source replica resides. For tasks such as deleting replicas and modifying the quorum of the Paxos group, this field is invalid and is 0. |
| SOURCE_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The quorum of the Paxos group for the source replica. |
| SOURCE_REPLICA_TYPE | varchar(16) | YES | The type of the source replica. For tasks such as deleting replicas and modifying the quorum of the Paxos group, this field is invalid and is NULL. |
| TASK_EXEC_SVR_IP | varchar(46) | YES | The IP address of the machine where the task is executed. |
| TASK_EXEC_SVR_PORT | bigint(20) | YES | The port number of the machine where the task is executed. |
| CREATE_TIME | datetime | NO | The time when the task was generated. |
| START_TIME | datetime | NO | The time when the task was scheduled. |
| MODIFY_TIME | datetime | NO | The time when the task status was updated. |
| COMMENT | varchar(2048) | YES | The reason why the task was generated. |