NODES System Table Description
Description
A pseudo table generated to show information about NuoDB processes (TEs and SMs) in the database. Each row in the SYSTEM.NODES
table represents one process in the NuoDB database.
Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.
|
Fields
Field | Type | Description | ||
---|---|---|---|---|
ID |
bigint |
The actual node ID in the database, incremented continually as new nodes come into the database.
|
||
STARTID |
bigint |
The NuoDB Admin start ID for this process. See Start ID. |
||
LOCALID |
integer |
The node ID used locally which will be reused as nodes come in and out of the database. |
||
FASTID_SEED |
smallint |
An internal value used when creating unique IDs. |
||
PORT |
integer |
The port on which this node is receiving messages. |
||
ADDRESS |
string |
The IP address on which this node is running. |
||
HOSTNAME |
string |
The host name of the physical machine on which this node is running. |
||
STATE |
string |
The state of this node: Running, Syncing, or Unknown |
||
TYPE |
string |
Storage (SM) or Transaction (TE) |
||
CONNSTATE |
string |
The state of the connection: Ready, Not Ready, Opening, Connecting, Flushing, Unknown |
||
MSGQSIZE |
integer |
The number of messages received and cached on this node. |
||
TRIPTIME |
integer |
The amount of time in microseconds, from when the TE to which the client is currently connected, |
||
GEOREGION |
string |
This field has been deprecated. Do not use. |
||
MINATOM_VER |
string |
The minimum version of any atom in the archive. On SMs, it will contain a percent-complete if the archive is currently being updated to this version. This value will always be empty for TEs. |
||
DISK_ENCRYPTION |
string |
The type of Transparent Data Encryption (TDE) enabled for this node: |
||
PLATFORM_VER |
integer |
Internal build number used to create this database processes (TE or SM). |
||
RELEASE_VER |
string |
External release number string used to create this database process (TE or SM). |
||
DEFAULT_SQLENGINE |
string |
In NuoDB 4.3 and above the execution engine used by connections to this node is always "Vectorized." This value will always be empty for SMs. |
Example
This example shows SYSTEM.NODES
for a database with one SM and one TE (See Running the SQL QuickStart):
SET OUTPUT VERTICAL;
SELECT * FROM system.nodes;
==================================== Row #1 ====================================
ID: 1
STARTID: 1
LOCALID: 1
FASTID_SEED: 1
PORT: 48006
ADDRESS: 172.18.0.3
HOSTNAME: examplehost1
STATE: Running
TYPE: Storage
CONNSTATE: Ready
MSGQSIZE: 0
TRIPTIME: 543
GEOREGION: 0
MINATOM_VER: 7.0
DISK_ENCRYPTION: NONE
PLATFORM_VER: 1769472
RELEASE_VER: 7.0-1-c8890aa3ab
DEFAULT_SQLENGINE:
==================================== Row #2 ====================================
ID: 2
STARTID: 2
LOCALID: 0
FASTID_SEED: 2
PORT: 48006
ADDRESS: 172.18.0.4
HOSTNAME: examplehost2
STATE: Running
TYPE: Transaction
CONNSTATE: Ready
MSGQSIZE: 0
TRIPTIME: 0
GEOREGION: 0
MINATOM_VER:
DISK_ENCRYPTION: NONE
PLATFORM_VER: 1769472
RELEASE_VER: 7.0-1-c8890aa3ab
DEFAULT_SQLENGINE: Vectorized