Postgres Pro
Downloads
Home   >   mailing lists

Re: Add an option to skip loading missing publication to avoid logical replication failure - Mailing list pgsql-hackers

From Xuneng Zhou
Subject Re: Add an option to skip loading missing publication to avoid logical replication failure
Date
Msg-id CABPTF7Xk7nKVepc9J9QEf4hzAo-AosJw7Pd2RKYn+dbnO6j7hQ@mail.gmail.com
Whole thread Raw
In response to Re: Add an option to skip loading missing publication to avoid logical replication failure  (vignesh C <vignesh21@gmail.com>)
Responses Re: Add an option to skip loading missing publication to avoid logical replication failure
List pgsql-hackers
Tree view

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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Valgrind - showing memory leaks
Next
From: Tomas Vondra
Date:
Subject: Re: Adding skip scan (including MDAM style range skip scan) to nbtree