Jon, >I just installed See Fusion... it's totally nasty. It shows me what >ColdFusion is doing at runtime. I'm able to tell that I occasionally get >some threads that become "stuck". For example: > >/home/index.cfm?event=displaySectionpage&id=292803 ><http://www.collegepublisher.com/home/index.cfm?event=displaySectionpage§io >n_id=292803> > 72.30.103.96 -- 334,650,985 -- -- --ms,-- rows > >/home/index.cfm?event=displaySectionpage&code=20060222Sports ><http://www.collegepublisher.com/home/index.cfm?event=displaySectionpage§io >nfile=20060222Sports> > 204.6.201.196 -- 334,649,860 -- -- --ms,-- rows > >As you can see there are two requests that have been hung for over 300,000 >seconds. Usually those requests take very little time to process... maybe 5 >seconds at most. What is the best way to ensure that this don't happen? > >In my ColdFusion Administrator, I've set the setting for "Timeout requests >after (seconds)" to "300" and I've checked the box too.
Start checking your code for loops that may have conditional logic that is causing the loop to never exit--endless loops. Also, once a JDBC operation begins, the CF will not timeout and the JDBC operation is completed. This means if you have a query that takes 600 seconds to run, the error will not get thrown until *after* the JDBC operation completes. It will not halt in mid operation. So, this could potentially mean the operation is getting hung during a JDBC operation. Perhaps your JDBC connection is getting broken. -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233533 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
