Re: Busy WebCatalog

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 32767
interpreted = N
texte = I am experiencing these as well. I am attempting to rewrite bannersleuth and will also be providing it as opensource. I have a work around, but would instead prefer that WebCatalog function as advertised. Nothing I see here seems to be strenuous on the server or webcatalog. Shouldn't webcat que its jobs? Shouldn't each access be seen as a seperate instance and be qued for processing. This code hangs the page due to exclusive locks, even with the code in the spawn. Now this is obviously a bug.Check out this code and tell me why if a single instance of this on a page will work fine, but if a multiple instances of this code on a single page will cause a the exclusive locks and eventual kill the server.****************** Example Code ******************************** [Search db=Banner_Dbs/ads.db&eqsec[s]datarq=X&eqdefdatarq=ad&UIDsort=1&UIDtype=num&U IDsdir=ra&max=1] [FoundItems] [text]uuid=[UID][/text] [text]r=[showif [referrer]=]Unknown[/showif][URL][referrer][/URL][/text] [hideif [image]^.html] [location] [/hideif] [showif [image]^.html] [include Banner_Ads/[url][image][/url]] [/showif] [text]spid=[sid][/text] [/founditems] [/Search][spawn] [!]spawn this record due to db locking, this calculate the total views etc for a specific ad.[/!] [search db=Banner_Dbs/ads.db&equiddata=[uuid]] [founditems] [math show=F]nueviews=[NumViews]+1[/math] [math show=F]spmaxviews=[showif [maxviews]=]0[/showif][maxviews][/math] [text]sptype=[type][/text] [/founditems] [/search] [Replace db=Banner_Dbs/ads.db&eqUIDdatarq=[uuid]]NumViews=[nueviews][showif [sptype]=MV][showif [NueViews]>[spMaxViews]]&Def=expad[/showif][/showif][/Replace] [/spawn][spawn] [!]spawn this record due to db locking, this calculates specific add placement, month, day, week hour etc. Placing this in the second spawn did no good either.[/!] [search db=Banner_Dbs/logs.db&eqrefdatarq=[r]&eqAYIDdatarq=[date %Y]_[uuid]_[s]] [showif [numfound]=0] [append db=Banner_Dbs/refloc.db]RID=[cart]&ref=[r][/append] [append db=Banner_Dbs/logs.db]SID=[cart]&ref=[r]&sec=[s]&CID=[ClientID]&AYID=[date %Y]_[uuid]_[s]&AYear=[date %Y]&AID=[uuid]&vdate=[Math]{[date]}[/Math]&vtime=[Math]{[time]}[/Math]&DV_[d ate %j]=1&TV=1&TC=0&MTV_[date %m]=1&WTV_[date %W]=1&HTV_[date %H]=[ma th show=T]hview+1[/math][loop start=1&end=366][hideif [date %j]=[index]]&DV_[index]=0[/hideif]&DC_[index]=0[/loop][loop start=0&end=52]&WCT_[Format .2d][index][/format]=0[hideif [date %W]=[index]]&WTV_[Format .2d][index][/format]=0[/hideif][/loop][loop st art=1&end=12]&MCT_[Format .2d][index][/format]=0[hideif [date %m]=[index]]&MTV_[Format .2d][index][/format]=0[/hideif][/loop][loop start=0&end=23]&HCT_[Format .2d][index][/format]=0[hideif [date %H]=[index]]&HTV_[Format .2d][index][/format]=0[/hideif][/lo op][/append] [/showif] [founditems] [math show=f]app=0[/math][math show=f]tv1=[TV]+1[/math][math show=f]nview=[interpret][DV_[date %j]][/interpret][/math][math show=f]mview=[interpret][MTV_[date %m]][/interpret][/math][math show=f]wview=[interpret][WTV_[date %W]][/interpret][/math][math sho w=f]hview=[interpret][HTV_[date %H]][/interpret][/math] [Replace db=Banner_Dbs/logs.db&eqSIDdatarq=[sid]]vdate=[Math]{[date]}[/Math]&vtime=[M ath]{[time]}[/Math]&TV=[tv1]&DV_[date %j]=[math show=T]nview+1[/math]&MTV_[date %m]=[math show=T]mview+1[/math]&WTV_[date %W]=[math show=T]wview+1[/math]&HTV_[date %H]=[M ath show=T]hview+1[/math][/replace] [/founditems] [/search] [/spawn][showif [nueviews]\10][commitdatabase Banner_Dbs/ads.db][commitdatabase Banner_Dbs/logs.db][/showif]******************************** End Code View **************************Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.> From: Paul Uttermohlen > Reply-To: > Date: Tue, 6 Jun 2000 12:15:03 > To: > Subject: Re: Busy WebCatalog > > And once a few months ago webstar log file lines (about > an hours worth) were written into the middle of our data obliterating > valuable customer banner ad tracking information. ############################################################# This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to Associated Messages, from the most recent to the oldest:

    
  1. Re: Busy WebCatalog (Grant Hulbert 2000)
  2. Re: Busy WebCatalog (John Butler 2000)
  3. Re: Busy WebCatalog (Wendell Kozak 2000)
  4. Re: Busy WebCatalog (Paul Uttermohlen 2000)
  5. Re: Busy WebCatalog (Bob Minor 2000)
  6. Re: Busy WebCatalog (Grant Hulbert 2000)
  7. Re: Busy WebCatalog (Michael O Shea 2000)
  8. Re: Busy WebCatalog (Grant Hulbert 2000)
  9. Re: Busy WebCatalog (Bob Minor 2000)
  10. Re: Busy WebCatalog (Paul Uttermohlen 2000)
  11. Re: Busy WebCatalog (Michael O Shea 2000)
