Overview
Displays the status of the log stream Palf. Common usage scenarios include:
- Query whether the log stream has a leader (the replica where the leader resides).
- Query the member list of a log stream (number of Paxos replicas).
- Query the replica synchronization status.
- Query the recyclable timestamp of a log stream.
- Query the scope of log streams that are allowed to provide log consumption services (including LSN and SCN).
- Query the access mode of Palf.
The results obtained by querying this view vary depending on the tenant. Specifically:
- When queried through the sys tenant, this view displays the status of all tenant log stream Palfs.
- When querying this view from a user tenant, only the status of the Palf for the current tenant's log stream is displayed.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| LS_ID | bigint(20) | NO | Log Stream ID |
| SVR_IP | varchar(46) | NO | OBServer IP |
| SVR_PORT | bigint(20) | NO | OBServer Port Number |
| ROLE | varchar(32) | NO | Replica role:
|
| PROPOSAL_ID | bigint(20) | NO | Paxos Proposal ID |
| CONFIG_VERSION | varchar(128) | NO | Version number corresponding to the configuration change |
| ACCESS_MODE | varchar(32) | NO | Access mode:
|
| PAXOS_MEMBER_LIST | varchar(1024) | NO | Paxos Member List |
| PAXOS_REPLICA_NUM | bigint(20) | NO | Number of Paxos Replicas |
| IN_SYNC | varchar(3) | NO | Whether the replicas are fully synchronized with the leader |
| BASE_LSN | bigint(20) | NO | Maximum Recyclable Timestamp |
| BEGIN_LSN | bigint(20) | NO | Least Recently Consumed Timestamp (LSN) |
| BEGIN_SCN | bigint(20) | NO | Smallest Consumable SCN |
| END_LSN | bigint(20) | NO | Maximum Consecutive Majority LSN |
| END_SCN | bigint(20) | NO | Maximum Consecutive Majority Timestamp/Scannable Consumer Timestamp (SCN) |
| MAX_LSN | bigint(20) | NO | Maximum Write Point (LSN) |
| MAX_SCN | bigint(20) | NO | Maximum Write Point (SCN) |
| ARBITRATION_MEMBER | varchar(128) | NO | The server address of the arbitration member. This parameter is not required at the moment. |
| DEGRADED_LIST | varchar(1024) | NO | List of Full-featured Replicas Degraded in Arbitration Scenarios |
| LEARNER_LIST | longtext | NO | List of Read-only Replicas for the Current Log Stream |
Sample query
The system tenant can view the log stream replica status for all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_LOG_STAT\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1
LS_ID: 1
SVR_IP: 172.xx.xx.xx
SVR_PORT: 2882
ROLE: LEADER
PROPOSAL_ID: 1
CONFIG_VERSION: {proposal_id:1, config_seq:2}
ACCESS_MODE: APPEND
PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
PAXOS_REPLICA_NUM: 1
IN_SYNC: YES
BASE_LSN: 134209536
BEGIN_LSN: 0
BEGIN_SCN: 2
END_LSN: 318191562
END_SCN: 1722479340929986934
MAX_LSN: 318191562
MAX_SCN: 1722479340929986934
ARBITRATION_MEMBER:
DEGRADED_LIST:
LEARNER_LIST:
*************************** 2. row ***************************
TENANT_ID: 1001
LS_ID: 1
SVR_IP: 172.xx.xx.xx
SVR_PORT: 2882
ROLE: LEADER
PROPOSAL_ID: 1
CONFIG_VERSION: {proposal_id:1, config_seq:2}
ACCESS_MODE: APPEND
PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
PAXOS_REPLICA_NUM: 1
IN_SYNC: YES
BASE_LSN: 268419072
BEGIN_LSN: 0
BEGIN_SCN: 2
END_LSN: 557711344
END_SCN: 1722479340939152599
MAX_LSN: 557711344
MAX_SCN: 1722479340939152599
ARBITRATION_MEMBER:
DEGRADED_LIST:
LEARNER_LIST:
*************************** 3. row ***************************
TENANT_ID: 1002
LS_ID: 1
SVR_IP: 172.xx.xx.xx
SVR_PORT: 2882
ROLE: LEADER
PROPOSAL_ID: 1
CONFIG_VERSION: {proposal_id:1, config_seq:2}
ACCESS_MODE: APPEND
PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
PAXOS_REPLICA_NUM: 1
IN_SYNC: YES
BASE_LSN: 67104768
BEGIN_LSN: 0
BEGIN_SCN: 2
END_LSN: 114146658
END_SCN: 1722479340863708484
MAX_LSN: 114146658
MAX_SCN: 1722479340863708484
ARBITRATION_MEMBER:
DEGRADED_LIST:
LEARNER_LIST:
*************************** 4. row ***************************
TENANT_ID: 1002
LS_ID: 1001
SVR_IP: 172.xx.xx.xx
SVR_PORT: 2882
ROLE: LEADER
PROPOSAL_ID: 1
CONFIG_VERSION: {proposal_id:1, config_seq:2}
ACCESS_MODE: APPEND
PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
PAXOS_REPLICA_NUM: 1
IN_SYNC: YES
BASE_LSN: 0
BEGIN_LSN: 0
BEGIN_SCN: 1722408567239862706
END_LSN: 86426047
END_SCN: 1722479340863708484
MAX_LSN: 86426047
MAX_SCN: 1722479340863708484
ARBITRATION_MEMBER:
DEGRADED_LIST:
LEARNER_LIST:
*************************** 5. row ***************************
TENANT_ID: 1003
LS_ID: 1
SVR_IP: 172.xx.xx.xx
SVR_PORT: 2882
ROLE: LEADER
PROPOSAL_ID: 1
CONFIG_VERSION: {proposal_id:1, config_seq:2}
ACCESS_MODE: APPEND
PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
PAXOS_REPLICA_NUM: 1
IN_SYNC: YES
BASE_LSN: 268419072
BEGIN_LSN: 0
BEGIN_SCN: 2
END_LSN: 552332267
END_SCN: 1722479341104912661
MAX_LSN: 552332267
MAX_SCN: 1722479341104912661
ARBITRATION_MEMBER:
DEGRADED_LIST:
LEARNER_LIST:
*************************** 6. row ***************************
TENANT_ID: 1004
LS_ID: 1
SVR_IP: 172.xx.xx.xx
SVR_PORT: 2882
ROLE: LEADER
PROPOSAL_ID: 1
CONFIG_VERSION: {proposal_id:1, config_seq:2}
ACCESS_MODE: APPEND
PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
PAXOS_REPLICA_NUM: 1
IN_SYNC: YES
BASE_LSN: 67104768
BEGIN_LSN: 0
BEGIN_SCN: 2
END_LSN: 121609719
END_SCN: 1722479340863954133
MAX_LSN: 121609719
MAX_SCN: 1722479340863954133
ARBITRATION_MEMBER:
DEGRADED_LIST:
LEARNER_LIST:
*************************** 7. row ***************************
TENANT_ID: 1004
LS_ID: 1001
SVR_IP: 172.xx.xx.xx
SVR_PORT: 2882
ROLE: LEADER
PROPOSAL_ID: 1
CONFIG_VERSION: {proposal_id:1, config_seq:2}
ACCESS_MODE: APPEND
PAXOS_MEMBER_LIST: 172.xx.xx.xx:2882:1
PAXOS_REPLICA_NUM: 1
IN_SYNC: YES
BASE_LSN: 67104768
BEGIN_LSN: 0
BEGIN_SCN: 1722408696347874714
END_LSN: 86210139
END_SCN: 1722479340863954133
MAX_LSN: 86210139
MAX_SCN: 1722479340863954133
ARBITRATION_MEMBER:
DEGRADED_LIST:
LEARNER_LIST:
7 rows in set