Exceptions occurred while trying to close a PooledConnection's resources normally

最新推荐文章于 2024-05-13 22:32:30 发布
最新推荐文章于 2024-05-13 22:32:30 发布
阅读量4.2k 收藏 1
点赞数
分类专栏： 学习笔记 文章标签： ComboPooledDataSourc Connection timed out
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u013456765/article/details/41516445
版权
2014-11-26 01:28:26,346 INFO [Resource Destroyer in BasicResourcePool.close()] NewPooledConnection - [c3p0] Exceptions occurred while trying to close a PooledConnection's resources normally.
2014-11-26 01:28:26,355 INFO [Resource Destroyer in BasicResourcePool.close()] NewPooledConnection - [c3p0] NewPooledConnection close Exception.
java.sql.SQLException: Io exception: Connection timed out
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:480)
        at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1175)
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:549)
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
        at com.mchange.v2.resourcepool.BasicResourcePool.destroyResource(BasicResourcePool.java:989)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$100(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$5.run(BasicResourcePool.java:1174)
2014-11-26 01:28:26,369 WARN [Resource Destroyer in BasicResourcePool.close()] BasicResourcePool - Failed to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@59b0ddf6
java.sql.SQLException: Some resources failed to close properly while closing com.mchange.v2.c3p0.impl.NewPooledConnection@59b0ddf6
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:571)
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
        at com.mchange.v2.resourcepool.BasicResourcePool.destroyResource(BasicResourcePool.java:989)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$100(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$5.run(BasicResourcePool.java:1174)
2014-11-26 01:37:21,275 INFO [Resource Destroyer in BasicResourcePool.close()] NewPooledConnection - [c3p0] Exceptions occurred while trying to close a PooledConnection's resources normally.
2014-11-26 01:37:21,276 INFO [Resource Destroyer in BasicResourcePool.close()] NewPooledConnection - [c3p0] NewPooledConnection close Exception.
java.sql.SQLException: Io exception: Connection timed out
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
        at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:480)
        at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1175)
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:549)
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
        at com.mchange.v2.resourcepool.BasicResourcePool.destroyResource(BasicResourcePool.java:989)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$100(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$5.run(BasicResourcePool.java:1174)
2014-11-26 01:37:21,276 WARN [Resource Destroyer in BasicResourcePool.close()] BasicResourcePool - Failed to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@425ad662
java.sql.SQLException: Some resources failed to close properly while closing com.mchange.v2.c3p0.impl.NewPooledConnection@425ad662
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:571)
        at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:234)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:470)
        at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:964)
        at com.mchange.v2.resourcepool.BasicResourcePool.destroyResource(BasicResourcePool.java:989)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$100(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$5.run(BasicResourcePool.java:1174)


代码里是用com.mchange.v2.c3p0.ComboPooledDataSource（连接池 cpds）管理链接的，同时创建一个链接对象conn，程序是定时调度的，在一轮调度结束后，代码里先将conn关闭，然后在关闭cpds（调用cpds.close()）,代码执行到结束地址池后大概10分钟就报上诉错误，经分析，原因大概如下：
1.地址池对象一般是不会关闭的，直到线程消亡或者所在对象消亡才会关闭，代码里却在程序一轮执行结束就主动关闭
2.地址池线程有自动监听功能，一定时间会扫描连接池里处于不用的链接（线程池调用close()不会把链接池线程关掉？），这事就会发现连接池是关闭的，就报上面的错误
3.如果下次再次执行代码也会报错，因为连接池已经关闭，报错信息如下。
（以上纯属网上查找，大胆猜测，仅供参考）

2014-11-26 09:34:33,257 WARN [Thread-3346] DnsBigfileCollect - error : java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreadsAwaitingCheckoutDefaultUser] ] has been closed() -- you can no longer use it.
java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreadsAwaitingCheckoutDefaultUser] ] has been closed() -- you can no longer use it.
 at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.assertCpds(AbstractPoolBackedDataSource.java:447)
 at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(AbstractPoolBackedDataSource.java:459)
 at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
 at com.zznode.ngn.sa.psm.probe.ftp.hebei.DnsBigfileCollect.getConnection(DnsBigfileCollect.java:557)
 at com.zznode.ngn.sa.psm.probe.ftp.hebei.DnsBigfileCollect.batchHandIn(DnsBigfileCollect.java:517)
 at com.zznode.ngn.sa.psm.probe.ftp.hebei.DnsBigfileCollect.collectFiles(DnsBigfileCollect.java:473)
 at com.zznode.ngn.sa.psm.probe.ftp.hebei.DnsBigfileCollect.collectFileMap(DnsBigfileCollect.java:214)
 at com.zznode.ngn.sa.psm.probe.ftp.hebei.DnsBigfileCollect.execute(DnsBigfileCollect.java:176)
 at com.zznode.ngn.sa.psm.probe.ftp.hebei.DNSDomainPraseProbe$ExecuteDataPool.statiscAndHandIn(DNSDomainPraseProbe.java:444)
 at com.zznode.ngn.sa.psm.probe.ftp.hebei.DNSDomainPraseProbe$ExecuteDataPool.run(DNSDomainPraseProbe.java:407)
2014-11-26 09:34:33,258 DEBUG [Thread-3346] DNSDomainPraseProbe - has all success done !!! cost time : 273 s

