Can you just use createUUID() to generate a unique ID without needing a lock? Regardless, you shouldn't be seeing a deadlock unless there's a whole lot more to the code than that which you posted; even then the timeout should be observed and you shouldn't be getting an infinite deadlock.
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_j-l_05.html mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/10/2 Andrew Mason <[EMAIL PROTECTED]> > Hi Folks, > > I wonder if someone can help me. > > I have a situation where I use cflock when generating IDs to ensure no > duplications occur etc which 'sometimes' results in a deadlock situation. > > <cflock timeout="8" throwontimeout="No" name="LockName" type="EXCLUSIVE"> > <cfset ID=..........> > </cflock> > <Insert Query Here> > > Because the Throw is 'no' whenever the lock gets 'stuck' for whatever > reason (which is quite rare, but has a high impact negative outcome) the > timeout is ignored and then it carries on forever, or atleast until I > restart my webserver. It is important to keep the Throw set to No. Does > anybody have any suggestions as to what to do to break this vicious circle > of locking without any manual intevention? > > The code above is actually an improved snippet than my earlier version > because I had previously included a select query and an insert query inside > the same bounding CFLOCK by the way. This may have been the root cause of > my problems because there was more work required in the original lock code, > but I don't really understand cflocks enough to be sure. > > Maybe I could use an server monitor software to analyse a test CF page > which tries to run a lock with the same name and then runs some sort of > action to restart on it's own as a last resort? > > Thanks a lot > > Andrew > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
