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:342191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
