public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Durgamahesh Manne <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Records count mismatch with logical replication
Date: Thu, 23 Jan 2025 10:38:31 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAJCZkoJrrezxCHxh0tmy-LQ+6CeizkDt88kM_yTDzVADhLdsJQ@mail.gmail.com>
References: <CAJCZko+gYNGiixGcqKAhjhLhUZ3QQg2rGs6nH7ZUNwTtjYLfGw@mail.gmail.com>
<[email protected]>
<CAJCZko+HhLFkiDLDPg3fscUEO4uWyEFT4_e6GBMeywnnwRC-rg@mail.gmail.com>
<[email protected]>
<CAJCZkoLZb5ON_T-YecS3-1sQjiGUVLdgKjS93thQyzZKiaWuFQ@mail.gmail.com>
<[email protected]>
<CAJCZkoJgAh_T_NJU5Jn3mzJJQE4LE-tDEjEyP37gKNR1X0cDWQ@mail.gmail.com>
<[email protected]>
<CAJCZkoLatfwsQ-puesPfjrYtUmaAwokWQvqShoTGfJ56QzLfQw@mail.gmail.com>
<[email protected]>
<CAJCZkoKvzBxjAZxfOsUpEmwmrtV33ZZaHC-d-yvF6RPAxoATkQ@mail.gmail.com>
<CAJCZkoJrrezxCHxh0tmy-LQ+6CeizkDt88kM_yTDzVADhLdsJQ@mail.gmail.com>
On 1/23/25 10:21, Durgamahesh Manne wrote:
> At subscription side
> getting this error repeatedly So Do we have any solution without resync
> full data again from scratch
>
> * |2025-01-23 18:11:46 UTC::@:[507]:DEBUG: logical replication did not
> find row to be updated in replication target relation's partition
> "markets_archive_p20250118"|
That looks like a different issue.
On the subscriber side is someone/something changing the data?
Are there more log reports related to this at something above the DEBUG
level?
I'm thinking this is related to from here:
https://www.postgresql.org/docs/current/logical-replication-conflicts.html
"When replicating UPDATE or DELETE operations, missing data will not
produce a conflict and such operations will simply be skipped."
I don't have time at the moment to dig any further.
>
> Regards,
> Durga Mahesh
--
Adrian Klaver
[email protected]
view thread (13+ messages)
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: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Records count mismatch with logical replication
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox