Re: Triggers-Deadlock

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30514
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 T > >Configuration: >Macintosh G4/400 512 MB RAM with MACOS 9.0 >WebTen 3.0.2 >WebCatalog plug-in 3.0.8 > >I 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. >Myron,I would turn on Extended Logging in the Webcat Prefs to see if the triggers are executing only at the time they are supposed to, or if they are running WAAY more often than they should.A while ago I hit a trigger bug where the URL was accessed upon creation of the trigger, and any typo in the URL or responsetext would cause the trigger to execute every second or two instead of on its schedule. I'm not sure if it was fixed in 3.0.8 or not, but your problem sounds very similar.A deadlock occurs when two threads are attempting to write to the same db. If you're trying to modify your trigger while the above runaway situation is occurring, it could very easily cause a deadlock.I would look very closely at your url and response text to make sure that you're setup correctly. Then look at the Webcatalog.debug file in the Webstar root for other clues.We have been fighting deadlocks on other db's for quite a while now. They happen much less often in OS9 than they do in 8.6, but we're stuck on 8.6 due to a different unresolved crashing problem when we run OS9. Sigh...Good luck.-Dale -- Dale LaFountain mailto:dalel@darkhorse.com Vice President of Information Technology, Webmaster Dark Horse Comics, Inc. Ph: 503-652-8815 x324 http://www.darkhorse.com/ Fax: 503-652-6917------------------------------------------------------------- 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 T > >Configuration: >Macintosh G4/400 512 MB RAM with MACOS 9.0 >WebTen 3.0.2 >WebCatalog plug-in 3.0.8 > >I 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. >Myron,I would turn on Extended Logging in the Webcat Prefs to see if the triggers are executing only at the time they are supposed to, or if they are running WAAY more often than they should.A while ago I hit a trigger bug where the URL was accessed upon creation of the trigger, and any typo in the URL or responsetext would cause the trigger to execute every second or two instead of on its schedule. I'm not sure if it was fixed in 3.0.8 or not, but your problem sounds very similar.A deadlock occurs when two threads are attempting to write to the same db. If you're trying to modify your trigger while the above runaway situation is occurring, it could very easily cause a deadlock.I would look very closely at your url and response text to make sure that you're setup correctly. Then look at the Webcatalog.debug file in the Webstar root for other clues.We have been fighting deadlocks on other db's for quite a while now. They happen much less often in OS9 than they do in 8.6, but we're stuck on 8.6 due to a different unresolved crashing problem when we run OS9. Sigh...Good luck.-Dale -- Dale LaFountain mailto:dalel@darkhorse.com Vice President of Information Technology, Webmaster Dark Horse Comics, Inc. Ph: 503-652-8815 x324 http://www.darkhorse.com/ Fax: 503-652-6917------------------------------------------------------------- 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 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:

convertchars and case? (1998) OK, here goes... (1997) Prices coming up 0.00 (2001) Double Spacing in Mails from Sendmail (2002) [append] problem (1997) Authenticate (1997) SIMS & WebCat .... Alias Folder (2002) Change in Host? (1999) Grep and <> (2005) Webcat Security (1998) Error.html (1997) Multiple Newcarts (1996) Problems with Summary and WEBCAT (1999) NT b19 sends extra MIME headers (1997) TeaRoom (1997) Protecting webdelivery (1997) [WebDNA] Internal [ipaddress] ? (2009) Upgrading old WebCat Database Files (1997) [username][password] not showing up! HELP! (1999) Can I invoke an ssi plugin from within a webcat page (1997)