Re: long-standing data loss bug in initial sync of logical replication - Mailing list pgsql-hackers

From Vadim Lakt
Subject Re: long-standing data loss bug in initial sync of logical replication
Date
Msg-id de81e05f-17a5-478e-bd7b-dcd4e28c3dff@gmail.com
Whole thread Raw
In response to Re: long-standing data loss bug in initial sync of logical replication  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Hi,

On 19.11.2023 09:18, Andres Freund wrote:
> Yea, the situation is much simpler during logical decoding than "originally" -
> there's no concurrency.
>
> Greetings,
>
> Andres Freund
>
We've encountered a similar error on our industrial server.

The case: After adding a table to logical replication, table 
initialization proceeds normally, but new data from the publisher's 
table does not appear on the subscriber server. After we added the 
table, we checked and saw that the data was present on the subscriber 
and everything was normal, we discovered the error after some time. I 
have attached scripts to the email.

The patch from the first message also solves this problem.

-- 
Best regards,
Vadim Lakt

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: remaining sql/json patches
Next
From: jian he
Date:
Subject: sql-merge.html Compatibility section, typo.