You will also find in your client variable settings an option Disable global client variable updates This option controls how ColdFusion updates global client variables, such as HITCOUNT and LASTVISIT. If updates are disabled, ColdFusion updates these variables only when they are set or modified. If updates are enabled, ColdFusion updates global client variables for each page request
Disabling this is going to make a difference. russ -----Original Message----- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 03 August 2005 22:24 To: CF-Talk Subject: RE: Client deadlock Tom, A deadlock message is not an error per se - at least not necessarily a programming error. It means that there are competing SQL connections trying to access the same resource on the client variable store. The first thing I would do would be to clear out all the client variables in the table (CDATA I think). I would also add an index or 2 to make selects breath easier. It's possible that this will fix your immediate problem. Finally, since you have this problem on a dev box (and presumably you are not hitting the same SQL server) which is typically not as busy as production - I would look for code that is continually inserting into the table. For example - if you dynamically change the application name with every request (don't laugh - it's been done :). -Mark -----Original Message----- From: Botts, Tom [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 3:51 PM To: CF-Talk Subject: Client deadlock I am getting a ton of these error messages. They are not in the coldfusion admin logs but under Jrun/logs/cfusion-out.log. This is a MX 7 installation, sql 2000, server 2003. These are the steps we have tried so far: 1. We observed we are getting these on both our production box and test box. 2. On the test box we have switched jdbc drivers from microsoft to native macromedia - no difference. 3. On the test box we switched sql servers - no difference. 08/03 16:40:25 Information [jrpp-550] - client variable JDBC STORE - retry 3 08/03 16:40:25 Information [jrpp-535] - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 377) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 08/03 16:40:25 Warning [jrpp-535] - Failed to store CLIENT variables to datasource CF_SERVER - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 377) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Any clues ? Thanks in advance, Tom ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Tom Botts Programmer/Analyst Gilbarco Inc. 336-547-5911 phone 336-547-5163 fax [EMAIL PROTECTED] www.gilbarco.com <file://www.gilbarco.com/> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This document contains confidential information of Gilbarco Inc. In consideration of the receipt of this document, the recipient agrees not to reproduce, copy, use or transmit this document and/or the information contained herein, in purpose except with written permission, first obtained, of GilbarcoInc. and further agrees to surrender the same to Gilbarco Inc. upon demand. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:213662 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
