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.

Deprecated in NuoDB 7.0 and later. Use STARTID instead.

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, TE1, first requests this information the node represented by this row until the time at which it TE1 gets the response back.

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: NONE or AES128. On SMs, it will contain a percent-complete if the archive is currently being encrypted to this type.

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.

Indexes

None

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