# Checking port 22401 # Found port 22401 Name: primary Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/archives Connection string: port=22401 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench Log file: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [07:47:21.267](0.108s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /Users/admin/pgsql/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 21983 (standby_1,) [07:47:23.511](2.243s) ok 1 - physical slot created on primary # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup --no-sync --pgdata /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup/my_backup --host /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench --port 22401 --checkpoint fast # Backup finished # Checking port 22402 # Found port 22402 Name: standby_1 Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/archives Connection string: port=22402 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench Log file: /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata --log /Users/admin/pgsql/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 22350 # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --dlpath=/Users/admin/pgsql/build/src/test/regress --bindir= --host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench --port=22401 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data [07:50:27.246](183.735s) not ok 2 - regression tests pass [07:50:27.252](0.006s) # Failed test 'regression tests pass' # at /Users/admin/pgsql/src/test/recovery/t/027_stream_regress.pl line 74. [07:50:27.252](0.000s) # ---------- command failed ---------- [07:50:27.252](0.000s) # /Users/admin/pgsql/build/src/test/regress/pg_regress --dlpath=/Users/admin/pgsql/build/src/test/regress --bindir= --host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench --port=22401 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data [07:50:27.253](0.000s) # -------------- stdout -------------- [07:50:27.254](0.001s) # # using postmaster on /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench, port 22401 # ok 1 - test_setup 2087 ms # # parallel group (20 tests): varchar char oid pg_lsn int4 txid name regproc float4 int2 text money bit int8 boolean uuid float8 enum numeric rangetypes # ok 2 + boolean 1204 ms # ok 3 + char 601 ms # ok 4 + name 897 ms # ok 5 + varchar 568 ms # ok 6 + text 979 ms # ok 7 + int2 935 ms # ok 8 + int4 884 ms # ok 9 + int8 1139 ms # ok 10 + oid 603 ms # ok 11 + float4 884 ms # ok 12 + float8 1343 ms # ok 13 + bit 1060 ms # ok 14 + numeric 3150 ms # ok 15 + txid 824 ms # ok 16 + uuid 1240 ms # ok 17 + enum 1700 ms # ok 18 + money 1005 ms # ok 19 + rangetypes 3171 ms # ok 20 + pg_lsn 537 ms # ok 21 + regproc 787 ms # # parallel group (20 tests): md5 macaddr circle timetz path time line lseg numerology point macaddr8 inet timestamp date interval polygon box timestamptz strings multirangetypes # ok 22 + strings 1772 ms # ok 23 + md5 388 ms # ok 24 + numerology 640 ms # ok 25 + point 653 ms # ok 26 + lseg 611 ms # ok 27 + line 585 ms [07:50:27.254](0.000s) # ... 206 lines omitted ... [07:50:27.254](0.000s) # ok 219 + partition_merge 5795 ms # ok 220 + partition_split 6023 ms # ok 221 + partition_join 8697 ms # ok 222 + partition_prune 8556 ms # ok 223 + reloptions 1206 ms # ok 224 + hash_part 929 ms # ok 225 + indexing 10477 ms # ok 226 + partition_aggregate 5779 ms # ok 227 + partition_info 1421 ms # ok 228 + tuplesort 5546 ms # ok 229 + explain 1163 ms # ok 230 + memoize 3777 ms # ok 231 + stats 6991 ms # ok 232 + predicate 2512 ms # ok 233 + numa 373 ms # ok 234 + eager_aggregate 2975 ms # ok 235 + graph_table_rls 2610 ms # ok 236 + planner_est 573 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 1024 ms # ok 238 + compression_lz4 846 ms # ok 239 + compression_pglz 250 ms # ok 240 + cluster 1646 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1211 ms # ok 242 + event_trigger 1514 ms # ok 243 - event_trigger_login 192 ms # ok 244 - fast_default 1334 ms # ok 245 - tablespace 3405 ms # 1..245 [07:50:27.254](0.000s) # -------------- stderr -------------- [07:50:27.254](0.000s) # # diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out # # --- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:02 # # +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-05-03 07:48:49 # # @@ -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 "/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/regression.diffs". # # A copy of the test summary that you see above is saved in the file "/Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/regression.out". [07:50:27.254](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench --port 22401 /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench:22401 - accepting connections # Running: pg_isready --timeout 180 --host /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench --port 22402 /var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/jkslPhench:22402 - accepting connections [07:50:27.760](0.505s) ok 3 - primary alive after regression test run [07:50:27.760](0.000s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 9 1 5 9 1 5 1 1 3 4 3 4 4 1 1 32 1 1 4001 1 41 1 -1 6 1 104 1 -1 2 1 -32768 32767 2 5 1 1006 1 -2 46 33 35 1 2 1 1 5 17 Waiting for replication conn standby_1's replay_lsn to pass 0/172E4CB8 on primary done # Running: pg_dumpall --file /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/primary.dump --no-sync --no-statistics --restrict-key test --port 22401 --no-unlogged-table-data [07:50:36.109](8.349s) ok 5 - dump primary server # Running: pg_dumpall --file /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/standby.dump --no-sync --no-statistics --restrict-key test --port 22402 [07:50:47.880](11.771s) ok 6 - dump standby server [07:50:48.317](0.437s) ok 7 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /Users/admin/pgsql/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 32958 Waiting for replication conn standby_1's replay_lsn to pass 0/175B3E68 on primary done # Running: pg_dump --schema pg_catalog --file /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/catalogs_primary.dump --no-sync --restrict-key test --port 22401 --no-unlogged-table-data regression [07:50:55.559](7.242s) ok 8 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog --file /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/catalogs_standby.dump --no-sync --restrict-key test --port 22402 regression [07:51:04.415](8.856s) ok 9 - dump catalogs of standby server [07:51:04.477](0.062s) ok 10 - compare primary and standby catalog dumps [07:51:05.331](0.855s) ok 11 - check contents of pg_stat_statements on regression database ### Stopping node "standby_1" using mode fast # Running: pg_ctl --pgdata /Users/admin/pgsql/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 /Users/admin/pgsql/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:05.593](0.261s) 1..11 [07:51:05.595](0.002s) # Looks like you failed 1 test of 11.