NODESTORAGEGROUPS System Table Description

Description

A pseudo table generated to show which storage groups are served by each SM process in the 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 bigint The ID of the storage group. This corresponds to the ID column in STORAGEGROUPS. (See SYSTEM.STORAGEGROUPS.)
NODEID integer The node ID of the SM process running in the database. This corresponds to the ID column in NODES. (See SYSTEM.NODES.)
STATE string The state of the SM process: Running, Syncing, Quiescing, Unquiescing, Quiesced, Unknown
LEADERCANDIDATE boolean Set to True if this live archive node can be the leader of this storage group the next time the database restarts. This means that this archive contains the complete effects on this storage group of all transactions committed in safe commit mode.

Indexes

None

Example of Leader Candidate Configuration

nuodb [nuotest/test] > show storageGroups
Database: test

[id=1] ALL Available
    No Leader Candidates.

  [id=2] UNPARTITIONED Available
    Leader Candidates:
    [SM] nuotest01/nuotest01:48005 (US_EAST) [ pid = 2204 ] [ nodeId = 1 ] RUNNING
    [SM] nuotest01/nuotest01:48008 (US_EAST) [ pid = 16990 ] [ nodeId = 7 ] RUNNING
  
  [id=10] SG1 Available
    Leader Candidates:
    [SM] nuotest01/nuotest01:48005 (US_EAST) [ pid = 2204 ] [ nodeId = 1 ] RUNNING
    [SM] nuotest01/nuotest01:48008 (US_EAST) [ pid = 16990 ] [ nodeId = 7 ] RUNNING