Node is down, but still i am able to connect to Database from it.

Nithesh

I am having a weird problem with Vertica 3-node cluster setup. Only one node comes up while creating database. Following is the status of the nodes: [dbadmin@ip-10-0-2-185 ~]$ admintools -t list_allnodes Node | Host | State | Version | DB ---------------------+------------+-------+-----------------+---------- v_mpp_test_node0001 | 10.0.2.184 | UP | vertica-7.2.3.0 | MPP_TEST v_mpp_test_node0002 | 10.0.2.185 | DOWN | vertica-7.2.3.0 | MPP_TEST v_mpp_test_node0003 | 10.0.2.186 | DOWN | vertica-7.2.3.0 | MPP_TEST But still i am able to connect to the database from that node. Query Database too. ADP_TEST=> \! hostname ip-10-0-2-185 ADP_TEST=> select * from schemata; schema_id | schema_name | schema_owner_id | schema_owner | system_schema_creator | create_time | is_system_schema -------------------+-------------+-------------------+--------------+-----------------------+-------------------------------+------------------ 8300 | v_internal | 45035996273704962 | dbadmin | dbadmin | 2016-08-03 06:09:59.829151+00 | t 8301 | v_catalog | 45035996273704962 | dbadmin | dbadmin | 2016-08-03 06:09:59.829201+00 | t 8302 | v_monitor | 45035996273704962 | dbadmin | dbadmin | 2016-08-03 06:09:59.829216+00 | t 45035996273704978 | public | 45035996273704962 | dbadmin | | 2016-08-03 06:09:58.53816+00 | f 45035996273722426 | v_idol | 45035996273704962 | dbadmin | | 2016-08-03 06:22:08.438045+00 | f 45035996273722496 | v_txtindex | 45035996273704962 | dbadmin | | 2016-08-03 06:22:08.802094+00 | f its a Vertica 7.2.3 setup on AWS VPC. I even killed the vertica process on one of the nodes that is down, still i was able to connect to the database from that node using admintools. I am unable to understand what is happening here. Is this some issue with how the servers are setup?