RE: 024_add_drop_pub.pl might fail due to deadlock - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: 024_add_drop_pub.pl might fail due to deadlock
Date
Msg-id OSCPR01MB14966E18F67B192E048F8AEFDF55FA@OSCPR01MB14966.jpnprd01.prod.outlook.com
Whole thread Raw
In response to RE: 024_add_drop_pub.pl might fail due to deadlock  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
Responses Re: 024_add_drop_pub.pl might fail due to deadlock
List pgsql-hackers
> 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.
Regarding the PG13, it may not be affected because the replication origin seemed
not to be used for the table sync. It was introduced for ce0fdbfe97.

[1]: https://www.postgresql.org/message-id/bab95e12-6cc5-4ebb-80a8-3e41956aa297%40gmail.com

Best regards,
Hayato Kuroda
FUJITSU LIMITED


pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: 024_add_drop_pub.pl might fail due to deadlock
Next
From: Tomas Vondra
Date:
Subject: Re: index prefetching