Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

Posted July 31, 2023 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin

Amrita Akshay, Information Developer
October 12, 2023

With over 380K downloads, the Vertica Grafana Data Source plugin just got an upgrade! The plugin was migrated from the deprecated older Grafana toolkit to align with Grafana's new Create-Plugin tool. This accelerates the plugin development with their modern build set up that requires no additional configuration. Additionally, the Vertica SQL Go driver received an...
Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...

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

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

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

Explore Popular Topics

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Partner Integrations
Vertica
Open Source
AWS
IoT
Time series

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