# Checking port 10221 # Found port 10221 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=10221 host=/tmp/8wMzPwhUe3 Log file: /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/log/001_replan_regress_main.log [07:44:48.557](0.043s) # 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 25427 # using postmaster on /tmp/8wMzPwhUe3, port 10221 ok 1 - test_setup 1173 ms # parallel group (20 tests): char pg_lsn varchar oid txid name int2 float4 text money int4 boolean int8 regproc float8 bit uuid enum numeric rangetypes ok 2 + boolean 415 ms ok 3 + char 211 ms ok 4 + name 305 ms ok 5 + varchar 260 ms ok 6 + text 354 ms ok 7 + int2 314 ms ok 8 + int4 374 ms ok 9 + int8 480 ms ok 10 + oid 270 ms ok 11 + float4 333 ms ok 12 + float8 524 ms ok 13 + bit 536 ms ok 14 + numeric 1927 ms ok 15 + txid 288 ms ok 16 + uuid 540 ms ok 17 + enum 610 ms ok 18 + money 367 ms ok 19 + rangetypes 1941 ms ok 20 + pg_lsn 237 ms ok 21 + regproc 420 ms # parallel group (20 tests): lseg md5 circle line path point time timetz macaddr8 macaddr numerology inet date interval timestamp timestamptz polygon strings box multirangetypes ok 22 + strings 985 ms ok 23 + md5 174 ms ok 24 + numerology 339 ms ok 25 + point 277 ms ok 26 + lseg 53 ms ok 27 + line 252 ms ok 28 + box 1057 ms ok 29 + path 253 ms ok 30 + polygon 910 ms ok 31 + circle 230 ms ok 32 + date 504 ms ok 33 + time 264 ms ok 34 + timetz 281 ms ok 35 + timestamp 739 ms ok 36 + timestamptz 816 ms ok 37 + interval 731 ms ok 38 + inet 476 ms ok 39 + macaddr 257 ms ok 40 + macaddr8 252 ms ok 41 + multirangetypes 1687 ms # parallel group (19 tests): comments euc_kr unicode misc_sanity pg_ndistinct pg_dependencies oid8 xid encoding mvcc expressions tstypes horology geometry type_sanity database regex stats_import opr_sanity ok 42 + geometry 922 ms ok 43 + horology 913 ms ok 44 + tstypes 763 ms ok 45 + regex 1668 ms ok 46 + type_sanity 1039 ms ok 47 + opr_sanity 2033 ms ok 48 + misc_sanity 264 ms ok 49 + comments 163 ms ok 50 + expressions 703 ms ok 51 + unicode 203 ms ok 52 + xid 494 ms ok 53 + mvcc 650 ms ok 54 + database 1021 ms ok 55 + stats_import 1925 ms ok 56 + pg_ndistinct 307 ms ok 57 + pg_dependencies 343 ms ok 58 + oid8 459 ms ok 59 + encoding 597 ms ok 60 + euc_kr 156 ms # parallel group (6 tests): copyencoding copyselect copydml copy insert_conflict insert ok 61 + copy 642 ms ok 62 + copyselect 153 ms ok 63 + copydml 202 ms ok 64 + copyencoding 98 ms ok 65 + insert 1686 ms ok 66 + insert_conflict 736 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 49 ms ok 68 + create_misc 227 ms ok 69 + create_operator 94 ms ok 70 + create_procedure 240 ms ok 71 + create_table 1966 ms ok 72 + create_type 139 ms ok 73 + create_schema 368 ms # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index ok 74 + create_index 5029 ms ok 75 + create_index_spgist 2474 ms ok 76 + create_view 2046 ms ok 77 + index_including 866 ms ok 78 + index_including_gist 1189 ms # parallel group (18 tests): errors create_cast create_aggregate roleattributes hash_func drop_if_exists select typed_table create_function_sql infinite_recurse create_am create_property_graph for_portion_of vacuum constraints updatable_views inherit triggers ok 79 + create_aggregate 279 ms ok 80 + create_function_sql 1046 ms ok 81 + create_cast 214 ms ok 82 + constraints 4303 ms ok 83 + triggers 7796 ms ok 84 + select 608 ms ok 85 + inherit 6581 ms ok 86 + typed_table 1003 ms ok 87 + vacuum 2775 ms ok 88 + drop_if_exists 542 ms ok 89 + updatable_views 4332 ms ok 90 + roleattributes 355 ms ok 91 + create_am 1166 ms ok 92 + hash_func 402 ms ok 93 + errors 169 ms ok 94 + infinite_recurse 1036 ms ok 95 + create_property_graph 1512 ms ok 96 + for_portion_of 2009 ms ok 97 - sanity_check 663 ms # parallel group (20 tests): delete select_having select_distinct_on case select_implicit namespace select_into random prepared_xacts transactions portals select_distinct union arrays update subselect hash_index join aggregates btree_index ok 98 + select_into 534 ms ok 99 + select_distinct 1068 ms ok 100 + select_distinct_on 319 ms ok 101 + select_implicit 426 ms ok 102 + select_having 314 ms ok 103 + subselect 2336 ms ok 104 + union 1231 ms ok 105 + case 403 ms ok 106 + join 3790 ms ok 107 + aggregates 3847 ms ok 108 + transactions 1003 ms ok 109 + random 693 ms ok 110 + portals 1032 ms ok 111 + arrays 1505 ms ok 112 + btree_index 7170 ms ok 113 + hash_index 3066 ms ok 114 + update 2211 ms ok 115 + delete 294 ms ok 116 + namespace 438 ms ok 117 + prepared_xacts 737 ms # parallel group (20 tests): init_privs security_label drop_operator lock password tablesample object_address collate replica_identity groupingsets matview identity spgist gist rowsecurity gin generated_stored join_hash brin privileges ok 118 + brin 7911 ms ok 119 + gin 6277 ms ok 120 + gist 6166 ms ok 121 + spgist 4774 ms ok 122 + privileges 9389 ms ok 123 + init_privs 205 ms ok 124 + security_label 425 ms ok 125 + collate 1749 ms ok 126 + matview 4354 ms ok 127 + lock 904 ms ok 128 + replica_identity 2407 ms ok 129 + rowsecurity 6256 ms ok 130 + object_address 998 ms ok 131 + tablesample 983 ms ok 132 + groupingsets 3281 ms ok 133 + drop_operator 438 ms ok 134 + password 972 ms ok 135 + identity 4621 ms ok 136 + generated_stored 6410 ms ok 137 + join_hash 7855 ms # parallel group (2 tests): brin_bloom brin_multi ok 138 + brin_bloom 544 ms ok 139 + brin_multi 3192 ms # parallel group (20 tests): async nls dbsize alter_operator tid collate.utf8 tidscan tsrf create_role alter_generic sysviews tidrangescan misc_functions misc incremental_sort merge collate.icu.utf8 create_table_like generated_virtual without_overlaps ok 140 + create_table_like 2766 ms ok 141 + alter_generic 675 ms ok 142 + alter_operator 332 ms ok 143 + misc 954 ms ok 144 + async 118 ms ok 145 + dbsize 160 ms ok 146 + merge 1954 ms ok 147 + misc_functions 816 ms ok 148 + nls 117 ms ok 149 + sysviews 668 ms ok 150 + tsrf 414 ms ok 151 + tid 342 ms ok 152 + tidscan 380 ms ok 153 + tidrangescan 681 ms ok 154 + collate.utf8 354 ms ok 155 + collate.icu.utf8 2452 ms ok 156 + incremental_sort 1070 ms ok 157 + create_role 521 ms ok 158 + without_overlaps 4363 ms # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out # --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.065096072 +0000 # +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-05-03 07:45:40.620351245 +0000 # @@ -1154,9 +1154,10 @@ # f2 | bigint | | | | plain | | # f3 | bigint | | | generated always as (f2 * 2) | plain | | # Partition key: RANGE (f3) # -Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'), # - gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'), # - gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100') # +Partitions: # + gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30') # + gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50') # + gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100') # # INSERT INTO gtest_part_key1(f2) VALUES (9); -- error # ERROR: no partition of relation "gtest_part_key1" found for row not ok 159 + generated_virtual 4321 ms # parallel group (8 tests): collate.windows.win1252 collate.linux.utf8 amutils psql_crosstab psql_pipeline rules psql stats_ext ok 160 + rules 2344 ms ok 161 + psql 2816 ms ok 162 + psql_crosstab 161 ms ok 163 + psql_pipeline 165 ms ok 164 + amutils 118 ms ok 165 + stats_ext 6246 ms ok 166 + collate.linux.utf8 65 ms ok 167 + collate.windows.win1252 31 ms ok 168 - select_parallel 3208 ms ok 169 - write_parallel 553 ms ok 170 - vacuum_parallel 1068 ms ok 171 - maintain_every 125 ms # parallel group (2 tests): subscription publication ok 172 + publication 2486 ms ok 173 + subscription 410 ms # parallel group (18 tests): portals_p2 advisory_lock combocid xmlmap functional_deps tsdicts dependency equivclass guc select_views stats_rewrite indirect_toast bitmapops window graph_table tsearch foreign_data foreign_key ok 174 + select_views 596 ms ok 175 + portals_p2 176 ms ok 176 + foreign_key 7891 ms ok 177 + dependency 439 ms ok 178 + guc 483 ms ok 179 + bitmapops 1262 ms ok 180 + combocid 249 ms ok 181 + tsearch 1603 ms ok 182 + tsdicts 385 ms ok 183 + foreign_data 3773 ms ok 184 + window 1441 ms ok 185 + xmlmap 302 ms ok 186 + functional_deps 363 ms ok 187 + advisory_lock 191 ms ok 188 + indirect_toast 1089 ms ok 189 + equivclass 438 ms ok 190 + stats_rewrite 669 ms ok 191 + graph_table 1564 ms # parallel group (9 tests): jsonpath_encoding json_encoding jsonpath sqljson_jsontable sqljson sqljson_queryfuncs json jsonb_jsonpath jsonb ok 192 + json 562 ms ok 193 + jsonb 963 ms ok 194 + json_encoding 76 ms ok 195 + jsonpath 171 ms ok 196 + jsonpath_encoding 63 ms ok 197 + jsonb_jsonpath 704 ms ok 198 + sqljson 442 ms ok 199 + sqljson_queryfuncs 473 ms ok 200 + sqljson_jsontable 339 ms # parallel group (18 tests): prepare conversion plancache limit returning largeobject copy2 rowtypes sequence truncate with polymorphism temp rangefuncs domain xml plpgsql alter_table ok 201 + plancache 586 ms ok 202 + limit 801 ms ok 203 + plpgsql 5548 ms ok 204 + copy2 1077 ms ok 205 + temp 1564 ms ok 206 + domain 1892 ms ok 207 + rangefuncs 1743 ms ok 208 + prepare 133 ms ok 209 + conversion 533 ms ok 210 + truncate 1289 ms ok 211 + alter_table 11920 ms ok 212 + sequence 1263 ms ok 213 + polymorphism 1531 ms ok 214 + rowtypes 1071 ms ok 215 + returning 839 ms ok 216 + largeobject 1002 ms ok 217 + with 1288 ms ok 218 + xml 2953 ms # parallel group (18 tests): planner_est hash_part numa reloptions explain partition_info predicate memoize graph_table_rls eager_aggregate partition_merge partition_aggregate partition_split stats partition_prune partition_join tuplesort indexing ok 219 + partition_merge 2998 ms ok 220 + partition_split 3386 ms ok 221 + partition_join 4251 ms ok 222 + partition_prune 4174 ms ok 223 + reloptions 383 ms ok 224 + hash_part 217 ms ok 225 + indexing 5109 ms ok 226 + partition_aggregate 3036 ms ok 227 + partition_info 553 ms ok 228 + tuplesort 4324 ms ok 229 + explain 551 ms ok 230 + memoize 744 ms ok 231 + stats 3685 ms ok 232 + predicate 663 ms ok 233 + numa 231 ms ok 234 + eager_aggregate 1955 ms ok 235 + graph_table_rls 817 ms ok 236 + planner_est 167 ms # parallel group (4 tests): compression_pglz compression_lz4 compression cluster ok 237 + compression 500 ms ok 238 + compression_lz4 422 ms ok 239 + compression_pglz 77 ms ok 240 + cluster 960 ms # parallel group (2 tests): oidjoins event_trigger ok 241 + oidjoins 809 ms ok 242 + event_trigger 898 ms ok 243 - event_trigger_login 73 ms ok 244 - fast_default 522 ms ok 245 - tablespace 1899 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/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out --- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.065096072 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-05-03 07:45:40.620351245 +0000 @@ -1154,9 +1154,10 @@ f2 | bigint | | | | plain | | f3 | bigint | | | generated always as (f2 * 2) | plain | | Partition key: RANGE (f3) -Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'), - gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'), - gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100') +Partitions: + gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30') + gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50') + gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100') INSERT INTO gtest_part_key1(f2) VALUES (9); -- error ERROR: no partition of relation "gtest_part_key1" found for row === EOF === [07:46:25.160](96.603s) not ok 1 - regression tests pass [07:46:25.165](0.005s) # Failed test 'regression tests pass' # at /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/t/001_replan_regress.pl line 64. [07:46:25.165](0.000s) # got: '256' # expected: '0' [07:46:25.165](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:46:25.284](0.119s) # Looks like you failed 1 test of 1.