NutzCN Logo
问答 DB2数据库连接中断
发布于 37天前 作者 efraiser 148 次浏览 复制 上一个帖子 下一个帖子
标签:

系统架构是两台服务器,一个服务器上面装应用和数据库,另一个应用单独一个服务器。两个应用连接一个数据库,其中只有一个应用服务器上的应用连接数据库一开始能连接上,但是过一会就会断开。重启服务或者多次刷新页面又正常了,网络PING 一直都是正常的没有发现丢包,请问可能输什么原因导致的,报错信息如下

15:46:38 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'driver'<class java.lang.String>
15:46:38 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT (SELECT count(*) AS checkNoPassNum1  FROM SYS_BMGL bm,SYS_GGZD zd WHERE zd.G_ID='RD_TABLE_TAB_TYPE' AND BM.COUNT_FLAG='1' AND bm.BM_AREA IS NOT NULL AND zd.ZD_VALUE IN('50','40','80')  AND EXISTS (SELECT 1 FROM SYS_USER_DEP ud WHERE ud.USER_ID='admin' AND ud.DEP_ID=bm.BM_CODE)),(SELECT count(*) AS checkNoPassNum2 FROM RD_CHECK_LOG rl WHERE rl.REPORT_DATE='201806' AND EXISTS(SELECT 1 FROM SYS_USER_DEP ud WHERE ud.USER_ID='admin' AND ud.DEP_ID=rl.ORGAN_NO))FROM SYSIBM.SYSDUMMY1
15:46:38 [DEBUG] org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [POST] path=/rd/check/log/getRdReportCheckLogForUser : RdCheckLogAction.getRdReportCheckLogForUser(...)
15:46:38 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'rdCheckLogAction'<class com.efraiser.rd.action.RdCheckLogAction>
15:46:38 [DEBUG] org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [POST] path=/sys/notice/getSysNoticeList : SysNoticeAction.getSysNoticeList(...)
15:46:38 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'sysNoticeAction'<class com.efraiser.sys.action.SysNoticeAction>
15:46:38 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT ORGAN_NO as areaCode,GET_BM_NAME(ORGAN_NO) as areaCodeName,sum(case when  check_risk='1' THEN 1 ELSE 0 END) AS checkNoPassNum1,sum(case when  check_risk='2' THEN 1 ELSE 0 END) AS checkNoPassNum2 FROM RD_CHECK_RESULTS t WHERE t.REPORT_DATE='201806' AND EXISTS(SELECT 1 FROM SYS_USER_DEP ud WHERE ud.DEP_ID=t.ORGAN_NO AND ud.USER_ID='admin') GROUP BY t.ORGAN_NO ORDER BY checkNoPassNum1 desc
15:46:38 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM SYS_NOTICE  ORDER BY release_Date DESC  ) T) AS A WHERE ROWNUM BETWEEN 1 AND 20 
15:46:38 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT COUNT(*) FROM SYS_NOTICE 
15:47:02 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:47:25 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:47:51 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:48:16 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:48:40 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:49:05 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:49:32 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:50:01 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:50:26 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:50:52 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:51:17 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:51:40 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:52:04 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:52:31 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:53:01 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:53:29 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:53:56 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:54:21 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:54:49 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:55:14 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:55:38 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:56:06 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:56:34 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:57:02 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:57:28 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:57:53 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:58:22 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:58:47 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:59:10 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
15:59:38 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 1 triggers
16:00:00 [DEBUG] org.quartz.simpl.PropertySettingJobFactory - Producing instance of Job 'defaultGroup.654de4b17cc0445084e73733fa642c4f', class=com.efraiser.ts.util.QuartzJob
16:00:00 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 1 triggers
16:00:00 [DEBUG] org.quartz.simpl.PropertySettingJobFactory - Producing instance of Job 'defaultGroup.9aeeb88bc34f4b40ba4f43223e50bc02', class=com.efraiser.ts.util.QuartzJob
16:00:00 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 1 triggers
16:00:00 [DEBUG] org.quartz.simpl.PropertySettingJobFactory - Producing instance of Job 'defaultGroup.e736d15f118844118ba00668b5937de1', class=com.efraiser.ts.util.QuartzJob
16:00:00 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
16:00:00 [DEBUG] org.quartz.core.JobRunShell - Calling execute on job defaultGroup.654de4b17cc0445084e73733fa642c4f
16:00:00 [DEBUG] com.efraiser.ts.util.QuartzJob - 进入QuartzJob方法
16:00:00 [INFO ] com.efraiser.ts.util.SchedulerManager - 调度任务-----[ 每天3点至23点之间,每120分钟执行一次 ]----开始执行
16:00:00 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'tsTaskListDao'<class com.efraiser.ts.dao.TsTaskListDao>
16:00:00 [DEBUG] org.quartz.core.JobRunShell - Calling execute on job defaultGroup.9aeeb88bc34f4b40ba4f43223e50bc02
16:00:00 [DEBUG] com.efraiser.ts.util.QuartzJob - 进入QuartzJob方法
16:00:00 [INFO ] com.efraiser.ts.util.SchedulerManager - 调度任务-----[ 每隔2个小时执行一次 ]----开始执行
16:00:00 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'tsTaskListDao'<class com.efraiser.ts.dao.TsTaskListDao>
16:00:00 [DEBUG] org.quartz.core.JobRunShell - Calling execute on job defaultGroup.e736d15f118844118ba00668b5937de1
16:00:00 [DEBUG] com.efraiser.ts.util.QuartzJob - 进入QuartzJob方法
16:00:00 [INFO ] com.efraiser.ts.util.SchedulerManager - 调度任务-----[ 每隔30分钟执行一次 ]----开始执行
16:00:00 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'tsTaskListDao'<class com.efraiser.ts.dao.TsTaskListDao>
16:00:08 [DEBUG] org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [GET] path=/sys/properties/loginImg1 : SysPropertiesAction.loginImg1(...)
16:00:08 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'sysPropertiesAction'<class com.efraiser.sys.action.SysPropertiesAction>
16:00:08 [DEBUG] org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [GET] path=/sys/properties/loginImg2 : SysPropertiesAction.loginImg2(...)
16:00:08 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'sysPropertiesAction'<class com.efraiser.sys.action.SysPropertiesAction>
16:00:16 [DEBUG] org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [POST] path=/doLogin : LoginAction.doLogin(...)
16:00:16 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'loginAction'<class com.efraiser.sys.action.LoginAction>
16:00:16 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'DateFormat'<class java.lang.String>
16:00:16 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'EastScoreShow'<class java.lang.String>
16:00:21 [DEBUG] org.nutz.dao.impl.jdbc.AbstractJdbcExpert - Table 'TS_TASK_LIST' doesn't exist!
16:00:21 [ERROR] org.quartz.core.JobRunShell - Job defaultGroup.654de4b17cc0445084e73733fa642c4f threw an unhandled Exception: 
java.lang.RuntimeException: java.sql.SQLException: Already closed.
	at org.nutz.lang.Lang.wrapThrow(Lang.java:148) ~[nutz-1.b.53.jar:na]
	at org.nutz.trans.Trans.closeConnectionAuto(Trans.java:278) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.entity.AnnotationEntityMaker._checkupEntityFieldsWithDatabase(AnnotationEntityMaker.java:546) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.entity.AnnotationEntityMaker.make(AnnotationEntityMaker.java:277) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.EntityHolder.getEntity(EntityHolder.java:65) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.NutDao.query(NutDao.java:445) ~[nutz-1.b.53.jar:na]
	at org.nutz.service.EntityService.query(EntityService.java:120) ~[nutz-1.b.53.jar:na]
	at com.efraiser.ts.dao.TsTaskListDao.getTaskListsByCycleId(TsTaskListDao.java:33) ~[classes/:na]
	at com.efraiser.ts.util.SchedulerManager.exceteCycleTask(SchedulerManager.java:105) ~[classes/:na]
	at com.efraiser.ts.util.QuartzJob.execute(QuartzJob.java:16) ~[classes/:na]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.2.1.jar:na]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.2.1.jar:na]
