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:

japanese characters (1997) apostrophe in search item (1997) show all problem (1997) OT: CT Scan might have saved my life!! (2006) [showif] with ! (2000) Fwd: Problems with Webcatalog Plug-in (1997) WebCat2 - Getting to the browser's username/password data (1997) Possible Bug in 2.0b15.acgi (1997) WebCommerce: Folder organization ? (1997) Showif Context combined with Search (1997) all records returned. (1997) Forms Search Questions (1997) empty shopping cart message (1997) Document Contains No Data! (1997) (no subject) (1997) Re:Item options w/ price adjustment (1997) RE: New WebCatalog Version !!! (1997) [SearchString] usage (1997) [WebDNA] TCPConnect w/ user:pass (2009) Arrays (2000)