Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
6.2.1
-
None
Description
Unusual increase in memory consumption by ExeMgr during execution of the specific query which cause OOM error.
Running the same query iteratively I found that the memory consumption by ExeMgr is increasing iteratively as well and finally cause a OOM error.
The query:
select
|
s_name,
|
count(*) as numwait |
from
|
supplier,
|
lineitem l1,
|
orders,
|
nation
|
where
|
s_suppkey = l1.l_suppkey
|
and o_orderkey = l1.l_orderkey |
and o_orderstatus = 'F' |
and l1.l_receiptdate > l1.l_commitdate |
and exists ( |
select |
*
|
from |
lineitem l2
|
where |
l2.l_orderkey = l1.l_orderkey
|
and l2.l_suppkey <> l1.l_suppkey |
)
|
and not exists ( |
select |
*
|
from |
lineitem l3
|
where |
l3.l_orderkey = l1.l_orderkey
|
and l3.l_suppkey <> l1.l_suppkey |
and l3.l_receiptdate > l3.l_commitdate |
)
|
and s_nationkey = n_nationkey |
and n_name = 'EGYPT' |
group by |
s_name
|
order by |
numwait desc, |
s_name
|
LIMIT 100;
|
I use sysbench and 10G of data to run the query.