MV_BOTTOMLESS_READ_REPLICAS_STATE

Column name	Description
`NODE_ID`	ID of the node hosting the replica.
`STORAGE_ID`	Storage ID of the database being replicated.
`COMPUTE_ID`	Compute ID of the database being replicated. This value changes when the primary compute session is suspended and resumed.
`ORDINAL`	Partition ordinal. -1 identifies the reference database.
`REPLAY_TERM`	Term of the replica's log tail.
`REPLAY_LSN`	Log sequence number (LSN) that the replica has replayed. This value can be NULL when it is unavailable.
`MASTER_TERM`	Term of the most recent log position that the primary uploaded to remote storage. This value can be NULL when the master position is unavailable.
`MASTER_LSN`	LSN of the most recent log chunk or snapshot that the primary uploaded to remote storage. This value can be NULL when the master position is unavailable.
`IS_CROSS_CLUSTER`	Whether the replica is a cross-cluster replica. 1 indicates a cross-cluster replica; 0 indicates a local, intra-cluster bottomless replica.
`MASTER_STATE`	Phase of the local bottomless fake master. This value is NULL when no fake master is running for the replica, such as when the fake master has failed and is restarting.

Example:

SELECT *
FROM information_schema.MV_BOTTOMLESS_READ_REPLICAS_STATE;

+---------+-----------------------------------------+------------------------+---------+-------------+------------+-------------+------------+------------------+--------------+
| NODE_ID | STORAGE_ID                              | COMPUTE_ID             | ORDINAL | REPLAY_TERM | REPLAY_LSN | MASTER_TERM | MASTER_LSN | IS_CROSS_CLUSTER | MASTER_STATE |
+---------+-----------------------------------------+------------------------+---------+-------------+------------+-------------+------------+------------------+--------------+
| 1       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | -1      | 3           | 1611       | 3           | 1614       | 1                | Streaming    |
| 2       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | -1      | 3           | 1613       | 3           | 1614       | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 2       | 6           | 997        | 6           | 998        | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 4       | 8           | 1011       | 8           | 1012       | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 14      | 18          | 940        | 18          | 941        | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 10      | 14          | 1058       | 14          | 1059       | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 8       | 12          | 1075       | 12          | 1076       | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 0       | 4           | 959        | 4           | 960        | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 6       | 10          | 1115       | 10          | 1116       | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | -1      | 3           | 1613       | 3           | 1614       | 1                | Streaming    |
| 3       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 12      | 16          | 1141       | 16          | 1142       | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 13      | 17          | 1128       | 17          | 1129       | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 5       | 9           | 972        | 9           | 973        | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 11      | 15          | 794        | 15          | 795        | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 9       | 13          | 1001       | 13          | 1002       | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 3       | 7           | 1072       | 7           | 1073       | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 7       | 11          | 1018       | 11          | 1019       | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | -1      | 3           | 1613       | 3           | 1614       | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 1       | 5           | 993        | 5           | 994        | 1                | Streaming    |
| 4       | 5425753636784760333:3927366288737761212 | 15387047735061808417:5 | 15      | 19          | 853        | 19          | 854        | 1                | Streaming    |
+---------+-----------------------------------------+------------------------+---------+-------------+------------+-------------+------------+------------------+--------------+

LMV_BOTTOMLESS_READ_REPLICAS_STATE

This view is the local version of MV_BOTTOMLESS_READ_REPLICAS_STATE. It displays only the smart read replica partitions present on the node where you run the query.

You can query this view from any node in the cluster.

This schema's column names and description are the same as for MV_BOTTOMLESS_READ_REPLICAS_STATE described above.

MV_BOTTOMLESS_READ_REPLICAS_STATE

On this page

LMV_BOTTOMLESS_READ_REPLICAS_STATE

Was this article helpful?

On this page

Was this article helpful?