NODESTORAGEGROUPS System Table Description

Description

A pseudo table generated to show which storage groups are served by each SM process in the 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 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, or 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.

OBSERVER

boolean

Set to True if this live archive node is a passive observer of this storage group.

Indexes

None

Example of Leader Candidate Configuration

$ nuocmd show storage-groups --db-name test
Storage groups for database: test
  [   1] [name = ALL] [state = Available]
    No Leader Candidates available
  [  10] [name = SG1] [state = Available]
    Leader Candidates:
      [SM] server0:48007 [start_id = 0] [pid = 248] [node_id = 3] MONITORED:RUNNING
      [SM] server1:48007 [start_id = 1] [pid = 90] [node_id = 1] MONITORED:RUNNING
  [   2] [name = UNPARTITIONED] [state = Available]
    Leader Candidates:
      [SM] server0:48007 [start_id = 0] [pid = 248] [node_id = 3] MONITORED:RUNNING
      [SM] server1:48007 [start_id = 1] [pid = 90] [node_id = 1] MONITORED:RUNNING