[05:26:31.720](0.034s) # testing using transfer mode --copy # Checking port 30399 # Found port 30399 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=30399 host=/tmp/gn56d7nsNW Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [05:26:31.733](0.013s) # 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: C LC_NUMERIC: C LC_TIME: C 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 ... 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 8942 [05:26:37.681](5.947s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [05:26:37.935](0.255s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [05:26:38.128](0.193s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [05:26:38.195](0.066s) 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/gn56d7nsNW --port=30399 --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:28:51.527](133.332s) not ok 5 - regression tests in old instance [05:28:51.528](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:28:51.528](0.000s) # ---------- command failed ---------- [05:28:51.528](0.000s) # /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/gn56d7nsNW --port=30399 --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:28:51.528](0.000s) # -------------- stdout -------------- [05:28:51.529](0.000s) # # using postmaster on /tmp/gn56d7nsNW, port 30399 # ok 1 - test_setup 816 ms # # parallel group (20 tests): txid text int2 int4 name money float8 boolean int8 varchar char regproc oid pg_lsn uuid float4 enum bit rangetypes numeric # ok 2 + boolean 420 ms # ok 3 + char 472 ms # ok 4 + name 337 ms # ok 5 + varchar 456 ms # ok 6 + text 246 ms # ok 7 + int2 290 ms # ok 8 + int4 317 ms # ok 9 + int8 430 ms # ok 10 + oid 520 ms # ok 11 + float4 779 ms # ok 12 + float8 415 ms # ok 13 + bit 814 ms # ok 14 + numeric 2312 ms # ok 15 + txid 215 ms # ok 16 + uuid 757 ms # ok 17 + enum 802 ms # ok 18 + money 352 ms # ok 19 + rangetypes 1219 ms # ok 20 + pg_lsn 518 ms # ok 21 + regproc 505 ms # # parallel group (20 tests): lseg md5 line timetz path circle inet time numerology date interval point macaddr box timestamp macaddr8 polygon timestamptz strings multirangetypes # ok 22 + strings 2359 ms # ok 23 + md5 280 ms # ok 24 + numerology 842 ms # ok 25 + point 1032 ms # ok 26 + lseg 23 ms # ok 27 + line 419 ms [05:28:51.529](0.000s) # ... 207 lines omitted ... [05:28:51.529](0.000s) # ok 220 + partition_merge 6630 ms # ok 221 + partition_split 9929 ms # ok 222 + partition_join 10730 ms # ok 223 + partition_prune 10102 ms # ok 224 + reloptions 677 ms # ok 225 + hash_part 590 ms # ok 226 + indexing 11365 ms # ok 227 + partition_aggregate 4778 ms # ok 228 + partition_info 321 ms # ok 229 + tuplesort 7105 ms # ok 230 + explain 456 ms # ok 231 + memoize 1181 ms # ok 232 + stats 4617 ms # ok 233 + predicate 1134 ms # ok 234 + numa 132 ms # ok 235 + eager_aggregate 2728 ms # ok 236 + graph_table_rls 1386 ms # ok 237 + planner_est 210 ms # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster # ok 238 + compression 167 ms # ok 239 + compression_lz4 1482 ms # ok 240 + compression_pglz 36 ms # ok 241 + cluster 1846 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 1050 ms # ok 243 + event_trigger 1093 ms # ok 244 - event_trigger_login 81 ms # ok 245 - fast_default 1088 ms # ok 246 - tablespace 1900 ms # 1..246 [05:28:51.529](0.000s) # -------------- stderr -------------- [05:28:51.529](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 2026-05-06 05:25:08.216455613 +0000 # # +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-05-06 05:27:43.585999066 +0000 # # @@ -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:28:51.529](0.000s) # ... 16 lines omitted ... [05:28:51.529](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:28:51.529](0.000s) # ------------------------------------ # Checking port 30400 # Found port 30400 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=30400 host=/tmp/gn56d7nsNW Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [05:28:51.533](0.004s) # 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 locale "C". 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 ... 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 28158 # Checking port 30401 # Found port 30401 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=30401 host=/tmp/gn56d7nsNW Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [05:28:53.034](1.500s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=30399 host=/tmp/gn56d7nsNW dbname='postgres' --file /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_FoDr/dump1.sql [05:29:03.817](10.783s) 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/gn56d7nsNW --old-port 30399 --new-port 30400 --copy --check [05:29:04.742](0.925s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [05:29:04.743](0.001s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [05:29:04.743](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/gn56d7nsNW --old-port 30399 --new-port 30400 --copy --check [05:29:05.560](0.817s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [05:29:05.561](0.000s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [05:29:05.561](0.000s) 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 4767 ### 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/gn56d7nsNW --old-port 30399 --new-port 30400 --copy --check [05:29:09.990](4.429s) ok 14 - run of pg_upgrade --check for new instance [05:29:09.990](0.000s) 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/gn56d7nsNW --old-port 30399 --new-port 30400 --copy [05:29:37.283](27.293s) ok 16 - run of pg_upgrade for new instance [05:29:37.284](0.001s) 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 26972 [05:29:37.448](0.164s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=30400 host=/tmp/gn56d7nsNW dbname='postgres' --file /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_FoDr/dump2.sql [05:29:47.044](9.595s) ok 19 - dump after running pg_upgrade [05:29:47.785](0.741s) ok 20 - old and new dumps match after pg_upgrade [05:29:47.793](0.008s) 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:29:47.898](0.105s) # Looks like you failed 1 test of 20.