Rick, There's one possibility that comes to mind dealing with networking. See this post.
http://www.coldfusionmuse.com/index.cfm/2006/5/25/hanging.threads.network.ca pacity.2 It's a fairly rare error dealing with renegotiation of port speeds/duplexing - but it could mimic the "sudden failure" issue you saw and it leaves these orphaned threads. Of course other network related issues could also cause the same thing - broadcast storms, switch recycling etc. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Rick Root [mailto:[email protected]] Sent: Sunday, November 28, 2010 2:19 PM To: cf-talk Subject: Diagnosing DB / CF problem 88 minutes ago, 5 different requests to various pages on the classcreator web site died while executing SQL Statements. There is nothing unusual about the SQL Statements, and in each case, these statements are executed tens or hundreds of times per minute with no problem. Since that time, 88 minutes ago, no additional queries have frozen any requests, but those 5 requests are still hanging (Fusion Reactor reports attempting to kill them, but the SQL calls are native threads so it cannot kill them). Since the instances were restarted approximately 107 minutes ago, the server has processed about 60,0000 requests, and only these 5 hung, all 5 at the same time. Anybody have any ideas what might cause something like these? We've had it happen several times recently.... we're running CF8 enterprise on Win2k8 ... (upgrading to CF9 next weekend!) I hate that the only way to kill these threads is to restart the CF instances... Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:339566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
