Mmmmm, the biggest problem that I see in this discussion, is why would
anyone run a production server without a UPS ??
That's just begging for trouble.
They're inexpensive and work great.

Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>




-----Original Message-----
From: spif1973 [mailto:MBU@...]
Sent: Friday, November 07, 2003 1:21 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: What happens if the power fails


--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > 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

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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=258297.4155332.5363524.4049140/D=egroupweb/S=17051153
86:HM/A=1683962/R=0/SIG=11j2ftep6/*http://www.techsmith.com/rdr/ban/syah/def
ault.asp> click here

<http://us.adserver.yahoo.com/l?M=258297.4155332.5363524.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=291514001>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]