Investigate Data Collector Table Data Produced by Scrutinize

The diagnostics tool scrutinize collects a broad range of information from a Vertica cluster. Part of the output from scrutinize includes data collector table data. Once extracted, we can easily load the data from a data collector table file into a Vertica Flex Table for analysis!

Let’s take a look at the data from the DC_ERRORS data collector table stored in a file called Errors on node 2.

Example:

dbadmin=> CREATE FLEX TABLE scrut_errors();
CREATE TABLE
dbadmin=> \! pwd
/home/dbadmin/VerticaScrutinize.20190903125316/v_test_db_node0002/normal/DC
dbadmin=> COPY scrut_errors FROM '/home/dbadmin/VerticaScrutinize.20190903125316/v_test_db_node0002/normal/DC/Errors' PARSER fdelimitedparser(delimiter=E'\1', record_terminator=E'\2');
Rows Loaded
-------------
222
(1 row)
dbadmin=> SELECT compute_flextable_keys_and_build_view('scrut_errors');
compute_flextable_keys_and_build_view
-------------------------------------------------------------------------------------------------------------
Please see public.scrut_errors_keys for updated keys
The view public.scrut_errors_view is ready for querying
(1 row)
dbadmin=> SELECT time, message FROM public.scrut_errors_view ORDER BY time DESC LIMIT 5;
time | message
-------------------------------+------------------------------------------------------------------------
2019-09-03 23:19:18.652508-04 | Database "test2" does not exist
2019-09-03 23:00:34.489693-04 | Cannot rollback; no transaction in progress
2019-09-03 23:00:09.944802-04 | Cannot rollback; no transaction in progress
2019-09-03 23:00:09.686553-04 | Cannot rollback; no transaction in progress
2019-09-03 22:59:02.376097-04 | Node startup/recovery in progress. Not yet ready to accept connections
(5 rows)

Helpful Link:

https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Diagnostics/CollectingDiagnosticsScrutinizeCommand.htm

Have fun!