cannot start node by using admintools

- we have 8 node of the cluster
- SSH/ Passwordless already setup ***
- I use the command as below:



/opt/vertica/bin/admintools -t restart_node -s -d TEST_DW -p password -F

- I try to run each node . It show the same error:


*** Restarting hosts for database TEST_DW ***
restart host with catalog v_TEST_DW_node0005_catalog
issuing multi-node restart
Unable to SSH as dbadmin to : UNEXPECTED EOF: Could not login with ssh. ssh output: 'usage: ssh [-1246AaCfgKkMNnqsTtVvXxYy] [-b bind_address] [-c cipher_spec]\r\n [-D [bind_address:]port] [-e escape_char] [-F configfile]\r\n [-I pkcs11] [-i identity_file]\r\n [-L [bind_address:]port:host:hostport]\r\n [-l login_name] [-m mac_spec] [-O ctl_cmd] [-o option] [-p port]\r\n [-R [bind_address:]port:host:hostport] [-S ctl_path]\r\n [-W host:port] [-w local_tun[:remote_tun]]\r\n [user@]hostname [command]\r\n'
Could not login with SSH to host

Starting nodes:

All nodes to start have failed startup tests. Nothing to do.
Restart Hosts result: Failed startup tests. Nothing to do.



- please help me to solve it.


  • Options
    SruthiASruthiA Vertica Employee Administrator



       what is the vertica version you are using? Can you share me vertica.log and output of following command


    admintools -t list_allnodes




  • Options

    version : vertica-7.1.1


    [dbadmin@hk-agvtc-2201 config]$ admintools -t list_allnodes
    Node | Host | State | Version | DB
    v_test_dw_node0001 | | UP | vertica- | test_DW
    v_test_dw_node0002 | | UP | vertica- | test_DW
    v_test_dw_node0003 | | UP | vertica- | test_DW
    v_test_dw_node0004 | | UP | vertica- | test_DW
    v_test_dw_node0005 | | UP | vertica- | test_DW
    v_test_dw_node0007 | | UP | vertica- | test_DW
    v_test_dw_node0008 | | UP | vertica- | test_DW
    v_test_dw_node0009 | | UP | vertica- | test_DW


    [dbadmin@hk-agvtc-2201 config]$ admintools -t view_cluster
    DB | Host | State
    test_DW | ALL | UP

  • Options

    - here is the admintools.conf


    last_port = 5433
    default_base = /home/dbadmin
    format = 3
    spreadlog = False
    controlsubnet = default
    controlmode = broadcast
    tmp_dir = /tmp

    hosts =,,,,,,,,

    node0008 =,/home/dbadmin,/home/dbadmin
    node0004 =,/home/dbadmin,/home/dbadmin
    node0005 =,/home/dbadmin,/home/dbadmin
    node0007 =,/home/dbadmin,/home/dbadmin
    node0006 =,/home/dbadmin,/home/dbadmin
    node0001 =,/home/dbadmin,/home/dbadmin
    node0002 =,/home/dbadmin,/home/dbadmin
    node0003 =,/home/dbadmin,/home/dbadmin
    node0009 =,/home/dbadmin,/home/dbadmin
    v_test_dw_node0001 =,/test/test_DW,/data/test_DW
    v_test_dw_node0002 =,/test/test_DW,/data/test_DW
    v_test_dw_node0003 =,/test/test_DW,/data/test_DW
    v_test_dw_node0004 =,/test/test_DW,/data/test_DW
    v_test_dw_node0005 =,/test/test_DW,/data/test_DW
    v_test_dw_node0007 =,/test/test_DW,/data/test_DW
    v_test_dw_node0008 =,/test/test_DW,/data/test_DW
    v_test_dw_node0009 =,/test/test_DW,/data/test_DW

    restartpolicy = ksafe
    port = 5433
    path = /test/test_DW/test_DW/v_test_dw_node0009_catalog
    nodes = v_test_dw_node0001,v_test_dw_node0002,v_test_dw_node0003,v_test_dw_node0004,v_test_dw_node0005,v_test_dw_node0007,v_test_dw_node0008,v_test_dw_node0009

  • Options
    SruthiASruthiA Vertica Employee Administrator



        Thank you for the output. Can you try restarting the db and share me vertica.log, it is present in the /test/test_DW/test_DW/v_test_dw_node0009_catalog directory



    Thank you,


Leave a Comment

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