Subject | Re: What happens if the power fails |
---|---|
Author | spif1973 |
Post date | 2003-11-07T10:04:14Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
they work :).
Martin
wrote:
> At 08:45 AM 7/11/2003 +0000, you wrote:everything
>
> >Yes, but the 5 tuples are all updated in the same commit statement,
> >hence the commit canĀ“t be trusted anymore.
>
> Wrong. A transaction is atomic: either everything commits or
> fails. So if the power goes out before the entire transaction iswill need
> committed, then the entire work of the transaction will be "in
> limbo". Yes, the recversions will need to be become garbage and
> to be cleaned out with gfix at some point. None of that work willeven be
> committed - no updates, no triggers, nothing.. When the powercomes back
> you can safely re-run the transaction.Thanks a lot for the replys - I guess I should trust my commits to do
>
> heLen
they work :).
Martin