yuqi1129 commented on issue #12589: URL: https://github.com/apache/gravitino/issues/12589#issuecomment-5449459371
> The title appears to have been lost on submit. Suggested, from the body: "[Bug report] JDBC catalog operations fail with CommunicationsException after an idle period on a MySQL backend". > > The report is clear: a pooled MySQL connection is reused after the server has closed it for exceeding wait_timeout, so listSchemas fails on both Paimon (JdbcCatalog.listDatabases) and Iceberg (JdbcCatalog.listNamespaces) once the server has been idle. Validating the connection before use, or capping connection lifetime below the server's wait_timeout, would address it. Yeah, the reason is just as what Mark has addressed above, and we also met it in the Gravitino entity store. We need to verify the connection when fetching them from connection pool before using it. -- 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]
