[07:44:48.543](0.029s) # testing using transfer mode --copy # Checking port 11485 # Found port 11485 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=11485 host=/tmp/bPZL8H6a58 Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [07:44:48.549](0.005s) # 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 25411 [07:44:51.201](2.653s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [07:44:51.359](0.157s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [07:44:51.472](0.113s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [07:44:51.525](0.053s) 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/bPZL8H6a58 --port=11485 --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:46:21.028](89.503s) not ok 5 - regression tests in old instance [07:46:21.028](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:46:21.028](0.000s) # ---------- command failed ---------- [07:46:21.028](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/bPZL8H6a58 --port=11485 --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:46:21.028](0.000s) # -------------- stdout -------------- [07:46:21.029](0.000s) # # using postmaster on /tmp/bPZL8H6a58, port 11485 # ok 1 - test_setup 528 ms # # parallel group (20 tests): char name varchar oid int2 txid int4 pg_lsn boolean text float4 int8 money regproc float8 enum bit uuid numeric rangetypes # ok 2 + boolean 340 ms # ok 3 + char 147 ms # ok 4 + name 175 ms # ok 5 + varchar 196 ms # ok 6 + text 355 ms # ok 7 + int2 239 ms # ok 8 + int4 271 ms # ok 9 + int8 423 ms # ok 10 + oid 224 ms # ok 11 + float4 398 ms # ok 12 + float8 488 ms # ok 13 + bit 639 ms # ok 14 + numeric 1758 ms # ok 15 + txid 230 ms # ok 16 + uuid 715 ms # ok 17 + enum 553 ms # ok 18 + money 451 ms # ok 19 + rangetypes 1966 ms # ok 20 + pg_lsn 225 ms # ok 21 + regproc 411 ms # # parallel group (20 tests): md5 lseg path time line circle macaddr numerology point timetz macaddr8 date inet timestamp interval timestamptz polygon strings box multirangetypes # ok 22 + strings 1217 ms # ok 23 + md5 87 ms # ok 24 + numerology 324 ms # ok 25 + point 324 ms # ok 26 + lseg 86 ms # ok 27 + line 187 ms [07:46:21.029](0.000s) # ... 206 lines omitted ... [07:46:21.029](0.000s) # ok 219 + partition_merge 2968 ms # ok 220 + partition_split 3615 ms # ok 221 + partition_join 4424 ms # ok 222 + partition_prune 4541 ms # ok 223 + reloptions 388 ms # ok 224 + hash_part 235 ms # ok 225 + indexing 4962 ms # ok 226 + partition_aggregate 3779 ms # ok 227 + partition_info 716 ms # ok 228 + tuplesort 4383 ms # ok 229 + explain 486 ms # ok 230 + memoize 1269 ms # ok 231 + stats 3281 ms # ok 232 + predicate 613 ms # ok 233 + numa 358 ms # ok 234 + eager_aggregate 2067 ms # ok 235 + graph_table_rls 875 ms # ok 236 + planner_est 206 ms # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster # ok 237 + compression 364 ms # ok 238 + compression_lz4 425 ms # ok 239 + compression_pglz 49 ms # ok 240 + cluster 1098 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1854 ms # ok 242 + event_trigger 1985 ms # ok 243 - event_trigger_login 143 ms # ok 244 - fast_default 1158 ms # ok 245 - tablespace 2038 ms # 1..245 [07:46:21.029](0.000s) # -------------- stderr -------------- [07:46:21.029](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.065096072 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-05-03 07:45:38.424372684 +0000 # # @@ -1154,9 +1154,10 @@ # # f2 | bigint | | | | plain | | # # f3 | bigint | | | generated always as (f2 * 2) | plain | | # # Partition key: RANGE (f3) # # -Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'), # # - gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'), # # - gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100') # # +Partitions: # # + gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30') # # + gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50') # # + gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100') # # # # INSERT INTO gtest_part_key1(f2) VALUES (9); -- error # # ERROR: no partition of relation "gtest_part_key1" found for row # # 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:46:21.029](0.000s) # ------------------------------------ # Checking port 11486 # Found port 11486 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=11486 host=/tmp/bPZL8H6a58 Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [07:46:21.036](0.007s) # 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 37815 # Checking port 11487 # Found port 11487 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=11487 host=/tmp/bPZL8H6a58 Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [07:46:23.550](2.514s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=11485 host=/tmp/bPZL8H6a58 dbname='postgres' --file /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_JRge/dump1.sql [07:46:29.495](5.945s) 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/bPZL8H6a58 --old-port 11485 --new-port 11486 --copy --check [07:46:29.863](0.368s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [07:46:29.864](0.000s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [07:46:29.864](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/bPZL8H6a58 --old-port 11485 --new-port 11486 --copy --check [07:46:30.376](0.512s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [07:46:30.376](0.000s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [07:46:30.376](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 39356 ### 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/bPZL8H6a58 --old-port 11485 --new-port 11486 --copy --check [07:46:33.218](2.842s) ok 14 - run of pg_upgrade --check for new instance [07:46:33.219](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/bPZL8H6a58 --old-port 11485 --new-port 11486 --copy [07:46:57.347](24.128s) ok 16 - run of pg_upgrade for new instance [07:46:57.347](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 43319 [07:46:57.534](0.186s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=11486 host=/tmp/bPZL8H6a58 dbname='postgres' --file /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_JRge/dump2.sql [07:47:07.398](9.865s) ok 19 - dump after running pg_upgrade [07:47:07.747](0.349s) ok 20 - old and new dumps match after pg_upgrade [07:47:07.747](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:47:07.858](0.111s) # Looks like you failed 1 test of 20.