Unexpected reindex when altering column types for partitioned tables

back to CI dashboard

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
ResultAttPGTestsBuild / testImageWhen
tests failed120670 / 6712m 53s / 4m 54sdocker run ... :t139902about 1 hour ago
run 37456262357
failed: 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
ResultAttPGTestsBuild / testImageWhen
success1201039 / 10392m 06s / 4m 07sdocker run ... @sha256:5c9f6b0...about 9 hours ago
run 37406921386
executed 1039 - ccache 78 hit / 6544 miss - head 00e0f2e5c - digest sha256:5c9f6b05970c72... - run 37406921386
success1201039 / 10392m 54s / 5m 27sdocker run ... @sha256:c37bb5c...1 day ago
run 37257483501
executed 1039 - ccache 78 hit / 6544 miss - head e09036fa3 - digest sha256:c37bb5c76f8a0a... - run 37257483501
success1201039 / 10393m 02s / 5m 18sdocker run ... @sha256:4dfe703...2 days ago
run 37172620533
executed 1039 - ccache 78 hit / 6544 miss - head be81be22a - digest sha256:4dfe7038e9c12f... - run 37172620533
success1201039 / 10392m 51s / 5m 12sdocker run ... @sha256:e9eb62d...3 days ago
run 37091499820
executed 1039 - ccache 78 hit / 6544 miss - head f968054d8 - digest sha256:e9eb62dda1d592... - run 37091499820
success1201039 / 10391m 46s / 4m 03sdocker run ... @sha256:85e0c2f...4 days ago
run 36957845434
executed 1039 - ccache 78 hit / 6544 miss - head 0ef50c632 - digest sha256:85e0c2fcec2abe... - run 36957845434
success1201039 / 10392m 18s / 4m 55sdocker run ... @sha256:1ce08fd...5 days ago
run 36807724950
executed 1039 - ccache 78 hit / 6544 miss - head 35f3dea15 - digest sha256:1ce08fdd3ce702... - run 36807724950
success1201039 / 10392m 49s / 5m 05sdocker run ... @sha256:b42c83e...6 days ago
run 36661458759
executed 1039 - ccache 78 hit / 6544 miss - head aff0e836e - digest sha256:b42c83ef573be0... - run 36661458759
success1201039 / 10392m 55s / 5m 31sdocker run ... @sha256:7b1804b...Sep 29, 02:58
run 36514187582
executed 1039 - ccache 78 hit / 6544 miss - head e48b521f5 - digest sha256:7b1804b0e6d8ca... - run 36514187582
success1201039 / 10392m 39s / 4m 53sdocker run ... @sha256:f3dcacb...Sep 28, 02:55
run 36371016571
executed 1039 - ccache 78 hit / 6544 miss - head b0d2afcc8 - digest sha256:f3dcacb77c2ba9... - run 36371016571
success1201039 / 10391m 48s / 4m 02sdocker run ... @sha256:b92f24e...Sep 26, 22:06
run 36274724687
executed 1039 - ccache 78 hit / 6544 miss - head 97c07aaea - digest sha256:b92f24ef5f8422... - run 36274724687
success1201039 / 10392m 09s / 4m 29sdocker run ... @sha256:5555275...Sep 25, 22:05
run 36194210956
executed 1039 - ccache 78 hit / 6544 miss - head 2492292ea - digest sha256:55552750257d4d... - run 36194210956
success1201038 / 10382m 57s / 5m 47sdocker run ... @sha256:1ff292d...Sep 24, 22:06
run 36064439997
executed 1038 - ccache 78 hit / 6544 miss - head 87c485ac7 - digest sha256:1ff292d1136f40... - run 36064439997
success1201036 / 10362m 48s / 5m 08sdocker run ... @sha256:5ed9ea1...Sep 23, 22:04
run 35925202148
executed 1036 - ccache 98 hit / 6524 miss - head 1fd541a2d - digest sha256:5ed9ea1ee92819... - run 35925202148
success1201036 / 10362m 53s / 5m 23sdocker run ... @sha256:beb879e...Sep 22, 22:01
run 35789051837
executed 1036 - ccache 98 hit / 6524 miss - head f208bf713 - digest sha256:beb879ee5f5e93... - run 35789051837
success1201036 / 10362m 44s / 4m 52sdocker run ... @sha256:7d31632...Sep 21, 21:50
run 35658574567
executed 1036 - ccache 98 hit / 6524 miss - head 4e4c5c42b - digest sha256:7d31632dceec3a... - run 35658574567
success1201036 / 10362m 51s / 5m 12sdocker run ... @sha256:835e311...Sep 20, 20:13
run 35534276683
executed 1036 - ccache 98 hit / 6524 miss - head 1992d542e - digest sha256:835e3117676130... - run 35534276683
success1201036 / 10362m 19s / 4m 53sdocker run ... @sha256:225a6ea...Sep 19, 20:11
run 35466144886
executed 1036 - ccache 98 hit / 6524 miss - head 8d5f2153f - digest sha256:225a6ea024d30a... - run 35466144886
success1201036 / 10362m 55s / 5m 17sdocker run ... @sha256:2429463...Sep 18, 20:12
run 35389197098
executed 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
ResultAttPGTestsBuild / testImageWhen
build failed1200 / 01m 03s / 0m 00s-Sep 17, 20:31
run 35270989455
executed 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
ResultAttPGTestsBuild / testImageWhen
success1201019 / 10192m 56s / 5m 25sdocker run ... @sha256:db5e2ff...Aug 10, 06:49
run 31362718999
executed 1019 - ccache 166 hit / 6452 miss - head 2f4dc6708 - digest sha256:db5e2ff5c6c236... - run 31362718999
success1201019 / 10192m 53s / 5m 15sdocker run ... @sha256:cd260f7...Aug 08, 05:30
run 31241318050
executed 1019 - ccache 166 hit / 6452 miss - head ffcdff81b - digest sha256:cd260f70a649f5... - run 31241318050
success1201018 / 10182m 48s / 5m 24sdocker run ... @sha256:6f53005...Aug 07, 05:27
run 31149947330
executed 1018 - ccache 166 hit / 6452 miss - head 72a3f9825 - digest sha256:6f53005157ea55... - run 31149947330
success1201018 / 10182m 58s / 5m 33sdocker run ... @sha256:3203d5d...Aug 06, 00:32
run 31059444341
executed 1018 - ccache 166 hit / 6452 miss - head f468bb366 - digest sha256:3203d5de19c015... - run 31059444341
success1201018 / 10182m 49s / 5m 24sdocker run ... @sha256:dd8cce5...Aug 05, 00:31
run 30962953749
executed 1018 - ccache 166 hit / 6452 miss - head 9376a14a4 - digest sha256:dd8cce53192cbe... - run 30962953749
success1201018 / 10182m 56s / 5m 33sdocker run ... @sha256:b2dd7ce...Aug 04, 00:29
run 30865153851
executed 1018 - ccache 166 hit / 6452 miss - head 092b751ae - digest sha256:b2dd7ce0b0c231... - run 30865153851
success1201017 / 10172m 53s / 5m 11sdocker run ... @sha256:57e5221...Aug 03, 00:27
run 30774139263
executed 1017 - ccache 166 hit / 6452 miss - head 1263b1c0b - digest sha256:57e5221464434a... - run 30774139263
success1201017 / 10172m 56s / 5m 35sdocker run ... @sha256:7be0c28...Aug 02, 00:27
run 30724913803
executed 1017 - ccache 166 hit / 6452 miss - head 4fe364a73 - digest sha256:7be0c2831d2e87... - run 30724913803
success1201017 / 10172m 41s / 4m 28sdocker run ... @sha256:3753a01...Aug 01, 00:24
run 30675068207
executed 1017 - ccache 166 hit / 6452 miss - head 8f3451c0e - digest sha256:3753a017f897e4... - run 30675068207
success1201016 / 10162m 56s / 5m 23sdocker run ... @sha256:0c21127...Jul 31, 00:24
run 30592951817
executed 1016 - ccache 166 hit / 6452 miss - head c872bc056 - digest sha256:0c2112717f2a5a... - run 30592951817
success1201016 / 10162m 46s / 4m 39sdocker run ... @sha256:2dee88b...Jul 30, 00:23
run 30502006658
executed 1016 - ccache 166 hit / 6452 miss - head d6bc4e9ad - digest sha256:2dee88b0e8b9df... - run 30502006658
success1201015 / 10152m 58s / 5m 23sdocker run ... @sha256:051f863...Jul 29, 00:31
run 30410388995
executed 1015 - ccache 166 hit / 6452 miss - head 0a37ccecb - digest sha256:051f863613382d... - run 30410388995