Re: Add an option to skip loading missing publication to avoid logical replication failure
Xuneng Zhou <xunengzhou@gmail.com>
From: Xuneng Zhou <xunengzhou@gmail.com>
To: vignesh C <vignesh21@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>, tgl@sss.pgh.pa.us, Dilip Kumar <dilipbalaut@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-05-11T15:19:22Z
Lists: pgsql-hackers
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? 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 > > A simpler way to consistently reproduce the issue is to add a 1-second > sleep in the LogicalRepApplyLoop function, just before the call to > WaitLatchOrSocket. This reproduces the test failure consistently for > me. The failure reason is the same as in [1]. > > [1] - > https://www.postgresql.org/message-id/CALDaNm2Q_pfwiCkaV920iXEbh4D%3D5MmD_tNQm_GRGX6-MsLxoQ%40mail.gmail.com > > Regards, > Vignesh >
Commits
-
Fix the race condition in the test added by 7c99dc587.
- 8ede692de512 18.0 landed