NODE_STATES

Monitors node recovery state-change history on the system.

Column Name Data Type Description 
EVENT_TIMESTAMP

TIMESTAMPTZ

Time when Vertica recorded the event.

 
NODE_ID

INTEGER

A unique numeric ID assigned by the Vertica catalog, which identifies the node.

 
NODE_NAME

VARCHAR

Name of the node that is reporting the requested information.

 
NODE_STATE

VARCHAR

Shows the node's state. Can be one of:

  • 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