From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
Cc: | pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: 2 phase commit with FDW |
Date: | 2022-02-18 15:40:07 |
Message-ID: | CAFj8pRCDi2nWhOgYXxS8OCxkJ2pe0CdcgR-gAgdf50bD8Ad0ug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
pá 18. 2. 2022 v 14:24 odesílatel Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
napsal:
> 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.
>
I don't watch this topic, but it looks so FDW doesn't support 2PC yet
https://www.postgresql.fastware.com/blog/postgresql-14-and-beyond
Regards
Pavel
Regards
>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2022-02-18 16:07:18 | Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*" |
Previous Message | Tom Lane | 2022-02-18 15:32:27 | Re: Strange results when casting string to double |