数据库连接超时，自动关闭 was active for 315435 milliseconds and has been removed automaticaly

最新推荐文章于 2023-05-05 11:18:23 发布

兮风

最新推荐文章于 2023-05-05 11:18:23 发布

阅读量1.3w

点赞数

分类专栏： J2EE Web开发文章标签：数据库 spring jdbc thread bean mysql

本文链接：https://blog.csdn.net/pk490525/article/details/8053324

版权

J2EE Web开发专栏收录该内容

20 篇文章 0 订阅

订阅专栏

在长时间导出数据时，经常看到一个错误，但是没怎么影响程序，就一直没管，今天就把它揪出来

[WARN] #0001 was active for 315435 milliseconds and has been removed automaticaly.
 The Thread responsible was named 'quartz-simpleThreadPoolTaskExecutor-1', 
but the last SQL it performed is unknown because the trace property is not enabled.

项目用的spring，配置有proxool连接池，这个问题也不怎么大，只是因为操作数据库超过5分钟还没有结束的时候，抛出错误意思是proxool连接池把超过309594 milliseconds的连接给关了，这样配大点就没问题了

<bean id="DataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource">
        <property name="driver" value="com.mysql.jdbc.Driver"></property>
        <property name="driverUrl" value="jdbc:mysql://ip:3306/comm?characterEncoding=UTF-8"></property>
        <property name="user" value="contact"></property>
        <property name="password" value="111111"></property>
        <property name="alias" value="contact_pool" />
    	<property name="prototypeCount" value="2" /> 
    	<property name="maximumConnectionCount" value="24" /> 
    	<property name="minimumConnectionCount" value="8" /> 
    	<property name="simultaneousBuildThrottle" value="24" /> 
    	<property name="maximumActiveTime" value="700000" />
    	<property name="houseKeepingSleepTime" value="99000" />
    	<property name="houseKeepingTestSql" value="select 1 from dual" />  
</bean>