[
https://issues.apache.org/jira/browse/IMPALA-10357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fang-Yu Rao updated IMPALA-10357:
---------------------------------
Description:
We found in a recent build that a test case in
[test_basic_joins()|https://github.com/apache/impala/blob/master/tests/query_test/test_join_queries.py#L71]
does not fail with the expected error. This test reads the test case at
[joins.test|https://github.com/apache/impala/blob/master/testdata/workloads/functional-query/queries/QueryTest/joins.test#L846-L850]
and verifies if the returned result is "{{Debug Action: FAIL}}".
{noformat}
Error Message
query_test/test_join_queries.py:71: in test_basic_joins
self.run_test_case('QueryTest/joins', new_vector)
common/impala_test_suite.py:668: in run_test_case
self.__verify_exceptions(test_section['CATCH'], str(e), use_db)
common/impala_test_suite.py:485: in __verify_exceptions (expected_str,
actual_str) E AssertionError: Unexpected exception string. Expected: Debug
Action: FAIL E Not found in actual: ImpalaBeeswaxException: Query
aborted:ExecQueryFInstances rpc query_id=9f4e869839247e75:d01b009300000000
failed: Exec() rpc failed: Aborted: ExecQueryFInstances RPC to 127.0.0.1:27002
is cancelled in state SENT
{noformat}
{noformat}
Stacktrace
query_test/test_join_queries.py:71: in test_basic_joins
self.run_test_case('QueryTest/joins', new_vector)
common/impala_test_suite.py:668: in run_test_case
self.__verify_exceptions(test_section['CATCH'], str(e), use_db)
common/impala_test_suite.py:485: in __verify_exceptions
(expected_str, actual_str)
E AssertionError: Unexpected exception string. Expected: Debug Action: FAIL
E Not found in actual: ImpalaBeeswaxException: Query
aborted:ExecQueryFInstances rpc query_id=9f4e869839247e75:d01b009300000000
failed: Exec() rpc failed: Aborted: ExecQueryFInstances RPC to 127.0.0.1:27002
is cancelled in state SENT
{noformat}
{noformat}
Standard Error
set debug_action="2:PREPARE:FAIL|COORD_BEFORE_EXEC_RPC:JITTER@100@0.3";
-- 2020-11-23 23:27:30,175 INFO MainThread: Started query
1a49038843b6b4da:30f6228100000000
-- executing against localhost:21000
select 1 from alltypestiny a join alltypestiny b on a.id != b.id;
-- 2020-11-23 23:27:30,188 INFO MainThread: Started query
9f4e869839247e75:d01b009300000000
-- executing against localhost:21000
{noformat}
According to the output to standard error, two related queries are of query
id's "{{1a49038843b6b4da:30f6228100000000}}" and
"{{9f4e869839247e75:d01b009300000000}}".
Using these two query id's, we excerpted the related log entries from two log
files of impalad's.
Since this test was recently revised in IMPALA-9309, maybe [~tarmstrong] could
offer some insight into it. Assigned it to Tim for now but feel free to
re-assign it as you see appropriate. Also let me know if some other logs are
needed for investigation. Thanks!
was:
We found in a recent build that a test case in
[test_basic_joins()|https://github.infra.cloudera.com/CDH/Impala/blob/cdpd-master-staging/tests/query_test/test_join_queries.py#L71]
does not fail with the expected error.
{noformat}
Error Message
query_test/test_join_queries.py:71: in test_basic_joins
self.run_test_case('QueryTest/joins', new_vector)
common/impala_test_suite.py:668: in run_test_case
self.__verify_exceptions(test_section['CATCH'], str(e), use_db)
common/impala_test_suite.py:485: in __verify_exceptions (expected_str,
actual_str) E AssertionError: Unexpected exception string. Expected: Debug
Action: FAIL E Not found in actual: ImpalaBeeswaxException: Query
aborted:ExecQueryFInstances rpc query_id=9f4e869839247e75:d01b009300000000
failed: Exec() rpc failed: Aborted: ExecQueryFInstances RPC to 127.0.0.1:27002
is cancelled in state SENT
{noformat}
{noformat}
Stacktrace
query_test/test_join_queries.py:71: in test_basic_joins
self.run_test_case('QueryTest/joins', new_vector)
common/impala_test_suite.py:668: in run_test_case
self.__verify_exceptions(test_section['CATCH'], str(e), use_db)
common/impala_test_suite.py:485: in __verify_exceptions
(expected_str, actual_str)
E AssertionError: Unexpected exception string. Expected: Debug Action: FAIL
E Not found in actual: ImpalaBeeswaxException: Query
aborted:ExecQueryFInstances rpc query_id=9f4e869839247e75:d01b009300000000
failed: Exec() rpc failed: Aborted: ExecQueryFInstances RPC to 127.0.0.1:27002
is cancelled in state SENT
{noformat}
{noformat}
Standard Error
set debug_action="2:PREPARE:FAIL|COORD_BEFORE_EXEC_RPC:JITTER@100@0.3";
-- 2020-11-23 23:27:30,175 INFO MainThread: Started query
1a49038843b6b4da:30f6228100000000
-- executing against localhost:21000
select 1 from alltypestiny a join alltypestiny b on a.id != b.id;
-- 2020-11-23 23:27:30,188 INFO MainThread: Started query
9f4e869839247e75:d01b009300000000
-- executing against localhost:21000
{noformat}
According to the output to standard error, two related queries are of query
id's {{1a49038843b6b4da:30f6228100000000}} and
{{9f4e869839247e75:d01b009300000000}}.
Using these two query id's, we excerpted the related log entries from two log
files of impalad's.
Since this test was recently revised in IMPALA-9309, maybe [~tarmstrong] could
offer some insight into it. Assigned it to Tim for now but feel free to
re-assign it as you see appropriate. Also let me know if some other logs are
needed for investigation. Thanks!
> A test case in test_basic_joins() seems flaky
> ---------------------------------------------
>
> Key: IMPALA-10357
> URL: https://issues.apache.org/jira/browse/IMPALA-10357
> Project: IMPALA
> Issue Type: Bug
> Affects Versions: Impala 4.0
> Reporter: Fang-Yu Rao
> Assignee: Tim Armstrong
> Priority: Major
> Labels: broken-build, flaky-test
> Attachments: excerpted_impalad.INFO, excerpted_impalad_node1.INFO
>
>
> We found in a recent build that a test case in
> [test_basic_joins()|https://github.com/apache/impala/blob/master/tests/query_test/test_join_queries.py#L71]
> does not fail with the expected error. This test reads the test case at
> [joins.test|https://github.com/apache/impala/blob/master/testdata/workloads/functional-query/queries/QueryTest/joins.test#L846-L850]
> and verifies if the returned result is "{{Debug Action: FAIL}}".
> {noformat}
> Error Message
> query_test/test_join_queries.py:71: in test_basic_joins
> self.run_test_case('QueryTest/joins', new_vector)
> common/impala_test_suite.py:668: in run_test_case
> self.__verify_exceptions(test_section['CATCH'], str(e), use_db)
> common/impala_test_suite.py:485: in __verify_exceptions (expected_str,
> actual_str) E AssertionError: Unexpected exception string. Expected: Debug
> Action: FAIL E Not found in actual: ImpalaBeeswaxException: Query
> aborted:ExecQueryFInstances rpc query_id=9f4e869839247e75:d01b009300000000
> failed: Exec() rpc failed: Aborted: ExecQueryFInstances RPC to
> 127.0.0.1:27002 is cancelled in state SENT
> {noformat}
> {noformat}
> Stacktrace
> query_test/test_join_queries.py:71: in test_basic_joins
> self.run_test_case('QueryTest/joins', new_vector)
> common/impala_test_suite.py:668: in run_test_case
> self.__verify_exceptions(test_section['CATCH'], str(e), use_db)
> common/impala_test_suite.py:485: in __verify_exceptions
> (expected_str, actual_str)
> E AssertionError: Unexpected exception string. Expected: Debug Action: FAIL
> E Not found in actual: ImpalaBeeswaxException: Query
> aborted:ExecQueryFInstances rpc query_id=9f4e869839247e75:d01b009300000000
> failed: Exec() rpc failed: Aborted: ExecQueryFInstances RPC to
> 127.0.0.1:27002 is cancelled in state SENT
> {noformat}
> {noformat}
> Standard Error
> set debug_action="2:PREPARE:FAIL|COORD_BEFORE_EXEC_RPC:JITTER@100@0.3";
> -- 2020-11-23 23:27:30,175 INFO MainThread: Started query
> 1a49038843b6b4da:30f6228100000000
> -- executing against localhost:21000
> select 1 from alltypestiny a join alltypestiny b on a.id != b.id;
> -- 2020-11-23 23:27:30,188 INFO MainThread: Started query
> 9f4e869839247e75:d01b009300000000
> -- executing against localhost:21000
> {noformat}
> According to the output to standard error, two related queries are of query
> id's "{{1a49038843b6b4da:30f6228100000000}}" and
> "{{9f4e869839247e75:d01b009300000000}}".
> Using these two query id's, we excerpted the related log entries from two log
> files of impalad's.
> Since this test was recently revised in IMPALA-9309, maybe [~tarmstrong]
> could offer some insight into it. Assigned it to Tim for now but feel free to
> re-assign it as you see appropriate. Also let me know if some other logs are
> needed for investigation. Thanks!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
