Re: 2 phase commit with FDW

On 2/17/22 13:10, Mladen Gogala wrote:
>
> Hi!
>
> I am getting the following error when trying to PREPARE transaction
> which updates both local and foreign table:
>
> 2/17/22 12:48:00:657 EST] 00000128 RegisteredRes E   WTRN0046E: An
> attempt by the transaction manager to call prepare on a transactional
> resource has resulted in an error. The error code was XAER_RMFAIL. The
> exception stack trace follows: org.postgresql.xa.PGXAException: Error
> preparing transaction. prepare xid={XidImpl: formatId(57415344),
> gtrid_length(36), bqual_length(54),
> data(0000017f08cc3aea00000001232c3afce8abf609478378ca6ac9d4bddbfea3e4efa55cf30000017f08cc3aea00000001232c3afce8abf609478378ca6ac9d4bddbfea3e4efa55cf3000000010000000000000000000000000002)}
>         at
> org.postgresql.xa.PGXAConnection.prepare(PGXAConnection.java:365)
>
> There are no errors is all the tables are local. It seems that
> postgres_fdw is incompatible with the XA protocol. Is there a way
> around it? If not, we will need yet another code change and another
> data source.
>
> Regards
>
Is there anybody on this list who can tell me whether foreign tables can
participate in 2-phase commit or not? My version is 14.2 on Oracle Linux
8.5.

Regards

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com