Vertica Blog

Vertica Blog

Under the Hood

Why is the Vertica Host Slow?

Soniya Shah, Information Developer
June 14, 2018

Symptoms: Sluggish response time Server is CPU-bound with a high load and too many processes. The host is possibly in a hung state, unable to make connections, or connections are hanging. Possible causes: Low available memory Too many concurrent active processes running Server actively using swap space To troubleshoot, follow this checklist: Step Task Results...

What Should I do When Vertica Host is Down?

Soniya Shah, Information Developer
June 14, 2018

Each member of a Vertica cluster is referred to as a host throughout this checklist. The Vertica process communicates to other Vertica nodes in a cluster. Node refers to the Vertica database software. If your host is down, follow this checklist: Step Task Results 1 The Vertica host is physically powered off. No status lights...

Debug Vertica Host Network Connectivity

Soniya Shah, Information Developer
June 14, 2018

If your host is physically available and the operating system is up and running, but you cannot access your network to the Vertica cluster, then external connections might not be possible. Client software connections are failing, and users are not able to ssh to the host. From observing a hardware console connection, it looks like...
Three 3D arrows, different colors pointing in different directions

Upgrading Vertica

Soniya Shah, Information Developer
June 14, 2018

Vertica adds new features and enhances existing features with every release. To access the new and improved features, upgrade to the latest release of Vertica. Prerequisites Before you upgrade, perform the following: Perform a full database backup. If upgrade is unsuccessful, a full back up allows you to roll back to your current version. You...

Expanding Your Cluster with New Nodes

Soniya Shah, Information Developer
June 14, 2018

Does your business need more storage? Consider adding nodes to your database if you need more storage. Vertica recommends that you add all new nodes at the same time. You can use this checklist to add nodes. These are basic steps. There are additional options discussed in the Vertica documentation. Step Task Results 1 Perform...
Modern Database Analytics

What Should I do if the Ancient History Mark is not Advancing?

Soniya Shah, Information Developer
June 14, 2018

If the AHM is not advancing, troubleshoot using this checklist: Step Task Results 1 Check whether the Last Good Epoch (LGE) is advancing. If the LGE is advancing, go to Step 2. If the LGE is not advancing, go to Step 5. 2 Check whether all nodes are UP. If all the nodes are UP,...
Programmer

What Should I do to Shut Down Vertica Node for Maintenance?

Soniya Shah, Information Developer
June 14, 2018

If you need to shut down a Vertica node for maintenance, follow this checklist. Step Task Results 1 Verify that all cluster nodes are UP. To avoid a long node recovery time after shutdown, if one or more nodes is DOWN, identify and restart them using the instructions in Restarting Vertica on a Host. 2...

What Should I do if my Node Recovery is Slow?

Soniya Shah, Information Developer
June 14, 2018

If you are running Vertica 7.2.x or later, perform recovery by table. For details, see Recovery By Table in the Vertica documentation. If you are running a Vertica version prior to 7.1.x, stop the ETL jobs and restart node recovery. Step Task Results 1 Monitor progress of recovery: If is_running = f, recovery completed. Repeat...

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...