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

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106889
interpreted = N
texte = We did. This might happens if Windows locks a file that WebDNA is trying = to write to, or if there are multiple instances of WebDNA running and = trying to write to a single database. I do not think the multiple = instance case is the problem here. WebDNA spits out an error first = before deadlocking. This is why i think we need to know why Windows = would lock a WebDNA database, and why this happens suddenly (and = regularely) after years of error-free service. If this comes from = WebDNA, a reinstall would solve the problem. In this case, i believe = Windows (an update, a specific module or extension) is to blame. - chris On Jul 10, 2011, at 19:52, Stuart Tremain wrote: > Very strange that this problem is happening to another Windows Server = user. I reported the same problem last week on a system that has been = running for 5+ years and have NEVER seen the problem in 12+ years of = WebDNA experience. >=20 > The problem tends to create a loop and brings the server to a grinding = halt by constantly using 100% of CPU. >=20 > After reading the many rants in this thread I do suspect that it MAY = be a Windows problem brought about from a Windows update. >=20 > "Failed to aquire lock on database - Possible deadlock averted" >=20 > The error that is being published in the errorlog.txt does not come = from the errormessages.db so must be coming from the WebDNA engine = itself. >=20 > Chris, maybe you could look into this please. >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 07/07/2011, at 5:10 AM, 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 >>=20 >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us 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)
We did. This might happens if Windows locks a file that WebDNA is trying = to write to, or if there are multiple instances of WebDNA running and = trying to write to a single database. I do not think the multiple = instance case is the problem here. WebDNA spits out an error first = before deadlocking. This is why i think we need to know why Windows = would lock a WebDNA database, and why this happens suddenly (and = regularely) after years of error-free service. If this comes from = WebDNA, a reinstall would solve the problem. In this case, i believe = Windows (an update, a specific module or extension) is to blame. - chris On Jul 10, 2011, at 19:52, Stuart Tremain wrote: > Very strange that this problem is happening to another Windows Server = user. I reported the same problem last week on a system that has been = running for 5+ years and have NEVER seen the problem in 12+ years of = WebDNA experience. >=20 > The problem tends to create a loop and brings the server to a grinding = halt by constantly using 100% of CPU. >=20 > After reading the many rants in this thread I do suspect that it MAY = be a Windows problem brought about from a Windows update. >=20 > "Failed to aquire lock on database - Possible deadlock averted" >=20 > The error that is being published in the errorlog.txt does not come = from the errormessages.db so must be coming from the WebDNA engine = itself. >=20 > Chris, maybe you could look into this please. >=20 >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 07/07/2011, at 5:10 AM, 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 >>=20 >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us christophe.billiottet@webdna.us

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:

Reversed words (1997) WebCatalog can't find database (1997) typhoon vs. webcatalog (1997) Press Release hit the NewsWire!!! (1997) [WebDNA] Digest Mode (2008) $Replace with [founditems] (1997) Forbidden CGI Error (1997) Sendmail truncation in Eudora Clients (1998) [OT] (waaaay OT) (2004) Discount solution? (1998) Payflow Pro on OSX (2003) Summing fields (1997) show all problem (1997) Listserver problem (1997) Re:Emailer and encryption (1997) OT bookmark my site (1999) PCS Frames (1997) problems with 2 tags shakur (1997) Appending Information from one db to another (1998) using showpage and showcart commands (1996)