Note
For V4.4.2, this view is available starting from V4.4.2 BP2.
Overview
The V$OB_LS_LOG_REPLAY_STAT view displays the log replay progress for each log stream (LS) replica on the current node of a tenant. You must query this view on a standby database, or on the primary database for follower replicas.
Since logs are not replayed on the leader replica of the primary tenant (primary database), in query results, a row with ROLE = LEADER for the primary tenant is meaningless.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| SVR_IP | varchar(46) | NO | Server IP address |
| SVR_PORT | bigint(20) | NO | Server port number |
| LS_ID | bigint(20) | NO | Log stream ID |
| ROLE | varchar(32) | NO | Log stream replica roles:
|
| ENABLED | tinyint(4) | NO | Whether the log replay service is enabled. |
| END_LSN | bigint(20) unsigned | NO | LSN written by Palf (right boundary for log replay) |
| UNSUBMITTED_LSN | bigint(20) unsigned | NO | The LSN of the next log to be committed to the replay queue |
| UNSUBMITTED_SCN | bigint(20) unsigned | NO | SCN of the next log to be submitted to the replay queue |
| MIN_UNREPLAYED_LSN | bigint(20) unsigned | NO | LSN of the earliest unreplayed log in the replay queue |
| MIN_UNREPLAYED_SCN | bigint(20) unsigned | NO | SCN of the earliest unreplayed log in the replay queue |
| PENDING_CNT | bigint(20) | NO | Number of tasks pending replay in memory |
Sample query
In the sys tenant of the cluster where the standby tenant resides, view the log replay progress for each log stream replica on the current node of the standby tenant with tenant ID 1002.
obclient(root@sys)[oceanbase]> SELECT TENANT_ID, LS_ID, ROLE, ENABLED,
END_LSN, UNSUBMITTED_LSN, MIN_UNREPLAYED_LSN, PENDING_CNT
FROM oceanbase.V$OB_LS_LOG_REPLAY_STAT WHERE TENANT_ID = 1002;
The query result is as follows:
+-----------+-------+----------+---------+-----------+-----------------+--------------------+-------------+
| TENANT_ID | LS_ID | ROLE | ENABLED | END_LSN | UNSUBMITTED_LSN | MIN_UNREPLAYED_LSN | PENDING_CNT |
+-----------+-------+----------+---------+-----------+-----------------+--------------------+-------------+
| 1002 | 1 | FOLLOWER | 1 | 300636581 | 300060582 | 300060582 | 0 |
| 1002 | 1001 | FOLLOWER | 1 | 197547054 | 197052262 | 197052262 | 0 |
+-----------+-------+----------+---------+-----------+-----------------+--------------------+-------------+
2 rows in set