[PATCH] Fix PITR pause bypass when initial XLOG_RUNNING_XACTS has subxid overflow

5 patchsets tracked - current t53405_11

v11t53405_11posted Oct 12, 07:42successneeds rebaserecent 7dpg 20

base6aecabcd5 Oct 15, 06:42 on master

applyapplied Oct 15, 07:54

rebaselast tried about 17 hours ago on ae75d12b5

Applying: Shut down instead of promoting when recovery cannot pause
Using index info to reconstruct a base tree...
M	doc/src/sgml/config.sgml
M	src/backend/access/transam/xlogrecovery.c
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/access/transam/xlogrecovery.c
Auto-merging doc/src/sgml/config.sgml
Patch failed at 0001 Shut down instead of promoting when recovery cannot pause

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

pushOct 15, 07:54 -> b867ae97f branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1048 / 1048	2m 55s / 5m 30s	`docker run ... :t53405`	Oct 15, 08:05
run 38701911735 executed 1048 - ccache 78 hit / 6544 miss - head b867ae97f - digest sha256:e4a534d3e89539... - run 38701911735
success	1	20	1045 / 1045	2m 42s / 4m 56s	`docker run ... @sha256:8ead6d2...`	Oct 14, 07:59
run 38530835658 executed 1045 - ccache 78 hit / 6544 miss - head 250ce614d - digest sha256:8ead6d2655bb2e... - run 38530835658
success	1	20	1045 / 1045	2m 52s / 5m 31s	`docker run ... @sha256:e64fa2d...`	Oct 13, 07:56
run 38364765242 executed 1045 - ccache 78 hit / 6544 miss - head 6f588664d - digest sha256:e64fa2d54f025c... - run 38364765242
success	1	20	1045 / 1045	2m 13s / 4m 40s	`docker run ... @sha256:3600dde...`	Oct 12, 07:52
run 38219376692 executed 1045 - ccache 78 hit / 6544 miss - head 3c4c37168 - digest sha256:3600dde03dca1e... - run 38219376692

v9t53405_9posted Aug 28, 15:51successsupersededrecent 29dpg 20

base4a2f5533f Sep 23, 20:37 on master

applyapplied Sep 23, 20:53

rebaselast tried Oct 11, 02:17 on 9e7d15248

