GV$OB_LS_LOG_TRANSPORT_STAT

Overview

The GV$OB_LS_LOG_TRANSPORT_STAT view displays the transmission status of logs pushed from each log stream (LS) on all nodes of a tenant to a standby tenant (standby database) in strong sync mode (SYNC_MODE is SYNC). To query this view, you must log in as the primary tenant (primary database) or the sys tenant of the cluster where the primary tenant (primary database) resides.

The log transfer service operates only in strong sync mode. In async mode, the standby database actively pulls logs, so this record is meaningless.

Columns

Sample query

In the sys tenant of the cluster where the primary tenant resides, query the transmission status of logs pushed from each LS on all nodes of the primary tenant with ID 1002 to the standby tenants.

1. Confirm the synchronization mode of the primary tenant LS.

   obclient(root@sys)[oceanbase]> SELECT TENANT_ID, SVR_IP, SVR_PORT, LS_ID, ROLE, SYNC_MODE FROM oceanbase.GV$OB_LOG_STAT WHERE TENANT_ID = 1002 AND ROLE = 'LEADER';
   

   The query result is as follows:

   +-----------+-------------+----------+-------+--------+-----------+
   | TENANT_ID | SVR_IP      | SVR_PORT | LS_ID | ROLE   | SYNC_MODE |
   +-----------+-------------+----------+-------+--------+-----------+
   |      1002 | 6.xx.xxx.91 |     2882 |     1 | LEADER | SYNC      |
   |      1002 | 6.xx.xxx.91 |     2882 |  1001 | LEADER | SYNC      |
   +-----------+-------------+----------+-------+--------+-----------+
   2 rows in set
   

   The result SYNC indicates that the current tenant's log stream synchronization mode is strong sync.

2. Query the transmission status of log streaming from each log source on all nodes of the primary tenant to the standby tenant.

   obclient(root@sys)[oceanbase]> SELECT TENANT_ID, SVR_IP, SVR_PORT, LS_ID, ROLE, ENABLED, 
       END_LSN, LAST_SENT_LSN, STANDBY_END_LSN, STANDBY_ADDR
       FROM oceanbase.GV$OB_LS_LOG_TRANSPORT_STAT WHERE TENANT_ID = 1002 AND ROLE = 'LEADER';
   

   The query result is as follows:

   +-----------+-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   | TENANT_ID | SVR_IP      | SVR_PORT | LS_ID | ROLE   | ENABLED | END_LSN   | LAST_SENT_LSN | STANDBY_END_LSN | STANDBY_ADDR      |
   +-----------+-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   |      1002 | 6.xx.xxx.91 |     2882 |     1 | LEADER |       1 | 304766784 |     304766784 |       304766784 | 6.xx.xxx.160:2882 |
   |      1002 | 6.xx.xxx.91 |     2882 |  1001 | LEADER |       1 | 200961942 |     200961942 |       200961942 | 6.xx.xxx.160:2882 |
   +-----------+-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+
   2 rows in set