WebLogic Stuck Threads after Clustered SQL Server Failover (Doc ID 1413706.1)

Last updated on APRIL 22, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

When a clustered SQL Server fails over from Active to Passive Mode, a SOA Composite which connects to that SQL Server is hanging.

The following Java stack trace is reported for "STUCK" threads in the WebLogic logfile :

<Feb 6, 2012 5:26:36 AM GMT> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: '38' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "612" seconds working on the request "weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl@28caa475", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
Thread-471 "[STUCK] ExecuteThread: '38' for queue: 'weblogic.kernel.Default (self-tuning)'" <alive, in native, suspended, priority=1, DAEMON> {
jrockit.net.SocketNativeIO.readBytesPinned(SocketNativeIO.java:???)
jrockit.net.SocketNativeIO.socketRead(SocketNativeIO.java:24)
java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)
java.net.SocketInputStream.read(SocketInputStream.java:107)
weblogic.jdbc.sqlserver.dda.w(Unknown Source)
weblogic.jdbc.sqlserver.dda.o(Unknown Source)
weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
weblogic.jdbc.sqlserver.tds.ddo.e(Unknown Source)
weblogic.jdbc.sqlserver.tds.ddn.a(Unknown Source)
weblogic.jdbc.sqlserver.ddj.h(Unknown Source)
weblogic.jdbc.sqlserverbase.ddde.v(Unknown Source)
weblogic.jdbc.sqlserverbase.ddde.r(Unknown Source)
weblogic.jdbc.sqlserverbase.ddb9.execute(Unknown Source)
^-- Holding lock: weblogic.jdbc.sqlserverbase.ddah@23c2a1fe[thin lock]
weblogic.jdbc.common.internal.ConnectionEnv.testInternal(ConnectionEnv.java:817)
weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:794)
weblogic.jdbc.common.internal.ConnectionEnv.test(ConnectionEnv.java:541)
weblogic.common.resourcepool.ResourcePoolImpl.testResource(ResourcePoolImpl.java:2191)
weblogic.common.resourcepool.ResourcePoolImpl.checkResource(ResourcePoolImpl.java:1668)
weblogic.common.resourcepool.ResourcePoolImpl.checkAndReturnResource(ResourcePoolImpl.java:1584)
weblogic.common.resourcepool.ResourcePoolImpl.checkAndReturnResource(ResourcePoolImpl.java:1577)
weblogic.common.resourcepool.ResourcePoolImpl.testUnusedResources(ResourcePoolImpl.java:1993)
weblogic.common.resourcepool.ResourcePoolImpl.access$1800(ResourcePoolImpl.java:41)
weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.timerExpired(ResourcePoolImpl.java:2658)
weblogic.timers.internal.TimerImpl.run(TimerImpl.java:253)
weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
weblogic.work.ExecuteThread.run(ExecuteThread.java:168)
}

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms