Re: Server crashes and triggers . . . are they linked?

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38195
interpreted = N
texte = Strange you should ask...I just finished migrating all of our triggers to a local unix box running cron. We have (had) about 2 dozen triggers, some simplistic and some extremely intensive. We have experienced some crashes and major slowdowns that we suspect are trigger-related, but they were mostly very cpu-intensive triggers that were being executed at the same time or slowness during high server loads. Doesn't sound like your particular problem.We've had tons of problems with triggers executing at incorrect times due to various date bugs: no executions on the 31st day of the month, triggers.db not being flushed so all of them attempt to execute as soon as the server is relaunched, deadlocks trying to edit the triggers db, etc. etc.This is all with the 3.0.7 plugin on Mac, but I know some of these problems are fixed in 4.0x. However, we still can't use 4.0x because of other problems so we were at an impasse.If you have any suspicions of triggers causing problems, here's a handy wget incantation that will simulate a trigger using cron on a unix box, throwing away the results, and not retrying if the request fails:wget -O /dev/null --quiet --spider http://yoursite.com/template.tplMake a .wgetrc file with http_user and http_passwd entries, and you can even access authenticated pages.If you depend on the retry setting of webcat triggers, this solution is less than ideal. However, if you're tired of your triggers rampantly executing when they're not supposed to or not at all, cron+wget works great.As for troubleshooting, you should turn on Extended Logging in the Webcat prefs. This will write the template name and some other info into a debug file before beginning to process the template. If you crash, you can look in this debug file for the last template(s) to be executed before the crash.Good luck,-Dale >A trigger simply executes a template as it would be executed by a web >browser. To manually execute, simply hit the url (with vars) with your >browser. > >----- Original Message ----- >From: Rudy >To: WebCatalog Talk >Sent: Monday, August 27, 2001 4:02 PM >Subject: Server crashes and triggers . . . are they linked? > > >> Hi, >> >> A while ago, the server started crashing and the reason for it were >> unknown. It was suspected by my colleagues that the triggers were causing >> the crashes. These triggers prompted actions to rotator pages to switch >> information on the index page of the site. They hit on a daily basis and >> were fairly simplistic in nature. I'm new here, so if any of you can help >me >> out in determining whether the crashes and triggers are related, I thank >you >> all in advance. >> >> by the way, in case if the triggers are causing the crashes, can you >> indicate how it is possible to establish a manual trigger via a link? >> >> Thanx again, >> Rudy >> >> >> ------------------------------------------------------------- >> 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 > >> Web Archive of this list is at: http://search.smithmicro.com/ > > >------------------------------------------------------------- >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 > >Web Archive of this list is at: http://search.smithmicro.com/-- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.com/------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Server crashes and triggers . . . are they linked? (Kenneth Grome 2001)
  2. Re: Server crashes and triggers . . . are they linked? (Paul Uttermohlen 2001)
  3. Re: Server crashes and triggers . . . are they linked? (Glenn Busbin 2001)
  4. Re: Server crashes and triggers . . . are they linked? (Dale LaFountain 2001)
  5. Re: Server crashes and triggers . . . are they linked? (Bob McPeak 2001)
  6. Server crashes and triggers . . . are they linked? (Rudy 2001)
Strange you should ask...I just finished migrating all of our triggers to a local unix box running cron. We have (had) about 2 dozen triggers, some simplistic and some extremely intensive. We have experienced some crashes and major slowdowns that we suspect are trigger-related, but they were mostly very cpu-intensive triggers that were being executed at the same time or slowness during high server loads. Doesn't sound like your particular problem.We've had tons of problems with triggers executing at incorrect times due to various date bugs: no executions on the 31st day of the month, triggers.db not being flushed so all of them attempt to execute as soon as the server is relaunched, deadlocks trying to edit the triggers db, etc. etc.This is all with the 3.0.7 plugin on Mac, but I know some of these problems are fixed in 4.0x. However, we still can't use 4.0x because of other problems so we were at an impasse.If you have any suspicions of triggers causing problems, here's a handy wget incantation that will simulate a trigger using cron on a unix box, throwing away the results, and not retrying if the request fails:wget -O /dev/null --quiet --spider http://yoursite.com/template.tplMake a .wgetrc file with http_user and http_passwd entries, and you can even access authenticated pages.If you depend on the retry setting of webcat triggers, this solution is less than ideal. However, if you're tired of your triggers rampantly executing when they're not supposed to or not at all, cron+wget works great.As for troubleshooting, you should turn on Extended Logging in the Webcat prefs. This will write the template name and some other info into a debug file before beginning to process the template. If you crash, you can look in this debug file for the last template(s) to be executed before the crash.Good luck,-Dale >A trigger simply executes a template as it would be executed by a web >browser. To manually execute, simply hit the url (with vars) with your >browser. > >----- Original Message ----- >From: Rudy >To: WebCatalog Talk >Sent: Monday, August 27, 2001 4:02 PM >Subject: Server crashes and triggers . . . are they linked? > > >> Hi, >> >> A while ago, the server started crashing and the reason for it were >> unknown. It was suspected by my colleagues that the triggers were causing >> the crashes. These triggers prompted actions to rotator pages to switch >> information on the index page of the site. They hit on a daily basis and >> were fairly simplistic in nature. I'm new here, so if any of you can help >me >> out in determining whether the crashes and triggers are related, I thank >you >> all in advance. >> >> by the way, in case if the triggers are causing the crashes, can you >> indicate how it is possible to establish a manual trigger via a link? >> >> Thanx again, >> Rudy >> >> >> ------------------------------------------------------------- >> 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 > >> Web Archive of this list is at: http://search.smithmicro.com/ > > >------------------------------------------------------------- >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 > >Web Archive of this list is at: http://search.smithmicro.com/-- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.com/------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Dale LaFountain

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:

Just Testing (1997) Emailer setup (1997) [ModDate] & [ModTime] ? (1997) HELP WITH DATES (1997) v5.x and Apache 2.x (2003) re: Default contains WEBDNA (1998) RE: protect tag on NT (1997) Showif, Search and text ? (2003) WebDNA Quick Reference (Reserved Words) (2000) Help formatting search results w/ table (1997) Command=Showcart? (2000) Pithy questions on webcommerce & siteedit (1997) GuestBook example (1997) chat opinion ... (2002) [WebDNA] Problem running Webdna (2011) Drop down menu (2003) PIXO support (1997) Protect and Serve (1999) Lastautonumber (2005) Unexpected error (1997)