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

integer

The actual node ID in the database, incremented continually as new nodes come into the database.

STARTID

integer

The NuoDB Admin start ID for this process. This value is always unique even across database and domain restart.

LOCALID

integer

The node ID used locally which will be reused as nodes come in and out of the database.

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 two SM / two TE database running on two Amazon EC2 instances. (See Running the SQL QuickStart):

SET OUTPUT VERTICAL;
SELECT * FROM system.nodes;
========================== Row #1 ==========================
ID: 1
LOCALID: 2
PORT: 48005
ADDRESS: 54.165.58.157
HOSTNAME: ec2-54-165-58-157.compute-1.amazonaws.com
STATE: Running
TYPE: Storage
CONNSTATE: Ready
MSGQSIZE: 1
TRIPTIME: 1012
GEOREGION: DEFAULT_REGION
MINATOM_VER: 4.1
DISK_ENCRYPTION: NONE
PLATFORM_VER: 1376256
RELEASE_VER: 4.1-1-011d582563
DEFAULT_SQLENGINE:
========================== Row #2 ==========================
ID: 2
LOCALID: 1
PORT: 48006
ADDRESS: 54.165.58.157
HOSTNAME: ec2-54-165-58-157.compute-1.amazonaws.com
STATE: Running
TYPE: Transaction
CONNSTATE: Ready
MSGQSIZE: 2
TRIPTIME: 1072
MINATOM_VER:
DISK_ENCRYPTION: NONE
PLATFORM_VER: 1376256
RELEASE_VER: 4.1-1-011d582563
DEFAULT_SQLENGINE: Vectorized
========================== Row #3 ==========================
ID: 3
LOCALID: 3
PORT: 48005
ADDRESS: 107.23.52.10
HOSTNAME: ec2-107-23-52-10.compute-1.amazonaws.com
STATE: Running
TYPE: Storage
CONNSTATE: Ready
MSGQSIZE: 2
TRIPTIME: 1111
GEOREGION: DEFAULT_REGION
MINATOM_VER: 4.1
DISK_ENCRYPTION: NONE
PLATFORM_VER: 1376256
RELEASE_VER: 4.1-1-011d582563
DEFAULT_SQLENGINE:
========================== Row #4 ==========================
ID: 4
LOCALID: 0
PORT: 48006
ADDRESS: localhost
HOSTNAME: ip-172-31-40-24.ec2.internal
STATE: Running
TYPE: Transaction
CONNSTATE: Ready
MSGQSIZE: 0
TRIPTIME: 0
GEOREGION: DEFAULT_REGION
MINATOM_VER:
DISK_ENCRYPTION: NONE
PLATFORM_VER: 1376256
RELEASE_VER: 4.1-1-011d582563
DEFAULT_SQLENGINE: Vectorized