Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106873
interpreted = N
texte = 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, = particularely as a server, and the experiences we have had in the past = with windows have always ended up with troubles (attacks, virii, SQL = problem, corruption, cryptic errors etc...). Note that i have never run = WebDNA on a production 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, >=20 > 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 = templates, and it being able to distingish when it can access and write, = on a related note. > In the admin section, under show databases, I can see it uses almost = 26mb 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 = and 26 mb, I am guessing this is the cache for it, but it somehow cant = figure out how to commit the changes to the online.db file, because = another process is using it. >=20 > 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 = problems 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. >=20 >=20 > On 09-07-2011 02:00, Govinda wrote: >> Chris, >>=20 >> I am not sure what you are saying. >>=20 >> ..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? >>=20 >> I thought the below error would only occur when [ExclusiveLock...] = failed to get an ExclusiveLock. (?) >>=20 >> Tommy, >> does your code anywhere use [ExclusiveLock...]? >>=20 >> -Govinda >>=20 >> On 2011-07-08, at 3:59 PM, christophe.billiottet@webdna.us wrote: >>=20 >>> 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 >>>> "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 >>=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 >=20 >=20 > --=20 > Med Venlig Hilsen > Tommy Dahlb=E6k Bell >=20 > Tlf: +45 27 63 00 88 >=20 > E-mail: tbell05@student.aau.dk > E-mail: tommy@enkelthed.dk >=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:
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, = particularely as a server, and the experiences we have had in the past = with windows have always ended up with troubles (attacks, virii, SQL = problem, corruption, cryptic errors etc...). Note that i have never run = WebDNA on a production 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, >=20 > 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 = templates, and it being able to distingish when it can access and write, = on a related note. > In the admin section, under show databases, I can see it uses almost = 26mb 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 = and 26 mb, I am guessing this is the cache for it, but it somehow cant = figure out how to commit the changes to the online.db file, because = another process is using it. >=20 > 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 = problems 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. >=20 >=20 > On 09-07-2011 02:00, Govinda wrote: >> Chris, >>=20 >> I am not sure what you are saying. >>=20 >> ..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? >>=20 >> I thought the below error would only occur when [ExclusiveLock...] = failed to get an ExclusiveLock. (?) >>=20 >> Tommy, >> does your code anywhere use [ExclusiveLock...]? >>=20 >> -Govinda >>=20 >> On 2011-07-08, at 3:59 PM, christophe.billiottet@webdna.us wrote: >>=20 >>> 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 >>>> "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 >>=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 >=20 >=20 > --=20 > Med Venlig Hilsen > Tommy Dahlb=E6k Bell >=20 > Tlf: +45 27 63 00 88 >=20 > E-mail: tbell05@student.aau.dk > E-mail: tommy@enkelthed.dk >=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:
[shownext max=?] armed (1997)
encryption in browser? (1998)
japanese characters (1997)
Questions To Answer (1997)
About Include (2001)
$Quit, $CloseDatabase corrections (1997)
Combining Searches (1998)
Showif, Hideif reverse logic ? (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Web Cat and MS SQL 6.5 (1999)
Open Databases on Restart (1999)
Need relative path explanation (1997)
Encrypted Databases (2000)
AOL and referrers on target=_blank (2000)
Searching for (field1 OR field2) AND field3 (2000)
Windows Install issue (2003)
Help w/ Duplicating The General Store 5 times. (1997)
$append (1998)
OK, here goes... (1997)
Date Help (2004)