向下生长的花
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
C3P0,alibaba连接池错误【已解决】-An exception occurred while acquiring a poolable resource. Will retry.
ZHTTTCZY的博客
10-28 979
C3P0 连接池出错 Spring MyBatis 整合时报错,报错信息如下： [com.mchange.v2.resourcepool.BasicResourcePool]-An exception occurred while acquiring a poolable resource. Will retry. java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.driver
Exceptions java 源码
10-13
Exceptions java 源码
Exception occurred while trying to invoke service method makeOrder
EricLiutyy's Area
06-16 1万+
<br />  “/AcesysWeb”应用程序中的服务器错误。 Exception occurred while trying to invoke service method makeOrder<br /> <br /> <br />说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。 <br /><br />异常详细信息: System.ServiceModel.FaultException: Exception occu
正确解决java.sql.SQLException异常的有效解决方法
最新发布
wbajsjhhhhh的博客
05-13 2960
正确解决java.sql.SQLException异常的有效解决方法
org.apache.axis2.AxisFault: Exception occurred while trying to invoke service method GetPassword
bokerr的博客
08-13 1万+
web新人一个，写在这里的是我犯过的错误，如果有老兄和我一样倒霉可以试试，我的这个方法。 说正题吧，我在使用Axis2发布我接口的三个方法时报错 1、首先在服务端直接编写了测试类调用接口的方法，结果是完全正确 2、然后我又在客户端写了一个测试类调用接口的方法，这次失败了，我通过这个错误报文找了很多博客都没能解决 客户端测试类报的错误(这似乎没啥用，不够详细) org.apache.a...
运行 openfire4.04 ServerStarter 报异常 AdminConsolePlugin:192 - An exception occurred while trying to mak
王人冉的博客
12-10 2567
AdminConsolePlugin:192 - An exception occurred while trying to make available the admin console via HTTPS
An exception occurred while acquiring a poolable resource. Will retry.
weixin_30399871的博客
05-28 1942
我的是mysql-connector-java-5.1.20.jar加到lib下面就行了。或者在pom中加入配置也行。 转载于:https://www.cnblogs.com/tietazhan/p/5537009.html
java 异常处理发生异常_Java中的异常处理
从零开始的教程世界
07-13 1377
java 异常处理发生异常Exception Handling in Java is a very interesting topic. Exception is an error event that can happen during the execution of a program and disrupts its normal flow. Java provides a robust ...
django-http-exceptions:django的HTTP例外
05-24
什么是django-http-exceptions ？ 对于您的django视图，这是很可笑的例外。 到底有什么好处呢？ 这使得 def some_function (): raise SomeError def view ( request ): try : response = some_function () ...
Cabother-Exceptions:自定义例外的参考书目
03-28
Cabother例外自定义例外的参考书目努吉特https://www.nuget.org/packages/Cabother.Exceptions/例外清单Nome da Exception Descrição Mensagem doUsuário ConfigurationNotFoundException Solicitado ...
marco-exceptions-core：基本程序包异常
01-29
"Marco-Exceptions-Core" 是一个专门用于处理程序异常的基础软件包，主要面向ASP.NET Core、ASP.NET以及C#开发者设计。这个库的核心目标是提供一套高效、易用且可扩展的异常处理机制，以增强应用的健壮性和用户体验...
VB.NET Developer's Guide(4574).pdf
08-15
Exercise 7.2 Adding a Menu to a Form at Design Time 323 Creating Dialog Boxes 1.Create a form. 2.Set the BorderStyle property of the form to FixedDialog. 3.Set the ControlBox, MinimizeBox, and ...
[JAVA]- Tomcat报错 内存泄漏This is very likely to create a memory leak. Stack trace of thread: java.ne
小白的日常记录
12-22 5076
我的项目用的是apache-tomcat-8.0.26-windows-i64 出现问题描述： 在服务器启动一段时间后就会报错 错误信息： appears to have started a thread named [Resource Destroyer in BasicResourcePool.close()] but has failed to stop it. This is v
C3P0异常：java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE 解决
Vi_error.nextval
04-10 8787
问题说明接手一个新项目的时候意外发现项目一直有一个c3p0的报错，完整信息是这样的：java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:566) at com.mc
C3P0连接池连接异常错误解决
热门推荐
lddongyu
07-01 2万+
转自：http://hi.baidu.com/zhenuu/blog/item/b91661385ca23d2a96ddd871.html
mac osx c3p0问题
chiduan54192的博客
05-03 381
一，现象 mac osx下出现以下错误 java.sql.SQLRecoverableException: 无法从套接字读取更多的数据 java.sql.SQLException:Some resources failed to close properly while closing ...
WARN com.mchange.v2.resourcepool.BasicResourcePool
laokaizzz的专栏
04-13 7597
[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] WARN  com.mchange.v2.resourcepool.BasicResourcePool  - Failed to destroy resource: com.mchange.v2.c3p0.impl.NewPooledConnection@11b608
selenium.common.exceptions.WebDriverException: Message: An unknown server-side error occurred while processing the command
12-08
`selenium.common.exceptions.WebDriverException: Message: An unknown server-side error occurred while processing the command`这个异常通常是由于浏览器驱动版本与浏览器版本不兼容或者浏览器驱动没有正确安装...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值