[ https://issues.apache.org/jira/browse/HAWQ-260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lei Chang closed HAWQ-260. -------------------------- > Resource manager wrongly calculates number of vseg > -------------------------------------------------- > > Key: HAWQ-260 > URL: https://issues.apache.org/jira/browse/HAWQ-260 > Project: Apache HAWQ > Issue Type: Bug > Components: Resource Manager > Reporter: Yi Jin > Assignee: Yi Jin > Fix For: 2.0.0 > > > 2015-12-17 11:56:11.219946 > PST,,,p4922,th1934305472,,,,0,con4,,seg-10000,,,,,"LOG","00000","ConnID 24. > Expect query resource (128 MB, 0.031250 CORE) x 1000 (MIN 38) after checking > queue capacity.",,,,,,,0,,"resqueuemanager.c",3427, > 2015-12-17 11:56:11.219967 > PST,,,p4922,th1934305472,,,,0,con4,,seg-10000,,,,,"LOG","00000","ConnID 24. > Expect query resource (128 MB, 0.031250 CORE) x 40 (MIN 38) after checking > query expectation 40 (MIN 1).",,,,,,,0,,"resqueuemanager.c",3457, > 2015-12-17 11:56:11.219986 > PST,,,p4922,th1934305472,,,,0,con4,,seg-10000,,,,,"WARNING","01000","ConnID > 24. expected minimum number of virtual segments 38 exceeds the limit of > number of virtual segments per query per segment 8 in cluster having 3 > available segments",,,,,,,0,,"resqueuemanager.c",3513, > 2015-12-17 11:56:11.220006 > PST,,,p4922,th1934305472,,,,0,con4,,seg-10000,,,,,"WARNING","01000","ConnID > 24. expected minimum number of virtual segments 38 exceeds the limit of > number of virtual segments per query per segment 8 in cluster having 3 > available segments",,,,,,,0,,"resqueuemanager.c",2214, > 2015-12-17 11:56:11.220121 > PST,"gpadmin","tpch_0.01_parquet_partition",p16864,th1934305472,"10.32.35.224","48568",2015-12-17 > 11:56:11 PST,1352,con79,cmd1,seg-10000,,,x1352,sx1,"LOG","00000","AsyncComm > framework receives message 2307 from FD 141",,,,,,"select > Write failed: Broken pipe > jiny2:~ yijin$ sum(l_extendedprice * (1 - l_discount)) as revenue, > o_orderdate, > o_shippriority > from > customer, > orders, > lineitem > where > c_mktsegment = 'BUILDING' > and c_custkey = o_custkey > and l_orderkey = o_orderkey > and o_orderdate < date '1995-03-26' > and l_shipdate > date '1995-03-26' > group by > l_orderkey, > o_orderdate, > o_shippriority > order by > revenue desc, > o_orderdate > LIMIT 10;",0,,"rmcomm_Message.c",100, > 2015-12-17 11:56:11.359039 > PST,"gpadmin","tpch_0.01_parquet_partition",p16864,th1934305472,"10.32.35.224","48568",2015-12-17 > 11:56:11 PST,1352,con79,cmd1,seg-10000,,,x1352,sx1,"ERROR","XX000","failed > to acquire resource from resource manager, expected minimum number of virtual > segments 38 exceeds the limit of number of virtual segments per query per > segment 8 in cluster having 3 available segments (pquery.c:788)",,,,,,"select -- This message was sent by Atlassian JIRA (v6.3.4#6332)