Re: URGENT! Locked DB's

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38408
interpreted = N
texte = On 9/6/01 7:50 AM, Patrick O'Brien wrote:> 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!!!!!!!!!!!!!!!!!!!! Since its written to the list I will respond to the list. Just a few notes. I would highly recommend upgrading to WebCat4 it solved most of our problems right out of the box. That said we also rewrote the logging routine to compensate for 3.0's lack of volume capability, these updated routines can help and maybe the fastest/safest, but less complete fix.Additionally we found that any unix variety server is a much better banner server than MacOS classic. We also found linux to be the best price performer.I also run busy banner sites on dedicated servers so I don't take down sites on the same server if webcat crashes. I also run multiple servers and round-robin access to compensate for this under industrial strength situations. Rarely does one answer work for home, small office and Big Business. Sincerely,Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us! ------------------------------------------------------------- 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)
On 9/6/01 7:50 AM, Patrick O'Brien wrote:> 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!!!!!!!!!!!!!!!!!!!! Since its written to the list I will respond to the list. Just a few notes. I would highly recommend upgrading to WebCat4 it solved most of our problems right out of the box. That said we also rewrote the logging routine to compensate for 3.0's lack of volume capability, these updated routines can help and maybe the fastest/safest, but less complete fix.Additionally we found that any unix variety server is a much better banner server than MacOS classic. We also found linux to be the best price performer.I also run busy banner sites on dedicated servers so I don't take down sites on the same server if webcat crashes. I also run multiple servers and round-robin access to compensate for this under industrial strength situations. Rarely does one answer work for home, small office and Big Business. Sincerely,Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us! ------------------------------------------------------------- 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/ Bob Minor

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:

Uploading Files and Descriptions W* (2000) Attn: Bug in GeneralStore example b15 (1997) custom freight charges (2001) Emailing a Database Record (2002) Not really WebCat- (1997) AuthorizeNet Bug (2002) Alternating BGColors in Table Rows (1998) can WC render sites out? (1997) [TaxableTotal] - not working with AOL and IE (1997) Upload to LINUX always breaks my sites - why? (2004) Extended [ConvertChars] (1997) & in Lookups (1997) Possible Bug in 2.0b15.acgi (1997) [WebDNA] Dead line Time Math (2017) Re2: frames & carts (1997) Serving images from databases (1998) [group] ? (1997) Authorize.net setup (2002) Location of Browser Info.txt file (1997) no global [username] or [password] displayed ... (1997)