2 Replies Latest reply: May 29, 2013 9:35 AM by Joe Weinstein-Oracle RSS

    Application hang up ..

    1011546

      Hi ,
      I am getting this error frequently in my application.
      I am using Websphere7.5 appserver.Here is the stacktrace when I am saving the data.Pls help me out.

      JDBC driver version : 10.2.0.3.0


      5/29/13 3:25:12:577 EDT] 00000003 ThreadMonitor W WSVR0605W: Thread "WebContainer : 3" (00000026) has been active for 660984 milliseconds and may be hung. There is/are 2 thread(s) in total in the server that may be hung.
      at java.net.SocketInputStream.socketRead0(Native Method)
      at java.net.SocketInputStream.read(SocketInputStream.java:140)
      at oracle.net.ns.Packet.receive(Unknown Source)
      at oracle.net.ns.DataPacket.receive(Unknown Source)
      at oracle.net.ns.NetInputStream.getNextPacket(Unknown Source)
      at oracle.net.ns.NetInputStream.read(Unknown Source)
      at oracle.net.ns.NetInputStream.read(Unknown Source)
      at oracle.net.ns.NetInputStream.read(Unknown Source)
      at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1104)
      at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1075)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:480)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
      at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
      at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623)
      at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteUpdate(WSJdbcStatement.java:1622)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
      at java.lang.reflect.Method.invoke(Method.java:599)
      at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
      at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
      at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
      at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
      at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
      at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
      at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
      at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
      at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
      at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
      at com.ibx.aiw.web.servlet.AiwActionServlet.process(AiwActionServlet.java:52)
      at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1443)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:790)
      at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443)
      at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
      at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
      at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859)
      at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557)
      at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
      at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
      at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
      at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
      at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
      at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
      at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
      at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
      at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766)
      at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
      at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate(WSJdbcStatement.java:970)
      at com.ibx.ace.helper.BeanToDBFiller.update(BeanToDBFiller.java:679)


      Thanks,
      Anand

        • 1. Re: Application hang up ..
          gimbal2
          Did you look at the stacktrace at all? Notice where it is 'hanging'? At the connection to the database. So what could be the problem there do you think?
          • 2. Re: Application hang up ..
            Joe Weinstein-Oracle
            That warning message from WS is just saying that this thread has been running
            a long time without returning control to the app-server. WS can't know whether
            the thread is hung, or is running fine in a long loop. You'd need to take a series
            of thread dumps and/or see what the DBMS thinks is going on with that session
            to maybe see the difference.
            The JDBC call is an update, so the thread may be blocked waiting at the DBMS
            for the data it wants to update to be released by some other session/transaction
            that got it first.