logical replication seems broken - Mailing list pgsql-hackers

From Erik Rijkers
Subject logical replication seems broken
Date
Msg-id 1295168140.139428.1613133237154@webmailclassic.xs4all.nl
Whole thread Raw
Responses Re: logical replication seems broken
List 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
testprogram without failure; so I think the culprit might be somewhere in those changes.  Or (always possible) there
mightbe 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
oneof you see the light immediately...
 


Erik Rijkers

[1] https://www.postgresql.org/message-id/flat/3897361c7010c4ac03f358173adbcd60%40xs4all.nl



pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: Improvements and additions to COPY progress reporting
Next
From: Bharath Rupireddy
Date:
Subject: Re: Improvements and additions to COPY progress reporting