Loading ...
Sorry, an error occurred while loading the content.

Hanging Threads?

Expand Messages
  • Seth Johnson
    I Have a FB 5.5 app that is suffering from hanging threads, not on every page but one particular section. I have broken down the code bit by bit and can t
    Message 1 of 6 , Jan 4, 2012
    • 0 Attachment

      I Have a FB 5.5 app that is suffering from hanging threads, not on every page but one particular section.

       

      I have broken down the code bit by bit and can’t figure out what is causing this to happen. 

       

      This has worked for years, but we recently moved servers and this issue started cropping up intermittently.

       

      I’m not really sure how to read stack traces, hopefully someone may be able to help….

       

      I go the following from Fusion Reactor after the thread had hung for about 900k ms.

       

      Thanks in advance!

       

      Seth

      ==============================================================================


      java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)[Native Method]
      java.net.SocketInputStream.read(SocketInputStream.java:129)
      macromedia.jdbc.sqlserver.dda.w(null:???)
      macromedia.jdbc.sqlserver.dda.a(null:???)
      macromedia.jdbc.sqlserver.tds.ddr.a(null:???)
      macromedia.jdbc.sqlserver.tds.ddr.a(null:???)
      macromedia.jdbc.sqlserver.ddh.a(null:???)
      macromedia.jdbc.sqlserverbase.ddch.getObject(null:???)
      coldfusion.sql.QueryTable.populate(QueryTable.java:396)
      coldfusion.sql.QueryTable.populate(QueryTable.java:261)
      coldfusion.sql.Executive.getRowSet(Executive.java:585)
      coldfusion.sql.Executive.executeQuery(Executive.java:1383)
      coldfusion.sql.Executive.executeQuery(Executive.java:1127)
      coldfusion.sql.Executive.executeQuery(Executive.java:1058)
      coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
      coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
      coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
      cfact_sendMessage2ecfm650806456._factor5(***:178)
      cfact_sendMessage2ecfm650806456.runPage(***:1)
      coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
      coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
      coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
      cffbx_Switch2ecfm2102203930.runPage(***:81)
      coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
      coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
      coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
      cffbx_fusebox30_CF502ecfm1988472699._factor4(***\fbx_fusebox30_CF50.cfm:241)
      cffbx_fusebox30_CF502ecfm1988472699._factor5(***\fbx_fusebox30_CF50.cfm:1)
      cffbx_fusebox30_CF502ecfm1988472699.runPage(***\fbx_fusebox30_CF50.cfm:1)
      coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
      coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
      coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
      cfindex2ecfm1721364712.runPage(***\index.cfm:7)
      coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
      coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
      coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
      coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
      coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
      coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
      coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
      coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
      coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
      coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
      coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
      coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
      coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
      coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
      coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126)
      coldfusion.CfmServlet.service(CfmServlet.java:200)
      coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
      jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
      com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:428)
      com.intergral.fusionreactor.filter.FusionReactorFilter.d(FusionReactorFilter.java:262)
      com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:171)
      jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
      coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
      coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
      jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
      jrun.servlet.FilterChain.service(FilterChain.java:101)
      jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
      jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
      jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
      jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
      jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
      jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
      jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
      jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
      jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

       

    • Kevin Roche
      Seth, Which SQL Server Driver are you using? Kevin
      Message 2 of 6 , Jan 4, 2012
      • 0 Attachment
        Seth,

        Which SQL Server Driver are you using?

        Kevin
         
      • Seth Johnson
        Hi Kevin, its MSSQLServer . Seth Johnson Today REAL ESTATE 508-568-8131 www.todayrealestate.com From: fusebox5@yahoogroups.com
        Message 3 of 6 , Jan 4, 2012
        • 0 Attachment

          Hi Kevin, its MSSQLServer .

           

          Seth Johnson

          Today REAL ESTATE

          508-568-8131

          www.todayrealestate.com

           

          From: fusebox5@yahoogroups.com [mailto:fusebox5@yahoogroups.com] On Behalf Of Kevin Roche
          Sent: Wednesday, January 04, 2012 10:05 AM
          To: fusebox5@yahoogroups.com
          Subject: Re: [fusebox5] Hanging Threads?

           

           

          Seth,

          Which SQL Server Driver are you using?

          Kevin
           

        • Kevin Roche
          Seth, Is that the one that comes with CF? or did you update it? What version of CF do you have? Is it patched with any recent patches? Kevin
          Message 4 of 6 , Jan 4, 2012
          • 0 Attachment
            Seth,

            Is that the one that comes with CF? or did you update it?

            What version of CF do you have?

            Is it patched with any recent patches?

            Kevin

            On 4 January 2012 15:30, Seth Johnson <sjohnson@...> wrote:
             

            Hi Kevin, its MSSQLServer .

             

            Seth Johnson

            Today REAL ESTATE

            508-568-8131

            www.todayrealestate.com

             


          • Nancie McCraw
            Are you using Windows 2008 server r2? We are seeing something similar and noticing weirdness in how Windows is allocating memory. From: Seth Johnson
            Message 5 of 6 , Jan 4, 2012
            • 0 Attachment

              Are you using Windows 2008 server r2? We are seeing something similar and noticing weirdness in how Windows is allocating memory.

               

              From: Seth Johnson [mailto:sjohnson@...]
              Sent: Wednesday, January 04, 2012 9:48 AM
              To: fusebox5@yahoogroups.com
              Subject: [fusebox5] Hanging Threads?

               

               

              I Have a FB 5.5 app that is suffering from hanging threads, not on every page but one particular section.

               

              I have broken down the code bit by bit and can’t figure out what is causing this to happen. 

               

              This has worked for years, but we recently moved servers and this issue started cropping up intermittently.

               

              I’m not really sure how to read stack traces, hopefully someone may be able to help….

               

              I go the following from Fusion Reactor after the thread had hung for about 900k ms.

               

              Thanks in advance!

               

              Seth

              ==============================================================================


              java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)[Native Method]
              java.net.SocketInputStream.read(SocketInputStream.java:129)
              macromedia.jdbc.sqlserver.dda.w(null:???)
              macromedia.jdbc.sqlserver.dda.a(null:???)
              macromedia.jdbc.sqlserver.tds.ddr.a(null:???)
              macromedia.jdbc.sqlserver.tds.ddr.a(null:???)
              macromedia.jdbc.sqlserver.ddh.a(null:???)
              macromedia.jdbc.sqlserverbase.ddch.getObject(null:???)
              coldfusion.sql.QueryTable.populate(QueryTable.java:396)
              coldfusion.sql.QueryTable.populate(QueryTable.java:261)
              coldfusion.sql.Executive.getRowSet(Executive.java:585)
              coldfusion.sql.Executive.executeQuery(Executive.java:1383)
              coldfusion.sql.Executive.executeQuery(Executive.java:1127)
              coldfusion.sql.Executive.executeQuery(Executive.java:1058)
              coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
              coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
              coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
              cfact_sendMessage2ecfm650806456._factor5(***:178)
              cfact_sendMessage2ecfm650806456.runPage(***:1)
              coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
              coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
              coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
              cffbx_Switch2ecfm2102203930.runPage(***:81)
              coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
              coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
              coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
              cffbx_fusebox30_CF502ecfm1988472699._factor4(***\fbx_fusebox30_CF50.cfm:241)
              cffbx_fusebox30_CF502ecfm1988472699._factor5(***\fbx_fusebox30_CF50.cfm:1)
              cffbx_fusebox30_CF502ecfm1988472699.runPage(***\fbx_fusebox30_CF50.cfm:1)
              coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
              coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
              coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
              cfindex2ecfm1721364712.runPage(***\index.cfm:7)
              coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
              coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
              coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
              coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
              coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
              coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
              coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
              coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
              coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
              coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
              coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
              coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
              coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
              coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
              coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126)
              coldfusion.CfmServlet.service(CfmServlet.java:200)
              coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
              jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
              com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:428)
              com.intergral.fusionreactor.filter.FusionReactorFilter.d(FusionReactorFilter.java:262)
              com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:171)
              jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
              coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
              coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
              jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
              jrun.servlet.FilterChain.service(FilterChain.java:101)
              jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
              jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
              jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
              jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
              jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
              jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
              jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
              jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
              jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

               

              This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of Kimmel & Associates of Asheville, NC. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments.

              {*}
            • Seth Johnson
              Kevin, I think I tracked it down to a slow running/locked query due to a heavily fragmented index. Should have been the first place I looked.. Seth Johnson
              Message 6 of 6 , Jan 4, 2012
              • 0 Attachment

                Kevin,

                 

                I think I tracked it down to a slow running/locked query due to  a heavily fragmented index.  Should have been the first place I looked….

                 

                Seth Johnson

                Today REAL ESTATE

                508-568-8131

                www.todayrealestate.com

                 

                From: fusebox5@yahoogroups.com [mailto:fusebox5@yahoogroups.com] On Behalf Of Kevin Roche
                Sent: Wednesday, January 04, 2012 11:57 AM
                To: fusebox5@yahoogroups.com
                Subject: Re: [fusebox5] Hanging Threads?

                 

                 

                Seth,

                Is that the one that comes with CF? or did you update it?

                What version of CF do you have?

                Is it patched with any recent patches?

                Kevin

                On 4 January 2012 15:30, Seth Johnson <sjohnson@...> wrote:

                 

                Hi Kevin, its MSSQLServer .

                 

                Seth Johnson

                Today REAL ESTATE

                508-568-8131

                www.todayrealestate.com

                 

                 

              Your message has been successfully submitted and would be delivered to recipients shortly.