Caused by: java.sql.SQLException: Already closed.
	at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84) ~[commons-dbcp.jar:1.2.2]
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181) ~[commons-dbcp.jar:1.2.2]
	at org.nutz.trans.Trans.closeConnectionAuto(Trans.java:275) ~[nutz-1.b.53.jar:na]
	... 10 common frames omitted
16:00:21 [ERROR] org.quartz.core.ErrorLogger - Job (defaultGroup.654de4b17cc0445084e73733fa642c4f threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception.
	at org.quartz.core.JobRunShell.run(JobRunShell.java:213) ~[quartz-2.2.1.jar:na]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.2.1.jar:na]
Caused by: java.lang.RuntimeException: java.sql.SQLException: Already closed.
	at org.nutz.lang.Lang.wrapThrow(Lang.java:148) ~[nutz-1.b.53.jar:na]
	at org.nutz.trans.Trans.closeConnectionAuto(Trans.java:278) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.entity.AnnotationEntityMaker._checkupEntityFieldsWithDatabase(AnnotationEntityMaker.java:546) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.entity.AnnotationEntityMaker.make(AnnotationEntityMaker.java:277) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.EntityHolder.getEntity(EntityHolder.java:65) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.NutDao.query(NutDao.java:445) ~[nutz-1.b.53.jar:na]
	at org.nutz.service.EntityService.query(EntityService.java:120) ~[nutz-1.b.53.jar:na]
	at com.efraiser.ts.dao.TsTaskListDao.getTaskListsByCycleId(TsTaskListDao.java:33) ~[classes/:na]
	at com.efraiser.ts.util.SchedulerManager.exceteCycleTask(SchedulerManager.java:105) ~[classes/:na]
	at com.efraiser.ts.util.QuartzJob.execute(QuartzJob.java:16) ~[classes/:na]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.2.1.jar:na]
	... 1 common frames omitted
