Note
This view is available starting with V4.0.0.
Purpose
This view displays information about all OBServer nodes.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| ID | bigint(20) | NO | The unique ID assigned to the cluster. |
| ZONE | varchar(128) | NO | The zone to which the OBServer node belongs. |
| SQL_PORT | bigint(20) | NO | The port used by the OBServer node to service SQL requests. |
| WITH_ROOTSERVER | varchar(3) | NO | YES: The Root Service is available.NO: The Root Service is unavailable. |
| STATUS | varchar(64) | NO | ACTIVE: The OBServer node is in communication with the RS.INACTIVE: The OBServer node has lost communication with the RS.DELETING: The OBServer node is being deleted. |
| START_SERVICE_TIME | timestamp(6) | NO | The time when the node can start to provide services after the node process is started.NULL: The node process has not been started or the node is unavailable. |
| STOP_TIME | timestamp(6) | NO | The time when the node service is stopped by the user.NULL: The node is not stopped. |
| BLOCK_MIGRATE_IN_TIME | timestamp(6) | NO | The time when data migration in is prohibited for the OBServer node NULL: Data migration in is not prohibited. |
| LAST_OFFLINE_TIME | timestamp(6) | NO | The last time when the OBServer node was offline NULL: The OBServer node has never been offline.Added in V4.2.0. |
| CREATE_TIME | timestamp(6) | YES | The time when the table was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the task was last modified. |
| BUILD_VERSION | varchar(256) | NO | The binary build version of the OBServer node. |
Sample query
Query the information about all OBServer nodes in the cluster as the sys tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_SERVERS\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 172.xx.xxx.xxx
SVR_PORT: 2882
ID: 1
ZONE: zone1
SQL_PORT: 2881
WITH_ROOTSERVER: YES
STATUS: ACTIVE
START_SERVICE_TIME: 2025-01-06 16:31:41.823169
STOP_TIME: NULL
BLOCK_MIGRATE_IN_TIME: NULL
CREATE_TIME: 2025-01-06 16:31:32.556126
MODIFY_TIME: 2025-01-06 16:31:43.487555
BUILD_VERSION: 4.2.5.2_102000012025010512-10209c65e7565e1e23b14c6a34c0a97063c8896e(Jan 5 2025 13:05:34)
LAST_OFFLINE_TIME: NULL
1 row in set