Zach Amsden created IMPALA-6526:
-----------------------------------
Summary: Regression
query_test.test_spilling.TestSpillingDebugActionDimensions.test_spilling[exec_option:
{'debug_action': '-1:OPEN:[email protected]',
'default_spillable_buffer_size': '256k'} | table_format: parquet/none] (from
pytest)
Key: IMPALA-6526
URL: https://issues.apache.org/jira/browse/IMPALA-6526
Project: IMPALA
Issue Type: Bug
Reporter: Zach Amsden
Assignee: Bikramjeet Vig
{noformat}
Regression
query_test.test_spilling.TestSpillingDebugActionDimensions.test_spilling[exec_option:
{'debug_action': '-1:OPEN:[email protected]',
'default_spillable_buffer_size': '256k'} | table_format: parquet/none] (from
pytest) Failing for the past 1 build (Since #276 ) Took 27 sec. add description
Error Message query_test/test_spilling.py:49: in test_spilling
self.run_test_case('QueryTest/spilling', vector)
common/impala_test_suite.py:397: in run_test_case result =
self.__execute_query(target_impalad_client, query, user=user)
common/impala_test_suite.py:612: in __execute_query return
impalad_client.execute(query, user=user) common/impala_connection.py:160: in
execute return self.__beeswax_client.execute(sql_stmt, user=user)
beeswax/impala_beeswax.py:173: in execute handle =
self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:339: in __execute_query handle =
self.execute_query_async(query_string, user=user)
beeswax/impala_beeswax.py:335: in execute_query_async return
self.__do_rpc(lambda: self.imp_service.query(query,))
beeswax/impala_beeswax.py:460: in __do_rpc raise
ImpalaBeeswaxException(self.__build_error_message(b), b) E
ImpalaBeeswaxException: ImpalaBeeswaxException: E INNER EXCEPTION: <class
'beeswaxd.ttypes.BeeswaxException'> E MESSAGE: Rejected query from pool
default-pool: minimum memory reservation is greater than memory available to
the query for buffer reservations. Increase the buffer_pool_limit to 24.31 MB.
See the query profile for more information about the per-node memory
requirements. Stacktrace query_test/test_spilling.py:49: in test_spilling
self.run_test_case('QueryTest/spilling', vector)
common/impala_test_suite.py:397: in run_test_case result =
self.__execute_query(target_impalad_client, query, user=user)
common/impala_test_suite.py:612: in __execute_query return
impalad_client.execute(query, user=user) common/impala_connection.py:160: in
execute return self.__beeswax_client.execute(sql_stmt, user=user)
beeswax/impala_beeswax.py:173: in execute handle =
self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:339: in __execute_query handle =
self.execute_query_async(query_string, user=user)
beeswax/impala_beeswax.py:335: in execute_query_async return
self.__do_rpc(lambda: self.imp_service.query(query,))
beeswax/impala_beeswax.py:460: in __do_rpc raise
ImpalaBeeswaxException(self.__build_error_message(b), b) E
ImpalaBeeswaxException: ImpalaBeeswaxException: E INNER EXCEPTION: <class
'beeswaxd.ttypes.BeeswaxException'> E MESSAGE: Rejected query from pool
default-pool: minimum memory reservation is greater than memory available to
the query for buffer reservations. Increase the buffer_pool_limit to 24.31 MB.
See the query profile for more information about the per-node memory
requirements. Standard Error -- executing against localhost:21000 use
tpch_parquet; SET debug_action=-1:OPEN:[email protected];
SET default_spillable_buffer_size=256k; -- executing against localhost:21000
set buffer_pool_limit=15m; -- executing against localhost:21000 select
count(l1.l_tax) from lineitem l1, lineitem l2, lineitem l3 where l1.l_tax <
0.01 and l2.l_tax < 0.04 and l1.l_orderkey = l2.l_orderkey and l1.l_orderkey =
l3.l_orderkey and l1.l_comment = l3.l_comment and l1.l_shipdate =
l3.l_shipdate; -- executing against localhost:21000 SET BUFFER_POOL_LIMIT="";
-- executing against localhost:21000 set buffer_pool_limit=2m; -- executing
against localhost:21000 select max(t1.total_count), max(t1.l_shipinstruct),
max(t1.l_comment) from (select l_shipinstruct, l_comment, count(*) over ()
total_count from lineitem) t1; -- executing against localhost:21000 SET
BUFFER_POOL_LIMIT=""; -- executing against localhost:21000 set
buffer_pool_limit=20m; -- executing against localhost:21000 select a.int_col,
count(*) from functional.alltypessmall a, functional.alltypessmall b,
functional.alltypessmall c where a.id = b.id and b.id = c.id group by
a.int_col; -- executing against localhost:21000 SET BUFFER_POOL_LIMIT="";
MainThread: Query Name: TPCH-Q22 -- executing against localhost:21000 set
buffer_pool_limit=23m; -- executing against localhost:21000 select s_name,
count(*) as numwait from supplier, lineitem l1 join [BROADCAST] 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 = 'SAUDI ARABIA'
group by s_name order by numwait desc, s_name limit 100; -- executing against
localhost:21000 SET BUFFER_POOL_LIMIT="";
{noformat}
I suspect this is a regression in the core-local tests caused by
https://issues.apache.org/jira/browse/IMPALA-5519
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
