Re: Deadlock Problem

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35645
interpreted = N
texte = Lani,I do not have first-hand experience with this. but from following past posts I believe you are witnessing a flaw(s) in webcat 3. The only solutions seem to be either upgrade or else significantly reduce the code complexity and/or parse time during evaluation of some page during which webcat has locked some db while reading or writing to it.http://search.smithmicro.com/TalkListArchive/DetailResults.tpl?command=search&db=WebDNA-Talk.db&eqskudata=13091&max=1&words=lock%20Grant http://search.smithmicro.com/TalkListArchive/DetailResults.tpl?command=search&db=webcatalog-beta.db&eqskudata=2218&max=1&words=lock%20Grantthose links may help you create a bandaid you need until upgradingHTH-JohnPS - at one time Grant said on the beta list that he would at least look into the idea of dummying down the webcat 4 parser so that it had the better threading but without the new 4 tags and then paint/ship that as the latest 3.0X release ... so 3 users could get the bug fix they deserve before upgrading. I suppose they decided not to bother after all, but you could always ask.Lani Twitchell wrote:> We have an online orientation program that uses WebCatalog 3.08(?) on a Sun Solaris box. The web pages and databases are working as expected, with one exception. > > We are getting 5-10 thread debug errors a day on the server. Here are the contents of one of them: > 07/31/00 12:18:57 deadlocked /services/web/webcatalog/orient/online/o_users/o_users.db, 1147 times waiting for write > > The url for the orientation program is: > http://webcatalog.cc.utah.edu/orient/online/opening_flash.html > > Smith Micro Tech Support recommends that we upgrade to WebCatalog 4.0. We cannot upgrade for a couple of months. > > My understanding of the problem is that queries to the database are bumping into each other, causing it to deadlock. Could this problem be created if the commands and contexts in the associated .tpl files do not use the cart=[cart] tag? Or is this a known problem of the 3.0 version that is only fixed with an upgrade? > > Lani Twitchell > Multimedia/Web Developer > KUED/Media Solutions/University of Utah > 801-581-5064 > ltwitchell@media.utah.edu ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Deadlock Problem (John Butler 2000)
  2. Deadlock Problem (Lani Twitchell 2000)
Lani,I do not have first-hand experience with this. but from following past posts I believe you are witnessing a flaw(s) in webcat 3. The only solutions seem to be either upgrade or else significantly reduce the code complexity and/or parse time during evaluation of some page during which webcat has locked some db while reading or writing to it.http://search.smithmicro.com/TalkListArchive/DetailResults.tpl?command=search&db=WebDNA-Talk.db&eqskudata=13091&max=1&words=lock%20Grant http://search.smithmicro.com/TalkListArchive/DetailResults.tpl?command=search&db=webcatalog-beta.db&eqskudata=2218&max=1&words=lock%20Grantthose links may help you create a bandaid you need until upgradingHTH-JohnPS - at one time Grant said on the beta list that he would at least look into the idea of dummying down the webcat 4 parser so that it had the better threading but without the new 4 tags and then paint/ship that as the latest 3.0X release ... so 3 users could get the bug fix they deserve before upgrading. I suppose they decided not to bother after all, but you could always ask.Lani Twitchell wrote:> We have an online orientation program that uses WebCatalog 3.08(?) on a Sun Solaris box. The web pages and databases are working as expected, with one exception. > > We are getting 5-10 thread debug errors a day on the server. Here are the contents of one of them: > 07/31/00 12:18:57 deadlocked /services/web/webcatalog/orient/online/o_users/o_users.db, 1147 times waiting for write > > The url for the orientation program is: > http://webcatalog.cc.utah.edu/orient/online/opening_flash.html > > Smith Micro Tech Support recommends that we upgrade to WebCatalog 4.0. We cannot upgrade for a couple of months. > > My understanding of the problem is that queries to the database are bumping into each other, causing it to deadlock. Could this problem be created if the commands and contexts in the associated .tpl files do not use the cart=[cart] tag? Or is this a known problem of the 3.0 version that is only fixed with an upgrade? > > Lani Twitchell > Multimedia/Web Developer > KUED/Media Solutions/University of Utah > 801-581-5064 > ltwitchell@media.utah.edu ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ John Butler

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:

WebCat2 beta 11 - new prefs ... (1997) WebCat b13 CGI -shownext- (1997) Summing fields (1997) Hiring: Web programmer in Seattle area (2000) could someone please try this - it's very quick and easy (2000) Dreamweaver (2002) QuickBooks Import? (2007) Mac Programs (1998) How to set triggers (1998) Is the list server working? (1998) MOOOOOO (2000) WebCatalog-NT?'s (1996) WebCat2 beta 11 - new prefs ... (1997) OT: Need some feedback, please. (2003) SpiderBotLock! (2003) How to delete all files in a folder? (2001) Bad creator codes which cause access denied error message (1997) PCS Frames (1997) re: Large databases in WebCat (1997) OrderFile (2000)