关于quartz中占满数据库连接问题

chendianVista 2014-02-13 09:42:37

项目中使用了quartz1.6.5版本，一直在was上运行的很稳定，有一天突然发生如下错误：
[14-2-12 8:22:34:326 CST] 00000030 LocalDataSour E org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler manage MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'springNonTxDataSource.IMESScheduler': com.ibm.websphere.ce.cm.StaleConnectionException: Io 异常: Connection resetDSRA0010E: SQL 状态 = null，错误代码 = 17,002
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.IMESScheduler': com.ibm.websphere.ce.cm.StaleConnectionException: Io 异常: Connection resetDSRA0010E: SQL 状态 = null，错误代码 = 17,002 [See nested exception: com.ibm.websphere.ce.cm.StaleConnectionException: Io 异常: Connection resetDSRA0010E: SQL 状态 = null，错误代码 = 17,002]
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:167)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3108)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3887)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3907)
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: Io 异常: Connection resetDSRA0010E: SQL 状态 = null，错误代码 = 17,002
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:67)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:522)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:525)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:580)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2160)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1683)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1256)
at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1990)
at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1662)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2363)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:934)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:610)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:449)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:418)
at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
at $Proxy5.getConnection(Unknown Source)
at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)
at org.quartz

报数据库连接不了，但过了十几分钟后，数据库又能连接的上，系统恢复正常（没有任何人为操作），看数据库监控那边，SELECT * FROM QUARTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE 这句话占用很高的连接数，但这个表是在quartz中使用的，对应用系统不可见，这是不是quartz内部的BUG引起的，望路过的大牛答疑解惑，谢谢！

...全文