0 Replies Latest reply on Sep 14, 2013 12:52 PM by PuneetBansal

    Thread getting stuck while reading message from AQ

    PuneetBansal

      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