DEBUG -- CLOSE BY CLIENT STACK TRACE

最新推荐文章于 2019-07-11 13:53:05 发布
原创 最新推荐文章于 2019-07-11 13:53:05 发布 · 720 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#c3p0 #数据库连接池 #exception

在使用C3P0数据库连接池时遇到DEBUG -- CLOSE BY CLIENT STACK TRACE异常。通过调整日志级别可以避免，但会丢失其他DEBUG信息。尝试修改C3P0配置，特别是增大maxIdleTime值，如设置为3600秒，可解决异常。此设置表示最大空闲时间，超过时间未使用的连接会被丢弃，有助于减轻连接池负载。
部署运行你感兴趣的模型镜像

第一次写博文，完全是属于菜鸟级别，写的不好之处还望各路大神多多指教，小子感激不尽。

最经开发一个项目使用了C3P0数据库连接池，发现了有这样一个Exception：

java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:646)
at com.mchange.v2.c3p0.impl.NewPooledConnection.closeMaybeCheckedOut(NewPooledConnection.java:259)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.destroyResource(C3P0PooledConnectionPool.java:619)
at com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask.run(BasicResourcePool.java:1024)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)

网上查了很多资料，差不不多都是说这个错误错误不会影响C3PO的使用，最简单的方法时提高日志输出级别，我自己用的log4j，把日子输出级别从DEBUG提到INFO级别就可以了。这样是能够解决问题，但是在开发当中自己定义的那些logger.debug信息也一样无法显示了。

网上也有很多分析原因的文章和解决方法，如：http://hi.baidu.com/xhr8334/item/7e5a6f5326aa02d5d48bacca

但貌似都不适合我自己的这个项目。后来我尝试修改一些C3P0de配置常数，发现这个异常就消失了，

就是maxIdleTime的值设的稍微大一些，如：<property name="maxIdleTime" value="3600"></property>

这个是指最大空闲时间，60秒内未使用则连接被丢弃。若为0则永不丢弃。默认值为 0

同时为了减轻连接池的负载，比如连接池中连接数因为某次数据访问高峰导致创建了很多数据连接  
但是后面的时间段需要的数据库连接数很少，则此时连接池完全没有必要维护那么多的连接，所以有必要将  
断开丢弃掉一些连接来减轻负载，必须小于maxIdleTime。配置不为0，则会将连接池中的连接数量保持到minPoolSize。

还可以设置<property name="maxIdleTimeExcessConnections" value="1800"/>（该设置和上述异常无关，即不设置也不会抛出上述异常）

原理不是非常清楚，也不敢夸大其词。希望能对各位朋友有用。


您可能感兴趣的与本文相关的镜像

ACE-Step

ACE-Step

音乐合成
ACE-Step

ACE-Step是由中国团队阶跃星辰（StepFun）与ACE Studio联手打造的开源音乐生成模型。 它拥有3.5B参数量，支持快速高质量生成、强可控性和易于拓展的特点。 最厉害的是，它可以生成多种语言的歌曲，包括但不限于中文、英文、日文等19种语言

