[05:28:00.554](0.081s) # testing using transfer mode --copy # Checking port 25576 # Found port 25576 Name: old_node Version: 19devel Data directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata Backup directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/backup Archive directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/archives Connection string: port=25576 host=C:/Windows/TEMP/fdGTCgrUFU Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_old_node.log [05:28:00.618](0.064s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata C:\cirrus\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 "SYSTEM". 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: English_United States.1252 LC_MONETARY: English_United States.1252 LC_NUMERIC: English_United States.1252 LC_TIME: English_United States.1252 The default text search configuration will be set to "english". Data page checksums are enabled. creating directory C:/cirrus/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 ... windows selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... Atlantic/Reykjavik 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 ^"C^:^\cirrus^\build^/testrun^/pg^_upgrade^/002^_pg^_upgrade^\data^/t^_002^_pg^_upgrade^_old^_node^_data^/pgdata^" -l logfile start # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\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 C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata --log C:\cirrus\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 2220 [05:28:09.858](9.240s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [05:28:10.456](0.598s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [05:28:11.106](0.651s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [05:28:11.485](0.379s) ok 4 - created database with ASCII characters from 91 to 127 # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/fdGTCgrUFU --port=25576 --schedule=C:/cirrus/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=C:/cirrus/src/test/regress --outputdir=C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data [05:31:49.175](217.690s) not ok 5 - regression tests in old instance [05:31:49.175](0.000s) # Failed test 'regression tests in old instance' # at C:/cirrus/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [05:31:49.175](0.000s) # ---------- command failed ---------- [05:31:49.176](0.000s) # C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/fdGTCgrUFU --port=25576 --schedule=C:/cirrus/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=C:/cirrus/src/test/regress --outputdir=C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data [05:31:49.176](0.001s) # -------------- stdout -------------- [05:31:49.177](0.001s) # # using postmaster on C:/Windows/TEMP/fdGTCgrUFU, port 25576 # ok 1 - test_setup 858 ms # # parallel group (20 tests): boolean oid name char varchar pg_lsn bit txid uuid regproc money float4 enum int2 int8 float8 text int4 rangetypes numeric # ok 2 + boolean 545 ms # ok 3 + char 1078 ms # ok 4 + name 751 ms # ok 5 + varchar 1421 ms # ok 6 + text 1696 ms # ok 7 + int2 1604 ms # ok 8 + int4 1695 ms # ok 9 + int8 1664 ms # ok 10 + oid 537 ms # ok 11 + float4 1592 ms # ok 12 + float8 1683 ms # ok 13 + bit 1434 ms # ok 14 + numeric 1961 ms # ok 15 + txid 1432 ms # ok 16 + uuid 1562 ms # ok 17 + enum 1584 ms # ok 18 + money 1578 ms # ok 19 + rangetypes 1916 ms # ok 20 + pg_lsn 1418 ms # ok 21 + regproc 1570 ms # # parallel group (20 tests): strings numerology line circle lseg box path time md5 timestamp date macaddr8 timestamptz timetz polygon multirangetypes macaddr point inet interval # ok 22 + strings 1231 ms # ok 23 + md5 1781 ms # ok 24 + numerology 1230 ms # ok 25 + point 3431 ms # ok 26 + lseg 1764 ms # ok 27 + line 1224 ms [05:31:49.177](0.000s) # ... 207 lines omitted ... [05:31:49.178](0.001s) # ok 220 + partition_merge 4024 ms # ok 221 + partition_split 3423 ms # ok 222 + partition_join 5319 ms # ok 223 + partition_prune 9280 ms # ok 224 + reloptions 1296 ms # ok 225 + hash_part 2301 ms # ok 226 + indexing 5552 ms # ok 227 + partition_aggregate 7340 ms # ok 228 + partition_info 4370 ms # ok 229 + tuplesort 5397 ms # ok 230 + explain 4658 ms # ok 231 + memoize 4441 ms # ok 232 + stats 7014 ms # ok 233 + predicate 4357 ms # ok 234 + numa 3772 ms # ok 235 + eager_aggregate 4664 ms # ok 236 + graph_table_rls 2871 ms # ok 237 + planner_est 2859 ms # # parallel group (4 tests): compression_lz4 compression_pglz compression cluster # ok 238 + compression 538 ms # ok 239 + compression_lz4 231 ms # ok 240 + compression_pglz 406 ms # ok 241 + cluster 1190 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 811 ms # ok 243 + event_trigger 962 ms # ok 244 - event_trigger_login 1098 ms # ok 245 - fast_default 961 ms # ok 246 - tablespace 1914 ms # 1..246 [05:31:49.179](0.001s) # -------------- stderr -------------- [05:31:49.180](0.001s) # # diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out # # --- C:/cirrus/src/test/regress/expected/goo.out 2026-05-06 05:24:59.138506000 +0000 # # +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-05-06 05:29:54.132679800 +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:31:49.180](0.001s) # ... 16 lines omitted ... [05:31:49.181](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 "C:/cirrus/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 "C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out". [05:31:49.181](0.000s) # ------------------------------------ # Checking port 25577 # Found port 25577 Name: new_node Version: 19devel Data directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata Backup directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/backup Archive directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/archives Connection string: port=25577 host=C:/Windows/TEMP/fdGTCgrUFU Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_new_node.log [05:31:49.213](0.032s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata C:\cirrus\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 "SYSTEM". This user must also own the server process. The database cluster will be initialized with locale "English_United States.1252". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory C:/cirrus/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 ... windows selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... Atlantic/Reykjavik 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 ^"C^:^\cirrus^\build^/testrun^/pg^_upgrade^/002^_pg^_upgrade^\data^/t^_002^_pg^_upgrade^_new^_node^_data^/pgdata^" -l logfile start # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\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 C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata --log C:\cirrus\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 8968 # Checking port 25578 # Found port 25578 Name: dst_node Version: 19devel Data directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_dst_node_data/pgdata Backup directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_dst_node_data/backup Archive directory: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_dst_node_data/archives Connection string: port=25578 host=C:/Windows/TEMP/fdGTCgrUFU Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_dst_node.log [05:31:54.223](5.009s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=25576 host=C:/Windows/TEMP/fdGTCgrUFU dbname='postgres' --file C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\tmp_test_NkAL/dump1.sql [05:32:01.603](7.380s) ok 7 - dump before running pg_upgrade ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata C:\cirrus\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 C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin/does/not/exist/ --new-bindir C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin --socketdir C:/Windows/TEMP/fdGTCgrUFU --old-port 25576 --new-port 25577 --copy --check [05:32:02.919](1.316s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [05:32:02.920](0.001s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [05:32:02.920](0.000s) ok 10 - pg_upgrade_output.d/ not removed after pg_upgrade failure # Running: pg_upgrade --no-sync --old-datadir C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin --new-bindir C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin --socketdir C:/Windows/TEMP/fdGTCgrUFU --old-port 25576 --new-port 25577 --copy --check [05:32:08.348](5.428s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [05:32:08.348](0.000s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [05:32:08.349](0.000s) ok 13 - invalid database causes failure stderr /(?^:^$)/ ### Starting node "old_node" # Running: pg_ctl --wait --pgdata C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata --log C:\cirrus\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 7548 ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata C:\cirrus\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 C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin --new-bindir C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin --socketdir C:/Windows/TEMP/fdGTCgrUFU --old-port 25576 --new-port 25577 --copy --check [05:32:16.479](8.131s) ok 14 - run of pg_upgrade --check for new instance [05:32:16.480](0.001s) ok 15 - pg_upgrade_output.d/ removed after pg_upgrade --check success # Running: pg_upgrade --no-sync --old-datadir C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin --new-bindir C:/cirrus/build/TMP_IN~1/usr/local/pgsql/bin --socketdir C:/Windows/TEMP/fdGTCgrUFU --old-port 25576 --new-port 25577 --copy [05:32:57.033](40.553s) ok 16 - run of pg_upgrade for new instance [05:32:57.033](0.000s) ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success ### Starting node "new_node" # Running: pg_ctl --wait --pgdata C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\data/t_002_pg_upgrade_new_node_data/pgdata --log C:\cirrus\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 5952 [05:32:57.780](0.747s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=25577 host=C:/Windows/TEMP/fdGTCgrUFU dbname='postgres' --file C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\tmp_test_NkAL/dump2.sql [05:33:04.725](6.945s) ok 19 - dump after running pg_upgrade [05:33:05.475](0.750s) ok 20 - old and new dumps match after pg_upgrade [05:33:05.477](0.001s) 1..20 ### Stopping node "new_node" using mode immediate # Running: pg_ctl --pgdata C:\cirrus\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:33:05.670](0.193s) # Looks like you failed 1 test of 20.