Re: URGENT! Locked DB's

This WebDNA talk-list message is from

2001

It keeps the original formatting. numero = 38431
interpreted = N
texte = You should upgrade to the latest 402 release candidate (402rc2). There havebeen several bug fixes and improvements since 401. You can download thelatest version here:ftp://ftp.isd.smithmicro.com/beta/WebCatalog/> -----Original Message-----> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On> Behalf Of Patrick O'Brien> Sent: Thursday, September 06, 2001 8:17 AM> To: WebCatalog Talk> Subject: Re: URGENT! Locked DB's>>> Thanks for the comments.>> I upgraded to WC 3.0.7 immediately and saw a slight> performance increase. Not enough though to help matters.>> Following that I've upgraded to WC 4.0.1 and saw an immediate> performance increase. The Finder is still sluggish on the G4> 400mhz machine but at least it is workable.>> Here's the bad part, after about 2,000 hits the server starts> to puke again. Quitting Web* and restarting the application> clears things up again and then the server runs zippy as> ever. So, it looks like after a few thousand hits its bogging down.>> The only apps running on the machine are Web*, WC, Rumpus and> Emailer.>> Any other comments are appreciated. I am a little concerned> about having to throw more hardware at this situation. Thanks.> --> Sincerely,>> Patrick O'Brien Systems Adminstrator and Web Manager> Sandusky Register http://www.sanduskyregister.com> Top Interactive http://www.topinteractive.com> 419-625-5500 ext. 333>> On Thursday, September 6, 2001 10:08 AM, dale@gmr.dresdner.net wrote:> >Come on folks, 18,000 banners per day is nothing for WebCat 3.x> >on Mac OS.> >> >I am doing 5 times that amount with no problems, that is no> problems after> >upgrading to v3.0.7. and previously I was doing 50,000> pages (all with> >banners) on a processor upgraded PM 7100. It was around that> time that I> >encountered these threads as well. Trying the newer beta's> that Grant sent> >me, then sticking with the final version of 3.0.7 solved all of> >them.> >> >3.0.4 does have problems with threads, this was improved> over the next> >couple of versions. an Upgrade to 4.x can be very expensive> and possibly not> >cost effective.> >> >I have to suggest once again to simply upgrade to the 3.0.7> plugin. Takes a> >couple of minutes to download, swap out the plugins and> restart WebStar.> >After you do that, *if* you continue to have problems then I> would suggest> >possibly considering upgrading to WC4.x> >> >What is the speed/processor of the computer? If you are> using an older and> >slower machine, then that could also be contributing to the> problem. And> >that will not necessarily be solved by upgrading to 4.x.> >> >Are you running anything else on the machine that could be> taking processor> >time? e.g. FileMaker Pro> >> >> From: Paul Uttermohlen > >> Reply-To: (WebCatalog Talk)> >> Date: Thu, 6 Sep 2001 09:32:06> >> To: (WebCatalog Talk)> >> Subject: Re: URGENT! Locked DB's> >>> >> Patrick,> >>> >> You are hitting the limitations of Webcat 3.x.> >>> >> Upgrading to Webcat 4.x will solve your thread problems> which handles> >> more threads better - that section of the code was> rewritten, fairly> >> well too.> >>> >> We upgraded last year to solve the problem you are> encountering now.> >>> >> Paul> >>> >>> Our G4 is running OS 9.0.4, Web* 4.2 and WebCat Plugin> v3.0.4. 700mb. of RAM.> >>>> >>> We are getting several hundred, close to 1,000 thread.debug files> >>> generated daily. The server bogs down to incredibly slow speed and> >>> even the Finder runs extrememly slow. The following is a> snippet of> >>> what the thread.debugs tell us:> >>>> >>> 09/06/01 05:49:48 deadlocked> >>> :BannerSleuth:Banner_Dbs:logs.db, 36856393 times waiting for read> >>> 09/06/01 05:50:10 deadlocked> >>> :BannerSleuth:Banner_Dbs:logs.db, 11391157 times waiting for write> >>> 09/06/01 05:50:30 deadlocked> >>> :BannerSleuth:Banner_Dbs:logs.db, 11506693 times waiting for write> >>> 09/06/01 05:50:52 deadlocked> >>> :BannerSleuth:Banner_Dbs:logs.db, 11527617 times waiting for write> >>>> >>> Does anybody have any idea on how to combat this problem without> >>> having to throw away Bannersleuth? When I take the BannerSleuth> >>> directory out of the Web* root so that BannerSleuth won't be> >>> accessed, the server runs just fine, of course none of our banner> >>> ads appear on our sites which doesn't make our advertisers happy> >>> either. We're averaging about 18,000 page views per day which> >>> translates into about 18,000 banner views per day. When we used> >>> BannerSleuth initially on one site we only had about 2,000> >>> page/banner views per day and had no problems. I have no idea if> >>> WebCat freaks after a certain amount of traffic.> >>>> >>> Any help is greatly appreciated!!!!!!!!!!!!!!!!!!!!> >>> --> >>> Sincerely,> >>>> >>> Patrick O'Brien Systems Adminstrator> and Web Manager> >>> Sandusky Register http://www.sanduskyregister.com> >>> Top Interactive http://www.topinteractive.com> >>> 419-625-5500 ext. 333> >> >> >-------------------------------------------------------------> >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/> >>>>> -------------------------------------------------------------> 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/-------------------------------------------------------------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: URGENT! Locked DB's (Patrick O'Brien 2001)
Re: URGENT! Locked DB's (Dale LaFountain 2001)
Re: URGENT! Locked DB's (Patrick O'Brien 2001)
Re: URGENT! Locked DB's (Scott Anderson 2001)
Re: URGENT! Locked DB's (Christer Olsson 2001)
Re: URGENT! Locked DB's (Paolo Coppo 2001)
Re: URGENT! Locked DB's (Patrick O'Brien 2001)
Re: URGENT! Locked DB's (dale 2001)
Re: URGENT! Locked DB's (Paul Uttermohlen 2001)
Re: URGENT! Locked DB's (Bob Minor 2001)
Re: URGENT! Locked DB's (dale 2001)
URGENT! Locked DB's (Patrick O'Brien 2001)

