记录一个连接池溢出问题

王大爷 2020年07月30日 535次浏览

报错信息

Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: null,  message from server: "Host '47.96.181.183' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
### The error may exist in com/ydl/wo/service/dao/CpsWithdrawStatusMapper.java (best guess)
### The error may involve com.ydl.wo.service.dao.CpsWithdrawStatusMapper.selectByExample
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: null,  message from server: "Host '47.96.181.183' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

解决方式一

[CSDN]扩大连接池

解决方式二 为什么会出现超多连接问题? 如何监控,连接是否关闭,哪些没关,哪些可以优化?

连接池溢出 https://www.cnblogs.com/jay-huaxiao/p/12823368.html