Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106875
interpreted = N
texte = Did your system always behave with this error, or is it something new? = did you do some microsoft update, added more extensions to IIS, changed = some code, added some files? did your traffic increase? - chris On Jul 9, 2011, at 11:59, Tommy Bell wrote: > Hey Chris >=20 > Moving is simply not an option. I realize it is not a very large DB; = it only contains who is online, and so on, but what I am still wondering = is why webdna is not able to write to it. I have to explicitly tell it = from the admin panel what to do with it, and then delte the file and let = webdna make a new db whenever it decides to not be able to access it. >=20 > I guess ill have to resort to the ultimate solution and attempt = convince the man upstairs to implement a new system, in something other = than webdna. >=20 > On 09-07-2011 12:24, christophe.billiottet@webdna.us wrote: >> Hi Tommy! >>=20 >> 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. >>=20 >> - chris >>=20 >> On Jul 9, 2011, at 5:45, Tommy Bell wrote: >>=20 >>> 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 >>> 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 >> --------------------------------------------------------- >> 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:
Did your system always behave with this error, or is it something new? = did you do some microsoft update, added more extensions to IIS, changed = some code, added some files? did your traffic increase? - chris On Jul 9, 2011, at 11:59, Tommy Bell wrote: > Hey Chris >=20 > Moving is simply not an option. I realize it is not a very large DB; = it only contains who is online, and so on, but what I am still wondering = is why webdna is not able to write to it. I have to explicitly tell it = from the admin panel what to do with it, and then delte the file and let = webdna make a new db whenever it decides to not be able to access it. >=20 > I guess ill have to resort to the ultimate solution and attempt = convince the man upstairs to implement a new system, in something other = than webdna. >=20 > On 09-07-2011 12:24, christophe.billiottet@webdna.us wrote: >> Hi Tommy! >>=20 >> 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. >>=20 >> - chris >>=20 >> On Jul 9, 2011, at 5:45, Tommy Bell wrote: >>=20 >>> 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 >>> 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 >> --------------------------------------------------------- >> 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:
[format 40s]text[/format] doesn't work (1997)
Sendmail (1997)
Initiating NewCart (1997)
shipcost - fed up with the old way (1998)
Email Not Being Sent (2004)
Pull Down Search (2000)
Bit off subject -- Faxing orders (1997)
SetHeader not Working (2006)
[OT] Might be of interest... (2006)
Stopping bad HTML propagation ? (1997)
New Cart No. on same page (2003)
WebCommerce: Folder organization ? (1997)
MacAuthorize order data fields WAS:How To question... (1997)
SiteGuard Admin Feature ? (1997)
WebCatalog2 Feature Feedback (1996)
problems with WebCat-Plugin ()
WebCatalog for guestbook ? (1997)
[WebDNA] Query re: autonumber (2010)
[WebDNA] Sorry WebDNA not running message (2019)
DataBaseHelper Flawed (1997)