Question
One of our CF servers under NLB getting database query errors now
Back in 2005, we hired a vendor create an app for us to take
in document submissions. We have two servers to do this, both Win
2003 servers running Coldfusion MX 6.1 and IIS. Network Load
Balancing was set up to include both, so when someone goes to
docs.mycompany.com, they'd go to either docs1.mycompany.com or
docs2.mycompany.com. Both servers connect to an MS SQL server. NLB
is using Single Affinity sticky sessions.
This setup has worked with no problems since it was first set up in 2005 until a couple of weeks ago. Now, docs1.mycompany.com will "hang" and then give a database query error. The application.cfm file has a query in it to read some settings. The other server, docs2.mycompany.com has no problem. As far as I can tell, the docs1 server will do this after a period of inactivity. If it does this, and I open up my web browser, and type in the direct url, http://docs1.mycompany.com, then the opening page comes up fine. After I do this, going to http://docs.mycompany.com comes up normally again.
I'm not aware of anything changing on this server. Like I said before, everything had been working fine since 2005. Does anything have any ideas as to what could be going on?
This setup has worked with no problems since it was first set up in 2005 until a couple of weeks ago. Now, docs1.mycompany.com will "hang" and then give a database query error. The application.cfm file has a query in it to read some settings. The other server, docs2.mycompany.com has no problem. As far as I can tell, the docs1 server will do this after a period of inactivity. If it does this, and I open up my web browser, and type in the direct url, http://docs1.mycompany.com, then the opening page comes up fine. After I do this, going to http://docs.mycompany.com comes up normally again.
I'm not aware of anything changing on this server. Like I said before, everything had been working fine since 2005. Does anything have any ideas as to what could be going on?
AdChoices