Re: WebDNA deletes major DB data big time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55756
interpreted = N
texte = I've seen this happen as well. It prompted me to put together the transaction-based version of DBEdit (available at genericaddress.com). While this isn't plug-and-play and requires effort to retrofit to existing code, I like the concept of tracking all DB modifications so you can rebuild a corrupted or deleted database. The side benefit is that you can get back deleted records or modifications for your clients if they make a mistake. If you've ever had to use the rollback functions in SQL Server you'll appreciate what this does. Daily or hourly backups always miss recent data. Lastly, since this is in WebDNA, you have much more ability to selectively restore the saved transactions - unlike SQL Server. If WebDNA ever allowed you to overload the DB functions then you could integrate something like this seamlessly. John. At 2:23 PM -0500 1/28/04, Alex McCombie wrote: >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/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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://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)
I've seen this happen as well. It prompted me to put together the transaction-based version of DBEdit (available at genericaddress.com). While this isn't plug-and-play and requires effort to retrofit to existing code, I like the concept of tracking all DB modifications so you can rebuild a corrupted or deleted database. The side benefit is that you can get back deleted records or modifications for your clients if they make a mistake. If you've ever had to use the rollback functions in SQL Server you'll appreciate what this does. Daily or hourly backups always miss recent data. Lastly, since this is in WebDNA, you have much more ability to selectively restore the saved transactions - unlike SQL Server. If WebDNA ever allowed you to overload the DB functions then you could integrate something like this seamlessly. John. At 2:23 PM -0500 1/28/04, Alex McCombie wrote: >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/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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://webdna.smithmicro.com/ John Hill

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:

Applescript in Webcatalog problem (1997) [table] tag (2003) [WebDNA] Is there a D.E. database record limit? (2014) WebDNA tags in WebMerchant email templates ... (1997) $Replace with [founditems] (1997) Multiple Sendmail Tags on One Page (2008) [WriteFile] problems (1997) [WebDNA] WebDNA Health Monitor (2014) [WebDNA] Can webDNA be forced to be able to read ANY file in ANY folder in a webroot in =?UTF-8?Q?CentOS=3F?= (2018) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) External RAID (2005) [SHOWIF AND/OR] (1997) Grep to convert characters to html entities (2006) Carts in Admin folder? (1999) WC2b15 File Corruption (1997) [ShowIf] if the varieable exists (1998) problems with 2 tags (1997) WebCat for Unix?? (1997) Running 2 two WebCatalog.acgi's (1996) OT Cookie limit (2001)