From: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
---|---|
To: | pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | 2 phase commit with FDW |
Date: | 2022-02-17 18:10:43 |
Message-ID: | b578cbbc-2999-7842-a88e-43aa4847b635@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-02-17 18:15:04 | Re: alter function/procedure depends on extension |
Previous Message | Alvaro Herrera | 2022-02-17 17:09:12 | Re: alter function/procedure depends on extension |