Re: WebDNA deletes major DB data big time
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55757
interpreted = N
texte = I very rarely use delete in database. I prefer to set a status to Zero (0) to avoid things like this. Btw... my system is...: Mac OS X Server v10.2.8 WebSTAR V WebDNA 5.x Palle On 28/1-2004, at 19.51, Matthew A Perosi wrote: > 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/ > > -- 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/
Associated Messages, from the most recent to the oldest:
I very rarely use delete in database. I prefer to set a status to Zero (0) to avoid things like this. Btw... my system is...: Mac OS X Server v10.2.8 WebSTAR V WebDNA 5.x Palle On 28/1-2004, at 19.51, Matthew A Perosi wrote: > 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/ > > -- 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/
Palle Bo Nielsen
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:
Re:Random Command (1997)
PIXO support (1997)
Attn: Power Palle (2004)
Multiple prices (1997)
WebMerchant Setup: Which card processor to use? (2000)
Blog solution (2006)
Uploading out of FMP (2001)
two forms of delivery (1998)
What am I missing (1997)
[OT] MS Security Flaw (2000)
webcat- multiple selection in input field (1997)
WebCat2b15MacPlugin - showing [math] (1997)
WebCatalog stalls (1998)
More Shopping Cart Problems (2000)
multiple search commands (1997)
ListFiles Bug (1998)
autocommit problem (1998)
[convertchars] HELP!!! (1999)
Removing [showif] makes a big difference in speed (1997)
multiple search commands (1997)