I have a situation where the web server became unresponsive and have been 
unable to pinpoint the exact issue as to why.

System:
Win 2008 vmware server running IIS 7.5 and CF 9 

Situation: 
A database server on another system went down and a popular page on the site 
makes 2 calls to the database, which is then looped 7 times for a total of 14 
times on each page load (before you flame... it is not my code). It appears 
that the CF server made 2 calls and timed out both times which then kicked off 
the error handler twice. The error handler dumps the form, url, session, 
cookie, cgi, application scopes into an email which is then sent to me. The 
email size comes in at just over 400k with all the dumps. I have had times when 
several dozen emails were handled by the server in a much shorter time frame, 
but we have recently moved from linux to windows and I am not certain how much 
this could play a role in the issue. I am taking steps to minimize the size of 
the email, but if that is not the cause, I will still be sitting on a time bomb.

Question: Is it the error handler or the database timeouts locking up threads 
that played havoc on the server or a combination of both? Also, what do you 
suggest will fix it permanently?

Thanks for your time. 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347954
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to