The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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 192.168.11.65 -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 192.168.11.65 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 [[email protected]]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.

Comments

  • SruthiASruthiA Employee

    HI,

     

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

     

    admintools -t list_allnodes

     

     

    Sruthi

  • version : vertica-7.1.1

     

    [[email protected] config]$ admintools -t list_allnodes
    Node | Host | State | Version | DB
    ---------------------+---------------+-------+-------------------+------
    ---------------------+---------------+-------+-------------------+----
    v_test_dw_node0001 | 192.168.11.61 | UP | vertica-7.1.1.000 | test_DW
    v_test_dw_node0002 | 192.168.11.62 | UP | vertica-7.1.1.000 | test_DW
    v_test_dw_node0003 | 192.168.11.63 | UP | vertica-7.1.1.000 | test_DW
    v_test_dw_node0004 | 192.168.11.64 | UP | vertica-7.1.1.000 | test_DW
    v_test_dw_node0005 | 192.168.11.65 | UP | vertica-7.1.1.000 | test_DW
    v_test_dw_node0007 | 192.168.11.67 | UP | vertica-7.1.1.000 | test_DW
    v_test_dw_node0008 | 192.168.11.68 | UP | vertica-7.1.1.000 | test_DW
    v_test_dw_node0009 | 192.168.11.69 | UP | vertica-7.1.1.000 | test_DW

     

    [[email protected] config]$ admintools -t view_cluster
    DB | Host | State
    ----------+------+-------
    test_DW | ALL | UP

  • - here is the admintools.conf

     

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

    [Cluster]
    hosts = 192.168.11.68,192.168.11.64,192.168.11.65,192.168.11.66,192.168.11.67,192.168.11.61,192.168.11.62,192.168.11.63,192.168.11.69

    [Nodes]
    node0008 = 192.168.11.68,/home/dbadmin,/home/dbadmin
    node0004 = 192.168.11.64,/home/dbadmin,/home/dbadmin
    node0005 = 192.168.11.65,/home/dbadmin,/home/dbadmin
    node0007 = 192.168.11.67,/home/dbadmin,/home/dbadmin
    node0006 = 192.168.11.66,/home/dbadmin,/home/dbadmin
    node0001 = 192.168.11.61,/home/dbadmin,/home/dbadmin
    node0002 = 192.168.11.62,/home/dbadmin,/home/dbadmin
    node0003 = 192.168.11.63,/home/dbadmin,/home/dbadmin
    node0009 = 192.168.11.69,/home/dbadmin,/home/dbadmin
    v_test_dw_node0001 = 192.168.11.61,/test/test_DW,/data/test_DW
    v_test_dw_node0002 = 192.168.11.62,/test/test_DW,/data/test_DW
    v_test_dw_node0003 = 192.168.11.63,/test/test_DW,/data/test_DW
    v_test_dw_node0004 = 192.168.11.64,/test/test_DW,/data/test_DW
    v_test_dw_node0005 = 192.168.11.65,/test/test_DW,/data/test_DW
    v_test_dw_node0007 = 192.168.11.67,/test/test_DW,/data/test_DW
    v_test_dw_node0008 = 192.168.11.68,/test/test_DW,/data/test_DW
    v_test_dw_node0009 = 192.168.11.69,/test/test_DW,/data/test_DW

    [Database: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

  • SruthiASruthiA Employee

    Hi,

     

        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,

    Sruthi

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.