Yea, that's really strange to me also... You might eliminate the error by disabling global client variable updates (iirc it's hitcount + lastvisit) -- that should significantly reduce the traffic to the db, although it's not a real answer to the problem of client storage deadlocks.
> that was what fueled my original WTF and it was/is > consistently > happening... without fail. > tw > On Apr 6, 2005 2:14 PM, Jochem van Dieten > <[EMAIL PROTECTED]> wrote: >> Tony Weeg wrote: >> > >> > "Error","Thread-20","04/06/05","11:03:15",,"Error >> > invoking CFC for >> > gateway Async CFML: Operation failed on the data source >> > named >> > ""clientStorage"". Reason of failure >> > ""[Macromedia][SQLServer JDBC >> > Driver][SQLServer]Transaction (Process ID 177) was >> > deadlocked on lock >> > resources with another process and has been chosen as >> > the deadlock >> > victim. Rerun the transaction.""" >> >> I find this weird. I was under the impression that CF >> threw >> simple queries at the the Client Storage. Lots and lots >> of them, >> but simple ones. That might make for a lot of lock >> contention and >> delays, but not deadlocks. >> Does anybody know which queries are used for client >> variables? >> >> Jochem s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:201771 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