龙君夜
关注
client-go中watch机制的一些陷阱
-happy 的博客
01-08 1140
通过一个线上问题，引出 watch 机制的最佳实践
Gin 框架中集成 runtime/debug 打印日志堆栈信息
不积跬步，无以至千里；不积小流，无以成江海。
04-27 959
在 Gin 框架中，你可以使用 runtime/debug 包来打印调试信息，特别是在错误处理和日志记录方面。是 Go 标准库中一个用于调试和诊断的包，提供了多种功能来帮助开发者分析程序运行状态、排查问题以及优化性能。os.Stderr[]byterecoverpanicAllocTotalAllocSysNumGCMain.PathDeps通过合理使用，可以显著提升 Go 程序的调试效率和运行稳定性。
关于CLOSE BY CLIENT STACK TRACE
Amos318的专栏
02-25 1156
关于CLOSE BY CLIENT STACK TRACE   程序正常运行，数据库连接可以获取，一些列操作都可以实现，可在debug信息中总会一段时间就报如下错误：   java.lang.Exception : DEBUG -- CLOSE BY CLIENT STACK TRACE at com.mchange.v2.c3p0.impl.NewPooledConn
C3P0连接池jar包.zip
07-11
c3p0完整jar包-c3p0-0.9.5.2.jar 能解决DEBUG -- CLOSE BY CLIENT STACK TRACE问题
C3P0 java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
jackpk的专栏
04-08 5411
关于CLOSE BY CLIENT STACK TRACE url：http://blog.youkuaiyun.com/hallelujah_chen/article/details/6016132 由一个DEBUG说开去 url：http://hi.baidu.com/xhr8334/item/7e5a6f5326aa02d5d48bacca C3P0
java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
xwh1314的博客
07-11 1212
1、出现这个问题试了配置文件中删掉destroy-method="close"不管用 2、添加或者删除<property name="automaticTestTable"><value>c3p0_test</value></property>不管用 3、添加或者删除<property name="preferredTestQuery"&g...
EXCEPTION STACK TRACE: ** BEGIN NESTED EXCEPTION ** javax.net.ssl.SSLException MESSAGE: closing inbound before receiving peer's close_notify STACKTRACE:
最新发布
10-11
<think>We are given an exception stack trace from a Java application indicating an SSLException: "closing inbound before receiving peer's close_notify" This exception typically occurs when one side ...
> Task :app:compileDebugJavaWithJavac FAILED FAILURE: Build completed with 5 failures. 1: Task failed with an exception. ----------- * What went wrong: Execution failed for task ':app:mergeDebugJavaResource'. > Could not resolve all files for configuration ':app:debugRuntimeClasspath'. > Failed to transform httpclient-osgi-4.5.14.jar to match attributes {artifactType=android-java-res, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar > Failed to transform httpclient-win-4.5.14.jar to match attributes {artifactType=android-java-res, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar > Failed to transform httpcore-4.4.16.jar to match attributes {artifactType=android-java-res, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. > Get more help at https://help.gradle.org. ============================================================================== 2: Task failed with an exception. ----------- * What went wrong: Execution failed for task ':app:checkDebugDuplicateClasses'. > Could not resolve all files for configuration ':app:debugRuntimeClasspath'. > Failed to transform httpclient-osgi-4.5.14.jar to match attributes {artifactType=enumerated-runtime-classes, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar > Failed to transform httpclient-win-4.5.14.jar to match attributes {artifactType=enumerated-runtime-classes, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar > Failed to transform httpcore-4.4.16.jar to match attributes {artifactType=enumerated-runtime-classes, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. > Get more help at https://help.gradle.org. ============================================================================== 3: Task failed with an exception. ----------- * What went wrong: Execution failed for task ':app:desugarDebugFileDependencies'. > Could not resolve all files for configuration ':app:debugRuntimeClasspath'. > Failed to transform httpclient-osgi-4.5.14.jar to match attributes {artifactType=android-classes-jar, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar > Failed to transform httpclient-win-4.5.14.jar to match attributes {artifactType=android-classes-jar, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar > Failed to transform httpcore-4.4.16.jar to match attributes {artifactType=android-classes-jar, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. > Get more help at https://help.gradle.org. ============================================================================== 4: Task failed with an exception. ----------- * What went wrong: Execution failed for task ':app:mergeDebugNativeLibs'. > Could not resolve all files for configuration ':app:debugRuntimeClasspath'. > Failed to transform httpclient-osgi-4.5.14.jar to match attributes {artifactType=android-jni, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for ExtractJniTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar. > C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar > Failed to transform httpclient-win-4.5.14.jar to match attributes {artifactType=android-jni, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for ExtractJniTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar. > C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar > Failed to transform httpcore-4.4.16.jar to match attributes {artifactType=android-jni, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for ExtractJniTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar. > C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. > Get more help at https://help.gradle.org. ============================================================================== 5: Task failed with an exception. ----------- * What went wrong: Execution failed for task ':app:compileDebugJavaWithJavac'. > Could not resolve all files for configuration ':app:debugCompileClasspath'. > Failed to transform httpclient-osgi-4.5.14.jar to match attributes {artifactType=android-classes-jar, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-osgi-4.5.14.jar > Failed to transform httpclient-win-4.5.14.jar to match attributes {artifactType=android-classes-jar, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpclient-win-4.5.14.jar > Failed to transform httpcore-4.4.16.jar to match attributes {artifactType=android-classes-jar, org.gradle.libraryelements=jar, org.gradle.usage=java-runtime}. > Execution failed for IdentityTransform: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar. > File/directory does not exist: C:\android\Notesmaster\httpcomponents-client-4.5.14-bin\lib\httpcore-4.4.16.jar * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. > Get more help at https://help.gradle.org. ============================================================================== BUILD FAILED in 2m 7s 26 actionable tasks: 26 executed
05-26
### Gradle 构建失败的原因分析 Gradle 构建失败通常是由于依赖管理出现问题引起的。... #### 1.... 如果在 `build.gradle` 文件... ctx.writeAndFlush(response).addListener(ChannelFutureListener.CLOSE); } } ``` ---
c3p0之DEBUG -- CLOSE BY CLIENT STACK TRACE
weixin_33785972的博客
01-30 269
2019独角兽企业重金招聘Python工程师标准>>> ...
由一个DEBUG信息说开去
Code On Earth
01-03 1473
c3p0 DEBUG -- CLOSE BY CLIENT STACK TRACE
harbey的专栏
11-06 240
Indeed, there is nothing to worry about. Just odd log statements sprinkled throughout the C3P0 codebase. Raise the loglevel to INFO and these statemens will not appear anymore. CLOSE BY CLIENT S...
ORACLE CLOSE BY CLIENT STACK TRACE
longload
07-31 249
ORACLE  CLOSE BY CLIENT STACK TRACE   部署一个项目启动的时候debug打印出好多错误 其中，CLOSE BY CLIENT STACK TRACE  是第一错误 使用的是Myeclipse 8.5 框 架： hibernate 3.0  ，spring 3.0  ，maven2 等 web服务器 ：resin3.1.10 错误信息如下所示： ...
奇怪的异常：DEBUG -- CLOSE BY CLIENT STACK TRACE
苳眠の菜鸟
10-08 1035
        last modified：2013-10-08 16:34:22       **********************************************       今天将测试服务器上测试通过的系统发布到线上，刚开始是出现一个mysql数据连接超时的错误，后来修改一下连接池的配置文件问题解决了，但是重新启动服务器确又报了一个新的错误： 2013-10...
c3p0 java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE
05-28 174
修改日志级别为info [url]http://hi.baidu.com/xhr8334/blog/item/cf15d1a6deb235fc9052ee9b.html[/url]
关于Debug报的java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE错
weixin_41260512的博客
12-26 1095
DEBUG 包c3p0错误项目使用C3P0数据库连接池，最近发现一个Exception： java.lang.Exception: DEBUG -- CLOSE BY CLIENT STACK TRACE at com.mchange.v2.c3p0.impl.NewPooledConnection.close(NewPooledConnection.java:566) at com.mchange
DEBUG -- CLOSE BY CLIENT STACK TRACE问题的两种解决方案，整理自网络
weixin_30835649的博客
09-04 680
1.DEBUG -- CLOSE BY CLIENT STACK TRACE 最近用c3p0遇到各种奇怪的问题，也不知道是它不行还是我不行。 今天又遇到了一个“DEBUG -- CLOSE BY CLIENT STACK TRACE”这个错误。 在网上找了找，大家都是抄的一篇文章，也不知道问题解决没解决，反正很多人都抄了这篇文章： http://hi.baidu.com/...
CLOSE BY CLIENT STACK TRACE
Rocy
06-12 207
ORACLE  CLOSE BY CLIENT STACK TRACE   部署一个项目启动的时候debug打印出好多错误 其中，CLOSE BY CLIENT STACK TRACE  是第一错误 使用的是Myeclipse 8.5 框 架： hibernate 3.0  ，spring 3.0  ，maven2 等 web服务器 ：resin3.1.10 错误信息如下所示： ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值