[
https://issues.apache.org/jira/browse/HAWQ-260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yi Jin resolved HAWQ-260.
-------------------------
Resolution: Fixed
> 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
>
> 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)
