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

From: Xuneng Zhou <xunengzhou(at)gmail(dot)com>
To: vignesh C <vignesh21(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, tgl(at)sss(dot)pgh(dot)pa(dot)us, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add an option to skip loading missing publication to avoid logical replication failure
Date: 2025-05-11 15:19:22
Message-ID: CABPTF7Xk7nKVepc9J9QEf4hzAo-AosJw7Pd2RKYn+dbnO6j7hQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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://stream.boxwatch.ru/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://stream.boxwatch.ru/message-id/CALDaNm2Q_pfwiCkaV920iXEbh4D%3D5MmD_tNQm_GRGX6-MsLxoQ%40mail.gmail.com
>
> Regards,
> Vignesh
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2025-05-11 16:07:56 Re: Adding skip scan (including MDAM style range skip scan) to nbtree
Previous Message Tom Lane 2025-05-11 15:13:18 Re: Valgrind - showing memory leaks