well I can tell you one of the causes for hung requests, it is visitors closing your page before the request is complete which leaves it in a hung state as there is no where to send the response back to. Not sure if this could cause a hung db request though, I wouldn't have thought so as that is between cf and the db not the client, but I spose it is possible that CF may also hang the db request if it know sthe client request has been terminated prematurely.
Russ On Mon, Nov 29, 2010 at 1:42 AM, Dan Crouch <[email protected]> wrote: > > I see similar things like that happen sometimes and SeeFusion won't kill > them either. In those cases, many times what I can do is run an sp_who on > the database and look for the offending query, use a dbcc > inputbuffer(processid) if need be and then kill that process id. Most of the > time, that will allow me to kill the hung thread in SeeFusion so that no > restart is needed. I haven't tried FusionReactor so I am not sure it works > the same way, but the problem is very similar to what I have seen, just > viewed it through SeeFusion instead. I dont know why it happens, something > just seems to temporarily have gotten stuck on stupid. > > Dan > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:339564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
