You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2023/04/23 08:40:00 UTC

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

    [ https://issues.apache.org/jira/browse/IMPALA-12083?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17715407#comment-17715407 ] 

Quanlong Huang commented on IMPALA-12083:
-----------------------------------------

Hi [~rizaon], assiging this to you since you added the test. Feel free to reassign it.

> 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
>            Priority: Critical
>
> 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