We are building a second data centre (dc), that will be identical to our existing one. This dc is using our old servers so as not to cost too much money.
We currently run ColdFusion 7 and have installed this on the web servers for the new dc. The sites work fine, but every now and then we get the following error:
Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
I've checked the logs on all devices that this traffic would have to pass through, but there is nothing related.
I've tried googling and have spent three days searching to no avail. I can't recreate the issue either as it happens randomly.
I had one of our web developers write me a simple page that returns a one row query result from each of our SQL DBs (which are 2000 & 2005 btw) and the error says the problem occurred on line 50 - there is only 49 lines in that file though!
So as you can see, I've not much in the way of ideas on how to sort this.
Can anyone shed some light? I don't think its a CF problem as it says Peer Closed Connection...
Thanks
Neil
We currently run ColdFusion 7 and have installed this on the web servers for the new dc. The sites work fine, but every now and then we get the following error:
Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write error
I've checked the logs on all devices that this traffic would have to pass through, but there is nothing related.
I've tried googling and have spent three days searching to no avail. I can't recreate the issue either as it happens randomly.
I had one of our web developers write me a simple page that returns a one row query result from each of our SQL DBs (which are 2000 & 2005 btw) and the error says the problem occurred on line 50 - there is only 49 lines in that file though!
So as you can see, I've not much in the way of ideas on how to sort this.
Can anyone shed some light? I don't think its a CF problem as it says Peer Closed Connection...
Thanks
Neil
