Skip to main content

Data is not getting distributed in all nodes of cluster why?

  • July 3, 2013
  • 3 replies
  • 15 views
renu
  • renu
  • Participating Frequently
i have created 3 node cluster . hoast1 hoast2 hoast3 i am loading data from hoast1 The problem i am facing is.... loaded data is not getting distributed in all nodes its using only hoast1 memory please help me out..

    3 replies

    Bhawana
    Forum|alt.badge.img
    • Bhawana
    • Participating Frequently
    • July 3, 2013
    Hi Renu, Can you please runt he following statement: get_node_dependencies(); and send me the result. Regards, Bhawana
    renu
    • renu
    • Author
    • Participating Frequently
    • July 4, 2013
    Hi Bhawna, Sorry for placing wrong question can you help me with following link where i have described my problem properly https://community.vertica.com/vertica/topics/insufficient_resources?rfm=1
    deb0687
    Forum|alt.badge.img+1
    • deb0687
    • Participating Frequently
    • November 5, 2015

    Hi Bhawana,

     

    This is regarding the same issue that I am facing now.

     

    As you told the I am sharing the output of select get_node_dependencies(); as below

     

    Deps:/n011 - cnt: 190/n101 - cnt: 190/n110 - cnt: 190/n111 - cnt: 39

     

    Also see the out put of below query.

     

    select  node_name,count(*) from query_requests group by 1;

     

    node_name                count
    v_pmdb_node0001    77895
    v_pmdb_node0002    2393
    v_pmdb_node0003    15

     

     

    I have set the load balance policy to roundrobin and ksafe 1 with 3 nodes

     

    Can you tell me why the load is not distributed ?

     

    Thnaks,

    Deb

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement