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/