DUMP_CATALOG

If Vertica seems to be hung, use DUMP_CATALOG to check for deadlocked clients and the resources they are waiting for:

1. Open an additional vsql connection.
2. Execute the query:

   SELECT DUMP_CATALOG();

   The output is written to vertica.log (see Monitoring the Log Files),

3. Send the output to Technical Support.

   To submit problem reports, questions, comments, and suggestions, please use the Technical Support page on the Vertica Systems, Inc. Web site:

   http://www.vertica.com/support

   You must be a registered user in order to access the page.

   Before reporting a problem, please run the Diagnostics Utility described in the Troubleshooting Guide and attach the resulting .zip file.