pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rahul <rahul@rhyadav.dev>
To: shihao zhong <zhong950419@gmail.com>
Cc: Kirill Reshke <reshkekirill@gmail.com>
Cc: Nktpro <nktpro@gmail.com>
Cc: Pgsql Bugs <pgsql-bugs@lists.postgresql.org>
Cc: Melanie Plageman <melanieplageman@gmail.com>
Subject: Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation
Date: Thu, 8 Oct 2026 17:02:26 +0200 (CEST)
Message-ID: <P3R1J53--F-9@rhyadav.dev> (raw)
In-Reply-To: <CAGRkXqSC1E-Go=HgnUAwGPovGuQuMEiWXg+reE9QNgEuCvaD6g@mail.gmail.com-P2zxqm1----9>
References: <CAL4mQLAp562c1rCgg2Dqx6TBSdOk6vOvaLFjwFG9E6k4uwvJJw@mail.gmail.com>
	<CALdSSPjEM90Y_6RQGox7OFJC+oAurWy5YSuXaH8Mr7m-TMOyWA@mail.gmail.com>
	<CAGRkXqRZva+Wiw6jb9-owhLjGOtoDn-btoFjJmejmJYOMSEbzg@mail.gmail.com>
	<P2s-NV0--F-9@rhyadav.dev>
	<CAGRkXqSZXoazu1x48pz2SuW_xHYQDdRcbp2HNCfRNm_WLF8aYA@mail.gmail.com-P2v1i8Y----9>
	<P2v9EE4--F-9@rhyadav.dev>
	<CAGRkXqSC1E-Go=HgnUAwGPovGuQuMEiWXg+reE9QNgEuCvaD6g@mail.gmail.com-P2zxqm1----9>

Hi Shihao,

cfbot says v3 needs a rebase.  0001 and 0002 still apply to master,
but the test's number is now taken: 12f866cd5f and cc33773482 added
058_shutdown_crash_restart.pl and 059_remote_apply_status_interval.pl
to src/test/recovery.  With the test renamed to
060_vm_clear_truncate.pl, the series applies to master (16b94c4012)
and the test passes.

As you were going to fold the heap_xlog_visible() wording for 17 and
18 into the next version, this may be a good time for v4.

Regards,
Rahul Yadav


Oct 3, 2026, 05:13 by zhong950419@gmail.com:

> Hi Rahul,
>
> Thanks for testing v3 on all four branches.
>
> You are right about 17 and 18. I will change that sentence to
> heap_xlog_visible() in those two versions, and add
> "Backpatch-through: 17" to 0002. Both are commit message changes
> only, so I will fold them into the next version and not post a v4
> just for that.
>
> I added a CommitFest entry so this is tracked for the November
> releases.
>
> https://commitfest.postgresql.org/patch/7386/
>
> Thanks,
> Shihao
>







view thread (15+ messages)  latest in thread

Message-ID: <P3R1J53--F-9@rhyadav.dev>
Permalink:  ../P3R1J53--F-9@rhyadav.dev/
Also on:    postgresql.org/message-id/P3R1J53--F-9@rhyadav.dev

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: rahul@rhyadav.dev, zhong950419@gmail.com, reshkekirill@gmail.com, nktpro@gmail.com, melanieplageman@gmail.com
  Subject: Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation
  In-Reply-To: <P3R1J53--F-9@rhyadav.dev>
  References: <CAL4mQLAp562c1rCgg2Dqx6TBSdOk6vOvaLFjwFG9E6k4uwvJJw@mail.gmail.com> <CALdSSPjEM90Y_6RQGox7OFJC+oAurWy5YSuXaH8Mr7m-TMOyWA@mail.gmail.com> <CAGRkXqRZva+Wiw6jb9-owhLjGOtoDn-btoFjJmejmJYOMSEbzg@mail.gmail.com> <P2s-NV0--F-9@rhyadav.dev> <CAGRkXqSZXoazu1x48pz2SuW_xHYQDdRcbp2HNCfRNm_WLF8aYA@mail.gmail.com-P2v1i8Y----9> <P2v9EE4--F-9@rhyadav.dev> <CAGRkXqSC1E-Go=HgnUAwGPovGuQuMEiWXg+reE9QNgEuCvaD6g@mail.gmail.com-P2zxqm1----9> <P3R1J53--F-9@rhyadav.dev>

* 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