We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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

NitheshNithesh - Select Field -
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?

Leave a Comment

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