This error is getting to the unbearable point, and I'm wondering if anybody has a solution.
I have 4 CFMX servers, all 6.11, all running 3.5 jdbc drivers, connecting to a single sql server (2000) that is on their local network. Only one CF server returns this error, and it does it constantly. This happened with 3.4, 3.3, etc as well, but at some point the error message changed from 'reset by peer' to this: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. The error occurred on line 19. To give you an idea what I mean by "unbearable", my error inbox has over 100 of these since last night at 10pm. This server is 95% used for scheduled 'data crunching' jobs, 90% of these jobs didn't run last night b/c of this error. One job that runs every 10 minutes to check an inbox failed every single time it ran between 11pm and 12pm, as far as I can tell, each time with this error. In manually being on the server this morning, I'd say 50% of my attempts to load a page ended in this error. I have 3 other CFMX servers, all with the same drivers, on the same network, connecting to this same DB. No other CF servers return this error, so obviously it has not exceeded connections despite the error messages insistance otherwise. I just checked the DB activity after receiving another error right now, there was not a single login under the credentials at the time. There were 3 non-system logins. I have tried maintaining connections and not maintaining connections. I have tried using the same DB login that all other cf servers use, and I have tried using it's own dedicated login. I have tried increasing timeout, and decreasing timeout. None of these things seem to have a significant impact. I can't go on like this. I have to wake up at 1am every morning to see if CF feels like connecting to the database that night, b/c it can't be trusted to do it on its own in a scheduled task. I need help :) Is there a specific JDBC setting / setup that I can make to... I don't know... make the drivers actually retrieve data from the database? This CF server is a bit different in purpose from my other cf servers. my other servers are meant to handle quick-loading user requests, whereas this server is meant to handle slow-loading data crunching jobs. The typical job will run 5 seconds to a minute, but others will stretch upwards of 30-40 minutes. While this morning is an extreme example of this error, it is rare that a morning goes by without at least 1 job failing as a result of this error. TIA for any suggestions, -Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225880 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