Applying: Shut down instead of promoting when recovery cannot pause
Using index info to reconstruct a base tree...
M	doc/src/sgml/config.sgml
M	src/backend/access/transam/xlogrecovery.c
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/access/transam/xlogrecovery.c
Auto-merging doc/src/sgml/config.sgml
Patch failed at 0001 Shut down instead of promoting when recovery cannot pause

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, 20:53 -> 1320c1ef3 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1037 / 1037	2m 54s / 5m 30s	`docker run ... @sha256:ab8503b...`	Sep 23, 21:04
run 35918958586 executed 1037 - ccache 98 hit / 6524 miss - head 1320c1ef3 - digest sha256:ab8503bf72b0c0... - run 35918958586
success	1	20	1037 / 1037	2m 13s / 4m 44s	`docker run ... @sha256:48a487d...`	Sep 22, 21:01
run 35783020868 executed 1037 - ccache 98 hit / 6524 miss - head c5746ccaa - digest sha256:48a487d2381275... - run 35783020868
success	1	20	1037 / 1037	2m 17s / 4m 55s	`docker run ... @sha256:4d81fcc...`	Sep 21, 20:48
run 35652315908 executed 1037 - ccache 98 hit / 6524 miss - head 0e2383cdf - digest sha256:4d81fcc62d711a... - run 35652315908
success	1	20	1037 / 1037	2m 13s / 4m 31s	`docker run ... @sha256:7f4bfe5...`	Sep 20, 15:15
run 35518507909 executed 1037 - ccache 98 hit / 6524 miss - head 583fc6954 - digest sha256:7f4bfe53cfdf89... - run 35518507909
success	1	20	1037 / 1037	2m 51s / 5m 19s	`docker run ... @sha256:71ed13b...`	Sep 19, 15:15
run 35450669234 executed 1037 - ccache 98 hit / 6524 miss - head 2221c9da9 - digest sha256:71ed13bd90add6... - run 35450669234
success	1	20	1037 / 1037	2m 35s / 4m 47s	`docker run ... @sha256:f3e9ac1...`	Sep 18, 15:12
run 35359987533 executed 1037 - ccache 98 hit / 6524 miss - head 82c2d2b0b - digest sha256:f3e9ac16c2910e... - run 35359987533
success	1	20	1037 / 1037	2m 54s / 5m 28s	`docker run ... @sha256:54d6b5d...`	Sep 17, 15:11
run 35237384446 executed 1037 - ccache 98 hit / 6524 miss - head 748a8c52f - digest sha256:54d6b5d3ef529b... - run 35237384446
success	1	20	1037 / 1037	1m 57s / 4m 28s	`docker run ... @sha256:7448d0a...`	Sep 16, 14:57
run 35111064608 executed 1037 - ccache 98 hit / 6524 miss - head 9d1a07a83 - digest sha256:7448d0a841bb4f... - run 35111064608
success	1	20	1037 / 1037	2m 51s / 5m 26s	`docker run ... @sha256:786f3a2...`	Sep 15, 14:56
run 34983800715 executed 1037 - ccache 98 hit / 6523 miss - head df632ac9b - digest sha256:786f3a2866da8c... - run 34983800715
success	1	20	1037 / 1037	2m 14s / 4m 46s	`docker run ... @sha256:dbe73c3...`	Sep 14, 14:50
run 34857158939 executed 1037 - ccache 98 hit / 6523 miss - head bc721df86 - digest sha256:dbe73c3e380e0b... - run 34857158939
success	1	20	1024 / 1024	2m 13s / 4m 55s	`docker run ... @sha256:26de918...`	Sep 13, 14:12
run 34761510439 executed 1024 - ccache 98 hit / 6523 miss - head 064fadeca - digest sha256:26de918181dc65... - run 34761510439
success	1	20	1024 / 1024	2m 53s / 5m 33s	`docker run ... @sha256:c13ce86...`	Sep 12, 13:52
run 34697126122 executed 1024 - ccache 98 hit / 6523 miss - head b0a7245e8 - digest sha256:c13ce868e82c7e... - run 34697126122
success	1	20	1023 / 1023	2m 55s / 5m 18s	`docker run ... @sha256:98494cd...`	Sep 11, 13:53
run 34605540196 executed 1023 - ccache 98 hit / 6523 miss - head 743a6eaf3 - digest sha256:98494cd1ed4f72... - run 34605540196
success	1	20	1023 / 1023	2m 55s / 5m 37s	`docker run ... @sha256:7765ab6...`	Sep 10, 13:53
run 34483700582 executed 1023 - ccache 98 hit / 6523 miss - head 62cfbbe9d - digest sha256:7765ab618c05b5... - run 34483700582
success	1	20	1021 / 1021	3m 00s / 5m 25s	`docker run ... @sha256:89df61b...`	Sep 09, 13:45
run 34357649973 executed 1021 - ccache 98 hit / 6523 miss - head 6d8cade57 - digest sha256:89df61b2c15616... - run 34357649973
success	1	20	1021 / 1021	2m 27s / 4m 38s	`docker run ... @sha256:8768908...`	Sep 08, 13:42
run 34232299433 executed 1021 - ccache 98 hit / 6523 miss - head 4dd03019c - digest sha256:8768908040dfd2... - run 34232299433
success	1	20	1025 / 1025	2m 10s / 4m 48s	`docker run ... @sha256:31d0ba1...`	Sep 07, 13:36
run 34127311633 executed 1025 - ccache 98 hit / 6527 miss - head e6d83925a - digest sha256:31d0ba13ab9f0c... - run 34127311633
success	1	20	1025 / 1025	2m 10s / 4m 48s	`docker run ... @sha256:ab624ad...`	Sep 05, 16:07
run 33976378852 executed 1025 - ccache 98 hit / 6527 miss - head c12b7f55e - digest sha256:ab624ad9971964... - run 33976378852
success	1	20	1025 / 1025	2m 48s / 4m 52s	`docker run ... @sha256:adb6ffd...`	Sep 04, 16:06
run 33892373412 executed 1025 - ccache 98 hit / 6527 miss - head d3a7066b3 - digest sha256:adb6ffd016814d... - run 33892373412
success	1	20	1024 / 1024	3m 01s / 5m 38s	`docker run ... @sha256:c709eb4...`	Sep 03, 16:08
run 33775649524 executed 1024 - ccache 98 hit / 6526 miss - head 68243b729 - digest sha256:c709eb48a64d5e... - run 33775649524
success	1	20	1023 / 1023	1m 57s / 3m 47s	`docker run ... @sha256:323ce27...`	Sep 02, 16:05
run 33651777757 executed 1023 - ccache 98 hit / 6526 miss - head 0f52bac4e - digest sha256:323ce277ef8138... - run 33651777757
success	1	20	1023 / 1023	2m 50s / 5m 11s	`docker run ... @sha256:389cde4...`	Sep 01, 16:06
run 33528762308 executed 1023 - ccache 98 hit / 6526 miss - head 10725ff5e - digest sha256:389cde4a12263e... - run 33528762308
success	1	20	1023 / 1023	2m 54s / 5m 31s	`docker run ... @sha256:4e85d4c...`	Aug 31, 16:06
run 33411126821 executed 1023 - ccache 98 hit / 6526 miss - head bc4ba1287 - digest sha256:4e85d4ca1c7584... - run 33411126821
success	1	20	1022 / 1022	2m 04s / 4m 41s	`docker run ... @sha256:29121bf...`	Aug 30, 16:03
run 33320910225 executed 1022 - ccache 98 hit / 6525 miss - head 3e31c224f - digest sha256:29121bf46bb221... - run 33320910225
success	1	20	1022 / 1022	2m 56s / 5m 46s	`docker run ... @sha256:a7f97a7...`	Aug 29, 16:04
run 33261463223 executed 1022 - ccache 98 hit / 6525 miss - head 42d70449a - digest sha256:a7f97a7f77c396... - run 33261463223
success	1	20	1022 / 1022	2m 59s / 5m 48s	`docker run ... @sha256:3092210...`	Aug 28, 16:03
run 33187229487 executed 1022 - ccache 98 hit / 6525 miss - head 00dbb22e2 - digest sha256:309221094ccd87... - run 33187229487

