org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC
Connection for transaction; nested exception is
com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 30000, active 12,
runningSqlCount 1 :
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: The last packet successfully received from the server was 83,820 milliseconds ago. The last packet sent successfully to the server was 83,822 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.
<!-- 配置获取连接等待超时的时间 -->
<property name="maxWait" value="${db.maxwait}" />
<!-- 超过时间限制是否回收 -->
<property name="removeAbandoned" value="true" />
<!-- 超时时间;单位为秒。180秒=3分钟 -->
<property name="removeAbandonedTimeout" value="1800" />
<!-- 关闭abanded连接时输出错误日志 -->
<property name="logAbandoned" value="false" />
<!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 -->
<property name="timeBetweenEvictionRunsMillis" value="10000" />
<!-- 配置一个连接在池中最小生存的时间,单位是毫秒 -->
<property name="minEvictableIdleTimeMillis" value="30000" />
<property name="validationQuery" value="SELECT 'x'" />
<property name="testWhileIdle" value="true" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />
<!-- 打开PSCache,并且指定每个连接上PSCache的大小 -->
<property name="poolPreparedStatements" value="true" />
<property name="maxPoolPreparedStatementPerConnectionSize" value="20" />
1.单个数据库最大连接数是200, 服务器是两台,每个都是200,改成了80
2. 改了数据库 waittimeout =60 3.改了 removeAbandonedTimeout 为45, timeBetweenEvictionRunsMillis 10的值 (两个加起来要小于 60)