Re: Crashes on a partition whose concurrent detach never finished

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: shveta malik <shveta(dot)malik(at)gmail(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, vignesh C <vignesh21(at)gmail(dot)com>, "ashutosh(dot)bapat(dot)oss(at)gmail(dot)com" <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, shveta malik <shvetamalik(at)gmail(dot)com>
Subject: Re: Crashes on a partition whose concurrent detach never finished
Date: 2026-11-11 09:17:52
Message-ID: CAA4eK1Khm7Mr1TiSrvVNsyW7i86kbyv3bV_fY2rUiNGd-VNATg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 11, 2026 at 2:21 PM shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
> On Wed, Nov 11, 2026 at 12:49 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
>
> > But the points
> > to consider are the fix is for both except and non-except cases, shall
> > we fix both if so, non-except should be ideally committed till PG-14.
> > Then the next question to consider is whether to fix the invalidation
> > problem you reported in [2]. Without the invalidation, the crash will
> > be fixed but probably the answer whether to replicate the partition
> > changes could be incorrect (this will be true for both EXCEPT and
> > non-EXCEPT cases).
> >
> > I feel in any case the invalidation problem is not related to PG-19
> > code change and requires more discussion. So, we should leave that and
> > discuss whether to fix both EXCEPT and non-EXCEPT cases?
>
> +1
>
> For non-EXCEPT, I also think that fix will be needed till PG15. Not
> sure about PG14, as it reaches end of life on 12 November 2026, which
> is tomorrow as per [1].
>

Right, we need the fix to be backpatched till PG15. Sawada-San, let us
know if you think differently about the above plan (both the scope of
fix and till which version it should be fixed) for pursuing the fix?

--
With Regards,
Amit Kapila.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert I Nilsson 2026-11-11 09:28:28 [PATCH] Fix SASLprep validation after NFKC normalization
Previous Message wenhui qiu 2026-11-11 09:17:32 Re: Wrong results from GROUP BY column removal