Skip to main content
Inspiring
July 30, 2009
Question

Pages timing out

  • July 30, 2009
  • 1 reply
  • 907 views

We have five in house built applications that run on the same server. However, one application seems to be timing out lately. Different pages, different hours of the day, different states (from CA, to TX, to MS, to FL), etc. Whenever one of the pages times out, the user calls and I try and duplicate by doing the exact same transaction on the same page, and it works for me without any issues. I call the sever admins located in AL and they say that the sever is fine and that the page is coded incorrected. Something call JRUN detected a problem and locked the page and when I used it, the lock was released.

This does not make sense to me. If the page/pages are coded in correctly, shouldnt they always fail ? Logically, that makes sense. But different pages fail at different times and we cannot pinpoint where teh problem is to try and fix it. One major difference between this app and the others is that this one still uses two pages, the form and action page. Some pages were rewritten to combine both into one page but that did not seem to solve the problem. We looked at the tables and they seem to be ok. We looked at the queries and ran thru analzyer and they completed quickly,no hangups. Everythihng seems to be ok, the data goes into the proper tables, etc. but some of the pages still time out. This app was running fine for the past year and half and the time outs just started happening about 2 months ago. At about the same time, the server crashed and was restored two days later. But this could just be a coincidence.

What could be causing the pages to time out ? Where else can we look to try and identify/isolate the problem ? Again, some people use it and it seems fine. But others using it wait awhile after submitting and then the page eventually times out. We are baffled and do not know what else can be done. None of the other apps seem to time out except for this one.

Any ideas or solutions will be greatly appreciated. Thanks

    This topic has been closed for replies.

    1 reply

    July 31, 2009

    Have you checked your ColdFusion, SQL and web server log files for when these timeouts happened? You're going to want to try and locate the code/page(s) that are causing your timeout and the best place to pinpoint this is the log files (IMO). You mention there was a JRUN error, look at the CF logs (application.log, exception.log, server.log) for the time you saw this error and post back what you find.

    August 13, 2009

    Are you writing and reading to a database?  If you have a dba, they can run some profiling to see if things are taking a long time, and they can also easily identify missing indexes.

    Missing indexes can be an issue as the size of the db grows, and yes sometimes this seems like all of a sudden because one major tables indexes go missing or become fragmented.

    Byron Mann

    mannb@hostmysite.com

    byronosity@gmail.com

    Software Architect

    hosting.com | hostmysite.com

    http://www.hostmysite.com/?utm_source=bb