Caused by: java.sql.SQLException: Already closed.
	at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84) ~[commons-dbcp.jar:1.2.2]
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181) ~[commons-dbcp.jar:1.2.2]
	at org.nutz.trans.Trans.closeConnectionAuto(Trans.java:275) ~[nutz-1.b.53.jar:na]
	... 10 common frames omitted
16:00:27 [DEBUG] org.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
16:00:34 [WARN ] org.nutz.mvc.impl.processor.FailProcessor - Error@/doLogin :
org.nutz.dao.DaoException: com.ibm.db2.jcc.am.yn: [jcc][t4][2030][11211][3.57.82] 在对连接的底层 socket、socket input stream 或 socket output stream 执行操作期间
发生通信错误。错误位置:Reply.fill()。消息:Read timed out。 ERRORCODE=-4499, SQLSTATE=08001
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:50) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:219) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.NutDao.fetch(NutDao.java:549) ~[nutz-1.b.53.jar:na]
	at org.nutz.service.EntityService.fetch(EntityService.java:157) ~[nutz-1.b.53.jar:na]
	at com.efraiser.sys.dao.SysUserDao.getSysUser(SysUserDao.java:144) ~[classes/:na]
	at com.efraiser.sys.dao.SysUserDao$$NUTZAOP._aop_invoke(SysUserDao.java:1) ~[nutz-1.b.53.jar:na]
	at org.nutz.aop.InterceptorChain.invoke(InterceptorChain.java:77) ~[nutz-1.b.53.jar:na]
	at org.nutz.aop.InterceptorChain.doChain(InterceptorChain.java:57) ~[nutz-1.b.53.jar:na]
	at org.nutz.aop.interceptor.TransactionInterceptor.filter(TransactionInterceptor.java:34) ~[nutz-1.b.53.jar:na]
	at org.nutz.aop.InterceptorChain.doChain(InterceptorChain.java:60) ~[nutz-1.b.53.jar:na]
	at com.efraiser.sys.dao.SysUserDao$$NUTZAOP.getSysUser(SysUserDao.java) ~[nutz-1.b.53.jar:na]
	at com.efraiser.sys.action.LoginAction.doLogin(LoginAction.java:93) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_60]
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.7.0_60]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.7.0_60]
	at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.7.0_60]
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:25) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:33) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:40) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:113) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:40) ~[nutz-1.b.53.jar:na]
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67) [nutz-1.b.53.jar:na]
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31) [nutz-1.b.53.jar:na]
	at org.nutz.mvc.NutServlet.service(NutServlet.java:66) [nutz-1.b.53.jar:na]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) [servlet-api.jar:na]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) [catalina.jar:7.0.73]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.73]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat7-websocket.jar:7.0.73]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.73]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.73]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) [catalina.jar:7.0.73]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) [catalina.jar:7.0.73]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) [catalina.jar:7.0.73]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) [catalina.jar:7.0.73]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) [catalina.jar:7.0.73]
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:958) [catalina.jar:7.0.73]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) [catalina.jar:7.0.73]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452) [catalina.jar:7.0.73]
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) [tomcat-coyote.jar:7.0.73]
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) [tomcat-coyote.jar:7.0.73]
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2517) [tomcat-coyote.jar:7.0.73]
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2506) [tomcat-coyote.jar:7.0.73]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.7.0_60]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.7.0_60]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-coyote.jar:7.0.73]
	at java.lang.Thread.run(Unknown Source) [na:1.7.0_60]
