The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Investigate Data Collector Table Data Produced by a Scrutinize

The diagnostics tool scrutinize collects a broad range of information from a Vertica cluster. Part of the output from a 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 Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Diagnostics/CollectingDiagnosticsScrutinizeCommand.htm

Have fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.