Re: Disappearing data

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43023
interpreted = N
texte = Ken, Our databases are over 175K records (about 30Mb) and the systems had 2 Gb RAM each with no other aps running. Tim On Fri, 30 Aug 2002, Kenneth Grome wrote:> >We started having a number of random problems: > >> - Frequent WebDNA service shut downs > > > >Tim, if your WebDNA crashes you have a chance of loosing > >any new data that has not been written to the hard disk. > >Make sure your databases are committed often enough. > > This will not solve the problem if the RAM-cached data gets screwed > up and then WebDNA writes that bad data to disk thereby overwriting > the 'good' data that was stored on disk. The only real solution to > this problem is to duplicate your db files at periodic intervals, and > then preferably to store those duplicates offline or on another > volume. > > > >We have 1500 products or so in our main store and > >haven't lost a single character. > >Site has been running for approx. 8 months or so now. > >MacOS - 4.5 > > 1500 products is a very small db compared to the db's some other > people are using. And this problem may also be related to how busy > the store is. It may just be that you will never see the same > problems others are experiencing -- until your db gets big enough to > start creating those problems, or until your store gets so busy that > ot severely taxes webcat's ability to keep up with the traffic. > > I would tend to think that this data loss problem may have something > to do with how much RAM is available for the webcat db's to reside > in. If RAM is too limited then webcat has to perform repetitive db > swaps into and out of memory. If this is happening a lot, especially > on a busy site, it seems like there would be a much higher chance for > data corruption (since there's far more writing of data to disk) than > on a site that never has to swap db's into and out of RAM ... > > > Sincerely, > Kenneth Grome > > --------------------------------------------------- > WebDNA Professional Training and Development Center > 175 J. Llorente Street +63 (32) 255-6921 > Cebu City, Cebu 6000 kengrome@webdna.net > Philippines http://www.webdna.net > --------------------------------------------------- > > ------------------------------------------------------------- > 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:

    
  1. Re: Disappearing data (Timur Ruban 2002)
  2. Re: Disappearing data (Timur Ruban 2002)
  3. Re: Disappearing data (Kenneth Grome 2002)
  4. Re: Disappearing data (Donovan Brooke 2002)
  5. Re: Disappearing data [OT] (Donovan Brooke 2002)
  6. Re: Disappearing data (Bob Minor 2002)
  7. Re: Disappearing data (Dan Strong 2002)
  8. Re: Disappearing data (Kenneth Grome 2002)
  9. Re: Disappearing data (Timur Ruban 2002)
  10. Re: Disappearing data (Dan Strong 2002)
  11. Re: Disappearing data [OT] (Rob Marquardt 2002)
  12. Re: Disappearing data (Sal D'anna 2002)
  13. Re: Disappearing data (Donovan Brooke 2002)
  14. Re: Disappearing data (Timur Ruban 2002)
  15. Re: Disappearing data (marc malacarme 2002)
  16. Disappearing data (Timur Ruban 2002)
  17. Re: Disappearing Databases (Larry Hewitt 2000)
  18. Re: Disappearing Databases (Kenneth Grome 2000)
  19. Re: Disappearing Databases (Larry Hewitt 2000)
  20. Re: Disappearing Databases (Kenneth Grome 2000)
  21. Re: Disappearing Databases (Paul Uttermohlen 2000)
  22. Re: Disappearing Databases (Kenneth Grome 2000)
  23. Disappearing Databases (Alex Cheparev 2000)
  24. Re: Disappearing Database (Ross Markbreiter 1998)
  25. Disappearing Database (Angel Bennett 1998)
Ken, Our databases are over 175K records (about 30Mb) and the systems had 2 Gb RAM each with no other aps running. Tim On Fri, 30 Aug 2002, Kenneth Grome wrote:> >We started having a number of random problems: > >> - Frequent WebDNA service shut downs > > > >Tim, if your WebDNA crashes you have a chance of loosing > >any new data that has not been written to the hard disk. > >Make sure your databases are committed often enough. > > This will not solve the problem if the RAM-cached data gets screwed > up and then WebDNA writes that bad data to disk thereby overwriting > the 'good' data that was stored on disk. The only real solution to > this problem is to duplicate your db files at periodic intervals, and > then preferably to store those duplicates offline or on another > volume. > > > >We have 1500 products or so in our main store and > >haven't lost a single character. > >Site has been running for approx. 8 months or so now. > >MacOS - 4.5 > > 1500 products is a very small db compared to the db's some other > people are using. And this problem may also be related to how busy > the store is. It may just be that you will never see the same > problems others are experiencing -- until your db gets big enough to > start creating those problems, or until your store gets so busy that > ot severely taxes webcat's ability to keep up with the traffic. > > I would tend to think that this data loss problem may have something > to do with how much RAM is available for the webcat db's to reside > in. If RAM is too limited then webcat has to perform repetitive db > swaps into and out of memory. If this is happening a lot, especially > on a busy site, it seems like there would be a much higher chance for > data corruption (since there's far more writing of data to disk) than > on a site that never has to swap db's into and out of RAM ... > > > Sincerely, > Kenneth Grome > > --------------------------------------------------- > WebDNA Professional Training and Development Center > 175 J. Llorente Street +63 (32) 255-6921 > Cebu City, Cebu 6000 kengrome@webdna.net > Philippines http://www.webdna.net > --------------------------------------------------- > > ------------------------------------------------------------- > 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/ Timur Ruban

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:

Forcing a NEWCART (1997) WC Database Format (1997) syntax question, not in online refernce (1997) WebCatalog can't find database (1997) Summary search -- speed (1997) [isfile] ? (1997) price carry over (1997) Mass deletion of records (2006) Frames and WebCat (1997) P.S.: What kind of request is this? (2002) Spontaneous Errors (2004) CSS positioning!!! (2001) my price won't move (1997) Displaying raw values (long) (1998) Running _every_ page through WebCat ? (1997) Webcat Crashing Error 1701 (2000) WebCat2_Mac RETURNs in .db (1997) international time (1997) Shipping cost out of synch (1998) b18 problem on NT 4.0 (1997)