Horton

Re: 024_add_drop_pub.pl might fail due to deadlock

Ajin Cherian <itsajin@gmail.com>

View thread View on postgr.es
From: Ajin Cherian <itsajin@gmail.com>
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: vignesh C <vignesh21@gmail.com>, Alexander Lakhin <exclusion@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Amit Kapila <amit.kapila16@gmail.com>
Date: 2025-07-24T12:15:12Z
Lists: pgsql-hackers

Attachments

On Wed, Jul 23, 2025 at 8:01 PM Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:
>
> > Dear Ajin,
> >
> > Thanks for the patch. Firstly let me confirm my understanding. While altering the
> > subscription, locks are acquired with below ordering:
> >
>
> I forgot to confirm one point. For which branch should be backpatch? Initially
> it was reported only on PG15 [1], but I found 021_alter_sub_pub could fail on PG14.

Yes, here's a patch for PG14 as well, based on REL_14_STABLE.

regards,
Ajin Cherian
Fujitsu Australia

Commits

  1. Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION.