[07:14:35.318](0.026s) # testing using transfer mode --copy # Checking port 11425 # Found port 11425 Name: old_node Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/archives Connection string: port=11425 host=/tmp/KyrwCjV4YV Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [07:14:35.326](0.008s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --auth trust --wal-segsize 1 --allow-group-access --encoding UTF-8 --lc-collate C --lc-ctype C --locale-provider builtin --builtin-locale C.UTF-8 -c io_method=io_uring The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: builtin default collation: C.UTF-8 LC_COLLATE: C LC_CTYPE: C LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C LC_TIME: C.UTF-8 The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata ### Starting node "old_node" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log --options --cluster-name=old_node start waiting for server to start.... done server started # Postmaster PID for node "old_node" is 22551 [07:14:38.013](2.687s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [07:14:38.175](0.163s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [07:14:38.259](0.083s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [07:14:38.343](0.085s) ok 4 - created database with ASCII characters from 91 to 127 # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/KyrwCjV4YV --port=11425 --schedule=/tmp/cirrus-ci-build/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/tmp/cirrus-ci-build/src/test/regress --outputdir=/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data [07:16:14.108](95.764s) not ok 5 - regression tests in old instance [07:16:14.108](0.000s) # Failed test 'regression tests in old instance' # at /tmp/cirrus-ci-build/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [07:16:14.108](0.000s) # ---------- command failed ---------- [07:16:14.109](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/KyrwCjV4YV --port=11425 --schedule=/tmp/cirrus-ci-build/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/tmp/cirrus-ci-build/src/test/regress --outputdir=/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data [07:16:14.109](0.000s) # -------------- stdout -------------- [07:16:14.109](0.000s) # # using postmaster on /tmp/KyrwCjV4YV, port 11425 # ok 1 - test_setup 1366 ms # # parallel group (20 tests): oid char varchar text pg_lsn int2 name txid int4 boolean float4 float8 money regproc int8 bit enum uuid numeric rangetypes # ok 2 + boolean 272 ms # ok 3 + char 178 ms # ok 4 + name 221 ms # ok 5 + varchar 177 ms # ok 6 + text 190 ms # ok 7 + int2 203 ms # ok 8 + int4 235 ms # ok 9 + int8 331 ms # ok 10 + oid 156 ms # ok 11 + float4 278 ms # ok 12 + float8 291 ms # ok 13 + bit 398 ms # ok 14 + numeric 1449 ms # ok 15 + txid 215 ms # ok 16 + uuid 485 ms # ok 17 + enum 455 ms # ok 18 + money 280 ms # ok 19 + rangetypes 2132 ms # ok 20 + pg_lsn 155 ms # ok 21 + regproc 277 ms # # parallel group (20 tests): lseg md5 circle path line point time macaddr timetz macaddr8 numerology inet date interval timestamp timestamptz polygon strings box multirangetypes # ok 22 + strings 1053 ms # ok 23 + md5 183 ms # ok 24 + numerology 345 ms # ok 25 + point 257 ms # ok 26 + lseg 180 ms # ok 27 + line 226 ms [07:16:14.109](0.000s) # ... 206 lines omitted ... [07:16:14.109](0.000s) # ok 219 + partition_merge 3840 ms # ok 220 + partition_split 4287 ms # ok 221 + partition_join 5438 ms # ok 222 + partition_prune 5381 ms # ok 223 + reloptions 531 ms # ok 224 + hash_part 329 ms # ok 225 + indexing 6152 ms # ok 226 + partition_aggregate 4139 ms # ok 227 + partition_info 678 ms # ok 228 + tuplesort 5263 ms # ok 229 + explain 663 ms # ok 230 + memoize 1765 ms # ok 231 + stats 4649 ms # ok 232 + predicate 757 ms # ok 233 + numa 363 ms # ok 234 + eager_aggregate 2599 ms # ok 235 + graph_table_rls 940 ms # ok 236 + planner_est 252 ms # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster # ok 237 + compression 399 ms # ok 238 + compression_lz4 450 ms # ok 239 + compression_pglz 54 ms # ok 240 + cluster 1048 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1503 ms # ok 242 + event_trigger 1776 ms # ok 243 - event_trigger_login 188 ms # ok 244 - fast_default 1126 ms # ok 245 - tablespace 2184 ms # 1..245 [07:16:14.109](0.000s) # -------------- stderr -------------- [07:16:14.109](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:09.594871958 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:14:54.484260627 +0000 # # @@ -1099,8 +1099,6 @@ # # FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' # # SET name = 'one^3' # # WHERE id = 1; # # -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # -- test inserts violating CHECK constraints # # ALTER TABLE for_portion_of_test2 # # @@ -1115,12 +1113,13 @@ # # SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; # # id | valid_at | name # # ----+-------------------------+------- # # - 1 | [2000-01-01,2010-01-01) | one # # + 1 | [2000-01-01,2001-01-11) | one^3 # # + 1 | [2001-01-11,2010-01-01) | one # # 1 | [2010-01-01,2010-01-05) | one^1 # # 1 | [2010-01-05,2010-01-07) | one # # 1 | [2010-01-07,2010-01-09) | one^2 # # 1 | [2010-01-09,2020-01-01) | one # # -(5 rows) # # +(6 rows) # # # # -- DELETE works: # # DELETE FROM for_portion_of_test2 # # @@ -1222,8 +1221,6 @@ # # FOR PORTION OF valid_at ('{[2000-01-01,2001-01-11)}') # # SET name = 'one^3' # # WHERE id = 1; # # -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, {[2000-01-01,2001-01-11)}, one^3). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # -- test inserts violating CHECK constraints # # ALTER TABLE for_portion_of_test2 # # @@ -1233,14 +1230,15 @@ # # SET name = 'one^3' # # WHERE id = 1; # # ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, {[2000-01-01,2001-01-01),[2002-02-02,2010-01-07),[2010-01-09,202..., one). # # +DETAIL: Failing row contains (1, {[2002-02-02,2010-01-07),[2010-01-09,2020-01-01)}, one). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; # # id | valid_at | name # # ----+---------------------------------------------------+------- # # - 1 | {[2000-01-01,2010-01-07),[2010-01-09,2020-01-01)} | one # # + 1 | {[2000-01-01,2001-01-11)} | one^3 # # + 1 | {[2001-01-11,2010-01-07),[2010-01-09,2020-01-01)} | one # # 1 | {[2010-01-07,2010-01-09)} | one^2 # # -(2 rows) # # +(3 rows) # # # # -- DELETE works: # # DELETE FROM for_portion_of_test2 # # 1 of 245 tests failed. # # The differences that caused some tests to fail can be viewed in the file "/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.diffs". # # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out". [07:16:14.109](0.000s) # ------------------------------------ # Checking port 11426 # Found port 11426 Name: new_node Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/archives Connection string: port=11426 host=/tmp/KyrwCjV4YV Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [07:16:14.118](0.009s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --auth trust --wal-segsize 1 --allow-group-access --encoding SQL_ASCII --locale-provider libc -c io_method=io_uring The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: C.UTF-8 LC_CTYPE: C.UTF-8 LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C LC_TIME: C.UTF-8 The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata ### Restarting node "old_node" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "old_node" is 34848 # Checking port 11427 # Found port 11427 Name: dst_node Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/archives Connection string: port=11427 host=/tmp/KyrwCjV4YV Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [07:16:16.743](2.625s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=11425 host=/tmp/KyrwCjV4YV dbname='postgres' --file /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_8mDL/dump1.sql [07:16:22.714](5.971s) ok 7 - dump before running pg_upgrade ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "old_node" # Running: pg_upgrade --no-sync --old-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/does/not/exist/ --new-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/KyrwCjV4YV --old-port 11425 --new-port 11426 --copy --check [07:16:23.076](0.362s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [07:16:23.081](0.005s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [07:16:23.081](0.000s) ok 10 - pg_upgrade_output.d/ not removed after pg_upgrade failure # Running: pg_upgrade --no-sync --old-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --new-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/KyrwCjV4YV --old-port 11425 --new-port 11426 --copy --check [07:16:23.594](0.513s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [07:16:23.595](0.000s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [07:16:23.595](0.000s) ok 13 - invalid database causes failure stderr /(?^:^$)/ ### Starting node "old_node" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log --options --cluster-name=old_node start waiting for server to start.... done server started # Postmaster PID for node "old_node" is 36434 ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "old_node" # Running: pg_upgrade --no-sync --old-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --new-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/KyrwCjV4YV --old-port 11425 --new-port 11426 --copy --check [07:16:26.525](2.930s) ok 14 - run of pg_upgrade --check for new instance [07:16:26.525](0.000s) ok 15 - pg_upgrade_output.d/ removed after pg_upgrade --check success # Running: pg_upgrade --no-sync --old-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --new-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/KyrwCjV4YV --old-port 11425 --new-port 11426 --copy [07:16:48.428](21.903s) ok 16 - run of pg_upgrade for new instance [07:16:48.428](0.000s) ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success ### Starting node "new_node" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log --options --cluster-name=new_node start waiting for server to start.... done server started # Postmaster PID for node "new_node" is 40139 [07:16:48.869](0.441s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=11426 host=/tmp/KyrwCjV4YV dbname='postgres' --file /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_8mDL/dump2.sql [07:16:56.752](7.883s) ok 19 - dump after running pg_upgrade [07:16:57.759](1.006s) ok 20 - old and new dumps match after pg_upgrade [07:16:57.760](0.001s) 1..20 ### Stopping node "new_node" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "new_node" [07:16:57.906](0.147s) # Looks like you failed 1 test of 20.