Unexpected reindex when altering column types for partitioned tables
4 patchsets tracked - current t139902_9
v9t139902_9posted about 1 hour agotests failedappliesrecent 0dpg 20
basee8f4f9e3c about 3 hours ago on master
applyapplied about 1 hour ago
rebaselast tried about 1 hour ago on e8f4f9e3c
pushabout 1 hour ago -> ca49b4fb1branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| tests failed | 1 | 20 | 670 / 671 | 2m 53s / 4m 54s | docker run ... :t139902 | about 1 hour ago |
run 37456262357failed: test_ddl_deparse/alter_table executed 671 - ccache 78 hit / 6544 miss - head ca49b4fb1 - digest sha256:3ab3a899beaf8c... - run 37456262357 | ||||||
v8t139902_8posted Sep 18, 19:59successsupersededrecent 0dpg 20
base6b858a36d about 11 hours ago on master
applyapplied about 10 hours ago
rebaselast tried about 10 hours ago on 6b858a36d
pushabout 10 hours ago -> 00e0f2e5cbranchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1039 / 1039 | 2m 06s / 4m 07s | docker run ... @sha256:5c9f6b0... | about 9 hours ago |
run 37406921386executed 1039 - ccache 78 hit / 6544 miss - head 00e0f2e5c - digest sha256:5c9f6b05970c72... - run 37406921386 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 54s / 5m 27s | docker run ... @sha256:c37bb5c... | 1 day ago |
run 37257483501executed 1039 - ccache 78 hit / 6544 miss - head e09036fa3 - digest sha256:c37bb5c76f8a0a... - run 37257483501 | ||||||
| success | 1 | 20 | 1039 / 1039 | 3m 02s / 5m 18s | docker run ... @sha256:4dfe703... | 2 days ago |
run 37172620533executed 1039 - ccache 78 hit / 6544 miss - head be81be22a - digest sha256:4dfe7038e9c12f... - run 37172620533 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 51s / 5m 12s | docker run ... @sha256:e9eb62d... | 3 days ago |
run 37091499820executed 1039 - ccache 78 hit / 6544 miss - head f968054d8 - digest sha256:e9eb62dda1d592... - run 37091499820 | ||||||
| success | 1 | 20 | 1039 / 1039 | 1m 46s / 4m 03s | docker run ... @sha256:85e0c2f... | 4 days ago |
run 36957845434executed 1039 - ccache 78 hit / 6544 miss - head 0ef50c632 - digest sha256:85e0c2fcec2abe... - run 36957845434 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 18s / 4m 55s | docker run ... @sha256:1ce08fd... | 5 days ago |
run 36807724950executed 1039 - ccache 78 hit / 6544 miss - head 35f3dea15 - digest sha256:1ce08fdd3ce702... - run 36807724950 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 49s / 5m 05s | docker run ... @sha256:b42c83e... | 6 days ago |
run 36661458759executed 1039 - ccache 78 hit / 6544 miss - head aff0e836e - digest sha256:b42c83ef573be0... - run 36661458759 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 55s / 5m 31s | docker run ... @sha256:7b1804b... | Sep 29, 02:58 |
run 36514187582executed 1039 - ccache 78 hit / 6544 miss - head e48b521f5 - digest sha256:7b1804b0e6d8ca... - run 36514187582 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 39s / 4m 53s | docker run ... @sha256:f3dcacb... | Sep 28, 02:55 |
run 36371016571executed 1039 - ccache 78 hit / 6544 miss - head b0d2afcc8 - digest sha256:f3dcacb77c2ba9... - run 36371016571 | ||||||
| success | 1 | 20 | 1039 / 1039 | 1m 48s / 4m 02s | docker run ... @sha256:b92f24e... | Sep 26, 22:06 |
run 36274724687executed 1039 - ccache 78 hit / 6544 miss - head 97c07aaea - digest sha256:b92f24ef5f8422... - run 36274724687 | ||||||
| success | 1 | 20 | 1039 / 1039 | 2m 09s / 4m 29s | docker run ... @sha256:5555275... | Sep 25, 22:05 |
run 36194210956executed 1039 - ccache 78 hit / 6544 miss - head 2492292ea - digest sha256:55552750257d4d... - run 36194210956 | ||||||
| success | 1 | 20 | 1038 / 1038 | 2m 57s / 5m 47s | docker run ... @sha256:1ff292d... | Sep 24, 22:06 |
run 36064439997executed 1038 - ccache 78 hit / 6544 miss - head 87c485ac7 - digest sha256:1ff292d1136f40... - run 36064439997 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 48s / 5m 08s | docker run ... @sha256:5ed9ea1... | Sep 23, 22:04 |
run 35925202148executed 1036 - ccache 98 hit / 6524 miss - head 1fd541a2d - digest sha256:5ed9ea1ee92819... - run 35925202148 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 53s / 5m 23s | docker run ... @sha256:beb879e... | Sep 22, 22:01 |
run 35789051837executed 1036 - ccache 98 hit / 6524 miss - head f208bf713 - digest sha256:beb879ee5f5e93... - run 35789051837 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 44s / 4m 52s | docker run ... @sha256:7d31632... | Sep 21, 21:50 |
run 35658574567executed 1036 - ccache 98 hit / 6524 miss - head 4e4c5c42b - digest sha256:7d31632dceec3a... - run 35658574567 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 51s / 5m 12s | docker run ... @sha256:835e311... | Sep 20, 20:13 |
run 35534276683executed 1036 - ccache 98 hit / 6524 miss - head 1992d542e - digest sha256:835e3117676130... - run 35534276683 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 19s / 4m 53s | docker run ... @sha256:225a6ea... | Sep 19, 20:11 |
run 35466144886executed 1036 - ccache 98 hit / 6524 miss - head 8d5f2153f - digest sha256:225a6ea024d30a... - run 35466144886 | ||||||
| success | 1 | 20 | 1036 / 1036 | 2m 55s / 5m 17s | docker run ... @sha256:2429463... | Sep 18, 20:12 |
run 35389197098executed 1036 - ccache 98 hit / 6524 miss - head 31dca6bc7 - digest sha256:2429463d8f6b04... - run 35389197098 | ||||||
v7t139902_7posted Sep 17, 20:25build failedsupersededstale 40dpg 20
base7612ae8ed Aug 26, 21:56 - 40 days / 362 commits behind master (from history)
applyapplied Sep 17, 20:28
rebaselast tried Sep 17, 20:28 on e1d8f81d4
Applying: Skip index rewriting when possible on ALTER TABLE ALTER COLUMN TYPE for partitioned tables Using index info to reconstruct a base tree... M src/backend/commands/tablecmds.c Falling back to patching base and 3-way merge... Auto-merging src/backend/commands/tablecmds.c CONFLICT (content): Merge conflict in src/backend/commands/tablecmds.c Patch failed at 0001 Skip index rewriting when possible on ALTER TABLE ALTER COLUMN TYPE for partitioned tables /ci/repo/worktrees/worktree/rebase-apply/patch:85: trailing whitespace. * indexes and constraints that depend on the altered columns. We record the /ci/repo/worktrees/worktree/rebase-apply/patch:86: trailing whitespace. * objects that need to be deleted here, so they can be dropped by the caller /ci/repo/worktrees/worktree/rebase-apply/patch:100: trailing whitespace. /ci/repo/worktrees/worktree/rebase-apply/patch:142: trailing whitespace. * that we won't create duplicate indexes. We rely on postgres /ci/repo/worktrees/worktree/rebase-apply/patch:143: trailing whitespace. * automatically attaching existing child indexes to a new warning: squelched 3 whitespace errors warning: 8 lines add whitespace errors. 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/commands/tablecmds.c
pushSep 17, 20:28 -> 8a87958d5branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| build failed | 1 | 20 | 0 / 0 | 1m 03s / 0m 00s | - | Sep 17, 20:31 |
run 35270989455executed 0 - ccache 98 hit / 5514 miss - head 8a87958d5 - run 35270989455 | ||||||
v4t139902_4posted Jun 16, 11:24successsupersededstale 57dpg 20
base1f3b9bb10 Aug 10, 05:53 on master
applyapplied Aug 10, 06:37
rebaselast tried Sep 09, 06:23 on 86f7c82cf
Applying: Skip index rewriting when possible on ALTER TABLE ALTER COLUMN TYPE for partitioned tables Patch failed at 0001 Skip index rewriting when possible on ALTER TABLE ALTER COLUMN TYPE for partitioned tables error: sha1 information is lacking or useless (src/test/regress/expected/alter_table.out). error: could not build fake ancestor 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"
pushAug 10, 06:38 -> 2f4dc6708branchdiff vs base
| Result | Att | PG | Tests | Build / test | Image | When |
|---|---|---|---|---|---|---|
| success | 1 | 20 | 1019 / 1019 | 2m 56s / 5m 25s | docker run ... @sha256:db5e2ff... | Aug 10, 06:49 |
run 31362718999executed 1019 - ccache 166 hit / 6452 miss - head 2f4dc6708 - digest sha256:db5e2ff5c6c236... - run 31362718999 | ||||||
| success | 1 | 20 | 1019 / 1019 | 2m 53s / 5m 15s | docker run ... @sha256:cd260f7... | Aug 08, 05:30 |
run 31241318050executed 1019 - ccache 166 hit / 6452 miss - head ffcdff81b - digest sha256:cd260f70a649f5... - run 31241318050 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 48s / 5m 24s | docker run ... @sha256:6f53005... | Aug 07, 05:27 |
run 31149947330executed 1018 - ccache 166 hit / 6452 miss - head 72a3f9825 - digest sha256:6f53005157ea55... - run 31149947330 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 58s / 5m 33s | docker run ... @sha256:3203d5d... | Aug 06, 00:32 |
run 31059444341executed 1018 - ccache 166 hit / 6452 miss - head f468bb366 - digest sha256:3203d5de19c015... - run 31059444341 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 49s / 5m 24s | docker run ... @sha256:dd8cce5... | Aug 05, 00:31 |
run 30962953749executed 1018 - ccache 166 hit / 6452 miss - head 9376a14a4 - digest sha256:dd8cce53192cbe... - run 30962953749 | ||||||
| success | 1 | 20 | 1018 / 1018 | 2m 56s / 5m 33s | docker run ... @sha256:b2dd7ce... | Aug 04, 00:29 |
run 30865153851executed 1018 - ccache 166 hit / 6452 miss - head 092b751ae - digest sha256:b2dd7ce0b0c231... - run 30865153851 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 53s / 5m 11s | docker run ... @sha256:57e5221... | Aug 03, 00:27 |
run 30774139263executed 1017 - ccache 166 hit / 6452 miss - head 1263b1c0b - digest sha256:57e5221464434a... - run 30774139263 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 56s / 5m 35s | docker run ... @sha256:7be0c28... | Aug 02, 00:27 |
run 30724913803executed 1017 - ccache 166 hit / 6452 miss - head 4fe364a73 - digest sha256:7be0c2831d2e87... - run 30724913803 | ||||||
| success | 1 | 20 | 1017 / 1017 | 2m 41s / 4m 28s | docker run ... @sha256:3753a01... | Aug 01, 00:24 |
run 30675068207executed 1017 - ccache 166 hit / 6452 miss - head 8f3451c0e - digest sha256:3753a017f897e4... - run 30675068207 | ||||||
| success | 1 | 20 | 1016 / 1016 | 2m 56s / 5m 23s | docker run ... @sha256:0c21127... | Jul 31, 00:24 |
run 30592951817executed 1016 - ccache 166 hit / 6452 miss - head c872bc056 - digest sha256:0c2112717f2a5a... - run 30592951817 | ||||||
| success | 1 | 20 | 1016 / 1016 | 2m 46s / 4m 39s | docker run ... @sha256:2dee88b... | Jul 30, 00:23 |
run 30502006658executed 1016 - ccache 166 hit / 6452 miss - head d6bc4e9ad - digest sha256:2dee88b0e8b9df... - run 30502006658 | ||||||
| success | 1 | 20 | 1015 / 1015 | 2m 58s / 5m 23s | docker run ... @sha256:051f863... | Jul 29, 00:31 |
run 30410388995executed 1015 - ccache 166 hit / 6452 miss - head 0a37ccecb - digest sha256:051f863613382d... - run 30410388995 | ||||||