Re: URGENT! Locked DB's

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38409
interpreted = N
texte = 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/__________________________ Paul Uttermohlen Chief Technical Officer Interactive Ink, Incorporated http://www.InteractiveInk.com 614.221.7089 extension 121 E-Business Made Easy __________________________------------------------------------------------------------- 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: URGENT! Locked DB's (Patrick O'Brien 2001)
  2. Re: URGENT! Locked DB's (Dale LaFountain 2001)
  3. Re: URGENT! Locked DB's (Patrick O'Brien 2001)
  4. Re: URGENT! Locked DB's (Scott Anderson 2001)
  5. Re: URGENT! Locked DB's (Christer Olsson 2001)
  6. Re: URGENT! Locked DB's (Paolo Coppo 2001)
  7. Re: URGENT! Locked DB's (Patrick O'Brien 2001)
  8. Re: URGENT! Locked DB's (dale 2001)
  9. Re: URGENT! Locked DB's (Paul Uttermohlen 2001)
  10. Re: URGENT! Locked DB's (Bob Minor 2001)
  11. Re: URGENT! Locked DB's (dale 2001)
  12. URGENT! Locked DB's (Patrick O'Brien 2001)
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/__________________________ Paul Uttermohlen Chief Technical Officer Interactive Ink, Incorporated http://www.InteractiveInk.com 614.221.7089 extension 121 E-Business Made Easy __________________________------------------------------------------------------------- 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/ 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:

Need relative path explanation (1997) WebCat b13 CGI -shownext- (1997) variables in [addlineitem] (1998) RE: type 2 errors with ssl server (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) creator code (1997) all records returned. (1997) Moment of Thanks (1997) [WebDNA] Dynamic server feedback? (2009) Re:[input] context (1999) [protect admin] (1997) New public beta available (1997) Problems appending to database (1997) [WebDNA] Spambots, message boards and such (was: Still having problems) (2008) Protecting webdelivery (1997) [WebDNA] [ipaddress] - [RealIP] - Not working properly (2016) AddLineItem Problem (1997) Error messages (2004) f2 download problems (1997) [writefile] remotely (2000)