I am experiencing these as well. I am attempting to rewrite bannersleuth and will also be providing it as opensource. I have a work around, but would instead prefer that WebCatalog function as advertised. Nothing I see here seems to be strenuous on the server or webcatalog. Shouldn't webcat que its jobs? Shouldn't each access be seen as a seperate instance and be qued for processing. This code hangs the page due to exclusive locks, even with the code in the spawn. Now this is obviously a bug.Check out this code and tell me why if a single instance of this on a page will work fine, but if a multiple instances of this code on a single page will cause a the exclusive locks and eventual kill the server.****************** Example Code ******************************** [Search db=Banner_Dbs/ads.db&eqsec[s]datarq=X&eqdefdatarq=ad&UIDsort=1&UIDtype=num&U IDsdir=ra&max=1] [founditems] [text]uuid=[UID][/text] [text]r=[showif [referrer]=]Unknown[/showif][url][referrer][/URL][/text] [hideif [image]^.html] [url][uid][/url]&r=[url][referrer][/URL]&d=[date %Y]_[uuid]_[s] target=_new> [url][image][/url] height=[imgh] width=[imgw] border=[border] alt=[location] title=[location]> [/hideif] [showif [image]^.html] [include Banner_Ads/[url][image][/url]] [/showif] [text]spid=[sid][/text] [/founditems] [/Search][spawn] [!]spawn this record due to db locking, this calculate the total views etc for a specific ad.[/!] [search db=Banner_Dbs/ads.db&equiddata=[uuid]] [founditems] [math show=F]nueviews=[NumViews]+1[/math] [math show=F]spmaxviews=[showif [maxviews]=]0[/showif][maxviews][/math] [text]sptype=[type][/text] [/founditems] [/search] [Replace db=Banner_Dbs/ads.db&eqUIDdatarq=[uuid]]NumViews=[nueviews][showif [sptype]=MV][showif [NueViews]>[spMaxViews]]&Def=expad[/showif][/showif][/Replace] [/spawn][spawn] [!]spawn this record due to db locking, this calculates specific add placement, month, day, week hour etc. Placing this in the second spawn did no good either.[/!] [search db=Banner_Dbs/logs.db&eqrefdatarq=[r]&eqAYIDdatarq=[date %Y]_[uuid]_[s]] [showif [numfound]=0] [append db=Banner_Dbs/refloc.db]RID=[cart]&ref=[r][/append] [append db=Banner_Dbs/logs.db]SID=[cart]&ref=[r]&sec=[s]&CID=[ClientID]&AYID=[date %Y]_[uuid]_[s]&AYear=[date %Y]&AID=[uuid]&vdate=[math]{[date]}[/Math]&vtime=[math]{[time]}[/Math]&DV_[d ate %j]=1&TV=1&TC=0&MTV_[date %m]=1&WTV_[date %W]=1&HTV_[date %H]=[ma th show=T]hview+1[/math][loop start=1&end=366][hideif [date %j]=[index]]&DV_[index]=0[/hideif]&DC_[index]=0[/loop][loop start=0&end=52]&WCT_[Format .2d][index][/format]=0[hideif [date %W]=[index]]&WTV_[Format .2d][index][/format]=0[/hideif][/loop][loop st art=1&end=12]&MCT_[Format .2d][index][/format]=0[hideif [date %m]=[index]]&MTV_[Format .2d][index][/format]=0[/hideif][/loop][loop start=0&end=23]&HCT_[Format .2d][index][/format]=0[hideif [date %H]=[index]]&HTV_[Format .2d][index][/format]=0[/hideif][/lo op][/append] [/showif] [founditems] [math show=f]app=0[/math][math show=f]tv1=[TV]+1[/math][math show=f]nview=[interpret][DV_[date %j]][/interpret][/math][math show=f]mview=[interpret][MTV_[date %m]][/interpret][/math][math show=f]wview=[interpret][WTV_[date %W]][/interpret][/math][math sho w=f]hview=[interpret][HTV_[date %H]][/interpret][/math] [Replace db=Banner_Dbs/logs.db&eqSIDdatarq=[sid]]vdate=[math]{[date]}[/Math]&vtime=[M ath]{[time]}[/Math]&TV=[tv1]&DV_[date %j]=[math show=T]nview+1[/math]&MTV_[date %m]=[math show=T]mview+1[/math]&WTV_[date %W]=[math show=T]wview+1[/math]&HTV_[date %H]=[M ath show=T]hview+1[/math][/replace] [/founditems] [/search] [/spawn][showif [nueviews]\10][commitdatabase Banner_Dbs/ads.db][commitdatabase Banner_Dbs/logs.db][/showif]******************************** End Code View **************************Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.> From: Paul Uttermohlen > Reply-To: > Date: Tue, 6 Jun 2000 12:15:03 > To: > Subject: Re: Busy WebCatalog > > And once a few months ago webstar log file lines (about > an hours worth) were written into the middle of our data obliterating > valuable customer banner ad tracking information. ############################################################# This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to Bob Minor

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:

AutoCommit Preference? (1998) Re:Formulas.db / Quantity Discount problem (1998) WebCat2: multiple currency support (1997) Possible Bug in 2.0b15.acgi (1997) Storing calculated data (2002) Cart questions (1997) Security Hole - NetCloak Update (1998) $Replace with [founditems] (1997) Some Advise needed (1997) [WebDNA] Crashing Database (2011) show all problem (1997) Date problems (1997) Nested tags count question (1997) Security hole in WebCat? (1999) Y2k compliance (1998) Capacity question (2002) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Date search - yes or no (1997) [WebDNA] OT: How is this being done? Curious. (2009) WebDNA Developer Edition - Host config problem (2003)