# Checking port 22599 # Found port 22599 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=22599 host=/tmp/fsZYAKpjh1 Log file: /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/log/001_replan_regress_main.log [05:25:47.781](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 6368 # using postmaster on /tmp/fsZYAKpjh1, port 22599 ok 1 - test_setup 1020 ms # parallel group (20 tests): varchar oid pg_lsn char name txid text int2 uuid int4 float8 enum float4 boolean money int8 bit regproc rangetypes numeric ok 2 + boolean 1721 ms ok 3 + char 278 ms ok 4 + name 414 ms ok 5 + varchar 146 ms ok 6 + text 753 ms ok 7 + int2 894 ms ok 8 + int4 1052 ms ok 9 + int8 2586 ms ok 10 + oid 251 ms ok 11 + float4 1624 ms ok 12 + float8 1118 ms ok 13 + bit 3130 ms ok 14 + numeric 8487 ms ok 15 + txid 500 ms ok 16 + uuid 899 ms ok 17 + enum 1158 ms ok 18 + money 2365 ms ok 19 + rangetypes 6685 ms ok 20 + pg_lsn 274 ms ok 21 + regproc 3905 ms # parallel group (20 tests): lseg path macaddr circle line md5 point polygon timetz box macaddr8 time numerology timestamp interval inet date timestamptz strings multirangetypes ok 22 + strings 10641 ms ok 23 + md5 640 ms ok 24 + numerology 1719 ms ok 25 + point 692 ms ok 26 + lseg 283 ms ok 27 + line 630 ms ok 28 + box 1189 ms ok 29 + path 446 ms ok 30 + polygon 793 ms ok 31 + circle 529 ms ok 32 + date 7607 ms ok 33 + time 1520 ms ok 34 + timetz 1118 ms ok 35 + timestamp 2509 ms ok 36 + timestamptz 9312 ms ok 37 + interval 2887 ms ok 38 + inet 3364 ms ok 39 + macaddr 508 ms ok 40 + macaddr8 1315 ms ok 41 + multirangetypes 14410 ms # parallel group (19 tests): euc_kr misc_sanity unicode mvcc comments pg_dependencies pg_ndistinct oid8 encoding expressions regex xid database stats_import type_sanity opr_sanity geometry tstypes horology ok 42 + geometry 5748 ms ok 43 + horology 7361 ms ok 44 + tstypes 5997 ms ok 45 + regex 2182 ms ok 46 + type_sanity 3875 ms ok 47 + opr_sanity 3965 ms ok 48 + misc_sanity 138 ms ok 49 + comments 200 ms ok 50 + expressions 901 ms ok 51 + unicode 181 ms ok 52 + xid 2207 ms ok 53 + mvcc 199 ms ok 54 + database 2312 ms ok 55 + stats_import 3760 ms ok 56 + pg_ndistinct 645 ms ok 57 + pg_dependencies 303 ms ok 58 + oid8 705 ms ok 59 + encoding 728 ms ok 60 + euc_kr 82 ms # parallel group (6 tests): copydml copyencoding copyselect copy insert_conflict insert ok 61 + copy 667 ms ok 62 + copyselect 238 ms ok 63 + copydml 143 ms ok 64 + copyencoding 185 ms ok 65 + insert 3710 ms ok 66 + insert_conflict 890 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 65 ms ok 68 + create_misc 1188 ms ok 69 + create_operator 368 ms ok 70 + create_procedure 1193 ms ok 71 + create_table 5537 ms ok 72 + create_type 880 ms ok 73 + create_schema 2146 ms # parallel group (5 tests): index_including_gist index_including create_index_spgist create_view create_index ok 74 + create_index 6783 ms ok 75 + create_index_spgist 4276 ms ok 76 + create_view 4503 ms ok 77 + index_including 2445 ms ok 78 + index_including_gist 1421 ms # parallel group (18 tests): create_cast infinite_recurse create_aggregate errors select typed_table create_am create_property_graph drop_if_exists hash_func for_portion_of create_function_sql roleattributes vacuum triggers updatable_views constraints inherit ok 79 + create_aggregate 1167 ms ok 80 + create_function_sql 4576 ms ok 81 + create_cast 138 ms ok 82 + constraints 19444 ms ok 83 + triggers 11497 ms ok 84 + select 2236 ms ok 85 + inherit 22476 ms ok 86 + typed_table 2411 ms ok 87 + vacuum 5364 ms ok 88 + drop_if_exists 3353 ms ok 89 + updatable_views 12694 ms ok 90 + roleattributes 4966 ms ok 91 + create_am 3202 ms ok 92 + hash_func 3461 ms ok 93 + errors 2126 ms ok 94 + infinite_recurse 952 ms ok 95 + create_property_graph 3261 ms ok 96 + for_portion_of 4260 ms ok 97 - sanity_check 539 ms # parallel group (20 tests): delete select_having select_implicit namespace select_distinct_on case random select_into select_distinct hash_index prepared_xacts portals transactions btree_index update union subselect join aggregates arrays ok 98 + select_into 1573 ms ok 99 + select_distinct 1726 ms ok 100 + select_distinct_on 947 ms ok 101 + select_implicit 763 ms ok 102 + select_having 726 ms ok 103 + subselect 8148 ms ok 104 + union 7591 ms ok 105 + case 990 ms ok 106 + join 12010 ms ok 107 + aggregates 16378 ms ok 108 + transactions 4185 ms ok 109 + random 1289 ms ok 110 + portals 4053 ms ok 111 + arrays 20145 ms ok 112 + btree_index 4795 ms ok 113 + hash_index 1992 ms ok 114 + update 5962 ms ok 115 + delete 181 ms ok 116 + namespace 934 ms ok 117 + prepared_xacts 2187 ms # parallel group (20 tests): init_privs drop_operator security_label password lock spgist gin object_address gist collate tablesample replica_identity groupingsets join_hash brin matview identity rowsecurity generated_stored privileges ok 118 + brin 6768 ms ok 119 + gin 1955 ms ok 120 + gist 2378 ms ok 121 + spgist 1865 ms ok 122 + privileges 14779 ms ok 123 + init_privs 194 ms ok 124 + security_label 405 ms ok 125 + collate 3158 ms ok 126 + matview 7724 ms ok 127 + lock 1166 ms ok 128 + replica_identity 5384 ms ok 129 + rowsecurity 9178 ms ok 130 + object_address 2104 ms ok 131 + tablesample 3257 ms ok 132 + groupingsets 5638 ms ok 133 + drop_operator 402 ms ok 134 + password 972 ms ok 135 + identity 8642 ms ok 136 + generated_stored 13601 ms ok 137 + join_hash 6428 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:51.848051000 +0000 # +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-05-06 05:27:41.037604000 +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 5005 ms # parallel group (2 tests): brin_bloom brin_multi ok 139 + brin_bloom 1176 ms ok 140 + brin_multi 6672 ms # parallel group (20 tests): nls async dbsize sysviews tidscan alter_operator misc create_role tidrangescan tid incremental_sort collate.utf8 alter_generic tsrf misc_functions merge without_overlaps create_table_like collate.icu.utf8 generated_virtual ok 141 + create_table_like 16081 ms ok 142 + alter_generic 2544 ms ok 143 + alter_operator 767 ms ok 144 + misc 854 ms ok 145 + async 132 ms ok 146 + dbsize 274 ms ok 147 + merge 6269 ms ok 148 + misc_functions 4736 ms ok 149 + nls 118 ms ok 150 + sysviews 620 ms ok 151 + tsrf 2566 ms ok 152 + tid 914 ms ok 153 + tidscan 657 ms ok 154 + tidrangescan 903 ms ok 155 + collate.utf8 1874 ms ok 156 + collate.icu.utf8 16230 ms ok 157 + incremental_sort 1689 ms ok 158 + create_role 880 ms ok 159 + without_overlaps 12717 ms ok 160 + generated_virtual 17604 ms # parallel group (8 tests): collate.windows.win1252 collate.linux.utf8 amutils psql_crosstab psql_pipeline rules psql stats_ext ok 161 + rules 9797 ms ok 162 + psql 20639 ms ok 163 + psql_crosstab 1992 ms ok 164 + psql_pipeline 4925 ms ok 165 + amutils 476 ms ok 166 + stats_ext 29164 ms ok 167 + collate.linux.utf8 56 ms ok 168 + collate.windows.win1252 29 ms ok 169 - select_parallel 6388 ms ok 170 - write_parallel 495 ms ok 171 - vacuum_parallel 274 ms ok 172 - maintain_every 95 ms # parallel group (2 tests): subscription publication ok 173 + publication 10742 ms ok 174 + subscription 804 ms # parallel group (18 tests): portals_p2 combocid functional_deps tsdicts bitmapops select_views equivclass indirect_toast dependency stats_rewrite advisory_lock xmlmap guc window graph_table foreign_key tsearch foreign_data ok 175 + select_views 1075 ms ok 176 + portals_p2 408 ms ok 177 + foreign_key 17155 ms ok 178 + dependency 1441 ms ok 179 + guc 2955 ms ok 180 + bitmapops 1024 ms ok 181 + combocid 564 ms ok 182 + tsearch 18498 ms ok 183 + tsdicts 917 ms ok 184 + foreign_data 20055 ms ok 185 + window 3118 ms ok 186 + xmlmap 1994 ms ok 187 + functional_deps 874 ms ok 188 + advisory_lock 1618 ms ok 189 + indirect_toast 1374 ms ok 190 + equivclass 1086 ms ok 191 + stats_rewrite 1490 ms ok 192 + graph_table 4636 ms # parallel group (9 tests): sqljson_jsontable jsonpath_encoding json_encoding sqljson_queryfuncs sqljson jsonpath json jsonb_jsonpath jsonb ok 193 + json 15472 ms ok 194 + jsonb 37805 ms ok 195 + json_encoding 1926 ms ok 196 + jsonpath 11753 ms ok 197 + jsonpath_encoding 1234 ms ok 198 + jsonb_jsonpath 37577 ms ok 199 + sqljson 5654 ms ok 200 + sqljson_queryfuncs 3232 ms ok 201 + sqljson_jsontable 1184 ms # parallel group (18 tests): conversion prepare limit returning plancache temp truncate with sequence rangefuncs largeobject polymorphism copy2 domain rowtypes xml plpgsql alter_table ok 202 + plancache 1992 ms ok 203 + limit 1590 ms ok 204 + plpgsql 9902 ms ok 205 + copy2 4129 ms ok 206 + temp 2684 ms ok 207 + domain 5211 ms ok 208 + rangefuncs 3698 ms ok 209 + prepare 998 ms ok 210 + conversion 677 ms ok 211 + truncate 3077 ms ok 212 + alter_table 30977 ms ok 213 + sequence 3357 ms ok 214 + polymorphism 4104 ms ok 215 + rowtypes 6532 ms ok 216 + returning 1699 ms ok 217 + largeobject 3831 ms ok 218 + with 3086 ms ok 219 + xml 8376 ms # parallel group (18 tests): numa planner_est hash_part reloptions graph_table_rls explain predicate eager_aggregate memoize partition_aggregate partition_info tuplesort partition_join partition_merge partition_split stats partition_prune indexing ok 220 + partition_merge 6979 ms ok 221 + partition_split 8024 ms ok 222 + partition_join 6067 ms ok 223 + partition_prune 19436 ms ok 224 + reloptions 1121 ms ok 225 + hash_part 766 ms ok 226 + indexing 20204 ms ok 227 + partition_aggregate 2783 ms ok 228 + partition_info 2993 ms ok 229 + tuplesort 4572 ms ok 230 + explain 1490 ms ok 231 + memoize 1972 ms ok 232 + stats 8179 ms ok 233 + predicate 1558 ms ok 234 + numa 168 ms ok 235 + eager_aggregate 1832 ms ok 236 + graph_table_rls 1434 ms ok 237 + planner_est 567 ms # parallel group (4 tests): compression_pglz compression_lz4 compression cluster ok 238 + compression 2519 ms ok 239 + compression_lz4 2042 ms ok 240 + compression_pglz 25 ms ok 241 + cluster 2787 ms # parallel group (2 tests): oidjoins event_trigger ok 242 + oidjoins 672 ms ok 243 + event_trigger 1998 ms ok 244 - event_trigger_login 298 ms ok 245 - fast_default 2795 ms ok 246 - tablespace 8214 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:51.848051000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-05-06 05:27:41.037604000 +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:30:57.843](310.062s) not ok 1 - regression tests pass [05:30:57.844](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:30:57.844](0.000s) # got: '256' # expected: '0' [05:30:57.844](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:30:57.950](0.106s) # Looks like you failed 1 test of 1.