Re: [Postgres-xc-developers] Patch correcting implicit 2-phase commit

[Michael P. <mic...@gm...>]

Hi all,

Here is the fix I propose based on the idea I proposed in a previous mail.
If a prepared transaction, partially committed, is aborted, this patch
gathers the handles to nodes where an error occurred and saves them on GTM.

The prepared transaction partially committed is kept alive on GTM, so other
transactions cannot see the partially committed results.
To complete the commit of the prepared transaction partially committed, it
is necessary to issue a COMMIT PREPARED 'gid'.
Once this command is issued, transaction will finish its commit properly.

Mason, this solves the problem you saw when you made your tests.
It also respects the rule that a 2PC transaction partially committed has to
be committed.

Thanks,

-- 
Michael Paquier
http://michaelpq.users.sourceforge.net