0 Replies Latest reply: Sep 14, 2013 7:52 AM by PuneetBansal RSS

    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