Re: Crashes on a partition whose concurrent detach never finished

From: Zhijie Hou <houzhijie22(at)gmail(dot)com>
To: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
Cc: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(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 <shveta(dot)malik(at)gmail(dot)com>
Subject: Re: Crashes on a partition whose concurrent detach never finished
Date: 2026-11-11 07:35:22
Message-ID: 68d8151c-6bfc-4630-8ce3-88673cc47fd7@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Sun, Sep27, 2026 at 10:26 PM Mihail Nikalayeu wrote:
> Attached is v2 of the remaining fixes, rebased on master and
> registered in the commitfest as [3] for tracking purposes.
>
> I tried to combine everything into the series. It is mostly
> AI-generated, but I still think structuring everything is helpful
> anyway.
>
> The rule throughout is that a partition pending detach is published as
> a standalone table, as it will be after FINALIZE; publishing it via
> the former root would cause the divergence Nisha described in [1].
>
> 0001 (pgoutput crash): The test comment Shveta asked about was
> misleading; it's fixed. pgindent-clean applied.

Since we are considering whether to push 0001 first, I reviewed it and
have few suggestions:

1. We can remove the am_partition variable completely and simply check
"ancestors" in the subsequent code, to be consistent with
RelationBuildPublicationDesc.

2. The test can be simplified to cover only the decoding crash (since
the subscriber side is not touched by this patch), which saves buildfarm
test time. In addition, we can move the test into the existing isolation
test to speed it up further.

I have attached a top-up patch for 0001 with these changes. Feel free to
merge it if it looks good.

--
Best Regards,
Zhijie Hou

Attachment Content-Type Size
nocfbot-0001-Top-up-for-v2-0001-Use-isolation-test-for-pgoutput-d.patch text/plain 11.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2026-11-11 07:48:31 Re: Bug report and fix for: COMMIT/ROLLBACK AND CHAIN after an error drops the isolation level
Previous Message Amit Kapila 2026-11-11 07:19:20 Re: Crashes on a partition whose concurrent detach never finished