View Database Cluster State

This tool shows the current state of the nodes in the database.

1. On the Main Menu, select View Database Cluster State.

   

2. The normal state of a running database is ALL UP. The normal state of a stopped database is ALL DOWN.

   

3. If some nodes are UP and some DOWN, restart the database as described in Starting and Stopping the Database (unless you have a known node failure and wish to continue in that state.)

   

4. Nodes that are INITIALIZING or RECOVERING indicate that failure recovery is in progress.
5. Nodes in other states (such as NEEDS_CATCHUP) are transitional and can be ignored unless they persist. In that case, call 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.

For more information, see:

• the Advanced section of the Administration Tools
• Startup Problems
• Shutdown Problems