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:

SmithMicro Help! -- Can't access WebCatalog Admin! (2001) Associative lookup style? + bit more (1997) Configuring E-mail (1997) Group search - using contexts (2000) webmerch and serials - almost there (1997) NT b19 sends extra MIME headers (1997) Taxes rates based on item and State (1998) using showpage and showcart commands (1996) Help! WebCat2 bug (1997) Getting total number of items ordered (1997) Popup Menu Options (1998) [WebDNA] Captcha question (and free code) (2009) Re:Emailer setup (1997) WebCat2final1 crashes (1997) Ghostly cached webpage (2000) Wits end with this [sendmail] problem. ;) (2000) Country & Ship-to address & other fields ? (1997) Cookies and WebCat?? (1999) FoundItems Question (1998) SV: Mass Mail (2000)