Introduce XID age based replication slot invalidation

5 patchsets tracked - current t52309_59

v59t52309_59posted Sep 23, 18:14successneeds rebaserecent 21dpg 20

base374522aa6 Sep 23, 13:18 on master

applyapplied Sep 23, 18:16

rebaselast tried about 20 hours ago on b84ad0cd9

Applying: Invalidate XID-aged replication slots.
Using index info to reconstruct a base tree...
M	doc/src/sgml/config.sgml
M	doc/src/sgml/maintenance.sgml
M	src/backend/access/transam/xlog.c
M	src/backend/replication/slot.c
M	src/backend/utils/misc/guc_parameters.dat
M	src/backend/utils/misc/postgresql.conf.sample
M	src/test/recovery/meson.build
Falling back to patching base and 3-way merge...
Auto-merging src/test/recovery/meson.build
CONFLICT (content): Merge conflict in src/test/recovery/meson.build
Auto-merging src/backend/utils/misc/postgresql.conf.sample
Auto-merging src/backend/utils/misc/guc_parameters.dat
Auto-merging src/backend/replication/slot.c
Auto-merging src/backend/access/transam/xlog.c
Auto-merging doc/src/sgml/maintenance.sgml
Auto-merging doc/src/sgml/config.sgml
Patch failed at 0001 Invalidate XID-aged replication slots.

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"

conflicts on master: src/test/recovery/meson.build

pushSep 23, 18:17 -> 9921fb212 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1037 / 1037	2m 51s / 5m 18s	`docker run ... :t52309`	Sep 23, 18:27
run 35901388681 executed 1037 - ccache 98 hit / 6524 miss - head 9921fb212 - digest sha256:15ac78803371c3... - run 35901388681

v46t52309_46posted Aug 21, 22:05successsupersededstale 31dpg 20

base0c5d62696 Sep 13, 12:06 on master

applyapplied Sep 13, 14:37

rebaselast tried Sep 22, 21:24 on 09a579aba

Applying: Invalidate XID-aged replication slots.
Using index info to reconstruct a base tree...
M	doc/src/sgml/config.sgml
M	doc/src/sgml/logical-replication.sgml
M	doc/src/sgml/maintenance.sgml
M	doc/src/sgml/system-views.sgml
M	src/backend/access/transam/xlog.c
M	src/backend/utils/misc/guc_parameters.dat
M	src/test/recovery/t/019_replslot_limit.pl
Falling back to patching base and 3-way merge...
Auto-merging src/test/recovery/t/019_replslot_limit.pl
Auto-merging src/backend/utils/misc/guc_parameters.dat
Auto-merging src/backend/access/transam/xlog.c
CONFLICT (content): Merge conflict in src/backend/access/transam/xlog.c
Auto-merging doc/src/sgml/system-views.sgml
Auto-merging doc/src/sgml/maintenance.sgml
Auto-merging doc/src/sgml/logical-replication.sgml
Auto-merging doc/src/sgml/config.sgml
Patch failed at 0001 Invalidate XID-aged replication slots.

error: Failed to merge in the changes.
hint: Use 'git am --show-current-patch=diff' to see the failed patch
hint: When you have resolved this problem, run "git am --continue".
hint: If you prefer to skip this patch, run "git am --skip" instead.
hint: To restore the original branch and stop patching, run "git am --abort".
hint: Disable this message with "git config advice.mergeConflict false"

conflicts on master: src/backend/access/transam/xlog.c

