# Checking port 15394 # Found port 15394 Name: main Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_data/archives Connection string: port=15394 host=/tmp/tBitqUCfeI Log file: /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/log/001_replan_regress_main.log [07:12:27.378](0.029s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_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/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_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/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_data/pgdata ### Starting node "main" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/log/001_replan_regress_main.log --options --cluster-name=main start waiting for server to start.... done server started # Postmaster PID for node "main" is 7167 # using postmaster on /tmp/tBitqUCfeI, port 15394 ok 1 - test_setup 728 ms # parallel group (20 tests): char varchar pg_lsn name txid float4 oid text uuid boolean int4 int2 bit regproc money enum int8 float8 rangetypes numeric ok 2 + boolean 553 ms ok 3 + char 143 ms ok 4 + name 312 ms ok 5 + varchar 211 ms ok 6 + text 480 ms ok 7 + int2 622 ms ok 8 + int4 581 ms ok 9 + int8 2639 ms ok 10 + oid 429 ms ok 11 + float4 422 ms ok 12 + float8 3031 ms ok 13 + bit 1469 ms ok 14 + numeric 6695 ms ok 15 + txid 387 ms ok 16 + uuid 507 ms ok 17 + enum 2144 ms ok 18 + money 2105 ms ok 19 + rangetypes 4516 ms ok 20 + pg_lsn 309 ms ok 21 + regproc 1975 ms # parallel group (20 tests): path circle timetz lseg point macaddr time macaddr8 box line numerology md5 polygon inet timestamp date timestamptz interval strings multirangetypes ok 22 + strings 9976 ms ok 23 + md5 741 ms ok 24 + numerology 569 ms ok 25 + point 244 ms ok 26 + lseg 207 ms ok 27 + line 563 ms ok 28 + box 561 ms ok 29 + path 76 ms ok 30 + polygon 769 ms ok 31 + circle 79 ms ok 32 + date 5089 ms ok 33 + time 398 ms ok 34 + timetz 171 ms ok 35 + timestamp 3756 ms ok 36 + timestamptz 8128 ms ok 37 + interval 8379 ms ok 38 + inet 3530 ms ok 39 + macaddr 370 ms ok 40 + macaddr8 413 ms ok 41 + multirangetypes 13947 ms # parallel group (19 tests): euc_kr comments misc_sanity mvcc unicode expressions oid8 encoding type_sanity xid pg_ndistinct pg_dependencies database tstypes opr_sanity geometry regex stats_import horology ok 42 + geometry 2583 ms ok 43 + horology 4539 ms ok 44 + tstypes 2257 ms ok 45 + regex 2860 ms ok 46 + type_sanity 725 ms ok 47 + opr_sanity 2450 ms ok 48 + misc_sanity 297 ms ok 49 + comments 154 ms ok 50 + expressions 457 ms ok 51 + unicode 352 ms ok 52 + xid 750 ms ok 53 + mvcc 308 ms ok 54 + database 1472 ms ok 55 + stats_import 3182 ms ok 56 + pg_ndistinct 1426 ms ok 57 + pg_dependencies 1432 ms ok 58 + oid8 509 ms ok 59 + encoding 708 ms ok 60 + euc_kr 64 ms # parallel group (6 tests): copydml copyencoding copyselect copy insert_conflict insert ok 61 + copy 803 ms ok 62 + copyselect 427 ms ok 63 + copydml 124 ms ok 64 + copyencoding 273 ms ok 65 + insert 3129 ms ok 66 + insert_conflict 838 ms # parallel group (7 tests): create_function_c create_operator create_procedure create_misc create_type create_schema create_table ok 67 + create_function_c 146 ms ok 68 + create_misc 915 ms ok 69 + create_operator 760 ms ok 70 + create_procedure 888 ms ok 71 + create_table 6082 ms ok 72 + create_type 1346 ms ok 73 + create_schema 1678 ms # parallel group (5 tests): index_including_gist index_including create_index_spgist create_view create_index ok 74 + create_index 8066 ms ok 75 + create_index_spgist 2693 ms ok 76 + create_view 2927 ms ok 77 + index_including 1675 ms ok 78 + index_including_gist 1053 ms # parallel group (18 tests): create_cast create_aggregate errors infinite_recurse roleattributes drop_if_exists select hash_func create_function_sql create_am vacuum typed_table create_property_graph for_portion_of triggers updatable_views constraints inherit ok 79 + create_aggregate 375 ms ok 80 + create_function_sql 1963 ms ok 81 + create_cast 172 ms ok 82 + constraints 15684 ms ok 83 + triggers 8684 ms ok 84 + select 1219 ms ok 85 + inherit 20228 ms ok 86 + typed_table 3856 ms ok 87 + vacuum 3837 ms ok 88 + drop_if_exists 844 ms ok 89 + updatable_views 9709 ms ok 90 + roleattributes 751 ms ok 91 + create_am 2626 ms ok 92 + hash_func 1251 ms ok 93 + errors 400 ms ok 94 + infinite_recurse 516 ms ok 95 + create_property_graph 4095 ms # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_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/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05 07:13:19.335050000 +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 not ok 96 + for_portion_of 5675 ms ok 97 - sanity_check 258 ms # parallel group (20 tests): select_having select_distinct_on delete case random select_into namespace select_implicit portals select_distinct hash_index prepared_xacts btree_index update transactions subselect union join aggregates arrays ok 98 + select_into 650 ms ok 99 + select_distinct 1277 ms ok 100 + select_distinct_on 434 ms ok 101 + select_implicit 778 ms ok 102 + select_having 246 ms ok 103 + subselect 4189 ms ok 104 + union 4249 ms ok 105 + case 636 ms ok 106 + join 7477 ms ok 107 + aggregates 9195 ms ok 108 + transactions 4008 ms ok 109 + random 644 ms ok 110 + portals 1235 ms ok 111 + arrays 13500 ms ok 112 + btree_index 3013 ms ok 113 + hash_index 1525 ms ok 114 + update 3818 ms ok 115 + delete 436 ms ok 116 + namespace 698 ms ok 117 + prepared_xacts 1920 ms # parallel group (20 tests): init_privs drop_operator security_label password lock tablesample spgist gist gin groupingsets replica_identity object_address collate join_hash brin rowsecurity matview identity generated_stored privileges ok 118 + brin 8028 ms ok 119 + gin 1892 ms ok 120 + gist 1763 ms ok 121 + spgist 1263 ms ok 122 + privileges 17121 ms ok 123 + init_privs 151 ms ok 124 + security_label 462 ms ok 125 + collate 3996 ms ok 126 + matview 10768 ms ok 127 + lock 1055 ms ok 128 + replica_identity 2635 ms ok 129 + rowsecurity 10599 ms ok 130 + object_address 3537 ms ok 131 + tablesample 1070 ms ok 132 + groupingsets 1961 ms ok 133 + drop_operator 212 ms ok 134 + password 668 ms ok 135 + identity 11976 ms ok 136 + generated_stored 17068 ms ok 137 + join_hash 7190 ms # parallel group (2 tests): brin_bloom brin_multi ok 138 + brin_bloom 1949 ms ok 139 + brin_multi 8854 ms # parallel group (20 tests): async nls tidscan tid tidrangescan sysviews alter_operator create_role misc dbsize collate.utf8 incremental_sort tsrf alter_generic misc_functions merge without_overlaps create_table_like collate.icu.utf8 generated_virtual ok 140 + create_table_like 13501 ms ok 141 + alter_generic 2582 ms ok 142 + alter_operator 626 ms ok 143 + misc 748 ms ok 144 + async 181 ms ok 145 + dbsize 782 ms ok 146 + merge 5964 ms ok 147 + misc_functions 4629 ms ok 148 + nls 215 ms ok 149 + sysviews 551 ms ok 150 + tsrf 2364 ms ok 151 + tid 406 ms ok 152 + tidscan 354 ms ok 153 + tidrangescan 513 ms ok 154 + collate.utf8 976 ms ok 155 + collate.icu.utf8 14976 ms ok 156 + incremental_sort 1178 ms ok 157 + create_role 688 ms ok 158 + without_overlaps 10673 ms ok 159 + generated_virtual 16426 ms # parallel group (8 tests): collate.linux.utf8 collate.windows.win1252 amutils psql_crosstab psql_pipeline rules psql stats_ext ok 160 + rules 6551 ms ok 161 + psql 16210 ms ok 162 + psql_crosstab 1269 ms ok 163 + psql_pipeline 1794 ms ok 164 + amutils 541 ms ok 165 + stats_ext 22768 ms ok 166 + collate.linux.utf8 31 ms ok 167 + collate.windows.win1252 32 ms ok 168 - select_parallel 6819 ms ok 169 - write_parallel 378 ms ok 170 - vacuum_parallel 199 ms ok 171 - maintain_every 96 ms # parallel group (2 tests): subscription publication ok 172 + publication 14152 ms ok 173 + subscription 555 ms # parallel group (18 tests): combocid portals_p2 functional_deps bitmapops equivclass dependency stats_rewrite select_views indirect_toast advisory_lock window xmlmap guc tsdicts graph_table foreign_key tsearch foreign_data ok 174 + select_views 816 ms ok 175 + portals_p2 361 ms ok 176 + foreign_key 14284 ms ok 177 + dependency 743 ms ok 178 + guc 3007 ms ok 179 + bitmapops 591 ms ok 180 + combocid 314 ms ok 181 + tsearch 15035 ms ok 182 + tsdicts 4254 ms ok 183 + foreign_data 17770 ms ok 184 + window 1338 ms ok 185 + xmlmap 1863 ms ok 186 + functional_deps 366 ms ok 187 + advisory_lock 1024 ms ok 188 + indirect_toast 982 ms ok 189 + equivclass 636 ms ok 190 + stats_rewrite 794 ms ok 191 + graph_table 4726 ms # parallel group (9 tests): json_encoding jsonpath_encoding sqljson_jsontable sqljson sqljson_queryfuncs jsonpath json jsonb jsonb_jsonpath ok 192 + json 13607 ms ok 193 + jsonb 28750 ms ok 194 + json_encoding 111 ms ok 195 + jsonpath 9308 ms ok 196 + jsonpath_encoding 148 ms ok 197 + jsonb_jsonpath 30769 ms ok 198 + sqljson 6666 ms ok 199 + sqljson_queryfuncs 9206 ms ok 200 + sqljson_jsontable 1355 ms # parallel group (18 tests): prepare conversion plancache limit largeobject returning polymorphism truncate temp copy2 sequence rowtypes with domain rangefuncs plpgsql xml alter_table ok 201 + plancache 850 ms ok 202 + limit 899 ms ok 203 + plpgsql 6729 ms ok 204 + copy2 1993 ms ok 205 + temp 1901 ms ok 206 + domain 3625 ms ok 207 + rangefuncs 4718 ms ok 208 + prepare 257 ms ok 209 + conversion 349 ms ok 210 + truncate 1751 ms ok 211 + alter_table 22162 ms ok 212 + sequence 2171 ms ok 213 + polymorphism 1346 ms ok 214 + rowtypes 2361 ms ok 215 + returning 1128 ms ok 216 + largeobject 1088 ms ok 217 + with 2453 ms ok 218 + xml 6757 ms # parallel group (18 tests): numa reloptions graph_table_rls predicate partition_aggregate hash_part eager_aggregate explain planner_est tuplesort memoize partition_info partition_join stats partition_merge partition_split indexing partition_prune ok 219 + partition_merge 9486 ms ok 220 + partition_split 13312 ms ok 221 + partition_join 7894 ms ok 222 + partition_prune 23311 ms ok 223 + reloptions 828 ms ok 224 + hash_part 2145 ms ok 225 + indexing 22780 ms ok 226 + partition_aggregate 2132 ms ok 227 + partition_info 5214 ms ok 228 + tuplesort 4049 ms ok 229 + explain 2997 ms ok 230 + memoize 4321 ms ok 231 + stats 9307 ms ok 232 + predicate 1990 ms ok 233 + numa 274 ms ok 234 + eager_aggregate 2450 ms ok 235 + graph_table_rls 1638 ms ok 236 + planner_est 3314 ms # parallel group (4 tests): compression_pglz compression_lz4 cluster compression ok 237 + compression 3236 ms ok 238 + compression_lz4 2892 ms ok 239 + compression_pglz 146 ms ok 240 + cluster 3119 ms # parallel group (2 tests): oidjoins event_trigger ok 241 + oidjoins 744 ms ok 242 + event_trigger 2353 ms ok 243 - event_trigger_login 103 ms ok 244 - fast_default 2495 ms ok 245 - tablespace 5593 ms 1..245 # 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/test_plan_advice/001_replan_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/test_plan_advice/001_replan_regress/data/regression.out". === dumping /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/regression.diffs === diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_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/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05 07:13:19.335050000 +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 === EOF === [07:17:02.563](275.185s) not ok 1 - regression tests pass [07:17:02.563](0.000s) # Failed test 'regression tests pass' # at /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/t/001_replan_regress.pl line 64. [07:17:02.563](0.000s) # got: '256' # expected: '0' [07:17:02.563](0.000s) 1..1 ### Stopping node "main" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/t_001_replan_regress_main_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "main" [07:17:02.671](0.108s) # Looks like you failed 1 test of 1.