Re: Mass deletion of records
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66156
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
Merging databases (1997)
WebDNA Solutions ... (1997)
SiteEdit Pro Update Announcement (1997)
A dynamic database. (1997)
Width & Height (1998)
WebDelivery downloads alias, not original ? (1997)
PSC recommends what date format yr 2000??? (1997)
pop up menu's (1998)
Add a field to the error log? (1997)
Include file not working on remote directory. (2004)
Custom Shipping Charges (1997)
Summing fields (1997)
emailer (1997)
SetHeader (1997)
RE: Sum of Quantities (1997)
& problem (1999)
WebCatalog + WebMerchant 2.1 for Windows released (1998)
Logging purchases (1997)
[urgent] Phone number at SM (2006)
Re:Emailer and encryption (1997)