logical replication seems broken
Erik Rijkers <er@xs4all.nl>
From: Erik Rijkers <er@xs4all.nl>
To: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2021-02-12T12:33:57Z
Lists: pgsql-hackers
Hello, I am seeing errors in replication in a test program that I've been running for years with very little change (since 2017, really [1]). The symptom: HEAD-replication fails (most of the time) when cascading 3 instances (master+2 replicas). HEAD-replication works with 2 instances (master+replica). I have also compiled a server on top of 4ad31bb2ef25 (avoiding some recent changes) - and this server runs the same test program without failure; so I think the culprit might be somewhere in those changes. Or (always possible) there might be something my testing does wrong - but then again, I do this test a few times every week, and it never fails. This weekend I can dig into it some more (make a self-sufficient example) but I thought I'd mention it already. perhaps one of you see the light immediately... Erik Rijkers [1] https://www.postgresql.org/message-id/flat/3897361c7010c4ac03f358173adbcd60%40xs4all.nl
Commits
-
Remove the unnecessary PrepareWrite in pgoutput.
- f672df5fdd22 14.0 landed
-
Allow multiple xacts during table sync in logical replication.
- ce0fdbfe9722 14.0 cited
-
Stop demanding that top xact must be seen before subxact in decoding.
- bff456d7a0b3 11.8 cited