v7t53405_7posted Aug 07, 14:43successsupersededstale 57dpg 20

baseedc095a26 Aug 26, 09:59 on master

applyapplied Aug 26, 12:55

rebaselast tried Aug 28, 13:09 on de5659440

Applying: Shut down instead of promoting when recovery cannot pause
Using index info to reconstruct a base tree...
M	doc/src/sgml/config.sgml
M	src/backend/access/transam/xlogrecovery.c
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/access/transam/xlogrecovery.c
Auto-merging doc/src/sgml/config.sgml
Patch failed at 0001 Shut down instead of promoting when recovery cannot pause

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

pushAug 26, 12:55 -> acf6d0127 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1025 / 1025	2m 12s / 4m 23s	`docker run ... @sha256:8515b3d...`	Aug 26, 13:05
run 32971228361 executed 1025 - ccache 98 hit / 6525 miss - head acf6d0127 - digest sha256:8515b3d55ef305... - run 32971228361
success	1	20	1025 / 1025	2m 09s / 4m 42s	`docker run ... @sha256:7809ec4...`	Aug 25, 12:55
run 32849335927 executed 1025 - ccache 98 hit / 6525 miss - head 2ef9a69af - digest sha256:7809ec4ff71aab... - run 32849335927
success	1	20	1024 / 1024	2m 47s / 5m 27s	`docker run ... @sha256:cb6f0b2...`	Aug 24, 12:56
run 32728710464 executed 1024 - ccache 98 hit / 6525 miss - head 8ccfb7194 - digest sha256:cb6f0b2a09f5bf... - run 32728710464
success	1	20	1024 / 1024	2m 32s / 4m 36s	`docker run ... @sha256:6fa7f25...`	Aug 23, 12:56
run 32640194781 executed 1024 - ccache 98 hit / 6525 miss - head 2059a422b - digest sha256:6fa7f25e6648ac... - run 32640194781
success	1	20	1024 / 1024	2m 58s / 5m 23s	`docker run ... @sha256:19d2f35...`	Aug 22, 12:54
run 32573683718 executed 1024 - ccache 98 hit / 6525 miss - head 3f250da47 - digest sha256:19d2f3503544a2... - run 32573683718
success	1	20	1024 / 1024	2m 45s / 4m 29s	`docker run ... @sha256:57e3474...`	Aug 21, 12:52
run 32483037867 executed 1024 - ccache 98 hit / 6525 miss - head 12f7b128d - digest sha256:57e347418a4cbf... - run 32483037867
success	1	20	1024 / 1024	2m 51s / 5m 10s	`docker run ... @sha256:489a21c...`	Aug 20, 12:52
run 32369970767 executed 1024 - ccache 98 hit / 6525 miss - head 55bc58749 - digest sha256:489a21c371b48c... - run 32369970767
success	1	20	1024 / 1024	1m 54s / 4m 04s	`docker run ... @sha256:1edf1da...`	Aug 19, 12:50
run 32253693124 executed 1024 - ccache 98 hit / 6525 miss - head 71a47fb5e - digest sha256:1edf1da9450b82... - run 32253693124
success	1	20	1022 / 1022	2m 50s / 5m 19s	`docker run ... @sha256:57770c8...`	Aug 18, 12:29
run 32136138641 executed 1022 - ccache 98 hit / 6525 miss - head f7adfd42b - digest sha256:57770c8c57d9f8... - run 32136138641
success	1	20	1020 / 1020	3m 03s / 5m 34s	`docker run ... @sha256:ccd8d9e...`	Aug 17, 12:34
run 32029155797 executed 1020 - ccache 98 hit / 6524 miss - head 3bde48702 - digest sha256:ccd8d9e897fb62... - run 32029155797
success	1	20	1020 / 1020	2m 50s / 5m 34s	`docker run ... @sha256:a6ecbbe...`	Aug 16, 12:25
run 31946466216 executed 1020 - ccache 98 hit / 6524 miss - head 76f3f796e - digest sha256:a6ecbbe472540b... - run 31946466216
success	1	20	1020 / 1020	2m 59s / 5m 05s	`docker run ... @sha256:afc4761...`	Aug 15, 12:25
run 31883996043 executed 1020 - ccache 98 hit / 6524 miss - head 885dde223 - digest sha256:afc476178d1251... - run 31883996043
success	1	20	1020 / 1020	2m 44s / 4m 40s	`docker run ... @sha256:b83da8f...`	Aug 14, 12:22
run 31799189946 executed 1020 - ccache 165 hit / 6457 miss - head 15f2fa5a2 - digest sha256:b83da8f9224fe1... - run 31799189946
success	1	20	1020 / 1020	2m 13s / 4m 25s	`docker run ... @sha256:9a41354...`	Aug 13, 12:22
run 31698727105 executed 1020 - ccache 165 hit / 6457 miss - head 711dfaeb7 - digest sha256:9a41354422191e... - run 31698727105
success	1	20	1020 / 1020	2m 48s / 5m 25s	`docker run ... @sha256:c9ce53d...`	Aug 12, 12:17
run 31594907381 executed 1020 - ccache 165 hit / 6457 miss - head 688880004 - digest sha256:c9ce53d5139de7... - run 31594907381
success	1	20	1020 / 1020	2m 56s / 5m 29s	`docker run ... @sha256:893ff81...`	Aug 11, 12:18
run 31489441903 executed 1020 - ccache 165 hit / 6453 miss - head 7e20c9b3d - digest sha256:893ff81ade7d2c... - run 31489441903
success	1	20	1020 / 1020	1m 55s / 4m 08s	`docker run ... @sha256:9563f7d...`	Aug 10, 12:11
run 31385946172 executed 1020 - ccache 166 hit / 6452 miss - head f8e3a55c0 - digest sha256:9563f7d67b6003... - run 31385946172
success	1	20	1020 / 1020	2m 49s / 5m 17s	`docker run ... @sha256:a890144...`	Aug 08, 14:57
run 31262790870 executed 1020 - ccache 166 hit / 6452 miss - head 5e8250867 - digest sha256:a890144cd2bd20... - run 31262790870
success	1	20	1020 / 1020	2m 10s / 4m 26s	`docker run ... @sha256:8aab13b...`	Aug 07, 14:55
run 31189235818 executed 1020 - ccache 166 hit / 6452 miss - head f739c8880 - digest sha256:8aab13baa00c0e... - run 31189235818

