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

help / color / mirror / Atom feed
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: vignesh C <vignesh21@gmail.com>
Cc: pgsql-bugs mailing list <pgsql-bugs@postgresql.org>
Subject: Re: Logical replication stops dropping used initial-sync replication slots
Date: Tue, 29 Mar 2022 14:01:41 +0200
Message-ID: <20220329120140.GA29363@depesz.com> (raw)
In-Reply-To: <CAA4eK1KbBAPfLL86x0nTz8f3dKKgETv9Udx3Ex8yKBArx+u1FA@mail.gmail.com>
References: <20220317142426.GA727@depesz.com>
	<20220318122758.GA25022@depesz.com>
	<CALDaNm0+k0M6SDSVEsRWoS8VkwYtTz3WAQcjPWRheKu2-ym-pQ@mail.gmail.com>
	<20220321144341.GA27089@depesz.com>
	<CALDaNm1S-DtphU51d3orNknjyNQEjAOL90jXAxkis_n4rtS=eA@mail.gmail.com>
	<20220322034847.GA15952@depesz.com>
	<CALDaNm2Za2KU-R07dXKGYjM1UF1SZtbBR1BycxHC-dzjc0OSnA@mail.gmail.com>
	<20220322112646.GA14817@depesz.com>
	<20220325083856.GA26455@depesz.com>
	<CAA4eK1KbBAPfLL86x0nTz8f3dKKgETv9Udx3Ex8yKBArx+u1FA@mail.gmail.com>

On Tue, Mar 29, 2022 at 04:57:42PM +0530, Amit Kapila wrote:
> What was your setting for max_logical_replication_workers? It should

4 on source, and 50 on replica. That could be related. Should I increase this on source?

> be more than max_sync_workers_per_subscription as that is taken from
> the pool of max_logical_replication_workers. One possible reason for

The thing is that, in next tests, it seemed to *usually* work. And break
just sometimes.

> It is good if you are able to proceed but we might get some clue about
> the problem you are seeing if you can show subscriber-side logs.

Will keep that in mind. The boxes I was testing it are gone, but if the
problem will resurface, I'll make the logs available.

Best regards,

depesz






view thread (12+ messages)  latest in thread

Message-ID: <20220329120140.GA29363@depesz.com>
Permalink:  ../20220329120140.GA29363@depesz.com/
Also on:    postgresql.org/message-id/20220329120140.GA29363@depesz.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-bugs@postgresql.org
  Cc: depesz@depesz.com, amit.kapila16@gmail.com, vignesh21@gmail.com
  Subject: Re: Logical replication stops dropping used initial-sync replication slots
  In-Reply-To: <20220329120140.GA29363@depesz.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