Note
This view is available starting with V4.0.0.
Purpose
This view displays all tasks to be generated (including those already generated and those not yet generated).
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| LS_ID | bigint(20) | NO | The log stream ID. |
| TASK_TYPE | varchar(64) | NO | The task type. Valid values:
|
| PRIORITY | varchar(5) | NO | The task priority. Valid values:
|
| TARGET_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the server where the target replica resides. |
| TARGET_REPLICA_SVR_PORT | bigint(20) | YES | The port number of the server where the target replica resides. |
| TARGET_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The number of required Paxos replicas for the target replica. |
| TARGET_REPLICA_TYPE | varchar(16) | YES | The type of the target replica. |
| SOURCE_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the server where the source replica resides. For tasks such as replica removal and modification of the number of required Paxos replicas, this field is invalid and displays as NULL. |
| SOURCE_REPLICA_SVR_PORT | bigint(20) | YES | The port number of the server where the source replica resides. For tasks such as replica removal and modification of the number of required Paxos replicas, this field is invalid and displays as 0. |
| SOURCE_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The number of required Paxos replicas for the source replica. |
| SOURCE_REPLICA_TYPE | varchar(16) | YES | The type of the source replica. For tasks such as replica removal and modification of the number of required Paxos replicas, this field is invalid and displays as NULL. |
| TASK_EXEC_SVR_IP | varchar(46) | YES | The IP address of the server where the task is executed. |
| TASK_EXEC_SVR_PORT | bigint(20) | YES | The port number of the server where the task is executed. |
| COMMENT | varchar(2048) | YES | The comment on the reason for task generation. |
| CONFIG_VERSION | varchar(128) | YES | The config_version information of the clog layer when the disaster recovery task is executed.
NoteThis field is available starting with V4.4.0. |
Sample query
Query the tasks to be generated for the current tenant.
obclient> SELECT * FROM oceanbase.V$OB_LS_REPLICA_TASK_PLAN\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1004
LS_ID: 1
TASK_TYPE: ADD REPLICA
PRIORITY: HIGH
TARGET_REPLICA_SVR_IP: 172.xx.xxx.243
TARGET_REPLICA_SVR_PORT: 2882
TARGET_PAXOS_REPLICA_NUMBER: 3
TARGET_REPLICA_TYPE: FULL
SOURCE_REPLICA_SVR_IP: 172.xx.xxx.254
SOURCE_REPLICA_SVR_PORT: 2882
SOURCE_PAXOS_REPLICA_NUMBER: 2
SOURCE_REPLICA_TYPE: FULL
TASK_EXEC_SVR_IP: 172.xx.xxx.243
TASK_EXEC_SVR_PORT: 2882
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
1 row in set