[IMPALA-3641] DROP / CREATE sequence on same table failed with "table already exists"

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.7.0
• Fix Version/s: Impala 2.9.0
• Component/s: Catalog, Frontend
• Labels: broken-build flaky
• Target Version: Impala 2.8.0
• Assignee: Alexander Behm
• Reporter: Lars Volker
• Created: 29/May/16 16:38
• Updated: 27/Jan/17 18:03
• Resolved: 05/Jan/17 19:42

Description

Michael, I assigned you hoping you'll know what's going on or have seen that before.

This GVM failed, due to what looks to me like a race condition in test_show_create_table.py: http://sandbox.jenkins.cloudera.com/job/impala-external-gerrit-verify-merge/2525/

[gw2] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-umbrella-build-and-test/repos/Impala/bin/../infra/python/env/bin/python
metadata/test_show_create_table.py:55: in test_show_create_table
    unique_database)
metadata/test_show_create_table.py:109: in __run_show_create_table_test_case
    self.__exec(create_table_result)
metadata/test_show_create_table.py:120: in __exec
    return self.execute_query_expect_success(self.client, sql_str)
common/impala_test_suite.py:416: in wrapper
    return function(*args, **kwargs)
common/impala_test_suite.py:423: in execute_query_expect_success
    result = cls.__execute_query(impalad_client, query, query_options)
common/impala_test_suite.py:509: in __execute_query
    return impalad_client.execute(query, user=user)
common/impala_connection.py:160: in execute
    return self.__beeswax_client.execute(sql_stmt, user=user)
beeswax/impala_beeswax.py:173: in execute
    handle = self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:337: in __execute_query
    handle = self.execute_query_async(query_string, user=user)
beeswax/impala_beeswax.py:333: in execute_query_async
    return self.__do_rpc(lambda: self.imp_service.query(query,))
beeswax/impala_beeswax.py:458: in __do_rpc
    raise ImpalaBeeswaxException(self.__build_error_message(b), b)
E   ImpalaBeeswaxException: ImpalaBeeswaxException:
E    INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
E    MESSAGE: AnalysisException: Table already exists: test_show_create_table_f1598d0b.i_1687_p

Issue Links

• blocks: IMPALA-3229 Allow all contributors (or at least committers?) to run GVM
• relates to: IMPALA-4342 "Cannot drop non-empty database: udf_test_errors" when using local filesystem