# Checking port 20554 # Found port 20554 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=20554 host=/tmp/2944h0JMNx Log file: /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/log/001_replan_regress_main.log [07:14:35.299](0.039s) # 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 io_method=io_uring The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: C.UTF-8 LC_CTYPE: C.UTF-8 LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C LC_TIME: C.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/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 ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/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 22589 # using postmaster on /tmp/2944h0JMNx, port 20554 ok 1 - test_setup 550 ms # parallel group (20 tests): char oid varchar name int2 text int4 txid pg_lsn boolean money float4 regproc float8 int8 enum bit uuid rangetypes numeric ok 2 + boolean 446 ms ok 3 + char 218 ms ok 4 + name 317 ms ok 5 + varchar 294 ms ok 6 + text 363 ms ok 7 + int2 320 ms ok 8 + int4 355 ms ok 9 + int8 596 ms ok 10 + oid 207 ms ok 11 + float4 484 ms ok 12 + float8 567 ms ok 13 + bit 721 ms ok 14 + numeric 2199 ms ok 15 + txid 355 ms ok 16 + uuid 731 ms ok 17 + enum 675 ms ok 18 + money 437 ms ok 19 + rangetypes 2100 ms ok 20 + pg_lsn 346 ms ok 21 + regproc 472 ms # parallel group (20 tests): md5 lseg line path circle time macaddr timetz point macaddr8 numerology date inet interval timestamp timestamptz polygon strings box multirangetypes ok 22 + strings 1554 ms ok 23 + md5 169 ms ok 24 + numerology 528 ms ok 25 + point 430 ms ok 26 + lseg 205 ms ok 27 + line 310 ms ok 28 + box 1700 ms ok 29 + path 322 ms ok 30 + polygon 1475 ms ok 31 + circle 346 ms ok 32 + date 626 ms ok 33 + time 372 ms ok 34 + timetz 401 ms ok 35 + timestamp 887 ms ok 36 + timestamptz 1365 ms ok 37 + interval 833 ms ok 38 + inet 625 ms ok 39 + macaddr 375 ms ok 40 + macaddr8 409 ms ok 41 + multirangetypes 2287 ms # parallel group (19 tests): euc_kr misc_sanity comments unicode pg_ndistinct pg_dependencies xid oid8 encoding expressions mvcc tstypes horology geometry type_sanity database regex stats_import opr_sanity ok 42 + geometry 1170 ms ok 43 + horology 1089 ms ok 44 + tstypes 893 ms ok 45 + regex 2114 ms ok 46 + type_sanity 1270 ms ok 47 + opr_sanity 2329 ms ok 48 + misc_sanity 193 ms ok 49 + comments 193 ms ok 50 + expressions 810 ms ok 51 + unicode 217 ms ok 52 + xid 439 ms ok 53 + mvcc 848 ms ok 54 + database 1246 ms ok 55 + stats_import 2133 ms ok 56 + pg_ndistinct 235 ms ok 57 + pg_dependencies 351 ms ok 58 + oid8 460 ms ok 59 + encoding 646 ms ok 60 + euc_kr 133 ms # parallel group (6 tests): copyencoding copyselect copydml insert_conflict copy insert ok 61 + copy 777 ms ok 62 + copyselect 124 ms ok 63 + copydml 145 ms ok 64 + copyencoding 79 ms ok 65 + insert 1959 ms ok 66 + insert_conflict 749 ms # parallel group (7 tests): create_function_c create_operator create_type create_misc create_procedure create_schema create_table ok 67 + create_function_c 75 ms ok 68 + create_misc 237 ms ok 69 + create_operator 124 ms ok 70 + create_procedure 375 ms ok 71 + create_table 2412 ms ok 72 + create_type 166 ms ok 73 + create_schema 556 ms # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index ok 74 + create_index 5181 ms ok 75 + create_index_spgist 1966 ms ok 76 + create_view 1479 ms ok 77 + index_including 896 ms ok 78 + index_including_gist 969 ms # parallel group (18 tests): create_cast create_aggregate errors roleattributes hash_func drop_if_exists select infinite_recurse typed_table create_function_sql create_am create_property_graph for_portion_of vacuum constraints updatable_views inherit triggers ok 79 + create_aggregate 75 ms ok 80 + create_function_sql 1171 ms ok 81 + create_cast 53 ms ok 82 + constraints 4069 ms ok 83 + triggers 11089 ms ok 84 + select 774 ms ok 85 + inherit 5892 ms ok 86 + typed_table 1092 ms ok 87 + vacuum 2733 ms ok 88 + drop_if_exists 545 ms ok 89 + updatable_views 4893 ms ok 90 + roleattributes 384 ms ok 91 + create_am 1275 ms ok 92 + hash_func 415 ms ok 93 + errors 196 ms ok 94 + infinite_recurse 1037 ms ok 95 + create_property_graph 1664 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:09.594871958 +0000 # +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05 07:14:58.240209658 +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 2485 ms ok 97 - sanity_check 381 ms # parallel group (20 tests): select_having delete select_distinct_on case select_implicit select_into namespace random prepared_xacts transactions select_distinct portals arrays union subselect update hash_index join aggregates btree_index ok 98 + select_into 433 ms ok 99 + select_distinct 892 ms ok 100 + select_distinct_on 275 ms ok 101 + select_implicit 302 ms ok 102 + select_having 206 ms ok 103 + subselect 2072 ms ok 104 + union 1109 ms ok 105 + case 264 ms ok 106 + join 3102 ms ok 107 + aggregates 3194 ms ok 108 + transactions 667 ms ok 109 + random 646 ms ok 110 + portals 917 ms ok 111 + arrays 1068 ms ok 112 + btree_index 9889 ms ok 113 + hash_index 2891 ms ok 114 + update 2190 ms ok 115 + delete 205 ms ok 116 + namespace 428 ms ok 117 + prepared_xacts 631 ms # parallel group (20 tests): init_privs drop_operator security_label tablesample password lock object_address collate replica_identity groupingsets matview identity spgist gin gist rowsecurity generated_stored join_hash brin privileges ok 118 + brin 6137 ms ok 119 + gin 4215 ms ok 120 + gist 4332 ms ok 121 + spgist 3504 ms ok 122 + privileges 8801 ms ok 123 + init_privs 159 ms ok 124 + security_label 293 ms ok 125 + collate 1196 ms ok 126 + matview 2967 ms ok 127 + lock 694 ms ok 128 + replica_identity 1879 ms ok 129 + rowsecurity 4518 ms ok 130 + object_address 815 ms ok 131 + tablesample 568 ms ok 132 + groupingsets 2211 ms ok 133 + drop_operator 254 ms ok 134 + password 647 ms ok 135 + identity 2986 ms ok 136 + generated_stored 4916 ms ok 137 + join_hash 6040 ms # parallel group (2 tests): brin_bloom brin_multi ok 138 + brin_bloom 674 ms ok 139 + brin_multi 1553 ms # parallel group (20 tests): async dbsize nls alter_operator tid collate.utf8 tsrf tidscan create_role sysviews tidrangescan misc_functions alter_generic misc incremental_sort merge collate.icu.utf8 create_table_like without_overlaps generated_virtual ok 140 + create_table_like 3565 ms ok 141 + alter_generic 877 ms ok 142 + alter_operator 350 ms ok 143 + misc 954 ms ok 144 + async 131 ms ok 145 + dbsize 137 ms ok 146 + merge 2771 ms ok 147 + misc_functions 760 ms ok 148 + nls 139 ms ok 149 + sysviews 576 ms ok 150 + tsrf 431 ms ok 151 + tid 342 ms ok 152 + tidscan 433 ms ok 153 + tidrangescan 678 ms ok 154 + collate.utf8 346 ms ok 155 + collate.icu.utf8 3296 ms ok 156 + incremental_sort 1167 ms ok 157 + create_role 528 ms ok 158 + without_overlaps 4284 ms ok 159 + generated_virtual 4534 ms # parallel group (8 tests): collate.windows.win1252 collate.linux.utf8 amutils psql_crosstab psql_pipeline rules psql stats_ext ok 160 + rules 1109 ms ok 161 + psql 2839 ms ok 162 + psql_crosstab 140 ms ok 163 + psql_pipeline 183 ms ok 164 + amutils 131 ms ok 165 + stats_ext 5261 ms ok 166 + collate.linux.utf8 74 ms ok 167 + collate.windows.win1252 24 ms ok 168 - select_parallel 3410 ms ok 169 - write_parallel 300 ms ok 170 - vacuum_parallel 297 ms ok 171 - maintain_every 87 ms # parallel group (2 tests): subscription publication ok 172 + publication 4226 ms ok 173 + subscription 217 ms # parallel group (18 tests): portals_p2 combocid advisory_lock xmlmap functional_deps tsdicts equivclass dependency guc stats_rewrite select_views indirect_toast window bitmapops graph_table tsearch foreign_data foreign_key ok 174 + select_views 721 ms ok 175 + portals_p2 184 ms ok 176 + foreign_key 8575 ms ok 177 + dependency 509 ms ok 178 + guc 509 ms ok 179 + bitmapops 1389 ms ok 180 + combocid 180 ms ok 181 + tsearch 1602 ms ok 182 + tsdicts 375 ms ok 183 + foreign_data 3132 ms ok 184 + window 1348 ms ok 185 + xmlmap 282 ms ok 186 + functional_deps 347 ms ok 187 + advisory_lock 260 ms ok 188 + indirect_toast 1197 ms ok 189 + equivclass 479 ms ok 190 + stats_rewrite 659 ms ok 191 + graph_table 1489 ms # parallel group (9 tests): jsonpath_encoding json_encoding jsonpath sqljson_jsontable jsonb_jsonpath sqljson sqljson_queryfuncs json jsonb ok 192 + json 753 ms ok 193 + jsonb 1576 ms ok 194 + json_encoding 126 ms ok 195 + jsonpath 338 ms ok 196 + jsonpath_encoding 119 ms ok 197 + jsonb_jsonpath 671 ms ok 198 + sqljson 671 ms ok 199 + sqljson_queryfuncs 724 ms ok 200 + sqljson_jsontable 451 ms # parallel group (18 tests): prepare conversion plancache returning limit largeobject rowtypes sequence truncate copy2 polymorphism temp with rangefuncs domain xml plpgsql alter_table ok 201 + plancache 627 ms ok 202 + limit 925 ms ok 203 + plpgsql 9481 ms ok 204 + copy2 1354 ms ok 205 + temp 1608 ms ok 206 + domain 1888 ms ok 207 + rangefuncs 1661 ms ok 208 + prepare 276 ms ok 209 + conversion 576 ms ok 210 + truncate 1322 ms ok 211 + alter_table 12266 ms ok 212 + sequence 1277 ms ok 213 + polymorphism 1478 ms ok 214 + rowtypes 1173 ms ok 215 + returning 870 ms ok 216 + largeobject 1034 ms ok 217 + with 1616 ms ok 218 + xml 3826 ms # parallel group (18 tests): planner_est hash_part numa reloptions explain partition_info predicate graph_table_rls memoize eager_aggregate partition_merge stats partition_aggregate partition_split partition_join tuplesort partition_prune indexing ok 219 + partition_merge 2996 ms ok 220 + partition_split 3943 ms ok 221 + partition_join 4494 ms ok 222 + partition_prune 4756 ms ok 223 + reloptions 421 ms ok 224 + hash_part 258 ms ok 225 + indexing 5803 ms ok 226 + partition_aggregate 3807 ms ok 227 + partition_info 646 ms ok 228 + tuplesort 4691 ms ok 229 + explain 627 ms ok 230 + memoize 1466 ms ok 231 + stats 3649 ms ok 232 + predicate 700 ms ok 233 + numa 316 ms ok 234 + eager_aggregate 2374 ms ok 235 + graph_table_rls 731 ms ok 236 + planner_est 158 ms # parallel group (4 tests): compression_pglz compression_lz4 compression cluster ok 237 + compression 557 ms ok 238 + compression_lz4 487 ms ok 239 + compression_pglz 66 ms ok 240 + cluster 1072 ms # parallel group (2 tests): oidjoins event_trigger ok 241 + oidjoins 890 ms ok 242 + event_trigger 1033 ms ok 243 - event_trigger_login 95 ms ok 244 - fast_default 496 ms ok 245 - tablespace 1533 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:09.594871958 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05 07:14:58.240209658 +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:16:19.064](103.765s) not ok 1 - regression tests pass [07:16:19.065](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:16:19.067](0.002s) # got: '256' # expected: '0' [07:16:19.069](0.002s) 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:16:19.292](0.223s) # Looks like you failed 1 test of 1.