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=sinterested in this information, he has no clear answer, but he signs mypaycheck - still over the summer I will make another attempt at him forignoring this 'feel-good' information, which as you say it is, not reallyimortant.Dan, he is intersted in it semi-real-time, google analytics is at best 3-=4hours behind afaik, but again, will work on him for getting rid of this, =itis an annoyance to fiddle with this every two weeks./TommyOn 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=sinterested in this information, he has no clear answer, but he signs mypaycheck - still over the summer I will make another attempt at him forignoring this 'feel-good' information, which as you say it is, not reallyimortant.Dan, he is intersted in it semi-real-time, google analytics is at best 3-=4hours behind afaik, but again, will work on him for getting rid of this, =itis an annoyance to fiddle with this every two weeks./TommyOn 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:
Is this possible, WebCat2.0 and checkboxes (1997)
Duplicate Cart ID (2001)
Using copyfolder (2001)
using showpage and showcart commands (1996)
delete command not working (2000)
search results not sorted with 'cl' (1998)
cookies and [returnraw] (1997)
Is there a max number of fields? (1998)
Where's Cart Created ? (1997)
suggestion (1997)
Software & Sites (1998)
06/06/2000 bug warning ... (2000)
Verbose error reporting (1998)
Categories (2000)
Separate SSL Server (1997)
Test (2002)
Anyone using WebCat UNIX on a busy server yet? (1999)
WebCatalog can't find database (1997)
WebCat2: Items xx to xx shown, etc. (1997)
WebDNA vs PHP (2003)