| Subject | Re: [firebird-support] Re: What happens if the power fails |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-11-07T09:11:36Z |
At 08:45 AM 7/11/2003 +0000, you wrote:
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
>Yes, but the 5 tuples are all updated in the same commit statement,Wrong. A transaction is atomic: either everything commits or everything
>hence the commit can´t be trusted anymore.
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