Re: BUG #18988: DROP SUBSCRIPTION locks not-yet-accessed database

From: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
To: vignesh C <vignesh21(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, "exclusion(at)gmail(dot)com" <exclusion(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18988: DROP SUBSCRIPTION locks not-yet-accessed database
Date: 2025-08-13 09:30:34
Message-ID: CAFiTN-sDQHoc5Yx=+mqupzwWJZ5=3eAFmzfWbGz7uxn424jajQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Aug 13, 2025 at 11:20 AM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
>
> On Wed, Aug 13, 2025 at 11:16 AM vignesh C <vignesh21(at)gmail(dot)com> wrote:
> >
> > Thanks for the updated patch. This change is required for the back
> > branches too. Currently it is not applying for PG16 and below
> > branches.
> > git am v3-0001-Fix-DROP-SUBSCRIPTION-deadlock-with-new-database-.patch
> > Applying: Fix DROP SUBSCRIPTION deadlock with new database creation
> > error: patch failed: src/backend/commands/subscriptioncmds.c:1571
> > error: src/backend/commands/subscriptioncmds.c: patch does not apply
> > error: patch failed: src/backend/replication/logical/worker.c:4624
> > error: src/backend/replication/logical/worker.c: patch does not apply
> > Patch failed at 0001 Fix DROP SUBSCRIPTION deadlock with new database creation
>
> Right, I was waiting for consensus for the fix, but anyway I will send
> the patches for back branches, thanks.

I have prepared back branch patches.

--
Regards,
Dilip Kumar
Google

Attachment Content-Type Size
v3-0001-Fix-DROP-SUBSCRIPTION-deadlock-with-new-database-V15.patch application/octet-stream 3.3 KB
v3-0001-Fix-DROP-SUBSCRIPTION-deadlock-with-new-database-v14.patch application/octet-stream 3.3 KB
v3-0001-Fix-DROP-SUBSCRIPTION-deadlock-with-new-database-Master.patch application/octet-stream 3.3 KB
v3-0001-Fix-DROP-SUBSCRIPTION-deadlock-with-new-database-V13.patch application/octet-stream 3.3 KB
v3-0001-Fix-DROP-SUBSCRIPTION-deadlock-with-new-database-V16.patch application/octet-stream 3.4 KB
v3-0001-Fix-DROP-SUBSCRIPTION-deadlock-with-new-database-V17-18.patch application/octet-stream 3.3 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ashutosh Bapat 2025-08-13 09:48:31 Re: "unexpected duplicate for tablespace" problem in logical replication
Previous Message Thomas Munro 2025-08-13 06:01:54 Re: BUG #19006: Assert(BufferIsPinned) in BufferGetBlockNumber() is triggered for forwarded buffer