-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 1 post ] 
  Previous topic | Next topic 
Author Message
XQing.Hu
 Post subject: c3p0 APPARENT DEADLOCK
PostPosted: Thu Nov 26, 2009 11:14 pm 
Newbie

Joined: Thu Nov 26, 2009 10:49 pm
Posts: 1
Heroes:
help!

Versions:
Hibernate 3.2.4.sp1
c3p0 0.9.1.2
Oracle9i 9.2.0.1.0
ojdbc14.jar 10.2.0.3.0

Code:
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 -> 1hge13w85d67p0e1lf6kx0|1d9d55b,
    debugUnreturnedConnectionStackTraces -> false,
    description -> null,
    driverClass -> oracle.jdbc.driver.OracleDriver,
    factoryClassLocation -> null,
    forceIgnoreUnresolvedTransactions -> false,
    identityToken -> 1hge13w85d67p0e1lf6kx0|1d9d55b,
    idleConnectionTestPeriod -> 60,
    initialPoolSize -> 5,
    jdbcUrl -> jdbc:oracle:thin:@***.***.***.***:1521:****,
    maxAdministrativeTaskTime -> 0,
    maxConnectionAge -> 0,
    maxIdleTime -> 60,
    maxIdleTimeExcessConnections -> 0,
    maxPoolSize -> 30,
    maxStatements -> 0,
    maxStatementsPerConnection -> 0,
    minPoolSize -> 5,
    numHelperThreads -> 3,
    numThreadsAwaitingCheckoutDefaultUser -> 0,
    preferredTestQuery -> null,
    properties -> {user=******, password=******},
    propertyCycle -> 0,
    testConnectionOnCheckin -> false,
    testConnectionOnCheckout -> false,
    unreturnedConnectionTimeout -> 0,
    usesTraditionalReflectiveProxies -> false
]

Code:
2009-11-26 08:53:11-[WARN]-[com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector.run(ThreadPoolAsynchronousRunner.java:608)] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@47e53a -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
2009-11-26 08:53:12-[WARN]-[com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector.run(ThreadPoolAsynchronousRunner.java:624)] com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@47e53a -- APPARENT DEADLOCK!!! Complete Status:
   Managed Threads: 3
   Active Threads: 3
   Active Tasks:
      com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@572090 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
      com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1b0caf (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
      com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1ddeda2 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
   Pending Tasks:
      com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@11c4041
      com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1be9d36
      com.mchange.v2.resourcepool.BasicResourcePool$1DestroyResourceTask@143472c
      com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1f5acd0
Pool thread stack traces:
   Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
      java.net.PlainSocketImpl.socketConnect(Native Method)
      java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
      java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
      java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
      java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
      java.net.Socket.connect(Socket.java:507)
      java.net.Socket.connect(Socket.java:457)
      java.net.Socket.<init>(Socket.java:365)
      java.net.Socket.<init>(Socket.java:178)
      oracle.net.nt.TcpNTAdapter.connect(Unknown Source)
      oracle.net.nt.ConnOption.connect(Unknown Source)
      oracle.net.nt.ConnStrategy.execute(Unknown Source)
      oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)
      oracle.net.ns.NSProtocol.establishConnection(Unknown Source)
      oracle.net.ns.NSProtocol.connect(Unknown Source)
      oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:856)
      oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)
      oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
      oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
      oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
      oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
      com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
      com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
      com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
      com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
      com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
      com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
      com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
      com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
   Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
      java.net.PlainSocketImpl.socketConnect(Native Method)
      java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
      java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
      java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
      java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
      java.net.Socket.connect(Socket.java:507)
      java.net.Socket.connect(Socket.java:457)
      java.net.Socket.<init>(Socket.java:365)
      java.net.Socket.<init>(Socket.java:178)
      oracle.net.nt.TcpNTAdapter.connect(Unknown Source)
      oracle.net.nt.ConnOption.connect(Unknown Source)
      oracle.net.nt.ConnStrategy.execute(Unknown Source)
      oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)
      oracle.net.ns.NSProtocol.establishConnection(Unknown Source)
      oracle.net.ns.NSProtocol.connect(Unknown Source)
      oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:856)
      oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)
      oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
      oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
      oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
      oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
      com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
      com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
      com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
      com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
      com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
      com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
      com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
      com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
   Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
      java.net.PlainSocketImpl.socketConnect(Native Method)
      java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
      java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
      java.net.PlainSocketIm2009-11-27 08:28:52-[WARN]-[org.hibernate.util.JDBCExceptionReporter.logExceptions(JDBCExceptionReporter.java:77)] SQL Error: 904, SQLState: 42000


Same problem
https://forum.hibernate.org/viewtopic.php?t=947246&amp%3bhighlight=apparent+deadlock+c3p0
http://forum.hibernate.org/viewtopic.php?t=941477
http://forum.hibernate.org/viewtopic.php?t=943141
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 1 post ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.