Yi Jin created HAWQ-260:
---------------------------
Summary: 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: Lei Chang
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)
