com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 50, maxActive 50, runningSqlCount 28

whitzsjs  于 3个月前  发布在  Druid
关注(0)|答案(1)|浏览(78)

环境:
JDK1.7
SpringBoot1.5.4
Druid1.0.25

请教下各位,服务器最近运行的过程中报这个错,重复刷同一段SQL.
如:
nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 50, maxActive 50,
runningSqlCount 28 select * from aaa where a=1;
runningSqlCount 12 select * from bbb where a=2;
runningSqlCount 10 select * from ccc where a=3;
每天凌晨开始刷,直到上午10点左右就正常了.

配置文件:
spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.initialSize=5
spring.datasource.minIdle=5
spring.datasource.maxActive=50
spring.datasource.maxWait=60000
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=SELECT 1 FROM DUAL
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
spring.datasource.filters=stat,wall,log4j
spring.datasource.connectionProperties=drui.stat.mdergeSql=true;druid.stat.slowSqlMillis=5000
spring.datasource.removeAbandoned=true
spring.datasource.removeAbandonedTimeout=180
spring.datasource.logAbandoned=true

e4yzc0pl

e4yzc0pl1#

升级 mysql-connector-java 到5.1.48,升级druid到 1.1.24版本可以解决问题

相关问题