My Oracle Support Banner

Deadlock When Using The Implicit Connection Cache Timetolive or Abandon Timeout (Doc ID 402788.1)

Last updated on FEBRUARY 03, 2019

Applies to:

JDBC - Version to [Release 10.1 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 14-Aug-2012***


An application is retrieving connection from the 10g Oracle JDBC  implicit connection cache (ICC). The application  hang can happen when the  ICC abandon or  timetolive timeout are enabled;

A deadlock is occurring when at the same time:

To illustrate this situation, here are the Java Stack dump of those threads [ Thread-11 is the ICC internal JDBC thread and Thread 14 is the application thread. (closing the connection)] :

at oracle.jdbc.pool.OracleImplicitConnectionCache.reusePooledConnection(
- waiting to lock <0x10969fe0> (a oracle.jdbc.pool.OracleImplicitConnectionCache)
at oracle.jdbc.pool.OracleConnectionCacheEventListener.connectionClosed(
- locked <0x109ad220> (a oracle.jdbc.pool.OracleConnectionCacheEventListener)
at oracle.jdbc.pool.OraclePooledConnection.callImplicitCacheListener(
at oracle.jdbc.pool.OraclePooledConnection.logicalCloseForImplicitConnectionCache(
at oracle.jdbc.pool.OraclePooledConnection.logicalClose(
at oracle.jdbc.driver.LogicalConnection.closeInternal(
at oracle.jdbc.driver.LogicalConnection.close(
- locked <0x109ad240> (a oracle.jdbc.driver.LogicalConnection)  at test.TestPool$

at oracle.jdbc.driver.LogicalConnection.close(
- waiting to lock <0x109ad240> (a oracle.jdbc.driver.LogicalConnection)
at oracle.jdbc.pool.OracleImplicitConnectionCache.closeCheckedOutConnection(
at oracle.jdbc.pool.OracleImplicitConnectionCacheThread.runTimeToLiveTimeout(
- locked <0x10969fe0> (a oracle.jdbc.pool.OracleImplicitConnectionCache)
at )

Found 1 deadlock.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.