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 whilereading or writing to it.http://search.smithmicro.com/TalkListArchive/DetailResults.tpl?command=search&db=WebDNA-Talk.db&eqskudata=13091&max=1&words=lock%20Granthttp://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 theydecided 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:

Re: Deadlock Problem (John Butler 2000)
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 whilereading or writing to it.http://search.smithmicro.com/TalkListArchive/DetailResults.tpl?command=search&db=WebDNA-Talk.db&eqskudata=13091&max=1&words=lock%20Granthttp://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 theydecided 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!

Re: Deadlock Problem

2000

Top Articles:

Related Readings: