I can second this and have seen it myself in the past. For more supporting opinion, check out Joel Spolky's post about an outage caused by this: http://joelonsoftware.com/items/2008/01/22.html
Also, this old post from ye ole (now dead) Guru Blog, based on the same incident from Mark's blog post. Additional links and goodness within... http://web.archive.org/web/20070126122711/www.cfguru.org/index.cfm/2006/6/6/Network-Auto-Sensing-Causes-ColdFusion-Server-to-Hang -Cameron On Mon, Nov 29, 2010 at 9:09 AM, Mark A. Kruger <[email protected]> wrote: > > 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... > > R ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:339575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
