# Checking port 32108 # Found port 32108 Name: primary Version: 19devel Data directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata Backup directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/backup Archive directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/archives Connection string: port=32108 host=C:/Windows/TEMP/VEX6LDrpb9 Log file: C:\cirrus\build/testrun/recovery/027_stream_regress\log/027_stream_regress_primary.log [05:32:44.835](0.099s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata --log C:\cirrus\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 2704 (standby_1,) [05:32:48.665](3.830s) ok 1 - physical slot created on primary # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup --no-sync --pgdata C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/backup/my_backup --host C:/Windows/TEMP/VEX6LDrpb9 --port 32108 --checkpoint fast # Backup finished # Checking port 32109 # Found port 32109 Name: standby_1 Version: 19devel Data directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_standby_1_data/pgdata Backup directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_standby_1_data/backup Archive directory: C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_standby_1_data/archives Connection string: port=32109 host=C:/Windows/TEMP/VEX6LDrpb9 Log file: C:\cirrus\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 C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_standby_1_data/pgdata --log C:\cirrus\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 596 # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/VEX6LDrpb9 --port=32108 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=C:\cirrus\build/testrun/recovery/027_stream_regress\data [05:36:15.255](206.589s) not ok 2 - regression tests pass [05:36:15.255](0.000s) # Failed test 'regression tests pass' # at C:/cirrus/src/test/recovery/t/027_stream_regress.pl line 74. [05:36:15.255](0.000s) # ---------- command failed ---------- [05:36:15.255](0.000s) # C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/VEX6LDrpb9 --port=32108 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=C:\cirrus\build/testrun/recovery/027_stream_regress\data [05:36:15.255](0.000s) # -------------- stdout -------------- [05:36:15.256](0.000s) # # using postmaster on C:/Windows/TEMP/VEX6LDrpb9, port 32108 # ok 1 - test_setup 941 ms # # parallel group (20 tests): char varchar pg_lsn regproc name int8 oid text txid float4 int4 uuid int2 float8 enum boolean money bit numeric rangetypes # ok 2 + boolean 1133 ms # ok 3 + char 660 ms # ok 4 + name 854 ms # ok 5 + varchar 661 ms # ok 6 + text 875 ms # ok 7 + int2 963 ms # ok 8 + int4 922 ms # ok 9 + int8 851 ms # ok 10 + oid 860 ms # ok 11 + float4 896 ms # ok 12 + float8 956 ms # ok 13 + bit 1160 ms # ok 14 + numeric 1852 ms # ok 15 + txid 861 ms # ok 16 + uuid 943 ms # ok 17 + enum 1003 ms # ok 18 + money 1148 ms # ok 19 + rangetypes 2042 ms # ok 20 + pg_lsn 728 ms # ok 21 + regproc 821 ms # # parallel group (20 tests): interval md5 circle date macaddr line polygon lseg time timestamptz point timetz path numerology macaddr8 timestamp inet box strings multirangetypes # ok 22 + strings 2787 ms # ok 23 + md5 1474 ms # ok 24 + numerology 2491 ms # ok 25 + point 2258 ms # ok 26 + lseg 1732 ms # ok 27 + line 1580 ms [05:36:15.256](0.000s) # ... 207 lines omitted ... [05:36:15.256](0.000s) # ok 220 + partition_merge 7912 ms # ok 221 + partition_split 7993 ms # ok 222 + partition_join 8418 ms # ok 223 + partition_prune 14368 ms # ok 224 + reloptions 2951 ms # ok 225 + hash_part 2843 ms # ok 226 + indexing 9924 ms # ok 227 + partition_aggregate 9918 ms # ok 228 + partition_info 2579 ms # ok 229 + tuplesort 9669 ms # ok 230 + explain 3580 ms # ok 231 + memoize 3756 ms # ok 232 + stats 10180 ms # ok 233 + predicate 2930 ms # ok 234 + numa 2166 ms # ok 235 + eager_aggregate 4561 ms # ok 236 + graph_table_rls 2571 ms # ok 237 + planner_est 4518 ms # # parallel group (4 tests): compression_lz4 compression_pglz compression cluster # ok 238 + compression 748 ms # ok 239 + compression_lz4 298 ms # ok 240 + compression_pglz 305 ms # ok 241 + cluster 2742 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 1275 ms # ok 243 + event_trigger 1467 ms # ok 244 - event_trigger_login 309 ms # ok 245 - fast_default 1031 ms # ok 246 - tablespace 3438 ms # 1..246 [05:36:15.256](0.000s) # -------------- stderr -------------- [05:36:15.257](0.000s) # # diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out # # --- C:/cirrus/src/test/regress/expected/goo.out 2026-05-06 05:24:59.138506000 +0000 # # +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-05-06 05:34:29.019758600 +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:36:15.257](0.000s) # ... 16 lines omitted ... [05:36:15.258](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 "C:/cirrus/build/testrun/recovery/027_stream_regress/data/regression.diffs". # # A copy of the test summary that you see above is saved in the file "C:/cirrus/build/testrun/recovery/027_stream_regress/data/regression.out". [05:36:15.258](0.001s) # ------------------------------------ # Running: pg_isready --timeout 180 --host C:/Windows/TEMP/VEX6LDrpb9 --port 32108 C:/Windows/TEMP/VEX6LDrpb9:32108 - accepting connections # Running: pg_isready --timeout 180 --host C:/Windows/TEMP/VEX6LDrpb9 --port 32109 C:/Windows/TEMP/VEX6LDrpb9:32109 - accepting connections [05:36:15.484](0.225s) ok 3 - primary alive after regression test run [05:36:15.497](0.014s) ok 4 - standby alive after regression test run 1 1 1 1 1 41 2 1 1 9 5 5 1 3 4 3 4 4 1 33 32 1 1 1 4001 6 35 104 -1 2 1 1 5 1 -1 2 5 17 1006 1 2 -32768 32767 1 1 1 1 -2 9 1 46 1 1 Waiting for replication conn standby_1's replay_lsn to pass 0/16EEC730 on primary done # Running: pg_dumpall --file C:\cirrus\build/testrun/recovery/027_stream_regress\data/primary.dump --no-sync --no-statistics --restrict-key test --port 32108 --no-unlogged-table-data [05:36:24.117](8.620s) ok 5 - dump primary server # Running: pg_dumpall --file C:\cirrus\build/testrun/recovery/027_stream_regress\data/standby.dump --no-sync --no-statistics --restrict-key test --port 32109 [05:36:32.311](8.194s) ok 6 - dump standby server [05:36:36.419](4.108s) ok 7 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl --wait --pgdata C:\cirrus\build/testrun/recovery/027_stream_regress\data/t_027_stream_regress_primary_data/pgdata --log C:\cirrus\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 7572 Waiting for replication conn standby_1's replay_lsn to pass 0/17459208 on primary done # Running: pg_dump --schema pg_catalog --file C:\cirrus\build/testrun/recovery/027_stream_regress\data/catalogs_primary.dump --no-sync --restrict-key test --port 32108 --no-unlogged-table-data regression [05:36:44.738](8.320s) ok 8 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog --file C:\cirrus\build/testrun/recovery/027_stream_regress\data/catalogs_standby.dump --no-sync --restrict-key test --port 32109 regression [05:36:52.595](7.857s) ok 9 - dump catalogs of standby server [05:36:53.079](0.484s) ok 10 - compare primary and standby catalog dumps [05:36:53.940](0.861s) ok 11 - check contents of pg_stat_statements on regression database ### Stopping node "standby_1" using mode fast # Running: pg_ctl --pgdata C:\cirrus\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 C:\cirrus\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:36:54.628](0.688s) 1..11 [05:36:54.644](0.016s) # Looks like you failed 1 test of 11.