Re: [WebDNA] An unknown error occured // Deadlock avoided

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106871
interpreted = N
texte = Chris,=20 I am not sure what you are saying. ..that one cannot write to a db if it is already open? That of course = does not make sense; as if we have to [closedatabase..] before every = write operation? I thought the below error would only occur when [ExclusiveLock...] = failed to get an ExclusiveLock. (?) Tommy,=20 does your code anywhere use [ExclusiveLock...]? -Govinda On 2011-07-08, at 3:59 PM, christophe.billiottet@webdna.us wrote: > The lock might happens on Windows when WebDNA is trying to write to a = database that is already written to. Are you reopening a database that = is already opened? Does it only deadlock under heavy traffic to the = site? >=20 > - chris >=20 >=20 >=20 > On Jul 6, 2011, at 16:10, Tommy Bell wrote: >=20 >> Hello everyone, a few days ago a post was made about=20 >> "Failed to aquire lock on database" >>=20 >> I have been experiencing this for quite some time, and recently it = has gotten much worse, I was hoping someone could enlighten me to where = to go bug hunting, or just offer some tips with regards to what I could = be doing wrong. >>=20 >> This is the error i get (One amongst many db's, not just online.db) >> An unknown error occurred: >> DBError >> ../../database/online.db >> Failed to aquire lock on database - Possible deadlock averted >>=20 >> /Tommy - Govinda -------------- Old WebDNA talklist archives: http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] An unknown error occured // Deadlock avoided (Stuart Tremain 2011)
  2. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  3. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  4. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  5. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  6. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  7. Re: [WebDNA] An unknown error occured // Deadlock avoided (Govinda 2011)
  8. Re: [WebDNA] An unknown error occured // Deadlock avoided (Paul Willis 2011)
  9. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  10. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  11. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  12. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  13. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  14. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  15. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  16. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  17. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  18. Re: [WebDNA] An unknown error occured // Deadlock avoided (Govinda 2011)
  19. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  20. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  21. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  22. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  23. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  24. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  25. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  26. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  27. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  28. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  29. Re: [WebDNA] An unknown error occured // Deadlock avoided (Stuart Tremain 2011)
  30. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  31. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  32. Re: [WebDNA] An unknown error occured // Deadlock avoided (Stuart Tremain 2011)
  33. RE: [WebDNA] An unknown error occured // Deadlock avoided ("Terry Nair" 2011)
  34. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  35. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  36. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  37. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  38. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  39. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  40. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  41. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  42. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  43. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  44. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  45. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  46. Re: [WebDNA] An unknown error occured // Deadlock avoided (Govinda 2011)
  47. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  48. [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
Chris,=20 I am not sure what you are saying. ..that one cannot write to a db if it is already open? That of course = does not make sense; as if we have to [closedatabase..] before every = write operation? I thought the below error would only occur when [ExclusiveLock...] = failed to get an ExclusiveLock. (?) Tommy,=20 does your code anywhere use [ExclusiveLock...]? -Govinda On 2011-07-08, at 3:59 PM, christophe.billiottet@webdna.us wrote: > The lock might happens on Windows when WebDNA is trying to write to a = database that is already written to. Are you reopening a database that = is already opened? Does it only deadlock under heavy traffic to the = site? >=20 > - chris >=20 >=20 >=20 > On Jul 6, 2011, at 16:10, Tommy Bell wrote: >=20 >> Hello everyone, a few days ago a post was made about=20 >> "Failed to aquire lock on database" >>=20 >> I have been experiencing this for quite some time, and recently it = has gotten much worse, I was hoping someone could enlighten me to where = to go bug hunting, or just offer some tips with regards to what I could = be doing wrong. >>=20 >> This is the error i get (One amongst many db's, not just online.db) >> An unknown error occurred: >> DBError >> ../../database/online.db >> Failed to aquire lock on database - Possible deadlock averted >>=20 >> /Tommy - Govinda -------------- Old WebDNA talklist archives: http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk Govinda

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:

quantity [addlineitem] (2001) [subtotal] and others (1997) WebCat b15 Mac plug-in (1997) WebCat2.0b15-to many nested [xx] tags (1997) Auction made in webcat (2000) Different Tax levels (1998) BIG PROBLEMS with Checkboxes!!! (1998) more info on [setlineitems] (1997) New WebCatalog Version !!! (1997) problems with dos and tracert + webDNA (1998) [WebDNA] Date/time server vs. browser (2015) WebMerchant & CC Response (2002) thisurl & arguments (2000) Opinion: [input] should be called [output] ... (1997) searchable list archive (1997) Math Function (1997) Country & Ship-to address & other fields ? (1997) FEATURE REQUEST: (was: Summarizing results. Is there a (1999) [WebDNA] Send Mail and Outlook Express (2008) db security on NT (1997)