Options

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

  • Options
    SruthiASruthiA Vertica Employee Administrator

    Hi,

     

     

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

     

    Sruthi

  • Options

     

     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