Re: deadlock

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34282
interpreted = N
texte = >Hi Grant, HAs the filelocking improved in 4? >I am still getting this ON 3 on OSX. >I'm not Grant, but I can tell you on Mac OS the file deadlock problem has been licked. We were getting 1,000+ deadlocks per day and now we're down to 0.The trade off, however, is nearly unbearable. We are now experiencing 8 to 12 crashes a day. It is far less stable.Also, please note that if you used forms to pass variables such as [username] and [password] or you overwrite text variables in any of your templates, they will cease to function. While there is a work around for the text variable issue (actually a hidden preference setting), you will be forced to rewrite everything else. This has been our worst upgrade transition in 3 years.Paul> >cat thread2197968.debug > >06/05/00 03:42:57 deadlocked >/Local/Library/WebServer/WebSites/www.dvd-shop.ch/adm >in/tracking.db, 1193 times waiting for write >213.003.117.074 SHOWPAGE >/Local/Library/WebServer/WebSites/www.dvd-shop.ch/cart.htm >Mozilla/ >4.05action=Add&cart=947509245344584&sku=5994&qty=1&rand=149132 >07/01/00 11:13:57 deadlocked >/Local/Library/WebServer/WebSites/www.dvd-shop.ch/adm >in/tracking.db, 1192 times waiting for write >194.230.253.140 SHOWPAGE >/Local/Library/WebServer/WebSites/www.dvd-shop.ch/cart.htm >Mozilla/ >5.0 (compatible; MSIE >5.0)action=add&cart=96244223436109&sku=14276&qty=1&rand=428364 >-- > > >Micheal O Shea Email:micheal@com4u.ch >com4u.ch http://www.com4u.ch >Breitistrasse 7B PGP key available upon request. >CH-5506 Maegenwil Tel: +41 62 896 46 26 >Switzerland > >############################################################# >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 > >To switch to the INDEX mode, E-mail to > >Send administrative queries to _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Interactive Ink, Inc._\_\_ \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_############################################################# 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 To switch to the INDEX mode, E-mail to Send administrative queries to Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Failed to aquire lock on database - Possible deadlock (Donovan Brooke 2011)
  2. [WebDNA] Failed to aquire lock on database - Possible deadlock averted (Tommy Bell 2011)
  3. Re: [WebDNA] online.db deadlock: your current options ... (Tommy Bell 2011)
  4. Re: [WebDNA] online.db deadlock: your current options ... (Stuart Tremain 2011)
  5. Re: [WebDNA] online.db deadlock: your current options ... (Grant Hulbert 2011)
  6. Re: [WebDNA] An unknown error occured // Deadlock avoided (Stuart Tremain 2011)
  7. Re: [WebDNA] online.db deadlock: your current options ... (Stuart Tremain 2011)
  8. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  9. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  10. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  11. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  12. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  13. Re: [WebDNA] An unknown error occured // Deadlock avoided (Govinda 2011)
  14. Re: [WebDNA] An unknown error occured // Deadlock avoided (Paul Willis 2011)
  15. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  16. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  17. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  18. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  19. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  20. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  21. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  22. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  23. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  24. Re: [WebDNA] An unknown error occured // Deadlock avoided (Govinda 2011)
  25. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  26. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  27. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  28. Re: [WebDNA] An unknown error occured // Deadlock avoided (Dan Strong 2011)
  29. [WebDNA] online.db deadlock: your current options ... (Kenneth Grome 2011)
  30. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  31. Re: [WebDNA] An unknown error occured // Deadlock avoided ( 2011)
  32. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  33. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  34. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  35. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  36. Re: [WebDNA] An unknown error occured // Deadlock avoided (Stuart Tremain 2011)
  37. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  38. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  39. Re: [WebDNA] An unknown error occured // Deadlock avoided (Stuart Tremain 2011)
  40. RE: [WebDNA] An unknown error occured // Deadlock avoided ("Terry Nair" 2011)
  41. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  42. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  43. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  44. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  45. Re: [WebDNA] An unknown error occured // Deadlock avoided (Ronald Kirkland 2011)
  46. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  47. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  48. Re: [WebDNA] An unknown error occured // Deadlock avoided (Kenneth Grome 2011)
  49. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  50. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  51. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  52. Re: [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  53. Re: [WebDNA] An unknown error occured // Deadlock avoided (Govinda 2011)
  54. Re: [WebDNA] An unknown error occured // Deadlock avoided (christophe.billiottet@webdna.us 2011)
  55. [WebDNA] An unknown error occured // Deadlock avoided (Tommy Bell 2011)
  56. Failed to aquire lock on database - Possible deadlock averted ( "Palle B. Nielsen (PowerPalle)" 2005)
  57. Re: Deadlock Problem (John Butler 2000)
  58. Deadlock Problem (Lani Twitchell 2000)
  59. Re: deadlock (Bob Minor 2000)
  60. Re: deadlock (Grant Hulbert 2000)
  61. Re: deadlock (Charles Kline 2000)
  62. Re: deadlock (Grant Hulbert 2000)
  63. Re: deadlock (Charles Kline 2000)
  64. Re: deadlock (Bob Minor 2000)
  65. Re: deadlock (Grant Hulbert 2000)
  66. Re: deadlock (Grant Hulbert 2000)
  67. Re: deadlock (Paul Uttermohlen 2000)
  68. deadlock (Michael O Shea 2000)
  69. Re: Triggers-Deadlock (Dale LaFountain 2000)
  70. Triggers-Deadlock (Myron Hintz 2000)
  71. Deadlocked! (Paul Uttermohlen 2000)
  72. Deadlocked Errors (Patrick O'Brien 1999)
  73. Re: Deadlock (John Jakovich 1999)
  74. Re: Deadlock (Kenneth Grome 1999)
  75. Deadlock (david@textileweb.net (TextileWeb - David) 1999)
  76. Deadlock (david@textileweb.net (TextileWeb - David) 1998)
>Hi Grant, HAs the filelocking improved in 4? >I am still getting this ON 3 on OSX. >I'm not Grant, but I can tell you on Mac OS the file deadlock problem has been licked. We were getting 1,000+ deadlocks per day and now we're down to 0.The trade off, however, is nearly unbearable. We are now experiencing 8 to 12 crashes a day. It is far less stable.Also, please note that if you used forms to pass variables such as [username] and [password] or you overwrite text variables in any of your templates, they will cease to function. While there is a work around for the text variable issue (actually a hidden preference setting), you will be forced to rewrite everything else. This has been our worst upgrade transition in 3 years.Paul> >cat thread2197968.debug > >06/05/00 03:42:57 deadlocked >/Local/Library/WebServer/WebSites/www.dvd-shop.ch/adm >in/tracking.db, 1193 times waiting for write >213.003.117.074 SHOWPAGE >/Local/Library/WebServer/WebSites/www.dvd-shop.ch/cart.htm >Mozilla/ >4.05action=Add&cart=947509245344584&sku=5994&qty=1&rand=149132 >07/01/00 11:13:57 deadlocked >/Local/Library/WebServer/WebSites/www.dvd-shop.ch/adm >in/tracking.db, 1192 times waiting for write >194.230.253.140 SHOWPAGE >/Local/Library/WebServer/WebSites/www.dvd-shop.ch/cart.htm >Mozilla/ >5.0 (compatible; MSIE >5.0)action=add&cart=96244223436109&sku=14276&qty=1&rand=428364 >-- > > >Micheal O Shea Email:micheal@com4u.ch >com4u.ch http://www.com4u.ch >Breitistrasse 7B PGP key available upon request. >CH-5506 Maegenwil Tel: +41 62 896 46 26 >Switzerland > >############################################################# >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 > >To switch to the INDEX mode, E-mail to > >Send administrative queries to _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Interactive Ink, Inc._\_\_ \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_############################################################# 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 To switch to the INDEX mode, E-mail to Send administrative queries to Paul Uttermohlen

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:

multiple product databases (1997) WebCat2b15MacPlugin - showing [math] (1997) Re:listfiles-looking for slick solution (1997) Re:2nd WebCatalog2 Feature Request (1996) Allow-Deny: Solved with [Getchars] (1998) Re: (1998) emailer setup (1997) Follow-Up: Problem upgrading from 3.0.8 to 4.0 on MS Windoze 98 / PWS (2000) [WebDNA] Is the AutoCommit preference still supported? (2010) Linux ODBC and the ODBC Bridge (2000) carriage returns in data (1997) Setting up shop (1997) PCS Frames (1997) Upload Maximum (2003) [newcart] (1998) Sku numbers (1997) Problem displaying search result (1997) emailer w/F2 (1997) Protect Tage and Groups (1998) Attention all list readers (1997)