Re: ExclusiveLock

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31826
interpreted = N
texte = >>>What happens when a template using ExclusiveLock cannot open one of >>>the designated db's because some other template using ExclusiveLock >>>already has it locked? >> >>I would guess that since [EXCLUSIVELOCK] is designed to prevent >>deadlocking, it would treat the second [EXCLUSIVELOCK] request as a >>regular request and wait until the first [EXCLUSIVELOCK] is finished >>before executing it. > >This is correct.Thanks for clarification. This brings up another question:What if [EXCLUSIVELOCK] locks some db's, but fails to unlock them for some reason? Wouldn't that prevent all other requests to the same db's from executing until webcatalog is shut down and restarted?If so, is there some kind of timeout available to force the [EXCLUSIVELOCK] to end, so this will never happen? ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================############################################################# This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Re: exclusivelock (Govinda 2011)
  2. Re: [WebDNA] Re: exclusivelock (Donovan Brooke 2011)
  3. Re: [WebDNA] Re: exclusivelock (Donovan Brooke 2011)
  4. Re: [WebDNA] Re: exclusivelock (Kenneth Grome 2011)
  5. Re: [WebDNA] Re: exclusivelock (Govinda 2011)
  6. Re: [WebDNA] Re: exclusivelock (Donovan Brooke 2011)
  7. Re: [WebDNA] Re: exclusivelock (Govinda 2011)
  8. Re: [WebDNA] Re: exclusivelock (Kenneth Grome 2011)
  9. Re: [WebDNA] Re: exclusivelock (William DeVaul 2011)
  10. Re: [WebDNA] Re: exclusivelock (Aaron Michael Kaczmarek 2011)
  11. Re: [WebDNA] Re: exclusivelock (Govinda 2011)
  12. [WebDNA] Re: exclusivelock (Kenneth Grome 2011)
  13. [WebDNA] exclusivelock (Kenneth Grome 2011)
  14. Re: ExclusiveLock question ( Donovan Brooke 2005)
  15. ExclusiveLock question ( Justin Carroll 2005)
  16. Re: ExclusiveLock ( "Scott Anderson" 2003)
  17. Re: ExclusiveLock ( Brian Fries 2003)
  18. Re: ExclusiveLock ( Donovan 2003)
  19. Re: ExclusiveLock ( "WebDna @" 2003)
  20. Re: ExclusiveLock ( Donovan 2003)
  21. ExclusiveLock ( "WebDna @" 2003)
  22. ExclusiveLock (was: Re: unique ascending numbers) (Nitai @ ComputerOil 2003)
  23. Re: [exclusivelock] (was:several people...) (Sam Lewis 2001)
  24. Re: [exclusivelock] (was:several people...) (dale 2001)
  25. [exclusivelock] (was:several people...) (Donovan Brooke 2001)
  26. Can I use a [closedatabase] inside an [exclusivelock]? (Jaishankar Jayaram 2000)
  27. Re: ExclusiveLock (Dale LaFountain 2000)
  28. Re: ExclusiveLock (John Butler 2000)
  29. Re: ExclusiveLock (Dale LaFountain 2000)
  30. Re: ExclusiveLock (John Butler 2000)
  31. Re: ExclusiveLock (John Butler 2000)
  32. Re: ExclusiveLock (Kenneth Grome 2000)
  33. Re: ExclusiveLock (Kenneth Grome 2000)
  34. Re: ExclusiveLock (GHulbert@smithmicro.com 2000)
  35. Re: ExclusiveLock (Kenneth Grome 2000)
  36. Re: ExclusiveLock (GHulbert@smithmicro.com 2000)
  37. Re: ExclusiveLock (Kenneth Grome 2000)
  38. Re: ExclusiveLock (GHulbert@smithmicro.com 2000)
  39. Re: ExclusiveLock (Michael Winston 2000)
  40. ExclusiveLock (Kenneth Grome 2000)
  41. [exclusivelock] ( Prev)
>>>What happens when a template using ExclusiveLock cannot open one of >>>the designated db's because some other template using ExclusiveLock >>>already has it locked? >> >>I would guess that since [exclusivelock] is designed to prevent >>deadlocking, it would treat the second [exclusivelock] request as a >>regular request and wait until the first [exclusivelock] is finished >>before executing it. > >This is correct.Thanks for clarification. This brings up another question:What if [exclusivelock] locks some db's, but fails to unlock them for some reason? Wouldn't that prevent all other requests to the same db's from executing until webcatalog is shut down and restarted?If so, is there some kind of timeout available to force the [exclusivelock] to end, so this will never happen? ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================############################################################# This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to Kenneth Grome

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Newbie questions (1999) how does multiple [cart] commands work? (2007) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) cart info (1998) [WebDNA] Error: Invalid JPEG file (2011) WebCat2 - [format thousands] (1997) WebCatalog f2 Installation (1997) 2.1 bugs left over from beta cycle (1998) WebDNA Solutions ... (1997) [showif] results returned... (2003) Exists? (1997) GuestBook example (1997) PSC recommends what date format yr 2000??? (1997) RE: ANother SHOWIF problem (1997) Need help... (1997) WebCatalog and WebTen (1997) Slow [spawn] (2003) strange [Shell] things / Linux.2 (2000) problems with 2 tags (1997) PROTECT PAGES (2002)