Subject Re: What happens if the power fails
Author spif1973
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
> > ok - but if it reaches the commit stage, and the unlikely scenario
> > happens, that the power fails during the commitments.
> > Ex. 5 tuples to be updated, the first 2 gets updated, then the
power
> > fails and the rest never gets updated.
> > Will the first 2 then be rolled-back on start-up, or will they
have
> > the updated data?
> >
> > Martin
> >
>
> I think that is what commit is all about. It needs to finish a
commit before
> it can commit.
>
> Alan

Yes, but the 5 tuples are all updated in the same commit statement,
hence the commit canĀ“t be trusted anymore.

Martin