danhuawang opened a new issue, #11065:
URL: https://github.com/apache/gravitino/issues/11065

   ### Version
   
   main branch
   
   ### Describe what's wrong
   
   Failed to drop catalog due to java.sql.SQLSyntaxErrorException: Unknown 
database
   ```
   {
       "code": 1002,
       "type": "RuntimeException",
       "message": "Failed to operate object [catalog_iceberg_mysql_backend] 
operation [DROP] under [metalake_b], reason [Failed to connect: 
jdbc:mysql://my-8-mysql.irc-e2e-env1:3306/gravitinoIRC?useSSL=false]",
       "stack": [
           "java.lang.RuntimeException: 
org.apache.iceberg.jdbc.UncheckedSQLException: Failed to connect: 
jdbc:mysql://my-8-mysql.irc-e2e-env1:3306/gravitinoIRC?useSSL=false",
           "\tat 
org.apache.gravitino.catalog.CatalogManager.lambda$dropCatalog$22(CatalogManager.java:823)",
           "\tat 
org.apache.gravitino.lock.TreeLockUtils.doWithTreeLock(TreeLockUtils.java:49)",
           "\tat 
org.apache.gravitino.catalog.CatalogManager.dropCatalog(CatalogManager.java:772)",
           "\tat 
org.apache.gravitino.catalog.CatalogNormalizeDispatcher.dropCatalog(CatalogNormalizeDispatcher.java:112)",
           "\tat 
org.apache.gravitino.listener.CatalogEventDispatcher.dropCatalog(CatalogEventDispatcher.java:175)",
           "\tat 
org.apache.gravitino.hook.CatalogHookDispatcher.dropCatalog(CatalogHookDispatcher.java:156)",
           "\tat 
org.apache.gravitino.server.web.rest.CatalogOperations.lambda$dropCatalog$7(CatalogOperations.java:338)",
           "\tat 
java.base/java.security.AccessController.doPrivileged(AccessController.java:712)",
           "\tat java.base/javax.security.auth.Subject.doAs(Subject.java:439)",
           "\tat 
org.apache.gravitino.utils.PrincipalUtils.doAs(PrincipalUtils.java:53)",
           "\tat org.apache.gravitino.server.web.Utils.doAs(Utils.java:202)",
           "\tat 
org.apache.gravitino.server.web.rest.CatalogOperations.dropCatalog(CatalogOperations.java:334)",
           "\tat 
org.apache.gravitino.server.web.rest.CatalogOperations_$$_jvstb8c_0._d4dropCatalog(CatalogOperations_$$_jvstb8c_0.java)",
           "\tat 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)",
           "\tat 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)",
           "\tat 
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)",
           "\tat java.base/java.lang.reflect.Method.invoke(Method.java:569)",
           "\tat 
org.glassfish.hk2.utilities.reflection.ReflectionHelper.invoke(ReflectionHelper.java:1268)",
           "\tat 
org.jvnet.hk2.internal.MethodInterceptorHandler$MethodInvocationImpl.proceed(MethodInterceptorHandler.java:164)",
           "\tat 
org.apache.gravitino.server.web.filter.GravitinoInterceptionService$MetadataAuthorizationMethodInterceptor.invoke(GravitinoInterceptionService.java:208)",
           "\tat 
org.jvnet.hk2.internal.MethodInterceptorHandler.invoke(MethodInterceptorHandler.java:97)",
           "\tat 
org.apache.gravitino.server.web.rest.CatalogOperations_$$_jvstb8c_0.dropCatalog(CatalogOperations_$$_jvstb8c_0.java)",
           "\tat 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)",
           "\tat 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)",
           "\tat 
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)",
           "\tat java.base/java.lang.reflect.Method.invoke(Method.java:569)",
           "\tat 
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)",
           "\tat 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:146)",
           "\tat 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:189)",
           "\tat 
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176)",
           "\tat 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:93)",
           "\tat 
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:478)",
           "\tat 
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:400)",
           "\tat 
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)",
           "\tat 
org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:256)",
           "\tat org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)",
           "\tat org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)",
           "\tat org.glassfish.jersey.internal.Errors.process(Errors.java:292)",
           "\tat org.glassfish.jersey.internal.Errors.process(Errors.java:274)",
           "\tat org.glassfish.jersey.internal.Errors.process(Errors.java:244)",
           "\tat 
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)",
           "\tat 
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:235)",
           "\tat 
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)",
           "\tat 
org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)",
           "\tat 
org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)",
           "\tat 
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:358)",
           "\tat 
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:311)",
           "\tat 
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)",
           "\tat 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)",
           "\tat 
org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1656)",
           "\tat 
org.apache.gravitino.server.authentication.AuthenticationFilter.lambda$doFilter$0(AuthenticationFilter.java:96)",
           "\tat 
java.base/java.security.AccessController.doPrivileged(AccessController.java:712)",
           "\tat java.base/javax.security.auth.Subject.doAs(Subject.java:439)",
           "\tat 
org.apache.gravitino.utils.PrincipalUtils.doAs(PrincipalUtils.java:53)",
           "\tat 
org.apache.gravitino.server.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:93)",
           "\tat 
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)",
           "\tat 
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)",
           "\tat 
org.apache.gravitino.server.web.VersioningFilter.doFilter(VersioningFilter.java:123)",
           "\tat 
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)",
           "\tat 
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)",
           "\tat 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:552)",
           "\tat 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)",
           "\tat 
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600)",
           "\tat 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)",
           "\tat 
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)",
           "\tat 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)",
           "\tat 
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)",
           "\tat 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)",
           "\tat 
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)",
           "\tat 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:505)",
           "\tat 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)",
           "\tat 
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)",
           "\tat 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)",
           "\tat 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)",
           "\tat 
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)",
           "\tat 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)",
           "\tat org.eclipse.jetty.server.Server.handle(Server.java:516)",
           "\tat 
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)",
           "\tat 
org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)",
           "\tat 
org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)",
           "\tat 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)",
           "\tat 
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)",
           "\tat 
org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)",
           "\tat 
org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)",
           "\tat 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)",
           "\tat 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)",
           "\tat 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)",
           "\tat 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)",
           "\tat 
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)",
           "\tat 
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)",
           "\tat 
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)",
           "\tat java.base/java.lang.Thread.run(Thread.java:840)",
           "Caused by: org.apache.iceberg.jdbc.UncheckedSQLException: Failed to 
connect: jdbc:mysql://my-8-mysql.irc-e2e-env1:3306/gravitinoIRC?useSSL=false",
           "\tat 
org.apache.iceberg.jdbc.JdbcClientPool.newClient(JdbcClientPool.java:90)",
           "\tat 
org.apache.iceberg.jdbc.JdbcClientPool.newClient(JdbcClientPool.java:35)",
           "\tat 
org.apache.iceberg.ClientPoolImpl.get(ClientPoolImpl.java:143)",
           "\tat org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:70)",
           "\tat org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:65)",
           "\tat 
org.apache.iceberg.jdbc.JdbcCatalog.atomicCreateTable(JdbcCatalog.java:162)",
           "\tat 
org.apache.iceberg.jdbc.JdbcCatalog.initializeCatalogTables(JdbcCatalog.java:208)",
           "\tat 
org.apache.iceberg.jdbc.JdbcCatalog.initialize(JdbcCatalog.java:148)",
           "\tat 
org.apache.iceberg.jdbc.JdbcCatalogWithMetadataLocationSupport.initialize(JdbcCatalogWithMetadataLocationSupport.java:42)",
           "\tat 
org.apache.gravitino.iceberg.common.utils.IcebergCatalogUtil.loadJdbcCatalog(IcebergCatalogUtil.java:118)",
           "\tat 
org.apache.gravitino.iceberg.common.utils.IcebergCatalogUtil.loadCatalogBackend(IcebergCatalogUtil.java:170)",
           "\tat 
org.apache.gravitino.iceberg.common.ops.IcebergCatalogWrapper.getCatalog(IcebergCatalogWrapper.java:111)",
           "\tat 
org.apache.gravitino.catalog.lakehouse.iceberg.IcebergCatalogOperations.initialize(IcebergCatalogOperations.java:132)",
           "\tat 
org.apache.gravitino.connector.BaseCatalog.ops(BaseCatalog.java:184)",
           "\tat 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.asSchemas(CatalogManager.java:259)",
           "\tat 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.lambda$doWithSchemaOps$0(CatalogManager.java:141)",
           "\tat 
org.apache.gravitino.utils.IsolatedClassLoader.withClassLoader(IsolatedClassLoader.java:86)",
           "\tat 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.doWithSchemaOps(CatalogManager.java:139)",
           "\tat 
org.apache.gravitino.catalog.CatalogManager.containsUserCreatedSchemas(CatalogManager.java:875)",
           "\tat 
org.apache.gravitino.catalog.CatalogManager.lambda$dropCatalog$22(CatalogManager.java:789)",
           "\t... 91 more",
           "Caused by: java.sql.SQLSyntaxErrorException: Unknown database 
'gravitinoirc'",
           "\tat 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)",
           "\tat 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)",
           "\tat 
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)",
           "\tat 
com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)",
           "\tat 
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)",
           "\tat 
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)",
           "\tat 
java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)",
           "\tat 
java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190)",
           "\tat 
org.apache.iceberg.jdbc.JdbcClientPool.newClient(JdbcClientPool.java:88)",
           "\t... 110 more"
       ]
   }
   ```
   
   ### Error message and/or stacktrace
   
   
   ```
   2026-05-13 03:19:31.419 WARN [Gravitino-webserver-43] 
[org.apache.gravitino.server.web.rest.ExceptionHandlers$CatalogExceptionHandler.handle(ExceptionHandlers.java:393)]
 - Failed to operate catalog(s) [catalog_iceberg_mysql_backend] operation 
[DROP] under metalake [metalake_b], reason [Failed to connect: 
jdbc:mysql://my-8-mysql.irc-e2e-env1:3306/gravitinoIRC?useSSL=false]
   java.lang.RuntimeException: org.apache.iceberg.jdbc.UncheckedSQLException: 
Failed to connect: 
jdbc:mysql://my-8-mysql.irc-e2e-env1:3306/gravitinoIRC?useSSL=false
        at 
org.apache.gravitino.catalog.CatalogManager.lambda$dropCatalog$22(CatalogManager.java:823)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.lock.TreeLockUtils.doWithTreeLock(TreeLockUtils.java:49) 
~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager.dropCatalog(CatalogManager.java:772)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogNormalizeDispatcher.dropCatalog(CatalogNormalizeDispatcher.java:112)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.listener.CatalogEventDispatcher.dropCatalog(CatalogEventDispatcher.java:175)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.hook.CatalogHookDispatcher.dropCatalog(CatalogHookDispatcher.java:156)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.server.web.rest.CatalogOperations.lambda$dropCatalog$7(CatalogOperations.java:338)
 ~[gravitino-server-1.3.0-SNAPSHOT.jar:?]
        at 
java.base/java.security.AccessController.doPrivileged(AccessController.java:712)
 ~[?:?]
        at java.base/javax.security.auth.Subject.doAs(Subject.java:439) ~[?:?]
        at 
org.apache.gravitino.utils.PrincipalUtils.doAs(PrincipalUtils.java:53) 
~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at org.apache.gravitino.server.web.Utils.doAs(Utils.java:202) 
~[gravitino-server-common-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.server.web.rest.CatalogOperations.dropCatalog(CatalogOperations.java:334)
 ~[gravitino-server-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.server.web.rest.CatalogOperations_$$_jvstb8c_0._d4dropCatalog(CatalogOperations_$$_jvstb8c_0.java)
 ~[gravitino-server-1.3.0-SNAPSHOT.jar:?]
        at 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[?:?]
        at 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
 ~[?:?]
        at 
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:?]
        at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
        at 
org.glassfish.hk2.utilities.reflection.ReflectionHelper.invoke(ReflectionHelper.java:1268)
 ~[hk2-utils-2.6.1.jar:?]
        at 
org.jvnet.hk2.internal.MethodInterceptorHandler$MethodInvocationImpl.proceed(MethodInterceptorHandler.java:164)
 ~[hk2-locator-2.6.1.jar:?]
        at 
org.apache.gravitino.server.web.filter.GravitinoInterceptionService$MetadataAuthorizationMethodInterceptor.invoke(GravitinoInterceptionService.java:208)
 ~[gravitino-server-1.3.0-SNAPSHOT.jar:?]
        at 
org.jvnet.hk2.internal.MethodInterceptorHandler.invoke(MethodInterceptorHandler.java:97)
 ~[hk2-locator-2.6.1.jar:?]
        at 
org.apache.gravitino.server.web.rest.CatalogOperations_$$_jvstb8c_0.dropCatalog(CatalogOperations_$$_jvstb8c_0.java)
 ~[gravitino-server-1.3.0-SNAPSHOT.jar:?]
        at 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[?:?]
        at 
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
 ~[?:?]
        at 
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:?]
        at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[?:?]
        at 
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:146)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:189)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:93)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:478)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:400)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:256) 
~[jersey-server-2.41.jar:?]
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) 
~[jersey-common-2.41.jar:?]
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) 
~[jersey-common-2.41.jar:?]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:292) 
~[jersey-common-2.41.jar:?]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:274) 
~[jersey-common-2.41.jar:?]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:244) 
~[jersey-common-2.41.jar:?]
        at 
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
 ~[jersey-common-2.41.jar:?]
        at 
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:235) 
~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)
 ~[jersey-server-2.41.jar:?]
        at 
org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) 
~[jersey-container-servlet-core-2.41.jar:?]
        at 
org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) 
~[jersey-container-servlet-core-2.41.jar:?]
        at 
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:358)
 ~[jersey-container-servlet-core-2.41.jar:?]
        at 
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:311)
 ~[jersey-container-servlet-core-2.41.jar:?]
        at 
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
 ~[jersey-container-servlet-core-2.41.jar:?]
        at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) 
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1656)
 ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.apache.gravitino.server.authentication.AuthenticationFilter.lambda$doFilter$0(AuthenticationFilter.java:96)
 ~[gravitino-server-common-1.3.0-SNAPSHOT.jar:?]
        at 
java.base/java.security.AccessController.doPrivileged(AccessController.java:712)
 ~[?:?]
        at java.base/javax.security.auth.Subject.doAs(Subject.java:439) ~[?:?]
        at 
org.apache.gravitino.utils.PrincipalUtils.doAs(PrincipalUtils.java:53) 
~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.server.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:93)
 ~[gravitino-server-common-1.3.0-SNAPSHOT.jar:?]
        at 
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) 
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
 ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.apache.gravitino.server.web.VersioningFilter.doFilter(VersioningFilter.java:123)
 ~[gravitino-server-1.3.0-SNAPSHOT.jar:?]
        at 
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) 
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626)
 ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:552) 
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) 
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600) 
~[jetty-security-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) 
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:505) 
~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) 
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
 ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) 
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at org.eclipse.jetty.server.Server.handle(Server.java:516) 
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487) 
~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732) 
[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479) 
[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) 
[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
 [jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) 
[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
        at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) 
[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
 [jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
 [jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
 [jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
 [jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
 [jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
 [jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
 [jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
        at java.base/java.lang.Thread.run(Thread.java:840) [?:?]
   Caused by: org.apache.iceberg.jdbc.UncheckedSQLException: Failed to connect: 
jdbc:mysql://my-8-mysql.irc-e2e-env1:3306/gravitinoIRC?useSSL=false
        at 
org.apache.iceberg.jdbc.JdbcClientPool.newClient(JdbcClientPool.java:90) ~[?:?]
        at 
org.apache.iceberg.jdbc.JdbcClientPool.newClient(JdbcClientPool.java:35) ~[?:?]
        at org.apache.iceberg.ClientPoolImpl.get(ClientPoolImpl.java:143) ~[?:?]
        at org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:70) ~[?:?]
        at org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:65) ~[?:?]
        at 
org.apache.iceberg.jdbc.JdbcCatalog.atomicCreateTable(JdbcCatalog.java:162) 
~[?:?]
        at 
org.apache.iceberg.jdbc.JdbcCatalog.initializeCatalogTables(JdbcCatalog.java:208)
 ~[?:?]
        at org.apache.iceberg.jdbc.JdbcCatalog.initialize(JdbcCatalog.java:148) 
~[?:?]
        at 
org.apache.iceberg.jdbc.JdbcCatalogWithMetadataLocationSupport.initialize(JdbcCatalogWithMetadataLocationSupport.java:42)
 ~[?:?]
        at 
org.apache.gravitino.iceberg.common.utils.IcebergCatalogUtil.loadJdbcCatalog(IcebergCatalogUtil.java:118)
 ~[?:?]
        at 
org.apache.gravitino.iceberg.common.utils.IcebergCatalogUtil.loadCatalogBackend(IcebergCatalogUtil.java:170)
 ~[?:?]
        at 
org.apache.gravitino.iceberg.common.ops.IcebergCatalogWrapper.getCatalog(IcebergCatalogWrapper.java:111)
 ~[?:?]
        at 
org.apache.gravitino.catalog.lakehouse.iceberg.IcebergCatalogOperations.initialize(IcebergCatalogOperations.java:132)
 ~[?:?]
        at org.apache.gravitino.connector.BaseCatalog.ops(BaseCatalog.java:184) 
~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.asSchemas(CatalogManager.java:259)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.lambda$doWithSchemaOps$0(CatalogManager.java:141)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.utils.IsolatedClassLoader.withClassLoader(IsolatedClassLoader.java:86)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.doWithSchemaOps(CatalogManager.java:139)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager.containsUserCreatedSchemas(CatalogManager.java:875)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager.lambda$dropCatalog$22(CatalogManager.java:789)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        ... 91 more
   Caused by: java.sql.SQLSyntaxErrorException: Unknown database 'gravitinoirc'
        at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
        at 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
        at 
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
        at 
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
        at 
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
        at 
java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681) 
~[java.sql:?]
        at 
java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190) 
~[java.sql:?]
        at 
org.apache.iceberg.jdbc.JdbcClientPool.newClient(JdbcClientPool.java:88) ~[?:?]
        at 
org.apache.iceberg.jdbc.JdbcClientPool.newClient(JdbcClientPool.java:35) ~[?:?]
        at org.apache.iceberg.ClientPoolImpl.get(ClientPoolImpl.java:143) ~[?:?]
        at org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:70) ~[?:?]
        at org.apache.iceberg.ClientPoolImpl.run(ClientPoolImpl.java:65) ~[?:?]
        at 
org.apache.iceberg.jdbc.JdbcCatalog.atomicCreateTable(JdbcCatalog.java:162) 
~[?:?]
        at 
org.apache.iceberg.jdbc.JdbcCatalog.initializeCatalogTables(JdbcCatalog.java:208)
 ~[?:?]
        at org.apache.iceberg.jdbc.JdbcCatalog.initialize(JdbcCatalog.java:148) 
~[?:?]
        at 
org.apache.iceberg.jdbc.JdbcCatalogWithMetadataLocationSupport.initialize(JdbcCatalogWithMetadataLocationSupport.java:42)
 ~[?:?]
        at 
org.apache.gravitino.iceberg.common.utils.IcebergCatalogUtil.loadJdbcCatalog(IcebergCatalogUtil.java:118)
 ~[?:?]
        at 
org.apache.gravitino.iceberg.common.utils.IcebergCatalogUtil.loadCatalogBackend(IcebergCatalogUtil.java:170)
 ~[?:?]
        at 
org.apache.gravitino.iceberg.common.ops.IcebergCatalogWrapper.getCatalog(IcebergCatalogWrapper.java:111)
 ~[?:?]
        at 
org.apache.gravitino.catalog.lakehouse.iceberg.IcebergCatalogOperations.initialize(IcebergCatalogOperations.java:132)
 ~[?:?]
        at org.apache.gravitino.connector.BaseCatalog.ops(BaseCatalog.java:184) 
~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.asSchemas(CatalogManager.java:259)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.lambda$doWithSchemaOps$0(CatalogManager.java:141)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.utils.IsolatedClassLoader.withClassLoader(IsolatedClassLoader.java:86)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager$CatalogWrapper.doWithSchemaOps(CatalogManager.java:139)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager.containsUserCreatedSchemas(CatalogManager.java:875)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        at 
org.apache.gravitino.catalog.CatalogManager.lambda$dropCatalog$22(CatalogManager.java:789)
 ~[gravitino-core-1.3.0-SNAPSHOT.jar:?]
        ... 91 more
   
   ```
   
   ### How to reproduce
   
   1. create a Iceberg catalog, it works fine.
   2. the disable the catalog, and delete or rename the database in the MySQL 
   3. drop Iceberg catalog through gravitino API
   
   ### Additional context
   
   _No response_


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to