VPN connections between servers for use in this way I had always found to be unreliable. There is nothing you can do to avoid this i'm afraid in this setup. CF requests will run until they either complete or timeout. Because a database connection is what is called native code, the request cannot be killed by CF or even fusionReactor so will usually just hang indefinitely
However you should be using some form of monitoring to mitigate such situations, a decent network monitoring tool will be able to monitor your VPN and restart the service if it goes down. Take a look at PRTG or Kaseya. you could also use FusionReactor to monitor CF to detect problems with DB connections as well. I would suggest a failover solution for your database server, but that would presumably be on the other end of a VPN as well, so would suffer from the same problem. You could also consider putting mail and Oracle on the same network as the CF server to avoid this problem altogether. On Fri, Nov 18, 2011 at 4:49 PM, Mallory Woods <mallory.wo...@gmail.com> wrote: > > We had an interesting fail that happened yesterday. > > > We had a user send out a large amount of mail during the day which choked > off almost all of our bandwidth. > When this happened, it collapsed our VPN tunnel. This tunnel is how we make > our connection to our Oracle > Database. > > With the DB down of course regular CF functionally was fine until code that > accesses the DB is executed. > > What appeared to happen is the site tried to make a DB connection and > eventually timed out. > This process continued over and over again with each attempted connection > to the DB until Jrun crashed or became unresponsive. > > When I saw the Jrun error message, my first thought was to restart CF and > Apache. This fixed the issue for the time until > another connection to the DB was attempted. At that point this whole > process restarted itself which lead to another crash. > > Eventually, we discovered that the VPN tunnel was not operational and that > was what prevented the DB connections. > > The question I have from my boss is *what can we do to prevent this*? I > think the answer is there is nothing we can do. My suggestion > from the experience yesterday is to ensure the tunnel is operational. I > don't think there is anything else that can be done. > > > Thanks in advance, > > Mallory Woods > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
