Wenzhe Zhou created IMPALA-10140:
------------------------------------
Summary: Throw CatalogException for query "create database if not
exist" with sync_ddl as true
Key: IMPALA-10140
URL: https://issues.apache.org/jira/browse/IMPALA-10140
Project: IMPALA
Issue Type: Bug
Components: Catalog, Frontend
Affects Versions: Impala 3.2.0
Reporter: Wenzhe Zhou
Customer faced following error message randomly when running following query on
impalad version 3.2.0-cdh6.3.2 RELEASE.
([https://jira.cloudera.com/browse/ENGESC-3589)|https://jira.cloudera.com/browse/ENGESC-3589]
set sync_ddl =true ; create database if not exists $dbname;
I0715 11:52:28.496253 51943 client-request-state.cc:187]
a246b430fe450786:81647bd600000000] CatalogException: Couldn't retrieve the
catalog topic version for the SYNC_DDL operation after 5 attempts.The operation
has been su
ccessfully executed but its effects may have not been broadcast to all the
coordinators.
>From the Catalog server log, we can check following error message as well.
I0715 11:01:50.143303 220286 jni-util.cc:256]
org.apache.impala.catalog.CatalogException: Couldn't retrieve the catalog topic
version for the SYNC_DDL operation after 5 attempts.The operation has been
successfully executed but its effects may have not been broadcast to all the
coordinators.
at
org.apache.impala.catalog.CatalogServiceCatalog.waitForSyncDdlVersion(CatalogServiceCatalog.java:2474)
at
org.apache.impala.service.CatalogOpExecutor.execDdlRequest(CatalogOpExecutor.java:374)
at org.apache.impala.service.JniCatalog.execDdl(JniCatalog.java:154)
This looks to be another variation of the conditions described in IMPALA-7961.
But the difference here is that this case is with "CREATE DATABASE ... IF NOT
EXISTS".
The fix in IMPALA-7961 specifically targets the "CREATE TABLE ... IF NOT
EXISTS" use case.
To fix the issue, we should port the change in patch
[https://gerrit.cloudera.org/#/c/12428/] to createDatabase() function.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
