Not possible to gracefully stop the Data Repository (Vertica) node.

Products

• Network Observability
• CA Performance Management

Issue/Introduction

I would like to shutdown and restart the sever running Vertica node but I am unable to shutdown the DB even with a force option :

/opt/vertica/bin/admintools -t stop_node -d dbname --hosts host_ip_address --force

Environment

DX NetOps Performance Management : any release

Cause

server resources are so limited / utilized that command is not getting processed properly

Resolution

Behind the admintools command for stopping the node is a code sending the SIGTERM signal to Vertica processes.

SIGTERM is a level 15 kill signal so a more direct command to execute this command is :

kill -15 <PID>

Find Vertica PIDs on relevant server using the :

ps -ef | grep vertica

and kill.

Additional Information

Keep in mind that depending on your environment ( amount of nodes and backup frequency ) you may face a data loss.