druid数据库连接溢出,导致应用宕机,数据库用的是阿里云的RDS,连接数允许8000
连接池配置如下:
tomcat错误日志:
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 67457, active 20, maxActive 20, runningSqlCount 1 : SELECT id, title, content, RIGHT(create_time, ?) AS parseTime, created_by_name
, updated_by_name AS publisherName, pic_url, file_url
FROM nt_notice
WHERE create_time IS NOT NULL
ORDER BY id DESC
LIMIT ?, ?
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:245)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.Transact