[ https://issues.apache.org/jira/browse/IMPALA-10140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Quanlong Huang updated IMPALA-10140: ------------------------------------ Description: Customer faced following error message randomly when running following query on impalad version 3.2.0-cdh6.3.2 RELEASE. 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. was: 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. > 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 > Priority: Critical > > Customer faced following error message randomly when running following query > on impalad version 3.2.0-cdh6.3.2 RELEASE. > 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: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org