Caused by: com.ibm.db2.jcc.am.yn: [jcc][t4][2030][11211][3.57.82] 在对连接的底层 socket、socket input stream 或 socket output stream 执行操作期间
发生通信错误。错误位置:Reply.fill()。消息:Read timed out。 ERRORCODE=-4499, SQLSTATE=08001
	at com.ibm.db2.jcc.am.bd.a(bd.java:319) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.a.a(a.java:365) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.a.a(a.java:360) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.ab.b(ab.java:202) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.ab.c(ab.java:243) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.ab.c(ab.java:354) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.ab.v(ab.java:1139) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.db.b(db.java:45) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.t.b(t.java:38) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.t4.sb.g(sb.java:114) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.am.km.db(km.java:1898) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.am.km.a(km.java:2899) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.am.km.e(km.java:985) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.am.jb.a(jb.java:1855) ~[db2jcc.jar:na]
	at com.ibm.db2.jcc.am.jb.setSavepoint(jb.java:1795) ~[db2jcc.jar:na]
	at org.apache.commons.dbcp.DelegatingConnection.setSavepoint(DelegatingConnection.java:402) ~[commons-dbcp.jar:1.2.2]
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setSavepoint(PoolingDataSource.java:364) ~[commons-dbcp.jar:1.2.2]
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:30) ~[nutz-1.b.53.jar:na]
	... 52 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
	at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.7.0_60]
	at java.net.SocketInputStream.read(Unknown Source) ~[na:1.7.0_60]
	at java.net.SocketInputStream.read(Unknown Source) ~[na:1.7.0_60]
	at com.ibm.db2.jcc.t4.ab.b(ab.java:195) ~[db2jcc.jar:na]
	... 66 common frames omitted
16:00:40 [DEBUG] org.nutz.dao.impl.jdbc.AbstractJdbcExpert - Table 'TS_TASK_LIST' doesn't exist!
16:00:40 [ERROR] org.quartz.core.JobRunShell - Job defaultGroup.e736d15f118844118ba00668b5937de1 threw an unhandled Exception: 
java.lang.RuntimeException: java.sql.SQLException: Already closed.
	at org.nutz.lang.Lang.wrapThrow(Lang.java:148) ~[nutz-1.b.53.jar:na]
	at org.nutz.trans.Trans.closeConnectionAuto(Trans.java:278) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.entity.AnnotationEntityMaker._checkupEntityFieldsWithDatabase(AnnotationEntityMaker.java:546) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.entity.AnnotationEntityMaker.make(AnnotationEntityMaker.java:277) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.EntityHolder.getEntity(EntityHolder.java:65) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.NutDao.query(NutDao.java:445) ~[nutz-1.b.53.jar:na]
	at org.nutz.service.EntityService.query(EntityService.java:120) ~[nutz-1.b.53.jar:na]
	at com.efraiser.ts.dao.TsTaskListDao.getTaskListsByCycleId(TsTaskListDao.java:33) ~[classes/:na]
	at com.efraiser.ts.util.SchedulerManager.exceteCycleTask(SchedulerManager.java:105) ~[classes/:na]
	at com.efraiser.ts.util.QuartzJob.execute(QuartzJob.java:16) ~[classes/:na]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.2.1.jar:na]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.2.1.jar:na]
