Connection Failure on established datasources

[rhouliston]

I'm running CF MX 7.01 - with all current hotfixes in place. This is
connecting to a MS SQL Server database with the SQL drivers. We've recently
noticed that at fairly random intervals, coldfusion will lose connection to the
database.

We get pages of errors in the coldfusion-err.log like this

A non-SQL error occurred while requesting a connection from zzzzz
Timed out trying to establish connection.

At this point the only way to fix this problem is to restart coldfusion. And
it seems to go on for days and then suddenly stop and be fine again.

The database can be connected to. I can log into the box, I can connect to
the datasources via Enterprise Manager.

I'm at a loss, any ideas whats going on and how to fix this?

[jdeline]

Check the ColdFusion server.log to see if you are experiencing slow running pages or losing threads around the time the timeouts occur.

[rhouliston]

At exactly the same time I started getting time-out errors, I started getting
many many of these errors as well

May 22, 2006 8:57 AM Warning 0
Thread: jrpp-46, processing template: D:\Inetpub\wwwroot\ping.cfm, completed
in 30 seconds, exceeding the 30 second warning limit

This page should have processed in a matter of seconds, all it is, is a single
query to the db. At this point I end up with a couple of hundred more of these
until I have to restart the server. But I wasn't sure if this was a cause or a
symptom

[jdeline]

In the server log, back up in time, 10-20 minutes, and see if you are getting messages that indicate that threads are beginning to hang. Also, how many concurrent threads is ColdFusion running?

[rhouliston]

There were no errors in the server log for the previous 30 min.

General Settings
Simultaneous request limit 20
Timeout requests Yes
Request Time Limit 60 seconds
Use UUID for CFToken No
Enable Whitespace Management Yes
Missing Template Handler
Site-wide Error Handler
Enable HTTP status codes Yes
Enable Global Script Protection Yes
Default CFForm ScriptSrc Directory /CFIDE/scripts/
Maximum size of post data 500 MB
Maximum number of report threads 10
Request Throttle Threshold 2 MB
Request Throttle Memory 200 MB

Database Settings:
We have 5 datasources with similar settings
Limit Connections - checked
Restrict Connections to 5
Maintain Connections - checked
Max Pooled Statements 1000
Timeout - 20 Interval - 7

[Richardji]

Hi,

I have exactly the same problem. CF 7.01, all hotfixes applied. Thought the
datadirect / ODBC updates would have fixed this but they haven't.

There are two DSN's, both SQL, one pointing to a clientvars db on an
SQL2000box, the other pointing to a content db on an SQL2005 box.

There are no connections limits on the DSN's, clob is enabled on one of them,
maintain connections is selected on both.

Threads are limited to 10.

Look forward to anyone else that can throw any light !