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
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
