Vertica Blog

Vertica Blog

Checklists

Why Does My Node Not Connect to Spread?

Soniya Shah, Information Developer
June 14, 2018

If your node is not connected to spread, follow the below steps to troubleshoot the connection issue. Step Task Results 1 Check whether the spread.conf file in the catalog folder is identical across all the nodes in the cluster. If the spread.conf flies are identical across all nodes, go to Step 2. If the spread.conf...

Investigate Sudden Performance Degradation of a Query

Soniya Shah, Information Developer
June 14, 2018

Have you ever had a formerly fast-running query begin to run slowly? Use the following checklist to investigate the sudden slowdown of a formerly fast-running query. Step Task Results 1 Check for host error messages using the following commands: If the cluster is in good health, go to Step 2. If the cluster is not...

What Should I do if the Database Performance is Slow?

Soniya Shah, Information Developer
June 14, 2018

Troubleshootusing the following checklist if your database performance is slow. Check if any of the following problems exist: Step Task Results 1 Is the query performance slow? If the query performance is slow, review the Query Performance checklist. If the query performance is not slow, go to Step 2. 2 Is the entire database slow?...

Catalog Size Debugging

Soniya Shah, Information Developer
June 14, 2018

You have a large catalog if your catalog size is more than 10 GB or your catalog is changing more than 5% per day. This checklist gives you some suggestions and recommendations to monitor and reduce your database catalog size. The database catalog contains tractable metadata such as tables, projections, users, nodes, ROSes, and so...

How Do I Manage Delete Vectors?

Soniya Shah, Information Developer
June 14, 2018

If you want to remove delete vectors manually or troubleshoot why they are not being removed automatically, follow this checklist. Step Task Results 1 Check if you have too many delete vectors (more than 100) in a projection. If there are too many delete vectors as shown by the num_dv (usually more than 100), go...

What Should I do When the Database Process is not Starting?

Soniya Shah, Information Developer
June 14, 2018

If you want to troubleshoot why the database process is not starting, follow this checklist. Step Task Results 1 Ensure Vertica is not already running on any node. The Vertica process displays as follows: Prior to proceeding to any further checks, ensure the dbadmin is the owner of and has access to the catalog directory...

What Should I do When the Database Node is DOWN?

Soniya Shah, Information Developer
June 14, 2018

When database node is DOWN, troubleshoot using the following checklist. Step Task Results 1 Check whether your database is UP. If the database is UP, go to Step 2. If the database if not UP, restart your database. If the database starts, the checklist is complete. If the database does not start, see the Database...

What Version of Vertica am I Running?

Sarah Lemaire, Manager, Vertica Documentation
June 14, 2018

Jim Knicely authored this tip. The built-in VERSION function returns a VARCHAR that contains your Vertica node's version information. The Vertica version is formatted as X.Y.Z-R, where… • X.Y is the two-digit Vertica major release number, e.g., 8.1, 9.0 and 9.1 • Z is the service pack number, e.g., 7.2.3, 8.1.1 and 9.0.1 • R...