[05:25:47.744](0.016s) # testing using transfer mode --link # Checking port 13326 # Found port 13326 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=13326 host=/tmp/sHuG8jvXDU Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [05:25:47.768](0.024s) # 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 debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress 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 /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 ... 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 6343 [05:25:49.922](2.154s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [05:25:49.956](0.034s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [05:25:50.022](0.066s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [05:25:50.155](0.134s) 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/sHuG8jvXDU --port=13326 --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 [05:30:46.936](296.780s) not ok 5 - regression tests in old instance [05:30:46.936](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. [05:30:46.936](0.000s) # ---------- command failed ---------- [05:30:46.937](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/sHuG8jvXDU --port=13326 --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 [05:30:46.937](0.000s) # -------------- stdout -------------- [05:30:46.937](0.000s) # # using postmaster on /tmp/sHuG8jvXDU, port 13326 # ok 1 - test_setup 1218 ms # # parallel group (20 tests): pg_lsn varchar char float4 txid name oid uuid text int2 regproc boolean enum int4 money bit float8 int8 rangetypes numeric # ok 2 + boolean 1209 ms # ok 3 + char 330 ms # ok 4 + name 459 ms # ok 5 + varchar 175 ms # ok 6 + text 723 ms # ok 7 + int2 864 ms # ok 8 + int4 2561 ms # ok 9 + int8 4429 ms # ok 10 + oid 542 ms # ok 11 + float4 331 ms # ok 12 + float8 3514 ms # ok 13 + bit 2829 ms # ok 14 + numeric 7919 ms # ok 15 + txid 396 ms # ok 16 + uuid 682 ms # ok 17 + enum 1397 ms # ok 18 + money 2741 ms # ok 19 + rangetypes 5674 ms # ok 20 + pg_lsn 129 ms # ok 21 + regproc 930 ms # # parallel group (20 tests): path lseg numerology macaddr macaddr8 line md5 point inet timetz polygon box time circle timestamp date interval timestamptz strings multirangetypes # ok 22 + strings 11347 ms # ok 23 + md5 646 ms # ok 24 + numerology 263 ms # ok 25 + point 686 ms # ok 26 + lseg 193 ms # ok 27 + line 539 ms [05:30:46.937](0.000s) # ... 207 lines omitted ... [05:30:46.937](0.000s) # ok 220 + partition_merge 10591 ms # ok 221 + partition_split 11461 ms # ok 222 + partition_join 9370 ms # ok 223 + partition_prune 26514 ms # ok 224 + reloptions 1572 ms # ok 225 + hash_part 676 ms # ok 226 + indexing 25997 ms # ok 227 + partition_aggregate 2921 ms # ok 228 + partition_info 3633 ms # ok 229 + tuplesort 5740 ms # ok 230 + explain 1105 ms # ok 231 + memoize 1879 ms # ok 232 + stats 11513 ms # ok 233 + predicate 1750 ms # ok 234 + numa 173 ms # ok 235 + eager_aggregate 2279 ms # ok 236 + graph_table_rls 1399 ms # ok 237 + planner_est 638 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 238 + compression 2246 ms # ok 239 + compression_lz4 1937 ms # ok 240 + compression_pglz 21 ms # ok 241 + cluster 2911 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 774 ms # ok 243 + event_trigger 1803 ms # ok 244 - event_trigger_login 204 ms # ok 245 - fast_default 1993 ms # ok 246 - tablespace 5815 ms # 1..246 [05:30:46.937](0.000s) # -------------- stderr -------------- [05:30:46.937](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-05-06 05:24:51.848051000 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-05-06 05:27:36.757600000 +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:30:46.938](0.000s) # ... 16 lines omitted ... [05:30:46.938](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 "/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". [05:30:46.938](0.000s) # ------------------------------------ # Checking port 13327 # Found port 13327 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=13327 host=/tmp/sHuG8jvXDU Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [05:30:46.942](0.004s) # 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 debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress 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 /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 ... 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 8658 # Checking port 13328 # Found port 13328 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=13328 host=/tmp/sHuG8jvXDU Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [05:30:48.567](1.625s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=13326 host=/tmp/sHuG8jvXDU dbname='postgres' --file /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_qMkc/dump1.sql [05:31:07.003](18.436s) 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/sHuG8jvXDU --old-port 13326 --new-port 13327 --link --check [05:31:07.166](0.163s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [05:31:07.166](0.000s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [05:31:07.166](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/sHuG8jvXDU --old-port 13326 --new-port 13327 --link --check [05:31:07.662](0.496s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [05:31:07.663](0.001s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [05:31:07.663](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 13917 ### 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/sHuG8jvXDU --old-port 13326 --new-port 13327 --link --check [05:31:09.768](2.105s) ok 14 - run of pg_upgrade --check for new instance [05:31:09.769](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/sHuG8jvXDU --old-port 13326 --new-port 13327 --link [05:31:51.752](41.984s) ok 16 - run of pg_upgrade for new instance [05:31:51.753](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 27774 [05:31:51.897](0.145s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=13327 host=/tmp/sHuG8jvXDU dbname='postgres' --file /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_qMkc/dump2.sql [05:32:17.919](26.022s) ok 19 - dump after running pg_upgrade [05:32:18.142](0.223s) ok 20 - old and new dumps match after pg_upgrade [05:32:18.143](0.000s) 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" [05:32:18.250](0.107s) # Looks like you failed 1 test of 20.