=== Applying patches on top of PostgreSQL commit ID 1fd1bd871012732e3c6c482667d2f2c56f1a9395 === /etc/rc.d/jail: WARNING: Per-jail configuration via jail_* variables is obsolete. Please consider migrating to /etc/jail.conf. Thu Feb 20 12:31:33 UTC 2025 On branch cf/5160 nothing to commit, working tree clean === applying patch ./v8-0001-Specs-top-reproduce-the-issues-with-CREATE-INDEX.patch Applied patch to 'src/backend/commands/indexcmds.c' cleanly. Applied patch to 'src/backend/executor/execIndexing.c' cleanly. Applied patch to 'src/backend/executor/nodeModifyTable.c' cleanly. Applied patch to 'src/backend/utils/time/snapmgr.c' cleanly. Applied patch to 'src/test/modules/injection_points/Makefile' cleanly. Falling back to direct application... Falling back to direct application... Falling back to direct application... Falling back to direct application... Falling back to direct application... Applied patch to 'src/test/modules/injection_points/meson.build' cleanly. Falling back to direct application... Falling back to direct application... Falling back to direct application... Falling back to direct application... Falling back to direct application... [cf/5160 ce141c1e32] Specs top reproduce the issues with CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY in scenarios involving INSERT ON CONFLICT DO UPDATE. These tests reproduce different error cases related to "duplicate key value violates unique constraint" where this error should not occur by design. Author: nkey Date: Thu Feb 20 14:50:10 2025 +0300 16 files changed, 1361 insertions(+), 2 deletions(-) create mode 100644 src/test/modules/injection_points/expected/index_concurrently_upsert.out create mode 100644 src/test/modules/injection_points/expected/index_concurrently_upsert_predicate.out create mode 100644 src/test/modules/injection_points/expected/reindex_concurrently_upsert.out create mode 100644 src/test/modules/injection_points/expected/reindex_concurrently_upsert_on_constraint.out create mode 100644 src/test/modules/injection_points/expected/reindex_concurrently_upsert_partitioned.out create mode 100644 src/test/modules/injection_points/specs/index_concurrently_upsert.spec create mode 100644 src/test/modules/injection_points/specs/index_concurrently_upsert_predicate.spec create mode 100644 src/test/modules/injection_points/specs/reindex_concurrently_upsert.spec create mode 100644 src/test/modules/injection_points/specs/reindex_concurrently_upsert_on_constraint.spec create mode 100644 src/test/modules/injection_points/specs/reindex_concurrently_upsert_partitioned.spec === applying patch ./v8-0002-Modify-the-infer_arbiter_indexes-function-to-cons.patch Applied patch to 'src/backend/optimizer/util/plancat.c' cleanly. [cf/5160 d5964c43bd] Modify the infer_arbiter_indexes function to consider both indisvalid and indisready indexes. Ensure that at least one indisvalid index is still required. Author: nkey Date: Thu Feb 20 14:50:58 2025 +0300 1 file changed, 13 insertions(+), 5 deletions(-) === applying patch ./v8-0003-Modify-the-infer_arbiter_indexes-function-to-also.patch Applied patch to 'src/backend/optimizer/util/plancat.c' cleanly. [cf/5160 0c9d1b9db8] Modify the infer_arbiter_indexes function to also look for indexes that match the specified named constraint to be used as arbiters. This ensures that the same set of arbiter indexes is used for all concurrent transactions in cases where REINDEX CONCURRENTLY processes an index used as a named constraint. Author: nkey Date: Thu Feb 20 14:51:19 2025 +0300 1 file changed, 88 insertions(+), 33 deletions(-) === applying patch ./v8-0004-Modify-the-ExecInitPartitionInfo-function-to-cons.patch Applied patch to 'src/backend/executor/execPartition.c' cleanly. [cf/5160 2e0482db1f] Modify the ExecInitPartitionInfo function to consider partitioned indexes that are potentially processed by REINDEX CONCURRENTLY as arbiters as well. Author: nkey Date: Thu Feb 20 14:52:23 2025 +0300 1 file changed, 107 insertions(+), 12 deletions(-)