Triggers-Deadlock

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30511
interpreted = N
texte = I'm trying to set up 6 triggers to hit a page every 10 minutes and have 2 problems:1) I have no problem adding the first trigger. After clicking the ADD button, the Trigger administration page displays the newly added trigger almost immediately. Once that first trigger is entered, I am able to update the trigger.db in about 1 out of every 10 attempts. On the failed attempts, the server times out and the result is a empty frame where the trigger admin page should be. There is also a new thread###.debug file on the server with the following text:... deadlocked :WebCatalog:Triggers.db, 68850620 times waiting for write ...2) The triggers I have entered never hit the web server. For testing purposes, I have set up the page so it sends me an email every time it is hit so I know the triggers are not working. Here is an example:TIME * * * * 45 0 2000/04/14 09:45:00 TConfiguration: Macintosh G4/400 512 MB RAM with MACOS 9.0 WebTen 3.0.2 WebCatalog plug-in 3.0.8I searched the archives of this list and found similar issues with WebTen 2.1.10 and WebCatalog 3.0.4 a year ago. Have they been resolved in the latest versions? Does anyone have triggers working in a configuration similar to mine or is there something I have set up wrong? I do not really want to resort to PageSentry to make this work.Sincerely, Myron Hintz Pump Systems, Inc. ------------------------------------------------------------- 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Triggers-Deadlock (Dale LaFountain 2000)
  2. Triggers-Deadlock (Myron Hintz 2000)
I'm trying to set up 6 triggers to hit a page every 10 minutes and have 2 problems:1) I have no problem adding the first trigger. After clicking the ADD button, the Trigger administration page displays the newly added trigger almost immediately. Once that first trigger is entered, I am able to update the trigger.db in about 1 out of every 10 attempts. On the failed attempts, the server times out and the result is a empty frame where the trigger admin page should be. There is also a new thread###.debug file on the server with the following text:... deadlocked :WebCatalog:triggers.db, 68850620 times waiting for write ...2) The triggers I have entered never hit the web server. For testing purposes, I have set up the page so it sends me an email every time it is hit so I know the triggers are not working. Here is an example:TIME * * * * 45 0 2000/04/14 09:45:00 TConfiguration: Macintosh G4/400 512 MB RAM with MACOS 9.0 WebTen 3.0.2 WebCatalog plug-in 3.0.8I searched the archives of this list and found similar issues with WebTen 2.1.10 and WebCatalog 3.0.4 a year ago. Have they been resolved in the latest versions? Does anyone have triggers working in a configuration similar to mine or is there something I have set up wrong? I do not really want to resort to PageSentry to make this work.Sincerely, Myron Hintz Pump Systems, Inc. ------------------------------------------------------------- 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 Myron Hintz

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:

Help name our technology! I found it (1997) Price Not Appearing (2000) Re:Emailer and encryption (1997) [WebDNA] anyone know how to enable URLs in plain text to links? (2009) order problem (2006) Summing fields (1997) problems with WebCat-Plugin (1997) Encrypt a page/template (2002) WebCat2: Found Items syntax, etc. (1997) Hard carriage convertion? (1998) WebCatalog can't find database (1997) service stop and restart (1997) Robots fill event log (1997) Shell script within a sandbox (2005) Linux -> OS X (2002) WCS Newbie question (1997) triggers (2003) WebCatalog dying in WebTen Revisited (1998) Which [index]? (1997) Summary search -- speed (1997)