# Checking port 17744 # Found port 17744 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=17744 host=/tmp/lxjJblO3X9 Log file: /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/log/027_stream_regress_primary.log [07:16:23.789](0.020s) # 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 36755 (standby_1,) [07:16:26.432](2.644s) 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/lxjJblO3X9 --port 17744 --checkpoint fast # Backup finished # Checking port 17745 # Found port 17745 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=17745 host=/tmp/lxjJblO3X9 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 36956 # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/lxjJblO3X9 --port=17744 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [07:18:00.068](93.635s) not ok 2 - regression tests pass [07:18:00.068](0.000s) # Failed test 'regression tests pass' # at /tmp/cirrus-ci-build/src/test/recovery/t/027_stream_regress.pl line 74. [07:18:00.068](0.000s) # ---------- command failed ---------- [07:18:00.068](0.000s) # /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --dlpath=/tmp/cirrus-ci-build/build/src/test/regress --bindir= --host=/tmp/lxjJblO3X9 --port=17744 --schedule=../regress/parallel_schedule --max-concurrent-tests=20 --inputdir=../regress --outputdir=/tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data [07:18:00.068](0.000s) # -------------- stdout -------------- [07:18:00.068](0.000s) # # using postmaster on /tmp/lxjJblO3X9, port 17744 # ok 1 - test_setup 901 ms # # parallel group (20 tests): varchar oid char name txid pg_lsn int2 money text int4 boolean float4 float8 regproc int8 bit enum uuid numeric rangetypes # ok 2 + boolean 306 ms # ok 3 + char 203 ms # ok 4 + name 209 ms # ok 5 + varchar 181 ms # ok 6 + text 270 ms # ok 7 + int2 260 ms # ok 8 + int4 274 ms # ok 9 + int8 383 ms # ok 10 + oid 175 ms # ok 11 + float4 338 ms # ok 12 + float8 351 ms # ok 13 + bit 461 ms # ok 14 + numeric 1226 ms # ok 15 + txid 192 ms # ok 16 + uuid 559 ms # ok 17 + enum 533 ms # ok 18 + money 233 ms # ok 19 + rangetypes 1526 ms # ok 20 + pg_lsn 229 ms # ok 21 + regproc 331 ms # # parallel group (20 tests): md5 lseg path line time circle timetz point macaddr8 macaddr numerology inet date interval timestamp strings timestamptz box polygon multirangetypes # ok 22 + strings 815 ms # ok 23 + md5 108 ms # ok 24 + numerology 368 ms # ok 25 + point 264 ms # ok 26 + lseg 107 ms # ok 27 + line 138 ms [07:18:00.068](0.000s) # ... 206 lines omitted ... [07:18:00.070](0.002s) # ok 219 + partition_merge 5923 ms # ok 220 + partition_split 7286 ms # ok 221 + partition_join 7456 ms # ok 222 + partition_prune 8103 ms # ok 223 + reloptions 273 ms # ok 224 + hash_part 304 ms # ok 225 + indexing 10407 ms # ok 226 + partition_aggregate 4852 ms # ok 227 + partition_info 1221 ms # ok 228 + tuplesort 3966 ms # ok 229 + explain 828 ms # ok 230 + memoize 3745 ms # ok 231 + stats 6449 ms # ok 232 + predicate 721 ms # ok 233 + numa 135 ms # ok 234 + eager_aggregate 2324 ms # ok 235 + graph_table_rls 1084 ms # ok 236 + planner_est 134 ms # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster # ok 237 + compression 587 ms # ok 238 + compression_lz4 648 ms # ok 239 + compression_pglz 70 ms # ok 240 + cluster 1423 ms # # parallel group (2 tests): oidjoins event_trigger # ok 241 + oidjoins 2077 ms # ok 242 + event_trigger 2259 ms # ok 243 - event_trigger_login 130 ms # ok 244 - fast_default 652 ms # ok 245 - tablespace 3741 ms # 1..245 [07:18:00.070](0.000s) # -------------- stderr -------------- [07:18:00.070](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:09.594871958 +0000 # # +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:16:41.812140645 +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:18:00.070](0.000s) # ------------------------------------ # Running: pg_isready --timeout 180 --host /tmp/lxjJblO3X9 --port 17744 /tmp/lxjJblO3X9:17744 - accepting connections # Running: pg_isready --timeout 180 --host /tmp/lxjJblO3X9 --port 17745 /tmp/lxjJblO3X9:17745 - accepting connections [07:18:00.156](0.086s) ok 3 - primary alive after regression test run [07:18:00.157](0.000s) ok 4 - standby alive after regression test run 1 1 1 1 1 2 5 1 5 9 3 4 3 4 4 1 32 1 1 1 6 104 2 1 4001 2 5 1006 1 2 1 1 41 5 17 -2 9 1 1 1 1 1 -1 1 1 -1 -32768 32767 1 46 1 33 35 Waiting for replication conn standby_1's replay_lsn to pass 0/16121BC8 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 17744 --no-unlogged-table-data [07:18:06.934](6.777s) 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 17745 [07:18:13.142](6.208s) ok 6 - dump standby server [07:18:13.486](0.344s) 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 51922 Waiting for replication conn standby_1's replay_lsn to pass 0/16AB9A98 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 17744 --no-unlogged-table-data regression [07:18:21.401](7.915s) 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 17745 regression [07:18:26.707](5.306s) ok 9 - dump catalogs of standby server [07:18:26.785](0.078s) ok 10 - compare primary and standby catalog dumps [07:18:27.167](0.383s) 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:18:27.504](0.336s) 1..11 [07:18:27.511](0.007s) # Looks like you failed 1 test of 11.