Re: Mass deletion of records
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66157
interpreted = N
texte = Ken I just can't figure it out, the drive is a RAID 5 . What has me wondering is the link that I posted earlier where others were reporting the same problems. Stuart Tremain idfk web developments, sydney, australia On 31 Jan 2006, at 4:34 PM, Kenneth Grome wrote: > That was just a wild guess because I couldn't think of anything > else that might be causing it ... but if you've got a lot more RAM > than you need, then that's certainly not it, is it? > > Seems rather strange that you'd be having these problems all of a > sudden when you haven't changed any code in a couple years and you > never had the problem until recently. > > Maybe someone else has changed your code without your knowledge? > Or someone has found a way to hack the server somehow? Once again > I'm just grasping at straws because I've never seen this problem > before, but when something new like this starts to happen I always > look for anything that might possibly have changed to cause it, > even if it's not likely. > > I don't imagine that SMSI will do anything about this if in fact it > is the WebDNA software that's failing, so if you never figure it > out yourself I guess the next best thing is to just create those > automatic backups periodically -- and save them on another drive so > if the existing drive craps out on you then at least you won't lose > your data. > > That brings up the question of whether or not the drive is already > starting to crap out on you, doesn't it? Maybe this has nothing to > do with WebDNA and everything to do with a failing hard drive ... ? > > Sincerely, > Kenneth Grome > www.kengrome.com > > > > > > On Tue, 31 Jan 2006 16:24:44 +1100, Stuart Tremain wrote: >> Ken >> >> I recently took a website off the server and put it on its own server >> to free things up. The server is now overspeced for the amount of >> work that it does. The dbs total less than 8 megs and the db in >> question only has 2100 records. >> >> The server has 2gb RAM. >> >> Stuart Tremain >> idfk web developments, sydney, australia >> >> >> On 31 Jan 2006, at 4:18 PM, Kenneth Grome wrote: >> >>> Maybe you need more RAM because the db's are getting too big and >>> webdna is failing to save the data properly to disk when it has to >>> close one db in order to open another one ... >>> >>> Sincerely, >>> Kenneth Grome >>> www.kengrome.com >>> >>> >>> >>> >>> >>> On Tue, 31 Jan 2006 15:22:47 +1100, Stuart Tremain wrote: >>>> Donovan >>>> >>>> Did you read that link I sent. >>>> >>>> Yes I had backups but they only happen once a day (every hour now) >>>> >>>> Yesterday over 900 records were deleted - yes GONE. >>>> >>>> Within the sandbox that the db resides in there is not one [delete] >>>> in any of the code ! Delete command is disabled. >>>> >>>> The db has been stable for years and in the past 2 weeks it has >>>> dumped records 3 times. >>>> >>>> And yes nothing like this has happened to me EVER in 8 years ! I >>>> always wondered what it would feel like to see an almost empty db, >>>> let me tell you it isn't great! >>>> >>>> Stuart Tremain >>>> idfk web developments, sydney, australia >>>> >>>> >>>> On 31 Jan 2006, at 3:09 PM, Donovan Brooke wrote: >>>> >>>>> Stuart Tremain wrote: >>>>> >>>>>> I have had a mass deletion of records from a db that has ben >>>>>> stable for a number of years, no work has been done to any of >>>>>> the >>>>>> system that would delete records. There is not even a >>>>>> [Delete] in >>>>>> the site. >>>>>> I noted in the archives other people having this 'mystery' >>>>>> deletion. Has anyone come up with an answer ? >>>>> >>>>> >>>>> Stuart, >>>>> I'm not saying it didn't happen... but nothing in your >>>>> statement makes me certain that this is just some sort of majic >>>>> deletion. >>>>> There are so many possibilities for mass data deletion that stem >>>>> from bad code that it makes it hard for me to believe anyone when >>>>> they say this has happened... (knock on wood). Just because it >>>>> baffells >>>>> someone, doesn't mean its majic. I get baffelled in one way or >>>>> another >>>>> most everytime I code something significant. >>>>> >>>>> Is there a interpret tag in your "site" somewhere? >>>>> Is there a bad CR in your database. >>>>> What do you mean by "Site" (you have to be weary of *any* code >>>>> that can >>>>> reach that database). >>>>> Are the records *deleted* for sure, or have the values been >>>>> replaced? >>>>> What kind of commands do you allow? >>>>> What platform/permissions. >>>>> >>>>> Again, I'm not saying some wierd bug didn't happen. I'm just >>>>> saying that >>>>> I've have never had any mass deletions.. and I'm anxiously >>>>> anticipating it.. >>>>> because at least I could troubleshoot for myself (and my system is >>>>> backed up daily). >>>>> >>>>> I've done quite a lot of code for ppl and as far as I know, >>>>> nothing like >>>>> this has happened (that couldn't be explained). >>>>> >>>>> At any right, sorry that it happened, and I hope you had backups. >>>>> >>>>> Donovan >>>>> >>>>> >>>>> >>>>> -- >>>>> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >>>>> DONOVAN D. BROOKE EUCA Design Center >>>>> >>>>> <- Web Development (specializing in eCommerce),-> >>>>> <- Custom Paint, Labels, and Specialty Signage. -> >>>>> <- Home and Business Embellishment/Fabrication, -> >>>>> <- Glass Blowing, and Art Glass -> >>>>> >>>>> PH/FAX:> 1 (608) 835-2476 >>>>> Web:> http://www.egg.bz | http://www.euca.us >>>>> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >>>>> >>>>> ------------------------------------------------------------- >>>>> 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/ >>>> >>>> >>> >>> ------------------------------------------------------------- >>> 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/ >> >> > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > 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:
Ken I just can't figure it out, the drive is a RAID 5 . What has me wondering is the link that I posted earlier where others were reporting the same problems. Stuart Tremain idfk web developments, sydney, australia On 31 Jan 2006, at 4:34 PM, Kenneth Grome wrote: > That was just a wild guess because I couldn't think of anything > else that might be causing it ... but if you've got a lot more RAM > than you need, then that's certainly not it, is it? > > Seems rather strange that you'd be having these problems all of a > sudden when you haven't changed any code in a couple years and you > never had the problem until recently. > > Maybe someone else has changed your code without your knowledge? > Or someone has found a way to hack the server somehow? Once again > I'm just grasping at straws because I've never seen this problem > before, but when something new like this starts to happen I always > look for anything that might possibly have changed to cause it, > even if it's not likely. > > I don't imagine that SMSI will do anything about this if in fact it > is the WebDNA software that's failing, so if you never figure it > out yourself I guess the next best thing is to just create those > automatic backups periodically -- and save them on another drive so > if the existing drive craps out on you then at least you won't lose > your data. > > That brings up the question of whether or not the drive is already > starting to crap out on you, doesn't it? Maybe this has nothing to > do with WebDNA and everything to do with a failing hard drive ... ? > > Sincerely, > Kenneth Grome > www.kengrome.com > > > > > > On Tue, 31 Jan 2006 16:24:44 +1100, Stuart Tremain wrote: >> Ken >> >> I recently took a website off the server and put it on its own server >> to free things up. The server is now overspeced for the amount of >> work that it does. The dbs total less than 8 megs and the db in >> question only has 2100 records. >> >> The server has 2gb RAM. >> >> Stuart Tremain >> idfk web developments, sydney, australia >> >> >> On 31 Jan 2006, at 4:18 PM, Kenneth Grome wrote: >> >>> Maybe you need more RAM because the db's are getting too big and >>> webdna is failing to save the data properly to disk when it has to >>> close one db in order to open another one ... >>> >>> Sincerely, >>> Kenneth Grome >>> www.kengrome.com >>> >>> >>> >>> >>> >>> On Tue, 31 Jan 2006 15:22:47 +1100, Stuart Tremain wrote: >>>> Donovan >>>> >>>> Did you read that link I sent. >>>> >>>> Yes I had backups but they only happen once a day (every hour now) >>>> >>>> Yesterday over 900 records were deleted - yes GONE. >>>> >>>> Within the sandbox that the db resides in there is not one [delete] >>>> in any of the code ! Delete command is disabled. >>>> >>>> The db has been stable for years and in the past 2 weeks it has >>>> dumped records 3 times. >>>> >>>> And yes nothing like this has happened to me EVER in 8 years ! I >>>> always wondered what it would feel like to see an almost empty db, >>>> let me tell you it isn't great! >>>> >>>> Stuart Tremain >>>> idfk web developments, sydney, australia >>>> >>>> >>>> On 31 Jan 2006, at 3:09 PM, Donovan Brooke wrote: >>>> >>>>> Stuart Tremain wrote: >>>>> >>>>>> I have had a mass deletion of records from a db that has ben >>>>>> stable for a number of years, no work has been done to any of >>>>>> the >>>>>> system that would delete records. There is not even a >>>>>> [delete] in >>>>>> the site. >>>>>> I noted in the archives other people having this 'mystery' >>>>>> deletion. Has anyone come up with an answer ? >>>>> >>>>> >>>>> Stuart, >>>>> I'm not saying it didn't happen... but nothing in your >>>>> statement makes me certain that this is just some sort of majic >>>>> deletion. >>>>> There are so many possibilities for mass data deletion that stem >>>>> from bad code that it makes it hard for me to believe anyone when >>>>> they say this has happened... (knock on wood). Just because it >>>>> baffells >>>>> someone, doesn't mean its majic. I get baffelled in one way or >>>>> another >>>>> most everytime I code something significant. >>>>> >>>>> Is there a interpret tag in your "site" somewhere? >>>>> Is there a bad CR in your database. >>>>> What do you mean by "Site" (you have to be weary of *any* code >>>>> that can >>>>> reach that database). >>>>> Are the records *deleted* for sure, or have the values been >>>>> replaced? >>>>> What kind of commands do you allow? >>>>> What platform/permissions. >>>>> >>>>> Again, I'm not saying some wierd bug didn't happen. I'm just >>>>> saying that >>>>> I've have never had any mass deletions.. and I'm anxiously >>>>> anticipating it.. >>>>> because at least I could troubleshoot for myself (and my system is >>>>> backed up daily). >>>>> >>>>> I've done quite a lot of code for ppl and as far as I know, >>>>> nothing like >>>>> this has happened (that couldn't be explained). >>>>> >>>>> At any right, sorry that it happened, and I hope you had backups. >>>>> >>>>> Donovan >>>>> >>>>> >>>>> >>>>> -- >>>>> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >>>>> DONOVAN D. BROOKE EUCA Design Center >>>>> >>>>> <- Web Development (specializing in eCommerce),-> >>>>> <- Custom Paint, Labels, and Specialty Signage. -> >>>>> <- Home and Business Embellishment/Fabrication, -> >>>>> <- Glass Blowing, and Art Glass -> >>>>> >>>>> PH/FAX:> 1 (608) 835-2476 >>>>> Web:> http://www.egg.bz | http://www.euca.us >>>>> =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o >>>>> >>>>> ------------------------------------------------------------- >>>>> 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/ >>>> >>>> >>> >>> ------------------------------------------------------------- >>> 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/ >> >> > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > 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/
Stuart Tremain
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:
GuestBook example (1997)
Date search - yes or no (1997)
Separate SSL Server (1997)
Enhancement Request for WebCatalog-NT (1996)
ShowIf & CountChars (2000)
error -108 (1997)
[WebDNA] [OT] the "Work in progress" thread. (2009)
StoreBuilder UPS/XML code question ... (2003)
ListFiles and NT Email Sender 2nd Answer (2000)
Internet Explorer 6 Form problems (2005)
Search Form (2000)
Replto in [SendMail] (2000)
[WebDNA] Dreamweaver Tag Libraries and Snippets (2010)
New Command prefs ... (1997)
RE: OK, here goes... (1997)
serial number generation (1997)
WebMerchant 1.6 and SHTML (1997)
[URL] around a [sendmail] recipient? (2000)
blank page from template (1997)
Loop context to replace items (1998)