使用druid连接池连接OB数据库，应用报错连接异常

不想用随机的名字 · 2021 年7 月 13 日 10:17

【产品名称】

druid+ob

【产品版本】

druid 1.1.14

ob 1.4

【问题描述】

日终跑批时程序中定义了一个长连接，在整个日终期间都会用到这个连接，如果这个连接在等待某一个任务执行完成，再下一次处理时，程序会报如下异常

1703×283 175 KB

以下是ob关于timeout变量的配置

以下图片是关于druid的配置

不想用随机的名字 · 2021 年7 月 13 日 10:27

最新的druid配置removeabandoned已经修改成了true，removeabandonedtimeout修改成了7200，然后interactive_timeout变量也配置成了与wait_timeout一样的值

longda · 2021 年7 月 13 日 11:17

稍等一下, 我找个客户端的同学, 帮忙看一下

为了西凉 · 2021 年7 月 13 日 13:58

这个完整的报错堆栈可以贴一下

不想用随机的名字 · 2021 年7 月 13 日 14:03

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1,246,875 milliseconds ago. The last packet sent successfully to the server was 1,246,875 milliseconds ago.

at sun.reflect.GeneratedConstructorAccessor126.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3751)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2512)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)

at com.alibaba.druid.filter.FilterChainImpl.statement_executeQuery(FilterChainImpl.java:2473)

at com.alibaba.druid.filter.FilterAdapter.statement_executeQuery(FilterAdapter.java:2503)

at com.alibaba.druid.filter.FilterEventAdapter.statement_executeQuery(FilterEventAdapter.java:302)

at com.alibaba.druid.filter.FilterChainImpl.statement_executeQuery(FilterChainImpl.java:2470)

at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeQuery(StatementProxyImpl.java:227)

at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:217)

at com.yuchengtech.ycloans.cmis2ycloans.buzs.DateStepAction.findJobErrorByBuzDt(DateStepAction.java:173)

at com.yuchengtech.ycloans.cmis2ycloans.buzs.DateStepAction.doExecute(DateStepAction.java:95)

at com.yuchengtech.ycloans.cmis2ycloans.buzs.Ser1BuzAbstrat.execute(Ser1BuzAbstrat.java:166)

at com.yuchengtech.ycloans.cmis2ycloans.actions.ServAction.execute(ServAction.java:90)

at com.ecc.emp.flow.EMPFlow.execute(EMPFlow.java:196)

at com.ecc.emp.flow.Operation.execute(Operation.java:91)

at com.ecc.emp.flow.EMPBusinessLogic.execute(EMPBusinessLogic.java:89)

at com.ecc.emp.access.http.EMPHTTPRequestService.handleRequest(EMPHTTPRequestService.java:314)

at com.ecc.emp.access.http.EMPHttpAccessServlet.service(EMPHttpAccessServlet.java:189)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:528)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:609)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1506)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.net.SocketException: Connection reset

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115)2021-07-11 22:25:46 ERROR [DruidDataSource ] discard connection

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

不想用随机的名字 · 2021 年7 月 13 日 14:03