A Node In A Vertica Cluster Is Down

book

Article ID: 196025

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Data Repository (Vertica) is part of a three node Vertica cluster setup.  Two nodes are up but one node is down.  Starting the database on the failed node fails.

Cause

In this scenario there was a power cut (UPS failed), resulting in no power to servers causing database corruption.

Resolution

On the failed node run the following command:

/opt/vertica/bin/admintools -t restart_node -d <database_name> --force

Note: This operation for this customer took over an hour. 

Additional Information

What should I do when the database node is down?

https://www.vertica.com/blog/what-should-i-do-when-the-database-node-is-down/