No i dont mean the.cfthread tag, I mean an actual thread. As I said if cf is simply unable to connect to the db server then you will get an error and not a hung thread. A hung thread is when the connection was successful but was unable to complete the request due to issues on the db side. So if the db went offline in the middle of a request, or if the db failed to respond due to crashing for maxed out cpu.
Check the fusion reactor site for details on how it works. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Nov 18, 2012 9:49 PM, "Stefan Richter" <[email protected]> wrote: > > 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:353236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
