[07:14:59.860](0.041s) # testing using transfer mode --copy # Checking port 14238 # Found port 14238 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=14238 host=C:/Windows/TEMP/4KpyreOCox Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_old_node.log [07:15:00.107](0.246s) # 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 5376 [07:15:07.677](7.570s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [07:15:08.208](0.531s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [07:15:08.580](0.372s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [07:15:08.928](0.347s) 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/4KpyreOCox --port=14238 --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:18:13.551](184.623s) not ok 5 - regression tests in old instance [07:18:13.551](0.000s) # Failed test 'regression tests in old instance' # at C:/cirrus/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [07:18:13.551](0.001s) # ---------- command failed ---------- [07:18:13.552](0.000s) # C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/4KpyreOCox --port=14238 --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:18:13.552](0.000s) # -------------- stdout -------------- [07:18:13.553](0.000s) # # using postmaster on C:/Windows/TEMP/4KpyreOCox, port 14238 # ok 1 - test_setup 738 ms # # parallel group (20 tests): char money int2 uuid float8 bit boolean txid varchar pg_lsn regproc name enum int4 oid int8 text float4 rangetypes numeric # ok 2 + boolean 1103 ms # ok 3 + char 977 ms # ok 4 + name 1289 ms # ok 5 + varchar 1102 ms # ok 6 + text 1835 ms # ok 7 + int2 975 ms # ok 8 + int4 1486 ms # ok 9 + int8 1635 ms # ok 10 + oid 1486 ms # ok 11 + float4 1834 ms # ok 12 + float8 972 ms # ok 13 + bit 1078 ms # ok 14 + numeric 2265 ms # ok 15 + txid 1083 ms # ok 16 + uuid 963 ms # ok 17 + enum 1267 ms # ok 18 + money 954 ms # ok 19 + rangetypes 1821 ms # ok 20 + pg_lsn 1162 ms # ok 21 + regproc 1257 ms # # parallel group (20 tests): point path macaddr interval numerology macaddr8 date strings inet md5 lseg time polygon circle line box timestamptz timetz timestamp multirangetypes # ok 22 + strings 1352 ms # ok 23 + md5 1473 ms # ok 24 + numerology 1341 ms # ok 25 + point 1133 ms # ok 26 + lseg 1468 ms # ok 27 + line 1639 ms [07:18:13.553](0.000s) # ... 206 lines omitted ... [07:18:13.553](0.000s) # ok 219 + partition_merge 2794 ms # ok 220 + partition_split 3390 ms # ok 221 + partition_join 3746 ms # ok 222 + partition_prune 5388 ms # ok 223 + reloptions 3386 ms # ok 224 + hash_part 2212 ms # ok 225 + indexing 6025 ms # ok 226 + partition_aggregate 6172 ms # ok 227 + partition_info 3370 ms # ok 228 + tuplesort 5477 ms # ok 229 + explain 2782 ms # ok 230 + memoize 3059 ms # ok 231 + stats 6152 ms # ok 232 + predicate 2205 ms # ok 233 + numa 2773 ms # ok 234 + eager_aggregate 3499 ms # ok 235 + graph_table_rls 2772 ms # ok 236 + planner_est 2761 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 453 ms # ok 238 + compression_lz4 379 ms # ok 239 + compression_pglz 273 ms # ok 240 + cluster 1058 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 745 ms # ok 242 + event_trigger 752 ms # ok 243 - event_trigger_login 513 ms # ok 244 - fast_default 853 ms # ok 245 - tablespace 2511 ms # 1..245 [07:18:13.553](0.000s) # -------------- stderr -------------- [07:18:13.554](0.000s) # # diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out # # --- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:28.222315600 +0000 # # +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:15:51.836766400 +0000 # # @@ -1099,8 +1099,6 @@ # # FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' # # SET name = 'one^3' # # WHERE id = 1; # # -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # -- test inserts violating CHECK constraints # # ALTER TABLE for_portion_of_test2 # # @@ -1115,12 +1113,13 @@ # # SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; # # id | valid_at | name # # ----+-------------------------+------- # # - 1 | [2000-01-01,2010-01-01) | one # # + 1 | [2000-01-01,2001-01-11) | one^3 # # + 1 | [2001-01-11,2010-01-01) | one # # 1 | [2010-01-01,2010-01-05) | one^1 # # 1 | [2010-01-05,2010-01-07) | one # # 1 | [2010-01-07,2010-01-09) | one^2 # # 1 | [2010-01-09,2020-01-01) | one # # -(5 rows) # # +(6 rows) # # # # -- DELETE works: # # DELETE FROM for_portion_of_test2 # # @@ -1222,8 +1221,6 @@ # # FOR PORTION OF valid_at ('{[2000-01-01,2001-01-11)}') # # SET name = 'one^3' # # WHERE id = 1; # # -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, {[2000-01-01,2001-01-11)}, one^3). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # -- test inserts violating CHECK constraints # # ALTER TABLE for_portion_of_test2 # # @@ -1233,14 +1230,15 @@ # # SET name = 'one^3' # # WHERE id = 1; # # ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, {[2000-01-01,2001-01-01),[2002-02-02,2010-01-07),[2010-01-09,202..., one). # # +DETAIL: Failing row contains (1, {[2002-02-02,2010-01-07),[2010-01-09,2020-01-01)}, one). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; # # id | valid_at | name # # ----+---------------------------------------------------+------- # # - 1 | {[2000-01-01,2010-01-07),[2010-01-09,2020-01-01)} | one # # + 1 | {[2000-01-01,2001-01-11)} | one^3 # # + 1 | {[2001-01-11,2010-01-07),[2010-01-09,2020-01-01)} | one # # 1 | {[2010-01-07,2010-01-09)} | one^2 # # -(2 rows) # # +(3 rows) # # # # -- DELETE works: # # DELETE FROM for_portion_of_test2 # # 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:18:13.554](0.000s) # ------------------------------------ # Checking port 14239 # Found port 14239 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=14239 host=C:/Windows/TEMP/4KpyreOCox Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_new_node.log [07:18:13.849](0.295s) # 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 2080 # Checking port 14240 # Found port 14240 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=14240 host=C:/Windows/TEMP/4KpyreOCox Log file: C:\cirrus\build/testrun/pg_upgrade/002_pg_upgrade\log/002_pg_upgrade_dst_node.log [07:18:17.957](4.109s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=14238 host=C:/Windows/TEMP/4KpyreOCox dbname='postgres' --file C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\tmp_test_YP4u/dump1.sql [07:18:23.637](5.679s) 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/4KpyreOCox --old-port 14238 --new-port 14239 --copy --check [07:18:24.701](1.064s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [07:18:24.702](0.001s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [07:18:24.702](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/4KpyreOCox --old-port 14238 --new-port 14239 --copy --check [07:18:27.112](2.410s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [07:18:27.113](0.002s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [07:18:27.115](0.001s) 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 7340 ### 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/4KpyreOCox --old-port 14238 --new-port 14239 --copy --check [07:18:32.978](5.863s) ok 14 - run of pg_upgrade --check for new instance [07:18:32.978](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/4KpyreOCox --old-port 14238 --new-port 14239 --copy [07:19:02.595](29.616s) ok 16 - run of pg_upgrade for new instance [07:19:02.595](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 3864 [07:19:03.082](0.488s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=14239 host=C:/Windows/TEMP/4KpyreOCox dbname='postgres' --file C:\cirrus\build\testrun\pg_upgrade\002_pg_upgrade\data\tmp_test_YP4u/dump2.sql [07:19:08.449](5.367s) ok 19 - dump after running pg_upgrade [07:19:09.059](0.610s) ok 20 - old and new dumps match after pg_upgrade [07:19:09.060](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" [07:19:09.228](0.168s) # Looks like you failed 1 test of 20.