PoC: Simplify recovery after dropping a table by LOGGING the restore LSN
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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1051 / 1051 | 3m 03s / 5m 38s | docker run ... :t50534 | about 17 hours ago |
run 39803035422executed 1051 - ccache 78 hit / 6544 miss - head cb8def0f9 - digest sha256:67a73b87c0863b... - run 39803035422 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 54s / 5m 24s | docker run ... @sha256:c09bad3... | 1 day ago |
run 39622965604executed 1050 - ccache 78 hit / 6544 miss - head 2a93b802b - digest sha256:c09bad32d9106e... - run 39622965604 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 46s / 4m 43s | docker run ... @sha256:b257327... | 3 days ago |
run 39442684152executed 1050 - ccache 78 hit / 6544 miss - head 15de1f22b - digest sha256:b25732725b1258... - run 39442684152 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 54s / 5m 22s | docker run ... @sha256:6d9c1d1... | 4 days ago |
run 39271633509executed 1050 - ccache 78 hit / 6544 miss - head a60aa3660 - digest sha256:6d9c1d1f9fc80f... - run 39271633509 | ||||||
| success | 1 | 20 | 1050 / 1050 | 1m 41s / 4m 11s | docker run ... @sha256:7ba6ba4... | 5 days ago |
run 39136626309executed 1050 - ccache 78 hit / 6544 miss - head 15c61992b - digest sha256:7ba6ba4b5b9cc8... - run 39136626309 | ||||||
| success | 1 | 20 | 1050 / 1050 | 2m 58s / 5m 37s | docker run ... @sha256:6e95b51... | 6 days ago |
run 39041180018executed 1050 - ccache 78 hit / 6544 miss - head 9328d4c8d - digest sha256:6e95b515c6e6b6... - run 39041180018 | ||||||
| success | 1 | 20 | 1050 / 1050 | 3m 04s / 5m 52s | docker run ... @sha256:ad44eac... | 7 days ago |
run 38916316104executed 1050 - ccache 78 hit / 6544 miss - head 8822ee420 - digest sha256:ad44eac6158b86... - run 38916316104 | ||||||
| success | 1 | 20 | 1050 / 1050 | 1m 54s / 4m 18s | docker run ... @sha256:7fa171c... | Oct 15, 14:38 |
run 38751923347executed 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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1046 / 1046 | 2m 52s / 5m 15s | docker run ... @sha256:cd78776... | Oct 14, 17:13 |
run 38603307305executed 1046 - ccache 78 hit / 6544 miss - head 388795867 - digest sha256:cd787762b7c185... - run 38603307305 | ||||||
| success | 1 | 20 | 1045 / 1045 | 2m 57s / 5m 37s | docker run ... @sha256:64e6080... | Oct 13, 17:03 |
run 38434097444executed 1045 - ccache 78 hit / 6544 miss - head c5a7b08eb - digest sha256:64e608043661af... - run 38434097444 | ||||||
| success | 1 | 20 | 1045 / 1045 | 2m 52s / 5m 41s | docker run ... @sha256:61c0a99... | Oct 12, 16:58 |
run 38279852126executed 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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1045 / 1045 | 2m 33s / 4m 42s | docker run ... @sha256:e51efe5... | Oct 12, 12:27 |
run 38248158805executed 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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1045 / 1045 | 2m 52s / 5m 32s | docker run ... @sha256:06af542... | Oct 11, 22:40 |
run 38180630226executed 1045 - ccache 78 hit / 6544 miss - head cc709d3fc - digest sha256:06af5427ddbaea... - run 38180630226 | ||||||
| success | 1 | 20 | 1045 / 1045 | 2m 56s / 5m 23s | docker run ... @sha256:bb896ff... | Oct 10, 22:39 |
run 38091562536executed 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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1041 / 1041 | 2m 16s / 4m 59s | docker run ... @sha256:1540a29... | Oct 06, 14:24 |
run 37477364291executed 1041 - ccache 78 hit / 6544 miss - head 4fba4e3e4 - digest sha256:1540a293513099... - run 37477364291 | ||||||
| success | 1 | 20 | 1040 / 1040 | 2m 43s / 4m 54s | docker run ... @sha256:075f727... | Oct 05, 14:24 |
run 37322973365executed 1040 - ccache 78 hit / 6544 miss - head 1f890969b - digest sha256:075f7270b5d0d7... - run 37322973365 | ||||||
| success | 1 | 20 | 1040 / 1040 | 1m 42s / 4m 13s | docker run ... @sha256:401d54f... | Oct 04, 14:18 |
run 37208304630executed 1040 - ccache 78 hit / 6544 miss - head c830a479a - digest sha256:401d54f8eb5e1f... - run 37208304630 | ||||||
| success | 1 | 20 | 1040 / 1040 | 2m 44s / 4m 44s | docker run ... @sha256:f5dd1cc... | Oct 03, 14:19 |
run 37128654221executed 1040 - ccache 78 hit / 6544 miss - head e1f4a67b3 - digest sha256:f5dd1cc5fb3141... - run 37128654221 | ||||||
| success | 1 | 20 | 1040 / 1040 | 2m 15s / 4m 52s | docker run ... @sha256:ab2e9bf... | Oct 02, 14:18 |
run 37017807186executed 1040 - ccache 78 hit / 6544 miss - head 071fac0d0 - digest sha256:ab2e9bfc2f00d9... - run 37017807186 | ||||||
| success | 1 | 20 | 1040 / 1040 | 2m 53s / 5m 34s | docker run ... @sha256:e312f9a... | Oct 01, 14:19 |
run 36873943756executed 1040 - ccache 78 hit / 6544 miss - head 01c849e0f - digest sha256:e312f9a15a659c... - run 36873943756 | ||||||
| success | 1 | 20 | 1040 / 1040 | 2m 49s / 5m 15s | docker run ... @sha256:9aa5d1c... | Sep 30, 14:12 |
run 36725951340executed 1040 - ccache 78 hit / 6544 miss - head 07cc26cc9 - digest sha256:9aa5d1cdb1721a... - run 36725951340 | ||||||
| success | 1 | 20 | 1040 / 1040 | 2m 52s / 5m 15s | docker run ... @sha256:0d44564... | Sep 29, 14:10 |
run 36579291940executed 1040 - ccache 78 hit / 6544 miss - head 3e20119b2 - digest sha256:0d445644f99d88... - run 36579291940 | ||||||
| success | 1 | 20 | 1040 / 1040 | 1m 58s / 4m 05s | docker run ... @sha256:7ab0f23... | Sep 28, 14:06 |
run 36432410096executed 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
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| build failed | 1 | 19 | 0 / 0 | 0m 02s / 0m 00s | - | Jul 27, 05:46 |
run 30240608966executed 0 - ccache 98 hit / 4907 miss - head 8b175b933 - run 30240608966 | ||||||