You should upgrade to the latest 402 release candidate (402rc2). There havebeen several bug fixes and improvements since 401. You can download thelatest version here:ftp://ftp.isd.smithmicro.com/beta/WebCatalog/> -----Original Message-----> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On> Behalf Of Patrick O'Brien> Sent: Thursday, September 06, 2001 8:17 AM> To: WebCatalog Talk> Subject: Re: URGENT! Locked DB's>>> Thanks for the comments.>> I upgraded to WC 3.0.7 immediately and saw a slight> performance increase. Not enough though to help matters.>> Following that I've upgraded to WC 4.0.1 and saw an immediate> performance increase. The Finder is still sluggish on the G4> 400mhz machine but at least it is workable.>> Here's the bad part, after about 2,000 hits the server starts> to puke again. Quitting Web* and restarting the application> clears things up again and then the server runs zippy as> ever. So, it looks like after a few thousand hits its bogging down.>> The only apps running on the machine are Web*, WC, Rumpus and> Emailer.>> Any other comments are appreciated. I am a little concerned> about having to throw more hardware at this situation. Thanks.> --> Sincerely,>> Patrick O'Brien Systems Adminstrator and Web Manager> Sandusky Register http://www.sanduskyregister.com> Top Interactive http://www.topinteractive.com> 419-625-5500 ext. 333>> On Thursday, September 6, 2001 10:08 AM, dale@gmr.dresdner.net wrote:> >Come on folks, 18,000 banners per day is nothing for WebCat 3.x> >on Mac OS.> >> >I am doing 5 times that amount with no problems, that is no> problems after> >upgrading to v3.0.7. and previously I was doing 50,000> pages (all with> >banners) on a processor upgraded PM 7100. It was around that> time that I> >encountered these threads as well. Trying the newer beta's> that Grant sent> >me, then sticking with the final version of 3.0.7 solved all of> >them.> >> >3.0.4 does have problems with threads, this was improved> over the next> >couple of versions. an Upgrade to 4.x can be very expensive> and possibly not> >cost effective.> >> >I have to suggest once again to simply upgrade to the 3.0.7> plugin. Takes a> >couple of minutes to download, swap out the plugins and> restart WebStar.> >After you do that, *if* you continue to have problems then I> would suggest> >possibly considering upgrading to WC4.x> >> >What is the speed/processor of the computer? If you are> using an older and> >slower machine, then that could also be contributing to the> problem. And> >that will not necessarily be solved by upgrading to 4.x.> >> >Are you running anything else on the machine that could be> taking processor> >time? e.g. FileMaker Pro> >> >> From: Paul Uttermohlen > >> Reply-To: (WebCatalog Talk)> >> Date: Thu, 6 Sep 2001 09:32:06> >> To: (WebCatalog Talk)> >> Subject: Re: URGENT! Locked DB's> >>> >> Patrick,> >>> >> You are hitting the limitations of Webcat 3.x.> >>> >> Upgrading to Webcat 4.x will solve your thread problems> which handles> >> more threads better - that section of the code was> rewritten, fairly> >> well too.> >>> >> We upgraded last year to solve the problem you are> encountering now.> >>> >> Paul> >>> >>> Our G4 is running OS 9.0.4, Web* 4.2 and WebCat Plugin> v3.0.4. 700mb. of RAM.> >>>> >>> We are getting several hundred, close to 1,000 thread.debug files> >>> generated daily. The server bogs down to incredibly slow speed and> >>> even the Finder runs extrememly slow. The following is a> snippet of> >>> what the thread.debugs tell us:> >>>> >>> 09/06/01 05:49:48 deadlocked> >>> :BannerSleuth:Banner_Dbs:logs.db, 36856393 times waiting for read> >>> 09/06/01 05:50:10 deadlocked> >>> :BannerSleuth:Banner_Dbs:logs.db, 11391157 times waiting for write> >>> 09/06/01 05:50:30 deadlocked> >>> :BannerSleuth:Banner_Dbs:logs.db, 11506693 times waiting for write> >>> 09/06/01 05:50:52 deadlocked> >>> :BannerSleuth:Banner_Dbs:logs.db, 11527617 times waiting for write> >>>> >>> Does anybody have any idea on how to combat this problem without> >>> having to throw away Bannersleuth? When I take the BannerSleuth> >>> directory out of the Web* root so that BannerSleuth won't be> >>> accessed, the server runs just fine, of course none of our banner> >>> ads appear on our sites which doesn't make our advertisers happy> >>> either. We're averaging about 18,000 page views per day which> >>> translates into about 18,000 banner views per day. When we used> >>> BannerSleuth initially on one site we only had about 2,000> >>> page/banner views per day and had no problems. I have no idea if> >>> WebCat freaks after a certain amount of traffic.> >>>> >>> Any help is greatly appreciated!!!!!!!!!!!!!!!!!!!!> >>> --> >>> Sincerely,> >>>> >>> Patrick O'Brien Systems Adminstrator> and Web Manager> >>> Sandusky Register http://www.sanduskyregister.com> >>> Top Interactive http://www.topinteractive.com> >>> 419-625-5500 ext. 333> >> >> >-------------------------------------------------------------> >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/> >>>>> -------------------------------------------------------------> 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/-------------------------------------------------------------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/ Scott Anderson

DOWNLOAD WEBDNA NOW!

Re: URGENT! Locked DB's

2001

Top Articles:

Related Readings: