CREATE PROJECTION Hangs

Explanation

In theory, this should never occur.

Workaround

If the CREATE PROJECTION statement is still hanging after five minutes:

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

   SELECT DUMP_LOCKTABLE();

   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.