Hogging Threads JDBC (Doc ID 3014957.1)

Last updated on APRIL 12, 2024

Applies to:

Symptoms

.

There are hogging threads in the SOA domain that end up with the SQLTimeoutException:

Internal Exception: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
 
Error Code: 1013
Call: INSERT INTO DLV_MESSAGE (MESSAGE_GUID, CIKEY, CLUSTER_NODE_ID, CLUSTER_NODE_KEY, COMPONENT_NAME, COMPONENT_TYPE, COM
POSITE_LABEL, COMPOSITE_NAME, COMPOSITE_REVISION, CONV_ID, DOMAIN_NAME, ECID, EVENT_NAME, EXT_INT1, EXT_STRING1, EXT_STRIN
G2, HEADER_PROPERTIES_BIN_FORMAT, HEADERS_REF_ID, MASTER_CONV_ID, OPERATION_NAME, PARTNER_LINK, PRIORITY, PROPERTIES, RECE
IVE_DATE, RECOVER_COUNT, STATE, TENANT_ID, DLV_TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?, ?)
  bind => [28 parameters bound]
Query: InsertObjectQuery(com.collaxa.cube.persistence.dto.InvokeMessage@1236c92c)],numRepliesOwedMe=0,numRepliesOwedOthers
=0,seconds since begin=159,seconds left=39,useSecure=false,XAServerResourceInfo[SOADataSource-<SOADATASOURCE>]
=(ServerResourceInfo[SOADataSource--<SOADATASOURCE>]=(state=rolledback,assigned=<server>),

The following exception shows on the logs:

java.lang.Exception
at weblogic.jdbc.common.internal.ConnectionEnv.setup(ConnectionEnv.java:367)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:379)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:471)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:368)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:353)
at weblogic.jdbc.common.internal.MultiPool.searchLoadBalance(MultiPool.java:411)
at weblogic.jdbc.common.internal.MultiPool.findPool(MultiPool.java:224)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:120)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:77)
at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1841)

Cause

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