Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The oceanbase.DBA_OB_LS_LOCATIONS view displays the distribution of the log stream (LS) replicas in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CREATE_TIME | datetime(6) | NO | The time when the log stream was created. |
| MODIFY_TIME | datetime(6) | NO | The time when the log stream was modified. |
| 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. |
| SQL_PORT | bigint(20) | NO | The SQL port number. |
| ZONE | varchar(128) | NO | The name of the zone. |
| ROLE | varchar(8) | NO | The role of the replica. Valid values: LEADERFOLLOWER |
| MEMBER_LIST | varchar(4480) | NO | The list of replica members. This column is valid when ROLE is set to LEADER, and is NULL if otherwise. |
| PAXOS_REPLICA_NUMBER | bigint(20) | NO | The quorum of a Paxos group. This column is valid when ROLE is set to LEADER, and is NULL if otherwise. |
| REPLICA_TYPE | varchar(18) | NO | The type of the replica. Valid values: FULL: indicates a full-featured replica.LOGONLY: indicates a log replica.READONLY: indicates a read-only replica.ENCRYPTION_LOGONLY: indicates an encrypted log replica.NULL: indicates an unknown replica type. |
| LEARNER_LIST | longtext | YES | A list of read-only replicas for the current log stream.
NoteThis column is introduced since OceanBase Database V4.2.0. |
| REBUILD | varchar(5) | NO | Indicates whether the replica is being rebuilt.
NoteThis column is introduced since OceanBase Database V4.2.1. |
Sample query
The following example shows how to view the distribution information of log stream replicas for the current tenant. The system tenant has only one log stream (Number 1).
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_LS_LOCATIONS;
The query result is as follows:
+----------------------------+----------------------------+-------+----------------+----------+----------+-------+--------+-----------------------+----------------------+--------------+--------------+---------+
| CREATE_TIME | MODIFY_TIME | LS_ID | SVR_IP | SVR_PORT | SQL_PORT | ZONE | ROLE | MEMBER_LIST | PAXOS_REPLICA_NUMBER | REPLICA_TYPE | LEARNER_LIST | REBUILD |
+----------------------------+----------------------------+-------+----------------+----------+----------+-------+--------+-----------------------+----------------------+--------------+--------------+---------+
| 2024-09-04 09:47:44.144634 | 2024-09-04 09:47:44.144634 | 1 | 172.xx.xxx.xxx | 2882 | 2881 | zone1 | LEADER | 172.xx.xxx.xxx:2882:1 | 1 | FULL | | FALSE |
+----------------------------+----------------------------+-------+----------------+----------+----------+-------+--------+-----------------------+----------------------+--------------+--------------+---------+
1 row in set