[jira] [Commented] (IMPALA-7852) test_hash_join_timer flakiness on s3 testing build

["Michael Ho (JIRA)" <ji...@apache.org>]

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

Michael Ho commented on IMPALA-7852:
------------------------------------

This may be caused by IMPALA-4063. In particular, the coordinator fragment instance didn't complete until the query handle is explicitly closed and the query is unregistered because the test didn't pull any of the results. In which case, other completed fragment instances running on the coordinator may not have their latest profiles recorded in the backend state until the query state thread wakes up to send them every {{--report_status_retry_interval_ms}}. By default, that period is 5 seconds. Before IMPALA-4063, the completed fragment instance will independently send the fragment instance's profile upon its own completion. It's a conscious decision in IMPALA-4063 to batch all fragments' profiles together.

> test_hash_join_timer flakiness on s3 testing build
> --------------------------------------------------
>
>                 Key: IMPALA-7852
>                 URL: https://issues.apache.org/jira/browse/IMPALA-7852
>             Project: IMPALA
>          Issue Type: Bug
>    Affects Versions: Impala 3.2.0
>            Reporter: Bikramjeet Vig
>            Assignee: Michael Ho
>            Priority: Critical
>              Labels: broken-build, flaky-test
>
> test_hash_join_timer failed whereas it passed a previous s3 build on the same githash,i.e., no new commits added between them
> Test cases failing with 
> {noformat}
> query_test/test_hash_join_timer.py:143: in test_hash_join_timer
>     strip1 = re.split("non-child: ", line)[1]
> E   IndexError: list index out of range
> {noformat}
> Failing Queries:
> {noformat}
> select /*+straight_join*/ count(*) from (select distinct * from functional.alltypes where int_col >= sleep(5)) a join /* +SHUFFLE */ functional.alltypes b on (a.id=b.id);
> select /*+straight_join*/ count(*) from functional.alltypes a join /* +SHUFFLE */  (select distinct * from functional.alltypes where int_col >= sleep(5)) b on (a.id=b.id);
> select /*+straight_join*/ count(*) from functional.alltypes a CROSS join  (select distinct * from functional.alltypes where int_col >= sleep(5)) b where a.id>b.id and a.id=99;
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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