Re: Mass deletion of records
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66158
interpreted = N
texte = One more thing, I used to have "strange problems" with WebDNA not interpreting its code properly from time to time, and the only way I could fix the problem was to reboot the server or the WebDNA software. It seems that whatever was causing the "glitch" was cleared after the reboot. I don't remember if you said that you tried this yet, but it probably wouldn't hurt ... Sincerely, Kenneth Grome www.kengrome.com On Tue, 31 Jan 2006 13:34:28 +0800, 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 > > 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:
One more thing, I used to have "strange problems" with WebDNA not interpreting its code properly from time to time, and the only way I could fix the problem was to reboot the server or the WebDNA software. It seems that whatever was causing the "glitch" was cleared after the reboot. I don't remember if you said that you tried this yet, but it probably wouldn't hurt ... Sincerely, Kenneth Grome www.kengrome.com On Tue, 31 Jan 2006 13:34:28 +0800, 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 > > 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/
Kenneth Grome
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:
Pull Down Search (2000)
Archives not sorting properly (2003)
sendmail spaces (1997)
How true is this? (1999)
Am I going senile? (Price recalc based on quantity) (1997)
WebCatalog Hosting (1996)
Emailer setup (1997)
attn: smitmicro - cart limitation (2002)
Subject: SMSI, please fix the StandardConversions.db (2005)
Re:Review comparison by PC Magazine: Open for On-line Business (1997)
PCS Customer submissions ? (1997)
[isfolder] and [filename] (1997)
WebCatalog for guestbook ? (1997)
question: back button prevention (1997)
[WebDNA] Exclude found items in a 2nd search (2016)
I'm new be kind (1997)
Bug Report, maybe (1997)
Email Problem (1997)
referrer & truncation (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)