diff options
| author | Amit Kapila <akapila@postgresql.org> | 2024-07-12 09:35:46 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2024-07-12 09:35:46 +0530 |
| commit | ae4e072bad5ff254a4fcfe876aae849acdaf8c3d (patch) | |
| tree | 7fd62fd851f8ed0d673104623dd0e1201e1eb926 /src/backend/executor/nodeModifyTable.c | |
| parent | 068674f4ab44f2c891b6841432687958e8e9c9a6 (diff) | |
| download | postgresql-ae4e072bad5ff254a4fcfe876aae849acdaf8c3d.tar.gz postgresql-ae4e072bad5ff254a4fcfe876aae849acdaf8c3d.zip | |
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
Diffstat (limited to 'src/backend/executor/nodeModifyTable.c')
0 files changed, 0 insertions, 0 deletions