# Checking port 23773 # Found port 23773 Name: primary Version: 19devel Data directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/backup Archive directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/archives Connection string: port=23773 host=/tmp/mwJuq6GrX7 Log file: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/log/027_stream_regress_primary.log [05:32:47.735](0.054s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/tmp_install/initdb-template /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata # Running: /tmp/cirrus-ci-build/src/test/recovery/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata --log /tmp/cirrus-ci-build/src/test/recovery/tmp_check/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 49573 (standby_1,) [05:32:48.314](0.578s) 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/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/backup/my_backup --host /tmp/mwJuq6GrX7 --port 23773 --checkpoint fast # Backup finished # Checking port 23774 # Found port 23774 Name: standby_1 Version: 19devel Data directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/backup Archive directory: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/archives Connection string: port=23774 host=/tmp/mwJuq6GrX7 Log file: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/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/src/test/recovery/tmp_check/t_027_stream_regress_standby_1_data/pgdata --log /tmp/cirrus-ci-build/src/test/recovery/tmp_check/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 49705 # Running: /tmp/cirrus-ci-build/src/test/recovery/../../../src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/src/test/regress --bindir= --host=/tmp/mwJuq6GrX7 --port=23773 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/src/test/recovery/tmp_check [05:35:27.547](159.233s) not ok 2 - regression tests pass [05:35:27.547](0.001s) [05:35:27.547](0.000s) # Failed test 'regression tests pass' # at t/027_stream_regress.pl line 74. [05:35:27.548](0.000s) # ---------- command failed ---------- [05:35:27.548](0.000s) # /tmp/cirrus-ci-build/src/test/recovery/../../../src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/src/test/regress --bindir= --host=/tmp/mwJuq6GrX7 --port=23773 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/src/test/recovery/tmp_check [05:35:27.548](0.000s) # -------------- stdout -------------- [05:35:27.548](0.000s) # # using postmaster on /tmp/mwJuq6GrX7, port 23773 # ok 1 - test_setup 1561 ms # # parallel group (20 tests): char int2 name varchar oid int4 boolean text pg_lsn txid money float4 int8 regproc float8 bit uuid enum numeric rangetypes # ok 2 + boolean 619 ms # ok 3 + char 332 ms # ok 4 + name 500 ms # ok 5 + varchar 508 ms # ok 6 + text 613 ms # ok 7 + int2 454 ms # ok 8 + int4 571 ms # ok 9 + int8 899 ms # ok 10 + oid 496 ms # ok 11 + float4 860 ms # ok 12 + float8 1049 ms # ok 13 + bit 1153 ms # ok 14 + numeric 4767 ms # ok 15 + txid 613 ms # ok 16 + uuid 1249 ms # ok 17 + enum 1313 ms # ok 18 + money 710 ms # ok 19 + rangetypes 5045 ms # ok 20 + pg_lsn 502 ms # ok 21 + regproc 850 ms # # parallel group (20 tests): md5 lseg path line time circle timetz point macaddr numerology macaddr8 date inet timestamp interval timestamptz polygon strings box multirangetypes # ok 22 + strings 2553 ms # ok 23 + md5 241 ms # ok 24 + numerology 842 ms # ok 25 + point 678 ms # ok 26 + lseg 277 ms # ok 27 + line 406 ms [05:35:27.548](0.000s) # ... 207 lines omitted ... [05:35:27.548](0.000s) # ok 220 + partition_merge 5493 ms # ok 221 + partition_split 6425 ms # ok 222 + partition_join 6929 ms # ok 223 + partition_prune 7458 ms # ok 224 + reloptions 721 ms # ok 225 + hash_part 473 ms # ok 226 + indexing 8924 ms # ok 227 + partition_aggregate 5326 ms # ok 228 + partition_info 1258 ms # ok 229 + tuplesort 6590 ms # ok 230 + explain 1037 ms # ok 231 + memoize 4128 ms # ok 232 + stats 6439 ms # ok 233 + predicate 1113 ms # ok 234 + numa 307 ms # ok 235 + eager_aggregate 2744 ms # ok 236 + graph_table_rls 1429 ms # ok 237 + planner_est 397 ms # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster # ok 238 + compression 661 ms # ok 239 + compression_lz4 741 ms # ok 240 + compression_pglz 89 ms # ok 241 + cluster 1322 ms # # parallel group (2 tests): oidjoins event_trigger # ok 242 + oidjoins 1079 ms # ok 243 + event_trigger 1232 ms # ok 244 - event_trigger_login 111 ms # ok 245 - fast_default 790 ms # ok 246 - tablespace 2410 ms # 1..246 [05:35:27.548](0.000s) # -------------- stderr -------------- [05:35:27.548](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-05-06 05:24:43.631583987 +0000 # # +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-05-06 05:34:25.089296124 +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:35:27.549](0.000s) # ... 16 lines omitted ... [05:35:27.549](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/src/test/recovery/tmp_check/regression.diffs". # # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/src/test/recovery/tmp_check/regression.out". [05:35:27.549](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/mwJuq6GrX7 --port 23773 /tmp/mwJuq6GrX7:23773 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/mwJuq6GrX7 --port 23774 /tmp/mwJuq6GrX7:23774 - accepting connections [05:35:27.645](0.096s) ok 3 - primary alive after regression test run [05:35:27.645](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 32 1 1 4001 1 6 104 2 1 1 1 2 5 41 1 1 1006 -1 1 1 -1 -32768 32767 -2 9 1 46 1 1 1 2 1 1 5 17 33 35 Waiting for replication conn standby_1's replay_lsn to pass 0/16D52330 on primary done # Running: pg_dumpall --file /tmp/cirrus-ci-build/src/test/recovery/tmp_check/primary.dump --no-sync --no-statistics --restrict-key test --port 23773 --no-unlogged-table-data [05:35:32.779](5.134s) ok 5 - dump primary server # Running: pg_dumpall --file /tmp/cirrus-ci-build/src/test/recovery/tmp_check/standby.dump --no-sync --no-statistics --restrict-key test --port 23774 [05:35:38.356](5.577s) ok 6 - dump standby server [05:35:38.507](0.151s) ok 7 - compare primary and standby dumps ### Restarting node "primary" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/src/test/recovery/tmp_check/t_027_stream_regress_primary_data/pgdata --log /tmp/cirrus-ci-build/src/test/recovery/tmp_check/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 61956 Waiting for replication conn standby_1's replay_lsn to pass 0/17934080 on primary done # Running: pg_dump --schema pg_catalog --file /tmp/cirrus-ci-build/src/test/recovery/tmp_check/catalogs_primary.dump --no-sync --restrict-key test --port 23773 --no-unlogged-table-data regression [05:35:44.230](5.723s) ok 8 - dump catalogs of primary server # Running: pg_dump --schema pg_catalog --file /tmp/cirrus-ci-build/src/test/recovery/tmp_check/catalogs_standby.dump --no-sync --restrict-key test --port 23774 regression [05:35:50.343](6.113s) ok 9 - dump catalogs of standby server [05:35:50.387](0.044s) ok 10 - compare primary and standby catalog dumps [05:35:50.816](0.428s) 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/src/test/recovery/tmp_check/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/src/test/recovery/tmp_check/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:35:51.040](0.224s) 1..11 [05:35:51.042](0.002s) # Looks like you failed 1 test of 11.