Node is down, but still i am able to connect to Database from it.
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?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.