ACTIVE_EVENTS

Returns all active events in the cluster.

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.