markhoerth commented on issue #12589: URL: https://github.com/apache/gravitino/issues/12589#issuecomment-5444015568
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. -- 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]
