| From: | Peter Smith <smithpb2250(at)gmail(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Cc: | Ajin Cherian <itsajin(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] logical decoding of two-phase transactions |
| Date: | 2020-11-25 07:24:06 |
| Message-ID: | CAHut+Ptm7E5Jj92tJWPtnnjbNjJN60_=aGGKYW3h23b7J=qeDg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Amit.
IIUC the tablesync worker runs in a single transaction.
Last week I discovered and described [1] a problem where/if (by
unlucky timing) the tablesync worker gets to handle the 2PC PREPARE
TRANSACTION then that whole single tx is getting committed, regardless
that a COMMIT PREPARED was not even been executed yet. i.e. It means
if the publisher subsequently does a ROLLBACK PREPARED then the table
records on Pub/Sub nodes will no longer be matching.
AFAIK this is a new problem for the current WIP patch because prior to
this the PREPARE had no decoding.
Please let me know if this issue description is still not clear.
Did you have any thoughts how we might address this issue?
---
Kind Regards,
Peter Smith.
Fujitsu Australia
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2020-11-25 07:32:12 | Re: walsender bug: stuck during shutdown |
| Previous Message | Kasahara Tatsuhito | 2020-11-25 07:18:19 | Re: autovac issue with large number of tables |