[07:13:10.276](0.010s) # testing using transfer mode --clone # Checking port 24095 # Found port 24095 Name: old_node Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/archives Connection string: port=24095 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 Log file: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [07:13:10.292](0.016s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /Users/admin/pgsql/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 "admin". 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 /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata -l logfile start # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /Users/admin/pgsql/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 8375 [07:13:13.301](3.008s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [07:13:13.552](0.251s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [07:13:13.846](0.293s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [07:13:14.097](0.251s) ok 4 - created database with ASCII characters from 91 to 127 # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --dlpath=/Users/admin/pgsql/build/src/test/regress --bindir= --host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 --port=24095 --schedule=/Users/admin/pgsql/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/Users/admin/pgsql/src/test/regress --outputdir=/Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data [07:14:26.723](72.626s) not ok 5 - regression tests in old instance [07:14:26.724](0.002s) # Failed test 'regression tests in old instance' # at /Users/admin/pgsql/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [07:14:26.725](0.000s) # ---------- command failed ---------- [07:14:26.725](0.000s) # /Users/admin/pgsql/build/src/test/regress/pg_regress --dlpath=/Users/admin/pgsql/build/src/test/regress --bindir= --host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 --port=24095 --schedule=/Users/admin/pgsql/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/Users/admin/pgsql/src/test/regress --outputdir=/Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data [07:14:26.725](0.000s) # -------------- stdout -------------- [07:14:26.725](0.000s) # # using postmaster on /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1, port 24095 # ok 1 - test_setup 1255 ms # # parallel group (20 tests): varchar char boolean float4 text int4 bit oid int8 pg_lsn txid int2 name money float8 regproc enum numeric uuid rangetypes # ok 2 + boolean 225 ms # ok 3 + char 168 ms # ok 4 + name 675 ms # ok 5 + varchar 136 ms # ok 6 + text 450 ms # ok 7 + int2 660 ms # ok 8 + int4 470 ms # ok 9 + int8 493 ms # ok 10 + oid 479 ms # ok 11 + float4 387 ms # ok 12 + float8 669 ms # ok 13 + bit 442 ms # ok 14 + numeric 948 ms # ok 15 + txid 603 ms # ok 16 + uuid 980 ms # ok 17 + enum 703 ms # ok 18 + money 605 ms # ok 19 + rangetypes 1299 ms # ok 20 + pg_lsn 433 ms # ok 21 + regproc 614 ms # # parallel group (20 tests): md5 lseg path circle line point numerology time timetz polygon macaddr macaddr8 inet interval date timestamp strings timestamptz box multirangetypes # ok 22 + strings 850 ms # ok 23 + md5 169 ms # ok 24 + numerology 294 ms # ok 25 + point 184 ms # ok 26 + lseg 161 ms # ok 27 + line 170 ms [07:14:26.725](0.000s) # ... 206 lines omitted ... [07:14:26.725](0.000s) # ok 219 + partition_merge 2417 ms # ok 220 + partition_split 2796 ms # ok 221 + partition_join 3436 ms # ok 222 + partition_prune 3179 ms # ok 223 + reloptions 629 ms # ok 224 + hash_part 474 ms # ok 225 + indexing 4299 ms # ok 226 + partition_aggregate 2676 ms # ok 227 + partition_info 724 ms # ok 228 + tuplesort 3611 ms # ok 229 + explain 720 ms # ok 230 + memoize 284 ms # ok 231 + stats 3039 ms # ok 232 + predicate 105 ms # ok 233 + numa 52 ms # ok 234 + eager_aggregate 1150 ms # ok 235 + graph_table_rls 85 ms # ok 236 + planner_est 512 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 618 ms # ok 238 + compression_lz4 346 ms # ok 239 + compression_pglz 264 ms # ok 240 + cluster 877 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 270 ms # ok 242 + event_trigger 623 ms # ok 243 - event_trigger_login 326 ms # ok 244 - fast_default 379 ms # ok 245 - tablespace 2218 ms # 1..245 [07:14:26.725](0.000s) # -------------- stderr -------------- [07:14:26.725](0.000s) # # diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out # # --- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-05-05 07:10:48 # # +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:13:30 # # @@ -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 "/Users/admin/pgsql/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 "/Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out". [07:14:26.726](0.000s) # ------------------------------------ # Checking port 24096 # Found port 24096 Name: new_node Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/archives Connection string: port=24096 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 Log file: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [07:14:26.745](0.020s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /Users/admin/pgsql/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 "admin". 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 /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata -l logfile start # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /Users/admin/pgsql/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 18531 # Checking port 24097 # Found port 24097 Name: dst_node Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/archives Connection string: port=24097 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 Log file: /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [07:14:29.692](2.946s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=24095 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 dbname='postgres' --file /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_BDdg/dump1.sql [07:14:35.497](5.805s) ok 7 - dump before running pg_upgrade ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin/does/not/exist/ --new-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --socketdir /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 --old-port 24095 --new-port 24096 --clone --check [07:14:36.308](0.812s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [07:14:36.309](0.000s) ok 9 - run of pg_upgrade --check for new instance with incorrect binary path stdout /(?^:check for ".*?does/not/exist" failed)/ [07:14:36.309](0.000s) ok 10 - pg_upgrade_output.d/ not removed after pg_upgrade failure # Running: pg_upgrade --no-sync --old-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --new-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --socketdir /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 --old-port 24095 --new-port 24096 --clone --check [07:14:37.402](1.093s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [07:14:37.402](0.000s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [07:14:37.402](0.000s) ok 13 - invalid database causes failure stderr /(?^:^$)/ ### Starting node "old_node" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /Users/admin/pgsql/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 19820 ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --new-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --socketdir /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 --old-port 24095 --new-port 24096 --clone --check [07:14:40.631](3.229s) ok 14 - run of pg_upgrade --check for new instance [07:14:40.631](0.001s) ok 15 - pg_upgrade_output.d/ removed after pg_upgrade --check success # Running: pg_upgrade --no-sync --old-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --new-bindir /Users/admin/pgsql/build/tmp_install/usr/local/pgsql/bin --socketdir /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 --old-port 24095 --new-port 24096 --clone [07:15:00.754](20.122s) ok 16 - run of pg_upgrade for new instance [07:15:00.754](0.001s) ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success ### Starting node "new_node" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --log /Users/admin/pgsql/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 22810 [07:15:01.059](0.304s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=24096 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/IhS4DExcQ1 dbname='postgres' --file /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_BDdg/dump2.sql [07:15:09.267](8.208s) ok 19 - dump after running pg_upgrade [07:15:09.719](0.452s) ok 20 - old and new dumps match after pg_upgrade [07:15:09.720](0.000s) 1..20 ### Stopping node "new_node" using mode immediate # Running: pg_ctl --pgdata /Users/admin/pgsql/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:15:09.838](0.119s) # Looks like you failed 1 test of 20.