Re: WebDNA deletes major DB data big time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55748
interpreted = N
texte = I recently had the same thing happen to me. We had 2 months of data deleted. It seemed random and I spent a week trying to figure out how it happen. Same thing with me, no hints, no logs, everything seemed normal. My company had to spend $3700 US in our own labor costs to recreate all the date and contact all the people effected. Then 2 weeks later it happen again! But this time I was able to trace steps because I was waiting for it to happen. It turned out that a delete routine I had written, which touched all the databases effected, had a run time error. The specifics were that I passed the delete routing a few variables, but some of the variables and header names did not match the headers for the databases. (simple ex: eqSKUdatarq=[sku] when it should have been written as eqRSKUdata=[sku]) The end result was that I had seemingly random data loss, when actually the data loss was rather specific to the variable passed, or rather, incorrectly passed. Even though it cost us a lot of money to correct the problem... TWICE.. I was very happy to say it was a programming glitch rather than a WebDNA credibility issue. However I now have a cron job backing up our databases every day in addition to the tape backup every night. Matt Perosi nj-singles.com ijo.com Palle Bo Nielsen wrote: > No log-file tells anything about the accident. Not WebDNA, Not Mac OS > X, Not WebSTAR, Nothing...! > > I will naturally continue to try to find an explanation but if I can't > find any clue or hint it really hits the credibility of WebDNA... > especially when others have been reporting this earlier on too without > any solution. > > I hope there is an explanations to the event which occurred today on > our server. > > Palle > > > On 28/1-2004, at 18.39, Clint Davis wrote: > >> This has been discussed before, and it happened to me too. I don't >> know if >> anyone had an explanation for it. >> >> >> On 1/28/04 11:04 AM, "Palle Bo Nielsen" >> wrote: >> >>> Nice surprise today, when I arrived at the office. My main WebDNA >>> databases had been almost entirely deleted. All data from todays date >>> and back to June 2003 was gone... and that a lot of data due to the >>> fact that I am running very popular IT news sites in Danish... >>> >>> Dunno what has happened - investigation starts now ! >> >> >> >> ------------------------------------------------------------- >> 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/ >> >> > > -- > Venlig hilsen > Palle B. Nielsen (PowerPalle) > http://www.macnyt.dk/ > > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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 recently had the same thing happen to me. We had 2 months of data deleted. It seemed random and I spent a week trying to figure out how it happen. Same thing with me, no hints, no logs, everything seemed normal. My company had to spend $3700 US in our own labor costs to recreate all the date and contact all the people effected. Then 2 weeks later it happen again! But this time I was able to trace steps because I was waiting for it to happen. It turned out that a delete routine I had written, which touched all the databases effected, had a run time error. The specifics were that I passed the delete routing a few variables, but some of the variables and header names did not match the headers for the databases. (simple ex: eqSKUdatarq=[sku] when it should have been written as eqRSKUdata=[sku]) The end result was that I had seemingly random data loss, when actually the data loss was rather specific to the variable passed, or rather, incorrectly passed. Even though it cost us a lot of money to correct the problem... TWICE.. I was very happy to say it was a programming glitch rather than a WebDNA credibility issue. However I now have a cron job backing up our databases every day in addition to the tape backup every night. Matt Perosi nj-singles.com ijo.com Palle Bo Nielsen wrote: > No log-file tells anything about the accident. Not WebDNA, Not Mac OS > X, Not WebSTAR, Nothing...! > > I will naturally continue to try to find an explanation but if I can't > find any clue or hint it really hits the credibility of WebDNA... > especially when others have been reporting this earlier on too without > any solution. > > I hope there is an explanations to the event which occurred today on > our server. > > Palle > > > On 28/1-2004, at 18.39, Clint Davis wrote: > >> This has been discussed before, and it happened to me too. I don't >> know if >> anyone had an explanation for it. >> >> >> On 1/28/04 11:04 AM, "Palle Bo Nielsen" >> wrote: >> >>> Nice surprise today, when I arrived at the office. My main WebDNA >>> databases had been almost entirely deleted. All data from todays date >>> and back to June 2003 was gone... and that a lot of data due to the >>> fact that I am running very popular IT news sites in Danish... >>> >>> Dunno what has happened - investigation starts now ! >> >> >> >> ------------------------------------------------------------- >> 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/ >> >> > > -- > Venlig hilsen > Palle B. Nielsen (PowerPalle) > http://www.macnyt.dk/ > > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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/ Matthew A Perosi

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:

Text data with spaces in them... (1997) Help formatting search results w/ table (1997) Site Test Please (2005) customizing the color of user's pages (1997) Bug or syntax error on my part? (1997) [append] and SSL (1997) A question on sub-categories (1997) Webcat/Webmerchant part II (1998) PIXO Support (1997) Running _every_ page through WebCat ? (1997) Re:Emailer tracking (1997) Don't tick me off :) [elaspedtime] (1997) Help!!!! Purchases not going through! FIXED! (1997) WebCatalog dying in NT (1998) Changing price for a SLU based on options (size, etc.) (1997) Auto Unsubscribe (2000) problems with 2 tags (1997) OK, here goes... (1997) Emailer again (1997) Fun with dates (1997)