=== Applying patches on top of PostgreSQL commit ID 0c01f509a38f5b1f5fab26d98ae55d796541c2e4 === /etc/rc.d/jail: WARNING: Per-jail configuration via jail_* variables is obsolete. Please consider migrating to /etc/jail.conf. === applying patch ./v5-0001-Specs-top-reproduce-the-issues-with-CREATE-INDEX.patch patching file src/backend/commands/indexcmds.c patching file src/backend/executor/execIndexing.c patching file src/backend/executor/nodeModifyTable.c patching file src/backend/utils/time/snapmgr.c patching file src/test/modules/injection_points/Makefile patching file src/test/modules/injection_points/expected/index_concurrently_upsert.out patching file src/test/modules/injection_points/expected/index_concurrently_upsert_predicate.out patching file src/test/modules/injection_points/expected/reindex_concurrently_upsert.out patching file src/test/modules/injection_points/expected/reindex_concurrently_upsert_on_constraint.out patching file src/test/modules/injection_points/expected/reindex_concurrently_upsert_partitioned.out patching file src/test/modules/injection_points/meson.build patching file src/test/modules/injection_points/specs/index_concurrently_upsert.spec patching file src/test/modules/injection_points/specs/index_concurrently_upsert_predicate.spec patching file src/test/modules/injection_points/specs/reindex_concurrently_upsert.spec patching file src/test/modules/injection_points/specs/reindex_concurrently_upsert_on_constraint.spec patching file src/test/modules/injection_points/specs/reindex_concurrently_upsert_partitioned.spec [cf/5160 77d7cb8180] 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: Sun Nov 24 14:45:41 2024 +0100 16 files changed, 1299 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 ./v5-0002-Modify-the-infer_arbiter_indexes-function-to-cons.patch patching file src/backend/optimizer/util/plancat.c [cf/5160 707b91e322] 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: Sun Nov 24 14:49:35 2024 +0100 1 file changed, 13 insertions(+), 5 deletions(-) === applying patch ./v5-0003-Modify-the-infer_arbiter_indexes-function-to-also.patch patching file src/backend/optimizer/util/plancat.c [cf/5160 675d3b0d7d] 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: Sun Nov 24 14:54:13 2024 +0100 1 file changed, 88 insertions(+), 33 deletions(-) === applying patch ./v5-0004-Modify-the-ExecInitPartitionInfo-function-to-cons.patch patching file src/backend/executor/execPartition.c [cf/5160 d3634a5aba] Modify the ExecInitPartitionInfo function to consider partitioned indexes that are potentially processed by REINDEX CONCURRENTLY as arbiters as well. Author: nkey Date: Sun Nov 24 14:55:13 2024 +0100 1 file changed, 107 insertions(+), 12 deletions(-)