Horton

Re: Add an option to skip loading missing publication to avoid logical replication failure

Amit Kapila <amit.kapila16@gmail.com>

View thread View on postgr.es
From: Amit Kapila <amit.kapila16@gmail.com>
To: Xuneng Zhou <xunengzhou@gmail.com>
Cc: vignesh C <vignesh21@gmail.com>, tgl@sss.pgh.pa.us, Dilip Kumar <dilipbalaut@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-05-12T05:41:28Z
Lists: pgsql-hackers 
On Sun, May 11, 2025 at 8:49 PM Xuneng Zhou <xunengzhou@gmail.com> wrote:
>
> Hi, I was able to reproduce the failure by adding a 1-second sleep in the LogicalRepApplyLoop function
> However, I noticed that the tests under src/test/subscription run significantly slower— is this normal?
>

Yes, because you made apply slower by adding a sleep.

> Also, it looks like the patch mentioned in this thread addresses the issue:
> https://www.postgresql.org/message-id/CALDaNm2Q_pfwiCkaV920iXEbh4D%3D5MmD_tNQm_GRGX6-MsLxoQ%40mail.gmail.com
>>

So you are okay with a test-only fix?

With Regards,
Amit Kapila.

Commits

  1. Fix the race condition in the test added by 7c99dc587.