# Checking port 30063 # Found port 30063 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=30063 host=/tmp/HHbWelI2tV Log file: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [05:29:36.080](0.032s) # 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 36146 (standby_1,) [05:29:38.828](2.749s) 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/HHbWelI2tV --port 30063 --checkpoint fast # Backup finished # Checking port 30064 # Found port 30064 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=30064 host=/tmp/HHbWelI2tV 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 36293 # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/HHbWelI2tV --port=30063 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [05:31:22.489](103.661s) not ok 2 - regression tests pass [05:31:22.490](0.000s) # Failed test 'regression tests pass' # at /tmp/cirrus-ci-build/src/test/recovery/t/027_stream_regress.pl line 74. [05:31:22.490](0.000s) # ---------- command failed ---------- [05:31:22.490](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/HHbWelI2tV --port=30063 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [05:31:22.490](0.000s) # -------------- stdout -------------- [05:31:22.490](0.000s) # # using postmaster on /tmp/HHbWelI2tV, port 30063 # ok 1 - test_setup 1051 ms # # parallel group (20 tests): varchar char oid txid pg_lsn name text int4 int2 money regproc float4 boolean int8 float8 uuid bit enum numeric rangetypes # ok 2 + boolean 344 ms # ok 3 + char 177 ms # ok 4 + name 235 ms # ok 5 + varchar 63 ms # ok 6 + text 263 ms # ok 7 + int2 287 ms # ok 8 + int4 281 ms # ok 9 + int8 413 ms # ok 10 + oid 183 ms # ok 11 + float4 317 ms # ok 12 + float8 495 ms # ok 13 + bit 547 ms # ok 14 + numeric 1588 ms # ok 15 + txid 208 ms # ok 16 + uuid 536 ms # ok 17 + enum 618 ms # ok 18 + money 281 ms # ok 19 + rangetypes 1640 ms # ok 20 + pg_lsn 211 ms # ok 21 + regproc 291 ms # # parallel group (20 tests): md5 macaddr8 circle lseg path line point timetz time macaddr numerology date inet interval timestamp timestamptz strings box polygon multirangetypes # ok 22 + strings 1006 ms # ok 23 + md5 90 ms # ok 24 + numerology 361 ms # ok 25 + point 201 ms # ok 26 + lseg 145 ms # ok 27 + line 195 ms [05:31:22.490](0.000s) # ... 207 lines omitted ... [05:31:22.490](0.000s) # ok 220 + partition_merge 6428 ms # ok 221 + partition_split 7355 ms # ok 222 + partition_join 7557 ms # ok 223 + partition_prune 8180 ms # ok 224 + reloptions 469 ms # ok 225 + hash_part 423 ms # ok 226 + indexing 9965 ms # ok 227 + partition_aggregate 4571 ms # ok 228 + partition_info 1162 ms # ok 229 + tuplesort 4842 ms # ok 230 + explain 866 ms # ok 231 + memoize 3899 ms # ok 232 + stats 6675 ms # ok 233 + predicate 657 ms # ok 234 + numa 175 ms # ok 235 + eager_aggregate 2293 ms # ok 236 + graph_table_rls 885 ms # ok 237 + planner_est 249 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 238 + compression 862 ms # ok 239 + compression_lz4 780 ms # ok 240 + compression_pglz 85 ms # ok 241 + cluster 1402 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 1929 ms # ok 243 + event_trigger 2182 ms # ok 244 - event_trigger_login 142 ms # ok 245 - fast_default 735 ms # ok 246 - tablespace 2803 ms # 1..246 [05:31:22.490](0.000s) # -------------- stderr -------------- [05:31:22.490](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-05-06 05:24:40.599773884 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-05-06 05:30:25.179899272 +0000 # # @@ -139,8 +139,8 @@ # # JOIN dim3 ON fact.dim3_id = dim3.id # # JOIN dim4 ON fact.dim4_id = dim4.id # # WHERE dim1.id < 5; # # - QUERY PLAN # # ---------------------------------------------------------------------- # # + QUERY PLAN # # +--------------------------------------------------------------------------- # # Aggregate # # -> Nested Loop # # Join Filter: (fact.dim4_id = dim4.id) # # @@ -149,15 +149,15 @@ # # -> Seq Scan on dim3 # # -> Hash # # -> Hash Join # # - Hash Cond: (fact.dim1_id = dim1.id) # # - -> Hash Join # # - Hash Cond: (fact.dim2_id = dim2.id) # # - -> Seq Scan on fact # # - -> Hash # # - -> Seq Scan on dim2 # # + Hash Cond: (dim2.id = fact.dim2_id) # # + -> Seq Scan on dim2 # # -> Hash # # - -> Seq Scan on dim1 # # - Filter: (id < 5) # # + -> Hash Join [05:31:22.490](0.000s) # ... 16 lines omitted ... [05:31:22.491](0.000s) # # Aggregate # # -> Hash Join # # Hash Cond: (t2.a = t1.a) # # - -> Nested Loop # # - -> Hash Join # # - Hash Cond: (t6.e = t5.f) # # - -> Seq Scan on t6 # # - -> Hash # # - -> Seq Scan on t5 # # - Filter: (d < 3) # # - -> Seq Scan on t2 # # + -> Seq Scan on t2 # # -> Hash # # - -> Seq Scan on t1 # # - Filter: (a < 5) # # + -> Nested Loop # # + -> Hash Join # # + Hash Cond: (t6.e = t5.f) # # + -> Seq Scan on t6 # # + -> Hash # # + -> Seq Scan on t5 # # + Filter: (d < 3) # # + -> Seq Scan on t1 # # + Filter: (a < 5) # # (14 rows) # # # # -- # # 1 of 246 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". [05:31:22.491](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/HHbWelI2tV --port 30063 /tmp/HHbWelI2tV:30063 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/HHbWelI2tV --port 30064 /tmp/HHbWelI2tV:30064 - accepting connections [05:31:22.616](0.126s) ok 3 - primary alive after regression test run [05:31:22.617](0.001s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 1 9 5 5 3 4 3 4 4 1 32 1 1 4001 1 6 104 2 1 2 5 41 1006 1 1 -1 1 2 1 1 -1 -32768 1 1 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/16656FE0 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 30063 --no-unlogged-table-data [05:31:28.002](5.385s) 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 30064 [05:31:35.652](7.650s) ok 6 - dump standby server [05:31:35.932](0.280s) 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 51684 Waiting for replication conn standby_1's replay_lsn to pass 0/16FC7788 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 30063 --no-unlogged-table-data regression [05:31:42.734](6.803s) 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 30064 regression [05:31:50.842](8.107s) ok 9 - dump catalogs of standby server [05:31:50.976](0.134s) ok 10 - compare primary and standby catalog dumps [05:31:51.498](0.522s) 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" [05:31:51.730](0.232s) 1..11 [05:31:51.732](0.002s) # Looks like you failed 1 test of 11.