pushSep 13, 14:38 -> b959d3117 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1023 / 1023	2m 36s / 4m 58s	`docker run ... @sha256:47708b1...`	Sep 13, 14:48
run 34763227574 executed 1023 - ccache 98 hit / 6523 miss - head b959d3117 - digest sha256:47708b17040c2f... - run 34763227574
success	1	20	1023 / 1023	2m 59s / 5m 50s	`docker run ... @sha256:b72d40c...`	Sep 12, 14:29
run 34698893138 executed 1023 - ccache 98 hit / 6523 miss - head d9c9d8a52 - digest sha256:b72d40c983cc57... - run 34698893138
success	1	20	1022 / 1022	2m 47s / 5m 36s	`docker run ... @sha256:13928ae...`	Sep 11, 14:28
run 34609230371 executed 1022 - ccache 98 hit / 6523 miss - head f1772af58 - digest sha256:13928ae7df6b5c... - run 34609230371
success	1	20	1022 / 1022	2m 54s / 5m 01s	`docker run ... @sha256:3ce6bdb...`	Sep 10, 14:28
run 34487895023 executed 1022 - ccache 98 hit / 6523 miss - head e1b3d4aee - digest sha256:3ce6bdbef8c7dc... - run 34487895023
success	1	20	1020 / 1020	2m 56s / 5m 05s	`docker run ... @sha256:f8c269d...`	Sep 09, 14:26
run 34362274314 executed 1020 - ccache 98 hit / 6523 miss - head 4ec116c82 - digest sha256:f8c269de567b72... - run 34362274314
success	1	20	1020 / 1020	2m 45s / 5m 17s	`docker run ... @sha256:83bfdee...`	Sep 08, 14:25
run 34236883693 executed 1020 - ccache 98 hit / 6523 miss - head 14c862d17 - digest sha256:83bfdee2577fae... - run 34236883693
success	1	20	1024 / 1024	2m 48s / 4m 58s	`docker run ... @sha256:bf156be...`	Sep 07, 14:23
run 34131633948 executed 1024 - ccache 98 hit / 6527 miss - head 6aba0d1ce - digest sha256:bf156bee912987... - run 34131633948
success	1	20	1024 / 1024	2m 48s / 5m 12s	`docker run ... @sha256:92fdeea...`	Sep 05, 22:30
run 33995621219 executed 1024 - ccache 98 hit / 6527 miss - head 21ac21452 - digest sha256:92fdeeacc40f08... - run 33995621219
success	1	20	1024 / 1024	2m 48s / 4m 51s	`docker run ... @sha256:d53c5ae...`	Sep 04, 22:30
run 33925043499 executed 1024 - ccache 98 hit / 6527 miss - head 0c84482f9 - digest sha256:d53c5ae8487a75... - run 33925043499
success	1	20	1024 / 1024	2m 52s / 5m 40s	`docker run ... @sha256:af92a11...`	Sep 03, 22:30
run 33812511145 executed 1024 - ccache 98 hit / 6527 miss - head 19c7eb8f2 - digest sha256:af92a11ff70323... - run 33812511145
success	1	20	1022 / 1022	2m 49s / 5m 14s	`docker run ... @sha256:9d739c4...`	Sep 02, 22:29
run 33689729287 executed 1022 - ccache 98 hit / 6526 miss - head e27079af0 - digest sha256:9d739c4db254ae... - run 33689729287
success	1	20	1022 / 1022	1m 59s / 4m 34s	`docker run ... @sha256:cf8e231...`	Sep 01, 22:28
run 33565534222 executed 1022 - ccache 98 hit / 6526 miss - head e6ae37a95 - digest sha256:cf8e231d02ef43... - run 33565534222
success	1	20	1022 / 1022	2m 19s / 4m 53s	`docker run ... @sha256:7a79a03...`	Aug 31, 22:26
run 33445477024 executed 1022 - ccache 98 hit / 6526 miss - head 9c899d688 - digest sha256:7a79a0320f2ddf... - run 33445477024
success	1	20	1021 / 1021	2m 59s / 5m 38s	`docker run ... @sha256:29fbd1a...`	Aug 30, 22:26
run 33338668019 executed 1021 - ccache 98 hit / 6525 miss - head c1db726c8 - digest sha256:29fbd1a588bc59... - run 33338668019
success	1	20	1021 / 1021	2m 53s / 5m 19s	`docker run ... @sha256:21c5447...`	Aug 29, 22:25
run 33278100897 executed 1021 - ccache 98 hit / 6525 miss - head 3ce4a8ebb - digest sha256:21c544766b3871... - run 33278100897
success	1	20	1021 / 1021	2m 12s / 4m 01s	`docker run ... @sha256:4115dd4...`	Aug 28, 22:22
run 33215942605 executed 1021 - ccache 98 hit / 6525 miss - head cb0087dc8 - digest sha256:4115dd45e6400e... - run 33215942605
success	1	20	1021 / 1021	2m 54s / 5m 35s	`docker run ... @sha256:647a88b...`	Aug 27, 22:23
run 33121572073 executed 1021 - ccache 98 hit / 6525 miss - head e1e930b98 - digest sha256:647a88b5e2c5b9... - run 33121572073
success	1	20	1021 / 1021	2m 54s / 5m 23s	`docker run ... @sha256:3c709d8...`	Aug 26, 22:22
run 33018679362 executed 1021 - ccache 98 hit / 6525 miss - head c22a02a39 - digest sha256:3c709d820aa6fd... - run 33018679362
success	1	20	1024 / 1024	2m 53s / 5m 41s	`docker run ... @sha256:b2ddec5...`	Aug 25, 22:22
run 32904927082 executed 1024 - ccache 98 hit / 6525 miss - head 248c9dbbb - digest sha256:b2ddec5b8d3a9f... - run 32904927082
success	1	20	1024 / 1024	2m 49s / 5m 29s	`docker run ... @sha256:0635fab...`	Aug 24, 22:21
run 32783383163 executed 1024 - ccache 98 hit / 6525 miss - head afddd62e7 - digest sha256:0635fabeb72149... - run 32783383163
success	1	20	1023 / 1023	2m 56s / 5m 33s	`docker run ... @sha256:30b9465...`	Aug 23, 22:21
run 32669758462 executed 1023 - ccache 98 hit / 6525 miss - head 2d8c0ec70 - digest sha256:30b94653902b7d... - run 32669758462
success	1	20	1023 / 1023	1m 56s / 4m 10s	`docker run ... @sha256:43f0ecd...`	Aug 22, 22:17
run 32601634032 executed 1023 - ccache 98 hit / 6525 miss - head 691ca8e04 - digest sha256:43f0ecd02af520... - run 32601634032
success	1	20	1023 / 1023	2m 54s / 5m 37s	`docker run ... @sha256:7fc168d...`	Aug 21, 22:18
run 32531644346 executed 1023 - ccache 98 hit / 6525 miss - head 3c5f2892c - digest sha256:7fc168dc0d37bf... - run 32531644346