Caused by: java.sql.SQLException: Already closed.
	at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84) ~[commons-dbcp.jar:1.2.2]
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181) ~[commons-dbcp.jar:1.2.2]
	at org.nutz.trans.Trans.closeConnectionAuto(Trans.java:275) ~[nutz-1.b.53.jar:na]
	... 10 common frames omitted
16:00:40 [ERROR] org.quartz.core.ErrorLogger - Job (defaultGroup.e736d15f118844118ba00668b5937de1 threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception.
	at org.quartz.core.JobRunShell.run(JobRunShell.java:213) ~[quartz-2.2.1.jar:na]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.2.1.jar:na]
Caused by: java.lang.RuntimeException: java.sql.SQLException: Already closed.
	at org.nutz.lang.Lang.wrapThrow(Lang.java:148) ~[nutz-1.b.53.jar:na]
	at org.nutz.trans.Trans.closeConnectionAuto(Trans.java:278) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.entity.AnnotationEntityMaker._checkupEntityFieldsWithDatabase(AnnotationEntityMaker.java:546) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.entity.AnnotationEntityMaker.make(AnnotationEntityMaker.java:277) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.EntityHolder.getEntity(EntityHolder.java:65) ~[nutz-1.b.53.jar:na]
	at org.nutz.dao.impl.NutDao.query(NutDao.java:445) ~[nutz-1.b.53.jar:na]
	at org.nutz.service.EntityService.query(EntityService.java:120) ~[nutz-1.b.53.jar:na]
	at com.efraiser.ts.dao.TsTaskListDao.getTaskListsByCycleId(TsTaskListDao.java:33) ~[classes/:na]
	at com.efraiser.ts.util.SchedulerManager.exceteCycleTask(SchedulerManager.java:105) ~[classes/:na]
	at com.efraiser.ts.util.QuartzJob.execute(QuartzJob.java:16) ~[classes/:na]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.2.1.jar:na]
	... 1 common frames omitted
Caused by: java.sql.SQLException: Already closed.
	at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84) ~[commons-dbcp.jar:1.2.2]
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181) ~[commons-dbcp.jar:1.2.2]
	at org.nutz.trans.Trans.closeConnectionAuto(Trans.java:275) ~[nutz-1.b.53.jar:na]
	... 10 common frames omitted
16:00:40 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT * FROM TS_TASK_LIST  WHERE CYCLE_ID=? AND flag=? ORDER BY TASK_INDEX ASC  
    |                                1 | 2 |
    |----------------------------------|---|
    | 9aeeb88bc34f4b40ba4f43223e50bc02 | 1 |
  For example:> "SELECT * FROM TS_TASK_LIST  WHERE CYCLE_ID='9aeeb88bc34f4b40ba4f43223e50bc02' AND flag='1' ORDER BY TASK_INDEX ASC  "
16:00:40 [INFO ] com.efraiser.ts.util.SchedulerManager - 调度任务-----[ 每隔2个小时执行一次 ]----完成执行
16:00:45 [DEBUG] org.nutz.mvc.impl.UrlMappingImpl - Found mapping for [POST] path=/doLogin : LoginAction.doLogin(...)
16:00:45 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'loginAction'<class com.efraiser.sys.action.LoginAction>
16:00:45 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'DateFormat'<class java.lang.String>
16:00:45 [DEBUG] org.nutz.ioc.impl.NutIoc - Get 'EastScoreShow'<class java.lang.String>
16:00:45 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM SYS_USER  WHERE USER_ID=? AND USER_PASS=?) T) AS A WHERE ROWNUM BETWEEN 1 AND 1 
    |                 1 |                                2 |
    |-------------------|----------------------------------|
    | E001B101321003001 | 21218cca77804d2ba1922c33e0151105 |
  For example:> "SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM SYS_USER  WHERE USER_ID='E001B101321003001' AND USER_PASS='21218cca77804d2ba1922c33e0151105') T) AS A WHERE ROWNUM BETWEEN 1 AND 1 "
