Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

One of our CF servers under NLB getting database query errors now

Guest
Mar 19, 2008 Mar 19, 2008
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?
221
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Mar 21, 2008 Mar 21, 2008
LATEST
What is your NLB?

Do you have any configuration change on load balancer?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources