pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Vadim Lakt <vadim.lakt@gmail.com>
To: Andres Freund <andres@anarazel.de>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: long-standing data loss bug in initial sync of logical replication
Date: Tue, 16 Jan 2024 17:24:02 +0700
Message-ID: <de81e05f-17a5-478e-bd7b-dcd4e28c3dff@gmail.com> (raw)
In-Reply-To: <20231119021830.d6t6aaxtrkpn743y@awork3.anarazel.de>
References: <de52b282-1166-1180-45a2-8d8917ca74c6@enterprisedb.com>
	<20231118015443.sfxfbr4eqolxbmjc@awork3.anarazel.de>
	<20231118025445.crhaeeuvoe2g5dv6@awork3.anarazel.de>
	<49958b83-009a-9360-2969-ea42cd15fff7@enterprisedb.com>
	<20231118181257.qtebsnkrzj3icg36@awork3.anarazel.de>
	<3c5ad91c-330a-0c5a-974a-da3801ffc18b@enterprisedb.com>
	<20231118210519.yborkczu2aln6zdd@awork3.anarazel.de>
	<5cc4bbc8-b2ad-3e6e-9878-cef8ddde8ffe@enterprisedb.com>
	<20231119021830.d6t6aaxtrkpn743y@awork3.anarazel.de>

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

Attachments:

  [application/zip] err_logical_replication.zip (2.0K, ../de81e05f-17a5-478e-bd7b-dcd4e28c3dff@gmail.com/2-err_logical_replication.zip)
  download

view thread (105+ messages)  latest in thread

Message-ID: <de81e05f-17a5-478e-bd7b-dcd4e28c3dff@gmail.com>
Permalink:  ../de81e05f-17a5-478e-bd7b-dcd4e28c3dff@gmail.com/
Also on:    postgresql.org/message-id/de81e05f-17a5-478e-bd7b-dcd4e28c3dff@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: vadim.lakt@gmail.com, andres@anarazel.de, tomas.vondra@enterprisedb.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: long-standing data loss bug in initial sync of logical replication
  In-Reply-To: <de81e05f-17a5-478e-bd7b-dcd4e28c3dff@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox