Thank you for your reply, but that sounds like a bug then, doesn't it? I mean there is no db problem as such, it just so happens that the db server may need rebooting from time to time. Would the same happen if a network error was to occur between CF and the db server?
You mention cfthread, do you mean a general CF thread of the cfthread tag specifically? I'm not using the cfthread tag if that's what you mean. I admit I don't understand the difference between what I am encountering and DSN failing. If the datasource is unavailable (even temporarily) isn't that something that can happen fairly naturally? It seems to be a huge issue to me that such an incident can effectively bring down the entire CF service :-/ Unfortunately I run CF Standard. Will check out Fusion Reactor. Could you explain what this will allow me to do apart from finding the source of the problem (which in this case I am 99% sure is related to the DB server being offline temporarily). Cheers Stefan >If a cf thread hangs trying to connect to a database then it will hang >indefinitely because this is a native java thread which cannot be killed. >So what happens is that all your requests will hang until you reach the >maximum and further requests will be queued and will never complete. >There isn't really any solution to this issue I have found other tham to >sort out the db problem as native threads cannot be killed. > >This is not the same as your dsn failing to.connect to the db server, which >will result in an error and the request will end. > >You can use your built in server monitor to check this and see the running >requests and threads and stack trace them. >If you do not have cf enterprise then try fusion reactor. > >Regards >Russ Michaels >www.michaels.me.uk >www.cfmldeveloper.com - Free CFML hosting for developers >www.cfsearch.com - CF search engine ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:353235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
