记一次连接池配置导致的问题

最新推荐文章于 2024-04-18 00:16:02 发布

e_shi_yi_p_l

最新推荐文章于 2024-04-18 00:16:02 发布

阅读量396

点赞数

分类专栏： mysql- 多线程

本文链接：https://blog.csdn.net/e_shi_yi_p/article/details/106071158

版权

本文记录了一次由于连接池配置不当导致的错误，问题在于数据库服务端线程池关闭了长时间未使用的连接，而客户端未能及时察觉。通过理解长连接的工作原理，特别是服务端的超时机制，发现当前的连接池配置缺乏检测功能。参考相关资料后，增加了检测机制，成功解决了问题。

摘要由CSDN通过智能技术生成

最近测试环境老抛出这个错，

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 53,014,427 milliseconds ago.  The last packet sent successfully to the server was 53,014,427 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.
	at sun.reflect.GeneratedConstructorAccessor58.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3706)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2506)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
	at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4776)
	at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:267)
	... 58 common frames omitted
	
引起原因：com.mysql.jdbc.exceptions.jdbc4.CommunicationsException：从服务器成功接收到的最后一个数据包是53,014,427毫秒之前。 成功发送到服务器的最后一个数据包是53,014,427毫秒之前。 大于服务器配置的“ wait_timeout”值。 您应考虑在应用程序中使用连接之前使连接有效性到期和/或对其进行测试，或者增加服务器为客户端超时配置的值，或者使用Connector / J连接属性'autoReconnect = true'来避免此问题。


Caused by: java.net.SocketException: 断开的管道 (Write failed)
	at java.net.SocketOutputStream.socketWrite0(Native Method