#86 C3P0 deadlock causing application to hang

open
nobody
None
5
2014-07-24
2010-08-31
Santosh Rao
No

When application running under extreme loads we observed a deadlock in two application threads where in one is trying to check-in after use and other is trying to open a connection. The java stack was taken using the kill -QUIT command on Solaris environment shows a deadlock between BasicResourcePool and ThreadPoolAsynchronousRunner objects. Tried looking at the code and also stack does not show where the lock to the runner object is held.
We are using C3P0 version 0.9.1.2. and below are the c3p0 properties through hibernate

hibernate.connection.driver_class oracle.jdbc.OracleDriver
hibernate.c3p0.max_size 1000
hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
hibernate.c3p0.min_size 10

Properies in c3p0
c3p0.maxIdleTimeExcessConnections=120
c3p0.acquireRetryDelay=10000
c3p0.autoCommitOnClose=true

Discussion

  • Santosh Rao
    Santosh Rao
    2010-08-31

    Stack Trace with deatails on deadlock

     
    Attachments
  • This issue is still open. Can any one please help in this regard. I'm also facing the same issue with C3P0 version 0.9.1.2.

    Thanks

     
  • ipauldev
    ipauldev
    2011-09-06

    Also requesting any updates. Having the same issue.

     
  • Jason Thorpe
    Jason Thorpe
    2011-09-06

    We too are having this issue - any updates?

     
  • Krishna
    Krishna
    2014-07-24

    We are having this issue and due to this the CPU get hung 100%. Any help on this issue.
    Appreciate well in advance.
    Thank you,