Subject Re: What happens if the power fails
Author spif1973
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 08:45 AM 7/11/2003 +0000, you wrote:
>
> >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
everything
> fails. So if the power goes out before the entire transaction is
> committed, then the entire work of the transaction will be "in
> limbo". Yes, the recversions will need to be become garbage and
will need
> to be cleaned out with gfix at some point. None of that work will
even be
> committed - no updates, no triggers, nothing.. When the power
comes back
> you can safely re-run the transaction.
>
> heLen

Thanks a lot for the replys - I guess I should trust my commits to do
they work :).

Martin