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

help / color / mirror / Atom feed
From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
Date: Sun, 2 Sep 2018 23:28:34 -0700 (MST)
Message-ID: <1535956114648-0.post@n3.nabble.com> (raw)
In-Reply-To: <MA1PR0101MB1687B5878714AA511B9E3697E00C0@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM>
References: <1535792170623-0.post@n3.nabble.com>
	<1535952517864-0.post@n3.nabble.com>
	<MA1PR0101MB1687E0C4823BB4A9C430C7FCE00C0@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM>
	<1535954598462-0.post@n3.nabble.com>
	<MA1PR0101MB1687B5878714AA511B9E3697E00C0@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM>

Hi Soumitra,

Actually speaking there is no duplicacy of the records. This error is
occurring on the subscriber side of the logical replication.

And the data on publisher is same as the data in subscriber. So there is no
point of mismatch in data integrity. 

And I think this error is caused because logical replication worker is
trying the sync the already synced rows from publisher to subscriber. In a
day it is occurring approximately 5264718 times.

This is causing heavy logging at the subscriber. I think you got my problem.

Environment:

The environment is two ubuntu boxes configured with Logical Replication on
Postgres 10.4. And the error flooding is occurring on the subscriber side.
Thanks in Advance.

Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html




view thread (21+ messages)  latest in thread

Message-ID: <1535956114648-0.post@n3.nabble.com>
Permalink:  ../1535956114648-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1535956114648-0.post@n3.nabble.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-admin@postgresql.org
  Cc: pavan.postgresdba@gmail.com
  Subject: Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4
  In-Reply-To: <1535956114648-0.post@n3.nabble.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