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:
Date problems-more (1997)
installing webcatalog problem. HELP! (1998)
Nested [xxx] contexts & Bad Suffix (1998)
Archives (2001)
REPLACE & MAX/STARTAT parameters doesn't work? (2000)
Auto conversion of URLs? (1998)
2nd WebCatalog2 Feature Request (1996)
Problem with updating 2.1b7 -> 2.1.1 (1998)
WebCatalog Plug-in for Webstar. (1997)
Problem (1997)
Upgrading old WebCat Database Files (1997)
woops - speed results - right subject (2002)
Running _every_ page through WebCat ? (1997)
Erotic Sites (1997)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
suffix mapping for NT? (1997)
passing variables - problem (1997)
Reminder for beta testers (2000)
Associative lookup style? + bit more (1997)
[OT] Colored source code in IE? (2007)