C3P0连接池偶然会挂掉,似乎是线程死锁,求解?
图片是jconsole监控的c3p0的线程池状况
最近线上服务总是挂掉,从日志看似乎是c3p0连接池挂了。基本配置:jdk1.6+tomcat6
为方便解决问题,我贴出详细日志,以下是报错信息:
2013-12-11 09:23:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@177bb7a -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
2013-12-11 09:23:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@177bb7a -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@276565
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#1
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@71fc3b
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#2
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@16689d1
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#0
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@e23387
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@a50d8d
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1cbdf4
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@fb18b3
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@112af0c
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1a2417b
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1790797
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@e1796b
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@ea9491
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@bfeb3f
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@1ed8c0c
Pool thread stack traces:
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#1,5,main]
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)
java.io.DataInputStream.readFully(DataInputStream.java:178)
java.io.DataInputStream.readFully(DataInputStream.java:152)
net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:841)
net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:722)
net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3928)
net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1045)
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:465)
net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1301)
com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:85)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:509)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:463)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:435)
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:2151)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#2,5,main]
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)
java.io.DataInputStream.readFully(DataInputStream.java:178)
java.io.DataInputStream.readFully(DataInputStream.java:152)
net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:841)
net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:722)
net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3928)
net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1045)
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:465)
net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1301)
com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:85)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:509)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:463)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:435)
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:2151)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#0,5,main]
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)
java.io.DataInputStream.readFully(DataInputStream.java:178)
java.io.DataInputStream.readFully(DataInputStream.java:152)
net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:841)
net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:722)
net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3928)
net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1045)
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:465)
net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1301)
com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:85)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:509)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.testPooledConnection(C3P0PooledConnectionPool.java:463)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.refurbishIdleResource(C3P0PooledConnectionPool.java:435)
com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:2151)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
2013-12-11 09:24:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@177bb7a -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
2013-12-11 09:24:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@177bb7a -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@938184
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#0
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@1c35b8
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#1
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@af34d
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#2
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@eb4b6e
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@1a55cac
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@167555d
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@11559b2
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@b3ddae
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@9ecbe4
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@15c1e78
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@d4978d
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@129d998
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@8c8edb
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@1f6d97b
Pool thread stack traces:
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#0,5,main]
net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:693)
net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2202)
net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:728)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.releaseTds(ConnectionJDBC2.java:1903)
net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:853)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.close(ConnectionJDBC2.java:1980)
com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:629)
com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:259)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1024)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#1,5,main]
net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:693)
net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2202)
net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:728)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.releaseTds(ConnectionJDBC2.java:1903)
net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:853)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.close(ConnectionJDBC2.java:1980)
com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:629)
com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:259)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1024)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgf4eq8y1jdz3or1h42r0d|13a6057]-HelperThread-#2,5,main]
net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:693)
net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2202)
net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:728)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.releaseTds(ConnectionJDBC2.java:1903)
net.sourceforge.jtds.jdbc.JtdsStatement.close(JtdsStatement.java:853)
net.sourceforge.jtds.jdbc.ConnectionJDBC2.close(ConnectionJDBC2.java:1980)
com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:629)
com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:259)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1024)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
2013-12-11 09:24:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] Task com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@276565 (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
2013-12-11 09:24:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] Task com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@71fc3b (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
2013-12-11 09:24:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] Task com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask@16689d1 (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
2013-12-11 09:25:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] Task com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@938184 (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
2013-12-11 09:25:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] Task com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@1c35b8 (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
2013-12-11 09:25:07 [com.mchange.v2.async.ThreadPoolAsynchronousRunner]-[WARN] Task com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@af34d (in deadlocked PoolThread) failed to complete in maximum time 60000ms. Trying interrupt().
2013-12-11 09:27:39 [org.springframework.web.context.support.XmlWebApplicationContext]-[INFO] Closing org.springframework.web.context.support.XmlWebApplicationContext@130661d: display name [Root WebApplicationContext]; startup date [Fri Dec 06 19:16:16 CST 2013]; root of context hierarchy
2013-12-11 09:27:39 [org.springframework.beans.factory.support.DefaultListableBeanFactory]-[INFO] Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1c3d029: defining beans [configurer,oa.dataSource,oa.SqlMapClient,oa.sqlMapClientTemplate,oa.TransactionManager,txAdvice,org.springframework.aop.config.internalAutoProxyCreator,allServiceCut,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,swbudgetlog.dataSource,swbudgetlog.SqlMapClient,swbudgetlog.sqlMapClientTemplate,swbudgetlog.TransactionManager,swbudgetlog.TransactionTemplate,TbStTicket,tbStTicketDao,tbStTicketDetailDao,tbStTicketDetailBo,tbStTicketDetailAction,stSummaryDao,stSummaryBo,stSummaryAction,del_task,task,cronTrigger,del_cronTrigger,org.springframework.scheduling.quartz.SchedulerFactoryBean#0,appDocDao2,caiGouDao,baoXiaoDao,fuKuanDao,caiGouServer,baoXiaoServer,fukuanServer,mergeServer,caiGouAction,baoXiaoAction,fuKuanAction,swrightClient.dataSource,swrightClient.SqlMapClient,swrightClient.sqlMapClientTemplate,swrightClient.TransactionManager,swrightClient.TransactionTemplate,swrightClient.subsysAction,swrightClient.swmenuAction,swrightClient.swpageAction,swrightClient.swoperationAction,swrightClient.swpositionAction,swrightClient.sworgAction,swrightClient.sworgpositionAction,swrightClient.sworgposuserAction,swrightClient.userinfoAction,swrightClient.swUserAction,swrightClient.subsysBo,swrightClient.menuBo,swrightClient.swpageBo,swrightClient.swurlBo,swrightClient.swoperationBo,swrightClient.userBo,swrightClient.swpositionBo,swrightClient.swpositionratioBo,swrightClient.sworgBo,swrightClient.sworgpositionBo,swrightClient.sworgposuserBo,swrightClient.userinfoBo,roleBo,swrightClient.userroleBo,swrightClient.userKeeperFactory,swrightClient.userKeeper,swrightClient.urlInterceptor,swrightClient.subsysDAO,swrightClient.roleDAO,swrightClient.userDAO,swrightClient.swmenuDAO,swrightClient.swpageDAO,swrightClient.swoperationDAO,swrightClient.userroleDAO,swrightClient.swurlDAO,swrightClient.swpositionDAO,swrightClient.swpositionratioDAO,swrightClient.sworgDAO,swrightClient.sworgpositionDAO,swrightClient.sworgposuserDAO,swrightClient.userinfoDAO,contractRemindBean,contractRemindTriggerBean,punchRecordJob-Quartz,punchRecordTrigger,attendanceJob-Quartz,attendanceTrigger,wpcaigouJob-Quartz,wpcaigouTrigger,yearLeaveJob,yearLeaveTrigger,materialsUrgentMailJob,materialsUrgentMailTrigger,scheduledFactoryBean,teamBuildingFeeJob-Quartz,teamBuildingFeeTrigger,persistLoginJob,persistLoginJobTrigger,discuz.dataSource,discuz.jdbcTemplate,discuzPostDao,discuzPostBo,discuzPostAction,dczToppostDao,dczToppostBo,dczToppostAction,atc.dataSource,atc.SqlMapClient,atc.sqlMapClientTemplate,atc.TransactionManager,ehr.dataSource,ehr.SqlMapClient,ehr.sqlMapClientTemplate,ehr.TransactionManager,punchRecordDao,punchRecordBo,punchRecordJob,sendMsgJob,reasonDetector,notExistReasonMatchCentral,notExistBURULeaveMatcher,notExistLeaveMatcher,notExistTravelWriteOffMatcher,abnormalAnalyzer,statusAnalysis,resetStatusDevice,shiftListAbnormalAnalysis,regularClassesAbnormalAnalysis,whiteListAbnormalAnalysis,branchAbnormalAnalysis,transformPunchs,dayRecordCleanDevice,attendanceInterfaceDao,contactInfoInterfaceDao,hrmUserMsgInterfaceBo,hrmUserMsgInterfaceDao,abnormalRemind,buruWorkflowProcessor,workflowProcessor,applicationProcessor,independenceProcessor,singleDayCalculator,agentrightDao,agentrightBo,agentrightAction,appDocDao,appDocBo,appDocAction,applicationDao,applicationBo,applicationAction,appRightDao,appRightBo,appRightAction,apptemplateDao,apptemplateBo,apptemplateAction,appTypeDao,appTypeBo,appTypeAction,commonUtilAction,flowagentDao,flowagentBo,flowAttachAction,flowPrintAction,receiveAction,flowSetAction,getChildrenSworgAction,patchFlowDocJob,saveLeaveJob,passLeaveJob,refuseLeaveJob,updateLeaveJob,maternityLeaveJob,annualLeaveProcessor,dayOffProcessor,overtimeProcessor,leaveProcessFactory,signJob,savePurchaseJob,saveTravelWriteOffJob,marketScheduleJob,marketScheduleBackUpdJob,cwfksqTempRecordJob,passPlanTravelJob,passTravelWriteOffJob,refuseTravelWriteOffJob,travelSubmitJob,travelPlanRefuseJob,travelRealPassJob,travelPlanPassJob,processTicketBookJob,travelUpdateJob,saveAccountWriteOffJob,saveVirtualMoneyJob,virtualCashSaveJob,accountPresentAgreementSaveJob,saveFinanceAccountJob,saveFinancePayJob,saveChannelrebateJob,saveFinancePayYsJob,balanceExcuteSubmitJob,balanceExcuteApprovePayingJob,balanceExcutePayoffJob,balanceExcuteRefusepayingApproveJob,balanceExcuteSkipRevokeJob,balanceExcuteRevokeJob,balanceExcuteSubmitApproveJob,balanceExcutePayingJob,balanceExcuteTravelCancelJob,balanceExcuteTravelRefuseCancelJob,balanceExcuteCancelPayingJob,balanceExcuteRefusePayingCancelJob,balanceExcuteSubmitCWFKJob,balanceExcuteRevokeWPCGJob,balanceExcuteRevokeWPCGReSubmitJob,balanceExcuteRevokeSubmitWPCGJob,balanceExcuteRevokeSubmitWPCGTuiHuiJob,balanceExcuteRevokeCWFKJob,balanceExcuteApproveCancelPayingCWFKJob,balanceExcuteApproveWPCGJob,parseJob_cwbxsq_ys,parseJob_cwfksq_ys,parseJob_wpcg_ys,parseJob_ccsq_ys,saveBranchBudgetJob,saveLaunchJob,saveSpecialClientJob,saveCrackClientJob,saveDownLineClientJob,openChannelPresentJob,saveChannelPresentJob,openChannelPresentZHJob,saveChannelPresentZHJob,saveNetworkAdvertisementPublishJob,ggsbWaitLoanJob,refuseGgsbWaitLoanJob,ggsbLoanJob,ggsbReturnJob,saveBURULeaveJob,refuseBURULeaveJob,passBURULeaveJob,saveVirtualnetAccessJob,refuseVirtualnetAccessJob,passVirtualnetAccessJob,saveIdcOnLineJob,standardContractJob,standardContractBackUpdJob,standardContractSaveCustomersJob,nonStandardContractSaveCustomersJob,sparePartsStoreEnterJob,sparePartsStoreExitJob,sparePartsStoreOrderJob,gameCurrencySaveJob,saveTeamBuildingFeeJob,materialsaccountData,materialsaccountOrderJob,materialsaccountOutPutJob,materialsaccountOrderBackJob,purchaseCheckedJob,refusePurchaseCheckedJob,wPCaiGouCheckedJob,patchChannelAddJob,patchupgradeJob,flowNoteDao,flowNoteBo,flowNoteAction,logInfoDao,logInfoBo,useCarJob,cachetUseJob,cachetBorrowJob,officialSiteJob,franchiserUpdJob,patchUpdJob,travelWriteOffJob,travelPrintJob,accountWriteOffJob,frameContractJob,contractLegalJob,purchaseJob,purchaseYsJob,sofeSendJob,advertPlanJob,financeAccountJob,financePayJob,wygghtLogoJob,branchBudgetJob,diaoZhangJob,proxyAgreementJob,gameContractJob,operatorContractJob,accountPresentAgreementJob,printPosMapDao,printPosMapBo,signatureDao,signatureBo,signatureAction,templateFlowDao,templateFlowBo,templateFlowAction,templateNodeDao,templateNodeBo,userAppRightDao,userAppRightBo,userAppRightAction,cbtAttachmentDao,cbtAttachmentBo,cbtAttachmentAction,cbtAuthorityDao,cbtAuthorityBo,cbtAuthorityAction,cbtAuthoritymapDao,cbtAuthoritymapBo,cbtAuthoritymapAction,cbtAuthorityresourceDao,cbtAuthorityresourceBo,cbtAuthorityresourceAction,cbtFileDao,cbtFileBo,cbtFileAction,cbtFolderDao,cbtFolderBo,cbtFolderAction,cbtResourceDao,cbtResourceBo,cbtResourceAction,cbtTempfileDao,cbtTempfileBo,cbtTempfileAction,pathUtil,uploadifyUtil,editorPicTempFileAction,downloadAction,downloadUtil,poiWordExport,poiExcelExport,authorityMapCreater,cabinetManageService,cabinetSearchService,msgManageService,msgSearchService,newsManageService,newsSearchService,attachmentProvider,fileProvider,msgProvider,newsProvider,cbtFileLuceneBo,cbtAttachmentLuceneBo,cbtFolderLuceneBo,msgInfLuceneBo,newsInfoLuceneBo,docReader,htmlReader,mppReader,pdfReader,rttReader,txtReader,xlsReader,xlsxReader,docxReader,pptxReader,rarReader,zipReader,oa.cabinetIndexUtil,oa.workflowIndexUtil,oa.bookIndexUtil,oa.msgIndexUtil,flexPaperSupport,flashPaperSupport,oa.cabinet.SingleDownload,oa.cabinet.View,oa.cabinet.Delete,msgInfDao,msgInfBo,msgInfAction,birthdayBlessAction,defaultMsgManager,fileMsgManager,EmailTransmitter,SMSTransmitter,OpenMasManager,smsManager,mailManager,mailAssembler,sMSAssembler,mobileBookProvider,mobileScopeProvider,mailAddressBookProvider,mailAddressScopeProvider,mailAttachmentCabinetProvider,msgWorkflow,msgAttendance,msgRecordDao,msgRecordBo,msgRecordAction,msgStatusDao,msgStatusBo,msgStatusAction,msgTempDao,msgTempBo,msgTempAction,globalParametersDao,globalParametersBo,globalParametersAction,leaveDateDao,leaveDateBo,leaveDateAction,logDao,logBo,menuDao,menuBo,menuAction,menuButtonDao,menuButtonBo,menuButtonAction,menuRightDao,menuRightBo,menuRightAction,oaInfoService,flowNoteItem,flowReadItem,msgDepartItem,msgNoticeItem,msgSystemItem,msgWorkflowItem,msgAllItem,indexAction,ldap,loginAction,activeUserManage,pathHolder,oaMsgServiceImpl,UserServiceImpl,BookServiceImpl,ImgFileServiceImpl,userAction,swright.userSync,updatePasswordAction,bookAction,bookBo,bookDao,stAccountobjDao,stAccountobjBo,stAccountobjAction,stAccountpresentagreementDao,stAccountpresentagreementBo,stAccountpresentagreementjdDao,stAccountpresentagreementjdBo,stAccountwriteoffDao,stAccountwriteoffBo,stAccountwriteoffAction,stAccountwriteoffExport,stAccountwriteoffUtil,stAccountwriteoffdetilsDao,stAccountwriteoffdetilsBo,stAccountwriteoffdetilsAction,stAccountwriteoffsplitdetilsDao,stAccountwriteoffsplitdetilsBo,stAccountwriteoffsplitdetilsAction,stApprecalldataDao,stApprecalldataBo,stApprecalldataAction,stAreaDao,stAreaBo,stAreaAction,stBranchbudgetDao,stBranchbudgetBo,stBranchbudgetAction,stBranchbudgetdetailDao,stBranchbudgetdetailBo,stBranchbudgetdetailAction,stBudgetDao,stBudgetBo,stBudgetobjDao,stBudgetobjBo,stBudgetobjAction,stBuruleaveDao,stBuruleaveBo,stBuruleaveAction,stChannelpresentDao,stChannelpresentBo,stChannelpresentAction,stChannelpresentbudgetDao,stChannelpresentbudgetBo,stChannelpresentbudgetAction,stChannelpresentZHDao,stChannelpresentZHBo,stChannelpresentZHAction,stChannelpresentZHZDao,stChannelpresentZHZBo,stChannelrebateDao,stChannelrebateBo,stChannelrebateAction,stConsumerecordcopyDao,stConsumerecordcopyBo,stConsumerecordcopyAction,contimeStatMeans,contimeAction,stCrackclientDao,stCrackclientBo,stCrackclientAction,stDownlineclientDao,stDownlineclientBo,stDownlineclientAction,stEquipmentDao,stEquipmentBo,stEquipmentAction,getEquipmentAction,stExpenseDao,stExpenseBo,stExpenseAction,stFinanceaccountDao,stFinancefeedetailDao,stFinancesplitdetailDao,stFinancereceivedetailDao,stFinanceaccountBo,stFinancefeedetailBo,stFinancesplitdetailBo,stFinancereceivedetailBo,stFinanceaccountAction,stFinancepayDao,stFinancepayBo,stFinancepayAction,stFinancepayfeedetailDao,stFinancepayfeedetailBo,stFinancepayfeedetailAction,stFinancepaysplitdetailDao,stFinancepaysplitdetailBo,stFinancepaysplitdetailAction,stGamecurrencyrecordDao,stGamecurrencyrecordBo,stGamecurrencyrecordAction,stIdconlineDao,stIdconlineBo,stIdconlineAction,stLaunchwinDao,stLaunchwinBo,stLaunchwinAction,stLeaveDao,stLeaveBo,stLeaveAction,stMarketcustomerDao,stMarketcustomerBo,stMarketcustomerAction,stMarketscheduleDao,stMarketscheduleBo,stMarketscheduleAction,stMarketscheduledetailsDao,stMarketscheduledetailsBo,stMarketscheduledetailsAction,stMaterialsaccountDao,stMaterialsaccountBo,stMaterialsaccountAction,stMaterialsaccountrecordDao,stMaterialsaccountrecordBo,stMaterialsaccountrecordAction,stNetworkAdvertisementPublishDao,stNetworkAdvertisementPublishBo,stNetworkAdvertisementPublishCompanyBDao,stNetworkAdvertisementPublishCompanyBBo,stNetworkAdvertisementPublishCompanyBAction,stOrgbudgetmapDao,stOrgbudgetmapBo,stOrgbudgetmapAction,stPatchchanneldetailDao,stPatchchanneldetailBo,stPatchchanneldetailAction,stPatchupgradeDao,stPatchupgradeBo,stPatchupgradeAction,stPatchupgradeexecutedetailDao,stPatchupgradeexecutedetailBo,stPatchupgradeexecutedetailAction,stPatchupgradefiledetailDao,stPatchupgradefiledetailBo,stPatchupgradefiledetailAction,stPatchupgradepolicydetailDao,stPatchupgradepolicydetailBo,stPatchupgradepolicydetailAction,stPurchaseDao,stPurchaseBo,stPurchaseAction,stPurchasecheckedDao,stPurchasecheckedBo,stPurchasecheckedAction,goodsCheckedRemind,wPcaigouFlow,stPurchaseitemDao,stPurchaseitemBo,stPurchaseitemAction,stPurchaseitemsuppliersDao,stPurchaseitemsuppliersBo,stPurchasesuppliersDao,stPurchasesuppliersBo,stPurchasesuppliersAction,recordAction,stSparepartsrecordDao,stSparepartsrecordBo,stSparepartsrecordAction,stSparepartsstoreDao,stSparepartsstoreBo,stSparepartsstoreAction,stSpecialclientDao,stSpecialclientBo,stSpecialclientAction,stStandardDao,stStandardBo,stStandardAction,stTravelentertainfeeDao,stTravelentertainfeeBo,stTravelentertainfeeAction,stTravelticketbookDao,stTravelticketbookBo,stTravelticketbookAction,stTravelwriteoffDao,stTravelwriteoffBo,stTravelwriteoffAction,stTravelwriteoffExport,stTravelwriteoffUtil,stVirtualcashDao,stVirtualcashBo,stVirtualcashAction,stVirtualcashacDao,stVirtualcashacBo,stVirtualcashydDao,stVirtualcashydBo,stVirtualcashzdDao,stVirtualcashzdBo,stVirtualmoneyDao,stVirtualmoneyBo,stVirtualmoneyAction,stVirtualmoneyExport,stVirtualmoneydetilsDao,stVirtualmoneydetilsBo,stVirtualmoneydetilsAction,stVirtualnetaccessDao,stVirtualnetaccessBo,stVirtualnetaccessAction,tbInfEmployeeDao,tbInfEmployeeBo,tbInfEmployeeAction,tbOrgOrgunitDao,tbOrgOrgunitBo,tbOrgOrgunitAction,tbOrgOrgunitAppendDao,tbOrgOrgunitAppendBo,tbOrgOrgunitAppendAction,tbOrgUnitrelationDao,tbOrgUnitrelationBo,tbOrgUnitrelationAction,teamCostDao,teamCostBo,teamCostAction,teamCostdetailDao,teamCostdetailBo,teamCostdetailAction,teamCostpermissionDao,teamCostpermissionBo,teamCostpermissionAction,teamCostpersioncountDao,teamCostpersioncountBo,teamCostpersioncountAction,ctContractDao,ctContractBo,ctContractAction,ctUserorgDao,ctUserorgBo,ctUserorgAction,customersDao,customersBo,customersAction,balanceQueryBo,balanceQueryAction,budgetreferenceDao,budgetreferenceBo,sWUserDao,sWUserBo,setupInfDao,setupInfBo,setupInfAction,userInfoManageAction,newsClassDao,newsClassBo,newsClassAction,newsCommentDao,newsCommentBo,newsCommentAction,newsInfoDao,newsInfoBo,newsInfoAction,fileNewsManager,newsPictureDao,newsPictureBo,newsPictureAction,imgFileUtil,imgFileDao,imgFileBo,imgFileAction,imgPathUtil,imgUploadifyUtil,atcAbnormalinfoDao,atcAbnormalinfoBo,atcAbnormalinfoAction,atcAbnormalreasonDao,atcAbnormalreasonBo,atcAbnormalreasonAction,atcBackfromLeaveAction,atcDaysoffDao,atcDaysoffBo,atcDaysoffAction,atcFreezeTimeDao,atcFreezeTimeBo,atcFreezeTimeAction,atcFrontregisteDao,atcFrontregisteBo,atcFrontregisteAction,atcHrprocessingDao,atcHrprocessingBo,atcHrprocessingAction,atcPunchrecordDao,atcPunchrecordBo,atcPunchrecordAction,monthSchDataFormat,atcRedoDao,atcRedoBo,atcRedoAction,atcRemindinfoDao,atcRemindinfoBo,atcSelfconfirmDao,atcSelfconfirmBo,atcSelfconfirmAction,atcSignedoffDao,atcSignedoffBo,atcSignedoffAction,atcStatisticsDao,atcStatisticsBo,atcStatisticsAction,atcStatisticsdetailDao,atcStatisticsdetailBo,atcStatisticsdetailAction,atcStatisticsdetailXlsimportDao,atcStatisticsdetailXlsimportBo,atcStatisticsdetailXlsimportAction,atcStatisticsXlsimportDao,atcStatisticsXlsimportBo,poiExcelImport,atcStatisticsXlsimportAction,hrmtooaTask,hrmtooaCronTrigger,schedulertest,jsBasicinfoDao,jsBasicinfoBo,jsBasicinfoAction,cash.dataSource,cash.SqlMapClient,cash.sqlMapClientTemplate,cash.TransactionManager,cash.TransactionTemplate,groupStyleDao,qzGroupDao,qzGroupBo,qzGroupAction,userRelationDao,userRelationBo,userRelationAction,cqCommonquestionDao,cqCommonquestionBo,cqCommonquestionAction,cqTypeDao,cqTypeBo,cqTypeAction,hrBasicDao,hrBasicBo,hrBasicAction,hrIndexAction,operationManager,hrRecruitmentDao,hrRecruitmentBo,hrRecruitmentAction,rulesFilesDao,rulesFilesBo,rulesFilesAction,rulesTypeDao,rulesTypeBo,rulesTypeAction,tbNoticeContextDao,tbNoticeContextBo,tbNoticeContextAction,tbNoticeTypeDao,tbNoticeTypeBo,tbNoticeTypeAction,ys_atom_submit,ys_atom_revoke,ys_atom_approved,ys_atom_refuse,ys_atom_paying,ys_atom_refusepaying,ys_atom_cashier,ys_atom_cancelcashier,ys_atom_cancel,ys_atom_refusecancel,ys_atom_payoff,ys_atom_refusepayoff,ys_atom_check,ys_atom_supplement,ys_atom_refusesupplement,parseNewJob_ystz,parseNewJob_cwbxsq_ys_n,parseNewJob_cwbxsq_ys_n_n,parseNewJob_ccsq_ys,parseNewJob_ccsq_ys_n,parseNewJob_ccsq_ys_n_n,parseNewJob_cwptfk_ys,parseNewJob_cwcgfk_ys,parseNewJob_wpcgsq_ys,balanceExcuteSupplementNewJob,balanceExcuteRefusesupplementNewJob,balanceExcuteApproveNewJob,balanceExcuteApprovePayingNewJob,balanceExcuteCancelcashierNewJob,balanceExcuteCancelNewJob,balanceExcuteCancelPayingNewJob,balanceExcuteCashierNewJob,balanceExcutePayingNewJob,balanceExcutePayoffNewJob,balanceExcuteRefusecancelRefuseRevokeNewJob,balanceExcuteRefusepayingNewJob,balanceExcuteRefusepayingRefuseNewJob,balanceExcuteRefusepayingRefuseRevokeNewJob,balanceExcuteRefusepayoffRevokeNewJob,balanceExcuteRefuseRevokeNewJob,balanceExcuteRevokeNewJob,balanceExcuteRevokeSubmitApproveNewJob,balanceExcuteSubmitApproveNewJob,balanceExcuteSubmitNewJob,balanceExcuteSubmitPayoffNewJob,balanceExcuteRefuseRevokeSubmitApprovedNewJob,balanceExcuteRefuseRevokeSubmitApprovedPayingNewJob,newBalanceQueryAction,purchaseCloseDao,purchaseCloseBo,purchaseCloseAction,purchaseCloseDetailAction,${dubbo.application.name},com.alibaba.dubbo.config.RegistryConfig,dubbo,com.shunwang.itsupport.oaservice.service.OaMsgService,com.shunwang.itsupport.oaservice.service.UserService,com.shunwang.itsupport.oaservice.service.BookService,com.shunwang.itsupport.oaservice.service.ImgFileService,discuz.TransactionManager,discuz.TransactionTemplate,discuzJdbcDaoSupport]; root of factory hierarchy
2013-12-11 09:27:39 [org.springframework.scheduling.quartz.SchedulerFactoryBean]-[INFO] Shutting down Quartz Scheduler
2013-12-11 09:27:39 [org.springframework.scheduling.quartz.SchedulerFactoryBean]-[INFO] Shutting down Quartz Scheduler
2013-12-11 09:27:39 [org.springframework.scheduling.quartz.SchedulerFactoryBean]-[INFO] Shutting down Quartz Scheduler
2013-12-11 09:27:40 [com.alibaba.dubbo.registry.zookeeper.ZookeeperRegistry]-[INFO] [DUBBO] Unregister: dubbo://192.168.200.18:20886/com.shunwang.itsupport.oaservice.service.ImgFileService?anyhost=true&application=swoa-service-provider&dubbo=2.4.9&interface=com.shunwang.itsupport.oaservice.service.ImgFileService&loadbalance=roundrobin&methods=getById&pid=9496&revision=1.0.0-20131118.042828-4&side=provider&timeout=5000×tamp=1386328590255&version=1.0.0, dubbo version: 2.4.9, current host: 127.0.0.1
2013-12-11 09:27:40 [com.mchange.v2.resourcepool.BasicResourcePool]-[INFO] com.mchange.v2.resourcepool.BasicResourcePool@10b69b -- an attempt to checkout a resource was interrupted, because the pool is now closed. [Thread: http-8093-199]
2013-12-11 09:27:40 [com.mchange.v2.resourcepool.BasicResourcePool]-[INFO] com.mchange.v2.resourcepool.BasicResourcePool@10b69b -- an attempt to checkout a resource was interrupted, because the pool is now closed. [Thread: http-8093-198]
2013-12-11 09:27:40 [com.mchange.v2.resourcepool.BasicResourcePool]-[INFO] com.mchange.v2.resourcepool.BasicResourcePool@10b69b -- an attempt to checkout a resource was interrupted, because the pool is now closed. [Thread: http-8093-28]
2013-12-11 09:27:40 [com.mchange.v2.resourcepool.BasicResourcePool]-[INFO] com.mchange.v2.resourcepool.BasicResourcePool@10b69b -- an attempt to checkout a resource was interrupted, because the pool is now closed. [Thread: http-8093-193]
2013-12-11 09:27:40 [com.shunwang.oa.flow.web.AppDocAction]-[ERROR] Wed Dec 11 09:27:40 CST 2013 SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in flow/sqlmap/flowNote_sqlMap.xml.
--- The error occurred while executing query.
--- Check the select noteId, docId, appId, senderUsername, senderRealname, receiverUsername, receiverRealname, sendTime, nextStatus, docStatus, flowName, noteStatus, flowType, opid, sendNoteId, dealerUsername, dealerRealname, finishTime, noteType, stepnum, limitTime, fileId, receiveTime, agentTo, sendTo, sysAgentFlag from dbo.flowNote where noteId = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in flow/sqlmap/flowNote_sqlMap.xml.
--- The error occurred while executing query.
--- Check the select noteId, docId, appId, senderUsername, senderRealname, receiverUsername, receiverRealname, sendTime, nextStatus, docStatus, flowName, noteStatus, flowType, opid, sendNoteId, dealerUsername, dealerRealname, finishTime, noteType, stepnum, limitTime, fileId, receiveTime, agentTo, sendTo, sysAgentFlag from dbo.flowNote where noteId = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in flow/sqlmap/flowNote_sqlMap.xml.
--- The error occurred while executing query.
--- Check the select noteId, docId, appId, senderUsername, senderRealname, receiverUsername, receiverRealname, sendTime, nextStatus, docStatus, flowName, noteStatus, flowType, opid, sendNoteId, dealerUsername, dealerRealname, finishTime, noteType, stepnum, limitTime, fileId, receiveTime, agentTo, sendTo, sysAgentFlag from dbo.flowNote where noteId = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in flow/sqlmap/flowNote_sqlMap.xml.
--- The error occurred while executing query.
--- Check the select noteId, docId, appId, senderUsername, senderRealname, receiverUsername, receiverRealname, sendTime, nextStatus, docStatus, flowName, noteStatus, flowType, opid, sendNoteId, dealerUsername, dealerRealname, finishTime, noteType, stepnum, limitTime, fileId, receiveTime, agentTo, sendTo, sysAgentFlag from dbo.flowNote where noteId = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
at com.shunwang.framework.ibatis.dao.ConditionQueryDao.getById(ConditionQueryDao.java:108)
at com.shunwang.framework.ibatis.dao.ConditionQueryDao.getById(ConditionQueryDao.java:1)
at com.shunwang.framework.bo.ConditionCrudBo.getById(ConditionCrudBo.java:69)
at com.shunwang.oa.flow.web.AppDocAction.flowDoc(AppDocAction.java:190)
at sun.reflect.GeneratedMethodAccessor5654.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
at com.shunwang.oa.common.interceptor.ErrorProcessInterceptor.intercept(ErrorProcessInterceptor.java:27)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.shunwang.oa.common.interceptor.FrontLoginInterceptor.intercept(FrontLoginInterceptor.java:31)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at de.javakaffee.web.msm.SessionTrackerValve.invoke(SessionTrackerValve.java:126)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in flow/sqlmap/flowNote_sqlMap.xml.
--- The error occurred while executing query.
--- Check the select noteId, docId, appId, senderUsername, senderRealname, receiverUsername, receiverRealname, sendTime, nextStatus, docStatus, flowName, noteStatus, flowType, opid, sendNoteId, dealerUsername, dealerRealname, finishTime, noteType, stepnum, limitTime, fileId, receiveTime, agentTo, sendTo, sysAgentFlag from dbo.flowNote where noteId = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:273)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
... 76 more
Caused by: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:74)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:691)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
at $Proxy46.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
... 82 more
Caused by: java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:628)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:526)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:755)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:682)
... 90 more
2013-12-11 09:27:40 [com.mchange.v2.resourcepool.BasicResourcePool]-[INFO] com.mchange.v2.resourcepool.BasicResourcePool@10b69b -- an attempt to checkout a resource was interrupted, because the pool is now closed. [Thread: http-8093-139]
2013-12-11 09:27:40 [com.opensymphony.xwork2.DefaultActionInvocation]-[ERROR] There was an exception while instantiating the result of type org.apache.struts2.dispatcher.ServletDispatcherResult
java.lang.IllegalStateException: BeanFactory not initialized or already closed - call 'refresh' before accessing beans via the ApplicationContext
at org.springframework.context.support.AbstractRefreshableApplicationContext.getBeanFactory(AbstractRefreshableApplicationContext.java:153)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:880)
at com.opensymphony.xwork2.spring.SpringObjectFactory.buildBean(SpringObjectFactory.java:130)
at com.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:139)
at com.opensymphony.xwork2.ObjectFactory.buildResult(ObjectFactory.java:216)
at com.opensymphony.xwork2.DefaultActionInvocation.createResult(DefaultActionInvocation.java:209)
at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:356)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:266)
at com.shunwang.oa.common.interceptor.ErrorProcessInterceptor.intercept(ErrorProcessInterceptor.java:27)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.shunwang.oa.common.interceptor.FrontLoginInterceptor.intercept(FrontLoginInterceptor.java:31)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.struts2.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at de.javakaffee.web.msm.SessionTrackerValve.invoke(SessionTrackerValve.java:126)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
回答
同问,一直有这个错误,网上的解决办法基本都不靠谱最直接的解决建议是换个数据库连接池。网上的方法基本都试过了,确实很不靠谱啊!换个连接池也不靠谱,稳定性是个问题,不敢冒这个险,出了事就是大事故。请问最后解决了吗请问最后解决了吗再观察一段时间,如果实在不行,说服领导换掉它换druid 靠谱 oschina就是用的druid是啊是啊有人解决了吗