# Checking port 10281 # Found port 10281 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=10281 host=C:/Windows/TEMP/2gQpWtik2n Log file: C:\cirrus\build/testrun/recovery/027_stream_regress\log/027_stream_regress_primary.log [07:47:39.250](0.121s) # 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 4472 (standby_1,) [07:47:42.077](2.826s) 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/2gQpWtik2n --port 10281 --checkpoint fast # Backup finished # Checking port 10282 # Found port 10282 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=10282 host=C:/Windows/TEMP/2gQpWtik2n 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 6596 # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/2gQpWtik2n --port=10281 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=C:\cirrus\build/testrun/recovery/027_stream_regress\data [07:50:36.301](174.224s) not ok 2 - regression tests pass [07:50:36.301](0.000s) # Failed test 'regression tests pass' # at C:/cirrus/src/test/recovery/t/027_stream_regress.pl line 74. [07:50:36.302](0.001s) # ---------- command failed ---------- [07:50:36.302](0.000s) # C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/2gQpWtik2n --port=10281 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=C:\cirrus\build/testrun/recovery/027_stream_regress\data [07:50:36.302](0.000s) # -------------- stdout -------------- [07:50:36.303](0.001s) # # using postmaster on C:/Windows/TEMP/2gQpWtik2n, port 10281 # ok 1 - test_setup 1120 ms # # parallel group (20 tests): int2 oid txid char name enum float8 pg_lsn varchar regproc boolean float4 money uuid int4 bit text int8 rangetypes numeric # ok 2 + boolean 1123 ms # ok 3 + char 729 ms # ok 4 + name 728 ms # ok 5 + varchar 842 ms # ok 6 + text 1436 ms # ok 7 + int2 545 ms # ok 8 + int4 1164 ms # ok 9 + int8 1434 ms # ok 10 + oid 629 ms # ok 11 + float4 1152 ms # ok 12 + float8 718 ms # ok 13 + bit 1355 ms # ok 14 + numeric 2173 ms # ok 15 + txid 675 ms # ok 16 + uuid 1146 ms # ok 17 + enum 706 ms # ok 18 + money 1141 ms # ok 19 + rangetypes 1923 ms # ok 20 + pg_lsn 808 ms # ok 21 + regproc 811 ms # # parallel group (20 tests): circle md5 point path line macaddr8 macaddr inet timetz timestamp date polygon strings time lseg numerology timestamptz interval box multirangetypes # ok 22 + strings 1274 ms # ok 23 + md5 830 ms # ok 24 + numerology 1273 ms # ok 25 + point 825 ms # ok 26 + lseg 1266 ms # ok 27 + line 920 ms [07:50:36.304](0.001s) # ... 206 lines omitted ... [07:50:36.304](0.000s) # ok 219 + partition_merge 6845 ms # ok 220 + partition_split 6565 ms # ok 221 + partition_join 6838 ms # ok 222 + partition_prune 12521 ms # ok 223 + reloptions 2430 ms # ok 224 + hash_part 2586 ms # ok 225 + indexing 9852 ms # ok 226 + partition_aggregate 9852 ms # ok 227 + partition_info 1229 ms # ok 228 + tuplesort 6830 ms # ok 229 + explain 2561 ms # ok 230 + memoize 3505 ms # ok 231 + stats 9447 ms # ok 232 + predicate 1416 ms # ok 233 + numa 2572 ms # ok 234 + eager_aggregate 3496 ms # ok 235 + graph_table_rls 1218 ms # ok 236 + planner_est 1415 ms # # parallel group (4 tests): compression_lz4 compression_pglz compression cluster # ok 237 + compression 583 ms # ok 238 + compression_lz4 196 ms # ok 239 + compression_pglz 388 ms # ok 240 + cluster 1758 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1213 ms # ok 242 + event_trigger 1350 ms # ok 243 - event_trigger_login 394 ms # ok 244 - fast_default 866 ms # ok 245 - tablespace 2459 ms # 1..245 [07:50:36.304](0.000s) # -------------- stderr -------------- [07:50:36.304](0.000s) # # diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out # # --- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:03.831515400 +0000 # # +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-05-03 07:49:15.916023400 +0000 # # @@ -1154,9 +1154,10 @@ # # f2 | bigint | | | | plain | | # # f3 | bigint | | | generated always as (f2 * 2) | plain | | # # Partition key: RANGE (f3) # # -Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'), # # - gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'), # # - gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100') # # +Partitions: # # + gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30') # # + gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50') # # + gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100') # # # # INSERT INTO gtest_part_key1(f2) VALUES (9); -- error # # ERROR: no partition of relation "gtest_part_key1" found for row # # 1 of 245 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". [07:50:36.305](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host C:/Windows/TEMP/2gQpWtik2n --port 10281 C:/Windows/TEMP/2gQpWtik2n:10281 - accepting connections # Running: pg_isready --timeout 180 --host C:/Windows/TEMP/2gQpWtik2n --port 10282 C:/Windows/TEMP/2gQpWtik2n:10282 - accepting connections [07:50:36.591](0.286s) ok 3 - primary alive after regression test run [07:50:36.591](0.001s) ok 4 - standby alive after regression test run 1 1 1 1 1 5 5 2 1 9 3 4 3 4 4 1 32 1 -2 1 1 6 104 2 1 1 1 1 1 -1 2 5 1 1 -1 4001 -32768 32767 1006 33 35 9 1 46 1 1 1 2 1 1 41 5 17 Waiting for replication conn standby_1's replay_lsn to pass 0/16ED9A20 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 10281 --no-unlogged-table-data [07:50:43.175](6.584s) 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 10282 [07:50:49.520](6.345s) ok 6 - dump standby server [07:50:52.710](3.190s) 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 8684 Waiting for replication conn standby_1's replay_lsn to pass 0/171E57F8 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 10281 --no-unlogged-table-data regression [07:50:59.275](6.565s) 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 10282 regression [07:51:04.587](5.312s) ok 9 - dump catalogs of standby server [07:51:05.259](0.672s) ok 10 - compare primary and standby catalog dumps [07:51:05.931](0.672s) 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" [07:51:06.638](0.707s) 1..11 [07:51:06.700](0.062s) # Looks like you failed 1 test of 11.