Don, To respond to your question, Macromedia is currently working on an issue where a thread can hang while trying to get a connection to an unresponsive database. The issue will be the underlying driver's use of the Socket API's. The ColdFusion Admin general Timeout may be exceeded in that case, and the CFQUERY tag timeout does not have any role until after the connection has been established. In a particular test I've recently ran, an attempted CFQuery to a datasource where the database was down or unavailable took over 100 seconds to finally timeout even though the CFAdmin timeout was 30 seconds.
In this scenario, the database may be unavailable for one of a variety of reasons including DNS server problems, a wrong ip entered in the CFAdmin dsn setting, or a firewall intermittently blocking traffic between CF and the database server. This is an important problem that we are working on, and I'll provide any news on the topic as I get it. One way to confirm if requests to a database are in fact backing up is to perform a full thread dump and then examine the results. See the TechNote, Debugging Stack Traces in ColdFusion MX, for details: http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm -Steven Erat Macromedia ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
