Re: [BULK] Re: [WebDNA] triggers.db "next execute" fails to update
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108353
interpreted = N
texte = Hi Matthew,Thanks for this very valuable information. I thought the host was running 6.2 but I checked the server this morning and he is still running 6.0! This explains the trigger problems I've been wasting my time on ... :(Does anyone remember when version 6.0 was released? I'm thinking it was almost 10 years ago, is this correct?Sincerely,Kenneth Grome> Kenneth,> > I've had the same issues on all my WebCat 4.x, 5.x, and> 6.0 servers over the years. The problems does not seem> to happen on 6.2 for me.> > In my case, I had many triggers in a single Sandbox that> would work fine for months and then one of them would> stop updating. Or, even stranger, it would update to> some time into the future. It never happen often enough> to figure out a pattern.> > My solution was to simply delete the next trigger date> and time. Save. Open the trigger record again and let> it fill in the next execute time on it's own.> > I always suspected that it would only happen when WebDNA> was close to, or exceeded, the available RAM, but that's> such a hard thing to figure out.> > -Matthew> > On 1/29/2012 6:53 PM, Kenneth Grome wrote:> > Nope, just> > > > Sincerely,> > Kenneth Grome> > > >> Typo in your "Validation Text" ?> >> > >> On 29/01/2012, at 4:29 PM, Kenneth Grome wrote:> >>> I created a trigger on WebDNA 6.x via WebDNA Sandbox> >>> Admin. This is the only trigger used in this sandbox.> >>> > >>> When it runs WebDNA fails update the "next execute"> >>> value like it is supposed to. Therefore the trigger> >>> runs again every 10 seconds, and the same template is> >>> interpreted by WebDNA again ...> >>> > >>> This is a "bad thing" when the template has a> >>> sendmail context it it to alert me that the trigger> >>> has run, because it sends me another email every 10> >>> seconds. I got more than 1500 emails this morning> >>> before the host put an end to it by rebooting the> >>> server ... :(> >>> > >>> Flushing the databases does not stop the trigger from> >>> running. Deleting the target template via FTP does> >>> not stop it, because even though the file is no> >>> longer on disk it is apparently still cached in RAM.> >>> Strangely enough, the template seems to remain> >>> cached in RAM , thus ignoring the WebCatalog Prefs> >>> that's supposed to force the template out of ram> >>> every 2 seconds. Issuing a FlushCache command also> >>> fails to purge the template from RAM.> >>> > >>> :(> >>> > >>> My host refuses to investigate this issue. Whether> >>> he is lazy, irresponsible, incompetent, or all of> >>> the above, cannot say for certain. Nevertheless I> >>> need the problem fixed, so I'll have to figure this> >>> out myself, hopefully with some bright ideas from> >>> others here.> >>> > >>> Any idea why WebDNA might fail to update the "next> >>> execute" value when the trigger is run?> >>> > >>> Sincerely,> >>> Kenneth Grome> >>> -----------------------------------------------------> >>> -- -- 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> > > > -------------------------------------------------------> > -- 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> > > > > > > > > > Psi Prime, Inc.> > 323 Union Blvd.> > Totowa, NJ 07512> > > > Service: 973.413.8211> > Training: 973.413.8214> > Fax: 973.413.8217> > > > http://www.perosi.com> > ---------------------------------------------------------> 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:
Hi Matthew,Thanks for this very valuable information. I thought the host was running 6.2 but I checked the server this morning and he is still running 6.0! This explains the trigger problems I've been wasting my time on ... :(Does anyone remember when version 6.0 was released? I'm thinking it was almost 10 years ago, is this correct?Sincerely,Kenneth Grome> Kenneth,> > I've had the same issues on all my WebCat 4.x, 5.x, and> 6.0 servers over the years. The problems does not seem> to happen on 6.2 for me.> > In my case, I had many triggers in a single Sandbox that> would work fine for months and then one of them would> stop updating. Or, even stranger, it would update to> some time into the future. It never happen often enough> to figure out a pattern.> > My solution was to simply delete the next trigger date> and time. Save. Open the trigger record again and let> it fill in the next execute time on it's own.> > I always suspected that it would only happen when WebDNA> was close to, or exceeded, the available RAM, but that's> such a hard thing to figure out.> > -Matthew> > On 1/29/2012 6:53 PM, Kenneth Grome wrote:> > Nope, just> > > > Sincerely,> > Kenneth Grome> > > >> Typo in your "Validation Text" ?> >> > >> On 29/01/2012, at 4:29 PM, Kenneth Grome wrote:> >>> I created a trigger on WebDNA 6.x via WebDNA Sandbox> >>> Admin. This is the only trigger used in this sandbox.> >>> > >>> When it runs WebDNA fails update the "next execute"> >>> value like it is supposed to. Therefore the trigger> >>> runs again every 10 seconds, and the same template is> >>> interpreted by WebDNA again ...> >>> > >>> This is a "bad thing" when the template has a> >>> sendmail context it it to alert me that the trigger> >>> has run, because it sends me another email every 10> >>> seconds. I got more than 1500 emails this morning> >>> before the host put an end to it by rebooting the> >>> server ... :(> >>> > >>> Flushing the databases does not stop the trigger from> >>> running. Deleting the target template via FTP does> >>> not stop it, because even though the file is no> >>> longer on disk it is apparently still cached in RAM.> >>> Strangely enough, the template seems to remain> >>> cached in RAM , thus ignoring the WebCatalog Prefs> >>> that's supposed to force the template out of ram> >>> every 2 seconds. Issuing a FlushCache command also> >>> fails to purge the template from RAM.> >>> > >>> :(> >>> > >>> My host refuses to investigate this issue. Whether> >>> he is lazy, irresponsible, incompetent, or all of> >>> the above, cannot say for certain. Nevertheless I> >>> need the problem fixed, so I'll have to figure this> >>> out myself, hopefully with some bright ideas from> >>> others here.> >>> > >>> Any idea why WebDNA might fail to update the "next> >>> execute" value when the trigger is run?> >>> > >>> Sincerely,> >>> Kenneth Grome> >>> -----------------------------------------------------> >>> -- -- 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> > > > -------------------------------------------------------> > -- 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> > > > > > > > > > Psi Prime, Inc.> > 323 Union Blvd.> > Totowa, NJ 07512> > > > Service: 973.413.8211> > Training: 973.413.8214> > Fax: 973.413.8217> > > > http://www.perosi.com> > ---------------------------------------------------------> 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
Kenneth Grome
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:
2nd WebCatalog2 Feature Request (1996)
PhotoMill -> PhotoMaster (1997)
Make sure I understand this??? (1997)
WebCatalog for Postcards ? (1997)
Re2: AAgghh!! Help, please. SSL strikes again. (1997)
Limiting user access to .tmpl files (1997)
question... no field names? (2002)
webcatalog [date] bug (1999)
WebCatalog NT beta 18 now available (1997)
[WebDNA] Styling search results [using css] (2009)
Dynamic Pop up menu? (1997)
Mozilla/4. and Browser Info.txt (1997)
redirect tag (2004)
For those of you not on the WebCatalog Beta... (1997)
Pithy questions on webcommerce & siteedit (1997)
WebDelivery downloads alias, not original ? (1997)
Any word on upload feature? (2000)
Fun with Dates - finally resolved but.... (1997)
Nested tags count question (1997)
[sendmail] questions... (1997)