IDEA 配置 c3p0数据库连接池出错

最新推荐文章于 2026-03-09 00:29:14 发布

原创最新推荐文章于 2026-03-09 00:29:14 发布 · 1.5k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

JDBC

本文记录了在使用C3P0连接池时遇到的死锁问题及解决方案。通过调整数据库连接参数，特别是针对MySQL 8.x版本的配置，成功解决了连接池的死锁情况，确保了应用程序的稳定运行。

出错信息
八月 02, 2020 2:12:16 下午 com.mchange.v2.log.MLog
信息: MLog clients using java 1.4+ standard logging.
八月 02, 2020 2:12:17 下午 com.mchange.v2.c3p0.C3P0Registry banner
信息: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
八月 02, 2020 2:12:17 下午 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
信息: Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> helloc3p0, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgery9ab1c817kn111kgbk|7b1d7fff, idleConnectionTestPeriod -> 0, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3306/test?useSSL=false&
useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&rewriteBatchedStatements=true, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 50, maxStatementsPerConnection -> 2, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
八月 02, 2020 2:12:37 下午 com.mchange.v2.async.ThreadPoolAsynchronousRunner $D e a d l o c k D e t e c t o r r u n 警告 : c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ DeadlockDetector@6be5b0ca – APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
八月 02, 2020 2:12:37 下午 com.mchange.v2.async.ThreadPoolAsynchronousRunner $D e a d l o c k D e t e c t o r r u n 警告 : c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ DeadlockDetector@6be5b0ca – APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k @ 241 f 49 f d (c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ PoolThread-#1)
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k @ 623 a d e 54 (c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ PoolThread-#2)
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k @ 15 f 18 d a 6 (c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ PoolThread-#0)
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k @ 1 a 3 e 44 a 9 c o m . m c h a n g e . v 2 . r e s o u r c e p o o l . B a s i c R e s o u r c e P o o l$ AcquireTask@4430b6b2
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k @ 70 c c 081 e c o m . m c h a n g e . v 2 . r e s o u r c e p o o l . B a s i c R e s o u r c e P o o l$ AcquireTask@69c9271c
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k @ 13 a 2 d 80 c o m . m c h a n g e . v 2 . r e s o u r c e p o o l . B a s i c R e s o u r c e P o o l$ AcquireTask@407e8e33
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k @ 50 e 2 e 2 d a P o o l t h r e a d s t a c k t r a c e s : T h r e a d [c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ PoolThread-#1,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k . r u n (B a s i c R e s o u r c e P o o l . j a v a : 1805) c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner $KaTeX parse error: Expected 'EOF', got '#' at position 12: PoolThread-#̲2,5,main] jav\dots$ AcquireTask.run(BasicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner $P o o l T h r e a d . r u n (T h r e a d P o o l A s y n c h r o n o u s R u n n e r . j a v a : 547) T h r e a d [c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ PoolThread-#0,5,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool $A c q u i r e T a s k . r u n (B a s i c R e s o u r c e P o o l . j a v a : 1805) c o m . m c h a n g e . v 2 . a s y n c . T h r e a d P o o l A s y n c h r o n o u s R u n n e r$ PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

因为我的mysql是8.x,所以修改如下
改正信息：
在配置c3p0-config.xml 中修改：
jdbc:mysql://localhost:3306/test**?&
useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true**

成功如下：
八月 02, 2020 2:16:26 下午 com.mchange.v2.log.MLog
信息: MLog clients using java 1.4+ standard logging.
八月 02, 2020 2:16:26 下午 com.mchange.v2.c3p0.C3P0Registry banner
信息: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
八月 02, 2020 2:16:27 下午 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
信息: Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> helloc3p0, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgery9ab1c86kc7kt367a|7b1d7fff, idleConnectionTestPeriod -> 0, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3306/test?&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 50, maxStatementsPerConnection -> 2, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
com.mchange.v2.c3p0.impl.NewProxyConnection@6cd8737

标签

#jdbc #java