# Checking port 26327 # Found port 26327 Name: primary Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/archives Connection string: port=26327 host=/tmp/y6l3PD5KB3 Log file: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [07:46:30.578](0.054s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --auth trust -c io_method=io_uring The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: C.UTF-8 LC_CTYPE: C.UTF-8 LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C LC_TIME: C.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /tmp/cirrus-ci-build/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 39784 (standby_1,) [07:46:33.043](2.466s) ok 1 - physical slot created on primary # Taking pg_basebackup my_backup from node "primary" # Running: pg_basebackup --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/backup/my_backup --host /tmp/y6l3PD5KB3 --port 26327 --checkpoint fast # Backup finished # Checking port 26328 # Found port 26328 Name: standby_1 Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/archives Connection string: port=26328 host=/tmp/y6l3PD5KB3 Log file: /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_standby_1_data/pgdata --log /tmp/cirrus-ci-build/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 39974 # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/y6l3PD5KB3 --port=26327 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [07:47:58.632](85.588s) not ok 2 - regression tests pass [07:47:58.632](0.000s) # Failed test 'regression tests pass' # at /tmp/cirrus-ci-build/src/test/recovery/t/027_stream_regress.pl line 74. [07:47:58.632](0.000s) # ---------- command failed ---------- [07:47:58.632](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/y6l3PD5KB3 --port=26327 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [07:47:58.632](0.000s) # -------------- stdout -------------- [07:47:58.632](0.000s) # # using postmaster on /tmp/y6l3PD5KB3, port 26327 # ok 1 - test_setup 470 ms # # parallel group (20 tests): text char varchar name txid oid pg_lsn float4 int2 int4 boolean money regproc int8 float8 bit uuid enum rangetypes numeric # ok 2 + boolean 325 ms # ok 3 + char 162 ms # ok 4 + name 199 ms # ok 5 + varchar 180 ms # ok 6 + text 152 ms # ok 7 + int2 281 ms # ok 8 + int4 299 ms # ok 9 + int8 362 ms # ok 10 + oid 203 ms # ok 11 + float4 257 ms # ok 12 + float8 411 ms # ok 13 + bit 425 ms # ok 14 + numeric 1417 ms # ok 15 + txid 197 ms # ok 16 + uuid 502 ms # ok 17 + enum 504 ms # ok 18 + money 291 ms # ok 19 + rangetypes 1093 ms # ok 20 + pg_lsn 172 ms # ok 21 + regproc 309 ms # # parallel group (20 tests): md5 lseg line path circle point timetz macaddr time numerology macaddr8 inet interval date timestamp strings timestamptz polygon box multirangetypes # ok 22 + strings 856 ms # ok 23 + md5 91 ms # ok 24 + numerology 311 ms # ok 25 + point 173 ms # ok 26 + lseg 117 ms # ok 27 + line 117 ms [07:47:58.632](0.000s) # ... 206 lines omitted ... [07:47:58.633](0.000s) # ok 219 + partition_merge 5668 ms # ok 220 + partition_split 6385 ms # ok 221 + partition_join 6891 ms # ok 222 + partition_prune 7317 ms # ok 223 + reloptions 423 ms # ok 224 + hash_part 287 ms # ok 225 + indexing 8813 ms # ok 226 + partition_aggregate 4278 ms # ok 227 + partition_info 1158 ms # ok 228 + tuplesort 4219 ms # ok 229 + explain 645 ms # ok 230 + memoize 3939 ms # ok 231 + stats 6035 ms # ok 232 + predicate 782 ms # ok 233 + numa 179 ms # ok 234 + eager_aggregate 2144 ms # ok 235 + graph_table_rls 996 ms # ok 236 + planner_est 224 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 771 ms # ok 238 + compression_lz4 715 ms # ok 239 + compression_pglz 69 ms # ok 240 + cluster 1503 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1909 ms # ok 242 + event_trigger 2081 ms # ok 243 - event_trigger_login 136 ms # ok 244 - fast_default 657 ms # ok 245 - tablespace 2833 ms # 1..245 [07:47:58.633](0.000s) # -------------- stderr -------------- [07:47:58.633](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.065096072 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-05-03 07:47:13.455672150 +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 "/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/regression.diffs". # # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/regression.out". [07:47:58.633](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/y6l3PD5KB3 --port 26327 /tmp/y6l3PD5KB3:26327 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/y6l3PD5KB3 --port 26328 /tmp/y6l3PD5KB3:26328 - accepting connections [07:47:58.723](0.090s) ok 3 - primary alive after regression test run [07:47:58.723](0.000s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 1 9 5 5 3 4 3 4 4 1 4001 32 1 1 1 6 104 2 1 2 5 1006 1 2 1 1 41 5 17 -2 9 1 1 1 1 1 -1 1 1 -1 -32768 32767 46 1 1 33 35 Waiting for replication conn standby_1's replay_lsn to pass 0/1614D548 on primary done # Running: pg_dumpall --file /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/primary.dump --no-sync --no-statistics --restrict-key test --port 26327 --no-unlogged-table-data [07:48:04.249](5.526s) ok 5 - dump primary server # Running: pg_dumpall --file /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/standby.dump --no-sync --no-statistics --restrict-key test --port 26328 [07:48:09.282](5.033s) ok 6 - dump standby server [07:48:09.712](0.430s) ok 7 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/t_027_stream_regress_primary_data/pgdata --log /tmp/cirrus-ci-build/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 54179 Waiting for replication conn standby_1's replay_lsn to pass 0/16AB2D98 on primary done # Running: pg_dump --schema pg_catalog --file /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/catalogs_primary.dump --no-sync --restrict-key test --port 26327 --no-unlogged-table-data regression [07:48:14.911](5.199s) ok 8 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog --file /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/catalogs_standby.dump --no-sync --restrict-key test --port 26328 regression [07:48:21.124](6.213s) ok 9 - dump catalogs of standby server [07:48:21.241](0.117s) ok 10 - compare primary and standby catalog dumps [07:48:21.821](0.580s) ok 11 - check contents of pg_stat_statements on regression database ### Stopping node "standby_1" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/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 /tmp/cirrus-ci-build/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:48:22.042](0.221s) 1..11 [07:48:22.046](0.004s) # Looks like you failed 1 test of 11.