[ 
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]

Reply via email to