Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106914
interpreted = N
texte = Ken, He is quite pigheaded, I've spoken to him repeatedly, about why he i= s interested in this information, he has no clear answer, but he signs my paycheck - still over the summer I will make another attempt at him for ignoring this 'feel-good' information, which as you say it is, not really imortant. Dan, he is intersted in it semi-real-time, google analytics is at best 3-= 4 hours behind afaik, but again, will work on him for getting rid of this, = it is an annoyance to fiddle with this every two weeks. /Tommy On Mon, 11 Jul 2011 09:13:22 -0500, Kenneth Grome
wrote: > I would tell him to "wise up" and forget about his interest=20 > in knowing how many people are online all the time --=20 > because it serves no useful purpose except to make him feel=20 > good! >=20 > Then again I'm not known for kissing asses, and I would=20 > probably get fired for talking to him like that. >=20 > :) >=20 > Sincerely, > Kenneth Grome >=20 >=20 >=20 >> 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. >>=20 >> 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 >>=20 >> On Mon, 11 Jul 2011 10:05:40 -0400, Govinda >> >>=20 >> wrote: >> > Tommy >> >=20 >> > 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 >>=20 >> disk, >>=20 >> > 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 >>=20 >> does >>=20 >> > 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 >>=20 >> much >>=20 >> > slower than they should be... >> >=20 >> > 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 >>=20 >> [replace...] >>=20 >> > with the '&append=3DT' param (instead of the [append]).=20 >> > In the >>=20 >> [replace...] >>=20 >> > params, you just search for a record which you *know* >> > will not exist - >>=20 >> to >>=20 >> > force the append operation... and since [replace..] >> > does not have the >>=20 >> same >>=20 >> > bug, your operation (essentially an append, same as >> > before) stays in >>=20 >> RAM - >>=20 >> > nice and fast. >> >=20 >> > Some thing like this: >> >=20 >> > replace this: >> > [append >> > db=3D[path]../../database/counter.db]DB_DATO=3D[date >> > %Y/%m/%d]&DB_ANTAL=3D1[/append] >> >=20 >> > ...with this: >> > [Replace >>=20 >> db=3D[path]../../database/counter.db&eqDB_DATOdatarq=3DdontFi >> nd2ForceAppendHaveAniceDay]DB_DATO=3D[date >>=20 >> > %Y/%m/%d]&DB_ANTAL=3D1[/Replace] >> >=20 >> >=20 >> > ...and do the same kind of thing for the [append] to >> > 'online.db' . >> >=20 >> >=20 >> > 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 >>=20 >> (meaning >>=20 >> > 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 >>=20 >> give >>=20 >> > you months or years of wiggle room to address the real >> > deeper issue(s). >> >=20 >> > - Govinda >> > -------------- >> > Old WebDNA talklist archives: >> > http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdn >> > a-talk >> >=20 >> >=20 >> > On 2011-07-11, at 4:03 AM, >> > >>=20 >> wrote: >> >> [snip] >> >>=20 >> >> Only two places is the online.db file used. >> >>=20 >> >> 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. >>=20 >> Despite >>=20 >> >> this appearing to be a windows problem, I hope someone >> >> will look at >>=20 >> this >>=20 >> >> and perhaps comment if it is even sane to do something >> >> like this. >> >>=20 >> >> topbanner.inc >> >> [search >> >> db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAd >> >> dress]] [showIf [numFound]=3D0] >> >>=20 >> >> [append >>=20 >> db=3D[path]../../database/online.db]DB_IP=3D[IPAddress]&DB_DA >> TO=3D[DATE]&DB_TID=3D[time]&DB_URL=3D[url][ThisURL]?a=3Db[FormVar >> iables][hideIf >>=20 >> [name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][ >> /url]&DB_KUNDEID=3D[kunde]&DB_BROWSER=3D[url][browser][/url]& >> DB_URL_REF=3D[url][REFERRER][/url][/append] >>=20 >> >> [search >> >>=20 > db=3D[path]../../database/counter.db&eqDB_DATOdata=3D[da >> >> te %Y/%m/%d]] >> >>=20 >> >> [showIf [numFound]<1] >> >> =20 >> >> [append >> >> =20 > db=3D[path]../../database/counter.db]DB_DATO=3D[d >> >> ate >> >>=20 >> >> %Y/%m/%d]&DB_ANTAL=3D1[/append] >> >>=20 >> >> [/showIf] >> >> [showIf [numFound]>0] >>=20 >> [replacefoundItems]DB_ANTAL=3D[math][DB_ANTAL]+1[/math] > [/r >> eplacefoundItems] >>=20 >> >> [/showIf] >> >> =20 >> >> [/search] >> >>=20 >> >> [/showIf] >> >> [showIf [numFound]=3D1] >> >>=20 >> >> [replace >>=20 >> db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAddres >> s]]DB_DATO=3D[DATE]&DB_TID=3D[time]&DB_URL=3D[url][ThisURL]?a=3Db >> [FormVariables][hideIf >>=20 >> [name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][ >> /url]&DB_KUNDEID=3D[kunde][/replace] >>=20 >> >> [/showIf] >> >> [/search] >> >>=20 >> >> [snip] >> >=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 >> --------------------------------------------------------- >> 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:
Ken, He is quite pigheaded, I've spoken to him repeatedly, about why he i= s interested in this information, he has no clear answer, but he signs my paycheck - still over the summer I will make another attempt at him for ignoring this 'feel-good' information, which as you say it is, not really imortant. Dan, he is intersted in it semi-real-time, google analytics is at best 3-= 4 hours behind afaik, but again, will work on him for getting rid of this, = it is an annoyance to fiddle with this every two weeks. /Tommy On Mon, 11 Jul 2011 09:13:22 -0500, Kenneth Grome wrote: > I would tell him to "wise up" and forget about his interest=20 > in knowing how many people are online all the time --=20 > because it serves no useful purpose except to make him feel=20 > good! >=20 > Then again I'm not known for kissing asses, and I would=20 > probably get fired for talking to him like that. >=20 > :) >=20 > Sincerely, > Kenneth Grome >=20 >=20 >=20 >> 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. >>=20 >> 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 >>=20 >> On Mon, 11 Jul 2011 10:05:40 -0400, Govinda >> >>=20 >> wrote: >> > Tommy >> >=20 >> > 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 >>=20 >> disk, >>=20 >> > 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 >>=20 >> does >>=20 >> > 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 >>=20 >> much >>=20 >> > slower than they should be... >> >=20 >> > 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 >>=20 >> [replace...] >>=20 >> > with the '&append=3DT' param (instead of the [append]).=20 >> > In the >>=20 >> [replace...] >>=20 >> > params, you just search for a record which you *know* >> > will not exist - >>=20 >> to >>=20 >> > force the append operation... and since [replace..] >> > does not have the >>=20 >> same >>=20 >> > bug, your operation (essentially an append, same as >> > before) stays in >>=20 >> RAM - >>=20 >> > nice and fast. >> >=20 >> > Some thing like this: >> >=20 >> > replace this: >> > [append >> > db=3D[path]../../database/counter.db]DB_DATO=3D[date >> > %Y/%m/%d]&DB_ANTAL=3D1[/append] >> >=20 >> > ...with this: >> > [Replace >>=20 >> db=3D[path]../../database/counter.db&eqDB_DATOdatarq=3DdontFi >> nd2ForceAppendHaveAniceDay]DB_DATO=3D[date >>=20 >> > %Y/%m/%d]&DB_ANTAL=3D1[/Replace] >> >=20 >> >=20 >> > ...and do the same kind of thing for the [append] to >> > 'online.db' . >> >=20 >> >=20 >> > 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 >>=20 >> (meaning >>=20 >> > 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 >>=20 >> give >>=20 >> > you months or years of wiggle room to address the real >> > deeper issue(s). >> >=20 >> > - Govinda >> > -------------- >> > Old WebDNA talklist archives: >> > http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdn >> > a-talk >> >=20 >> >=20 >> > On 2011-07-11, at 4:03 AM, >> > >>=20 >> wrote: >> >> [snip] >> >>=20 >> >> Only two places is the online.db file used. >> >>=20 >> >> 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. >>=20 >> Despite >>=20 >> >> this appearing to be a windows problem, I hope someone >> >> will look at >>=20 >> this >>=20 >> >> and perhaps comment if it is even sane to do something >> >> like this. >> >>=20 >> >> topbanner.inc >> >> [search >> >> db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAd >> >> dress]] [showIf [numFound]=3D0] >> >>=20 >> >> [append >>=20 >> db=3D[path]../../database/online.db]DB_IP=3D[ipaddress]&DB_DA >> TO=3D[date]&DB_TID=3D[time]&DB_URL=3D[url][thisurl]?a=3Db[FormVar >> iables][hideIf >>=20 >> [name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][ >> /url]&DB_KUNDEID=3D[kunde]&DB_BROWSER=3D[url][browser][/url]& >> DB_URL_REF=3D[url][referrer][/url][/append] >>=20 >> >> [search >> >>=20 > db=3D[path]../../database/counter.db&eqDB_DATOdata=3D[da >> >> te %Y/%m/%d]] >> >>=20 >> >> [showIf [numFound]<1] >> >> =20 >> >> [append >> >> =20 > db=3D[path]../../database/counter.db]DB_DATO=3D[d >> >> ate >> >>=20 >> >> %Y/%m/%d]&DB_ANTAL=3D1[/append] >> >>=20 >> >> [/showIf] >> >> [showIf [numFound]>0] >>=20 >> [replacefounditems]DB_ANTAL=3D[math][DB_ANTAL]+1[/math] > [/r >> eplacefoundItems] >>=20 >> >> [/showIf] >> >> =20 >> >> [/search] >> >>=20 >> >> [/showIf] >> >> [showIf [numFound]=3D1] >> >>=20 >> >> [replace >>=20 >> db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAddres >> s]]DB_DATO=3D[date]&DB_TID=3D[time]&DB_URL=3D[url][thisurl]?a=3Db >> [formvariables][hideIf >>=20 >> [name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][ >> /url]&DB_KUNDEID=3D[kunde][/replace] >>=20 >> >> [/showIf] >> >> [/search] >> >>=20 >> >> [snip] >> >=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 >> --------------------------------------------------------- >> 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
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:
trouble updating records in database (1998)
Need help with emailer- 2 issues (1997)
2 questions (2000)
Add (1998)
RAM to disk (2002)
So what ya working on? (or have you completed?) (2004)
WCS Newbie question (1997)
OT: really big site on xserve (2003)
Using Applescript to process WebCatalog functions (1998)
I can help! (1996)
re: Large Database Options? (1999)
All choices on IE different than Netscape (1997)
My slower response (1997)
Range search (2003)
Need Sample Template - just purchased (1997)
my price won't move (1997)
Searching for a Blank Field (2000)
Country & Ship-to address & other fields ? (1997)
Math with Time (1997)
Extended [ConvertChars] (1997)