Re: Two-phase commit issues - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Two-phase commit issues
Date
Msg-id 200505201634.j4KGYre29742@candle.pha.pa.us
Whole thread Raw
In response to Re: Two-phase commit issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Two-phase commit issues
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I am a little confused by this.  How does two-phase commit add extra
> > requirements on crash recovery?
> 
> Uh, that's more or less the entire *POINT*.  Once an open transaction is
> prepared, it's supposed to survive a server crash.

Wow.  This is much more than I thought we were going to do.  I thought
if something failed after the prepare we were just going to inform the
administrator and give up.  Becuase you are writing status file to the
disk, it seems you are trying to recover from a crash and roll forward.

What cases would we actually fail to recover from a crash after a
PREPARE?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Image storage questions
Next
From: Tom Lane
Date:
Subject: Re: Two-phase commit issues