[07:43:31.530](0.041s) # testing using transfer mode --copy # Checking port 20261 # Found port 20261 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=20261 host=C:/Windows/TEMP/9iVnUuiXZ1 Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_old_node.log [07:43:31.635](0.106s) # 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 4524 [07:43:38.999](7.363s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [07:43:39.547](0.549s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [07:43:39.983](0.435s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [07:43:40.282](0.299s) 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/9iVnUuiXZ1 --port=20261 --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 [07:46:43.874](183.592s) not ok 5 - regression tests in old instance [07:46:43.874](0.000s) # Failed test 'regression tests in old instance' # at C:/cirrus/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [07:46:43.874](0.000s) # ---------- command failed ---------- [07:46:43.874](0.000s) # C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/9iVnUuiXZ1 --port=20261 --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 [07:46:43.874](0.000s) # -------------- stdout -------------- [07:46:43.875](0.000s) # # using postmaster on C:/Windows/TEMP/9iVnUuiXZ1, port 20261 # ok 1 - test_setup 726 ms # # parallel group (20 tests): uuid text int4 money boolean enum pg_lsn oid int2 float4 txid varchar float8 int8 char bit name regproc rangetypes numeric # ok 2 + boolean 2164 ms # ok 3 + char 2254 ms # ok 4 + name 2345 ms # ok 5 + varchar 2247 ms # ok 6 + text 2078 ms # ok 7 + int2 2163 ms # ok 8 + int4 2075 ms # ok 9 + int8 2242 ms # ok 10 + oid 2153 ms # ok 11 + float4 2233 ms # ok 12 + float8 2236 ms # ok 13 + bit 2237 ms # ok 14 + numeric 2516 ms # ok 15 + txid 2229 ms # ok 16 + uuid 2060 ms # ok 17 + enum 2139 ms # ok 18 + money 2059 ms # ok 19 + rangetypes 2345 ms # ok 20 + pg_lsn 2135 ms # ok 21 + regproc 2318 ms # # parallel group (20 tests): lseg timetz point macaddr path line timestamp date numerology inet box circle polygon time md5 macaddr8 interval strings multirangetypes timestamptz # ok 22 + strings 1422 ms # ok 23 + md5 1366 ms # ok 24 + numerology 1025 ms # ok 25 + point 1016 ms # ok 26 + lseg 883 ms # ok 27 + line 1014 ms [07:46:43.875](0.000s) # ... 206 lines omitted ... [07:46:43.875](0.000s) # ok 219 + partition_merge 2874 ms # ok 220 + partition_split 2963 ms # ok 221 + partition_join 3666 ms # ok 222 + partition_prune 7096 ms # ok 223 + reloptions 2564 ms # ok 224 + hash_part 1507 ms # ok 225 + indexing 6017 ms # ok 226 + partition_aggregate 3288 ms # ok 227 + partition_info 1894 ms # ok 228 + tuplesort 4844 ms # ok 229 + explain 3294 ms # ok 230 + memoize 2940 ms # ok 231 + stats 6006 ms # ok 232 + predicate 2854 ms # ok 233 + numa 2937 ms # ok 234 + eager_aggregate 3524 ms # ok 235 + graph_table_rls 3285 ms # ok 236 + planner_est 2843 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 755 ms # ok 238 + compression_lz4 459 ms # ok 239 + compression_pglz 275 ms # ok 240 + cluster 1468 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 887 ms # ok 242 + event_trigger 949 ms # ok 243 - event_trigger_login 661 ms # ok 244 - fast_default 745 ms # ok 245 - tablespace 1848 ms # 1..245 [07:46:43.876](0.001s) # -------------- stderr -------------- [07:46:43.876](0.000s) # # diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out # # --- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:03.831515400 +0000 # # +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-05-03 07:45:12.669426200 +0000 # # @@ -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 "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". [07:46:43.876](0.000s) # ------------------------------------ # Checking port 20262 # Found port 20262 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=20262 host=C:/Windows/TEMP/9iVnUuiXZ1 Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_new_node.log [07:46:43.903](0.027s) # 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 1444 # Checking port 20263 # Found port 20263 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=20263 host=C:/Windows/TEMP/9iVnUuiXZ1 Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_dst_node.log [07:46:48.490](4.587s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=20261 host=C:/Windows/TEMP/9iVnUuiXZ1 dbname='postgres' --file C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\tmp_test_JyM7/dump1.sql [07:46:54.058](5.568s) 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/9iVnUuiXZ1 --old-port 20261 --new-port 20262 --copy --check [07:46:54.965](0.907s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [07:46:54.966](0.001s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [07:46:54.966](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/9iVnUuiXZ1 --old-port 20261 --new-port 20262 --copy --check [07:46:58.452](3.486s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [07:46:58.453](0.000s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [07:46:58.453](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 6484 ### 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/9iVnUuiXZ1 --old-port 20261 --new-port 20262 --copy --check [07:47:04.762](6.309s) ok 14 - run of pg_upgrade --check for new instance [07:47:04.762](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/9iVnUuiXZ1 --old-port 20261 --new-port 20262 --copy [07:47:33.249](28.486s) ok 16 - run of pg_upgrade for new instance [07:47:33.249](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 1132 [07:47:34.499](1.250s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=20262 host=C:/Windows/TEMP/9iVnUuiXZ1 dbname='postgres' --file C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\tmp_test_JyM7/dump2.sql [07:47:40.417](5.918s) ok 19 - dump after running pg_upgrade [07:47:41.137](0.720s) ok 20 - old and new dumps match after pg_upgrade [07:47:41.139](0.002s) 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" [07:47:41.332](0.193s) # Looks like you failed 1 test of 20.