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: pgsql-bugs mailing list <pgsql-bugs@postgresql.org>
Subject: Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
Date: Mon, 14 Nov 2022 14:33:28 +0100
Message-ID: <Y3JDqOe8w8LBF9HO@depesz.com> (raw)
In-Reply-To: <CAA4eK1+h8KAGW1bvo3vECWR9-ZExp1EptOBvqWP8V-aDyvaORg@mail.gmail.com>
References: <Yz2hivgyjS1RfMKs@depesz.com>
	<CAA4eK1JTE0tLgR5qzVECrKJV5VVTnDa0k5LQ4TOkBAA=MySj3g@mail.gmail.com>
	<Y00cp4sNQtFNoo25@depesz.com>
	<CAA4eK1KUMFfVrOpP7VgAPUN7rabvfr5GhcQh++T8BX-t7=e5YA@mail.gmail.com>
	<Y0/bSiDkYlhiSmOW@depesz.com>
	<Y1E3JIFqb0mFBZNR@depesz.com>
	<Y25hQCKLnolQaFN9@depesz.com>
	<CAA4eK1JSTC9uJ_CTTFxMZV6wSr2hkCX4bwtruUp9wX_K8JLo1Q@mail.gmail.com>
	<Y3Ixv1QYMxnhruNN@depesz.com>
	<CAA4eK1+h8KAGW1bvo3vECWR9-ZExp1EptOBvqWP8V-aDyvaORg@mail.gmail.com>

On Mon, Nov 14, 2022 at 06:30:57PM +0530, Amit Kapila wrote:
> > There is something weird happening:
> What exactly weird you are seeing in this? To me, it appears as if the
> system due to some reason ignores an existing slot that has
> restart_lsn as 1039D/83825958.

The weird part for me is that it is trying to remove wal files older
than the same "x" many times.
But perhaps it just means that the code that does it doesn't check if it
did the same previously.

Best regards,

depesz






view thread (57+ messages)  latest in thread

Message-ID: <Y3JDqOe8w8LBF9HO@depesz.com>
Permalink:  ../Y3JDqOe8w8LBF9HO@depesz.com/
Also on:    postgresql.org/message-id/Y3JDqOe8w8LBF9HO@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
  Subject: Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
  In-Reply-To: <Y3JDqOe8w8LBF9HO@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