wingkingbobo opened a new issue, #19085: URL: https://github.com/apache/shardingsphere/issues/19085
## Question Is there any way to monitor the connection pool like druid monitor？ Recently, I have encountered several times in the online environment that the sharding proxy database connection is unavailable, which will occur one day to one month after the server is started. At this time, I try to use Navicat to test the direct connection to MySQL. It can connect, but it can't connect to sharding proxy. The log is as follows: ``` ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConne ctionException: Failed to obtain JDBC Connection; nested exception is java.sql.S QLTransientConnectionException: HikariPool-1 - Connection is not available, requ est timed out after 30001ms. ### The error may exist in com/xxx/dao/XXDao.java (b est guess) ### The error may involve com.xxx.dao.XXDao.selectXXByID ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionExcep tion: HikariPool-1 - Connection is not available, request timed out after 30001m s. ``` I hope there is a way to monitor the status of sharding proxy connection pool. Can you give me some suggestions. Thanks. -- 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]
