This discussion is archived
0 Replies Latest reply: Sep 14, 2013 5:52 AM by PuneetBansal RSS

Thread getting stuck while reading message from AQ

PuneetBansal Newbie
Currently Being Moderated

Hi,

 

Our java jobs dequeue messages from oracle aq. Lately threads have started hanging while trying to read messages from AQ. Stack trace of one such thread is:

 

java.net.SocketInputStream.socketRead0(Native Method)

java.net.SocketInputStream.read(SocketInputStream.java:129)

oracle.net.ns.Packet.receive(Unknown Source)

oracle.net.ns.DataPacket.receive(Unknown Source)

oracle.net.ns.NetInputStream.getNextPacket(Unknown Source)

oracle.net.ns.NetInputStream.read(Unknown Source)

oracle.net.ns.NetInputStream.read(Unknown Source)

oracle.net.ns.NetInputStream.read(Unknown Source)

oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1104)

oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1075)

oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:480)

oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:218)

oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:969)

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)

oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)

oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)

oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1625)

oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1371)

 

Can someone help us in understanding the issue here?

 

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points