JDBC Connection Hang (Doc ID 1140473.1)

Last updated on JUNE 08, 2017

Applies to:

JDBC - Version 11.1.0.6 and later
Oracle WebLogic Server - Version 10.3 and later
Oracle Net Services - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 02-Feb-2016***


Goal

You see JDBC client is waiting for Database return result, but you can't see any session from Database in the V$Session view.

Thread-43 "[STUCK] ExecuteThread: '3' 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:31)
java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)
java.net.SocketInputStream.read(SocketInputStream.java:107)
oracle.net.ns.Packet.receive(Packet.java:220)
oracle.net.ns.DataPacket.receive(DataPacket.java:92)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:164)
oracle.net.ns.NetInputStream.read(NetInputStream.java:109)
oracle.net.ns.NetInputStream.read(NetInputStream.java:92)
oracle.net.ns.NetInputStream.read(NetInputStream.java:77)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1017)
oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:999)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:555)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:56)
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:932)
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:815)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1147)
 
How to avoid that thread wait forever?

Solution

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