Subject RE: [firebird-support] What happens if the power fails
Author Alan McDonald
> Hi - I´m new to Firebird and I was wondering what happens, if I am
> trying to update/add/delete multiple tuples in a single transaction,
> and the power fails during the process. Will it rollback when the
> power comes back on? Or will it leave the update/add/delete tuples in
> the database?
> Im hoping for a rollback :), since I otherwise will have to code my
> way out of the problem (i´m using .NET, C# and Firebird v.1.5.0.3744
> RC4).
>
>

If it never reaches the commit stage, then it will be left as a record
version which will be cleaned up next time you garbage collect or
backup/restore. It won't be rolled back just never committed and thrown
away. At least that's what I think. The changes you speak of are never seen
again.

Alan