ACTIVE_EVENTS

Returns all active events in the cluster. See Monitoring Events.

Column Name Data Type Description
NODE_NAME

VARCHAR

The node name where the event occurred.

EVENT_CODE

INTEGER

A numeric ID that indicates the type of event. See Event Types for a list of event type codes.

EVENT_ID

INTEGER

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

EVENT_SEVERITY

VARCHAR

The severity of the event from highest to lowest. These events are based on standard syslog severity types.

  • 0—Emergency
  • 1—Alert
  • 2—Critical
  • 3—Error
  • 4—Warning
  • 5—Notice
  • 6—Informational
  • 7—Debug
EVENT_POSTED_TIMESTAMP

TIMESTAMP

The year, month, day, and time the event was reported. The time is posted in military time.

EVENT_EXPIRATION

VARCHAR

The year, month, day, and time the event expire. The time is posted in military time. If the cause of the event is still active, the event is posted again.

EVENT_CODE_DESCRIPTION

VARCHAR

A brief description of the event and details pertinent to the specific situation.

EVENT_PROBLEM_DESCRIPTION

VARCHAR

A generic description of the event.

REPORTING_NODE

VARCHAR

The name of the node within the cluster that reported the event.

EVENT_SENT_TO_CHANNELS

VARCHAR

The event logging mechanisms that are configured for Vertica. These can include vertica.log, (configured by default) syslog, and SNMP.

EVENT_POSTED_COUNT

INTEGER

Tracks the number of times an event occurs. Rather than posting the same event multiple times, Vertica posts the event once and then counts the number of additional instances in which the event occurs.