# Checking port 13886 # Found port 13886 Name: primary Version: 19devel Data directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup Archive directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/archives Connection string: port=13886 host=/tmp/OGVxD4BNOm Log file: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [05:27:29.759](0.018s) # initializing database system by copying initdb template # Running: cp -RPp /home/postgres/postgres/build/tmp_install/initdb-template /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /home/postgres/postgres/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 16977 (standby_1,) [05:27:29.995](0.237s) ok 1 - physical slot created on primary # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup --no-sync --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup/my_backup --host /tmp/OGVxD4BNOm --port 13886 --checkpoint fast # Backup finished # Checking port 13887 # Found port 13887 Name: standby_1 Version: 19devel Data directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/backup Archive directory: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/archives Connection string: port=13887 host=/tmp/OGVxD4BNOm Log file: /home/postgres/postgres/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 /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata --log /home/postgres/postgres/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 19747 # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/OGVxD4BNOm --port=13886 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data [05:29:59.594](149.599s) not ok 2 - regression tests pass [05:29:59.595](0.001s) # Failed test 'regression tests pass' # at /home/postgres/postgres/src/test/recovery/t/027_stream_regress.pl line 74. [05:29:59.595](0.000s) # ---------- command failed ---------- [05:29:59.595](0.000s) # /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/OGVxD4BNOm --port=13886 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data [05:29:59.596](0.000s) # -------------- stdout -------------- [05:29:59.596](0.000s) # # using postmaster on /tmp/OGVxD4BNOm, port 13886 # ok 1 - test_setup 356 ms # # parallel group (20 tests): int4 oid varchar int8 money regproc int2 pg_lsn float4 txid text boolean float8 char name uuid enum bit numeric rangetypes # ok 2 + boolean 228 ms # ok 3 + char 252 ms # ok 4 + name 262 ms # ok 5 + varchar 102 ms # ok 6 + text 216 ms # ok 7 + int2 157 ms # ok 8 + int4 62 ms # ok 9 + int8 109 ms # ok 10 + oid 69 ms # ok 11 + float4 171 ms # ok 12 + float8 232 ms # ok 13 + bit 383 ms # ok 14 + numeric 602 ms # ok 15 + txid 161 ms # ok 16 + uuid 267 ms # ok 17 + enum 381 ms # ok 18 + money 97 ms # ok 19 + rangetypes 618 ms # ok 20 + pg_lsn 125 ms # ok 21 + regproc 101 ms # # parallel group (20 tests): macaddr time point md5 timetz inet line lseg path numerology date circle macaddr8 timestamp interval strings timestamptz box polygon multirangetypes # ok 22 + strings 1142 ms # ok 23 + md5 119 ms # ok 24 + numerology 370 ms # ok 25 + point 113 ms # ok 26 + lseg 360 ms # ok 27 + line 358 ms [05:29:59.596](0.000s) # ... 207 lines omitted ... [05:29:59.596](0.000s) # ok 220 + partition_merge 6048 ms # ok 221 + partition_split 5048 ms # ok 222 + partition_join 7420 ms # ok 223 + partition_prune 8048 ms # ok 224 + reloptions 336 ms # ok 225 + hash_part 580 ms # ok 226 + indexing 11055 ms # ok 227 + partition_aggregate 5849 ms # ok 228 + partition_info 2224 ms # ok 229 + tuplesort 4393 ms # ok 230 + explain 661 ms # ok 231 + memoize 2970 ms # ok 232 + stats 6642 ms # ok 233 + predicate 796 ms # ok 234 + numa 104 ms # ok 235 + eager_aggregate 2873 ms # ok 236 + graph_table_rls 1096 ms # ok 237 + planner_est 106 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 238 + compression 1100 ms # ok 239 + compression_lz4 711 ms # ok 240 + compression_pglz 107 ms # ok 241 + cluster 2176 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 1828 ms # ok 243 + event_trigger 1979 ms # ok 244 - event_trigger_login 95 ms # ok 245 - fast_default 783 ms # ok 246 - tablespace 3654 ms # 1..246 [05:29:59.596](0.000s) # -------------- stderr -------------- [05:29:59.596](0.000s) # # diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out # # --- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-05-06 05:25:08.216455613 +0000 # # +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-05-06 05:28:38.169902225 +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:29:59.597](0.000s) # ... 16 lines omitted ... [05:29:59.597](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 "/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/regression.diffs". # # A copy of the test summary that you see above is saved in the file "/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/regression.out". [05:29:59.597](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/OGVxD4BNOm --port 13886 /tmp/OGVxD4BNOm:13886 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/OGVxD4BNOm --port 13887 /tmp/OGVxD4BNOm:13887 - accepting connections [05:29:59.638](0.041s) ok 3 - primary alive after regression test run [05:29:59.639](0.001s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 1 9 5 5 3 4 3 4 4 1 32 1 1 4001 1 6 104 2 1 2 5 41 1006 1 1 1 2 -1 1 1 -1 1 1 -32768 32767 5 17 -2 9 1 46 1 1 1 1 33 35 Waiting for replication conn standby_1's replay_lsn to pass 0/17433108 on primary done # Running: pg_dumpall --file /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/primary.dump --no-sync --no-statistics --restrict-key test --port 13886 --no-unlogged-table-data [05:30:08.920](9.281s) ok 5 - dump primary server # Running: pg_dumpall --file /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/standby.dump --no-sync --no-statistics --restrict-key test --port 13887 [05:30:11.336](2.416s) ok 6 - dump standby server [05:30:11.533](0.197s) ok 7 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /home/postgres/postgres/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 19526 Waiting for replication conn standby_1's replay_lsn to pass 0/1774BFF0 on primary done # Running: pg_dump --schema pg_catalog --file /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/catalogs_primary.dump --no-sync --restrict-key test --port 13886 --no-unlogged-table-data regression [05:30:20.114](8.581s) ok 8 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog --file /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/catalogs_standby.dump --no-sync --restrict-key test --port 13887 regression [05:30:28.385](8.271s) ok 9 - dump catalogs of standby server [05:30:28.463](0.078s) ok 10 - compare primary and standby catalog dumps [05:30:28.888](0.426s) ok 11 - check contents of pg_stat_statements on regression database ### Stopping node "standby_1" using mode fast # Running: pg_ctl --pgdata /home/postgres/postgres/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 /home/postgres/postgres/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:30:29.552](0.664s) 1..11 [05:30:29.558](0.005s) # Looks like you failed 1 test of 11.