Re: 2-phase commit

Hiroshi Inoue <inoue@tpf.co.jp>

From: Hiroshi Inoue <Inoue@tpf.co.jp>
To: Tom Lane <tgl@sss.pgh.pa.us>, "'Bruce Momjian'" <pgman@candle.pha.pa.us>, "'Zeugswetter Andreas SB SD'" <ZeugswetterA@spardat.at>, "'Andrew Sullivan'" <andrew@libertyrms.info>, pgsql-hackers@postgresql.org
Date: 2003-09-29T05:05:03Z
Lists: pgsql-hackers

Hiroshi Inoue wrote:
> 
> Tom Lane wrote:
> >
> > Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > > The simplest senario(though there could be varations) is
> >
> > > [At participant(master)'s side]
> > >   Because the commit operations is done, does nothing.
> >
> > > [At coordinator(slave)' side]
> > >    1) After a while
> > >    2) re-establish the communication path between the
> > >       partcipant(master)'s TM.
> > >    3) resend the "commit requeset" to the participant's TM.
> > >   1)2)3) would be repeated until the coordinator receives
> > >   the "commit ok" message from the partcipant.
> >
> > [ scratches head ] I think you are using the terms "master" and "slave"
> > oppositely than I would.
> 
> Oops my mistake, sorry.
> But is it 2-phase commit protocol in the first place ?

That is, in your exmaple below

 Example:

        Master          Slave
        ------          -----
        commit ready-->
                        <--OK
        commit done->XX

is the "commit done" message needed ?

regards,
Hiroshi Inoue
	http://www.geocities.jp/inocchichichi/psqlodbc/