# Checking port 15055 # Found port 15055 Name: primary Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/archives Connection string: port=15055 host=/tmp/gHu5h8tFHf Log file: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [11:35:39.335](0.074s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --auth trust -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 database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_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/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log --options --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 35388 (standby_1,) [11:35:41.981](2.646s) ok 1 - physical slot created on primary # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup/my_backup --host /tmp/gHu5h8tFHf --port 15055 --checkpoint fast # Backup finished # Checking port 15056 # Found port 15056 Name: standby_1 Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/archives Connection string: port=15056 host=/tmp/gHu5h8tFHf Log file: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_standby_1.log # Initializing node "standby_1" from backup "my_backup" of node "primary" ### Enabling streaming replication for node "standby_1" ### Starting node "standby_1" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_standby_1.log --options --cluster-name=standby_1 start waiting for server to start.... done server started # Postmaster PID for node "standby_1" is 35487 # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/gHu5h8tFHf --port=15055 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [11:40:47.474](305.493s) not ok 2 - regression tests pass [11:40:47.474](0.000s) # Failed test 'regression tests pass' # at /tmp/cirrus-ci-build/src/test/recovery/t/027_stream_regress.pl line 74. [11:40:47.475](0.000s) # ---------- command failed ---------- [11:40:47.475](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/gHu5h8tFHf --port=15055 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [11:40:47.475](0.000s) # -------------- stdout -------------- [11:40:47.475](0.000s) # # using postmaster on /tmp/gHu5h8tFHf, port 15055 # ok 1 - test_setup 550 ms # # parallel group (20 tests): oid varchar pg_lsn char txid name text money float4 int2 int4 uuid int8 boolean enum float8 regproc bit rangetypes numeric # ok 2 + boolean 1392 ms # ok 3 + char 274 ms # ok 4 + name 324 ms # ok 5 + varchar 147 ms # ok 6 + text 448 ms # ok 7 + int2 599 ms # ok 8 + int4 628 ms # ok 9 + int8 1134 ms # ok 10 + oid 135 ms # ok 11 + float4 573 ms # ok 12 + float8 1593 ms # ok 13 + bit 2533 ms # ok 14 + numeric 9268 ms # ok 15 + txid 310 ms # ok 16 + uuid 824 ms # ok 17 + enum 1571 ms # ok 18 + money 567 ms # ok 19 + rangetypes 4860 ms # ok 20 + pg_lsn 179 ms # ok 21 + regproc 2492 ms # # parallel group (20 tests): lseg circle md5 path line point timetz macaddr numerology timestamp time macaddr8 box inet interval date polygon timestamptz strings multirangetypes # ok 22 + strings 17030 ms # ok 23 + md5 215 ms # ok 24 + numerology 1048 ms # ok 25 + point 279 ms # ok 26 + lseg 156 ms # ok 27 + line 235 ms [11:40:47.475](0.000s) # ... 206 lines omitted ... [11:40:47.476](0.000s) # ok 219 + partition_merge 9886 ms # ok 220 + partition_split 6726 ms # ok 221 + partition_join 7809 ms # ok 222 + partition_prune 17462 ms # ok 223 + reloptions 1075 ms # ok 224 + hash_part 632 ms # ok 225 + indexing 15850 ms # ok 226 + partition_aggregate 5005 ms # ok 227 + partition_info 1636 ms # ok 228 + tuplesort 3832 ms # ok 229 + explain 1288 ms # ok 230 + memoize 4535 ms # ok 231 + stats 8152 ms # ok 232 + predicate 1704 ms # ok 233 + numa 115 ms # ok 234 + eager_aggregate 2292 ms # ok 235 + graph_table_rls 1741 ms # ok 236 + planner_est 615 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 3396 ms # ok 238 + compression_lz4 2463 ms # ok 239 + compression_pglz 35 ms # ok 240 + cluster 4329 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1944 ms # ok 242 + event_trigger 3436 ms # ok 243 - event_trigger_login 246 ms # ok 244 - fast_default 2772 ms # ok 245 - tablespace 6289 ms # 1..245 [11:40:47.476](0.000s) # -------------- stderr -------------- [11:40:47.476](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/union.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/union.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/union.out 2026-05-04 11:33:35.379872000 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/union.out 2026-05-04 11:37:15.586826000 +0000 # # @@ -550,9 +550,9 @@ # # select x from (values (array[1, 2]), (array[1, 3])) _(x) union select x from (values (array[1, 2]), (array[1, 4])) _(x); # # x # # ------- # # + {1,2} # # {1,4} # # {1,3} # # - {1,2} # # (3 rows) # # # # explain (costs off) # # 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/recovery/027_stream_regress/data/regression.diffs". # # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/regression.out". [11:40:47.476](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/gHu5h8tFHf --port 15055 /tmp/gHu5h8tFHf:15055 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/gHu5h8tFHf --port 15056 /tmp/gHu5h8tFHf:15056 - accepting connections [11:40:47.517](0.041s) ok 3 - primary alive after regression test run [11:40:47.518](0.000s) ok 4 - standby alive after regression test run 1 1 1 1 1 1 1 1 2 1 9 5 5 1 1 -1 5 1 1 -1 -32768 3 4 3 4 4 1 32767 32 17 1 1 4001 41 1 1 6 104 2 1 -2 2 5 9 1 1006 46 33 35 1 2 1 1 Waiting for replication conn standby_1's replay_lsn to pass 0/16CD0028 on primary done # Running: pg_dumpall --file /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/primary.dump --no-sync --no-statistics --restrict-key test --port 15055 --no-unlogged-table-data [11:41:04.171](16.653s) ok 5 - dump primary server # Running: pg_dumpall --file /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/standby.dump --no-sync --no-statistics --restrict-key test --port 15056 [11:41:18.467](14.296s) ok 6 - dump standby server [11:41:18.621](0.154s) ok 7 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "primary" is 45279 Waiting for replication conn standby_1's replay_lsn to pass 0/17048540 on primary done # Running: pg_dump --schema pg_catalog --file /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/catalogs_primary.dump --no-sync --restrict-key test --port 15055 --no-unlogged-table-data regression [11:42:09.951](51.330s) ok 8 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog --file /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/catalogs_standby.dump --no-sync --restrict-key test --port 15056 regression [11:42:38.478](28.527s) ok 9 - dump catalogs of standby server [11:42:38.517](0.039s) ok 10 - compare primary and standby catalog dumps [11:42:38.669](0.152s) ok 11 - check contents of pg_stat_statements on regression database ### Stopping node "standby_1" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby_1" ### Stopping node "primary" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary" [11:42:38.877](0.209s) 1..11 [11:42:38.879](0.001s) # Looks like you failed 1 test of 11.