Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106913
interpreted = N
texte = I would tell him to "wise up" and forget about his interest in knowing how many people are online all the time -- because it serves no useful purpose except to make him feel good! Then again I'm not known for kissing asses, and I would probably get fired for talking to him like that. :) Sincerely, Kenneth Grome > Govinda, Excellent, I shall try this as soon as possible. > And yes I am using webdna 6.2 I am not sure why it has > not been updated. > > Ken, yes he is the only one that is interested in this > information, and the only one that uses it. Never the > less, he is interested in it. /Tommy > > On Mon, 11 Jul 2011 10:05:40 -0400, Govinda >
> > wrote: > > Tommy > > > > If you are using any version of webdna less than > > version 7, then please note that there is a webdna bug > > that causes [append] tags to write to > > disk, > > > even if the admin pref. has been set to not do that. > > Normally (unless the admin pref has been set to > > auto-commit) webdna just writes any new record to the > > *RAM copy* of the db.. and your disk copy > > does > > > not get updated to match the RAM copy until you do a > > [closedatabase] or [commitdatabase]. But because of > > the bug, before webdna version 7, [append] writes to > > the disk copy constantly.. meaning that appends are > > much > > > slower than they should be... > > > > The workaround for this, which I recommend you > > implement (in case you do keep the below > > 'topbanner.inc' code you posted), is to use a > > [replace...] > > > with the '&append=T' param (instead of the [append]). > > In the > > [replace...] > > > params, you just search for a record which you *know* > > will not exist - > > to > > > force the append operation... and since [replace..] > > does not have the > > same > > > bug, your operation (essentially an append, same as > > before) stays in > > RAM - > > > nice and fast. > > > > Some thing like this: > > > > replace this: > > [append > > db=[path]../../database/counter.db]DB_DATO=[date > > %Y/%m/%d]&DB_ANTAL=1[/append] > > > > ...with this: > > [Replace > > db=[path]../../database/counter.db&eqDB_DATOdatarq=dontFi > nd2ForceAppendHaveAniceDay]DB_DATO=[date > > > %Y/%m/%d]&DB_ANTAL=1[/Replace] > > > > > > ...and do the same kind of thing for the [append] to > > 'online.db' . > > > > > > I have no idea if implementing this will help your > > situation.. but it might relieve some pressure .. and > > if your issue is a phantom one > > (meaning > > > not consistent on every firing of the said problem code > > (if we even know where that problem code is)), then > > just relieving some pressure could > > give > > > you months or years of wiggle room to address the real > > deeper issue(s). > > > > - Govinda > > -------------- > > Old WebDNA talklist archives: > > http://dev.webdna.us/TalkListArchive/index.tpl?db=webdn > > a-talk > > > > > > On 2011-07-11, at 4:03 AM, > > > > wrote: > >> [snip] > >> > >> Only two places is the online.db file used. > >> > >> One is just a search with nothing else done to it. The > >> other appends or replaces in online.db I am guessing > >> this is where the problem is. > > Despite > > >> this appearing to be a windows problem, I hope someone > >> will look at > > this > > >> and perhaps comment if it is even sane to do something > >> like this. > >> > >> topbanner.inc > >> [search > >> db=[path]../../database/online.db&eqDB_IPdatarq=[IPAd > >> dress]] [showIf [numFound]=0] > >> > >> [append > > db=[path]../../database/online.db]DB_IP=[IPAddress]&DB_DA > TO=[DATE]&DB_TID=[time]&DB_URL=[url][ThisURL]?a=b[FormVar > iables][hideIf > > [name]=template]&[name]=[value][/hideIf][/FormVariables][ > /url]&DB_KUNDEID=[kunde]&DB_BROWSER=[url][browser][/url]& > DB_URL_REF=[url][REFERRER][/url][/append] > > >> [search > >> db=[path]../../database/counter.db&eqDB_DATOdata=[da > >> te %Y/%m/%d]] > >> > >> [showIf [numFound]<1] > >> > >> [append > >> db=[path]../../database/counter.db]DB_DATO=[d > >> ate > >> > >> %Y/%m/%d]&DB_ANTAL=1[/append] > >> > >> [/showIf] > >> [showIf [numFound]>0] > > [replacefoundItems]DB_ANTAL=[math][DB_ANTAL]+1[/math] [/r > eplacefoundItems] > > >> [/showIf] > >> > >> [/search] > >> > >> [/showIf] > >> [showIf [numFound]=1] > >> > >> [replace > > db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddres > s]]DB_DATO=[DATE]&DB_TID=[time]&DB_URL=[url][ThisURL]?a=b > [FormVariables][hideIf > > [name]=template]&[name]=[value][/hideIf][/FormVariables][ > /url]&DB_KUNDEID=[kunde][/replace] > > >> [/showIf] > >> [/search] > >> > >> [snip] > > > > ------------------------------------------------------- > > -- 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
Associated Messages, from the most recent to the oldest:
I would tell him to "wise up" and forget about his interest in knowing how many people are online all the time -- because it serves no useful purpose except to make him feel good! Then again I'm not known for kissing asses, and I would probably get fired for talking to him like that. :) Sincerely, Kenneth Grome > Govinda, Excellent, I shall try this as soon as possible. > And yes I am using webdna 6.2 I am not sure why it has > not been updated. > > Ken, yes he is the only one that is interested in this > information, and the only one that uses it. Never the > less, he is interested in it. /Tommy > > On Mon, 11 Jul 2011 10:05:40 -0400, Govinda > > > wrote: > > Tommy > > > > If you are using any version of webdna less than > > version 7, then please note that there is a webdna bug > > that causes [append] tags to write to > > disk, > > > even if the admin pref. has been set to not do that. > > Normally (unless the admin pref has been set to > > auto-commit) webdna just writes any new record to the > > *RAM copy* of the db.. and your disk copy > > does > > > not get updated to match the RAM copy until you do a > > [closedatabase] or [commitdatabase]. But because of > > the bug, before webdna version 7, [append] writes to > > the disk copy constantly.. meaning that appends are > > much > > > slower than they should be... > > > > The workaround for this, which I recommend you > > implement (in case you do keep the below > > 'topbanner.inc' code you posted), is to use a > > [replace...] > > > with the '&append=T' param (instead of the [append]). > > In the > > [replace...] > > > params, you just search for a record which you *know* > > will not exist - > > to > > > force the append operation... and since [replace..] > > does not have the > > same > > > bug, your operation (essentially an append, same as > > before) stays in > > RAM - > > > nice and fast. > > > > Some thing like this: > > > > replace this: > > [append > > db=[path]../../database/counter.db]DB_DATO=[date > > %Y/%m/%d]&DB_ANTAL=1[/append] > > > > ...with this: > > [Replace > > db=[path]../../database/counter.db&eqDB_DATOdatarq=dontFi > nd2ForceAppendHaveAniceDay]DB_DATO=[date > > > %Y/%m/%d]&DB_ANTAL=1[/Replace] > > > > > > ...and do the same kind of thing for the [append] to > > 'online.db' . > > > > > > I have no idea if implementing this will help your > > situation.. but it might relieve some pressure .. and > > if your issue is a phantom one > > (meaning > > > not consistent on every firing of the said problem code > > (if we even know where that problem code is)), then > > just relieving some pressure could > > give > > > you months or years of wiggle room to address the real > > deeper issue(s). > > > > - Govinda > > -------------- > > Old WebDNA talklist archives: > > http://dev.webdna.us/TalkListArchive/index.tpl?db=webdn > > a-talk > > > > > > On 2011-07-11, at 4:03 AM, > > > > wrote: > >> [snip] > >> > >> Only two places is the online.db file used. > >> > >> One is just a search with nothing else done to it. The > >> other appends or replaces in online.db I am guessing > >> this is where the problem is. > > Despite > > >> this appearing to be a windows problem, I hope someone > >> will look at > > this > > >> and perhaps comment if it is even sane to do something > >> like this. > >> > >> topbanner.inc > >> [search > >> db=[path]../../database/online.db&eqDB_IPdatarq=[IPAd > >> dress]] [showIf [numFound]=0] > >> > >> [append > > db=[path]../../database/online.db]DB_IP=[ipaddress]&DB_DA > TO=[date]&DB_TID=[time]&DB_URL=[url][thisurl]?a=b[FormVar > iables][hideIf > > [name]=template]&[name]=[value][/hideIf][/FormVariables][ > /url]&DB_KUNDEID=[kunde]&DB_BROWSER=[url][browser][/url]& > DB_URL_REF=[url][referrer][/url][/append] > > >> [search > >> db=[path]../../database/counter.db&eqDB_DATOdata=[da > >> te %Y/%m/%d]] > >> > >> [showIf [numFound]<1] > >> > >> [append > >> db=[path]../../database/counter.db]DB_DATO=[d > >> ate > >> > >> %Y/%m/%d]&DB_ANTAL=1[/append] > >> > >> [/showIf] > >> [showIf [numFound]>0] > > [replacefounditems]DB_ANTAL=[math][DB_ANTAL]+1[/math] [/r > eplacefoundItems] > > >> [/showIf] > >> > >> [/search] > >> > >> [/showIf] > >> [showIf [numFound]=1] > >> > >> [replace > > db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddres > s]]DB_DATO=[date]&DB_TID=[time]&DB_URL=[url][thisurl]?a=b > [formvariables][hideIf > > [name]=template]&[name]=[value][/hideIf][/FormVariables][ > /url]&DB_KUNDEID=[kunde][/replace] > > >> [/showIf] > >> [/search] > >> > >> [snip] > > > > ------------------------------------------------------- > > -- 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
Kenneth Grome
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:
Show only certain items (2002)
WebCat Refrence problem (2000)
Separate SSL Server (1997)
Protect (1997)
For those of you not on the WebCatalog Beta... (1997)
.. more on sliding discounts... (1997)
Re:no [search] with NT (1997)
Photo Album (2000)
2 easy questions re: [showif] and [sendmail] (1997)
Here's how to kill a Butler Database. (1997)
Forbidden CGI Error (1997)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
Frames and WebCat (1997)
RE:It just Does't add up!!! (1997)
cookies ok ??? (2006)
v6 Development copy download link seems to be offline? (2004)
problems with 2 tags (1997)
WebCatalog can't find database (1997)
Goofy Date Sorting (1998)
WebDNA Quick Reference (Reserved Words) (2000)