Re: [WebDNA] Triggers.db wiped completely blank

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107855
interpreted = N
texte = Hi Ken! just tested the worst possible situation with the triggers: - WebDNA commits databases to disk only when instructed - added two triggers - kill -9 webdna.fcgi - new call to webdna (to wake it up again) - check that the PID is a new one (confirm that WebDNA has been closed = and restarted) - check the triggers: they are still there - chris On Dec 30, 2011, at 12:07, Kenneth Grome wrote: > I just learned that something completely wiped out my=20 > Triggers.db 7 days ago -- it is completely blank -- and I=20 > have no idea what might have caused this. =20 >=20 > Does anyone else have a clue why this might happen? >=20 > Along with other things I was using it to bill clients=20 > automatically. But the bills never went out last week,=20 > which explains why I never got paid this week. =20 >=20 > I'm going to recreate my triggers, and I'm adding a new=20 > trigger -- one that will send me an email every day to=20 > confirm that triggers are still working. Then I will know=20 > when this happens again from the lack of a daily email,=20 > rather than learning about it a week later. But this does=20 > not make me feel any more confident about trusting triggers,=20 > and that's why I am hoping for an explanation of how this=20 > could have happened in the first place. >=20 > I have not made any config changes on the server in months,=20 > nor has anyone else -- except possibly the hosting company=20 > -- and I do not understand how the hosting company's=20 > potential changes might have wiped out my Triggers.db while=20 > leaving all the other db's intact and functioning properly. >=20 > The only thing I can think of is that maybe the=20 > flushdatabases tag does NOT flush the Triggers.db to disk, so=20 > the Triggers.db always remains volatile in RAM ... and=20 > therefore it is subject to being wiped out when the server=20 > crashes or the VPS is moved to a different computer. >=20 > ??? >=20 > Sincerely, > Kenneth Grome > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Triggers.db wiped completely blank (christophe.billiottet@webdna.us 2011)
  2. Re: [WebDNA] Triggers.db wiped completely blank (Donovan Brooke 2011)
  3. Re: [WebDNA] Triggers.db wiped completely blank (Kenneth Grome 2011)
  4. Re: [WebDNA] Triggers.db wiped completely blank (Kenneth Grome 2011)
  5. Re: [WebDNA] Triggers.db wiped completely blank (Kenneth Grome 2011)
  6. Re: [WebDNA] Triggers.db wiped completely blank (christophe.billiottet@webdna.us 2011)
  7. Re: [WebDNA] Triggers.db wiped completely blank (Govinda 2011)
  8. Re: [WebDNA] Triggers.db wiped completely blank (Daniel Meola 2011)
  9. Re: [WebDNA] Triggers.db wiped completely blank (chris@usinter.net 2011)
  10. Re: [WebDNA] Triggers.db wiped completely blank (Govinda 2011)
  11. Re: [WebDNA] Triggers.db wiped completely blank (Kenneth Grome 2011)
  12. Re: [WebDNA] Triggers.db wiped completely blank (Kenneth Grome 2011)
  13. Re: [WebDNA] Triggers.db wiped completely blank (christophe.billiottet@webdna.us 2011)
  14. Re: [WebDNA] Triggers.db wiped completely blank (Kenneth Grome 2011)
  15. Re: [WebDNA] Triggers.db wiped completely blank (Donovan Brooke 2011)
  16. Re: [WebDNA] Triggers.db wiped completely blank (christophe.billiottet@webdna.us 2011)
  17. Re: [WebDNA] Triggers.db wiped completely blank (Kenneth Grome 2011)
  18. Re: [WebDNA] Triggers.db wiped completely blank (Govinda 2011)
  19. [WebDNA] Triggers.db wiped completely blank (Kenneth Grome 2011)
Hi Ken! just tested the worst possible situation with the triggers: - WebDNA commits databases to disk only when instructed - added two triggers - kill -9 webdna.fcgi - new call to webdna (to wake it up again) - check that the PID is a new one (confirm that WebDNA has been closed = and restarted) - check the triggers: they are still there - chris On Dec 30, 2011, at 12:07, Kenneth Grome wrote: > I just learned that something completely wiped out my=20 > triggers.db 7 days ago -- it is completely blank -- and I=20 > have no idea what might have caused this. =20 >=20 > Does anyone else have a clue why this might happen? >=20 > Along with other things I was using it to bill clients=20 > automatically. But the bills never went out last week,=20 > which explains why I never got paid this week. =20 >=20 > I'm going to recreate my triggers, and I'm adding a new=20 > trigger -- one that will send me an email every day to=20 > confirm that triggers are still working. Then I will know=20 > when this happens again from the lack of a daily email,=20 > rather than learning about it a week later. But this does=20 > not make me feel any more confident about trusting triggers,=20 > and that's why I am hoping for an explanation of how this=20 > could have happened in the first place. >=20 > I have not made any config changes on the server in months,=20 > nor has anyone else -- except possibly the hosting company=20 > -- and I do not understand how the hosting company's=20 > potential changes might have wiped out my triggers.db while=20 > leaving all the other db's intact and functioning properly. >=20 > The only thing I can think of is that maybe the=20 > flushdatabases tag does NOT flush the triggers.db to disk, so=20 > the triggers.db always remains volatile in RAM ... and=20 > therefore it is subject to being wiped out when the server=20 > crashes or the VPS is moved to a different computer. >=20 > ??? >=20 > Sincerely, > Kenneth Grome > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us christophe.billiottet@webdna.us

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:

absolute paths for databases? (1997) Re:Searching for ALL / empty form field (1997) [applescript] support in 4.5 for OS X -- really? (2002) WebCommerce: Folder organization ? (1997) WebCat2 - [format thousands] (1997) Replacing entry (1998) 2.0 Info (1997) Stock Quotes (2000) Stop the madness. (1997) First n words (2000) Emailer (1999) Help! WebCat2 bug (1997) Wanted: Broader string manipulation functions (1997) searching with groups (1997) 4.5's frequency of math problem running as demo? (2002) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) More on the email templates (1997) Single Link browsing (1997) Problems searching from a FORM (1997) best way to get 2 unique strings on the same page load? (2000)