PoC: Simplify recovery after dropping a table by LOGGING the restore LSN

back to CI dashboard

6 patchsets tracked - current t50534_10

v10t50534_10posted Oct 15, 14:26successappliesrecent 0dpg 20
base5ffb8c740 1 day ago on master
applyapplied about 18 hours ago
rebaselast tried about 18 hours ago on 5ffb8c740
pushabout 18 hours ago -> cb8def0f9branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201051 / 10513m 03s / 5m 38sdocker run ... :t50534about 17 hours ago
run 39803035422
executed 1051 - ccache 78 hit / 6544 miss - head cb8def0f9 - digest sha256:67a73b87c0863b... - run 39803035422
success1201050 / 10502m 54s / 5m 24sdocker run ... @sha256:c09bad3...1 day ago
run 39622965604
executed 1050 - ccache 78 hit / 6544 miss - head 2a93b802b - digest sha256:c09bad32d9106e... - run 39622965604
success1201050 / 10502m 46s / 4m 43sdocker run ... @sha256:b257327...3 days ago
run 39442684152
executed 1050 - ccache 78 hit / 6544 miss - head 15de1f22b - digest sha256:b25732725b1258... - run 39442684152
success1201050 / 10502m 54s / 5m 22sdocker run ... @sha256:6d9c1d1...4 days ago
run 39271633509
executed 1050 - ccache 78 hit / 6544 miss - head a60aa3660 - digest sha256:6d9c1d1f9fc80f... - run 39271633509
success1201050 / 10501m 41s / 4m 11sdocker run ... @sha256:7ba6ba4...5 days ago
run 39136626309
executed 1050 - ccache 78 hit / 6544 miss - head 15c61992b - digest sha256:7ba6ba4b5b9cc8... - run 39136626309
success1201050 / 10502m 58s / 5m 37sdocker run ... @sha256:6e95b51...6 days ago
run 39041180018
executed 1050 - ccache 78 hit / 6544 miss - head 9328d4c8d - digest sha256:6e95b515c6e6b6... - run 39041180018
success1201050 / 10503m 04s / 5m 52sdocker run ... @sha256:ad44eac...7 days ago
run 38916316104
executed 1050 - ccache 78 hit / 6544 miss - head 8822ee420 - digest sha256:ad44eac6158b86... - run 38916316104
success1201050 / 10501m 54s / 4m 18sdocker run ... @sha256:7fa171c...Oct 15, 14:38
run 38751923347
executed 1050 - ccache 78 hit / 6544 miss - head 58bfdccd4 - digest sha256:7fa171c50850b4... - run 38751923347
v9t50534_9posted Oct 12, 16:45successsupersededrecent 8dpg 20
based733fcaf5 Oct 14, 12:49 on master
applyapplied Oct 14, 17:02
rebaselast tried Oct 14, 17:02 on d733fcaf5
pushOct 14, 17:02 -> 388795867branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201046 / 10462m 52s / 5m 15sdocker run ... @sha256:cd78776...Oct 14, 17:13
run 38603307305
executed 1046 - ccache 78 hit / 6544 miss - head 388795867 - digest sha256:cd787762b7c185... - run 38603307305
success1201045 / 10452m 57s / 5m 37sdocker run ... @sha256:64e6080...Oct 13, 17:03
run 38434097444
executed 1045 - ccache 78 hit / 6544 miss - head c5a7b08eb - digest sha256:64e608043661af... - run 38434097444
success1201045 / 10452m 52s / 5m 41sdocker run ... @sha256:61c0a99...Oct 12, 16:58
run 38279852126
executed 1045 - ccache 78 hit / 6544 miss - head 4e1b88008 - digest sha256:61c0a998157b69... - run 38279852126
v8t50534_8posted Oct 12, 12:14successsupersededrecent 10dpg 20
base8e82d6610 Oct 12, 09:56 on master
applyapplied Oct 12, 12:17
rebaselast tried Oct 12, 12:17 on 8e82d6610
pushOct 12, 12:17 -> 134373447branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201045 / 10452m 33s / 4m 42sdocker run ... @sha256:e51efe5...Oct 12, 12:27
run 38248158805
executed 1045 - ccache 78 hit / 6544 miss - head 134373447 - digest sha256:e51efe53b10458... - run 38248158805
v7t50534_7posted Oct 10, 22:27successsupersededrecent 12dpg 20
base9e7d15248 Oct 10, 23:38 on master
applyapplied Oct 11, 22:29
rebaselast tried Oct 11, 22:29 on 9e7d15248
pushOct 11, 22:29 -> cc709d3fcbranchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201045 / 10452m 52s / 5m 32sdocker run ... @sha256:06af542...Oct 11, 22:40
run 38180630226
executed 1045 - ccache 78 hit / 6544 miss - head cc709d3fc - digest sha256:06af5427ddbaea... - run 38180630226
success1201045 / 10452m 56s / 5m 23sdocker run ... @sha256:bb896ff...Oct 10, 22:39
run 38091562536
executed 1045 - ccache 78 hit / 6544 miss - head 29d1331c1 - digest sha256:bb896ff118c11c... - run 38091562536
v6t50534_6posted Sep 28, 13:54successsupersededrecent 16dpg 20
basea14041d43 Oct 06, 14:04 on master
applyapplied Oct 06, 14:14
rebaselast tried Oct 10, 14:19 on f58ab18a9
Applying: Add LSN logging for DROP and TRUNCATE TABLE operations
Using index info to reconstruct a base tree...
M	doc/src/sgml/config.sgml
M	src/backend/access/transam/xact.c
M	src/backend/access/transam/xlog.c
M	src/backend/commands/tablecmds.c
M	src/backend/utils/misc/guc_parameters.dat
M	src/backend/utils/misc/postgresql.conf.sample
M	src/include/access/xlog.h
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/include/access/xlog.h
Auto-merging src/backend/utils/misc/postgresql.conf.sample
Auto-merging src/backend/utils/misc/guc_parameters.dat
Auto-merging src/backend/commands/tablecmds.c
Auto-merging src/backend/access/transam/xlog.c
Auto-merging src/backend/access/transam/xact.c
Auto-merging doc/src/sgml/config.sgml
Patch failed at 0001 Add LSN logging for DROP and TRUNCATE TABLE operations

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 06, 14:14 -> 4fba4e3e4branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
success1201041 / 10412m 16s / 4m 59sdocker run ... @sha256:1540a29...Oct 06, 14:24
run 37477364291
executed 1041 - ccache 78 hit / 6544 miss - head 4fba4e3e4 - digest sha256:1540a293513099... - run 37477364291
success1201040 / 10402m 43s / 4m 54sdocker run ... @sha256:075f727...Oct 05, 14:24
run 37322973365
executed 1040 - ccache 78 hit / 6544 miss - head 1f890969b - digest sha256:075f7270b5d0d7... - run 37322973365
success1201040 / 10401m 42s / 4m 13sdocker run ... @sha256:401d54f...Oct 04, 14:18
run 37208304630
executed 1040 - ccache 78 hit / 6544 miss - head c830a479a - digest sha256:401d54f8eb5e1f... - run 37208304630
success1201040 / 10402m 44s / 4m 44sdocker run ... @sha256:f5dd1cc...Oct 03, 14:19
run 37128654221
executed 1040 - ccache 78 hit / 6544 miss - head e1f4a67b3 - digest sha256:f5dd1cc5fb3141... - run 37128654221
success1201040 / 10402m 15s / 4m 52sdocker run ... @sha256:ab2e9bf...Oct 02, 14:18
run 37017807186
executed 1040 - ccache 78 hit / 6544 miss - head 071fac0d0 - digest sha256:ab2e9bfc2f00d9... - run 37017807186
success1201040 / 10402m 53s / 5m 34sdocker run ... @sha256:e312f9a...Oct 01, 14:19
run 36873943756
executed 1040 - ccache 78 hit / 6544 miss - head 01c849e0f - digest sha256:e312f9a15a659c... - run 36873943756
success1201040 / 10402m 49s / 5m 15sdocker run ... @sha256:9aa5d1c...Sep 30, 14:12
run 36725951340
executed 1040 - ccache 78 hit / 6544 miss - head 07cc26cc9 - digest sha256:9aa5d1cdb1721a... - run 36725951340
success1201040 / 10402m 52s / 5m 15sdocker run ... @sha256:0d44564...Sep 29, 14:10
run 36579291940
executed 1040 - ccache 78 hit / 6544 miss - head 3e20119b2 - digest sha256:0d445644f99d88... - run 36579291940
success1201040 / 10401m 58s / 4m 05sdocker run ... @sha256:7ab0f23...Sep 28, 14:06
run 36432410096
executed 1040 - ccache 78 hit / 6544 miss - head 5ec414d9c - digest sha256:7ab0f23508f3d2... - run 36432410096
v5t50534_5posted Dec 10, 2025build failedsupersededstale 11mopg 19
base1b105f947 Dec 09, 2025 - 317 days / 2910 commits behind master (from history)
applyapplied Jul 26, 07:20
pushJul 27, 05:44 -> 8b175b933branchdiff vs base
ResultAttPGTestsBuild / testImageWhen
build failed1190 / 00m 02s / 0m 00s-Jul 27, 05:46
run 30240608966
executed 0 - ccache 98 hit / 4907 miss - head 8b175b933 - run 30240608966