NODE_STATES

Monitors node recovery state-change history on the system.

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 thenode.
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

  • RECOVER_ERROR

  • RECOVERED

  • INITIALIZING

  • STANDBY

  • NEEDS_CATCHUP

The following flow chart details different node states:

Privileges

None