阿里Druid连接池连接不释放、连接泄漏排查

1
2
3
4
5
6

<!-- 超过时间限制是否回收 -->  
<property name="removeAbandoned" value="true" />  
<!-- 超时时间；单位为秒。180秒=3分钟   -->
<property name="removeAbandonedTimeout" value="180" />  
<!-- 关闭abanded连接时输出错误日志   -->
<property name="logAbandoned" value="true" />

1
2
3
4
5
6
7
8
9

2019-04-17 17:10:05:140 - ERROR [Druid-ConnectionPool-Destroy-1559154670] - com.alibaba.druid.pool.DruidDataSource com.alibaba.druid.pool.DruidDataSource.removeAbandoned:2666 abandon connection, owner thread: http-nio-8085-exec-1, connected at : 1555491605100, open stackTrace
	at java.lang.Thread.getStackTrace(Thread.java:1559)
	at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1313)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1235)
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1225)
	at com.xxxx.xx.common.util.JdbcUtil.linkTrace(JdbcUtil.java:39)
	at com.xxxx.xx.xxxxx.service.impl.DashboardServiceImpl.getExpenTrend(DashboardServiceImpl.java:263)
	at com.xxxx.xx.xxxxx.service.impl.DashboardServiceImpl.getBossData(DashboardServiceImpl.java:58)
	at com.xxxx.xx.xxxxx.controller.DashboardController.getBossData(DashboardController.java:43)