v6t53405_6posted Jun 16, 08:58successsupersededstale 5mopg 19

base55136e378 Jun 05, 20:16 - 139 days / 1295 commits behind master (from history)

applyapplied Jul 29, 00:13

rebaselast tried Jul 29, 00:13 on dd50eb914

Applying: Shut down instead of promoting when recovery cannot pause
Using index info to reconstruct a base tree...
M	doc/src/sgml/config.sgml
M	src/backend/access/transam/xlogrecovery.c
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/access/transam/xlogrecovery.c
Auto-merging doc/src/sgml/config.sgml
Patch failed at 0001 Shut down instead of promoting when recovery cannot pause

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

pushJul 29, 00:13 -> 8ad13e639 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	19	1006 / 1006	2m 49s / 5m 16s	`docker run ... @sha256:371b29f...`	Jul 29, 00:32
run 30410473940 executed 1006 - ccache 145 hit / 6474 miss - head 8ad13e639 - digest sha256:371b29f8f4da4e... - run 30410473940

v1t53405_1posted Feb 26, 12:57successsupersededstale 8mopg 19

base462fe0ff6 Feb 24, 04:26 - 240 days / 2342 commits behind master (from history)

applyapplied Jul 26, 07:19

pushJul 27, 03:35 -> 4adc9d869 branch diff vs base

patchsetdownload in thread

Result	Att	PG	Tests	Build / test	Image	When
success	1	19	948 / 948	2m 52s / 5m 02s	`docker run ... @sha256:be2f7ad...`	Jul 27, 03:45
run 30234970979 executed 948 - ccache 78 hit / 6502 miss - head 4adc9d869 - digest sha256:be2f7ad5313ae4... - run 30234970979