cannot start node by using admintools

Peacherr

- 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 [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.

SruthiA

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

Peacherr

version : vertica-7.1.1

 

[dbadmin@hk-agvtc-2201 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

 

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

Peacherr

- 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

SruthiA

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