The V_MONITOR.ERROR_MESSAGES system table tracks error and warning messages encountered while processing queries.
Example:
dbadmin=> CREATE TABLE 123 (c1 INT);
ERROR 4856: Syntax error at or near "123" at character 14
LINE 1: CREATE TABLE 123 (c1 INT);
^
dbadmin=> SELECT event_timestamp, user_name, message FROM error_messages ORDER BY event_timestamp DESC LIMIT 1;
event_timestamp | user_name | message
-------------------------------+-----------+-------------------------------
2018-02-12 09:50:17.836661-05 | dbadmin | Syntax error at or near "123"
(1 row)
If you need a bit more info, like the cursor position of a syntax error, you can query the data collector table DC_ERRORS.Example:
dbadmin=> SELECT time, user_name, message, cursor_position FROM dc_errors ORDER BY time DESC LIMIT 1;
time | user_name | message | cursor_position
-------------------------------+-----------+-------------------------------+-----------------
2018-02-12 09:50:17.836661-05 | dbadmin | Syntax error at or near "123" | 14
(1 row)
Have fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
