[17:24:13.233] su postgres <<-EOF [17:24:13.233] set -e [17:24:13.233] ulimit -c unlimited [17:24:13.233] meson test $MTEST_ARGS --num-processes ${TEST_JOBS} [17:24:13.233] EOF [17:24:14.438] 1/399 postgresql:setup / tmp_install OK 0.76s [17:24:14.497] 2/399 postgresql:setup / install_test_files OK 0.06s [17:24:16.147] 3/399 postgresql:setup / initdb_cache OK 1.65s [17:24:16.453] 4/399 postgresql:pg_upgrade / pg_upgrade/001_basic OK 0.28s 9 subtests passed [17:24:33.516] 5/399 postgresql:pg_upgrade / pg_upgrade/005_char_signedness OK 17.31s 16 subtests passed [17:24:51.942] 6/399 postgresql:pg_upgrade / pg_upgrade/003_logical_slots OK 35.76s 13 subtests passed [17:24:55.459] 7/399 postgresql:pg_upgrade / pg_upgrade/008_extension_control_path OK 21.94s 5 subtests passed [17:24:55.507] ▶ 8/399 + vacuum 3673 ms FAIL [17:24:55.507] ▶ 8/399 + updatable_views 9213 ms FAIL [17:24:56.684] 9/399 postgresql:pg_upgrade / pg_upgrade/004_subscription OK 40.49s 19 subtests passed [17:24:58.893] 10/399 postgresql:pg_upgrade / pg_upgrade/007_multixact_conversion OK 42.44s 3 subtests passed [17:25:13.259] 11/399 postgresql:recovery / recovery/002_archiving OK 16.57s 12 subtests passed [17:25:24.517] 12/399 postgresql:recovery / recovery/003_recovery_targets OK 25.62s 15 subtests passed [17:25:25.752] 13/399 postgresql:recovery / recovery/001_stream_rep OK 30.29s 64 subtests passed [17:25:37.313] 14/399 postgresql:recovery / recovery/004_timeline_switch OK 24.05s 5 subtests passed [17:25:38.059] 15/399 postgresql:recovery / recovery/006_logical_decoding OK 12.31s 20 subtests passed [17:25:41.658] 16/399 postgresql:recovery / recovery/005_replay_delay OK 17.14s 3 subtests passed [17:25:51.208] 17/399 postgresql:recovery / recovery/007_sync_rep OK 13.89s 11 subtests passed [17:25:56.197] 18/399 postgresql:recovery / recovery/008_fsm_truncation OK 18.13s 1 subtests passed [17:25:59.883] 19/399 postgresql:recovery / recovery/009_twophase OK 18.22s 30 subtests passed [17:26:00.095] 20/399 postgresql:recovery / recovery/010_logical_decoding_timelines OK 8.88s 13 subtests passed [17:26:07.347] 21/399 postgresql:recovery / recovery/014_unlogged_reinit OK 7.25s 23 subtests passed [17:26:09.213] 22/399 postgresql:recovery / recovery/012_subtransactions OK 13.02s 12 subtests passed [17:26:09.366] 23/399 postgresql:recovery / recovery/013_crash_restart OK 9.48s 20 subtests passed [17:26:19.412] 24/399 postgresql:recovery / recovery/015_promotion_pages OK 12.05s 1 subtests passed [17:26:19.951] 25/399 postgresql:recovery / recovery/017_shm OK 10.58s 4 subtests passed [17:26:20.229] 26/399 postgresql:recovery / recovery/016_min_consistency OK 11.02s 1 subtests passed [17:26:20.773] ▶ 8/399 + reloptions 697 ms FAIL [17:26:20.808] ▶ 8/399 + tuplesort 5915 ms FAIL [17:26:20.834] ▶ 8/399 + stats 4970 ms FAIL [17:26:27.557] ▶ 27/399 - regression tests in old instance FAIL [17:26:28.707] 8/399 postgresql:regress / regress/regress ERROR 132.55s exit status 1 [17:26:28.708] >>> LD_LIBRARY_PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/lib/x86_64-linux-gnu top_builddir=/tmp/cirrus-ci-build/build MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 INITDB_TEMPLATE=/tmp/cirrus-ci-build/build/tmp_install/initdb-template MALLOC_PERTURB_=189 REGRESS_SHLIB=/tmp/cirrus-ci-build/build/src/test/regress/regress.so PG_REGRESS=/tmp/cirrus-ci-build/build/src/test/regress/pg_regress MESON_TEST_ITERATION=1 PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/regress:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin /usr/bin/python3 /tmp/cirrus-ci-build/build/../src/tools/testwrap --basedir /tmp/cirrus-ci-build/build --srcdir /tmp/cirrus-ci-build/src/test/regress --pg-test-extra '' --testgroup regress --testname regress --schedule /tmp/cirrus-ci-build/build/../src/test/regress/parallel_schedule --tests -- /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --inputdir /tmp/cirrus-ci-build/src/test/regress --expecteddir /tmp/cirrus-ci-build/src/test/regress --bindir '' --dlpath /tmp/cirrus-ci-build/build/src/test/regress --max-concurrent-tests=20 --dbname regression --outputdir /tmp/cirrus-ci-build/build/testrun/regress/regress --temp-instance /tmp/cirrus-ci-build/build/testrun/regress/regress/tmp_check --port 40059 [17:26:28.708] ――――――――――――――――――――――――――――――――――――― ✀ ――――――――――――――――――――――――――――――――――――― [17:26:28.708] stderr: [17:26:28.708] # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/regress/regress/results/vacuum.out [17:26:28.708] # --- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:10.562306822 +0000 [17:26:28.708] # +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/vacuum.out 2026-04-28 17:24:41.253322163 +0000 [17:26:28.708] # @@ -231,7 +231,7 @@ [17:26:28.708] # SELECT pg_relation_size('vac_truncate_test') > 0; [17:26:28.708] # ?column? [17:26:28.708] # ---------- [17:26:28.708] # - t [17:26:28.708] # + f [17:26:28.708] # (1 row) [17:26:28.708] # [17:26:28.708] # SET vacuum_truncate = false; [17:26:28.708] # @@ -251,7 +251,7 @@ [17:26:28.708] # SELECT pg_relation_size('vac_truncate_test') > 0; [17:26:28.708] # ?column? [17:26:28.708] # ---------- [17:26:28.708] # - t [17:26:28.708] # + f [17:26:28.708] # (1 row) [17:26:28.708] # [17:26:28.708] # RESET vacuum_truncate; [17:26:28.708] # @@ -259,7 +259,7 @@ [17:26:28.708] # SELECT pg_relation_size('vac_truncate_test') > 0; [17:26:28.708] # ?column? [17:26:28.708] # ---------- [17:26:28.708] # - t [17:26:28.708] # + f [17:26:28.708] # (1 row) [17:26:28.708] # [17:26:28.708] # VACUUM (DISABLE_PAGE_SKIPPING) vac_truncate_test; [17:26:28.708] # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out /tmp/cirrus-ci-build/build/testrun/regress/regress/results/updatable_views.out [17:26:28.708] # --- /tmp/cirrus-ci-build/src/test/regress/expected/updatable_views.out 2026-04-28 17:20:10.562306822 +0000 [17:26:28.708] # +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/updatable_views.out 2026-04-28 17:24:46.797313844 +0000 [17:26:28.708] # @@ -2529,28 +2529,25 @@ [17:26:28.708] # [17:26:28.708] # INSERT INTO rw_view1 VALUES(3,4); -- ok [17:26:28.708] # INSERT INTO rw_view1 VALUES(4,3); -- should fail [17:26:28.708] # -ERROR: new row violates check option for view "rw_view1" [17:26:28.708] # -DETAIL: Failing row contains (4, 3). [17:26:28.708] # INSERT INTO rw_view1 VALUES(5,null); -- should fail [17:26:28.708] # -ERROR: new row violates check option for view "rw_view1" [17:26:28.708] # -DETAIL: Failing row contains (5, null). [17:26:28.708] # UPDATE rw_view1 SET b = 5 WHERE a = 3; -- ok [17:26:28.708] # UPDATE rw_view1 SET b = -5 WHERE a = 3; -- should fail [17:26:28.708] # ERROR: new row violates check option for view "rw_view1" [17:26:28.708] # DETAIL: Failing row contains (3, -5). [17:26:28.708] # INSERT INTO rw_view1(a) VALUES (9); -- ok [17:26:28.708] # INSERT INTO rw_view1(a) VALUES (10); -- should fail [17:26:28.708] # -ERROR: new row violates check option for view "rw_view1" [17:26:28.708] # -DETAIL: Failing row contains (10, 10). [17:26:28.708] # SELECT * FROM base_tbl ORDER BY a, b; [17:26:28.708] # - a | b [17:26:28.708] # ----+---- [17:26:28.708] # - 1 | -1 [17:26:28.708] # - 1 | 2 [17:26:28.708] # - 2 | 3 [17:26:28.708] # - 3 | 5 [17:26:28.708] # - 9 | 10 [17:26:28.708] # -(5 rows) [17:26:28.708] # + a | b [17:26:28.708] # +----+---- [17:26:28.708] # + 1 | -1 [17:26:28.708] # + 1 | 2 [17:26:28.708] # + 2 | 3 [17:26:28.708] # + 3 | 5 [17:26:28.708] # + 4 | 3 [17:26:28.708] # + 5 | [17:26:28.708] # + 9 | 10 [17:26:28.708] # + 10 | 10 [17:26:28.708] # +(8 rows) [17:26:28.708] # [17:26:28.708] # MERGE INTO rw_view1 t USING (VALUES (10)) AS v(a) ON t.a = v.a [17:26:28.708] # WHEN NOT MATCHED THEN INSERT VALUES (v.a, v.a + 1); -- ok [17:26:28.708] # @@ -2571,9 +2568,12 @@ [17:26:28.708] # 1 | -1 [17:26:28.708] # 2 | 3 [17:26:28.708] # 3 | 5 [17:26:28.708] # + 4 | 3 [17:26:28.708] # + 5 | [17:26:28.708] # 9 | 10 [17:26:28.708] # (diff output truncated and silencing output for further failing tests...) [17:26:28.708] # (diff output truncated and silencing output for further failing tests...) [17:26:28.708] # (diff output truncated and silencing output for further failing tests...) [17:26:28.708] # (diff output truncated and silencing output for further failing tests...) [17:26:28.708] # 5 of 249 tests failed. [17:26:28.708] # The differences that caused some tests to fail can be viewed in the file "/tmp/cirrus-ci-build/build/testrun/regress/regress/regression.diffs". [17:26:28.708] # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/build/testrun/regress/regress/regression.out". [17:26:28.708] [17:26:28.708] (test program exited with status code 1) [17:26:28.708] ―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― [17:26:28.708] [17:26:30.485] 28/399 postgresql:pg_upgrade / pg_upgrade/006_transfer_modes OK 134.27s 50 subtests passed [17:26:32.490] 29/399 postgresql:recovery / recovery/020_archive_status OK 12.26s 19 subtests passed [17:26:33.627] 30/399 postgresql:recovery / recovery/021_row_visibility OK 4.91s 10 subtests passed [17:26:34.109] ▶ 31/399 - regression tests pass FAIL [17:26:34.235] 31/399 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR 138.07s exit status 1 [17:26:34.236] >>> LD_LIBRARY_PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/lib/x86_64-linux-gnu top_builddir=/tmp/cirrus-ci-build/build MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/modules/test_plan_advice:/tmp/cirrus-ci-build/build/src/test/modules/test_plan_advice/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin INITDB_TEMPLATE=/tmp/cirrus-ci-build/build/tmp_install/initdb-template REGRESS_SHLIB=/tmp/cirrus-ci-build/build/src/test/regress/regress.so MALLOC_PERTURB_=233 PG_REGRESS=/tmp/cirrus-ci-build/build/src/test/regress/pg_regress MESON_TEST_ITERATION=1 share_contrib_dir=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/share/contrib /usr/bin/python3 /tmp/cirrus-ci-build/build/../src/tools/testwrap --basedir /tmp/cirrus-ci-build/build --srcdir /tmp/cirrus-ci-build/src/test/modules/test_plan_advice --pg-test-extra '' --testgroup test_plan_advice --testname 001_replan_regress -- /usr/bin/perl -I /tmp/cirrus-ci-build/src/test/perl -I /tmp/cirrus-ci-build/src/test/modules/test_plan_advice /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/t/001_replan_regress.pl [17:26:34.236] ――――――――――――――――――――――――――――――――――――― ✀ ――――――――――――――――――――――――――――――――――――― [17:26:34.236] stderr: [17:26:34.236] # Failed test 'regression tests pass' [17:26:34.236] # at /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/t/001_replan_regress.pl line 64. [17:26:34.236] # got: '256' [17:26:34.236] # expected: '0' [17:26:34.236] # Looks like you failed 1 test of 1. [17:26:34.236] [17:26:34.236] (test program exited with status code 1) [17:26:34.236] ―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― [17:26:34.236] [17:26:34.286] 32/399 postgresql:recovery / recovery/022_crash_temp_files OK 3.80s 11 subtests passed [17:26:37.629] 33/399 postgresql:recovery / recovery/023_pitr_prepared_xact OK 5.14s 1 subtests passed [17:26:39.090] 34/399 postgresql:recovery / recovery/024_archive_recovery OK 5.46s 2 subtests passed [17:26:40.023] 35/399 postgresql:recovery / recovery/025_stuck_on_old_timeline OK 5.79s 1 subtests passed [17:26:43.851] 36/399 postgresql:recovery / recovery/026_overwrite_contrecord OK 9.56s 3 subtests passed [17:26:46.296] 37/399 postgresql:recovery / recovery/028_pitr_timelines OK 7.20s 3 subtests passed [17:26:47.714] 38/399 postgresql:recovery / recovery/019_replslot_limit OK 27.76s 26 subtests passed [17:26:47.924] 39/399 postgresql:recovery / recovery/018_wal_optimize OK 28.51s 38 subtests passed [17:26:50.474] 40/399 postgresql:recovery / recovery/029_stats_restart OK 10.45s 44 subtests passed [17:26:52.507] 41/399 postgresql:isolation / isolation/isolation OK 120.56s 128 subtests passed [17:26:53.862] 42/399 postgresql:recovery / recovery/030_stats_cleanup_replica OK 10.01s 11 subtests passed [17:26:55.565] 43/399 postgresql:recovery / recovery/031_recovery_conflict OK 9.27s 18 subtests passed [17:26:55.949] 44/399 postgresql:recovery / recovery/034_create_database OK 5.47s 2 subtests passed [17:27:00.755] 45/399 postgresql:recovery / recovery/032_relfilenode_reuse OK 13.04s 14 subtests passed [17:27:01.804] 46/399 postgresql:recovery / recovery/036_truncated_dropped OK 7.94s 8 subtests passed [17:27:01.915] 47/399 postgresql:recovery / recovery/037_invalid_database OK 6.35s 10 subtests passed [17:27:06.090] 48/399 postgresql:recovery / recovery/038_save_logical_slots_shutdown OK 10.14s 2 subtests passed [17:27:06.794] 49/399 postgresql:recovery / recovery/033_replay_tsp_drops OK 18.87s 3 subtests passed [17:27:07.268] 50/399 postgresql:recovery / recovery/041_checkpoint_at_promote OK 5.35s 6 subtests passed [17:27:13.733] 51/399 postgresql:recovery / recovery/044_invalidate_inactive_slots OK 6.46s 1 subtests passed [17:27:14.544] 52/399 postgresql:recovery / recovery/043_no_contrecord_switch OK 7.75s 1 subtests passed [17:27:14.614] 53/399 postgresql:recovery / recovery/042_low_level_backup OK 8.52s 4 subtests passed [17:27:15.933] 54/399 postgresql:recovery / recovery/039_end_of_wal OK 15.18s 14 subtests passed [17:27:25.403] 55/399 postgresql:recovery / recovery/047_checkpoint_physical_slot OK 10.78s 1 subtests passed [17:27:25.703] 56/399 postgresql:recovery / recovery/048_vacuum_horizon_floor OK 9.77s 3 subtests passed [17:27:26.003] 27/399 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 189.83s exit status 1 [17:27:26.004] >>> top_builddir=/tmp/cirrus-ci-build/build PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/bin/pg_upgrade:/tmp/cirrus-ci-build/build/src/bin/pg_upgrade/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 INITDB_TEMPLATE=/tmp/cirrus-ci-build/build/tmp_install/initdb-template with_icu=yes LD_LIBRARY_PATH=/tmp/cirrus-ci-build/build/src/bin/pg_upgrade:/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/lib/x86_64-linux-gnu TEST_EXT_LIB=/tmp/cirrus-ci-build/build/src/bin/pg_upgrade/test_ext.so REGRESS_SHLIB=/tmp/cirrus-ci-build/build/src/test/regress/regress.so PG_REGRESS=/tmp/cirrus-ci-build/build/src/test/regress/pg_regress MALLOC_PERTURB_=94 MESON_TEST_ITERATION=1 share_contrib_dir=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/share/contrib /usr/bin/python3 /tmp/cirrus-ci-build/build/../src/tools/testwrap --basedir /tmp/cirrus-ci-build/build --srcdir /tmp/cirrus-ci-build/src/bin/pg_upgrade --pg-test-extra '' --testgroup pg_upgrade --testname 002_pg_upgrade -- /usr/bin/perl -I /tmp/cirrus-ci-build/src/test/perl -I /tmp/cirrus-ci-build/src/bin/pg_upgrade /tmp/cirrus-ci-build/src/bin/pg_upgrade/t/002_pg_upgrade.pl [17:27:26.004] ――――――――――――――――――――――――――――――――――――― ✀ ――――――――――――――――――――――――――――――――――――― [17:27:26.004] Listing only the last 100 lines from a long log. [17:27:26.004] # ok 25 + point 285 ms [17:27:26.004] # ok 26 + lseg 131 ms [17:27:26.004] # ok 27 + line 164 ms [17:27:26.004] # ... 211 lines omitted ... [17:27:26.004] # not ok 224 + reloptions 527 ms [17:27:26.004] # ok 225 + hash_part 258 ms [17:27:26.004] # ok 226 + indexing 8520 ms [17:27:26.004] # ok 227 + partition_aggregate 4978 ms [17:27:26.004] # ok 228 + partition_info 638 ms [17:27:26.004] # not ok 229 + tuplesort 6134 ms [17:27:26.004] # ok 230 + explain 618 ms [17:27:26.004] # ok 231 + memoize 1303 ms [17:27:26.004] # not ok 232 + stats 5138 ms [17:27:26.004] # ok 233 + predicate 745 ms [17:27:26.004] # ok 234 + numa 362 ms [17:27:26.004] # ok 235 + eager_aggregate 1952 ms [17:27:26.004] # ok 236 + graph_table_rls 884 ms [17:27:26.004] # ok 237 + planner_est 221 ms [17:27:26.004] # # parallel group (4 tests): compression_pglz compression compression_lz4 cluster [17:27:26.004] # ok 238 + compression 208 ms [17:27:26.004] # ok 239 + compression_lz4 529 ms [17:27:26.004] # ok 240 + compression_pglz 44 ms [17:27:26.004] # ok 241 + cluster 1397 ms [17:27:26.004] # # parallel group (2 tests): oidjoins event_trigger [17:27:26.004] # ok 242 + oidjoins 1039 ms [17:27:26.004] # ok 243 + event_trigger 1497 ms [17:27:26.004] # # parallel group (3 tests): tablespace_ddl role_ddl database_ddl [17:27:26.004] # ok 244 + role_ddl 663 ms [17:27:26.004] # ok 245 + tablespace_ddl 189 ms [17:27:26.004] # ok 246 + database_ddl 663 ms [17:27:26.004] # ok 247 - event_trigger_login 179 ms [17:27:26.004] # ok 248 - fast_default 1519 ms [17:27:26.004] # ok 249 - tablespace 2294 ms [17:27:26.004] # 1..249 [17:27:26.004] # -------------- stderr -------------- [17:27:26.004] # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out [17:27:26.004] # # --- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:10.562306822 +0000 [17:27:26.004] # # +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum.out 2026-04-28 17:24:39.557324834 +0000 [17:27:26.004] # # @@ -231,7 +231,7 @@ [17:27:26.004] # # SELECT pg_relation_size('vac_truncate_test') > 0; [17:27:26.004] # # ?column? [17:27:26.004] # # ---------- [17:27:26.004] # # - t [17:27:26.004] # # + f [17:27:26.004] # # (1 row) [17:27:26.004] # # [17:27:26.004] # # SET vacuum_truncate = false; [17:27:26.004] # # @@ -251,7 +251,7 @@ [17:27:26.004] # # SELECT pg_relation_size('vac_truncate_test') > 0; [17:27:26.004] # # ?column? [17:27:26.004] # # ---------- [17:27:26.004] # # - t [17:27:26.004] # # + f [17:27:26.004] # # (1 row) [17:27:26.004] # # [17:27:26.004] # # RESET vacuum_truncate; [17:27:26.004] # # @@ -259,7 +259,7 @@ [17:27:26.004] # # SELECT pg_relation_size('vac_truncate_test') > 0; [17:27:26.004] # # ?column? [17:27:26.004] # # ---------- [17:27:26.004] # # - t [17:27:26.004] # # + f [17:27:26.004] # # (1 row) [17:27:26.004] # # [17:27:26.004] # # VACUUM (DISABLE_PAGE_SKIPPING) vac_truncate_test; [17:27:26.004] # ... 27 lines omitted ... [17:27:26.004] # # - 9 | 10 [17:27:26.004] # # -(5 rows) [17:27:26.004] # # + a | b [17:27:26.004] # # +----+---- [17:27:26.004] # # + 1 | -1 [17:27:26.004] # # + 1 | 2 [17:27:26.004] # # + 2 | 3 [17:27:26.004] # # + 3 | 5 [17:27:26.004] # # + 4 | 3 [17:27:26.004] # # + 5 | [17:27:26.004] # # + 9 | 10 [17:27:26.004] # # + 10 | 10 [17:27:26.004] # # +(8 rows) [17:27:26.004] # # [17:27:26.004] # # MERGE INTO rw_view1 t USING (VALUES (10)) AS v(a) ON t.a = v.a [17:27:26.004] # # WHEN NOT MATCHED THEN INSERT VALUES (v.a, v.a + 1); -- ok [17:27:26.004] # # @@ -2571,9 +2568,12 @@ [17:27:26.004] # # 1 | -1 [17:27:26.004] # # 2 | 3 [17:27:26.004] # # 3 | 5 [17:27:26.004] # # + 4 | 3 [17:27:26.004] # # + 5 | [17:27:26.004] # # 9 | 10 [17:27:26.004] # # (diff output truncated and silencing output for further failing tests...) [17:27:26.004] # # (diff output truncated and silencing output for further failing tests...) [17:27:26.004] # # (diff output truncated and silencing output for further failing tests...) [17:27:26.004] # # (diff output truncated and silencing output for further failing tests...) [17:27:26.004] # # 5 of 249 tests failed. [17:27:26.004] # # The differences that caused some tests to fail can be viewed in the file "/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.diffs". [17:27:26.004] # # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/regression.out". [17:27:26.004] # ------------------------------------ [17:27:26.004] # Looks like you failed 1 test of 20. [17:27:26.004] [17:27:26.004] (test program exited with status code 1) [17:27:26.004] ―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― [17:27:26.004] [17:27:26.308] 57/399 postgresql:recovery / recovery/045_archive_restartpoint OK 12.57s 1 subtests passed [17:27:27.591] 58/399 postgresql:recovery / recovery/035_standby_logical_decoding OK 35.08s 89 subtests passed [17:27:29.904] 59/399 postgresql:recovery / recovery/046_checkpoint_logical_slot OK 15.36s 2 subtests passed [17:27:31.736] 60/399 postgresql:recovery / recovery/050_redo_segment_missing OK 6.03s 2 subtests passed [17:27:32.106] 61/399 postgresql:recovery / recovery/052_checkpoint_segment_missing OK 5.80s 4 subtests passed [17:27:32.690] 62/399 postgresql:recovery / recovery/040_standby_failover_slots_sync OK 30.88s 38 subtests passed [17:27:36.097] 63/399 postgresql:plpgsql / plpgsql/regress OK 6.19s 13 subtests passed [17:27:36.645] 64/399 postgresql:plperl / plperl/regress OK 4.91s 14 subtests passed [17:27:37.746] 65/399 postgresql:pltcl / pltcl/regress OK 5.05s 8 subtests passed [17:27:39.135] 66/399 postgresql:plpython / plpython/regress OK 7.03s 23 subtests passed [17:27:40.022] 67/399 postgresql:kerberos / kerberos/001_auth OK 12.43s 142 subtests passed [17:27:40.541] 68/399 postgresql:auto_explain / auto_explain/regress OK 3.89s 2 subtests passed [17:27:42.313] 69/399 postgresql:basic_archive / basic_archive/regress OK 4.57s 1 subtests passed [17:27:43.110] 70/399 postgresql:bloom / bloom/regress OK 3.97s 1 subtests passed [17:27:43.459] 71/399 postgresql:recovery / recovery/051_effective_wal_level OK 17.45s 31 subtests passed [17:27:43.563] 72/399 postgresql:bool_plperl / bool_plperl/regress OK 3.54s 2 subtests passed [17:27:44.496] 73/399 postgresql:recovery / recovery/049_wait_for_lsn OK 19.09s 35 subtests passed [17:27:46.748] 74/399 postgresql:btree_gin / btree_gin/regress OK 6.21s 30 subtests passed [17:27:48.594] 75/399 postgresql:citext / citext/regress OK 5.48s 3 subtests passed [17:27:48.886] 76/399 postgresql:cube / cube/regress OK 5.43s 2 subtests passed [17:27:49.305] 77/399 postgresql:dblink / dblink/regress OK 5.74s 1 subtests passed [17:27:49.483] 78/399 postgresql:dict_int / dict_int/regress OK 4.99s 1 subtests passed [17:27:49.803] 79/399 postgresql:btree_gist / btree_gist/regress OK 7.49s 32 subtests passed [17:27:50.395] 80/399 postgresql:amcheck / amcheck/regress OK 14.30s 4 subtests passed [17:27:52.548] 81/399 postgresql:dict_xsyn / dict_xsyn/regress OK 5.80s 1 subtests passed [17:27:52.975] 82/399 postgresql:fuzzystrmatch / fuzzystrmatch/regress OK 3.66s 2 subtests passed [17:27:53.471] 83/399 postgresql:file_fdw / file_fdw/regress OK 4.58s 1 subtests passed [17:27:53.519] 84/399 postgresql:earthdistance / earthdistance/regress OK 4.92s 1 subtests passed [17:27:53.862] 85/399 postgresql:hstore_plperl / hstore_plperl/regress OK 4.06s 3 subtests passed [17:27:54.095] 86/399 postgresql:hstore_plpython / hstore_plpython/regress OK 3.70s 1 subtests passed [17:27:56.872] 87/399 postgresql:hstore / hstore/regress OK 7.39s 2 subtests passed [17:27:58.855] 88/399 postgresql:isn / isn/regress OK 5.88s 1 subtests passed [17:27:58.919] 89/399 postgresql:jsonb_plperl / jsonb_plperl/regress OK 5.45s 2 subtests passed [17:27:59.267] 90/399 postgresql:jsonb_plpython / jsonb_plpython/regress OK 5.75s 1 subtests passed [17:27:59.322] 91/399 postgresql:lo / lo/regress OK 5.46s 1 subtests passed [17:28:00.931] 92/399 postgresql:ltree / ltree/regress OK 6.83s 1 subtests passed [17:28:02.107] 93/399 postgresql:ltree_plpython / ltree_plpython/regress OK 5.23s 1 subtests passed [17:28:03.062] 94/399 postgresql:passwordcheck / passwordcheck/regress OK 4.14s 1 subtests passed [17:28:03.493] 95/399 postgresql:pg_buffercache / pg_buffercache/regress OK 4.22s 2 subtests passed [17:28:04.983] 96/399 postgresql:pageinspect / pageinspect/regress OK 6.13s 8 subtests passed [17:28:05.389] 97/399 postgresql:pg_freespacemap / pg_freespacemap/regress OK 4.46s 1 subtests passed [17:28:05.823] 98/399 postgresql:pg_logicalinspect / pg_logicalinspect/isolation OK 3.71s 1 subtests passed [17:28:05.961] 99/399 postgresql:pgcrypto / pgcrypto/regress OK 6.63s 25 subtests passed [17:28:06.991] 100/399 postgresql:pg_overexplain / pg_overexplain/regress OK 3.93s 1 subtests passed [17:28:10.020] 101/399 postgresql:pg_prewarm / pg_prewarm/regress OK 5.04s 1 subtests passed [17:28:11.068] 102/399 postgresql:pgrowlocks / pgrowlocks/isolation OK 5.68s 1 subtests passed [17:28:12.835] 103/399 postgresql:pgstattuple / pgstattuple/regress OK 5.84s 1 subtests passed [17:28:13.170] 104/399 postgresql:intarray / intarray/regress OK 20.62s 1 subtests passed [17:28:14.031] ▶ 105/399 - wal 60 ms FAIL [17:28:14.767] 106/399 postgresql:pg_stash_advice / pg_stash_advice/regress OK 8.94s 2 subtests passed [17:28:15.363] 105/399 postgresql:pg_stat_statements / pg_stat_statements/regress ERROR 9.40s exit status 1 [17:28:15.363] >>> LD_LIBRARY_PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/lib/x86_64-linux-gnu top_builddir=/tmp/cirrus-ci-build/build MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 INITDB_TEMPLATE=/tmp/cirrus-ci-build/build/tmp_install/initdb-template MALLOC_PERTURB_=189 REGRESS_SHLIB=/tmp/cirrus-ci-build/build/src/test/regress/regress.so PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/contrib/pg_stat_statements:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin PG_REGRESS=/tmp/cirrus-ci-build/build/src/test/regress/pg_regress MESON_TEST_ITERATION=1 /usr/bin/python3 /tmp/cirrus-ci-build/build/../src/tools/testwrap --basedir /tmp/cirrus-ci-build/build --srcdir /tmp/cirrus-ci-build/contrib/pg_stat_statements --pg-test-extra '' --testgroup pg_stat_statements --testname regress --schedule --tests select dml cursors utility level_tracking planning user_activity wal entry_timestamp privileges extended parallel plancache squashing cleanup oldextversions -- /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --inputdir /tmp/cirrus-ci-build/contrib/pg_stat_statements --expecteddir /tmp/cirrus-ci-build/contrib/pg_stat_statements --bindir '' --dlpath /tmp/cirrus-ci-build/build/contrib/pg_stat_statements --max-concurrent-tests=20 --dbname regression_pg_stat_statements --temp-config /tmp/cirrus-ci-build/build/../contrib/pg_stat_statements/pg_stat_statements.conf --outputdir /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress --temp-instance /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/tmp_check --port 40040 [17:28:15.363] ――――――――――――――――――――――――――――――――――――― ✀ ――――――――――――――――――――――――――――――――――――― [17:28:15.363] stderr: [17:28:15.363] # diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/wal.out /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/wal.out [17:28:15.363] # --- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/wal.out 2026-04-28 17:20:08.558306780 +0000 [17:28:15.363] # +++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/wal.out 2026-04-28 17:28:14.005169841 +0000 [17:28:15.363] # @@ -16,7 +16,7 @@ [17:28:15.363] # query | calls | rows | wal_bytes_generated | wal_records_generated | wal_records_ge_rows [17:28:15.363] # --------------------------------------------------------------+-------+------+---------------------+-----------------------+--------------------- [17:28:15.363] # DELETE FROM pgss_wal_tab WHERE a > $1 | 1 | 1 | t | t | t [17:28:15.363] # - INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t | t [17:28:15.363] # + INSERT INTO pgss_wal_tab VALUES(generate_series($1, $2), $3) | 1 | 10 | t | t | f [17:28:15.363] # SELECT pg_stat_statements_reset() IS NOT NULL AS t | 1 | 1 | f | f | f [17:28:15.363] # SET pg_stat_statements.track_utility = $1 | 1 | 0 | f | f | t [17:28:15.363] # UPDATE pgss_wal_tab SET b = $1 WHERE a > $2 | 1 | 3 | t | t | t [17:28:15.363] # 1 of 16 tests failed. [17:28:15.363] # The differences that caused some tests to fail can be viewed in the file "/tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/regression.diffs". [17:28:15.363] # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/regression.out". [17:28:15.363] [17:28:15.363] (test program exited with status code 1) [17:28:15.363] ―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― [17:28:15.363] [17:28:15.718] 107/399 postgresql:pg_surgery / pg_surgery/regress OK 5.70s 1 subtests passed [17:28:17.356] 108/399 postgresql:pg_visibility / pg_visibility/regress OK 4.52s 1 subtests passed [17:28:17.616] ▶ 109/399 - pg_walinspect 182 ms FAIL [17:28:17.828] 109/399 postgresql:pg_walinspect / pg_walinspect/regress ERROR 4.66s exit status 1 [17:28:17.828] >>> LD_LIBRARY_PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/lib/x86_64-linux-gnu top_builddir=/tmp/cirrus-ci-build/build MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 INITDB_TEMPLATE=/tmp/cirrus-ci-build/build/tmp_install/initdb-template MALLOC_PERTURB_=36 REGRESS_SHLIB=/tmp/cirrus-ci-build/build/src/test/regress/regress.so PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/contrib/pg_walinspect:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin PG_REGRESS=/tmp/cirrus-ci-build/build/src/test/regress/pg_regress MESON_TEST_ITERATION=1 /usr/bin/python3 /tmp/cirrus-ci-build/build/../src/tools/testwrap --basedir /tmp/cirrus-ci-build/build --srcdir /tmp/cirrus-ci-build/contrib/pg_walinspect --pg-test-extra '' --testgroup pg_walinspect --testname regress --schedule --tests pg_walinspect oldextversions -- /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --inputdir /tmp/cirrus-ci-build/contrib/pg_walinspect --expecteddir /tmp/cirrus-ci-build/contrib/pg_walinspect --bindir '' --dlpath /tmp/cirrus-ci-build/build/contrib/pg_walinspect --max-concurrent-tests=20 --dbname regression_pg_walinspect --temp-config /tmp/cirrus-ci-build/build/../contrib/pg_walinspect/walinspect.conf --outputdir /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress --temp-instance /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/tmp_check --port 40045 [17:28:17.828] ――――――――――――――――――――――――――――――――――――― ✀ ――――――――――――――――――――――――――――――――――――― [17:28:17.828] stderr: [17:28:17.828] # diff -U3 /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out [17:28:17.828] # --- /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out 2026-04-28 17:20:08.570306780 +0000 [17:28:17.828] # +++ /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2026-04-28 17:28:17.589165242 +0000 [17:28:17.828] # @@ -98,7 +98,7 @@ [17:28:17.828] # WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap'; [17:28:17.828] # ok [17:28:17.828] # ---- [17:28:17.828] # - t [17:28:17.828] # + f [17:28:17.828] # (1 row) [17:28:17.828] # [17:28:17.828] # -- =================================================================== [17:28:17.828] # @@ -109,7 +109,7 @@ [17:28:17.828] # WHERE resource_manager = 'Heap' AND record_type = 'INSERT'; [17:28:17.828] # ok [17:28:17.828] # ---- [17:28:17.828] # - t [17:28:17.828] # + f [17:28:17.828] # (1 row) [17:28:17.828] # [17:28:17.828] # -- =================================================================== [17:28:17.828] # 1 of 2 tests failed. [17:28:17.828] # The differences that caused some tests to fail can be viewed in the file "/tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/regression.diffs". [17:28:17.828] # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/regression.out". [17:28:17.828] [17:28:17.828] (test program exited with status code 1) [17:28:17.828] ―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― [17:28:17.828] [17:28:17.843] 110/399 postgresql:pg_plan_advice / pg_plan_advice/regress OK 14.35s 9 subtests passed [17:28:18.843] 111/399 postgresql:postgres_fdw / postgres_fdw/isolation OK 3.48s 1 subtests passed [17:28:19.440] 112/399 postgresql:pg_trgm / pg_trgm/regress OK 8.37s 4 subtests passed [17:28:19.634] 113/399 postgresql:seg / seg/regress OK 3.91s 3 subtests passed [17:28:20.911] 114/399 postgresql:tablefunc / tablefunc/regress OK 3.08s 1 subtests passed [17:28:21.539] 115/399 postgresql:spi / spi/regress OK 4.18s 2 subtests passed [17:28:21.729] 116/399 postgresql:tcn / tcn/isolation OK 3.88s 1 subtests passed [17:28:22.567] 117/399 postgresql:tsm_system_rows / tsm_system_rows/regress OK 2.93s 1 subtests passed [17:28:24.839] 118/399 postgresql:tsm_system_time / tsm_system_time/regress OK 3.93s 1 subtests passed [17:28:25.181] 119/399 postgresql:uuid-ossp / uuid-ossp/regress OK 3.45s 1 subtests passed [17:28:25.619] 120/399 postgresql:unaccent / unaccent/regress OK 4.08s 1 subtests passed [17:28:26.360] 121/399 postgresql:xml2 / xml2/regress OK 3.79s 1 subtests passed [17:28:26.504] 122/399 postgresql:test_decoding / test_decoding/isolation OK 7.06s 14 subtests passed [17:28:27.501] ▶ 123/399 - regression tests pass FAIL [17:28:28.625] 124/399 postgresql:commit_ts / commit_ts/regress OK 3.44s 1 subtests passed [17:28:29.208] 125/399 postgresql:brin / brin/isolation OK 4.37s 1 subtests passed [17:28:29.279] 126/399 postgresql:dummy_index_am / dummy_index_am/regress OK 2.91s 1 subtests passed [17:28:30.432] 127/399 postgresql:dummy_seclabel / dummy_seclabel/regress OK 3.93s 1 subtests passed [17:28:30.709] 128/399 postgresql:delay_execution / delay_execution/isolation OK 5.09s 2 subtests passed [17:28:33.900] 129/399 postgresql:injection_points / injection_points/regress OK 4.62s 4 subtests passed [17:28:33.922] 130/399 postgresql:gin / gin/regress OK 5.30s 1 subtests passed [17:28:34.128] 131/399 postgresql:test_decoding / test_decoding/regress OK 15.28s 20 subtests passed [17:28:34.274] 132/399 postgresql:index / index/isolation OK 5.06s 1 subtests passed [17:28:37.910] 133/399 postgresql:plsample / plsample/regress OK 4.01s 1 subtests passed [17:28:38.315] 134/399 postgresql:spgist_name_ops / spgist_name_ops/regress OK 4.39s 1 subtests passed [17:28:38.371] 135/399 postgresql:test_binaryheap / test_binaryheap/regress OK 4.24s 1 subtests passed [17:28:38.422] ▶ 136/399 - postgres_fdw 20055 ms FAIL [17:28:38.673] 137/399 postgresql:test_bitmapset / test_bitmapset/regress OK 4.40s 1 subtests passed [17:28:38.775] 136/399 postgresql:postgres_fdw / postgres_fdw/regress ERROR 24.01s exit status 1 [17:28:38.776] >>> LD_LIBRARY_PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/lib/x86_64-linux-gnu top_builddir=/tmp/cirrus-ci-build/build MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/contrib/postgres_fdw:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin INITDB_TEMPLATE=/tmp/cirrus-ci-build/build/tmp_install/initdb-template REGRESS_SHLIB=/tmp/cirrus-ci-build/build/src/test/regress/regress.so MALLOC_PERTURB_=250 PG_REGRESS=/tmp/cirrus-ci-build/build/src/test/regress/pg_regress MESON_TEST_ITERATION=1 /usr/bin/python3 /tmp/cirrus-ci-build/build/../src/tools/testwrap --basedir /tmp/cirrus-ci-build/build --srcdir /tmp/cirrus-ci-build/contrib/postgres_fdw --pg-test-extra '' --testgroup postgres_fdw --testname regress --schedule --tests postgres_fdw query_cancel -- /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --inputdir /tmp/cirrus-ci-build/contrib/postgres_fdw --expecteddir /tmp/cirrus-ci-build/contrib/postgres_fdw --bindir '' --dlpath /tmp/cirrus-ci-build/build/contrib/postgres_fdw --max-concurrent-tests=20 --dbname regression_postgres_fdw --dlpath /tmp/cirrus-ci-build/build/src/test/regress --outputdir /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress --temp-instance /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/tmp_check --port 40046 [17:28:38.776] ――――――――――――――――――――――――――――――――――――― ✀ ――――――――――――――――――――――――――――――――――――― [17:28:38.776] stderr: [17:28:38.776] # diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out [17:28:38.776] # --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-04-28 17:20:08.598306780 +0000 [17:28:38.776] # +++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2026-04-28 17:28:38.373140297 +0000 [17:28:38.776] # @@ -3016,13 +3016,16 @@ [17:28:38.776] # -- GROUP BY clause having expressions [17:28:38.776] # explain (verbose, costs off) [17:28:38.776] # select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2; [17:28:38.776] # - QUERY PLAN [17:28:38.776] # ------------------------------------------------------------------------------------------------------------------- [17:28:38.776] # - Foreign Scan [17:28:38.776] # + QUERY PLAN [17:28:38.776] # +--------------------------------------------------------------------------------------- [17:28:38.776] # + Sort [17:28:38.776] # Output: ((c2 / 2)), ((sum(c2) * (c2 / 2))) [17:28:38.776] # - Relations: Aggregate on (public.ft1) [17:28:38.776] # - Remote SQL: SELECT (c2 / 2), (sum(c2) * (c2 / 2)) FROM "S 1"."T 1" GROUP BY 1 ORDER BY (c2 / 2) ASC NULLS LAST [17:28:38.776] # -(4 rows) [17:28:38.776] # + Sort Key: ((ft1.c2 / 2)) [17:28:38.776] # + -> Foreign Scan [17:28:38.776] # + Output: ((c2 / 2)), ((sum(c2) * (c2 / 2))) [17:28:38.776] # + Relations: Aggregate on (public.ft1) [17:28:38.776] # + Remote SQL: SELECT (c2 / 2), (sum(c2) * (c2 / 2)) FROM "S 1"."T 1" GROUP BY 1 [17:28:38.776] # +(7 rows) [17:28:38.776] # [17:28:38.776] # select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2; [17:28:38.776] # ?column? | ?column? [17:28:38.776] # @@ -3103,13 +3106,16 @@ [17:28:38.776] # -- GROUP BY clause in various forms, cardinal, alias and constant expression [17:28:38.776] # explain (verbose, costs off) [17:28:38.776] # select count(c2) w, c2 x, 5 y, 7.0 z from ft1 group by 2, y, 9.0::int order by 2; [17:28:38.776] # - QUERY PLAN [17:28:38.776] # ------------------------------------------------------------------------------------------------------------ [17:28:38.776] # - Foreign Scan [17:28:38.776] # + QUERY PLAN [17:28:38.776] # +-------------------------------------------------------------------------------------- [17:28:38.776] # + Sort [17:28:38.776] # Output: (count(*)), c2, 5, 7.0, 9 [17:28:38.776] # - Relations: Aggregate on (public.ft1) [17:28:38.776] # - Remote SQL: SELECT count(*), c2, 5, 7.0, 9 FROM "S 1"."T 1" GROUP BY 2, 3, 5 ORDER BY c2 ASC NULLS LAST [17:28:38.776] # -(4 rows) [17:28:38.776] # + Sort Key: ft1.c2 [17:28:38.776] # + -> Foreign Scan [17:28:38.776] # + Output: (count(*)), c2, 5, 7.0, 9 [17:28:38.776] # + Relations: Aggregate on (public.ft1) [17:28:38.776] # + Remote SQL: SELECT count(*), c2, 5, 7.0, 9 FROM "S 1"."T 1" GROUP BY 2, 3, 5 [17:28:38.776] # +(7 rows) [17:28:38.776] # [17:28:38.776] # select count(c2) w, c2 x, 5 y, 7.0 z from ft1 group by 2, y, 9.0::int order by 2; [17:28:38.776] # w | x | y | z [17:28:38.776] # @@ -3149,13 +3155,16 @@ [17:28:38.776] # -- Testing HAVING clause shippability [17:28:38.776] # explain (verbose, costs off) [17:28:38.776] # select c2, sum(c1) from ft2 group by c2 having avg(c1) < 500 and sum(c1) < 49800 order by c2; [17:28:38.776] # - QUERY PLAN [17:28:38.776] # ------------------------------------------------------------------------------------------------------------------------------------------------------------- [17:28:38.776] # - Foreign Scan [17:28:38.776] # + QUERY PLAN [17:28:38.776] # +--------------------------------------------------------------------------------------------------------------------------------------- [17:28:38.776] # + Sort [17:28:38.776] # Output: c2, (sum(c1)) [17:28:38.776] # - Relations: Aggregate on (public.ft2) [17:28:38.776] # - Remote SQL: SELECT c2, sum("C 1") FROM "S 1"."T 1" GROUP BY 1 HAVING ((avg("C 1") < 500::numeric)) AND ((sum("C 1") < 49800)) ORDER BY c2 ASC NULLS LAST [17:28:38.776] # -(4 rows) [17:28:38.776] # + Sort Key: ft2.c2 [17:28:38.776] # + -> Foreign Scan [17:28:38.776] # + Output: c2, (sum(c1)) [17:28:38.776] # + Relations: Aggregate on (public.ft2) [17:28:38.776] # + Remote SQL: SELECT c2, sum("C 1") FROM "S 1"."T 1" GROUP BY 1 HAVING ((avg("C 1") < 500::numeric)) AND ((sum("C 1") < 49800)) [17:28:38.776] # +(7 rows) [17:28:38.776] # [17:28:38.776] # select c2, sum(c1) from ft2 group by c2 having avg(c1) < 500 and sum(c1) < 49800 order by c2; [17:28:38.776] # c2 | sum [17:28:38.776] # @@ -6415,13 +6424,13 @@ [17:28:38.776] # -> Sort [17:28:38.776] # Output: ft2.ctid, ft2.*, ft2.c2, ft4.*, ft4.c1, ft4.c2, ft4.c3 [17:28:38.776] # Sort Key: ft2.c2 [17:28:38.776] # - -> Hash Join [17:28:38.776] # + -> Nested Loop [17:28:38.776] # Output: ft2.ctid, ft2.*, ft2.c2, ft4.*, ft4.c1, ft4.c2, ft4.c3 [17:28:38.776] # - Hash Cond: (ft2.c2 = ft4.c1) [17:28:38.776] # (diff output truncated and silencing output for further failing tests...) [17:28:38.776] # 1 of 2 tests failed. [17:28:38.776] # The differences that caused some tests to fail can be viewed in the file "/tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/regression.diffs". [17:28:38.776] # A copy of the test summary that you see above is saved in the file "/tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/regression.out". [17:28:38.776] [17:28:38.776] (test program exited with status code 1) [17:28:38.776] ―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― [17:28:38.776] [17:28:40.344] 138/399 postgresql:injection_points / injection_points/isolation OK 9.91s 6 subtests passed [17:28:40.603] 139/399 postgresql:nbtree / nbtree/regress OK 9.89s 2 subtests passed [17:28:42.375] 140/399 postgresql:test_custom_types / test_custom_types/regress OK 3.60s 1 subtests passed [17:28:42.610] 141/399 postgresql:test_copy_callbacks / test_copy_callbacks/regress OK 4.24s 1 subtests passed [17:28:42.697] 142/399 postgresql:test_bloomfilter / test_bloomfilter/regress OK 4.79s 1 subtests passed [17:28:43.023] 143/399 postgresql:test_buffered_insert / test_buffered_insert/regress OK 4.71s 1 subtests passed [17:28:43.116] 144/399 postgresql:test_cplusplusext / test_cplusplusext/regress OK 4.44s 1 subtests passed [17:28:44.966] 145/399 postgresql:test_dsa / test_dsa/regress OK 4.36s 1 subtests passed [17:28:46.142] 146/399 postgresql:test_ddl_deparse / test_ddl_deparse/regress OK 5.80s 22 subtests passed [17:28:46.448] 147/399 postgresql:test_lfind / test_lfind/regress OK 3.33s 1 subtests passed [17:28:47.205] 148/399 postgresql:test_ginpostinglist / test_ginpostinglist/regress OK 4.51s 1 subtests passed [17:28:47.775] 149/399 postgresql:test_dsm_registry / test_dsm_registry/regress OK 5.40s 1 subtests passed [17:28:48.775] 150/399 postgresql:test_extensions / test_extensions/regress OK 6.16s 2 subtests passed [17:28:49.008] 151/399 postgresql:test_lwlock_tranches / test_lwlock_tranches/regress OK 4.04s 1 subtests passed [17:28:50.584] 152/399 postgresql:test_oat_hooks / test_oat_hooks/regress OK 4.44s 2 subtests passed [17:28:51.154] 153/399 postgresql:test_parser / test_parser/regress OK 4.71s 1 subtests passed [17:28:51.340] 154/399 postgresql:test_pg_dump / test_pg_dump/regress OK 4.13s 1 subtests passed [17:28:52.112] 155/399 postgresql:test_predtest / test_predtest/regress OK 4.34s 1 subtests passed [17:28:53.435] 156/399 postgresql:test_rbtree / test_rbtree/regress OK 4.43s 1 subtests passed [17:28:53.743] 157/399 postgresql:test_radixtree / test_radixtree/regress OK 4.97s 1 subtests passed [17:28:54.633] 158/399 postgresql:test_rls_hooks / test_rls_hooks/regress OK 3.29s 1 subtests passed [17:28:56.381] 159/399 postgresql:test_integerset / test_integerset/regress OK 13.35s 1 subtests passed [17:28:56.756] 160/399 postgresql:test_resowner / test_resowner/regress OK 5.60s 1 subtests passed [17:28:56.964] 161/399 postgresql:test_saslprep / test_saslprep/regress OK 4.85s 1 subtests passed [17:28:57.406] 162/399 postgresql:test_regex / test_regex/regress OK 6.82s 2 subtests passed [17:28:58.307] 163/399 postgresql:test_slru / test_slru/regress OK 4.56s 1 subtests passed [17:28:58.502] 164/399 postgresql:test_tidstore / test_tidstore/regress OK 3.87s 1 subtests passed [17:28:58.655] 165/399 postgresql:libpq / libpq/002_api OK 0.35s 1 subtests passed [17:28:59.324] 166/399 postgresql:libpq / libpq/001_uri OK 1.92s 63 subtests passed [17:28:59.859] 167/399 postgresql:typcache / typcache/regress OK 3.48s 1 subtests passed [17:29:01.246] 168/399 postgresql:test_shm_mq / test_shm_mq/regress OK 7.81s 1 subtests passed [17:29:01.639] 169/399 postgresql:libpq-oauth / libpq-oauth/001_oauth OK 0.39s 55 subtests passed [17:29:02.136] 170/399 postgresql:unsafe_tests / unsafe_tests/regress OK 5.38s 4 subtests passed [17:29:02.572] 171/399 postgresql:pg_amcheck / pg_amcheck/001_basic OK 0.43s 9 subtests passed [17:29:07.569] 172/399 postgresql:ecpg / ecpg/ecpg OK 10.60s 66 subtests passed [17:29:08.440] 173/399 postgresql:libpq / libpq/006_service OK 8.58s 47 subtests passed [17:29:10.538] 174/399 postgresql:pg_amcheck / pg_amcheck/002_nonesuch OK 7.96s 107 subtests passed [17:29:12.827] 175/399 postgresql:libpq / libpq/004_load_balance_dns OK 14.17s 125 subtests passed [17:29:13.274] 176/399 postgresql:libpq / libpq/003_load_balance_host_list OK 14.76s 127 subtests passed [17:29:13.393] 177/399 postgresql:pg_archivecleanup / pg_archivecleanup/010_pg_archivecleanup OK 0.56s 51 subtests passed [17:29:15.897] 178/399 postgresql:pg_amcheck / pg_amcheck/004_verify_heapam OK 7.46s 32 subtests passed [17:29:16.724] 179/399 postgresql:pg_amcheck / pg_amcheck/005_opclass_damage OK 6.18s 10 subtests passed [17:29:17.537] 180/399 postgresql:libpq / libpq/005_negotiate_encryption OK 18.21s 249 subtests passed [17:29:17.711] 181/399 postgresql:pg_basebackup / pg_basebackup/011_in_place_tablespace OK 4.32s 3 subtests passed [17:29:18.071] 182/399 postgresql:pg_checksums / pg_checksums/001_basic OK 0.36s 9 subtests passed [17:29:21.059] 123/399 postgresql:recovery / recovery/027_stream_regress ERROR 163.43s exit status 1 [17:29:21.060] >>> LD_LIBRARY_PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/lib/x86_64-linux-gnu top_builddir=/tmp/cirrus-ci-build/build MALLOC_PERTURB_=17 MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 INITDB_TEMPLATE=/tmp/cirrus-ci-build/build/tmp_install/initdb-template REGRESS_SHLIB=/tmp/cirrus-ci-build/build/src/test/regress/regress.so PATH=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin PG_REGRESS=/tmp/cirrus-ci-build/build/src/test/regress/pg_regress MESON_TEST_ITERATION=1 enable_injection_points=yes share_contrib_dir=/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/share/contrib /usr/bin/python3 /tmp/cirrus-ci-build/build/../src/tools/testwrap --basedir /tmp/cirrus-ci-build/build --srcdir /tmp/cirrus-ci-build/src/test/recovery --pg-test-extra '' --testgroup recovery --testname 027_stream_regress -- /usr/bin/perl -I /tmp/cirrus-ci-build/src/test/perl -I /tmp/cirrus-ci-build/src/test/recovery /tmp/cirrus-ci-build/src/test/recovery/t/027_stream_regress.pl [17:29:21.060] ――――――――――――――――――――――――――――――――――――― ✀ ――――――――――――――――――――――――――――――――――――― [17:29:21.060] Listing only the last 100 lines from a long log. [17:29:21.060] # ok 25 + point 335 ms [17:29:21.060] # ok 26 + lseg 162 ms [17:29:21.060] # ok 27 + line 171 ms [17:29:21.060] # ... 211 lines omitted ... [17:29:21.060] # not ok 224 + reloptions 498 ms [17:29:21.060] # ok 225 + hash_part 485 ms [17:29:21.060] # ok 226 + indexing 11580 ms [17:29:21.060] # ok 227 + partition_aggregate 4573 ms [17:29:21.060] # ok 228 + partition_info 1148 ms [17:29:21.060] # not ok 229 + tuplesort 4625 ms [17:29:21.060] # ok 230 + explain 729 ms [17:29:21.060] # ok 231 + memoize 3821 ms [17:29:21.060] # ok 232 + stats 6705 ms [17:29:21.060] # ok 233 + predicate 768 ms [17:29:21.060] # ok 234 + numa 206 ms [17:29:21.060] # ok 235 + eager_aggregate 2432 ms [17:29:21.060] # ok 236 + graph_table_rls 1010 ms [17:29:21.060] # ok 237 + planner_est 226 ms [17:29:21.060] # # parallel group (4 tests): compression_pglz compression_lz4 compression cluster [17:29:21.060] # ok 238 + compression 922 ms [17:29:21.060] # ok 239 + compression_lz4 726 ms [17:29:21.060] # ok 240 + compression_pglz 54 ms [17:29:21.060] # ok 241 + cluster 1764 ms [17:29:21.060] # # parallel group (2 tests): oidjoins event_trigger [17:29:21.060] # ok 242 + oidjoins 1896 ms [17:29:21.060] # ok 243 + event_trigger 2210 ms [17:29:21.060] # # parallel group (3 tests): tablespace_ddl database_ddl role_ddl [17:29:21.060] # ok 244 + role_ddl 383 ms [17:29:21.060] # ok 245 + tablespace_ddl 88 ms [17:29:21.060] # ok 246 + database_ddl 334 ms [17:29:21.060] # ok 247 - event_trigger_login 155 ms [17:29:21.060] # ok 248 - fast_default 665 ms [17:29:21.060] # ok 249 - tablespace 3466 ms [17:29:21.060] # 1..249 [17:29:21.060] # -------------- stderr -------------- [17:29:21.060] # # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/vacuum.out [17:29:21.060] # # --- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum.out 2026-04-28 17:20:10.562306822 +0000 [17:29:21.060] # # +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/vacuum.out 2026-04-28 17:26:59.645216146 +0000 [17:29:21.060] # # @@ -231,7 +231,7 @@ [17:29:21.060] # # SELECT pg_relation_size('vac_truncate_test') > 0; [17:29:21.060] # # ?column? [17:29:21.060] # # ---------- [17:29:21.060] # # - t [17:29:21.060] # # + f [17:29:21.060] # # (1 row) [17:29:21.060] # # [17:29:21.060] # # SET vacuum_truncate = false; [17:29:21.060] # # @@ -251,7 +251,7 @@ [17:29:21.060] # # SELECT pg_relation_size('vac_truncate_test') > 0; [17:29:21.060] # # ?column? [17:29:21.060] # # ---------- [17:29:21.060] # # - t [17:29:21.060] # # + f [17:29:21.060] # # (1 row) [17:29:21.060] # # [17:29:21.060] # # RESET vacuum_truncate; [17:29:21.060] # # @@ -259,7 +259,7 @@ [17:29:21.060] # # SELECT pg_relation_size('vac_truncate_test') > 0; [17:29:21.060] # # ?column? [17:29:21.060] # # ---------- [17:29:21.060] # # - t [17:29:21.060] # # + f [17:29:21.060] # # (1 row) [17:29:21.060] # # [17:29:21.060] # # VACUUM (DISABLE_PAGE_SKIPPING) vac_truncate_test; [17:29:21.060] # ... 26 lines omitted ... [17:29:21.060] # # - 3 | 5 [17:29:21.060] # # - 9 | 10 [17:29:21.060] # # -(5 rows) [17:29:21.060] # # + a | b [17:29:21.060] # # +----+---- [17:29:21.060] # # + 1 | -1 [17:29:21.060] # # + 1 | 2 [17:29:21.060] # # + 2 | 3 [17:29:21.060] # # + 3 | 5 [17:29:21.060] # # + 4 | 3 [17:29:21.060] # # + 5 | [17:29:21.060] # # + 9 | 10 [17:29:21.060] # # + 10 | 10 [17:29:21.060] # # +(8 rows) [17:29:21.060] # # [17:29:21.060] # # MERGE INTO rw_view1 t USING (VALUES (10)) AS v(a) ON t.a = v.a [17:29:21.060] # # WHEN NOT MATCHED THEN INSERT VALUES (v.a, v.a + 1); -- ok [17:29:21.060] # # @@ -2571,9 +2568,12 @@ [17:29:21.060] # # 1 | -1 [17:29:21.060] # # 2 | 3 [17:29:21.060] # # 3 | 5 [17:29:21.060] # # + 4 | 3 [17:29:21.060] # # + 5 | [17:29:21.060] # # 9 | 10 [17:29:21.060] # # (diff output truncated and silencing output for further failing tests...) [17:29:21.060] # # (diff output truncated and silencing output for further failing tests...) [17:29:21.060] # # (diff output truncated and silencing output for further failing tests...) [17:29:21.060] # # 4 of 249 tests failed. [17:29:21.060] # # 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". [17:29:21.060] # # 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". [17:29:21.060] # ------------------------------------ [17:29:21.060] # Looks like you failed 1 test of 11. [17:29:21.060] [17:29:21.060] (test program exited with status code 1) [17:29:21.060] ―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― [17:29:21.060] [17:29:21.496] 183/399 postgresql:pg_combinebackup / pg_combinebackup/001_basic OK 0.43s 13 subtests passed [17:29:23.195] 184/399 postgresql:pg_basebackup / pg_basebackup/020_pg_receivewal OK 7.30s 43 subtests passed [17:29:25.272] 185/399 postgresql:pg_amcheck / pg_amcheck/003_check OK 17.70s 75 subtests passed [17:29:25.643] 186/399 postgresql:pg_checksums / pg_checksums/002_actions OK 7.57s 66 subtests passed [17:29:27.723] 187/399 postgresql:pg_basebackup / pg_basebackup/030_pg_recvlogical OK 11.00s 27 subtests passed [17:29:29.542] 188/399 postgresql:pg_combinebackup / pg_combinebackup/003_timeline OK 6.34s 7 subtests passed [17:29:30.627] 189/399 postgresql:pg_combinebackup / pg_combinebackup/004_manifest OK 5.35s 11 subtests passed [17:29:32.398] 190/399 postgresql:pg_combinebackup / pg_combinebackup/002_compare_backups OK 10.90s 6 subtests passed [17:29:33.720] 191/399 postgresql:pg_combinebackup / pg_combinebackup/006_db_file_copy OK 6.00s 4 subtests passed [17:29:34.176] 192/399 postgresql:pg_combinebackup / pg_combinebackup/007_wal_level_minimal OK 4.63s 3 subtests passed [17:29:34.607] 193/399 postgresql:pg_combinebackup / pg_combinebackup/005_integrity OK 8.96s 22 subtests passed [17:29:34.938] 194/399 postgresql:pg_config / pg_config/001_pg_config OK 0.33s 21 subtests passed [17:29:35.100] 195/399 postgresql:initdb / initdb/001_initdb OK 33.46s 57 subtests passed [17:29:36.521] 196/399 postgresql:pg_combinebackup / pg_combinebackup/009_no_full_file OK 4.12s 4 subtests passed [17:29:37.569] 197/399 postgresql:pg_controldata / pg_controldata/001_pg_controldata OK 2.63s 18 subtests passed [17:29:38.419] 198/399 postgresql:pg_combinebackup / pg_combinebackup/008_promote OK 7.79s 2 subtests passed [17:29:38.835] 199/399 postgresql:pg_combinebackup / pg_combinebackup/011_ib_truncation OK 4.66s 5 subtests passed [17:29:38.923] 200/399 postgresql:pg_basebackup / pg_basebackup/010_pg_basebackup OK 25.65s 200 subtests passed [17:29:39.139] 201/399 postgresql:pg_ctl / pg_ctl/001_start_stop OK 4.04s 25 subtests passed [17:29:39.393] 202/399 postgresql:pg_ctl / pg_ctl/002_status OK 2.87s 3 subtests passed [17:29:39.596] 203/399 postgresql:pg_combinebackup / pg_combinebackup/010_hardlink OK 5.87s 4 subtests passed [17:29:40.583] 204/399 postgresql:pg_basebackup / pg_basebackup/040_pg_createsubscriber OK 23.04s 60 subtests passed [17:29:41.009] 205/399 postgresql:pg_dump / pg_dump/001_basic OK 2.17s 135 subtests passed [17:29:42.599] 206/399 postgresql:pg_ctl / pg_ctl/003_promote OK 5.03s 12 subtests passed [17:29:43.355] 207/399 postgresql:pg_dump / pg_dump/003_pg_dump_with_server OK 4.21s 3 subtests passed [17:29:44.220] 208/399 postgresql:pg_ctl / pg_ctl/004_logrotate OK 5.80s 14 subtests passed [17:29:44.775] 209/399 postgresql:pg_dump / pg_dump/004_pg_dump_parallel OK 5.38s 4 subtests passed [17:29:47.769] 210/399 postgresql:pg_resetwal / pg_resetwal/002_corrupted OK 3.55s 9 subtests passed [17:29:48.196] 211/399 postgresql:pg_dump / pg_dump/006_pg_dump_compress OK 7.61s 98 subtests passed [17:29:48.348] 212/399 postgresql:pg_resetwal / pg_resetwal/001_basic OK 4.99s 83 subtests passed [17:29:51.787] 213/399 postgresql:pg_dump / pg_dump/005_pg_dump_filterfile OK 12.19s 108 subtests passed [17:29:56.750] 214/399 postgresql:pg_rewind / pg_rewind/005_same_timeline OK 4.96s 1 subtests passed [17:29:57.136] 215/399 postgresql:pg_rewind / pg_rewind/006_options OK 0.39s 13 subtests passed [17:29:58.915] 216/399 postgresql:pg_dump / pg_dump/010_dump_connstr OK 16.31s 13 subtests passed [17:29:59.295] 217/399 postgresql:pg_rewind / pg_rewind/004_pg_xlog_symlink OK 10.94s 10 subtests passed [17:29:59.827] 218/399 postgresql:pg_rewind / pg_rewind/003_extrafiles OK 11.63s 6 subtests passed [17:30:02.683] 219/399 postgresql:pg_rewind / pg_rewind/002_databases OK 14.91s 12 subtests passed [17:30:03.512] 220/399 postgresql:pg_rewind / pg_rewind/007_standby_source OK 6.37s 7 subtests passed [17:30:03.878] 221/399 postgresql:pg_test_fsync / pg_test_fsync/001_basic OK 0.36s 13 subtests passed [17:30:04.239] 222/399 postgresql:pg_rewind / pg_rewind/009_growing_files OK 4.94s 3 subtests passed [17:30:04.704] 223/399 postgresql:pg_verifybackup / pg_verifybackup/001_basic OK 0.46s 17 subtests passed [17:30:04.898] 224/399 postgresql:pg_rewind / pg_rewind/001_basic OK 20.12s 57 subtests passed [17:30:07.007] 225/399 postgresql:pg_rewind / pg_rewind/008_min_recovery_point OK 8.09s 3 subtests passed [17:30:07.292] 226/399 postgresql:pg_test_timing / pg_test_timing/001_basic OK 3.41s 18 subtests passed [17:30:07.381] 227/399 postgresql:pg_rewind / pg_rewind/010_keep_recycled_wals OK 7.55s 1 subtests passed [17:30:07.418] 228/399 postgresql:pg_rewind / pg_rewind/011_wal_copy OK 4.73s 12 subtests passed [17:30:08.560] 229/399 postgresql:pg_verifybackup / pg_verifybackup/005_bad_manifest OK 1.27s 60 subtests passed [17:30:11.635] 230/399 postgresql:pg_verifybackup / pg_verifybackup/006_encoding OK 4.25s 5 subtests passed [17:30:11.650] 231/399 postgresql:pg_verifybackup / pg_verifybackup/004_options OK 4.63s 32 subtests passed [17:30:13.187] 232/399 postgresql:pg_verifybackup / pg_verifybackup/007_wal OK 5.77s 11 subtests passed [17:30:13.544] 233/399 postgresql:pg_verifybackup / pg_verifybackup/002_algorithm OK 8.84s 38 subtests passed [17:30:17.431] 234/399 postgresql:pg_waldump / pg_waldump/002_save_fullpage OK 3.88s 5 subtests passed [17:30:17.551] 235/399 postgresql:pg_verifybackup / pg_verifybackup/008_untar OK 8.99s 18 subtests passed [17:30:17.787] 236/399 postgresql:pg_walsummary / pg_walsummary/001_basic OK 0.35s 11 subtests passed [17:30:19.703] 237/399 postgresql:pg_verifybackup / pg_verifybackup/003_corruption OK 14.80s 92 subtests passed [17:30:19.740] 238/399 postgresql:pg_verifybackup / pg_verifybackup/009_extract OK 8.10s 10 subtests passed [17:30:19.905] 239/399 postgresql:pg_verifybackup / pg_verifybackup/010_client_untar OK 8.25s 21 subtests passed [17:30:21.414] 240/399 postgresql:pgbench / pgbench/002_pgbench_no_server OK 1.71s 207 subtests passed [17:30:21.667] 241/399 postgresql:pg_walsummary / pg_walsummary/002_blocks OK 4.11s 7 subtests passed [17:30:24.955] 242/399 postgresql:psql / psql/010_tab_completion OK 5.05s 89 subtests passed [17:30:25.466] 243/399 postgresql:psql / psql/020_cancel OK 4.05s 2 subtests passed [17:30:26.148] 244/399 postgresql:psql / psql/001_basic OK 6.41s 126 subtests passed [17:30:26.592] 245/399 postgresql:psql / psql/030_pager OK 4.92s 4 subtests passed [17:30:28.885] 246/399 postgresql:scripts / scripts/010_clusterdb OK 3.93s 16 subtests passed [17:30:29.889] 247/399 postgresql:scripts / scripts/011_clusterdb_all OK 4.42s 7 subtests passed [17:30:30.524] 248/399 postgresql:pg_waldump / pg_waldump/001_basic OK 17.33s 212 subtests passed [17:30:31.467] 249/399 postgresql:scripts / scripts/040_createuser OK 4.87s 37 subtests passed [17:30:33.419] 250/399 postgresql:scripts / scripts/050_dropdb OK 4.53s 16 subtests passed [17:30:33.837] 251/399 postgresql:scripts / scripts/070_dropuser OK 3.95s 13 subtests passed [17:30:34.807] 252/399 postgresql:scripts / scripts/080_pg_isready OK 4.28s 11 subtests passed [17:30:37.041] 253/399 postgresql:pg_dump / pg_dump/002_pg_dump OK 58.11s 12122 subtests passed [17:30:37.391] 254/399 postgresql:scripts / scripts/020_createdb OK 11.24s 64 subtests passed [17:30:38.503] 255/399 postgresql:pgbench / pgbench/001_pgbench_with_server OK 20.71s 474 subtests passed [17:30:38.695] 256/399 postgresql:scripts / scripts/091_reindexdb_all OK 5.28s 13 subtests passed [17:30:38.771] 257/399 postgresql:ecpg / ecpg/001_ecpg_err_warn_msg OK 0.26s 27 subtests passed [17:30:39.136] 258/399 postgresql:ecpg / ecpg/002_ecpg_err_warn_msg_informix OK 0.44s 4 subtests passed [17:30:39.530] 259/399 postgresql:pg_bsd_indent / pg_bsd_indent/001_pg_bsd_indent OK 0.76s 39 subtests passed [17:30:39.727] 260/399 postgresql:scripts / scripts/090_reindexdb OK 8.26s 64 subtests passed [17:30:39.791] 261/399 postgresql:scripts / scripts/101_vacuumdb_all OK 4.98s 5 subtests passed [17:30:43.194] 262/399 postgresql:pg_dump / pg_dump/007_pg_dumpall OK 62.18s 60 subtests passed [17:30:43.791] 263/399 postgresql:amcheck / amcheck/002_cic OK 4.26s 4 subtests passed [17:30:43.865] 264/399 postgresql:amcheck / amcheck/004_verify_nbtree_unique OK 4.07s 6 subtests passed [17:30:44.102] 265/399 postgresql:scripts / scripts/100_vacuumdb OK 10.26s 113 subtests passed [17:30:44.727] 266/399 postgresql:scripts / scripts/200_connstr OK 7.33s 3 subtests passed [17:30:45.087] 267/399 postgresql:amcheck / amcheck/003_cic_2pc OK 5.36s 7 subtests passed [17:30:45.623] 268/399 postgresql:scripts / scripts/102_vacuumdb_stages OK 8.25s 4 subtests passed [17:30:45.971] 269/399 postgresql:oid2name / oid2name/001_basic OK 0.35s 9 subtests passed [17:30:48.460] 270/399 postgresql:amcheck / amcheck/005_pitr OK 5.26s 3 subtests passed [17:30:48.782] 271/399 postgresql:auto_explain / auto_explain/001_auto_explain OK 4.91s 22 subtests passed [17:30:50.340] 272/399 postgresql:pg_prewarm / pg_prewarm/001_basic OK 4.37s 11 subtests passed [17:30:50.653] 273/399 postgresql:amcheck / amcheck/006_verify_gin OK 6.86s 6 subtests passed [17:30:50.770] 274/399 postgresql:basebackup_to_shell / basebackup_to_shell/001_basic OK 6.04s 16 subtests passed [17:30:53.085] 275/399 postgresql:pg_stat_statements / pg_stat_statements/010_restart OK 4.30s 3 subtests passed [17:30:53.299] 276/399 postgresql:pg_stash_advice / pg_stash_advice/001_persist OK 4.84s 6 subtests passed [17:30:53.654] 277/399 postgresql:sepgsql / sepgsql/001_sepgsql SKIP 0.35s [17:30:55.083] 278/399 postgresql:amcheck / amcheck/001_verify_heapam OK 15.94s 272 subtests passed [17:30:55.127] 279/399 postgresql:pg_visibility / pg_visibility/002_corrupt_vm OK 4.47s 3 subtests passed [17:30:55.466] 280/399 postgresql:pg_visibility / pg_visibility/001_concurrent_transaction OK 5.12s 2 subtests passed [17:30:55.495] 281/399 postgresql:vacuumlo / vacuumlo/001_basic OK 0.41s 9 subtests passed [17:30:55.583] 282/399 postgresql:dblink / dblink/001_auth_scram OK 10.49s 12 subtests passed [17:30:59.107] 283/399 postgresql:test_decoding / test_decoding/001_repl_stats OK 5.45s 6 subtests passed [17:30:59.525] 284/399 postgresql:authentication / authentication/005_sspi SKIP 0.42s [17:30:59.655] 285/399 postgresql:authentication / authentication/004_file_inclusion OK 4.07s 2 subtests passed [17:30:59.836] 286/399 postgresql:authentication / authentication/002_saslprep OK 4.37s 20 subtests passed [17:31:00.332] 287/399 postgresql:postmaster / postmaster/001_basic OK 0.49s 9 subtests passed [17:31:00.628] 288/399 postgresql:postgres_fdw / postgres_fdw/010_subscription OK 7.54s 4 subtests passed [17:31:00.656] 289/399 postgresql:postgres_fdw / postgres_fdw/001_auth_scram OK 9.88s 7 subtests passed [17:31:01.203] 290/399 postgresql:authentication / authentication/003_peer OK 5.71s 53 subtests passed [17:31:03.701] 291/399 postgresql:authentication / authentication/006_login_trigger OK 4.17s 32 subtests passed [17:31:03.818] 292/399 postgresql:authentication / authentication/007_pre_auth OK 4.16s 2 subtests passed [17:31:04.419] 293/399 postgresql:authentication / authentication/001_password OK 9.29s 207 subtests passed [17:31:04.572] 294/399 postgresql:postmaster / postmaster/002_connection_limits OK 4.24s 30 subtests passed [17:31:04.588] 295/399 postgresql:postmaster / postmaster/003_start_stop OK 3.96s 25 subtests passed [17:31:09.255] 296/399 postgresql:bloom / bloom/001_wal OK 25.15s 31 subtests passed [17:31:11.479] 297/399 postgresql:subscription / subscription/002_types OK 10.27s 4 subtests passed [17:31:11.545] 298/399 postgresql:subscription / subscription/003_constraints OK 7.84s 6 subtests passed [17:31:11.622] 299/399 postgresql:subscription / subscription/005_encoding OK 7.20s 1 subtests passed [17:31:11.911] 300/399 postgresql:subscription / subscription/006_rewrite OK 7.34s 2 subtests passed [17:31:14.223] 301/399 postgresql:subscription / subscription/004_sync OK 10.40s 9 subtests passed [17:31:14.836] 302/399 postgresql:subscription / subscription/007_ddl OK 10.25s 8 subtests passed [17:31:18.200] 303/399 postgresql:subscription / subscription/001_rep_changes OK 17.54s 38 subtests passed [17:31:18.381] 304/399 postgresql:subscription / subscription/008_diff_schema OK 9.12s 5 subtests passed [17:31:18.798] 305/399 postgresql:subscription / subscription/009_matviews OK 7.32s 1 subtests passed [17:31:19.750] 306/399 postgresql:subscription / subscription/012_collation OK 7.84s 2 subtests passed [17:31:23.421] 307/399 postgresql:subscription / subscription/011_generated OK 11.80s 11 subtests passed [17:31:23.850] 308/399 postgresql:subscription / subscription/010_truncate OK 12.30s 14 subtests passed [17:31:26.683] 309/399 postgresql:subscription / subscription/014_binary OK 11.85s 8 subtests passed [17:31:26.709] 310/399 postgresql:subscription / subscription/016_stream_subxact OK 8.33s 3 subtests passed [17:31:27.020] 311/399 postgresql:subscription / subscription/017_stream_ddl OK 8.22s 3 subtests passed [17:31:31.897] 312/399 postgresql:subscription / subscription/020_messages OK 8.04s 5 subtests passed [17:31:31.991] 313/399 postgresql:subscription / subscription/018_stream_subxact_abort OK 12.24s 9 subtests passed [17:31:32.047] 314/399 postgresql:subscription / subscription/019_stream_subxact_ddl_abort OK 8.62s 2 subtests passed [17:31:37.400] 315/399 postgresql:subscription / subscription/015_stream OK 19.20s 10 subtests passed [17:31:39.750] 316/399 postgresql:subscription / subscription/013_partition OK 25.52s 74 subtests passed [17:31:41.719] 317/399 postgresql:subscription / subscription/024_add_drop_pub OK 9.82s 4 subtests passed [17:31:42.659] 318/399 postgresql:subscription / subscription/025_rep_changes_for_schema OK 10.67s 13 subtests passed [17:31:43.229] 319/399 postgresql:subscription / subscription/021_twophase OK 16.54s 31 subtests passed [17:31:44.236] 320/399 postgresql:subscription / subscription/023_twophase_stream OK 17.21s 34 subtests passed [17:31:45.315] 321/399 postgresql:subscription / subscription/022_twophase_cascade OK 18.60s 41 subtests passed [17:31:47.545] 322/399 postgresql:subscription / subscription/026_stats OK 15.50s 13 subtests passed [17:31:50.535] 323/399 postgresql:subscription / subscription/029_on_error OK 8.81s 5 subtests passed [17:31:55.986] 324/399 postgresql:subscription / subscription/033_run_as_table_owner OK 10.67s 10 subtests passed [17:31:56.402] 325/399 postgresql:subscription / subscription/028_row_filter OK 16.65s 26 subtests passed [17:31:57.508] 326/399 postgresql:subscription / subscription/027_nosuperuser OK 20.11s 19 subtests passed [17:31:58.595] 327/399 postgresql:subscription / subscription/030_origin OK 15.93s 13 subtests passed [17:32:00.503] 328/399 postgresql:subscription / subscription/032_subscribe_use_index OK 16.26s 15 subtests passed [17:32:03.587] 329/399 postgresql:subscription / subscription/034_temporal OK 16.04s 37 subtests passed [17:32:04.688] 330/399 postgresql:subscription / subscription/031_column_list OK 21.46s 36 subtests passed [17:32:05.108] 331/399 postgresql:subscription / subscription/035_conflicts OK 14.57s 29 subtests passed [17:32:05.333] 332/399 postgresql:brin / brin/01_workitems OK 4.83s 4 subtests passed [17:32:05.905] 333/399 postgresql:subscription / subscription/036_sequences OK 9.92s 9 subtests passed [17:32:07.939] 334/399 postgresql:brin / brin/02_wal_consistency OK 4.35s 2 subtests passed [17:32:08.164] 335/399 postgresql:subscription / subscription/038_walsnd_shutdown_timeout OK 10.65s 4 subtests passed [17:32:09.062] 336/399 postgresql:subscription / subscription/037_except OK 12.66s 17 subtests passed [17:32:09.612] 337/399 postgresql:commit_ts / commit_ts/001_base OK 4.92s 2 subtests passed [17:32:10.652] 338/399 postgresql:commit_ts / commit_ts/002_standby OK 5.54s 4 subtests passed [17:32:11.303] 339/399 postgresql:commit_ts / commit_ts/003_standby_2 OK 5.97s 4 subtests passed [17:32:11.581] 340/399 postgresql:commit_ts / commit_ts/004_restart OK 5.68s 16 subtests passed [17:32:11.791] 341/399 postgresql:libpq_pipeline / libpq_pipeline/001_libpq_pipeline OK 3.63s 23 subtests passed [17:32:11.833] 342/399 postgresql:ldap_password_func / ldap_password_func/001_mutated_bindpasswd OK 3.89s 4 subtests passed [17:32:14.381] 343/399 postgresql:oauth_validator / oauth_validator/002_client OK 4.77s 20 subtests passed [17:32:14.860] 344/399 postgresql:ssl_passphrase_callback / ssl_passphrase_callback/001_testfunc OK 4.21s 7 subtests passed [17:32:16.219] 345/399 postgresql:test_aio / test_aio/002_io_workers OK 4.64s 22 subtests passed [17:32:18.318] 346/399 postgresql:test_aio / test_aio/004_read_stream OK 6.47s 31 subtests passed [17:32:19.785] 347/399 postgresql:test_checksums / test_checksums/001_basic OK 4.92s 9 subtests passed [17:32:19.992] 348/399 postgresql:test_checksums / test_checksums/002_restarts OK 3.77s 5 subtests passed [17:32:20.423] 349/399 postgresql:test_autovacuum / test_autovacuum/001_parallel_autovacuum OK 6.04s 2 subtests passed [17:32:20.686] 350/399 postgresql:test_aio / test_aio/003_initdb OK 8.89s 6 subtests passed [17:32:20.727] 351/399 postgresql:test_checksums / test_checksums/006_pgbench_single SKIP 0.30s [17:32:20.963] 352/399 postgresql:test_checksums / test_checksums/007_pgbench_standby SKIP 0.27s [17:32:20.993] 353/399 postgresql:test_checksums / test_checksums/008_pitr SKIP 0.26s [17:32:23.700] 354/399 postgresql:test_checksums / test_checksums/003_standby_restarts OK 5.38s 12 subtests passed [17:32:24.156] 355/399 postgresql:test_checksums / test_checksums/005_injection OK 4.16s 3 subtests passed [17:32:25.013] 356/399 postgresql:test_checksums / test_checksums/004_offline OK 5.23s 8 subtests passed [17:32:25.073] 357/399 postgresql:test_custom_rmgrs / test_custom_rmgrs/001_basic OK 4.07s 2 subtests passed [17:32:25.583] 358/399 postgresql:test_int128 / test_int128/001_test_int128 OK 0.51s 2 subtests passed [17:32:27.791] 359/399 postgresql:oauth_validator / oauth_validator/001_server OK 18.73s 170 subtests passed [17:32:28.014] 360/399 postgresql:test_escape / test_escape/001_test_escape OK 3.85s 1218 subtests passed [17:32:28.356] 361/399 postgresql:test_json_parser / test_json_parser/003_test_semantic OK 0.32s 12 subtests passed [17:32:28.692] 362/399 postgresql:test_json_parser / test_json_parser/004_test_parser_perf OK 0.33s 2 subtests passed [17:32:29.300] 363/399 postgresql:test_extensions / test_extensions/001_extension_control_path OK 4.28s 11 subtests passed [17:32:29.394] 364/399 postgresql:subscription / subscription/100_bugs OK 30.80s 17 subtests passed [17:32:29.428] 365/399 postgresql:test_custom_stats / test_custom_stats/001_custom_stats OK 5.73s 15 subtests passed [17:32:30.564] 366/399 postgresql:test_aio / test_aio/001_aio OK 19.26s 826 subtests passed [17:32:30.691] 367/399 postgresql:test_json_parser / test_json_parser/001_test_json_parser_incremental OK 5.11s 516 subtests passed [17:32:32.873] 368/399 postgresql:test_json_parser / test_json_parser/002_inline OK 5.08s 3712 subtests passed [17:32:32.948] 369/399 postgresql:test_misc / test_misc/003_check_guc OK 3.55s 4 subtests passed [17:32:33.821] 370/399 postgresql:test_misc / test_misc/004_io_direct OK 4.39s 3 subtests passed [17:32:33.936] 371/399 postgresql:test_misc / test_misc/002_tablespace OK 4.64s 20 subtests passed [17:32:33.999] 372/399 postgresql:test_misc / test_misc/001_constraint_validation OK 5.30s 42 subtests passed [17:32:35.015] 373/399 postgresql:test_misc / test_misc/006_signal_autovacuum OK 4.32s 2 subtests passed [17:32:35.351] 374/399 postgresql:test_misc / test_misc/005_timeouts OK 4.75s 2 subtests passed [17:32:35.767] 375/399 postgresql:test_saslprep / test_saslprep/001_saslprep_ranges SKIP 0.41s [17:32:36.291] 376/399 postgresql:test_misc / test_misc/007_catcache_inval OK 3.37s 2 subtests passed [17:32:37.405] 377/399 postgresql:test_misc / test_misc/009_log_temp_files OK 3.58s 11 subtests passed [17:32:37.545] 378/399 postgresql:test_misc / test_misc/008_replslot_single_user OK 4.59s 10 subtests passed [17:32:38.810] 379/399 postgresql:test_misc / test_misc/011_lock_stats OK 4.81s 7 subtests passed [17:32:39.938] 380/399 postgresql:test_shmem / test_shmem/001_late_shmem_alloc OK 4.17s 2 subtests passed [17:32:40.305] 381/399 postgresql:xid_wraparound / xid_wraparound/001_emergency_vacuum SKIP 0.36s [17:32:40.619] 382/399 postgresql:test_slru / test_slru/001_multixact OK 4.33s 2 subtests passed [17:32:40.665] 383/399 postgresql:xid_wraparound / xid_wraparound/002_limits SKIP 0.36s [17:32:40.947] 384/399 postgresql:xid_wraparound / xid_wraparound/003_wraparounds SKIP 0.33s [17:32:42.478] 385/399 postgresql:test_slru / test_slru/002_multixact_wraparound OK 5.07s 18 subtests passed [17:32:42.851] 386/399 postgresql:test_misc / test_misc/010_index_concurrently_upsert OK 8.91s 73 subtests passed [17:32:43.191] 387/399 postgresql:worker_spi / worker_spi/001_worker_spi OK 5.64s 8 subtests passed [17:32:43.955] 388/399 postgresql:xid_wraparound / xid_wraparound/004_notify_freeze SKIP 3.29s [17:32:44.698] 389/399 postgresql:worker_spi / worker_spi/002_worker_terminate OK 5.89s 11 subtests passed [17:32:46.729] 390/399 postgresql:test_checksums / test_checksums/009_fpi OK 25.76s 7 subtests passed [17:32:47.620] 391/399 postgresql:test_pg_dump / test_pg_dump/001_base OK 12.60s 1044 subtests passed [17:32:49.331] 392/399 postgresql:ldap / ldap/002_bindpasswd OK 4.63s 3 subtests passed [17:32:49.399] 393/399 postgresql:ssl / ssl/002_scram OK 6.92s 28 subtests passed [17:32:49.444] 394/399 postgresql:ssl / ssl/003_sslinfo OK 6.59s 21 subtests passed [17:32:50.865] 395/399 postgresql:icu / icu/010_database OK 3.24s 8 subtests passed [17:32:51.339] 396/399 postgresql:ldap / ldap/003_ldap_connection_param_lookup OK 4.61s 26 subtests passed [17:32:52.148] 397/399 postgresql:ssl / ssl/004_sni OK 8.96s 102 subtests passed [17:32:52.200] 398/399 postgresql:ldap / ldap/001_auth OK 8.24s 47 subtests passed [17:32:55.693] 399/399 postgresql:ssl / ssl/001_ssltests OK 14.74s 272 subtests passed [17:32:55.810] [17:32:55.810] Summary of Failures: [17:32:55.810] [17:32:55.810] 8/399 postgresql:regress / regress/regress ERROR 132.55s exit status 1 [17:32:55.810] 31/399 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR 138.07s exit status 1 [17:32:55.810] 27/399 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 189.83s exit status 1 [17:32:55.810] 105/399 postgresql:pg_stat_statements / pg_stat_statements/regress ERROR 9.40s exit status 1 [17:32:55.810] 109/399 postgresql:pg_walinspect / pg_walinspect/regress ERROR 4.66s exit status 1 [17:32:55.810] 136/399 postgresql:postgres_fdw / postgres_fdw/regress ERROR 24.01s exit status 1 [17:32:55.810] 123/399 postgresql:recovery / recovery/027_stream_regress ERROR 163.43s exit status 1 [17:32:55.810] [17:32:55.810] Ok: 382 [17:32:55.810] Expected Fail: 0 [17:32:55.810] Fail: 7 [17:32:55.810] Unexpected Pass: 0 [17:32:55.810] Skipped: 10 [17:32:55.810] Timeout: 0 [17:32:55.810] [17:32:55.810] Full log written to /tmp/cirrus-ci-build/build/meson-logs/testlog.txt [17:32:56.003] [17:32:56.003] Exit status: 7