ERROR_MESSAGES

Lists system error messages and warnings Vertica encounters while processing queries. Some errors occur when no transaction is in progress, so the transaction identifier or statement identifier columns might return NULL.

Column Name Data Type Description 
EVENT_TIMESTAMP

TIMESTAMPTZ

Time when the row recorded the event

 
NODE_NAME

VARCHAR

Name of the node that is reporting the requested information

 
USER_ID

INTEGER

Identifier of the user who received the error message

 
USER_NAME

VARCHAR

Name of the user who received the error message when Vertica recorded the session

 
SESSION_ID

VARCHAR

Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes.

 
REQUEST_ID

INTEGER

Unique identifier of the query request in the user session

 
TRANSACTION_ID

INTEGER

Identifier for the transaction within the session, if any; otherwise NULL

 
STATEMENT_ID

INTEGER

Unique numeric ID for the currently-running statement. NULL indicates that no statement is currently being processed. The combination of TRANSACTION_ID, STATEMENT_ID, and REQUEST_ID uniquely identifies a statement within a session.

 
ERROR_LEVEL

VARCHAR

Severity of the error, one of the following:

  • LOG
  • INFO
  • NOTICE
  • WARNING
  • ERROR
  • ROLLBACK
  • INTERNAL
  • FATAL
  • PANIC
 
ERROR_CODE

INTEGER

Error code that Vertica reports

 
MESSAGE

VARCHAR

Textual output of the error message

 
DETAIL

VARCHAR

Additional information about the error message, in greater detail

 
HINT

VARCHAR

Actionable hint about the error. For example:

HINT: Set the locale in this session to en_US@collation=binary using the command "\locale en_US@collation=binary"

Privileges

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.