Event Data

To help you interpret and solve the issue that triggered an event, each event provides a variety of data, depending upon the event logging mechanism used.

The following table describes the event data and indicates where it is used.

vertica.log ACTIVE_EVENTS
(column names)
SNMP Syslog Description

N/A

NODE_NAME

N/A

N/A

The node where the event occurred.

Event Code

EVENT_CODE

Event Type

Event Code

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

Event Id

EVENT_ID

Event OID

Event Id

A unique numeric ID that identifies the specific event.

Event Severity

EVENT_

SEVERITY

Event Severity

Event Severity

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 – Info

7 – Debug

PostedTimestamp

EVENT_

POSTED_

TIMESTAMP

N/A

PostedTimestamp

The year, month, day, and time the event was reported. Time is provided as military time.

ExpirationTimestamp

EVENT_

EXPIRATION

N/A

ExpirationTimestamp

The time at which this event expires. If the same event is posted again prior to its expiration time, this field gets updated to a new expiration time.

EventCodeDescription

EVENT_CODE_

DESCRIPTION

Description

EventCodeDescription

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

ProblemDescription

EVENT_PROBLEM_

DESCRIPTION

Event Short Description

ProblemDescription

A generic description of the event.

N/A

REPORTING_

NODE

Node Name

N/A

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

DatabaseName

N/A

Database Name

DatabaseName

The name of the database that is impacted by the event.

N/A

N/A

Host Name

Hostname

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

N/A

N/A

Event Status

N/A

The status of the event. It can be either:

1 – Open

2 – Clear