v37t52309_37posted Aug 11, 01:25successsupersededstale 54dpg 20

basee5aff2aa6 Aug 21, 01:35 on master

applyapplied Aug 21, 01:50

rebaselast tried Aug 21, 01:50 on e5aff2aa6

pushAug 21, 01:50 -> 5e3a5c054 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1023 / 1023	1m 49s / 4m 18s	`docker run ... @sha256:5f0c74f...`	Aug 21, 01:59
run 32437691582 executed 1023 - ccache 98 hit / 6525 miss - head 5e3a5c054 - digest sha256:5f0c74fc7ea6aa... - run 32437691582
success	1	20	1023 / 1023	2m 13s / 4m 44s	`docker run ... @sha256:d28a025...`	Aug 20, 02:01
run 32322342526 executed 1023 - ccache 98 hit / 6525 miss - head 608e23bad - digest sha256:d28a02554b60a0... - run 32322342526
success	1	20	1023 / 1023	2m 13s / 4m 48s	`docker run ... @sha256:d3386d7...`	Aug 19, 01:59
run 32206226086 executed 1023 - ccache 98 hit / 6525 miss - head 53c920e8b - digest sha256:d3386d74240a8f... - run 32206226086
success	1	20	1019 / 1019	2m 13s / 4m 50s	`docker run ... @sha256:08c2984...`	Aug 18, 01:59
run 32089440714 executed 1019 - ccache 98 hit / 6524 miss - head c9e1cfea7 - digest sha256:08c29845fabb27... - run 32089440714
success	1	20	1019 / 1019	2m 54s / 5m 38s	`docker run ... @sha256:30d90d6...`	Aug 17, 01:58
run 31985919700 executed 1019 - ccache 98 hit / 6524 miss - head 1ed5b0064 - digest sha256:30d90d62ba3f3c... - run 31985919700
success	1	20	1019 / 1019	3m 09s / 5m 47s	`docker run ... @sha256:0a54dc4...`	Aug 16, 01:45
run 31919818827 executed 1019 - ccache 98 hit / 6524 miss - head 116cc5882 - digest sha256:0a54dc42abe85f... - run 31919818827
success	1	20	1019 / 1019	2m 55s / 5m 26s	`docker run ... @sha256:1c8e530...`	Aug 15, 01:44
run 31856742765 executed 1019 - ccache 98 hit / 6524 miss - head 11ddd5487 - digest sha256:1c8e530e63cf9c... - run 31856742765
success	1	20	1019 / 1019	2m 53s / 5m 35s	`docker run ... @sha256:6a7e192...`	Aug 14, 01:45
run 31760819153 executed 1019 - ccache 165 hit / 6457 miss - head 1ca26e716 - digest sha256:6a7e1921974894... - run 31760819153
success	1	20	1019 / 1019	2m 51s / 5m 33s	`docker run ... @sha256:5d8c8b7...`	Aug 13, 01:45
run 31657854293 executed 1019 - ccache 165 hit / 6457 miss - head 923a41b10 - digest sha256:5d8c8b7fb599ef... - run 31657854293
success	1	20	1019 / 1019	2m 18s / 4m 50s	`docker run ... @sha256:a9461ed...`	Aug 12, 01:39
run 31553684800 executed 1019 - ccache 165 hit / 6453 miss - head a3210370d - digest sha256:a9461edd713fd1... - run 31553684800
success	1	20	1019 / 1019	2m 53s / 5m 35s	`docker run ... @sha256:96ed385...`	Aug 11, 01:39
run 31449309185 executed 1019 - ccache 165 hit / 6453 miss - head 3f21794e5 - digest sha256:96ed38551f33e1... - run 31449309185

