This is very interesting, our SQL server is not restarting but we do see a lot of these connections being reset and in turn server failure...
Hmmm, a bug all along... How intriguing. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Steven Erat To: CF-Talk Sent: Wed Feb 28 17:11:06 2007 Subject: RE: Problem with Server Timing Out I've reproduced the Connection Reset error in the following scenario: Reproducible Scenario: 1) With connection pooling enabled, make one simple query with a simple test table to establish the driver connection. 2) Restart the SQL Server database server via Windows Services 3) When SQL Server Service is running again, repeat step 1 to run the simple query. A "Connection reset by peer: socket write error" will occur. In this scenario ColdFusion driver has established a database connection via TCP and has cached it. Upon a database restart the database terminates the TCP connection. When the query is rerun the cached connection is used however the underlying connection no longer present or functional. Rather than quietly establishing a new connection as retry, the database driver simply propagates the error back to the application. I've submitted the full test case details to the driver vendor DataDirect. We anticipate a fix where the driver will silently make a new connection upon a Connection Reset rather than stopping on the error. -Steven Erat > -----Original Message----- > From: Jim H [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 27, 2007 1:29 PM > To: CF-Talk > Subject: Re: Problem with Server Timing Out > > I upgraded the drivers to the article's specs and the problem > persists. > I will try and collect the other data from CFSTAT. We > installed FusionRactor on the server, however, I have not > been able to deeply understand what it is showing me. I see > connection times ramp up, then time out and fall off. Due to > the errors, it appears like they are DB connections that ramp > up, stall and fail. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
