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=20 documentation, I expect it to work when I include the code in my=20 templates, and it being able to distingish when it can access and write,=20 on a related note. In the admin section, under show databases, I can see it uses almost=20 26mb of ram, which is about the same size as the online.db file - there=20 is also an online.db.tmp file, which is constantly fluctuating between 0=20 and 26 mb, I am guessing this is the cache for it, but it somehow cant=20 figure out how to commit the changes to the online.db file, because=20 another process is using it. Chris, yes it is doing this, even when there is not heavy load - our visitor=20 numbers have dropped significantly, we explain it by the myriad of=20 problems we've been having with webdna, I inherited this system, and I=20 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 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 > --=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:
Govinda, no I dont use exclusive lock at all - in fact the way i understand the=20 documentation, I expect it to work when I include the code in my=20 templates, and it being able to distingish when it can access and write,=20 on a related note. In the admin section, under show databases, I can see it uses almost=20 26mb of ram, which is about the same size as the online.db file - there=20 is also an online.db.tmp file, which is constantly fluctuating between 0=20 and 26 mb, I am guessing this is the cache for it, but it somehow cant=20 figure out how to commit the changes to the online.db file, because=20 another process is using it. Chris, yes it is doing this, even when there is not heavy load - our visitor=20 numbers have dropped significantly, we explain it by the myriad of=20 problems we've been having with webdna, I inherited this system, and I=20 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 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 > --=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:
If Empty ? (1997)
WebCatalog can't find database (1997)
Browser Problem?!? NN 4.0+ and Browser Info.txt? (1997)
[OT] Am I an Idiot? (2004)
Help name our technology! (1997)
[WebDNA] sem_open bugfix for os x version 6.2 (2012)
A few questions. . . (1997)
Can you do this??? and other stuff (1997)
Using [Include] Context (1999)
Protect (1997)
suffix mapping for NT? (1997)
b12 cannot limit records returned and more. (1997)
[off] Promotions Co? (1997)
Weird error/limit - something amiss? (1997)
Another question (1997)
WebDNA and FTP (2003)
send mail problem? (1997)
[showif] and equality (1998)
[WebDNA] [BULK] which of these tags exist in 7.0 (2011)
Summing fields (1997)