That makes sense to me.... one server reinitiated the connection login sequence (and of course failed) while the other server kept right on using the connections it had in the pool. You could probably circumvent this by turning off pooling (maintain connections in the admin).
Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Earl, George [mailto:george.e...@ssa.gov] Sent: Monday, February 14, 2011 8:54 AM To: cf-talk Subject: Data source continues working after user id revoked We had something weird happen. We're running CF 9.0.1 in a load balanced setting with two servers. The password for one of our data sources was changed so that the passwords in the data sources on the two servers no longer were valid. The data source on one server promptly stopped working with a user id revoked error because of the 'bad' password. But the data source on the other server kept working for several hours until sometime after close of business for that day. In the morning the data source was broken on both servers with the user id revoked error. Does it sound reasonable that the server that continued to be able to use the data source after the user id had been revoked was able to do so because it was kept open in the cache as long as someone was using it within the maintain connections timeout window? And that it was able to do so until the timeout window expired at some point with no further requests for the data source? Thanks! George ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm