# Checking port 30276 # Found port 30276 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=30276 host=/tmp/PfjPYfYYAe Log file: /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/log/001_replan_regress_main.log [05:27:43.119](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 21697 # using postmaster on /tmp/PfjPYfYYAe, port 30276 ok 1 - test_setup 1033 ms # parallel group (20 tests): oid name varchar char int2 pg_lsn txid text float4 int4 money boolean regproc float8 int8 bit enum uuid numeric rangetypes ok 2 + boolean 343 ms ok 3 + char 208 ms ok 4 + name 189 ms ok 5 + varchar 194 ms ok 6 + text 261 ms ok 7 + int2 220 ms ok 8 + int4 286 ms ok 9 + int8 417 ms ok 10 + oid 157 ms ok 11 + float4 259 ms ok 12 + float8 396 ms ok 13 + bit 435 ms ok 14 + numeric 1950 ms ok 15 + txid 215 ms ok 16 + uuid 537 ms ok 17 + enum 431 ms ok 18 + money 288 ms ok 19 + rangetypes 2104 ms ok 20 + pg_lsn 203 ms ok 21 + regproc 325 ms # parallel group (20 tests): md5 lseg line path circle time point macaddr timetz numerology macaddr8 date inet polygon interval timestamp timestamptz strings box multirangetypes ok 22 + strings 1339 ms ok 23 + md5 83 ms ok 24 + numerology 291 ms ok 25 + point 213 ms ok 26 + lseg 119 ms ok 27 + line 157 ms ok 28 + box 1482 ms ok 29 + path 157 ms ok 30 + polygon 618 ms ok 31 + circle 173 ms ok 32 + date 412 ms ok 33 + time 182 ms ok 34 + timetz 268 ms ok 35 + timestamp 870 ms ok 36 + timestamptz 962 ms ok 37 + interval 628 ms ok 38 + inet 401 ms ok 39 + macaddr 230 ms ok 40 + macaddr8 294 ms ok 41 + multirangetypes 1905 ms # parallel group (19 tests): comments euc_kr misc_sanity unicode pg_ndistinct pg_dependencies oid8 expressions xid encoding mvcc tstypes geometry horology type_sanity database regex opr_sanity stats_import ok 42 + geometry 606 ms ok 43 + horology 687 ms ok 44 + tstypes 490 ms ok 45 + regex 1856 ms ok 46 + type_sanity 702 ms ok 47 + opr_sanity 2291 ms ok 48 + misc_sanity 163 ms ok 49 + comments 106 ms ok 50 + expressions 395 ms ok 51 + unicode 167 ms ok 52 + xid 403 ms ok 53 + mvcc 467 ms ok 54 + database 985 ms ok 55 + stats_import 2397 ms ok 56 + pg_ndistinct 230 ms ok 57 + pg_dependencies 251 ms ok 58 + oid8 357 ms ok 59 + encoding 444 ms ok 60 + euc_kr 98 ms # parallel group (6 tests): copyencoding copyselect copydml copy insert_conflict insert ok 61 + copy 605 ms ok 62 + copyselect 151 ms ok 63 + copydml 189 ms ok 64 + copyencoding 91 ms ok 65 + insert 1475 ms ok 66 + insert_conflict 829 ms # parallel group (7 tests): create_function_c create_operator create_type create_procedure create_misc create_schema create_table ok 67 + create_function_c 37 ms ok 68 + create_misc 217 ms ok 69 + create_operator 108 ms ok 70 + create_procedure 195 ms ok 71 + create_table 1764 ms ok 72 + create_type 149 ms ok 73 + create_schema 497 ms # parallel group (5 tests): index_including_gist index_including create_view create_index_spgist create_index ok 74 + create_index 4321 ms ok 75 + create_index_spgist 2391 ms ok 76 + create_view 2284 ms ok 77 + index_including 1395 ms ok 78 + index_including_gist 1372 ms # parallel group (18 tests): create_cast errors roleattributes create_aggregate hash_func drop_if_exists select infinite_recurse typed_table create_function_sql create_am create_property_graph for_portion_of vacuum updatable_views constraints inherit triggers ok 79 + create_aggregate 367 ms ok 80 + create_function_sql 1431 ms ok 81 + create_cast 156 ms ok 82 + constraints 6233 ms ok 83 + triggers 12047 ms ok 84 + select 805 ms ok 85 + inherit 8342 ms ok 86 + typed_table 1395 ms ok 87 + vacuum 3847 ms ok 88 + drop_if_exists 634 ms ok 89 + updatable_views 6219 ms ok 90 + roleattributes 324 ms ok 91 + create_am 1493 ms ok 92 + hash_func 381 ms ok 93 + errors 203 ms ok 94 + infinite_recurse 1205 ms ok 95 + create_property_graph 2010 ms ok 96 + for_portion_of 2961 ms ok 97 - sanity_check 634 ms # parallel group (20 tests): delete select_having select_implicit select_distinct_on case select_into namespace random prepared_xacts select_distinct transactions portals union arrays update subselect hash_index aggregates join btree_index ok 98 + select_into 484 ms ok 99 + select_distinct 1071 ms ok 100 + select_distinct_on 330 ms ok 101 + select_implicit 309 ms ok 102 + select_having 284 ms ok 103 + subselect 2402 ms ok 104 + union 1419 ms ok 105 + case 349 ms ok 106 + join 3810 ms ok 107 + aggregates 3462 ms ok 108 + transactions 1113 ms ok 109 + random 648 ms ok 110 + portals 1118 ms ok 111 + arrays 1561 ms ok 112 + btree_index 9687 ms ok 113 + hash_index 2829 ms ok 114 + update 2322 ms ok 115 + delete 183 ms ok 116 + namespace 454 ms ok 117 + prepared_xacts 777 ms # parallel group (20 tests): init_privs drop_operator security_label password lock tablesample object_address collate replica_identity groupingsets matview spgist identity gist gin rowsecurity generated_stored join_hash brin privileges ok 118 + brin 6822 ms ok 119 + gin 5090 ms ok 120 + gist 5063 ms ok 121 + spgist 3909 ms ok 122 + privileges 8402 ms ok 123 + init_privs 138 ms ok 124 + security_label 306 ms ok 125 + collate 1538 ms ok 126 + matview 3414 ms ok 127 + lock 778 ms ok 128 + replica_identity 2122 ms ok 129 + rowsecurity 5109 ms ok 130 + object_address 958 ms ok 131 + tablesample 861 ms ok 132 + groupingsets 2720 ms ok 133 + drop_operator 265 ms ok 134 + password 758 ms ok 135 + identity 3942 ms ok 136 + generated_stored 5509 ms ok 137 + join_hash 6682 ms # diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out # --- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-05-06 05:24:40.599773884 +0000 # +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-05-06 05:28:38.915797808 +0000 # @@ -139,8 +139,8 @@ # JOIN dim3 ON fact.dim3_id = dim3.id # JOIN dim4 ON fact.dim4_id = dim4.id # WHERE dim1.id < 5; # - QUERY PLAN # ---------------------------------------------------------------------- # + QUERY PLAN # +--------------------------------------------------------------------------- # Aggregate # -> Nested Loop # Join Filter: (fact.dim4_id = dim4.id) # @@ -149,15 +149,15 @@ # -> Seq Scan on dim3 # -> Hash # -> Hash Join # - Hash Cond: (fact.dim1_id = dim1.id) # - -> Hash Join # - Hash Cond: (fact.dim2_id = dim2.id) # - -> Seq Scan on fact # - -> Hash # - -> Seq Scan on dim2 # + Hash Cond: (dim2.id = fact.dim2_id) # + -> Seq Scan on dim2 # -> Hash # - -> Seq Scan on dim1 # - Filter: (id < 5) # + -> Hash Join # + Hash Cond: (fact.dim1_id = dim1.id) # + -> Seq Scan on fact # + -> Hash # + -> Seq Scan on dim1 # + Filter: (id < 5) # -> Seq Scan on dim4 # (18 rows) # # @@ -459,22 +459,22 @@ # FROM t1 JOIN t2 ON t1.a = t2.a, # t5 JOIN t6 ON t5.f = t6.e # WHERE t1.a < 5 AND t5.d < 3; # - QUERY PLAN # -------------------------------------------------- # + QUERY PLAN # +------------------------------------------------------- # Aggregate # -> Hash Join # Hash Cond: (t2.a = t1.a) # - -> Nested Loop # - -> Hash Join # - Hash Cond: (t6.e = t5.f) # - -> Seq Scan on t6 # - -> Hash # - -> Seq Scan on t5 # - Filter: (d < 3) # - -> Seq Scan on t2 # + -> Seq Scan on t2 # -> Hash # - -> Seq Scan on t1 # - Filter: (a < 5) # + -> Nested Loop # + -> Hash Join # + Hash Cond: (t6.e = t5.f) # + -> Seq Scan on t6 # + -> Hash # + -> Seq Scan on t5 # + Filter: (d < 3) # + -> Seq Scan on t1 # + Filter: (a < 5) # (14 rows) # # -- not ok 138 - goo 5802 ms # parallel group (2 tests): brin_bloom brin_multi ok 139 + brin_bloom 608 ms ok 140 + brin_multi 2593 ms # parallel group (20 tests): async nls dbsize tid collate.utf8 tidscan alter_operator tsrf create_role tidrangescan sysviews misc_functions alter_generic misc incremental_sort merge create_table_like collate.icu.utf8 generated_virtual without_overlaps ok 141 + create_table_like 3124 ms ok 142 + alter_generic 1025 ms ok 143 + alter_operator 460 ms ok 144 + misc 1055 ms ok 145 + async 92 ms ok 146 + dbsize 206 ms ok 147 + merge 2509 ms ok 148 + misc_functions 934 ms ok 149 + nls 144 ms ok 150 + sysviews 789 ms ok 151 + tsrf 523 ms ok 152 + tid 330 ms ok 153 + tidscan 439 ms ok 154 + tidrangescan 750 ms ok 155 + collate.utf8 382 ms ok 156 + collate.icu.utf8 3334 ms ok 157 + incremental_sort 1266 ms ok 158 + create_role 607 ms ok 159 + without_overlaps 4389 ms ok 160 + generated_virtual 3939 ms # parallel group (8 tests): collate.windows.win1252 collate.linux.utf8 amutils psql_pipeline psql_crosstab rules psql stats_ext ok 161 + rules 2369 ms ok 162 + psql 3506 ms ok 163 + psql_crosstab 147 ms ok 164 + psql_pipeline 146 ms ok 165 + amutils 90 ms ok 166 + stats_ext 7352 ms ok 167 + collate.linux.utf8 83 ms ok 168 + collate.windows.win1252 78 ms ok 169 - select_parallel 3070 ms ok 170 - write_parallel 352 ms ok 171 - vacuum_parallel 899 ms ok 172 - maintain_every 112 ms # parallel group (2 tests): subscription publication ok 173 + publication 4043 ms ok 174 + subscription 362 ms # parallel group (18 tests): portals_p2 advisory_lock combocid xmlmap functional_deps tsdicts dependency equivclass guc select_views stats_rewrite indirect_toast bitmapops graph_table window tsearch foreign_data foreign_key ok 175 + select_views 836 ms ok 176 + portals_p2 242 ms ok 177 + foreign_key 9861 ms ok 178 + dependency 597 ms ok 179 + guc 626 ms ok 180 + bitmapops 1648 ms ok 181 + combocid 322 ms ok 182 + tsearch 1982 ms ok 183 + tsdicts 519 ms ok 184 + foreign_data 4625 ms ok 185 + window 1867 ms ok 186 + xmlmap 366 ms ok 187 + functional_deps 433 ms ok 188 + advisory_lock 268 ms ok 189 + indirect_toast 1254 ms ok 190 + equivclass 601 ms ok 191 + stats_rewrite 906 ms ok 192 + graph_table 1846 ms # parallel group (9 tests): json_encoding jsonpath_encoding jsonpath sqljson_jsontable sqljson sqljson_queryfuncs json jsonb_jsonpath jsonb ok 193 + json 1153 ms ok 194 + jsonb 2116 ms ok 195 + json_encoding 109 ms ok 196 + jsonpath 308 ms ok 197 + jsonpath_encoding 109 ms ok 198 + jsonb_jsonpath 1336 ms ok 199 + sqljson 971 ms ok 200 + sqljson_queryfuncs 1097 ms ok 201 + sqljson_jsontable 527 ms # parallel group (18 tests): prepare conversion plancache returning limit largeobject sequence rowtypes copy2 truncate temp polymorphism with rangefuncs domain xml plpgsql alter_table ok 202 + plancache 612 ms ok 203 + limit 912 ms ok 204 + plpgsql 6976 ms ok 205 + copy2 1609 ms ok 206 + temp 1964 ms ok 207 + domain 2924 ms ok 208 + rangefuncs 2530 ms ok 209 + prepare 243 ms ok 210 + conversion 549 ms ok 211 + truncate 1787 ms ok 212 + alter_table 9548 ms ok 213 + sequence 1463 ms ok 214 + polymorphism 2081 ms ok 215 + rowtypes 1448 ms ok 216 + returning 864 ms ok 217 + largeobject 1067 ms ok 218 + with 2285 ms ok 219 + xml 4508 ms # parallel group (18 tests): hash_part planner_est numa reloptions explain partition_info predicate graph_table_rls memoize eager_aggregate partition_merge partition_split partition_aggregate stats tuplesort partition_prune partition_join indexing ok 220 + partition_merge 2800 ms ok 221 + partition_split 3299 ms ok 222 + partition_join 4833 ms ok 223 + partition_prune 4692 ms ok 224 + reloptions 437 ms ok 225 + hash_part 242 ms ok 226 + indexing 5485 ms ok 227 + partition_aggregate 3529 ms ok 228 + partition_info 602 ms ok 229 + tuplesort 4329 ms ok 230 + explain 534 ms ok 231 + memoize 1427 ms ok 232 + stats 3844 ms ok 233 + predicate 691 ms ok 234 + numa 303 ms ok 235 + eager_aggregate 2091 ms ok 236 + graph_table_rls 706 ms ok 237 + planner_est 245 ms # parallel group (4 tests): compression_pglz compression_lz4 compression cluster ok 238 + compression 559 ms ok 239 + compression_lz4 414 ms ok 240 + compression_pglz 42 ms ok 241 + cluster 1126 ms # parallel group (2 tests): oidjoins event_trigger ok 242 + oidjoins 586 ms ok 243 + event_trigger 743 ms ok 244 - event_trigger_login 100 ms ok 245 - fast_default 478 ms ok 246 - tablespace 1692 ms 1..246 # 1 of 246 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/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out --- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-05-06 05:24:40.599773884 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-05-06 05:28:38.915797808 +0000 @@ -139,8 +139,8 @@ JOIN dim3 ON fact.dim3_id = dim3.id JOIN dim4 ON fact.dim4_id = dim4.id WHERE dim1.id < 5; - QUERY PLAN ---------------------------------------------------------------------- + QUERY PLAN +--------------------------------------------------------------------------- Aggregate -> Nested Loop Join Filter: (fact.dim4_id = dim4.id) @@ -149,15 +149,15 @@ -> Seq Scan on dim3 -> Hash -> Hash Join - Hash Cond: (fact.dim1_id = dim1.id) - -> Hash Join - Hash Cond: (fact.dim2_id = dim2.id) - -> Seq Scan on fact - -> Hash - -> Seq Scan on dim2 + Hash Cond: (dim2.id = fact.dim2_id) + -> Seq Scan on dim2 -> Hash - -> Seq Scan on dim1 - Filter: (id < 5) + -> Hash Join + Hash Cond: (fact.dim1_id = dim1.id) + -> Seq Scan on fact + -> Hash + -> Seq Scan on dim1 + Filter: (id < 5) -> Seq Scan on dim4 (18 rows) @@ -459,22 +459,22 @@ FROM t1 JOIN t2 ON t1.a = t2.a, t5 JOIN t6 ON t5.f = t6.e WHERE t1.a < 5 AND t5.d < 3; - QUERY PLAN -------------------------------------------------- + QUERY PLAN +------------------------------------------------------- Aggregate -> Hash Join Hash Cond: (t2.a = t1.a) - -> Nested Loop - -> Hash Join - Hash Cond: (t6.e = t5.f) - -> Seq Scan on t6 - -> Hash - -> Seq Scan on t5 - Filter: (d < 3) - -> Seq Scan on t2 + -> Seq Scan on t2 -> Hash - -> Seq Scan on t1 - Filter: (a < 5) + -> Nested Loop + -> Hash Join + Hash Cond: (t6.e = t5.f) + -> Seq Scan on t6 + -> Hash + -> Seq Scan on t5 + Filter: (d < 3) + -> Seq Scan on t1 + Filter: (a < 5) (14 rows) -- === EOF === [05:29:33.568](110.449s) not ok 1 - regression tests pass [05:29:33.568](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. [05:29:33.569](0.000s) # got: '256' # expected: '0' [05:29:33.569](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" [05:29:33.692](0.123s) # Looks like you failed 1 test of 1.