Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106872
interpreted = N
texte = Govinda,no I dont use exclusive lock at all - in fact the way i understand the=20documentation, I expect it to work when I include the code in my=20templates, and it being able to distingish when it can access and write,=20on a related note.In the admin section, under show databases, I can see it uses almost=2026mb of ram, which is about the same size as the online.db file - there=20is also an online.db.tmp file, which is constantly fluctuating between 0=20and 26 mb, I am guessing this is the cache for it, but it somehow cant=20figure out how to commit the changes to the online.db file, because=20another process is using it.Chris,yes it is doing this, even when there is not heavy load - our visitor=20numbers have dropped significantly, we explain it by the myriad of=20problems we've been having with webdna, I inherited this system, and I=20doubt it webdna, was ever meant to run such a complex and large system.On 09-07-2011 02:00, Govinda wrote:> Chris,>> 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 writ=e operation?>> I thought the below error would only occur when [ExclusiveLock...] fail=ed to get an ExclusiveLock. (?)>> Tommy,> 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?>>>> - chris>>>>>>>> On Jul 6, 2011, at 16:10, Tommy Bell wrote:>>>>> Hello everyone, a few days ago a post was made about>>> "Failed to aquire lock on database">>>>>> I have been experiencing this for quite some time, and recently it ha=s 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 d=oing wrong.>>>>>> 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>>>>>> /Tommy> - Govinda> --------------> Old WebDNA talklist archives:> http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk>> ---------------------------------------------------------> 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>--=20Med Venlig HilsenTommy Dahlb=E6k BellTlf: +45 27 63 00 88E-mail: tbell05@student.aau.dkE-mail: tommy@enkelthed.dk
Associated Messages, from the most recent to the oldest:
Govinda,no I dont use exclusive lock at all - in fact the way i understand the=20documentation, I expect it to work when I include the code in my=20templates, and it being able to distingish when it can access and write,=20on a related note.In the admin section, under show databases, I can see it uses almost=2026mb of ram, which is about the same size as the online.db file - there=20is also an online.db.tmp file, which is constantly fluctuating between 0=20and 26 mb, I am guessing this is the cache for it, but it somehow cant=20figure out how to commit the changes to the online.db file, because=20another process is using it.Chris,yes it is doing this, even when there is not heavy load - our visitor=20numbers have dropped significantly, we explain it by the myriad of=20problems we've been having with webdna, I inherited this system, and I=20doubt it webdna, was ever meant to run such a complex and large system.On 09-07-2011 02:00, Govinda wrote:> Chris,>> 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 writ=e operation?>> I thought the below error would only occur when [ExclusiveLock...] fail=ed to get an ExclusiveLock. (?)>> Tommy,> 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?>>>> - chris>>>>>>>> On Jul 6, 2011, at 16:10, Tommy Bell wrote:>>>>> Hello everyone, a few days ago a post was made about>>> "Failed to aquire lock on database">>>>>> I have been experiencing this for quite some time, and recently it ha=s 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 d=oing wrong.>>>>>> 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>>>>>> /Tommy> - Govinda> --------------> Old WebDNA talklist archives:> http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk>> ---------------------------------------------------------> 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>--=20Med Venlig HilsenTommy Dahlb=E6k BellTlf: +45 27 63 00 88E-mail: tbell05@student.aau.dkE-mail: tommy@enkelthed.dk
Tommy Bell
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:
[WebDNA] Middle Question (2015)
[WebDNA] Double sendmails (2014)
Not really WebCat (1997)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)
RAM to disk - well correction. (2002)
upgrade? (1997)
RE: strip .0 off off IPaddress (1998)
Conveting Characters to Graphics (1997)
Strange errors in error log (1998)
PCS Frames (1997)
[WebDNA] Mail and SPF (2011)
WebCatalog Technical Reference (1997)
Purchased cart being overwritten (1997)
Search design (1997)
WebCat2.0 [format thousands .0f] no go (1997)
WebCatalog for guestbook ? (1997)
Exclamation point (1997)
Navigator 4.01 (1997)
WebCatalog NT beta 18 now available (1997)