You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Lei Chang (JIRA)" <ji...@apache.org> on 2016/01/24 02:22:39 UTC

[jira] [Updated] (HAWQ-260) Resource manager wrongly calculates number of vseg

     [ https://issues.apache.org/jira/browse/HAWQ-260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lei Chang updated HAWQ-260:
---------------------------
    Fix Version/s: 2.0.0

> 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)