danhuawang opened a new issue, #6874: URL: https://github.com/apache/gravitino/issues/6874
### Version main branch ### Describe what's wrong <img width="825" alt="Image" src="https://github.com/user-attachments/assets/d2dfdccc-c89d-419c-9430-e788a7589973"; /> ### Error message and/or stacktrace ``` [ "org.apache.ibatis.exceptions.PersistenceException: ", "### Error querying database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 53,480,036 milliseconds ago. The last packet sent successfully to the server was 53,480,037 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.", "### The error may exist in org/apache/gravitino/storage/relational/mapper/MetalakeMetaMapper.java (best guess)", "### The error may involve org.apache.gravitino.storage.relational.mapper.MetalakeMetaMapper.selectMetalakeIdMetaByName-Inline", "### The error occurred while setting parameters", "### SQL: SELECT metalake_id as metalakeId FROM metalake_meta WHERE metalake_name = ? and deleted_at = 0", "### Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 53,480,036 milliseconds ago. The last packet sent successfully to the server was 53,480,037 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.", "\tat org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)", "\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)", "\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)", "\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)", "\tat org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)", "\tat org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)", "\tat org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)", "\tat jdk.proxy2/jdk.proxy2.$Proxy28.selectMetalakeIdMetaByName(Unknown Source)", "\tat org.apache.gravitino.storage.relational.service.MetalakeMetaService.lambda$getMetalakeIdByName$0(MetalakeMetaService.java:83)", "\tat org.apache.gravitino.storage.relational.utils.SessionUtils.getWithoutCommit(SessionUtils.java:122)", "\tat org.apache.gravitino.storage.relational.service.MetalakeMetaService.getMetalakeIdByName(MetalakeMetaService.java:82)", "\tat org.apache.gravitino.storage.relational.service.CommonMetaService.getParentEntityIdByNamespace(CommonMetaService.java:41)", "\tat org.apache.gravitino.storage.relational.service.CatalogMetaService.getCatalogByIdentifier(CatalogMetaService.java:113)", "\tat org.apache.gravitino.storage.relational.JDBCBackend.get(JDBCBackend.java:220)", "\tat org.apache.gravitino.storage.relational.RelationalEntityStore.get(RelationalEntityStore.java:118)", "\tat org.apache.gravitino.catalog.CatalogManager.loadCatalogInternal(CatalogManager.java:921)", "\tat com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2406)", "\tat java.base/java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1916)", "\tat com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2404)", "\tat com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2387)", "\tat com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108)", "\tat com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62)", "\tat org.apache.gravitino.catalog.CatalogManager.loadCatalogAndWrap(CatalogManager.java:840)", "\tat org.apache.gravitino.catalog.CatalogManager.lambda$loadCatalog$7(CatalogManager.java:376)", "\tat org.apache.gravitino.lock.TreeLockUtils.doWithTreeLock(TreeLockUtils.java:49)", "\tat org.apache.gravitino.catalog.CatalogManager.loadCatalog(CatalogManager.java:371)", "\tat org.apache.gravitino.hook.CatalogHookDispatcher.loadCatalog(CatalogHookDispatcher.java:71)", "\tat org.apache.gravitino.catalog.CatalogNormalizeDispatcher.loadCatalog(CatalogNormalizeDispatcher.java:71)", "\tat org.apache.gravitino.listener.CatalogEventDispatcher.loadCatalog(CatalogEventDispatcher.java:106)", "\tat org.apache.gravitino.catalog.SupportsCatalogs.catalogExists(SupportsCatalogs.java:77)", "\tat org.apache.gravitino.utils.MetadataObjectUtil.checkMetadataObject(MetadataObjectUtil.java:138)", "\tat org.apache.gravitino.tag.TagManager.listTagsInfoForMetadataObject(TagManager.java:241)", "\tat org.apache.gravitino.listener.TagEventDispatcher.listTagsInfoForMetadataObject(TagEventDispatcher.java:227)", "\tat org.apache.gravitino.server.web.rest.MetadataObjectTagOperations.lambda$listTagsForMetadataObject$8(MetadataObjectTagOperations.java:167)", "\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:39)", "\tat org.apache.gravitino.server.web.Utils.doAs(Utils.java:188)", "\tat org.apache.gravitino.server.web.rest.MetadataObjectTagOperations.listTagsForMetadataObject(MetadataObjectTagOperations.java:159)", "\tat jdk.internal.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)", "\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)", "\tat java.base/java.lang.reflect.Method.invoke(Method.java:568)", "\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.doFilter(AuthenticationFilter.java:86)", "\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:111)", "\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:833)", "Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 53,480,036 milliseconds ago. The last packet sent successfully to the server was 53,480,037 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.", "\tat com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)", "\tat com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)", "\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)", "\tat com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)", "\tat org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:95)", "\tat org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:95)", "\tat org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)", "\tat org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)", "\tat org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)", "\tat org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)", "\tat org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)", "\tat org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)", "\tat org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)", "\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)", "\t... 102 more", "Caused by: com.mysql.cj.exceptions.CJCommunicationsException: The last packet successfully received from the server was 53,480,036 milliseconds ago. The last packet sent successfully to the server was 53,480,037 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.", "\tat java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)", "\tat java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)", "\tat java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)", "\tat java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)", "\tat java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)", "\tat com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)", "\tat com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)", "\tat com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)", "\tat com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)", "\tat com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:567)", "\tat com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:622)", "\tat com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:987)", "\tat com.mysql.cj.NativeSession.execSQL(NativeSession.java:666)", "\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:930)", "\t... 113 more", "Caused by: java.net.SocketException: Broken pipe", "\tat java.base/sun.nio.ch.NioSocketImpl.implWrite(NioSocketImpl.java:420)", "\tat java.base/sun.nio.ch.NioSocketImpl.write(NioSocketImpl.java:440)", "\tat java.base/sun.nio.ch.NioSocketImpl$2.write(NioSocketImpl.java:826)", "\tat java.base/java.net.Socket$SocketOutputStream.write(Socket.java:1035)", "\tat java.base/sun.security.ssl.SSLSocketOutputRecord.deliver(SSLSocketOutputRecord.java:345)", "\tat java.base/sun.security.ssl.SSLSocketImpl$AppOutputStream.write(SSLSocketImpl.java:1298)", "\tat java.base/java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:81)", "\tat java.base/java.io.BufferedOutputStream.flush(BufferedOutputStream.java:142)", "\tat com.mysql.cj.protocol.a.SimplePacketSender.send(SimplePacketSender.java:55)", "\tat com.mysql.cj.protocol.a.TimeTrackingPacketSender.send(TimeTrackingPacketSender.java:50)", "\tat com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:558)", "\t... 117 more" ``` ### How to reproduce 1. Use MySQL database as Gravitino backend 2. Create relational catalogs , schemas, tables (PG catalog or MySQL catalog or Hive catalog) 3. Don't access the environment at least 8 hours. 4. Access gravitino URL. ### 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: commits-unsubscr...@gravitino.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
