# Checking port 18593 # Found port 18593 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=18593 host=/tmp/erVNrndRVZ Log file: /tmp/cirrus-ci-build/src/test/recovery/tmp_check/log/027_stream_regress_primary.log [07:20:05.428](0.041s) # 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 53692 (standby_1,) [07:20:05.864](0.436s) 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/erVNrndRVZ --port 18593 --checkpoint fast # Backup finished # Checking port 18594 # Found port 18594 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=18594 host=/tmp/erVNrndRVZ 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 53825 # Running: /tmp/cirrus-ci-build/src/test/recovery/../../../src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/src/test/regress --bindir= --host=/tmp/erVNrndRVZ --port=18593 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/src/test/recovery/tmp_check [07:22:35.187](149.323s) not ok 2 - regression tests pass [07:22:35.188](0.001s) [07:22:35.188](0.000s) # Failed test 'regression tests pass' # at t/027_stream_regress.pl line 74. [07:22:35.188](0.000s) # ---------- command failed ---------- [07:22:35.188](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/erVNrndRVZ --port=18593 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/src/test/recovery/tmp_check [07:22:35.188](0.000s) # -------------- stdout -------------- [07:22:35.188](0.000s) # # using postmaster on /tmp/erVNrndRVZ, port 18593 # ok 1 - test_setup 2861 ms # # parallel group (20 tests): varchar char oid name text int2 int4 pg_lsn txid boolean float4 money regproc int8 float8 bit enum uuid numeric rangetypes # ok 2 + boolean 598 ms # ok 3 + char 363 ms # ok 4 + name 434 ms # ok 5 + varchar 332 ms # ok 6 + text 432 ms # ok 7 + int2 462 ms # ok 8 + int4 490 ms # ok 9 + int8 788 ms # ok 10 + oid 356 ms # ok 11 + float4 605 ms # ok 12 + float8 798 ms # ok 13 + bit 1001 ms # ok 14 + numeric 2887 ms # ok 15 + txid 470 ms # ok 16 + uuid 1041 ms # ok 17 + enum 969 ms # ok 18 + money 604 ms # ok 19 + rangetypes 3139 ms # ok 20 + pg_lsn 432 ms # ok 21 + regproc 615 ms # # parallel group (20 tests): md5 lseg circle path line point time macaddr macaddr8 timetz numerology date inet timestamp interval timestamptz strings polygon box multirangetypes # ok 22 + strings 1573 ms # ok 23 + md5 171 ms # ok 24 + numerology 600 ms # ok 25 + point 414 ms # ok 26 + lseg 200 ms # ok 27 + line 389 ms [07:22:35.188](0.000s) # ... 206 lines omitted ... [07:22:35.188](0.000s) # ok 219 + partition_merge 5615 ms # ok 220 + partition_split 8009 ms # ok 221 + partition_join 8704 ms # ok 222 + partition_prune 10090 ms # ok 223 + reloptions 570 ms # ok 224 + hash_part 458 ms # ok 225 + indexing 12883 ms # ok 226 + partition_aggregate 5417 ms # ok 227 + partition_info 1199 ms # ok 228 + tuplesort 8433 ms # ok 229 + explain 1067 ms # ok 230 + memoize 4161 ms # ok 231 + stats 7691 ms # ok 232 + predicate 1230 ms # ok 233 + numa 270 ms # ok 234 + eager_aggregate 2936 ms # ok 235 + graph_table_rls 1601 ms # ok 236 + planner_est 386 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 713 ms # ok 238 + compression_lz4 682 ms # ok 239 + compression_pglz 85 ms # ok 240 + cluster 1372 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1364 ms # ok 242 + event_trigger 1595 ms # ok 243 - event_trigger_login 123 ms # ok 244 - fast_default 709 ms # ok 245 - tablespace 2138 ms # 1..245 [07:22:35.189](0.000s) # -------------- stderr -------------- [07:22:35.189](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/for_portion_of.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:03.251281978 +0000 # # +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/for_portion_of.out 2026-05-05 07:20:40.450907440 +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 "/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". [07:22:35.189](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/erVNrndRVZ --port 18593 /tmp/erVNrndRVZ:18593 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/erVNrndRVZ --port 18594 /tmp/erVNrndRVZ:18594 - accepting connections [07:22:35.283](0.094s) ok 3 - primary alive after regression test run [07:22:35.283](0.000s) ok 4 - standby alive after regression test run 1 1 1 1 1 1 2 1 1 9 5 5 1 1 -1 1 1 -1 -32768 3 4 3 4 4 1 32767 32 1 1 4001 1 6 104 2 1 2 5 -2 46 1006 9 1 1 2 1 1 1 1 41 5 17 33 35 Waiting for replication conn standby_1's replay_lsn to pass 0/1705D4A0 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 18593 --no-unlogged-table-data [07:22:39.387](4.104s) 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 18594 [07:22:43.473](4.087s) ok 6 - dump standby server [07:22:43.608](0.134s) 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 65724 Waiting for replication conn standby_1's replay_lsn to pass 0/175031D8 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 18593 --no-unlogged-table-data regression [07:22:48.082](4.474s) 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 18594 regression [07:22:52.198](4.116s) ok 9 - dump catalogs of standby server [07:22:52.240](0.043s) ok 10 - compare primary and standby catalog dumps [07:22:52.658](0.418s) 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" [07:22:52.874](0.216s) 1..11 [07:22:52.876](0.002s) # Looks like you failed 1 test of 11.