[07:14:18.439](0.111s) # testing using transfer mode --copy # Checking port 29704 # Found port 29704 Name: old_node Version: 19devel Data directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/backup Archive directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/archives Connection string: port=29704 host=/tmp/JMkZpdDkFn Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [07:14:18.471](0.033s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /home/postgres/postgres/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 "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 /home/postgres/postgres/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 ... Etc/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata -l logfile start # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /home/postgres/postgres/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 48540 [07:14:24.262](5.791s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [07:14:24.985](0.723s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [07:14:25.685](0.700s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [07:14:26.000](0.315s) ok 4 - created database with ASCII characters from 91 to 127 # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/JMkZpdDkFn --port=29704 --schedule=/home/postgres/postgres/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/home/postgres/postgres/src/test/regress --outputdir=/home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data [07:17:02.648](156.648s) not ok 5 - regression tests in old instance [07:17:02.650](0.002s) # Failed test 'regression tests in old instance' # at /home/postgres/postgres/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [07:17:02.651](0.001s) # ---------- command failed ---------- [07:17:02.651](0.000s) # /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/JMkZpdDkFn --port=29704 --schedule=/home/postgres/postgres/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/home/postgres/postgres/src/test/regress --outputdir=/home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data [07:17:02.652](0.000s) # -------------- stdout -------------- [07:17:02.652](0.001s) # # using postmaster on /tmp/JMkZpdDkFn, port 29704 # ok 1 - test_setup 878 ms # # parallel group (20 tests): int4 txid name float4 varchar pg_lsn text bit money oid int8 int2 uuid regproc char boolean float8 enum rangetypes numeric # ok 2 + boolean 1159 ms # ok 3 + char 1063 ms # ok 4 + name 251 ms # ok 5 + varchar 306 ms # ok 6 + text 334 ms # ok 7 + int2 940 ms # ok 8 + int4 207 ms # ok 9 + int8 900 ms # ok 10 + oid 743 ms # ok 11 + float4 284 ms # ok 12 + float8 1303 ms # ok 13 + bit 542 ms # ok 14 + numeric 3541 ms # ok 15 + txid 191 ms # ok 16 + uuid 947 ms # ok 17 + enum 1449 ms # ok 18 + money 685 ms # ok 19 + rangetypes 2857 ms # ok 20 + pg_lsn 298 ms # ok 21 + regproc 979 ms # # parallel group (20 tests): lseg path timetz inet time macaddr point circle line md5 macaddr8 numerology timestamptz timestamp date interval polygon strings box multirangetypes # ok 22 + strings 1167 ms # ok 23 + md5 395 ms # ok 24 + numerology 581 ms # ok 25 + point 291 ms # ok 26 + lseg 187 ms # ok 27 + line 339 ms [07:17:02.652](0.000s) # ... 206 lines omitted ... [07:17:02.653](0.000s) # ok 219 + partition_merge 6091 ms # ok 220 + partition_split 7625 ms # ok 221 + partition_join 9567 ms # ok 222 + partition_prune 8446 ms # ok 223 + reloptions 1275 ms # ok 224 + hash_part 682 ms # ok 225 + indexing 11947 ms # ok 226 + partition_aggregate 4615 ms # ok 227 + partition_info 1695 ms # ok 228 + tuplesort 6373 ms # ok 229 + explain 1518 ms # ok 230 + memoize 2038 ms # ok 231 + stats 5727 ms # ok 232 + predicate 1990 ms # ok 233 + numa 199 ms # ok 234 + eager_aggregate 2933 ms # ok 235 + graph_table_rls 1928 ms # ok 236 + planner_est 484 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 1017 ms # ok 238 + compression_lz4 888 ms # ok 239 + compression_pglz 70 ms # ok 240 + cluster 2343 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1626 ms # ok 242 + event_trigger 1787 ms # ok 243 - event_trigger_login 312 ms # ok 244 - fast_default 1068 ms # ok 245 - tablespace 4374 ms # 1..245 [07:17:02.653](0.000s) # -------------- stderr -------------- [07:17:02.653](0.000s) # # diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out # # --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue May 5 07:11:28 2026 # # +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out Tue May 5 07:14:54 2026 # # @@ -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 "/home/postgres/postgres/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 "/home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out". [07:17:02.653](0.000s) # ------------------------------------ # Checking port 29705 # Found port 29705 Name: new_node Version: 19devel Data directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/backup Archive directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/archives Connection string: port=29705 host=/tmp/JMkZpdDkFn Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [07:17:02.678](0.025s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /home/postgres/postgres/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 "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 /home/postgres/postgres/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 ... Etc/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata -l logfile start # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /home/postgres/postgres/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 94749 # Checking port 29706 # Found port 29706 Name: dst_node Version: 19devel Data directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/backup Archive directory: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/archives Connection string: port=29706 host=/tmp/JMkZpdDkFn Log file: /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [07:17:09.865](7.187s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=29704 host=/tmp/JMkZpdDkFn dbname='postgres' --file /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_ROlh/dump1.sql [07:17:31.551](21.686s) ok 7 - dump before running pg_upgrade ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin/does/not/exist/ --new-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/JMkZpdDkFn --old-port 29704 --new-port 29705 --copy --check [07:17:32.701](1.150s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [07:17:32.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:17:32.702](0.000s) ok 10 - pg_upgrade_output.d/ not removed after pg_upgrade failure # Running: pg_upgrade --no-sync --old-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --new-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/JMkZpdDkFn --old-port 29704 --new-port 29705 --copy --check [07:17:35.119](2.417s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [07:17:35.122](0.003s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [07:17:35.123](0.002s) ok 13 - invalid database causes failure stderr /(?^:^$)/ ### Starting node "old_node" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /home/postgres/postgres/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 56932 ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --new-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/JMkZpdDkFn --old-port 29704 --new-port 29705 --copy --check [07:17:45.880](10.757s) ok 14 - run of pg_upgrade --check for new instance [07:17:45.881](0.001s) ok 15 - pg_upgrade_output.d/ removed after pg_upgrade --check success # Running: pg_upgrade --no-sync --old-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --new-bindir /home/postgres/postgres/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/JMkZpdDkFn --old-port 29704 --new-port 29705 --copy [07:18:45.891](60.010s) ok 16 - run of pg_upgrade for new instance [07:18:45.892](0.001s) ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success ### Starting node "new_node" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --log /home/postgres/postgres/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 75002 [07:18:46.329](0.437s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=29705 host=/tmp/JMkZpdDkFn dbname='postgres' --file /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_ROlh/dump2.sql [07:19:03.196](16.867s) ok 19 - dump after running pg_upgrade [07:19:05.656](2.460s) ok 20 - old and new dumps match after pg_upgrade [07:19:05.664](0.008s) 1..20 ### Stopping node "new_node" using mode immediate # Running: pg_ctl --pgdata /home/postgres/postgres/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:05.841](0.176s) # Looks like you failed 1 test of 20.