关于WAS连接数据库超时的问题 求大神

2014-09-12 04:44:51 1.1k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›
DF350 DF350 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网 我也要 + 加入社区
数据库连接超时问题（求解） 问题出现的背景： APP 阅读详情
CST] 00000030 SystemOut O select HTIP.STORAGER_STATUS.DATA_TAG ,HTIP.STORAGER_STATUS.RECEIVE_TIME,HTIP.STORAGER_STATUS.STATUS ,HTIP.STORAGER_STATUS.SERVICE_RECEIVE from HTIP.STORAGER_STATUS, HTIP.DATA_STORAGER where HTIP.STORAGER_STATUS.STATUS = '01' and HTIP.STORAGER_STATUS.STATUS_TIME < '2014-09-11 16:47:23:580'AND HTIP.STORAGER_STATUS.STATUS_TIME > '2014-09-11 11:57:23:580' and HTIP.STORAGER_STATUS.DATA_TAG = HTIP.DATA_STORAGER.DATA_TAG
[14-9-11 16:57:23:799 CST] 0000002e SystemOut O 2014-09-11 16:57:23.799 43db43db I: 取值~~~~~~~~~~~~~~~~~~~~11
[14-9-11 16:57:23:799 CST] 0000002e SystemOut O 2014-09-11 16:57:23.799 43db43db I: [DBOperator(22862286)]Connection opened in 0.170304 ms
[14-9-11 16:57:23:799 CST] 0000002e SystemOut O 2014-09-11 16:57:23.799 43db43db I: conn:com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@22862286
[14-9-11 16:57:23:799 CST] 0000002e SystemOut O 2014-09-11 16:57:23.799 43db43db I: making a connection...[349]
[14-9-11 16:57:41:988 CST] 0000002d ConnectionEve W J2CA0206W: 发生连接错误。为了帮助确定问题，请对连接工厂或数据源启用“诊断连接使用情况”选项。
[14-9-11 16:57:41:988 CST] 0000002d ConnectionEve A J2CA0056I: 连接管理器从资源 HTIPpool 的资源适配器接收到致命连接错误。异常：java.sql.SQLRecoverableException: Io 异常: Socket read timed out
[14-9-11 16:57:41:988 CST] 0000002d WSRdbManagedC W DSRA0180W: 在 ManagedConnection.destroy() 期间检测到异常。异常：com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: 关闭的连接. with SQL State : 99999 SQL Code : 17008
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3369)
at oracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:135)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4546)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3721)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1852)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:738)
at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:495)
at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1843)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2380)
at com.ibm.ejs.j2c.MCWrapper.connectionErrorOccurred(MCWrapper.java:2520)
at com.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:503)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:2432)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1902)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1954)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2209)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1006)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:943)
at com.haitaiinc.change.service.dao.StoragerStatusDAO.getAlreadySendData(StoragerStatusDAO.java:391)
at com.haitaiinc.change.service.send.SendExceptionAction.getAlreadySendData(SendExceptionAction.java:92)
at com.haitaiinc.change.service.thread.AlreadySendThread.alreadySend(AlreadySendThread.java:44)
at com.haitaiinc.change.service.thread.AlreadySendThread.run(AlreadySendThread.java:21)
Caused by: java.sql.SQLException: 关闭的连接DSRA0010E: SQL 状态：99999，错误码：17,008。
... 26 more

