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 "Sahil Takiar (Jira)" <ji...@apache.org> on 2020/06/01 16:19:00 UTC

[jira] [Commented] (IMPALA-9757) Test failures with HiveServer2Error: Invalid session id

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

Sahil Takiar commented on IMPALA-9757:
--------------------------------------

{quote} I ran into some issues like this when I tried to set the idle session timeout for our tests a while back - a lot of the tests do just leave the connections sitting there for a very long time, then suddenly decide to use them. The disconnected session timeout isn't an issue for the TCP clients, since those just leave the connection open indefinitely.
{quote}
Good to know we have seen this issue before. Makes me more confident that my analysis above makes sense :).
{quote} It does look like it was sitting there for an hour, based on the timestamps
{quote}
Whoops, you are right. I didn't notice the 2 --> 3 change.
{quote} Maybe we do just need to increase that timeout further?
{quote}
Agreed, will do.

> Test failures with HiveServer2Error: Invalid session id
> -------------------------------------------------------
>
>                 Key: IMPALA-9757
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9757
>             Project: IMPALA
>          Issue Type: Test
>            Reporter: Sahil Takiar
>            Assignee: Sahil Takiar
>            Priority: Critical
>              Labels: broken-build, flaky
>
> Only seen once so far on an exhaustive build. It's not clear if the "HiveServer2Error: Invalid session id" error is specific to this test or not.
> {code:java}
> query_test.test_queries.TestQueries.test_inline_view[protocol: hs2-http | exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: parquet/none] (from pytest)
> Error Message
> query_test/test_queries.py:104: in test_inline_view     self.run_test_case('QueryTest/inline-view', vector) common/impala_test_suite.py:567: in run_test_case     table_format_info, use_db, pytest.config.option.scale_factor) common/impala_test_suite.py:782: in change_database     impala_client.execute(query) common/impala_connection.py:331: in execute     handle = self.execute_async(sql_stmt, user) common/impala_connection.py:354: in execute_async     self.__cursor.execute_async(sql_stmt, configuration=self.__query_options) /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:375: in execute_async     self._execute_async(op) /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:394: in _execute_async     operation_fn() /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:372: in op     run_async=True) /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:1096: in execute     return self._operation('ExecuteStatement', req) /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:1026: in _operation     resp = self._rpc(kind, request) /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:994: in _rpc     err_if_rpc_not_ok(response) /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:748: in err_if_rpc_not_ok     raise HiveServer2Error(resp.status.errorMessage) E   HiveServer2Error: Invalid session id: 3345279d9b2e75ab:3aef93f7a80d7d8a
> Stacktrace
> query_test/test_queries.py:104: in test_inline_view
>     self.run_test_case('QueryTest/inline-view', vector)
> common/impala_test_suite.py:567: in run_test_case
>     table_format_info, use_db, pytest.config.option.scale_factor)
> common/impala_test_suite.py:782: in change_database
>     impala_client.execute(query)
> common/impala_connection.py:331: in execute
>     handle = self.execute_async(sql_stmt, user)
> common/impala_connection.py:354: in execute_async
>     self.__cursor.execute_async(sql_stmt, configuration=self.__query_options)
> /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:375: in execute_async
>     self._execute_async(op)
> /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:394: in _execute_async
>     operation_fn()
> /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:372: in op
>     run_async=True)
> /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:1096: in execute
>     return self._operation('ExecuteStatement', req)
> /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:1026: in _operation
>     resp = self._rpc(kind, request)
> /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:994: in _rpc
>     err_if_rpc_not_ok(response)
> /data/jenkins/workspace/impala-asf-master-exhaustive/repos/Impala/infra/python/env/lib/python2.7/site-packages/impala/hiveserver2.py:748: in err_if_rpc_not_ok
>     raise HiveServer2Error(resp.status.errorMessage)
> E   HiveServer2Error: Invalid session id: 3345279d9b2e75ab:3aef93f7a80d7d8a {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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