[IMPALA-9441] TestHS2.test_get_schemas is flaky in local catalog mode

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: Impala 4.5.0
• Component/s: Catalog
• Epic Color: ghx-label-11
• Assignee: Quanlong Huang
• Reporter: Sahil Takiar
• Created: 02/Mar/20 04:09
• Updated: 12/Jul/24 22:57
• Resolved: 01/Jul/24 09:22

Description

Saw this once on a ubuntu-16.04-dockerised-tests job:

Error Message

hs2/hs2_test_suite.py:63: in add_session     lambda: fn(self)) hs2/hs2_test_suite.py:44: in add_session_helper     fn() hs2/hs2_test_suite.py:63: in <lambda>     lambda: fn(self)) hs2/test_hs2.py:423: in test_get_schemas     TestHS2.check_response(get_schemas_resp) hs2/hs2_test_suite.py:131: in check_response     assert response.status.statusCode == expected_status_code E   assert 3 == 0 E    +  where 3 = 3 E    +    where 3 = TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_impala_2201_e794b8f' not found\n", sqlState='HY000', infoMessages=None, statusCode=3).statusCode E    +      where TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_impala_2201_e794b8f' not found\n", sqlState='HY000', infoMessages=None, statusCode=3) = TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_impala_2201_e794b8f' not found\n", sqlState='HY000', infoMessages=None, statusCode=3) E    +        where TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_impala_2201_e794b8f' not found\n", sqlState='HY000', infoMessages=None, statusCode=3) = TGetSchemasResp(status=TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_i...nHandle(hasResultSet=False, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret='', guid=''))).status

Stacktrace

hs2/hs2_test_suite.py:63: in add_session
    lambda: fn(self))
hs2/hs2_test_suite.py:44: in add_session_helper
    fn()
hs2/hs2_test_suite.py:63: in <lambda>
    lambda: fn(self))
hs2/test_hs2.py:423: in test_get_schemas
    TestHS2.check_response(get_schemas_resp)
hs2/hs2_test_suite.py:131: in check_response
    assert response.status.statusCode == expected_status_code
E   assert 3 == 0
E    +  where 3 = 3
E    +    where 3 = TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_impala_2201_e794b8f' not found\n", sqlState='HY000', infoMessages=None, statusCode=3).statusCode
E    +      where TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_impala_2201_e794b8f' not found\n", sqlState='HY000', infoMessages=None, statusCode=3) = TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_impala_2201_e794b8f' not found\n", sqlState='HY000', infoMessages=None, statusCode=3)
E    +        where TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_impala_2201_e794b8f' not found\n", sqlState='HY000', infoMessages=None, statusCode=3) = TGetSchemasResp(status=TStatus(errorCode=None, errorMessage="DatabaseNotFoundException: Database 'test_compute_stats_i...nHandle(hasResultSet=False, modifiedRowCount=None, operationType=3, operationId=THandleIdentifier(secret='', guid=''))).status 

Issue Links

• is related to: IMPALA-13170 InconsistentMetadataFetchException due to database dropped when showing databases