Re: 2-phase commit - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: 2-phase commit
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4962023@m0114.s-mxs.net
Whole thread Raw
In response to 2-phase commit  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-hackers
> I don't think there is any way to handle cases where the master or slave
> just disappears.  The other machine isn't under the server's control, so
> it has no way of it knowing. I think we have to allow the administrator
> to set a timeout, or ask to wait indefinately, and allow them to call an
> external program to record the event or notify administrators.
> Multi-master replication has the same issues.

Needs to wait indefinitely, a timeout is not acceptable since it leads to
inconsistent data. Human (or monitoring software) intervention is needed
if they can't reach each other in a reasonable time.

I think this needs to be kept dumb. Different sorts of use cases will simply
need different answers to resolve in-doubt transactions. What is needed is an
interface that allows listing and commit/rollback of in-doubt transactions
(preferably from a newly started client, or a direct command for the postmaster).

Andreas


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Re: 2-phase commit
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: 2-phase commit