[jira] [Created] (IMPALA-12083) TestTpcdsQueryWithProcessingCost.test_tpcds_q67a intermmitently failed by Memory limit exceeded

["Quanlong Huang (Jira)" <ji...@apache.org>]

Quanlong Huang created IMPALA-12083:
---------------------------------------

             Summary: TestTpcdsQueryWithProcessingCost.test_tpcds_q67a intermmitently failed by Memory limit exceeded
                 Key: IMPALA-12083
                 URL: https://issues.apache.org/jira/browse/IMPALA-12083
             Project: IMPALA
          Issue Type: Bug
            Reporter: Quanlong Huang
            Assignee: Riza Suminto


Saw TestTpcdsQueryWithProcessingCost.test_tpcds_q67a failed in 3 jobs:

[https://jenkins.impala.io/job/ubuntu-16.04-dockerised-tests/7272/]
[https://jenkins.impala.io/job/ubuntu-16.04-dockerised-tests/7285]
[https://jenkins.impala.io/job/ubuntu-16.04-dockerised-tests/7295]

The failure is "Memory limit exceeded":
{code}query_test/test_tpcds_queries.py:240: in test_tpcds_q67a
    self.run_test_case(self.get_workload() + '-q67a', vector)
common/impala_test_suite.py:718: in run_test_case
    result = exec_fn(query, user=test_section.get('USER', '').strip() or None)
common/impala_test_suite.py:656: in __exec_in_impala
    result = self.__execute_query(target_impalad_client, query, user=user)
common/impala_test_suite.py:992: in __execute_query
    return impalad_client.execute(query, user=user)
common/impala_connection.py:214: in execute
    return self.__beeswax_client.execute(sql_stmt, user=user)
beeswax/impala_beeswax.py:191: in execute
    handle = self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:369: in __execute_query
    self.wait_for_finished(handle)
beeswax/impala_beeswax.py:390: in wait_for_finished
    raise ImpalaBeeswaxException("Query aborted:" + error_log, None)
E   ImpalaBeeswaxException: ImpalaBeeswaxException:
E    Query aborted:Failed to get minimum memory reservation of 2.14 GB on daemon 192.168.124.4:27000 for query a54626f3c4e64feb:532c512800000000 due to following error: Memory limit exceeded: Could not allocate memory while trying to increase reservation.
E   Query(a54626f3c4e64feb:532c512800000000) could not allocate 2.14 GB without exceeding limit.
E   Error occurred on backend 192.168.124.4:27000
E   Memory left in process limit: 2.29 GB
E   Memory left in query limit: 4.00 GB
E   Query(a54626f3c4e64feb:532c512800000000): Limit=4.00 GB Reservation=0 ReservationLimit=3.20 GB OtherMemory=0 Total=0 Peak=0
E   Memory is likely oversubscribed. Reducing query concurrency or configuring admission control may help avoid this error.
{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org