# Checking port 19114 # Found port 19114 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=19114 host=/tmp/gr_VLmgWy8 Log file: /home/postgres/postgres/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [07:15:22.993](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 2540 (standby_1,) [07:15:23.188](0.195s) 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/gr_VLmgWy8 --port 19114 --checkpoint fast # Backup finished # Checking port 19115 # Found port 19115 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=19115 host=/tmp/gr_VLmgWy8 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 26441 # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/gr_VLmgWy8 --port=19114 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data [07:17:18.455](115.267s) not ok 2 - regression tests pass [07:17:18.456](0.001s) # Failed test 'regression tests pass' # at /home/postgres/postgres/src/test/recovery/t/027_stream_regress.pl line 74. [07:17:18.456](0.000s) # ---------- command failed ---------- [07:17:18.456](0.000s) # /home/postgres/postgres/build/src/test/regress/pg_regress --dlpath=/home/postgres/postgres/build/src/test/regress --bindir= --host=/tmp/gr_VLmgWy8 --port=19114 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/home/postgres/postgres/build/testrun/recovery/027_stream_regress/data [07:17:18.456](0.000s) # -------------- stdout -------------- [07:17:18.456](0.000s) # # using postmaster on /tmp/gr_VLmgWy8, port 19114 # ok 1 - test_setup 248 ms # # parallel group (20 tests): char pg_lsn int4 varchar float4 money txid uuid oid name text int8 bit regproc float8 int2 boolean enum rangetypes numeric # ok 2 + boolean 245 ms # ok 3 + char 48 ms # ok 4 + name 159 ms # ok 5 + varchar 92 ms # ok 6 + text 199 ms # ok 7 + int2 238 ms # ok 8 + int4 74 ms # ok 9 + int8 203 ms # ok 10 + oid 153 ms # ok 11 + float4 114 ms # ok 12 + float8 235 ms # ok 13 + bit 213 ms # ok 14 + numeric 466 ms # ok 15 + txid 140 ms # ok 16 + uuid 152 ms # ok 17 + enum 256 ms # ok 18 + money 121 ms # ok 19 + rangetypes 453 ms # ok 20 + pg_lsn 61 ms # ok 21 + regproc 222 ms # # parallel group (20 tests): lseg point line numerology timetz macaddr macaddr8 md5 inet path circle date interval time strings timestamp timestamptz polygon box multirangetypes # ok 22 + strings 366 ms # ok 23 + md5 157 ms # ok 24 + numerology 69 ms # ok 25 + point 54 ms # ok 26 + lseg 45 ms # ok 27 + line 62 ms [07:17:18.457](0.000s) # ... 206 lines omitted ... [07:17:18.457](0.000s) # ok 219 + partition_merge 3032 ms # ok 220 + partition_split 4148 ms # ok 221 + partition_join 5048 ms # ok 222 + partition_prune 5018 ms # ok 223 + reloptions 296 ms # ok 224 + hash_part 353 ms # ok 225 + indexing 8099 ms # ok 226 + partition_aggregate 4318 ms # ok 227 + partition_info 591 ms # ok 228 + tuplesort 1903 ms # ok 229 + explain 1816 ms # ok 230 + memoize 2224 ms # ok 231 + stats 3900 ms # ok 232 + predicate 467 ms # ok 233 + numa 56 ms # ok 234 + eager_aggregate 1493 ms # ok 235 + graph_table_rls 592 ms # ok 236 + planner_est 78 ms # # parallel group (4 tests): compression_pglz compression cluster compression_lz4 # ok 237 + compression 642 ms # ok 238 + compression_lz4 1703 ms # ok 239 + compression_pglz 37 ms # ok 240 + cluster 1569 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1514 ms # ok 242 + event_trigger 1743 ms # ok 243 - event_trigger_login 49 ms # ok 244 - fast_default 792 ms # ok 245 - tablespace 3347 ms # 1..245 [07:17:18.457](0.000s) # -------------- stderr -------------- [07:17:18.457](0.000s) # # diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out # # --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:29.328544742 +0000 # # +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:15:41.725301957 +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 "/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". [07:17:18.457](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/gr_VLmgWy8 --port 19114 /tmp/gr_VLmgWy8:19114 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/gr_VLmgWy8 --port 19115 /tmp/gr_VLmgWy8:19115 - accepting connections [07:17:18.494](0.037s) ok 3 - primary alive after regression test run [07:17:18.494](0.000s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 1 9 5 5 3 4001 4 3 4 4 1 32 1 1 1 6 104 2 1 2 5 1006 1 1 1 2 -1 1 1 -1 1 1 41 -32768 32767 5 17 1 1 -2 9 1 46 1 1 33 35 Waiting for replication conn standby_1's replay_lsn to pass 0/1604BCA0 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 19114 --no-unlogged-table-data [07:17:26.735](8.241s) 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 19115 [07:17:28.838](2.103s) ok 6 - dump standby server [07:17:29.011](0.173s) 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 16785 Waiting for replication conn standby_1's replay_lsn to pass 0/16D2C158 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 19114 --no-unlogged-table-data regression [07:17:34.075](5.064s) 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 19115 regression [07:17:38.200](4.125s) ok 9 - dump catalogs of standby server [07:17:38.249](0.049s) ok 10 - compare primary and standby catalog dumps [07:17:38.662](0.413s) 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" [07:17:38.890](0.228s) 1..11 [07:17:38.892](0.002s) # Looks like you failed 1 test of 11.