[14-9-11 16:57:42:519 CST] 00000030 ConnectionEve W J2CA0206W: 发生连接错误。为了帮助确定问题，请对连接工厂或数据源启用“诊断连接使用情况”选项。
[14-9-11 16:57:42:519 CST] 00000030 ConnectionEve A J2CA0056I: 连接管理器从资源 HTIPpool 的资源适配器接收到致命连接错误。异常：java.sql.SQLRecoverableException: Io 异常: Socket read timed out
[14-9-11 16:57:42:519 CST] 00000030 WSRdbManagedC W DSRA0180W: 在 ManagedConnection.destroy() 期间检测到异常。异常：com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: 关闭的连接. with SQL State : 99999 SQL Code : 17008
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3369)
at oracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:135)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4546)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3721)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1852)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:738)
at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:495)
at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1843)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2380)
at com.ibm.ejs.j2c.MCWrapper.connectionErrorOccurred(MCWrapper.java:2520)
at com.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:503)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:2432)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1902)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1954)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2209)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1006)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:943)
at com.haitaiinc.change.service.dao.StoragerStatusDAO.getWaitData(StoragerStatusDAO.java:305)
at com.haitaiinc.change.service.send.SendExceptionAction.getWaitData(SendExceptionAction.java:71)
at com.haitaiinc.change.service.thread.WaitSendThread.waitSend(WaitSendThread.java:44)
at com.haitaiinc.change.service.thread.WaitSendThread.run(WaitSendThread.java:21)
Caused by: java.sql.SQLException: 关闭的连接DSRA0010E: SQL 状态：99999，错误码：17,008。
... 26 more

[14-9-11 16:57:42:737 CST] 0000002e ConnectionEve W J2CA0206W: 发生连接错误。为了帮助确定问题，请对连接工厂或数据源启用“诊断连接使用情况”选项。
[14-9-11 16:57:42:737 CST] 0000002e ConnectionEve A J2CA0056I: 连接管理器从资源 HTIPpool 的资源适配器接收到致命连接错误。异常：java.sql.SQLRecoverableException: Io 异常: Socket read timed out
[14-9-11 16:57:42:737 CST] 0000002e WSRdbManagedC W DSRA0180W: 在 ManagedConnection.destroy() 期间检测到异常。异常：com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: 关闭的连接. with SQL State : 99999 SQL Code : 17008
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3369)
at oracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:135)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4546)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy(WSRdbManagedConnectionImpl.java:3721)
at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:1852)
at com.ibm.ejs.j2c.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:738)
at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:495)
at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1843)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2380)
at com.ibm.ejs.j2c.MCWrapper.connectionErrorOccurred(MCWrapper.java:2520)
at com.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:503)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:2432)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1902)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1954)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2209)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1006)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:943)
at com.haitaiinc.change.service.dao.StoragerStatusDAO.getFailData(StoragerStatusDAO.java:519)
at com.haitaiinc.change.service.send.SendExceptionAction.getFailData(SendExceptionAction.java:131)
at com.haitaiinc.change.service.thread.FailSendThread.failSend(FailSendThread.java:45)
at com.haitaiinc.change.service.thread.FailSendThread.run(FailSendThread.java:21)
Caused by: java.sql.SQLException: 关闭的连接DSRA0010E: SQL 状态：99999，错误码：17,008。
... 26 more
...全文
数据库连接超时问题根治：连接池存活检测、心跳机制配置及超时参数校准的实操方案 摘要：数据库连接超时是业务系统常见隐患，表现为间歇性失败、连接中断等问题。本文系统分析其根源，包括连接池管理不当、网络波动、数据库配置不合理等，并提出三方面解决方案：1）连接池存活检测机制，通过轻量级查询识别无效连接；2）心跳机制配置，维持连接活性对抗中间件超时；3）超时参数协同优化，确保数据库、连接池和业务层的超时设置匹配。强调需建立全链路监控体系，通过&quot;预防+监控&quot;的闭环管理持续保障连接稳定性，为业务系统提供可靠数据支撑。（149字） 阅读详情

相关推荐

解决MySQL 5数据库连接超时问题

mysql5将其连接的等待时间(wait_timeout)缺省为8小时。怎么不让它超时呢

qq37607941

Sql Server数据库超时问题的解决方法

本文介绍了Sql Server数据库超时问题的解决方法。

weixin_38532849

WAS数据库连接配置文档

word文档类--WAS数据库连接配置文档

hhcrab

在数据库‘master’中拒绝CREATE DATABASE权限问题的解决方法

今天使用Linq To SQL，要求判断数据库是否存在，不存在是自动创建数据库。

weixin_38609571

Sql Server 数据库超时问题的解决方法

Sql server 2000 的等待响应时间

zcw_5858
评论 2
收藏 已收藏
分享
返回顶部
DF350
DF350
Java 51,407 成员 86,129 内容
+ 加入社区