GV$OB_LOG_STAT

Last Updated:2026-09-04 09:48:49

Note

This view was introduced in OceanBase Database V4.0.0.

Purpose

The GV$OB_LOG_STAT view displays the Palf status of log streams. You can use this view to perform the following operations:

Query whether a log stream has a leader.
Query the member list (number of Paxos replicas) of a log stream.
Query the replica synchronization status.
Query the recyclable checkpoint of the logs of a log stream.
Query the log consumption service scope of a log stream based on the log sequence number (LSN) or system change number (SCN).
Query the access mode of Palf.

The query results vary based on the tenant.

When you query this view from the sys tenant, the Palf status of all tenant log streams is displayed.
When you query this view from a user tenant, only the Palf status of the log streams of the current tenant is displayed.

Columns

Column	Type	Nullable?	Description
TENANT_ID	bigint(20)	NO	The ID of the tenant.
LS_ID	bigint(20)	NO	The ID of the log stream.
SVR_IP	varchar(46)	NO	The IP address of the OBServer node.
SVR_PORT	bigint(20)	NO	The port number of the OBServer node.
ROLE	varchar(32)	NO	The role of the replica. Valid values: `LEADER`: The replica is a leader. `FOLLOWER`: The replica is a follower.
PROPOSAL_ID	bigint(20)	NO	The proposal ID of Paxos.
CONFIG_VERSION	varchar(128)	NO	The version number corresponding to the configuration change.
ACCESS_MODE	varchar(32)	NO	The access mode. Valid values: `APPEND`: The primary tenant can write data to the log stream replica. `RAW_WRITE`: The log stream replica is read-only for the standby tenant.
PAXOS_MEMBER_LIST	varchar(1024)	NO	The list of Paxos members.
PAXOS_REPLICA_NUM	bigint(20)	NO	The number of Paxos replicas.
IN_SYNC	varchar(3)	NO	Indicates whether the replica is completely synchronized with the leader.
BASE_LSN	bigint(20)	NO	The maximum recyclable checkpoint.
BEGIN_LSN	bigint(20)	NO	The LSN of the minimum consumption checkpoint.
BEGIN_SCN	bigint(20)	NO	The SCN of the minimum consumption checkpoint.
END_LSN	bigint(20)	NO	The LSN of the maximum consecutive majority checkpoint, also known as the maximum consumption checkpoint.
END_SCN	bigint(20)	NO	The SCN of the maximum consecutive majority checkpoint, also known as the maximum consumption checkpoint.
MAX_LSN	bigint(20)	NO	The LSN of the maximum write point.
MAX_SCN	bigint(20)	NO	The SCN of the maximum write point.
ARBITRATION_MEMBER	varchar(128)	NO	The server address of the arbitration member. Note This column was introduced in OceanBase Database V4.1.0.
DEGRADED_LIST	varchar(1024)	NO	The list of degraded full-featured replicas with arbitration enabled. Note This column was introduced in OceanBase Database V4.1.0.
LEARNER_LIST	longtext	NO	The list of read-only replicas in the current log stream. Note This column was introduced in OceanBase Database V4.2.0.

Sample query

Query the log stream replicas of all tenants from the sys tenant.

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

Previous topic

GV$OB_KV_GROUP_COMMIT_STATUS

Last

Next topic

GV$SYSTEM_EVENT