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,=20I 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,=20does your code anywhere use [ExclusiveLock...]?-GovindaOn 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:
Chris,=20I 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,=20does your code anywhere use [ExclusiveLock...]?-GovindaOn 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)