[IMPALA-9757] Test failures with HiveServer2Error: Invalid session id

• Type: Test
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: Impala 4.0.0
• Labels: broken-build flaky
• Epic Color: ghx-label-2
• Assignee: Sahil Takiar
• Reporter: Sahil Takiar
• Created: 18/May/20 20:58
• Updated: 08/Jun/20 16:28
• Resolved: 08/Jun/20 16:28

Description

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.

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