Note
For V4.4.2, this view is available starting with V4.4.2 BP2.
Overview
The GV$OB_LS_LOG_TRANSPORT_STAT view displays the transmission status of logs pushed from each log stream (LS) to a standby database on all nodes of a tenant in strong sync mode. To query this view, you must log in as the primary tenant (or the sys tenant of the cluster where the primary tenant resides).
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 | Server IP Address |
| SVR_PORT | bigint(20) | NO | Server Port Number |
| ROLE | varchar(32) | NO | Log stream replica roles:
|
| ENABLED | tinyint(4) | NO | Whether the log transport service is enabled. |
| END_LSN | bigint(20) unsigned | NO | LSN committed by the primary tenant (primary database) Palf |
| END_SCN | bigint(20) unsigned | NO | SCN committed by the primary tenant (primary database) Palf |
| LAST_SENT_LSN | bigint(20) unsigned | NO | Last LSN sent to the standby tenant (standby database) |
| LAST_SENT_SCN | bigint(20) unsigned | NO | Last SCN sent to the standby tenant (standby database) |
| STANDBY_END_LSN | bigint(20) unsigned | NO | Confirmed LSN written on the standby tenant (standby database) |
| STANDBY_END_SCN | bigint(20) unsigned | NO | Confirmed SCN written on the standby tenant (standby database) |
| STANDBY_ADDR | varchar(52) | NO | The address of the current log stream leader for the standby tenant (standby database). If it is0.0.0.0:0, indicating that it is invalid. |
Sample query
In the primary tenant, query the transmission status of logs pushed from each log server on all nodes of the tenant to the standby tenant.
Confirm the synchronization mode of the primary tenant LS.
obclient(root@mysql001)[oceanbase]> SELECT SVR_IP, SVR_PORT, LS_ID, ROLE, SYNC_MODE FROM oceanbase.GV$OB_LOG_STAT WHERE ROLE = 'LEADER';The query result is as follows:
+-------------+----------+-------+--------+-----------+ | SVR_IP | SVR_PORT | LS_ID | ROLE | SYNC_MODE | +-------------+----------+-------+--------+-----------+ | 6.xx.xxx.91 | 2882 | 1 | LEADER | SYNC | | 6.xx.xxx.91 | 2882 | 1001 | LEADER | SYNC | +-------------+----------+-------+--------+-----------+ 2 rows in setIf the result is
SYNC, it indicates that the current tenant's log stream synchronization mode is strong sync.Query the transmission status of log forwarding from each log stream on all nodes of the primary tenant to the standby tenant.
obclient(root@mysql001)[oceanbase]> SELECT 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 ROLE = 'LEADER';The query result is as follows:
+-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+ | SVR_IP | SVR_PORT | LS_ID | ROLE | ENABLED | END_LSN | LAST_SENT_LSN | STANDBY_END_LSN | STANDBY_ADDR | +-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+ | 6.xx.xxx.91 | 2882 | 1 | LEADER | 1 | 305150963 | 305150963 | 305150963 | 6.xx.xxx.160:2882 | | 6.xx.xxx.91 | 2882 | 1001 | LEADER | 1 | 201294294 | 201294294 | 201294294 | 6.xx.xxx.160:2882 | +-------------+----------+-------+--------+---------+-----------+---------------+-----------------+-------------------+ 2 rows in set