# Checking port 18424 # Found port 18424 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=18424 host=/tmp/dJlOnc0dAZ Log file: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [07:13:37.991](0.018s) # 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 debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress 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: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: C LC_TIME: en_US.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 ... 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 36876 (standby_1,) [07:13:40.059](2.068s) 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/dJlOnc0dAZ --port 18424 --checkpoint fast # Backup finished # Checking port 18425 # Found port 18425 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=18425 host=/tmp/dJlOnc0dAZ 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 37009 # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/dJlOnc0dAZ --port=18424 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [07:17:58.544](258.485s) not ok 2 - regression tests pass [07:17:58.544](0.000s) # Failed test 'regression tests pass' # at /tmp/cirrus-ci-build/src/test/recovery/t/027_stream_regress.pl line 74. [07:17:58.544](0.000s) # ---------- command failed ---------- [07:17:58.545](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/dJlOnc0dAZ --port=18424 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [07:17:58.545](0.000s) # -------------- stdout -------------- [07:17:58.545](0.000s) # # using postmaster on /tmp/dJlOnc0dAZ, port 18424 # ok 1 - test_setup 681 ms # # parallel group (20 tests): oid char txid varchar pg_lsn name int2 text float4 uuid int4 boolean int8 enum money bit regproc float8 rangetypes numeric # ok 2 + boolean 502 ms # ok 3 + char 160 ms # ok 4 + name 230 ms # ok 5 + varchar 195 ms # ok 6 + text 440 ms # ok 7 + int2 334 ms # ok 8 + int4 496 ms # ok 9 + int8 618 ms # ok 10 + oid 103 ms # ok 11 + float4 455 ms # ok 12 + float8 2911 ms # ok 13 + bit 1394 ms # ok 14 + numeric 12068 ms # ok 15 + txid 185 ms # ok 16 + uuid 470 ms # ok 17 + enum 934 ms # ok 18 + money 1296 ms # ok 19 + rangetypes 7164 ms # ok 20 + pg_lsn 199 ms # ok 21 + regproc 1980 ms # # parallel group (20 tests): lseg circle time path macaddr md5 line timetz point macaddr8 numerology inet polygon timestamp box date interval timestamptz strings multirangetypes # ok 22 + strings 8326 ms # ok 23 + md5 333 ms # ok 24 + numerology 1065 ms # ok 25 + point 805 ms # ok 26 + lseg 110 ms # ok 27 + line 412 ms [07:17:58.545](0.000s) # ... 206 lines omitted ... [07:17:58.545](0.000s) # ok 219 + partition_merge 9860 ms # ok 220 + partition_split 7184 ms # ok 221 + partition_join 7029 ms # ok 222 + partition_prune 14288 ms # ok 223 + reloptions 1249 ms # ok 224 + hash_part 1011 ms # ok 225 + indexing 13359 ms # ok 226 + partition_aggregate 6490 ms # ok 227 + partition_info 2345 ms # ok 228 + tuplesort 4552 ms # ok 229 + explain 1316 ms # ok 230 + memoize 5272 ms # ok 231 + stats 7365 ms # ok 232 + predicate 2042 ms # ok 233 + numa 191 ms # ok 234 + eager_aggregate 2512 ms # ok 235 + graph_table_rls 1847 ms # ok 236 + planner_est 685 ms # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster # ok 237 + compression 1612 ms # ok 238 + compression_lz4 1491 ms # ok 239 + compression_pglz 29 ms # ok 240 + cluster 2587 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 1153 ms # ok 242 + event_trigger 1949 ms # ok 243 - event_trigger_login 177 ms # ok 244 - fast_default 1913 ms # ok 245 - tablespace 6222 ms # 1..245 [07:17:58.545](0.000s) # -------------- stderr -------------- [07:17:58.546](0.000s) # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out # # --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:03.195678000 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:14:37.341720000 +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/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:17:58.546](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/dJlOnc0dAZ --port 18424 /tmp/dJlOnc0dAZ:18424 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/dJlOnc0dAZ --port 18425 /tmp/dJlOnc0dAZ:18425 - accepting connections [07:17:58.614](0.069s) ok 3 - primary alive after regression test run [07:17:58.615](0.001s) ok 4 - standby alive after regression test run 1 1 1 1 1 1 2 1 1 9 -1 5 5 5 1 17 -1 -32768 3 4 3 4 4 1 32 4001 1 1 1 41 6 104 2 1 33 35 1 1 2 5 1006 1 1 -2 9 1 46 1 32767 1 2 1 1 Waiting for replication conn standby_1's replay_lsn to pass 0/170F50F0 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 18424 --no-unlogged-table-data [07:18:15.190](16.575s) 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 18425 [07:18:27.184](11.994s) ok 6 - dump standby server [07:18:27.344](0.160s) 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 42817 Waiting for replication conn standby_1's replay_lsn to pass 0/17B64118 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 18424 --no-unlogged-table-data regression [07:19:09.267](41.923s) 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 18425 regression [07:19:45.232](35.965s) ok 9 - dump catalogs of standby server [07:19:45.272](0.040s) ok 10 - compare primary and standby catalog dumps [07:19:45.428](0.156s) 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:19:45.639](0.211s) 1..11 [07:19:45.641](0.001s) # Looks like you failed 1 test of 11.