C3P0发生了死锁问题,更改了最大连接数还是没用

Question

Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePoolKaTeX parse error: Expected 'EOF', got '#' at position 139: …]-HelperThread-#̲1 com.mchange…ScatteredAcquireTask@376dbb3b
on thread: C3P0PooledConnectionPoolManager[identityToken->1hgery9a71kp96ca1jub2be|3aff1e0a]-HelperThread-#0
com.mchange.v2.resourcepool.BasicResourcePoolKaTeX parse error: Expected 'EOF', got '#' at position 139: …]-HelperThread-#̲2 Pending Task…ScatteredAcquireTask@73e3cccd
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@2c69b36f
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@54f379f7
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@78fdcb55
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@548bfb19
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@2cb44323
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@7c65efad
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@6457346a
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@2cb10f54
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@3d5a27a1
com.mchange.v2.resourcepool.BasicResourcePool$\mathrm{[e-mail]}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}\mathrm{}$ScatteredAcquireTask@321847a9
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4f4b5cf8
Pool thread stack traces:
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgery9a71kp96ca1jub2be|3aff1e0a]-HelperThread-#1,5,main]
java.lang.Math.min(Math.java:1336)
java.util.Arrays.copyOfRange(Arrays.java:3666)
java.lang.String.(String.java:207)
java.lang.String.substring(String.java:1969)
org.apache.catalina.webresources.AbstractArchiveResourceSet.getResource(AbstractArchiveResourceSet.java:234)
org.apache.catalina.webresources.StandardRoot.getResourceInternal(StandardRoot.java:281)
org.apache.catalina.webresources.Cache.getResource(Cache.java:62)
org.apache.catalina.webresources.StandardRoot.getResource(StandardRoot.java:216)
org.apache.catalina.webresources.StandardRoot.getClassLoaderResource(StandardRoot.java:225)
org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2285)
org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:859)
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1333)
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1185)
com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:398)
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgery9a71kp96ca1jub2be|3aff1e0a]-HelperThread-#0,5,main]
com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:398)
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Thread[C3P0PooledConnectionPoolManager[identityToken->1hgery9a71kp96ca1jub2be|3aff1e0a]-HelperThread-#2,5,main]
com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:398)
com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

C3p0配置

	<!-- c3p0连接池的私有属性 -->
	<!--连接池中保留的最小连接数。-->
    <property name="minPoolSize" value="5"/>
    <!--连接池中保留的最大连接数。Default: 15 -->
    <property name="maxPoolSize" value="500"/>
    <!--初始化时获取的连接数，取值应在minPoolSize与maxPoolSize之间。Default: 3 -->
    <property name="initialPoolSize" value="10"/>
    <!--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
    <property name="maxIdleTime" value="60"/>
    <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
    <property name="acquireIncrement" value="5"/>
    <!--JDBC的标准参数，用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements
   属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。
   如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0-->
    <property name="maxStatements" value="0"/>
    <!--每60秒检查所有连接池中的空闲连接。Default: 0 -->
    <property name="idleConnectionTestPeriod" value="60"/>
    <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
    <property name="acquireRetryAttempts" value="30"/>
    <!--获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效
   保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试
   获取连接失败后该数据源将申明已断开并永久关闭。Default: false-->
    <property name="breakAfterAcquireFailure" value="false"/>
    <!--因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的
  时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable
  等方法来提升连接测试的性能。Default: false -->
    <property name="testConnectionOnCheckout" value="false"/>
    <!--连接池用完时客户调用getConnection()后等待获取连接的时间，单位：毫秒。超时后会抛出-->

	<property name="checkoutTimeout" value="100"/>			
</bean>

Answer 1

翔仔 2020-01-22 18:24:00

同学好，com.mchange.v2.resourcepool.BasicResourcePoolKaTeX parse error，这个不是死锁呀，感觉是xml里面有语法错误导致解析报错？这个影响使用么，不影响可以忽略

• 提问者 慕慕1135193 #1

  找到原因了,断点打太多了导致debug模式下运行缓慢,把断点全清理了就正常运行了

Answer 2

提问者 慕慕1135193 2020-01-22 16:54:28

正常启动没事.用debug模式就会出现这样的信息