[backport-1.4]: Find the root cause behind the CNPG replication sync issue

Issue #2648 (closed) needs to be backported to 1.4.x