Carl, There are a number of things that can go wrong on a CF 5 server. As some have suggested your code (particularly locking) is a good place to start. Tuning the server itself and the dreaded "zero length mail file" bug are other possibilities. Here's a blog entry that applies from some time ago.
http://mkruger.cfwebtools.com/index.cfm?mode=alias&alias=cfmailbug -----Original Message----- From: Carl O [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 6:00 PM To: CF-Talk Subject: Cold Fusion Crashes Hi I am kind of new to cold fusion (been dealing with it for about 6 months) and not a programmer. This is a horrible question im about to ask, but can you give me the basic steps to troubleshoot a CF problem? Our server is crashing once every few days. Its cold fusion 5. The error logs dont really have anything in common with previous crashes, but ive only jsut started keeping records. I have horribly little information on the problem. We have two load balanced webservers with an MS SQL database. all servers are very able to handle the load we are having, barely reaching 50% cpu usage most of the time. Every few days, one of the servers will crash. The fix is to restart the service. This is highly annoying when it happens at 4am. The servers have not gone down together yet. I have included the last error in the application log right before the server crashed today. IP address has been removed to protect the innocent. 65.35.XXX.XXX, Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 9x 4.90; AT&T CSM6.0; H010818), An error occurred while evaluating the expression: #HTTP_REFERER# Error near line 293, column 57.------------------------------------------------------------------------- -------Error resolving parameter HTTP_REFERERColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (#HTTP_REFERER#), occupying document position (293:56) to (293:69).Date/Time: 06/14/05 14:48:49Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 9x 4.90; AT&T CSM6.0; H010818)Remote Address: 65.35.XXX.XXXQuery String: fuseaction=counselling_shipping&CFID=3155787&CFTOKEN=76384874 there are many of these errors throughout the day so i dont think its related. Which log files would be the best ones to look at? is there a way to get some kind of verbose logging? how do i determine exactly what the server is doing at the moment of death? Like i said im a newbie any help appreciated. Carl O ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209617 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
