This discussion is archived
1 Reply Latest reply: Jan 3, 2013 4:03 PM by 792849 RSS

Stuck Thread Problem in Weblogic & DB2

982774 Newbie
Currently Being Moderated
Hi ,

Please help us in analysing the below Stuck Thread Dump.In our webapplication we are using Java and DB2.
When we are trying to submit a request we are getting the below error:

Accept: image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/xaml+xml, application/x-ms-xbap, application/x-ms-application, application/vnd.ms-xpsdocument, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
Accept-Language: en-us
User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET4.0C; .NET4.0E; MS-RTC LM 8; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2)
Content-Type: application/x-www-form-urlencoded
Accept-Encoding: gzip, deflate
Content-Length: 1027
Connection: Keep-Alive
Cache-Control: no-cache
Cookie: JSESSIONID=gxdbQkJKc1nyynt3fys9mkNHtSxHvTC68kSQjQ0yQQ0VG0QQVTQq!2045462985

]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
Thread-98 "

[STUCK] ExecuteThread: '8' 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:24)
java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)
java.net.SocketInputStream.read(SocketInputStream.java:107)
com.ibm.db2.jcc.t4.z.b(z.java:161)
com.ibm.db2.jcc.t4.z.c(z.java:253)
com.ibm.db2.jcc.t4.z.c(z.java:370)
com.ibm.db2.jcc.t4.z.v(z.java:1147)
com.ibm.db2.jcc.t4.cb.e(cb.java:96)
com.ibm.db2.jcc.t4.q.e(q.java:81)
com.ibm.db2.jcc.t4.rb.k(rb.java:160)
com.ibm.db2.jcc.am.gn.jb(gn.java:2188)
com.ibm.db2.jcc.am.hn.b(hn.java:3499)
com.ibm.db2.jcc.am.in.gc(in.java:111)
com.ibm.db2.jcc.am.in.execute(in.java:92)
^-- Holding lock: com.ibm.db2.jcc.t4.b@1e51e2f7[thin lock]
weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:87)
com.one.somers.action.CorrectJSLAction.execute(CorrectJSLAction.java:64)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:217)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1481)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:700)
javax.servlet.http.HttpServlet.service(HttpServlet.java:815)
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:224)
weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:108)
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:206)
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(Unknown Source)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(Unknown Source)
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:308)
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:116)
weblogic.servlet.internal.WebAppServletContext.securedExecute(Unknown Source)
weblogic.servlet.internal.WebAppServletContext.execute(Unknown Source)
weblogic.servlet.internal.ServletRequestImpl.run(Unknown Source)
weblogic.work.ExecuteThread.execute(ExecuteThread.java:203)
weblogic.work.ExecuteThread.run(ExecuteThread.java:170)

Experts let me know if you need any additional information and help me.

Thanks

Edited by: user9532183 on 3 Jan, 2013 7:03 PM
  • 1. Re: Stuck Thread Problem in Weblogic & DB2
    792849 Newbie
    Currently Being Moderated
    This line: com.capitalone.sims.action.CouponISLAction.execute(CorrectJSLAction.java:64) has a long running SQL sentence. You must optimize the sentence or increase the StuckThreadMaxTime of the server or of the application.


    Change your weblogic.xml to this:
    <?xml version="1.0" encoding="UTF-8"?><wls:weblogic-web-app xmlns:wls="http://xmlns.oracle.com/weblogic/weblogic-web-app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd http://xmlns.oracle.com/weblogic/weblogic-web-app http://xmlns.oracle.com/weblogic/weblogic-web-app/1.3/weblogic-web-app.xsd">
        <wls:weblogic-version>10.3.6</wls:weblogic-version>
        <wls:context-root>StuckThreadWebProject</wls:context-root>
        <wls:work-manager>
            <wls:name>wm/NoStuckWorkManager</wls:name>
            <wls:response-time-request-class>
                <wls:name>ResponseTime</wls:name>
                <wls:goal-ms>12000000</wls:goal-ms>
            </wls:response-time-request-class>
        </wls:work-manager>
        <wls:wl-dispatch-policy>wm/NoStuckWorkManager</wls:wl-dispatch-policy>
    </wls:weblogic-web-app>
    [http://www.thiagovespa.com.br/blog/2012/09/06/stuck-threads-no-weblogic/|source] (pt-BR)

Legend

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