[05:27:24.609](0.048s) # testing using transfer mode --copy # Checking port 14840 # Found port 14840 Name: old_node Version: 19devel Data directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/backup Archive directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/archives Connection string: port=14840 host=/tmp/nKWzbXIh6z Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [05:27:24.653](0.044s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /home/postgres/postgres/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 "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: 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 /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata -l logfile start # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /home/postgres/postgres/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 44576 [05:27:30.209](5.556s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [05:27:31.175](0.966s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [05:27:31.422](0.248s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [05:27:31.511](0.089s) ok 4 - created database with ASCII characters from 91 to 127 # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/nKWzbXIh6z --port=14840 --schedule=/home/postgres/postgres/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/home/postgres/postgres/src/test/regress --outputdir=/home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data [05:29:49.401](137.889s) not ok 5 - regression tests in old instance [05:29:49.402](0.001s) # Failed test 'regression tests in old instance' # at /home/postgres/postgres/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [05:29:49.404](0.002s) # ---------- command failed ---------- [05:29:49.404](0.000s) # /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/nKWzbXIh6z --port=14840 --schedule=/home/postgres/postgres/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/home/postgres/postgres/src/test/regress --outputdir=/home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data [05:29:49.404](0.000s) # -------------- stdout -------------- [05:29:49.405](0.000s) # # using postmaster on /tmp/nKWzbXIh6z, port 14840 # ok 1 - test_setup 1004 ms # # parallel group (20 tests): int8 varchar char int4 name text int2 pg_lsn money enum oid txid float8 regproc bit float4 boolean uuid rangetypes numeric # ok 2 + boolean 1424 ms # ok 3 + char 257 ms # ok 4 + name 277 ms # ok 5 + varchar 177 ms # ok 6 + text 402 ms # ok 7 + int2 457 ms # ok 8 + int4 266 ms # ok 9 + int8 176 ms # ok 10 + oid 970 ms # ok 11 + float4 1359 ms # ok 12 + float8 1183 ms # ok 13 + bit 1347 ms # ok 14 + numeric 4289 ms # ok 15 + txid 1072 ms # ok 16 + uuid 1533 ms # ok 17 + enum 949 ms # ok 18 + money 761 ms # ok 19 + rangetypes 3953 ms # ok 20 + pg_lsn 472 ms # ok 21 + regproc 1189 ms # # parallel group (20 tests): md5 lseg time path point macaddr line circle numerology timetz interval box date timestamp macaddr8 inet strings polygon timestamptz multirangetypes # ok 22 + strings 1248 ms # ok 23 + md5 114 ms # ok 24 + numerology 484 ms # ok 25 + point 203 ms # ok 26 + lseg 156 ms # ok 27 + line 399 ms [05:29:49.405](0.000s) # ... 207 lines omitted ... [05:29:49.405](0.000s) # ok 220 + partition_merge 8153 ms # ok 221 + partition_split 9072 ms # ok 222 + partition_join 10776 ms # ok 223 + partition_prune 8989 ms # ok 224 + reloptions 1331 ms # ok 225 + hash_part 1413 ms # ok 226 + indexing 10740 ms # ok 227 + partition_aggregate 7641 ms # ok 228 + partition_info 1043 ms # ok 229 + tuplesort 8498 ms # ok 230 + explain 2743 ms # ok 231 + memoize 1564 ms # ok 232 + stats 7802 ms # ok 233 + predicate 2834 ms # ok 234 + numa 131 ms # ok 235 + eager_aggregate 4243 ms # ok 236 + graph_table_rls 2581 ms # ok 237 + planner_est 971 ms # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster # ok 238 + compression 897 ms # ok 239 + compression_lz4 944 ms # ok 240 + compression_pglz 77 ms # ok 241 + cluster 2684 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 1476 ms # ok 243 + event_trigger 1764 ms # ok 244 - event_trigger_login 157 ms # ok 245 - fast_default 1382 ms # ok 246 - tablespace 2644 ms # 1..246 [05:29:49.405](0.000s) # -------------- stderr -------------- [05:29:49.405](0.000s) # # diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out # # --- /home/postgres/postgres/src/test/regress/expected/goo.out Wed May 6 05:25:03 2026 # # +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Wed May 6 05:28:38 2026 # # @@ -139,8 +139,8 @@ # # JOIN dim3 ON fact.dim3_id = dim3.id # # JOIN dim4 ON fact.dim4_id = dim4.id # # WHERE dim1.id < 5; # # - QUERY PLAN # # ---------------------------------------------------------------------- # # + QUERY PLAN # # +--------------------------------------------------------------------------- # # Aggregate # # -> Nested Loop # # Join Filter: (fact.dim4_id = dim4.id) # # @@ -149,15 +149,15 @@ # # -> Seq Scan on dim3 # # -> Hash # # -> Hash Join # # - Hash Cond: (fact.dim1_id = dim1.id) # # - -> Hash Join # # - Hash Cond: (fact.dim2_id = dim2.id) # # - -> Seq Scan on fact # # - -> Hash # # - -> Seq Scan on dim2 # # + Hash Cond: (dim2.id = fact.dim2_id) # # + -> Seq Scan on dim2 # # -> Hash # # - -> Seq Scan on dim1 # # - Filter: (id < 5) # # + -> Hash Join [05:29:49.406](0.000s) # ... 16 lines omitted ... [05:29:49.406](0.000s) # # Aggregate # # -> Hash Join # # Hash Cond: (t2.a = t1.a) # # - -> Nested Loop # # - -> Hash Join # # - Hash Cond: (t6.e = t5.f) # # - -> Seq Scan on t6 # # - -> Hash # # - -> Seq Scan on t5 # # - Filter: (d < 3) # # - -> Seq Scan on t2 # # + -> Seq Scan on t2 # # -> Hash # # - -> Seq Scan on t1 # # - Filter: (a < 5) # # + -> Nested Loop # # + -> Hash Join # # + Hash Cond: (t6.e = t5.f) # # + -> Seq Scan on t6 # # + -> Hash # # + -> Seq Scan on t5 # # + Filter: (d < 3) # # + -> Seq Scan on t1 # # + Filter: (a < 5) # # (14 rows) # # # # -- # # 1 of 246 tests failed. # # The differences that caused some tests to fail can be viewed in the file "/home/postgres/postgres/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 "/home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out". [05:29:49.406](0.000s) # ------------------------------------ # Checking port 14841 # Found port 14841 Name: new_node Version: 19devel Data directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/backup Archive directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/archives Connection string: port=14841 host=/tmp/nKWzbXIh6z Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [05:29:49.417](0.011s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /home/postgres/postgres/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 "postgres". 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 /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata -l logfile start # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /home/postgres/postgres/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 18758 # Checking port 14842 # Found port 14842 Name: dst_node Version: 19devel Data directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/backup Archive directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/archives Connection string: port=14842 host=/tmp/nKWzbXIh6z Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [05:29:54.786](5.369s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=14840 host=/tmp/nKWzbXIh6z dbname='postgres' --file /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_rCKc/dump1.sql [05:30:14.592](19.806s) ok 7 - dump before running pg_upgrade ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/does/not/exist/ --new-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/nKWzbXIh6z --old-port 14840 --new-port 14841 --copy --check [05:30:15.363](0.771s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [05:30:15.364](0.001s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [05:30:15.364](0.000s) ok 10 - pg_upgrade_output.d/ not removed after pg_upgrade failure # Running: pg_upgrade --no-sync --old-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --new-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/nKWzbXIh6z --old-port 14840 --new-port 14841 --copy --check [05:30:16.422](1.058s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [05:30:16.422](0.001s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [05:30:16.423](0.001s) ok 13 - invalid database causes failure stderr /(?^:^$)/ ### Starting node "old_node" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /home/postgres/postgres/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 67880 ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --new-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/nKWzbXIh6z --old-port 14840 --new-port 14841 --copy --check [05:30:21.444](5.021s) ok 14 - run of pg_upgrade --check for new instance [05:30:21.444](0.001s) ok 15 - pg_upgrade_output.d/ removed after pg_upgrade --check success # Running: pg_upgrade --no-sync --old-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --new-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/nKWzbXIh6z --old-port 14840 --new-port 14841 --copy [05:31:18.704](57.259s) ok 16 - run of pg_upgrade for new instance [05:31:18.704](0.000s) ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success ### Starting node "new_node" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --log /home/postgres/postgres/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 88954 [05:31:18.928](0.224s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=14841 host=/tmp/nKWzbXIh6z dbname='postgres' --file /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_rCKc/dump2.sql [05:31:35.702](16.774s) ok 19 - dump after running pg_upgrade [05:31:37.605](1.903s) ok 20 - old and new dumps match after pg_upgrade [05:31:37.607](0.001s) 1..20 ### Stopping node "new_node" using mode immediate # Running: pg_ctl --pgdata /home/postgres/postgres/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" [05:31:37.771](0.164s) # Looks like you failed 1 test of 20.