16:00:45 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - UPDATE SYS_USER SET LOGIN_COUNT=?,LAST_LOGIN_DATE=?,LAST_LOGIN_IP=?  WHERE USER_ID=?
    | 1 |                   2 |           3 |                 4 |
    |---|---------------------|-------------|-------------------|
    | 1 | 2018-07-13 16:00:45 | 10.52.8.221 | E001B101321003001 |
  For example:> "UPDATE SYS_USER SET LOGIN_COUNT=1,LAST_LOGIN_DATE='2018-07-13 16:00:45',LAST_LOGIN_IP='10.52.8.221'  WHERE USER_ID='E001B101321003001'"
16:00:45 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - INSERT INTO SYS_USER_LOGIN_LOG(USER_ID,USER_NAME,LOGIN_INFO,LOGIN_DATE,LOGIN_TIME,LOGIN_IP) VALUES(?,?,?,?,?,?) 
    |                 1 |                2 |     3 |          4 |        5 |           6 |
    |-------------------|------------------|-------|------------|----------|-------------|
    | E001B101321003001 | 中国民生银行股份有限公司扬州分行 | 登录本系统 | 2018-07-13 | 16:00:45 | 10.52.8.221 |
  For example:> "INSERT INTO SYS_USER_LOGIN_LOG(USER_ID,USER_NAME,LOGIN_INFO,LOGIN_DATE,LOGIN_TIME,LOGIN_IP) VALUES('E001B101321003001','中国民生银行股份有限公司扬州分行','登录本系统','2018-07-13','16:00:45','10.52.8.221') "
16:00:45 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - select ROLE_ID FROM SYS_USER_ROLE WHERE USER_ID='E001B101321003001'
16:00:45 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - select JS_NAME FROM SYS_JSGL WHERE JS_ID IN (select ROLE_ID FROM SYS_USER_ROLE WHERE USER_ID='E001B101321003001')
16:00:45 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT Q_ID FROM SYS_JSGL_QXGL WHERE J_ID IN (SELECT ROLE_ID FROM SYS_USER_ROLE,SYS_JSGL WHERE J_ID=JS_ID and USER_ID ='E001B101321003001' and JS_STATUS='1')
16:00:45 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - select dep_id from sys_user_dep where user_id = 'E001B101321003001'
16:00:45 [DEBUG] org.nutz.dao.impl.sql.run.NutDaoExecutor - SELECT * FROM SYS_BMGL  WHERE bm_code=? AND count_flag=?
    |                 1 | 2 |
    |-------------------|---|
8 回复

网络不稳?

来自炫酷的 NutzCN

PING 一直都是稳定的,没有丢包发生。

换个连接池吧

换什么连接池好点呢

修改成这样吗

var ioc = {
	appConfig : {
		type : "org.nutz.ioc.impl.PropertiesProxy",
		fields : {
			paths : ["app.properties"]
		}
	},
	fileSqlManager : {
		type : 'org.nutz.dao.impl.FileSqlManager',
		args : ['config/nutz/sql']
	},
	dataSource : {
		type : "com.alibaba.druid.pool.DruidDataSource",
		events : {
			depose : 'close'
		},
		fields : {
			driverClassName : {
				java : "$appConfig.get('db-driver')"
			},
			url : {
				java : "$appConfig.get('db-url')"
			},
			username : {
				java : "$appConfig.get('db-username')"
			},
			password : {
				java : "$appConfig.get('db-password')"
			},
			initialSize     : {java :"10"},
		}
	},
	dao : {
		type : 'org.nutz.dao.impl.NutDao',
		args : [{
					refer : "dataSource"
				}, {
					refer : "fileSqlManager"
				}]
	},
	driver : {
		type : 'java.lang.String',
		args : [{java :"$appConfig.get('db-driver')"}] 
	}
};

先试后问

替换成功了,会不会再中断还要在客户现场测试下

添加回复
请先登陆
回到顶部