Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux