Re: WebDNA deletes major DB data big time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55755
interpreted = N
texte = Macintosh Plugin version 4.5.1 Memory available to WebDNA - Commerce Edition 48,406 K (after all DB's are open) We have something like this happen from time to time. Its always on a Db that has the following specs: 46176 records, using 23,769K of RAM 13 fields Periodically we get a unable to open the db for insufficient memory, though there is clearly enough memory available at the time. Typically this causes a nuisance as the db is unavailable for reading while still allowing it to be written to (its a discussion forum). On a few occasions (3), in conjunction with this error, we ended up with a severely truncated DB. 46,000 turned into 2000 or so. Backups needed to be called upon. However, even when the DB wasn't truncated, restarting the machine (reboot) was the only way to solve the issue and any records that had been 'added' after the memory error we lost on the reboot. I have since started committing the DB on every addition, which really hits performance on a 23 meg DB. But it is the only way I can be secure that new entries wont be lost in the memory void when this occurs. Anyway... Doubt this will help because of the randomness of my issue as well as everyone elses...but always nice to have someone to share pain with ;-) Alex Alex J McCombie New World Media Chief Information Officer Box 124 888/892.6379 MartVille, NY 13111 Alex@NewWorldMedia.com http://OurClients.com Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  2. Re: WebDNA deletes major DB data big time ( John Hill 2004)
  3. Re: WebDNA deletes major DB data big time ( Matthew A Perosi 2004)
  4. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  5. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  6. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  7. Re: WebDNA deletes major DB data big time ( Gary Krockover 2004)
  8. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  9. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  10. Re: WebDNA deletes major DB data big time ( Chris List Recipient 2004)
  11. Re: WebDNA deletes major DB data big time ( "Vincent Medina" 2004)
  12. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  13. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  14. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  15. Re: WebDNA deletes major DB data big time ( John Hill 2004)
  16. Re: WebDNA deletes major DB data big time ( Alex McCombie 2004)
  17. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  18. Re: WebDNA deletes major DB data big time ( Marc Kaiwi 2004)
  19. Re: WebDNA deletes major DB data big time ( Karl Schroll 2004)
  20. Re: WebDNA deletes major DB data big time ( Clint Davis 2004)
  21. Re: WebDNA deletes major DB data big time ( Marc Kaiwi 2004)
  22. Re: WebDNA deletes major DB data big time ( "Brian Boegershausen" 2004)
  23. Re: WebDNA deletes major DB data big time ( Matthew A Perosi 2004)
  24. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  25. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  26. Re: WebDNA deletes major DB data big time ( Clint Davis 2004)
  27. Re: WebDNA deletes major DB data big time ( "Morten Madsen" 2004)
  28. WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
Macintosh Plugin version 4.5.1 Memory available to WebDNA - Commerce Edition 48,406 K (after all DB's are open) We have something like this happen from time to time. Its always on a Db that has the following specs: 46176 records, using 23,769K of RAM 13 fields Periodically we get a unable to open the db for insufficient memory, though there is clearly enough memory available at the time. Typically this causes a nuisance as the db is unavailable for reading while still allowing it to be written to (its a discussion forum). On a few occasions (3), in conjunction with this error, we ended up with a severely truncated DB. 46,000 turned into 2000 or so. Backups needed to be called upon. However, even when the DB wasn't truncated, restarting the machine (reboot) was the only way to solve the issue and any records that had been 'added' after the memory error we lost on the reboot. I have since started committing the DB on every addition, which really hits performance on a 23 meg DB. But it is the only way I can be secure that new entries wont be lost in the memory void when this occurs. Anyway... Doubt this will help because of the randomness of my issue as well as everyone elses...but always nice to have someone to share pain with ;-) Alex Alex J McCombie New World Media Chief Information Officer Box 124 888/892.6379 MartVille, NY 13111 Alex@NewWorldMedia.com http://OurClients.com Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- 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://webdna.smithmicro.com/ Alex McCombie

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:

More news on 5.0 (2003) Non-Cart Files in Shopping Cart Folder (1997) Using copyfolder (2001) Bug Report, maybe (1997) WebCatalog can't find database (1997) Anyone have an invoicing system? (1999) Encrypt/Decrypt (2007) If search results are blank... (2003) View order not right (1997) [WebDNA] Bug in WebDNA or in my brain? (2013) # fields limited? (1997) Using Currencies other than Dollars (1997) Stumpted Again (1997) WebCat and image maps (1997) WebCat2 beta 11 - new prefs ... (1997) Re:emailer 150 (1997) [Shell]ps -A[/Shell] Linux Webcat Q (2000) Database on the same server but with different domains (2000) WebCatalog 4 Install Problems - Not Answered ?? (2000) Digest Version (2000)