Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106874
interpreted = N
texte = Hey Chris Moving is simply not an option. I realize it is not a very large DB; it=20 only contains who is online, and so on, but what I am still wondering is=20 why webdna is not able to write to it. I have to explicitly tell it from=20 the admin panel what to do with it, and then delte the file and let=20 webdna make a new db whenever it decides to not be able to access it. I guess ill have to resort to the ultimate solution and attempt convince=20 the man upstairs to implement a new system, in something other than webdn= a. On 09-07-2011 12:24, christophe.billiottet@webdna.us wrote: > Hi Tommy! > > 26mb is by no mean a large database and you should not have any problem= with it. I am unfamiliar with windows because i try to avoid it, particu= larely as a server, and the experiences we have had in the past with wind= ows have always ended up with troubles (attacks, virii, SQL problem, corr= uption, cryptic errors etc...). Note that i have never run WebDNA on a pr= oduction windows server; if i were you, i would try to move my website to= a linux system. > > - chris > > On Jul 9, 2011, at 5:45, Tommy Bell wrote: > >> Govinda, >> >> no I dont use exclusive lock at all - in fact the way i understand the= documentation, I expect it to work when I include the code in my templat= es, and it being able to distingish when it can access and write, on a re= lated note. >> In the admin section, under show databases, I can see it uses almost 2= 6mb of ram, which is about the same size as the online.db file - there is= also an online.db.tmp file, which is constantly fluctuating between 0 an= d 26 mb, I am guessing this is the cache for it, but it somehow cant figu= re out how to commit the changes to the online.db file, because another p= rocess is using it. >> >> Chris, >> yes it is doing this, even when there is not heavy load - our visitor = numbers have dropped significantly, we explain it by the myriad of proble= ms we've been having with webdna, I inherited this system, and I doubt 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 cours= e does not make sense; as if we have to [closedatabase..] before every wr= ite operation? >>> >>> I thought the below error would only occur when [ExclusiveLock...] fa= iled 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 = has gotten much worse, I was hoping someone could enlighten me to where t= o go bug hunting, or just offer some tips with regards to what I could be= doing 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 >>> >> >> --=20 >> Med Venlig Hilsen >> Tommy Dahlb=E6k Bell >> >> Tlf: +45 27 63 00 88 >> >> E-mail: tbell05@student.aau.dk >> E-mail: tommy@enkelthed.dk >> >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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 Med Venlig Hilsen Tommy Dahlb=E6k Bell Tlf: +45 27 63 00 88 E-mail: tbell05@student.aau.dk E-mail: tommy@enkelthed.dk
Associated Messages, from the most recent to the oldest:
Hey Chris Moving is simply not an option. I realize it is not a very large DB; it=20 only contains who is online, and so on, but what I am still wondering is=20 why webdna is not able to write to it. I have to explicitly tell it from=20 the admin panel what to do with it, and then delte the file and let=20 webdna make a new db whenever it decides to not be able to access it. I guess ill have to resort to the ultimate solution and attempt convince=20 the man upstairs to implement a new system, in something other than webdn= a. On 09-07-2011 12:24, christophe.billiottet@webdna.us wrote: > Hi Tommy! > > 26mb is by no mean a large database and you should not have any problem= with it. I am unfamiliar with windows because i try to avoid it, particu= larely as a server, and the experiences we have had in the past with wind= ows have always ended up with troubles (attacks, virii, SQL problem, corr= uption, cryptic errors etc...). Note that i have never run WebDNA on a pr= oduction windows server; if i were you, i would try to move my website to= a linux system. > > - chris > > On Jul 9, 2011, at 5:45, Tommy Bell wrote: > >> Govinda, >> >> no I dont use exclusive lock at all - in fact the way i understand the= documentation, I expect it to work when I include the code in my templat= es, and it being able to distingish when it can access and write, on a re= lated note. >> In the admin section, under show databases, I can see it uses almost 2= 6mb of ram, which is about the same size as the online.db file - there is= also an online.db.tmp file, which is constantly fluctuating between 0 an= d 26 mb, I am guessing this is the cache for it, but it somehow cant figu= re out how to commit the changes to the online.db file, because another p= rocess is using it. >> >> Chris, >> yes it is doing this, even when there is not heavy load - our visitor = numbers have dropped significantly, we explain it by the myriad of proble= ms we've been having with webdna, I inherited this system, and I doubt 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 cours= e does not make sense; as if we have to [closedatabase..] before every wr= ite operation? >>> >>> I thought the below error would only occur when [ExclusiveLock...] fa= iled 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 = has gotten much worse, I was hoping someone could enlighten me to where t= o go bug hunting, or just offer some tips with regards to what I could be= doing 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 >>> >> >> --=20 >> Med Venlig Hilsen >> Tommy Dahlb=E6k Bell >> >> Tlf: +45 27 63 00 88 >> >> E-mail: tbell05@student.aau.dk >> E-mail: tommy@enkelthed.dk >> >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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 Med Venlig Hilsen Tommy Dahlb=E6k Bell Tlf: +45 27 63 00 88 E-mail: tbell05@student.aau.dk E-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:
user selectable sort order (2000)
Web Developer Product Awards (1997)
What file? (1997)
Nested tags count question (1997)
Cancel Subscription (1996)
WCS Newbie question (1997)
WebDNA 6 (2004)
Date Time Oddness (1999)
[SearchString] problem with [search] context (1997)
I have observed and I am gone. (1998)
Header info in content (1998)
Textarea Breaks (2000)
updating checkbox in a db (1998)
Progress !! WAS: Trouble with formula.db (1997)
[WebDNA] WebDNA Hosting (2008)
Purchased cart being overwritten - still !?? (1997)
Applescript, WebDNA, and PDF (1997)
Quit revisited (1997)
If Else Statement... (2004)
multi-paragraph fields (1997)