The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica DB wont start

[dbadmin@node2 opt]$ admintools -t start_db -d VMart;
Info: no password specified, using none
Error: it appears as if the vertica process is stillrunning on the following hosts: []
please wait until the process exits before startingthe database.
[dbadmin@node2 opt]$

 

database is not starting , its a 3 nodes cluster , 3 VM on my laptop it was working before but probably didnt do a proper shutdown and now its failing to start , from admintools UI nothing happens when i try to start it . 

 

Comments

  • SruthiASruthiA Vertica Employee Employee

    Hi,

     

     

           Can you run ps -ef|grep vertica from all nodes and share me the output

     

    Sruthi

  •  

     Are your ip address the same ? on your virtual hosts ?

     

    What does your logs say ?

    /opt/vertica/log/adminTools.log

    /vertica/catalog/<db_name>/v_<db_name>_<node>_catalog/startup.log

     

    It might be very easy thing ! 95% of the times the logs will help you solve it.

     

     or wipeout all Vertica pids on all hosts

    ps -ef | grep vertica |grep -v grep |awk '{print "kill -9 "$2}'

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file