[07:44:40.029](0.063s) # testing using transfer mode --clone # Checking port 19869 # Found port 19869 Name: old_node Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/archives Connection string: port=19869 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L Log file: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [07:44:40.057](0.029s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /Users/admin/pgsql/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 The files belonging to this database system will be owned by user "admin". 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: en_US.UTF-8 LC_NUMERIC: C LC_TIME: en_US.UTF-8 The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /Users/admin/pgsql/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 ... 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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata -l logfile start # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /Users/admin/pgsql/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 9541 [07:44:44.028](3.970s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [07:44:44.422](0.394s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [07:44:44.697](0.275s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [07:44:45.048](0.351s) ok 4 - created database with ASCII characters from 91 to 127 # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --dlpath=/Users/admin/pgsql/build/src/test/regress --bindir= --host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L --port=19869 --schedule=/Users/admin/pgsql/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/Users/admin/pgsql/src/test/regress --outputdir=/Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data [07:46:54.503](129.454s) not ok 5 - regression tests in old instance [07:46:54.527](0.024s) # Failed test 'regression tests in old instance' # at /Users/admin/pgsql/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [07:46:54.527](0.000s) # ---------- command failed ---------- [07:46:54.527](0.000s) # /Users/admin/pgsql/build/src/test/regress/pg_regress --dlpath=/Users/admin/pgsql/build/src/test/regress --bindir= --host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L --port=19869 --schedule=/Users/admin/pgsql/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/Users/admin/pgsql/src/test/regress --outputdir=/Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data [07:46:54.527](0.000s) # -------------- stdout -------------- [07:46:54.527](0.000s) # # using postmaster on /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L, port 19869 # ok 1 - test_setup 1959 ms # # parallel group (20 tests): char int4 int2 varchar boolean int8 oid float4 name txid pg_lsn text enum float8 money regproc bit uuid numeric rangetypes # ok 2 + boolean 414 ms # ok 3 + char 268 ms # ok 4 + name 540 ms # ok 5 + varchar 392 ms # ok 6 + text 702 ms # ok 7 + int2 351 ms # ok 8 + int4 319 ms # ok 9 + int8 404 ms # ok 10 + oid 401 ms # ok 11 + float4 423 ms # ok 12 + float8 908 ms # ok 13 + bit 947 ms # ok 14 + numeric 2612 ms # ok 15 + txid 486 ms # ok 16 + uuid 1323 ms # ok 17 + enum 669 ms # ok 18 + money 869 ms # ok 19 + rangetypes 2640 ms # ok 20 + pg_lsn 482 ms # ok 21 + regproc 838 ms # # parallel group (20 tests): lseg point line time md5 timetz path macaddr8 date numerology interval circle macaddr timestamptz inet timestamp strings polygon box multirangetypes # ok 22 + strings 1667 ms # ok 23 + md5 645 ms # ok 24 + numerology 1008 ms # ok 25 + point 498 ms # ok 26 + lseg 469 ms # ok 27 + line 507 ms [07:46:54.528](0.000s) # ... 206 lines omitted ... [07:46:54.528](0.000s) # ok 219 + partition_merge 3717 ms # ok 220 + partition_split 3279 ms # ok 221 + partition_join 5814 ms # ok 222 + partition_prune 5543 ms # ok 223 + reloptions 314 ms # ok 224 + hash_part 306 ms # ok 225 + indexing 7907 ms # ok 226 + partition_aggregate 3677 ms # ok 227 + partition_info 316 ms # ok 228 + tuplesort 4522 ms # ok 229 + explain 457 ms # ok 230 + memoize 1292 ms # ok 231 + stats 5947 ms # ok 232 + predicate 774 ms # ok 233 + numa 486 ms # ok 234 + eager_aggregate 1975 ms # ok 235 + graph_table_rls 828 ms # ok 236 + planner_est 253 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 593 ms # ok 238 + compression_lz4 530 ms # ok 239 + compression_pglz 223 ms # ok 240 + cluster 2423 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1045 ms # ok 242 + event_trigger 1087 ms # ok 243 - event_trigger_login 113 ms # ok 244 - fast_default 889 ms # ok 245 - tablespace 2525 ms # 1..245 [07:46:54.528](0.000s) # -------------- stderr -------------- [07:46:54.528](0.000s) # # diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out # # --- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:02 # # +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-05-03 07:45:57 # # @@ -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 "/Users/admin/pgsql/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 "/Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out". [07:46:54.528](0.000s) # ------------------------------------ # Checking port 19870 # Found port 19870 Name: new_node Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/archives Connection string: port=19870 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L Log file: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [07:46:54.570](0.042s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /Users/admin/pgsql/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 The files belonging to this database system will be owned by user "admin". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: C LC_TIME: en_US.UTF-8 The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /Users/admin/pgsql/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 ... 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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata -l logfile start # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /Users/admin/pgsql/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 19684 # Checking port 19871 # Found port 19871 Name: dst_node Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/archives Connection string: port=19871 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L Log file: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [07:46:57.964](3.395s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=19869 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L dbname='postgres' --file /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_V0Fv/dump1.sql [07:47:07.420](9.456s) ok 7 - dump before running pg_upgrade ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin/does/not/exist/ --new-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --socketdir /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L --old-port 19869 --new-port 19870 --clone --check [07:47:08.157](0.737s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [07:47:08.158](0.001s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [07:47:08.158](0.000s) ok 10 - pg_upgrade_output.d/ not removed after pg_upgrade failure # Running: pg_upgrade --no-sync --old-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --new-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --socketdir /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L --old-port 19869 --new-port 19870 --clone --check [07:47:09.703](1.545s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [07:47:09.704](0.001s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [07:47:09.704](0.000s) ok 13 - invalid database causes failure stderr /(?^:^$)/ ### Starting node "old_node" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /Users/admin/pgsql/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 21072 ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --new-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --socketdir /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L --old-port 19869 --new-port 19870 --clone --check [07:47:14.907](5.203s) ok 14 - run of pg_upgrade --check for new instance [07:47:14.908](0.001s) ok 15 - pg_upgrade_output.d/ removed after pg_upgrade --check success # Running: pg_upgrade --no-sync --old-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --new-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --socketdir /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L --old-port 19869 --new-port 19870 --clone [07:47:56.746](41.838s) ok 16 - run of pg_upgrade for new instance [07:47:56.749](0.003s) ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success ### Starting node "new_node" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --log /Users/admin/pgsql/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 23745 [07:47:57.486](0.737s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=19870 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/zIDGacnI5L dbname='postgres' --file /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_V0Fv/dump2.sql [07:48:10.393](12.907s) ok 19 - dump after running pg_upgrade [07:48:11.793](1.400s) ok 20 - old and new dumps match after pg_upgrade [07:48:11.795](0.002s) 1..20 ### Stopping node "new_node" using mode immediate # Running: pg_ctl --pgdata /Users/admin/pgsql/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:48:11.958](0.163s) # Looks like you failed 1 test of 20.