# Checking port 23874 # Found port 23874 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=23874 host=C:/Windows/TEMP/VE3jiGAelA Log file: C:\cirrus\build/testrun/recovery/027_stream_regress\log/027_stream_regress_primary.log [07:19:09.910](0.147s) # 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 6628 (standby_1,) [07:19:11.859](1.949s) 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/VE3jiGAelA --port 23874 --checkpoint fast # Backup finished # Checking port 23875 # Found port 23875 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=23875 host=C:/Windows/TEMP/VE3jiGAelA 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 4176 # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/VE3jiGAelA --port=23874 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=C:\cirrus\build/testrun/recovery/027_stream_regress\data [07:21:52.191](160.332s) not ok 2 - regression tests pass [07:21:52.191](0.000s) # Failed test 'regression tests pass' # at C:/cirrus/src/test/recovery/t/027_stream_regress.pl line 74. [07:21:52.192](0.001s) # ---------- command failed ---------- [07:21:52.193](0.001s) # C:\cirrus\build\src/test\regress\pg_regress.exe --dlpath=C:\cirrus\build\src/test\regress --bindir= --host=C:/Windows/TEMP/VE3jiGAelA --port=23874 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=C:\cirrus\build/testrun/recovery/027_stream_regress\data [07:21:52.194](0.001s) # -------------- stdout -------------- [07:21:52.196](0.002s) # # using postmaster on C:/Windows/TEMP/VE3jiGAelA, port 23874 # ok 1 - test_setup 922 ms # # parallel group (20 tests): varchar char boolean name int2 text money regproc int4 pg_lsn float8 float4 oid int8 bit txid uuid enum rangetypes numeric # ok 2 + boolean 863 ms # ok 3 + char 778 ms # ok 4 + name 869 ms # ok 5 + varchar 674 ms # ok 6 + text 909 ms # ok 7 + int2 864 ms # ok 8 + int4 1090 ms # ok 9 + int8 1158 ms # ok 10 + oid 1106 ms # ok 11 + float4 1102 ms # ok 12 + float8 1099 ms # ok 13 + bit 1153 ms # ok 14 + numeric 2244 ms # ok 15 + txid 1159 ms # ok 16 + uuid 1185 ms # ok 17 + enum 1352 ms # ok 18 + money 986 ms # ok 19 + rangetypes 1986 ms # ok 20 + pg_lsn 1083 ms # ok 21 + regproc 1063 ms # # parallel group (20 tests): macaddr numerology macaddr8 point inet time path polygon interval timetz date circle lseg md5 line timestamptz timestamp multirangetypes strings box # ok 22 + strings 1724 ms # ok 23 + md5 1411 ms # ok 24 + numerology 1043 ms # ok 25 + point 1063 ms # ok 26 + lseg 1403 ms # ok 27 + line 1405 ms [07:21:52.197](0.001s) # ... 206 lines omitted ... [07:21:52.198](0.001s) # ok 219 + partition_merge 4096 ms # ok 220 + partition_split 3175 ms # ok 221 + partition_join 5587 ms # ok 222 + partition_prune 10032 ms # ok 223 + reloptions 1002 ms # ok 224 + hash_part 1410 ms # ok 225 + indexing 7545 ms # ok 226 + partition_aggregate 7520 ms # ok 227 + partition_info 2929 ms # ok 228 + tuplesort 7130 ms # ok 229 + explain 3152 ms # ok 230 + memoize 3723 ms # ok 231 + stats 7238 ms # ok 232 + predicate 994 ms # ok 233 + numa 1402 ms # ok 234 + eager_aggregate 4643 ms # ok 235 + graph_table_rls 3482 ms # ok 236 + planner_est 2894 ms # # parallel group (4 tests): compression_lz4 compression_pglz compression cluster # ok 237 + compression 660 ms # ok 238 + compression_lz4 224 ms # ok 239 + compression_pglz 267 ms # ok 240 + cluster 1437 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1316 ms # ok 242 + event_trigger 1465 ms # ok 243 - event_trigger_login 238 ms # ok 244 - fast_default 1345 ms # ok 245 - tablespace 2414 ms # 1..245 [07:21:52.199](0.001s) # -------------- stderr -------------- [07:21:52.199](0.000s) # # diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out # # --- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:28.222315600 +0000 # # +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:19:49.775743200 +0000 # # @@ -1099,8 +1099,6 @@ # # FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' # # SET name = 'one^3' # # WHERE id = 1; # # -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # -- test inserts violating CHECK constraints # # ALTER TABLE for_portion_of_test2 # # @@ -1115,12 +1113,13 @@ # # SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; # # id | valid_at | name # # ----+-------------------------+------- # # - 1 | [2000-01-01,2010-01-01) | one # # + 1 | [2000-01-01,2001-01-11) | one^3 # # + 1 | [2001-01-11,2010-01-01) | one # # 1 | [2010-01-01,2010-01-05) | one^1 # # 1 | [2010-01-05,2010-01-07) | one # # 1 | [2010-01-07,2010-01-09) | one^2 # # 1 | [2010-01-09,2020-01-01) | one # # -(5 rows) # # +(6 rows) # # # # -- DELETE works: # # DELETE FROM for_portion_of_test2 # # @@ -1222,8 +1221,6 @@ # # FOR PORTION OF valid_at ('{[2000-01-01,2001-01-11)}') # # SET name = 'one^3' # # WHERE id = 1; # # -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, {[2000-01-01,2001-01-11)}, one^3). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # -- test inserts violating CHECK constraints # # ALTER TABLE for_portion_of_test2 # # @@ -1233,14 +1230,15 @@ # # SET name = 'one^3' # # WHERE id = 1; # # ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" # # -DETAIL: Failing row contains (1, {[2000-01-01,2001-01-01),[2002-02-02,2010-01-07),[2010-01-09,202..., one). # # +DETAIL: Failing row contains (1, {[2002-02-02,2010-01-07),[2010-01-09,2020-01-01)}, one). # # ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; # # SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; # # id | valid_at | name # # ----+---------------------------------------------------+------- # # - 1 | {[2000-01-01,2010-01-07),[2010-01-09,2020-01-01)} | one # # + 1 | {[2000-01-01,2001-01-11)} | one^3 # # + 1 | {[2001-01-11,2010-01-07),[2010-01-09,2020-01-01)} | one # # 1 | {[2010-01-07,2010-01-09)} | one^2 # # -(2 rows) # # +(3 rows) # # # # -- DELETE works: # # DELETE FROM for_portion_of_test2 # # 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:21:52.199](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host C:/Windows/TEMP/VE3jiGAelA --port 23874 C:/Windows/TEMP/VE3jiGAelA:23874 - accepting connections # Running: pg_isready --timeout 180 --host C:/Windows/TEMP/VE3jiGAelA --port 23875 C:/Windows/TEMP/VE3jiGAelA:23875 - accepting connections [07:21:52.547](0.348s) ok 3 - primary alive after regression test run [07:21:52.549](0.002s) ok 4 - standby alive after regression test run 1 1 1 1 1 1 1 5 2 1 5 9 1 1 -1 1 1 -1 -32768 3 4 3 4 4 1 32767 4001 32 1 1 1 6 104 41 2 1 2 5 -2 1006 9 1 46 1 1 33 35 1 2 1 1 5 17 Waiting for replication conn standby_1's replay_lsn to pass 0/16C74270 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 23874 --no-unlogged-table-data [07:21:59.322](6.773s) 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 23875 [07:22:05.083](5.761s) ok 6 - dump standby server [07:22:08.232](3.148s) 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 5396 Waiting for replication conn standby_1's replay_lsn to pass 0/17636BA8 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 23874 --no-unlogged-table-data regression [07:22:14.994](6.762s) 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 23875 regression [07:22:19.840](4.847s) ok 9 - dump catalogs of standby server [07:22:21.077](1.236s) ok 10 - compare primary and standby catalog dumps [07:22:22.109](1.032s) 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:22:22.798](0.689s) 1..11 [07:22:22.826](0.027s) # Looks like you failed 1 test of 11.