[07:12:27.405](0.015s) # testing using transfer mode --link # Checking port 17885 # Found port 17885 Name: old_node Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/archives Connection string: port=17885 host=/tmp/es9rmtIicA Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_old_node.log [07:12:27.418](0.012s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/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 -c debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress 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 /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /tmp/cirrus-ci-build/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 7304 [07:12:30.359](2.942s) ok 1 - check locales in original cluster # Running: createdb regression\"\  !"#$%&'()*+,-\\"\\\ [07:12:30.532](0.173s) ok 2 - created database with ASCII characters from 1 to 45 # Running: createdb regression./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ [07:12:30.585](0.053s) ok 3 - created database with ASCII characters from 46 to 90 # Running: createdb regression[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ [07:12:30.621](0.036s) ok 4 - created database with ASCII characters from 91 to 127 # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/es9rmtIicA --port=17885 --schedule=/tmp/cirrus-ci-build/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/tmp/cirrus-ci-build/src/test/regress --outputdir=/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data [07:16:52.635](262.015s) not ok 5 - regression tests in old instance [07:16:52.636](0.000s) # Failed test 'regression tests in old instance' # at /tmp/cirrus-ci-build/src/bin/pg_upgrade/t/002_pg_upgrade.pl line 286. [07:16:52.636](0.000s) # ---------- command failed ---------- [07:16:52.636](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/es9rmtIicA --port=17885 --schedule=/tmp/cirrus-ci-build/src/test/regress/parallel_schedule --max-concurrent-tests=20 --inputdir=/tmp/cirrus-ci-build/src/test/regress --outputdir=/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data [07:16:52.636](0.000s) # -------------- stdout -------------- [07:16:52.637](0.000s) # # using postmaster on /tmp/es9rmtIicA, port 17885 # ok 1 - test_setup 756 ms # # parallel group (20 tests): varchar char oid pg_lsn int4 float4 txid name money text float8 boolean uuid int2 enum bit int8 regproc rangetypes numeric # ok 2 + boolean 590 ms # ok 3 + char 94 ms # ok 4 + name 313 ms # ok 5 + varchar 89 ms # ok 6 + text 429 ms # ok 7 + int2 1476 ms # ok 8 + int4 218 ms # ok 9 + int8 1907 ms # ok 10 + oid 106 ms # ok 11 + float4 229 ms # ok 12 + float8 529 ms # ok 13 + bit 1636 ms # ok 14 + numeric 6744 ms # ok 15 + txid 242 ms # ok 16 + uuid 642 ms # ok 17 + enum 1544 ms # ok 18 + money 321 ms # ok 19 + rangetypes 2904 ms # ok 20 + pg_lsn 152 ms # ok 21 + regproc 2640 ms # # parallel group (20 tests): circle path lseg time md5 point line macaddr box polygon timetz inet macaddr8 timestamp numerology date interval timestamptz multirangetypes strings # ok 22 + strings 9913 ms # ok 23 + md5 244 ms # ok 24 + numerology 1437 ms # ok 25 + point 260 ms # ok 26 + lseg 196 ms # ok 27 + line 325 ms [07:16:52.637](0.000s) # ... 206 lines omitted ... [07:16:52.637](0.000s) # ok 219 + partition_merge 7497 ms # ok 220 + partition_split 10627 ms # ok 221 + partition_join 6553 ms # ok 222 + partition_prune 19610 ms # ok 223 + reloptions 1376 ms # ok 224 + hash_part 1296 ms # ok 225 + indexing 20885 ms # ok 226 + partition_aggregate 2678 ms # ok 227 + partition_info 2348 ms # ok 228 + tuplesort 3304 ms # ok 229 + explain 953 ms # ok 230 + memoize 1405 ms # ok 231 + stats 7498 ms # ok 232 + predicate 2235 ms # ok 233 + numa 157 ms # ok 234 + eager_aggregate 2048 ms # ok 235 + graph_table_rls 1052 ms # ok 236 + planner_est 666 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 2752 ms # ok 238 + compression_lz4 2253 ms # ok 239 + compression_pglz 134 ms # ok 240 + cluster 4162 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1080 ms # ok 242 + event_trigger 1930 ms # ok 243 - event_trigger_login 197 ms # ok 244 - fast_default 2126 ms # ok 245 - tablespace 5958 ms # 1..245 [07:16:52.637](0.000s) # -------------- stderr -------------- [07:16:52.637](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:03.195678000 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:13:14.356530000 +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 "/tmp/cirrus-ci-build/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 "/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out". [07:16:52.637](0.000s) # ------------------------------------ # Checking port 17886 # Found port 17886 Name: new_node Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/archives Connection string: port=17886 host=/tmp/es9rmtIicA Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_new_node.log [07:16:52.640](0.003s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/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 -c debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress 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 /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /tmp/cirrus-ci-build/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 10456 # Checking port 17887 # Found port 17887 Name: dst_node Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_dst_node_data/archives Connection string: port=17887 host=/tmp/es9rmtIicA Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/log/002_pg_upgrade_dst_node.log [07:16:54.543](1.903s) ok 6 # skip regress_dump_restore not enabled in PG_TEST_EXTRA # Running: pg_dumpall --no-sync --restrict-key test --dbname port=17885 host=/tmp/es9rmtIicA dbname='postgres' --file /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_is3p/dump1.sql [07:17:08.529](13.986s) ok 7 - dump before running pg_upgrade ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/does/not/exist/ --new-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/es9rmtIicA --old-port 17885 --new-port 17886 --link --check [07:17:08.668](0.139s) ok 8 - run of pg_upgrade --check for new instance with incorrect binary path status (got 1 vs expected 1) [07:17:08.668](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:08.668](0.000s) ok 10 - pg_upgrade_output.d/ not removed after pg_upgrade failure # Running: pg_upgrade --no-sync --old-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --new-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/es9rmtIicA --old-port 17885 --new-port 17886 --link --check [07:17:09.136](0.468s) ok 11 - invalid database causes failure status (got 1 vs expected 1) [07:17:09.137](0.001s) ok 12 - invalid database causes failure stdout /(?^:datconnlimit)/ [07:17:09.137](0.000s) ok 13 - invalid database causes failure stderr /(?^:^$)/ ### Starting node "old_node" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --log /tmp/cirrus-ci-build/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 16234 ### Stopping node "old_node" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --new-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/es9rmtIicA --old-port 17885 --new-port 17886 --link --check [07:17:11.569](2.432s) ok 14 - run of pg_upgrade --check for new instance [07:17:11.569](0.000s) ok 15 - pg_upgrade_output.d/ removed after pg_upgrade --check success # Running: pg_upgrade --no-sync --old-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_old_node_data/pgdata --new-datadir /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --old-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --new-bindir /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin --socketdir /tmp/es9rmtIicA --old-port 17885 --new-port 17886 --link [07:17:48.016](36.447s) ok 16 - run of pg_upgrade for new instance [07:17:48.017](0.000s) ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success ### Starting node "new_node" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/t_002_pg_upgrade_new_node_data/pgdata --log /tmp/cirrus-ci-build/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 29229 [07:17:48.145](0.128s) ok 18 - check that locales in new cluster match original cluster # Running: pg_dumpall --no-sync --restrict-key test --dbname port=17886 host=/tmp/es9rmtIicA dbname='postgres' --file /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_is3p/dump2.sql [07:18:05.747](17.603s) ok 19 - dump after running pg_upgrade [07:18:05.967](0.220s) ok 20 - old and new dumps match after pg_upgrade [07:18:05.967](0.000s) 1..20 ### Stopping node "new_node" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/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:18:06.073](0.106s) # Looks like you failed 1 test of 20.