Vertica nodes are down and cannot be started

Products

• Network Observability
• CA Performance Management

Issue/Introduction

Error in the startup.log file:

Failure during commit of transaction 0xfff0000000000cc1, cannot proceed\n\tHINT: Vertica semantics require commit to succeed or the node to go down; restart this note\n\tLOCATION: commitTransaction, ...

Environment

DX NetOps PM: Any version

Cause

No free disk space in /catalog directory. The vertica.log file size is 86GB.

df -h

Filesystem         Size   Used  Avail  Used%  Mounted on
/dev/nvme4n1        98G    92G   1.1G    99%  /catalog

Resolution

Clean up the vertica.log file on node 2 and 3.

echo "" > vertica.log

 

Then started the Vertica using this KB article:

Unable to start the Vertica database