[
https://issues.apache.org/jira/browse/IMPALA-9049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944881#comment-17944881
]
Quanlong Huang commented on IMPALA-9049:
----------------------------------------
This raise up again:
[https://jenkins.impala.io/job/ubuntu-20.04-dockerised-tests/3237/testReport/junit/metadata.test_ddl/TestDdlStatements/test_sync_ddl_drop_unique_database0_/]
{noformat}
metadata.test_ddl.TestDdlStatements.test_sync_ddl_drop[unique_database0] (from
pytest) {noformat}
Error Message
{noformat}
test setup failure{noformat}
Stacktrace
{noformat}
conftest.py:407: in cleanup
cleanup_database(client, db_name, True)
conftest.py:393: in cleanup_database
"" if must_exist else "IF EXISTS", db_name))
common/impala_connection.py:735: in execute
cursor.execute(sql_stmt, configuration=self.__query_options)
../infra/python/env-gcc10.4.0/lib/python2.7/site-packages/impala/hiveserver2.py:392:
in execute
configuration=configuration)
../infra/python/env-gcc10.4.0/lib/python2.7/site-packages/impala/hiveserver2.py:443:
in execute_async
self._execute_async(op)
../infra/python/env-gcc10.4.0/lib/python2.7/site-packages/impala/hiveserver2.py:462:
in _execute_async
operation_fn()
../infra/python/env-gcc10.4.0/lib/python2.7/site-packages/impala/hiveserver2.py:440:
in op
run_async=True)
../infra/python/env-gcc10.4.0/lib/python2.7/site-packages/impala/hiveserver2.py:1324:
in execute
return self._operation('ExecuteStatement', req, False)
../infra/python/env-gcc10.4.0/lib/python2.7/site-packages/impala/hiveserver2.py:1244:
in _operation
resp = self._rpc(kind, request, safe_to_retry)
../infra/python/env-gcc10.4.0/lib/python2.7/site-packages/impala/hiveserver2.py:1181:
in _rpc
err_if_rpc_not_ok(response)
../infra/python/env-gcc10.4.0/lib/python2.7/site-packages/impala/hiveserver2.py:867:
in err_if_rpc_not_ok
raise HiveServer2Error(resp.status.errorMessage)
E HiveServer2Error: Query c2401500546f2498:b35acf1d00000000 failed:
E AnalysisException: Database does not exist: test_sync_ddl_drop_9363e3c2
{noformat}
Standard Error
{noformat}
-- 2025-04-15 16:29:31,168 INFO MainThread: beeswax:
set
client_identifier=metadata/test_ddl.py::TestDdlStatements::()::test_sync_ddl_drop[unique_database0];
-- 2025-04-15 16:29:31,168 INFO MainThread: hs2:
set
client_identifier=metadata/test_ddl.py::TestDdlStatements::()::test_sync_ddl_drop[unique_database0];
-- 2025-04-15 16:29:31,168 INFO MainThread: hs2-http:
set
client_identifier=metadata/test_ddl.py::TestDdlStatements::()::test_sync_ddl_drop[unique_database0];
-- 2025-04-15 16:29:31,168 INFO MainThread: hs2:
set
client_identifier=metadata/test_ddl.py::TestDdlStatements::()::test_sync_ddl_drop[unique_database0];
-- 2025-04-15 16:29:31,168 INFO MainThread: hs2: connected to
localhost:21050 with impyla hs2
-- 2025-04-15 16:29:31,169 INFO MainThread: hs2:
set
client_identifier=metadata/test_ddl.py::TestDdlStatements::()::test_sync_ddl_drop[unique_database0];
-- 2025-04-15 16:29:31,169 INFO MainThread: hs2: set_configuration:
set sync_ddl=True;
-- 2025-04-15 16:29:31,169 INFO MainThread: hs2: executing against Impala
at localhost:21050. session: 7847e043c5602a6c:2e96d76fa4d12d8d main_cursor:
True user: None
DROP DATABASE IF EXISTS `test_sync_ddl_drop_9363e3c2` CASCADE;
-- 2025-04-15 16:29:37,218 INFO MainThread:
0846a788f2cb29d8:c034141300000000: query started
-- 2025-04-15 16:29:37,219 INFO MainThread:
0846a788f2cb29d8:c034141300000000: getting log for operation
-- 2025-04-15 16:29:37,219 INFO MainThread:
0846a788f2cb29d8:c034141300000000: getting runtime profile operation
-- 2025-04-15 16:29:37,220 INFO MainThread:
0846a788f2cb29d8:c034141300000000: closing query for operation
-- 2025-04-15 16:29:37,227 INFO MainThread: hs2: executing against Impala
at localhost:21050. session: 7847e043c5602a6c:2e96d76fa4d12d8d main_cursor:
True user: None
CREATE DATABASE `test_sync_ddl_drop_9363e3c2`;
-- 2025-04-15 16:29:43,210 INFO MainThread:
e347fee46b54f4cd:9b5a875d00000000: query started
-- 2025-04-15 16:29:43,213 INFO MainThread:
e347fee46b54f4cd:9b5a875d00000000: getting log for operation
-- 2025-04-15 16:29:43,213 INFO MainThread:
e347fee46b54f4cd:9b5a875d00000000: getting runtime profile operation
-- 2025-04-15 16:29:43,214 INFO MainThread:
e347fee46b54f4cd:9b5a875d00000000: closing query for operation
-- 2025-04-15 16:29:43,214 INFO MainThread: Created database
"test_sync_ddl_drop_9363e3c2" for test ID
"metadata/test_ddl.py::TestDdlStatements::()::test_sync_ddl_drop[unique_database0]"
-- 2025-04-15 16:29:43,214 INFO MainThread: hs2: closing 1 sync and 0 async
hs2 connections to: localhost:21050
-- 2025-04-15 16:29:43,215 INFO MainThread: beeswax:
set
client_identifier=metadata/test_ddl.py::TestDdlStatements::()::test_sync_ddl_drop[unique_database0];
-- 2025-04-15 16:29:43,215 INFO MainThread: beeswax: set_configuration:
set sync_ddl=1;
-- 2025-04-15 16:29:43,215 INFO MainThread: beeswax: executing against
localhost:21000
drop database test_sync_ddl_drop_9363e3c2;
-- 2025-04-15 16:29:43,223 INFO MainThread: Started query
7b4d1efb8c5b85e3:801c5a1400000000
-- 2025-04-15 16:29:49,198 INFO MainThread: beeswax: executing against
localhost:21000
show databases;{noformat}
> TestDdlStatements.test_sync_ddl_drop is flaky
> ---------------------------------------------
>
> Key: IMPALA-9049
> URL: https://issues.apache.org/jira/browse/IMPALA-9049
> Project: IMPALA
> Issue Type: Bug
> Components: Catalog
> Affects Versions: Impala 3.4.0
> Reporter: Yongzhi Chen
> Assignee: Quanlong Huang
> Priority: Major
> Labels: broken-build, flaky
>
> It failed precommit tests for unrelated change:
> https://jenkins.impala.io/job/ubuntu-16.04-dockerised-tests/1405/testReport/metadata.test_ddl/TestDdlStatements/test_sync_ddl_drop_protocol__beeswax___exec_option____sync_ddl___0___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__text_none_unique_database0_/
> Error Message
> test setup failure
> Stacktrace
> conftest.py:319: in cleanup
> {'sync_ddl': sync_ddl})
> common/impala_test_suite.py:790: in wrapper
> return function(*args, **kwargs)
> common/impala_test_suite.py:798: in execute_query_expect_success
> result = cls.__execute_query(impalad_client, query, query_options, user)
> common/impala_test_suite.py:893: in __execute_query
> return impalad_client.execute(query, user=user)
> common/impala_connection.py:205: in execute
> return self.__beeswax_client.execute(sql_stmt, user=user)
> beeswax/impala_beeswax.py:187: in execute
> handle = self.__execute_query(query_string.strip(), user=user)
> beeswax/impala_beeswax.py:362: in __execute_query
> handle = self.execute_query_async(query_string, user=user)
> beeswax/impala_beeswax.py:356: in execute_query_async
> handle = self.__do_rpc(lambda: self.imp_service.query(query,))
> beeswax/impala_beeswax.py:519: in __do_rpc
> raise ImpalaBeeswaxException(self.__build_error_message(b), b)
> E ImpalaBeeswaxException: ImpalaBeeswaxException:
> E INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
> E MESSAGE: AnalysisException: Database does not exist:
> test_sync_ddl_drop_eb3f13e1
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]