Error: the vertica process for the database is running on the following hosts mesaage is seen when starting vertica
Article ID: 195505
Updated On:
Products
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
Environment
All supported releases
Cause
Hung Vertica processes that must be killed
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
Feedback
