NODE_STATES

Monitors node recovery state-change history on the system. Vertica returns information only on nodes whose state is currently UP. To determine which nodes are not up, query the NODES table.

Column Name Data Type Description
EVENT_TIMESTAMP

TIMESTAMPTZ

Time when Vertica recorded the event.
NODE_ID

INTEGER

Catalog-assigned integer value that uniquely identifies the node.
NODE_NAME

VARCHAR

Name of the node.
NODE_STATE

VARCHAR

The node's state, one of the following:

  • UP
  • DOWN
  • READY
  • UNSAFE
  • SHUTDOWN
  • SHUTDOWN ERROR
  • RECOVERING
  • RECOVERY ERROR
  • RECOVERED
  • INITIALIZING
  • STAND BY
  • NEEDS CATCH UP

The following flow chart details different node states:

Privileges

None