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.

Caution: 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.
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 The Geo region specified when the host, on which this node is running, was configured for the domain.
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).

Indexes

None

Example

This example shows SYSTEM.NODES for a Minimally Redundant database started from SQL QuickStart and running on two Amazon EC2 instances. (See Running the SQL QuickStart.) We use SET OUTPUT VERTICAL here to make the display more readable.

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: us-east-1
PLATFORM_VER: 102
RELEASE_VER: 2.1.rel21-51-4074924
==================================== 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
GEOREGION: us-east-1
PLATFORM_VER: 102
RELEASE_VER: 2.1.rel21-51-4074924
==================================== 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: us-east-1
PLATFORM_VER: 102
RELEASE_VER: 2.1.rel21-51-4074924
==================================== 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: us-east-1
PLATFORM_VER: 102
RELEASE_VER: 2.1.rel21-51-4074924