Fix unstable test in 040_pg_createsubscriber.
Amit Kapila <akapila@postgresql.org>
Fix unstable test in 040_pg_createsubscriber. The slot synchronization failed because the local slot's (created during slot synchronization) catalog_xmin on standby is ahead of remote slot. This happens because the INSERT before slot synchronization results in the generation of a new xid that could be replicated to the standby. Now before the xmin of the physical slot on the primary catches up via hot_standby_feedback, the test has created a logical slot that got some prior value of catalog_xmin. To fix this we could try to ensure that the physical slot's catalog_xmin is caught up to latest value before creating a logical slot but we took a simpler path to move the INSERT after synchronizing the logical slot. Reported-by: Alexander Lakhin as per buildfarm Diagnosed-by: Amit Kapila, Hou Zhijie, Alexander Lakhin Author: Hou Zhijie Backpatch-through: 17 Discussion: https://postgr.es/m/bde6ac67-69cc-c104-5ab6-dd4f5deadf24@gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/bin/pg_basebackup/t/040_pg_createsubscriber.pl | modified | +8 −4 |
Discussion
- speed up a logical replica setup 327 messages · 2022-02-21 → 2024-07-30