Error: the vertica process for the database is running on the following hosts mesaage is seen when starting vertica

book

Article ID: 195505

calendar_today

Updated On:

Products

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

Issue/Introduction

When we attempt to start vertica through adminTools the following error is seen

Error: the vertica process for the database is running on the following hosts:
xx.x.xxx.xx
This may be because the process has not completed previous shutdown activities. Please wait and retry again.
Database start up failed.  Processes still running. 
Press RETURN to continue

Cause

Hung vertica processes that must be killed

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

Run ps aux |grep vertica

 

# ps aux | grep vertica
dradmin    6884  0.0  0.0 113176  1468 ?        Ss   May25   0:00 /bin/bash /opt/vertica/agent/agent.sh /opt/vertica/config/users/dradmin/agent.conf
dradmin    6892  0.7  0.2 1345200 41868 ?       Sl   May25 597:40 /opt/vertica/oss/python/bin/python ./simply_fast.py
dradmin    6993  0.0  0.0  19448  3244 ?        S    May25  22:28 /opt/vertica/spread/sbin/spread -c /loddisk2/catalog/drdata/v_drdata_node0001_catalog/spread.conf -D /opt/vertica/spread/tmp
dradmin    6995  3.4 28.1 23290392 4569376 ?    Sl   May25 2835:46 /opt/vertica/bin/vertica -D /loddisk2/catalog/drdata/v_drdata_node0001_catalog -C drdata -n v_drdata_node0001 -h xx.xx.xx.xx -p 5433 -P 4803 -Y ipv4
dradmin    7036  0.0  0.0  58188  3644 ?        Sl   May25  23:46 /opt/vertica/bin/vertica-udx-zygote 13 3 6995 debug-log-off /loddisk2/catalog/drdata/v_drdata_node0001_catalog/UDxLogs 60 14 0
root     114370  0.0  0.0 112708   980 pts/0    S+   19:20   0:00 grep --color=auto vertica

 

If the vertica process is hung you will likely see a process like 6995 noted above.  You would need to do a kill -9 6995 (in this case) then restart the vertica database from adminTools and it should start up fine

 

Additional Information

Monitoring Process Status:

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/MonitoringProcessStatusPs.htm?TocPath=Administrator%27s%20Guide%7CMonitoring%20Vertica%7C_____3