# Checking port 19760 # Found port 19760 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=19760 host=/tmp/F6LJRU3mXt Log file: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [05:27:06.201](0.027s) # 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 36234 (standby_1,) [05:27:08.466](2.265s) 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/F6LJRU3mXt --port 19760 --checkpoint fast # Backup finished # Checking port 19761 # Found port 19761 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=19761 host=/tmp/F6LJRU3mXt 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 36388 # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/F6LJRU3mXt --port=19760 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [05:32:34.431](325.965s) not ok 2 - regression tests pass [05:32:34.431](0.000s) # Failed test 'regression tests pass' # at /tmp/cirrus-ci-build/src/test/recovery/t/027_stream_regress.pl line 74. [05:32:34.431](0.000s) # ---------- command failed ---------- [05:32:34.432](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/F6LJRU3mXt --port=19760 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [05:32:34.432](0.000s) # -------------- stdout -------------- [05:32:34.433](0.001s) # # using postmaster on /tmp/F6LJRU3mXt, port 19760 # ok 1 - test_setup 583 ms # # parallel group (20 tests): varchar char txid pg_lsn int2 name oid float4 uuid text money boolean float8 enum int4 int8 bit regproc rangetypes numeric # ok 2 + boolean 786 ms # ok 3 + char 204 ms # ok 4 + name 436 ms # ok 5 + varchar 142 ms # ok 6 + text 673 ms # ok 7 + int2 345 ms # ok 8 + int4 1137 ms # ok 9 + int8 1376 ms # ok 10 + oid 557 ms # ok 11 + float4 624 ms # ok 12 + float8 936 ms # ok 13 + bit 1752 ms # ok 14 + numeric 10318 ms # ok 15 + txid 288 ms # ok 16 + uuid 637 ms # ok 17 + enum 1133 ms # ok 18 + money 720 ms # ok 19 + rangetypes 4070 ms # ok 20 + pg_lsn 317 ms # ok 21 + regproc 1788 ms # # parallel group (20 tests): line point md5 lseg circle timetz macaddr8 path macaddr time numerology date timestamp box inet interval polygon timestamptz multirangetypes strings # ok 22 + strings 15175 ms # ok 23 + md5 206 ms # ok 24 + numerology 768 ms # ok 25 + point 202 ms # ok 26 + lseg 239 ms # ok 27 + line 168 ms [05:32:34.433](0.000s) # ... 207 lines omitted ... [05:32:34.433](0.000s) # ok 220 + partition_merge 11328 ms # ok 221 + partition_split 10863 ms # ok 222 + partition_join 8713 ms # ok 223 + partition_prune 21703 ms # ok 224 + reloptions 2029 ms # ok 225 + hash_part 1035 ms # ok 226 + indexing 21370 ms # ok 227 + partition_aggregate 9679 ms # ok 228 + partition_info 3406 ms # ok 229 + tuplesort 5720 ms # ok 230 + explain 1559 ms # ok 231 + memoize 7473 ms # ok 232 + stats 11619 ms # ok 233 + predicate 1776 ms # ok 234 + numa 191 ms # ok 235 + eager_aggregate 2881 ms # ok 236 + graph_table_rls 3195 ms # ok 237 + planner_est 858 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 238 + compression 3966 ms # ok 239 + compression_lz4 2996 ms # ok 240 + compression_pglz 101 ms # ok 241 + cluster 4181 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 2281 ms # ok 243 + event_trigger 3162 ms # ok 244 - event_trigger_login 151 ms # ok 245 - fast_default 2751 ms # ok 246 - tablespace 6037 ms # 1..246 [05:32:34.433](0.000s) # -------------- stderr -------------- [05:32:34.433](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-05-06 05:24:51.848051000 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-05-06 05:29:36.035560000 +0000 # # @@ -139,8 +139,8 @@ # # JOIN dim3 ON fact.dim3_id = dim3.id # # JOIN dim4 ON fact.dim4_id = dim4.id # # WHERE dim1.id < 5; # # - QUERY PLAN # # ---------------------------------------------------------------------- # # + QUERY PLAN # # +--------------------------------------------------------------------------- # # Aggregate # # -> Nested Loop # # Join Filter: (fact.dim4_id = dim4.id) # # @@ -149,15 +149,15 @@ # # -> Seq Scan on dim3 # # -> Hash # # -> Hash Join # # - Hash Cond: (fact.dim1_id = dim1.id) # # - -> Hash Join # # - Hash Cond: (fact.dim2_id = dim2.id) # # - -> Seq Scan on fact # # - -> Hash # # - -> Seq Scan on dim2 # # + Hash Cond: (dim2.id = fact.dim2_id) # # + -> Seq Scan on dim2 # # -> Hash # # - -> Seq Scan on dim1 # # - Filter: (id < 5) # # + -> Hash Join [05:32:34.433](0.000s) # ... 16 lines omitted ... [05:32:34.433](0.000s) # # Aggregate # # -> Hash Join # # Hash Cond: (t2.a = t1.a) # # - -> Nested Loop # # - -> Hash Join # # - Hash Cond: (t6.e = t5.f) # # - -> Seq Scan on t6 # # - -> Hash # # - -> Seq Scan on t5 # # - Filter: (d < 3) # # - -> Seq Scan on t2 # # + -> Seq Scan on t2 # # -> Hash # # - -> Seq Scan on t1 # # - Filter: (a < 5) # # + -> Nested Loop # # + -> Hash Join # # + Hash Cond: (t6.e = t5.f) # # + -> Seq Scan on t6 # # + -> Hash # # + -> Seq Scan on t5 # # + Filter: (d < 3) # # + -> Seq Scan on t1 # # + Filter: (a < 5) # # (14 rows) # # # # -- # # 1 of 246 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". [05:32:34.434](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/F6LJRU3mXt --port 19760 /tmp/F6LJRU3mXt:19760 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/F6LJRU3mXt --port 19761 /tmp/F6LJRU3mXt:19761 - accepting connections [05:32:34.473](0.040s) ok 3 - primary alive after regression test run [05:32:34.474](0.001s) ok 4 - standby alive after regression test run 1 1 1 1 1 1 1 2 -1 1 9 1 5 5 5 1 17 -32768 35 3 4 3 4 4 1 32767 32 1 1 1 4001 6 104 2 1 41 2 5 1006 46 1 -2 1 9 1 1 33 1 -1 1 2 1 1 Waiting for replication conn standby_1's replay_lsn to pass 0/17306C30 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 19760 --no-unlogged-table-data [05:32:51.309](16.835s) 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 19761 [05:33:07.278](15.970s) ok 6 - dump standby server [05:33:07.432](0.153s) 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 48833 Waiting for replication conn standby_1's replay_lsn to pass 0/17D4C5D8 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 19760 --no-unlogged-table-data regression [05:33:58.437](51.006s) 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 19761 regression [05:34:32.998](34.561s) ok 9 - dump catalogs of standby server [05:34:33.038](0.040s) ok 10 - compare primary and standby catalog dumps [05:34:33.205](0.167s) 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" [05:34:33.414](0.209s) 1..11 [05:34:33.415](0.002s) # Looks like you failed 1 test of 11.