v35t52309_35posted Jul 12, 20:26successsupersededstale 2mopg 20

baseb91f79cd0 Aug 10, 00:01 on master

applyapplied Aug 10, 05:37

rebaselast tried Aug 10, 05:37 on b91f79cd0

pushAug 10, 05:37 -> cdd4a7460 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1019 / 1019	2m 40s / 4m 33s	`docker run ... @sha256:74fdd8e...`	Aug 10, 05:53
run 31359188518 executed 1019 - ccache 166 hit / 6452 miss - head cdd4a7460 - digest sha256:74fdd8e4fb949d... - run 31359188518
success	1	20	1019 / 1019	2m 48s / 5m 27s	`docker run ... @sha256:a447f55...`	Aug 08, 04:28
run 31239100932 executed 1019 - ccache 166 hit / 6452 miss - head 7d0cfb365 - digest sha256:a447f55c46b8f5... - run 31239100932
success	1	20	1018 / 1018	2m 45s / 5m 05s	`docker run ... @sha256:7ab405f...`	Aug 07, 04:26
run 31146838569 executed 1018 - ccache 166 hit / 6452 miss - head 5eba13b33 - digest sha256:7ab405faa4360d... - run 31146838569
success	1	20	1018 / 1018	2m 58s / 5m 34s	`docker run ... @sha256:b5f4a91...`	Aug 05, 23:14
run 31054942909 executed 1018 - ccache 166 hit / 6452 miss - head d6032b253 - digest sha256:b5f4a9196ca809... - run 31054942909
success	1	20	1018 / 1018	2m 59s / 5m 24s	`docker run ... @sha256:a6e9794...`	Aug 04, 23:13
run 30958549071 executed 1018 - ccache 166 hit / 6452 miss - head 053f3df5b - digest sha256:a6e97947eacfe2... - run 30958549071
success	1	20	1018 / 1018	2m 47s / 5m 15s	`docker run ... @sha256:c2299ae...`	Aug 03, 23:12
run 30860733473 executed 1018 - ccache 166 hit / 6452 miss - head 92b536827 - digest sha256:c2299ae2e2914a... - run 30860733473
success	1	20	1017 / 1017	2m 55s / 5m 41s	`docker run ... @sha256:4227558...`	Aug 02, 23:11
run 30771288036 executed 1017 - ccache 166 hit / 6452 miss - head a1070cbab - digest sha256:422755812e32da... - run 30771288036
success	1	20	1017 / 1017	2m 10s / 4m 33s	`docker run ... @sha256:86ea1a9...`	Aug 01, 23:11
run 30722404493 executed 1017 - ccache 166 hit / 6452 miss - head f466de9ff - digest sha256:86ea1a929711d7... - run 30722404493
success	1	20	1017 / 1017	2m 57s / 5m 31s	`docker run ... @sha256:70a4143...`	Jul 31, 23:10
run 30671553783 executed 1017 - ccache 166 hit / 6452 miss - head 345b1c330 - digest sha256:70a41430b759ed... - run 30671553783
tests failed	1	20	1015 / 1016	2m 49s / 5m 28s	`docker run ... @sha256:7bbeadb...`	Jul 30, 23:09
run 30588897811 failed: recovery/051_effective_wal_level executed 1016 - ccache 166 hit / 6452 miss - head b316e36b5 - digest sha256:7bbeadbefd1de9... - run 30588897811
success	1	20	1016 / 1016	2m 54s / 5m 32s	`docker run ... @sha256:4d1ed02...`	Jul 29, 23:07
run 30497795530 executed 1016 - ccache 166 hit / 6452 miss - head 35f25c1ec - digest sha256:4d1ed02cde98eb... - run 30497795530
success	1	20	1015 / 1015	2m 49s / 5m 11s	`docker run ... @sha256:36c364d...`	Jul 28, 23:07
run 30406263201 executed 1015 - ccache 166 hit / 6452 miss - head 10532224b - digest sha256:36c364d113dc65... - run 30406263201

v31t52309_31posted Apr 23, 18:11build failedsupersededstale 3mopg 20

base8a045f760 Jul 28, 08:50 on master

applyapplied Jul 28, 15:54

rebaselast tried Jul 28, 15:54 on 8a045f760

pushJul 28, 15:54 -> 128e1cc89 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
build failed	1	20	0 / 0	2m 07s / 0m 00s	-	Jul 28, 16:04
run 30375695896 executed 0 - ccache 98 hit / 5929 miss - head 128e1cc89 - run 30375695896
build failed	1	20	0 / 0	2m 05s / 0m 00s	-	Jul 27, 01:13
run 30229164493 executed 0 - ccache 98 hit / 5929 miss - head cb0d7d530 - run 30229164493