So, There is a thread on one of my CF instances that has been hung for like 3 hours now... like the others I've mentioned, it's frozen on a SQL Server operation:
The top of the stack trace is here: http://cfm.pastebin.com/9WkKuELc As with the others, the query is a perfectly normal query that runs hundreds or thousands of times per hour (this site processes about 25,000 CF rquests per hour during the night hours). So I ran sp_who <loginname> on SQL server and there's no sign of any hung threads... so I think it's safe to say that SQL Server completed processing of the request, and somehow, Coldfusion failed to receive the result - perhaps due to a network problem... I am at a loss on how to resolve this issue. Networking is *WAY* out of my league. I don't even know what an "unmanaged switch" is, nor do I really have any idea what the network topography in the data center is like... Rick > On Sun, Nov 28, 2010 at 8:42 PM, 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:339716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
