[00:10:16.366] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [00:10:16.700] dumping /tmp/cores/postgres.10492.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:10:16.833] [New LWP 101780] [00:10:16.912] Core was generated by `postgres: postgres regression [local] SELECT'. [00:10:16.912] Program terminated with signal SIGSEGV, Segmentation fault. [00:10:16.912] Address not mapped to object. [00:10:16.912] #0 equal (a=0x35c8b778, b=b@entry=0x835c88068) at ../src/backend/nodes/equalfuncs.c:239 [00:10:16.912] 239 if (nodeTag(a) != nodeTag(b)) [00:10:16.942] [00:10:16.942] Thread 1 (LWP 101780): [00:10:16.942] #0 equal (a=0x35c8b778, b=b@entry=0x835c88068) at ../src/backend/nodes/equalfuncs.c:239 [00:10:16.942] retval = [00:10:16.942] #1 0x000000000076ef32 in list_member (list=0x835c8b7e8, datum=datum@entry=0x835c88068) at ../src/backend/nodes/list.c:670 [00:10:16.942] cell__state = {l = 0x835c8b7e8, i = 0} [00:10:16.942] cell = 0x0 [00:10:16.942] cell__state = [00:10:16.942] #2 0x00000000007e2915 in add_new_column_to_pathtarget (target=0x835c8b708, expr=) at ../src/backend/optimizer/util/tlist.c:743 [00:10:16.942] No locals. [00:10:16.942] #3 add_new_columns_to_pathtarget (target=target@entry=0x835c8b708, exprs=0x835c8b918) at ../src/backend/optimizer/util/tlist.c:760 [00:10:16.942] expr = [00:10:16.942] lc__state = {l = 0x835c8b918, i = 0} [00:10:16.942] lc = 0xfffffe3b [00:10:16.942] #4 0x00000000007b2309 in make_group_input_target (root=0x832a7aba8, final_target=0x835c8b5a8) at ../src/backend/optimizer/plan/planner.c:5472 [00:10:16.942] parse = 0x835c70e50 [00:10:16.942] input_target = 0x835c8b708 [00:10:16.942] non_group_cols = 0x835c8b8c8 [00:10:16.942] i = [00:10:16.942] lc = [00:10:16.942] non_group_vars = 0x835c8b918 [00:10:16.942] #5 grouping_planner (root=root@entry=0x832a7aba8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:10:16.942] qp_extra = {activeWindows = 0x0, gset_data = 0x835c894b8} [00:10:16.942] activeWindows = 0x0 [00:10:16.942] sort_input_target_parallel_safe = false [00:10:16.942] grouping_target = 0x835c8b5a8 [00:10:16.942] scanjoin_target = [00:10:16.942] sort_input_targets = [00:10:16.942] wflists = 0x0 [00:10:16.942] gset_data = 0x835c894b8 [00:10:16.942] have_grouping = false [00:10:16.942] sort_input_targets_contain_srfs = [00:10:16.942] sort_input_target = 0x835c8b5a8 [00:10:16.942] grouping_target_parallel_safe = false [00:10:16.942] scanjoin_target_parallel_safe = [00:10:16.942] grouping_targets = [00:10:16.942] scanjoin_targets = [00:10:16.942] grouping_targets_contain_srfs = [00:10:16.942] scanjoin_targets_contain_srfs = [00:10:16.942] scanjoin_target_same_exprs = [00:10:16.942] extra = {limit_needed = 152, limit_tuples = 1.7421779573995662e-313, count_est = 72, offset_est = 34924844688} [00:10:16.942] parse = 0x835c70e50 [00:10:16.942] offset_est = [00:10:16.942] count_est = [00:10:16.942] limit_tuples = -1 [00:10:16.942] have_postponed_srfs = false [00:10:16.942] current_rel = 0x832a7afb8 [00:10:16.942] final_target = 0x835c8b5a8 [00:10:16.942] final_targets_contain_srfs = [00:10:16.942] final_targets = [00:10:16.942] final_rel = [00:10:16.942] lc = [00:10:16.942] final_target_parallel_safe = [00:10:16.942] #6 0x00000000007b0214 in subquery_planner (glob=glob@entry=0x835c85d60, parse=parse@entry=0x835c70e50, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:10:16.942] root = 0x832a7aba8 [00:10:16.942] hasOuterJoins = false [00:10:16.942] hasResultRTEs = false [00:10:16.942] l = [00:10:16.942] newWithCheckOptions = [00:10:16.942] newHaving = 0x0 [00:10:16.942] final_rel = [00:10:16.942] #7 0x00000000007aed38 in standard_planner (parse=0x835c70e50, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [00:10:16.942] glob = 0x835c85d60 [00:10:16.942] tuple_fraction = 0 [00:10:16.942] root = [00:10:16.942] final_rel = [00:10:16.942] best_path = [00:10:16.942] top_plan = [00:10:16.942] lp = [00:10:16.942] lr = [00:10:16.942] result = [00:10:16.942] #8 0x00000000007aec0c in planner (parse=0x35c8b778, parse@entry=0x835c70e50, query_string=0x835c88068 "\006", query_string@entry=0x83299c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=565106144, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [00:10:16.942] result = [00:10:16.942] #9 0x00000000008d2255 in pg_plan_query (querytree=querytree@entry=0x835c70e50, query_string=query_string@entry=0x83299c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [00:10:16.942] plan = [00:10:16.942] #10 0x00000000008d2332 in pg_plan_queries (querytrees=0x835c85d10, query_string=query_string@entry=0x83299c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=565106144, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [00:10:16.942] query = 0x835c70e50 [00:10:16.942] stmt = [00:10:16.942] query_list__state = {l = 0x835c85d10, i = 0} [00:10:16.942] stmt_list = 0x0 [00:10:16.942] query_list = [00:10:16.942] #11 0x00000000008d64cc in exec_simple_query (query_string=query_string@entry=0x83299c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [00:10:16.942] cmdtaglen = [00:10:16.942] snapshot_set = [00:10:16.942] per_parsetree_context = 0x0 [00:10:16.942] plantree_list = [00:10:16.942] qc = {commandTag = 336, nprocessed = 6} [00:10:16.942] parsetree = 0x832af6600 [00:10:16.942] commandTag = [00:10:16.942] cmdtagname = [00:10:16.942] querytree_list = 0x0 [00:10:16.942] portal = [00:10:16.942] format = [00:10:16.942] receiver = [00:10:16.942] parsetree_item__state = {l = 0x832a776f8, i = 0} [00:10:16.942] msec_str = "P\001\000\000\000\000\000\000\006\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:10:16.942] dest = DestRemote [00:10:16.942] was_logged = [00:10:16.942] oldcontext = 0x8329a8000 [00:10:16.942] parsetree_list = 0x832a776f8 [00:10:16.942] use_implicit_block = false [00:10:16.942] parsetree_item = 0x832a77710 [00:10:16.942] save_log_statement_stats = [00:10:16.942] #12 0x00000000008d43a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:10:16.942] query_string = 0x83299c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [00:10:16.942] input_message = {data = 0x83299c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [00:10:16.942] firstchar = [00:10:16.942] local_sigjmp_buf = {{_sjb = {9255024, 34924845664, 34924845624, 34924846224, 11914584, 11861056, 8192, 8388608, 72057628962718591, 0, 0, 34359738369}}} [00:10:16.942] send_ready_for_query = false [00:10:16.942] idle_in_transaction_timeout_enabled = false [00:10:16.942] idle_session_timeout_enabled = false [00:10:16.942] #13 0x000000000083303a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:10:16.942] No locals. [00:10:16.942] #14 0x00000000008312c0 in BackendStartup (client_sock=0x821aee6b8) at ../src/backend/postmaster/postmaster.c:4117 [00:10:16.942] bn = 0x8329a8588 [00:10:16.942] cac = CAC_OK [00:10:16.942] pid = [00:10:16.942] __error = [00:10:16.942] __error = [00:10:16.942] __error = [00:10:16.942] save_errno = [00:10:16.942] __error = [00:10:16.942] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:10:16.942] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X\f\244+\000\000\000\000\001\000\000\000\000\000\000\000\320\356\264", '\000' , "\300Ƶ\000\000\000\000\000\v\000\000\000\000\000\000\0000\347\256!\b\000\000\000\330\205;+\b\000\000\000\320\356\264\000\000\000\000\000\016\006<+\b", '\000' , "p\347\256!\b\000\000\000\264Â\000\000\000\000"}, salen = 16}} [00:10:16.942] i = 0 [00:10:16.942] now = [00:10:16.942] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 730352740, events = 8, fd = 565107968, user_data = 0x821aede90}, {pos = 580727816, events = 8, fd = 32, user_data = 0x821aede80}, {pos = -2112431468, events = 3111, fd = 580698120, user_data = 0x8229cc408}, {pos = 580700168, events = 8, fd = 580701192, user_data = 0x8229d0008}, {pos = 580715528, events = 8, fd = 580716552, user_data = 0x8229d0c08}, {pos = 580718600, events = 8, fd = 580719624, user_data = 0x8229d1808}, {pos = 580721672, events = 8, fd = 580722696, user_data = 0x8229d2408}, {pos = 580724744, events = 8, fd = 580725768, user_data = 0x8229d3008}, {pos = 580727816, events = 8, fd = -1, user_data = 0x82ba5c2e0}, {pos = 565108208, events = 8, fd = 731943337, user_data = 0x0}, {pos = 4096, events = 0, fd = -1443945139, user_data = 0x82ba5c7e8}, {pos = 838900704, events = 8, fd = 160, user_data = 0x0}, {pos = 822538384, events = 8, fd = 565108416, user_data = 0x82b9e792c}, {pos = 4096, events = 0, fd = 730368356, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 580753976, user_data = 0x800000001}, {pos = 580727816, events = 8, fd = 730282200, user_data = 0x821aedf48}, {pos = 565107968, events = 8, fd = 32, user_data = 0x82b884c64}, {pos = 580727816, events = 8, fd = 580753976, user_data = 0x0}, {pos = 2625, events = 0, fd = 565108528, user_data = 0xc278216d645}, {pos = 730368356, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 580753976, events = 8, fd = 1, user_data = 0x8229d3408}, {pos = 848871424, events = 8, fd = 1, user_data = 0x83298c194}, {pos = 0, events = 0, fd = 565108480, user_data = 0x82b3bfc0c}, {pos = 1, events = 0, fd = 848871424, user_data = 0x821aedf30}, {pos = 725348020, events = 8, fd = 732094816, user_data = 0x82ba2e160 }, {pos = 730464448, events = 8, fd = 580727816, user_data = 0x821aee010}, {pos = -2112433108, events = 3111, fd = 822538384, user_data = 0x800000001}, {pos = -2112433490, events = 3111, fd = 12240, user_data = 0x821aedf38}, {pos = 565108752, events = 8, fd = 849549288, user_data = 0x821aee580}, {pos = -2112352624, events = 3111, fd = 580727816, user_data = 0x821ae037f}, {pos = 731751836, events = 8, fd = 580698120, user_data = 0x0}, {pos = 580727816, events = 8, fd = 12240, user_data = 0x82b864000}, {pos = 1964368, events = 0, fd = 732094816, user_data = 0x82b884c64}, {pos = 15616, events = 0, fd = 565109936, user_data = 0x821aee080}, {pos = 731025806, events = 8, fd = 732133432, user_data = 0x821aee044}, {pos = 849286618, events = 8, fd = 565109936, user_data = 0x821aee080}, {pos = 731117061, events = 8, fd = 565108802, user_data = 0x821aee4b0}, {pos = 565109936, events = 8, fd = 0, user_data = 0xbdffb2c5a9ef254d}, {pos = 565109936, events = 8, fd = 849286616, user_data = 0x821aee580}, {pos = 732133432, events = 8, fd = 0, user_data = 0x821aee4f0}, {pos = 731117325, events = 8, fd = 0, user_data = 0x0}, {pos = 565110304, events = 8, fd = 849286616, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -2112404471, events = 3111, fd = 565109208, user_data = 0x82b884c64}, {pos = 2503, events = 0, fd = -2112404471, user_data = 0x821aee1f8}, {pos = 730352740, events = 8, fd = 2758, user_data = 0x82b87e120}, {pos = 565109112, events = 8, fd = 580727816, user_data = 0x821aee1f8}, {pos = 730325280, events = 8, fd = 565109216, user_data = 0xc278216f465}, {pos = 0, events = 0, fd = 0, user_data = 0x82ba500f0}, {pos = 730285392, events = 8, fd = 0, user_data = 0x0}, {pos = 732162480, events = 8, fd = 16, user_data = 0x0}, {pos = 565109352, events = 8, fd = 580747400, user_data = 0xc2782174409}, {pos = 565109416, events = 8, fd = 730352740, user_data = 0xb6c}, {pos = 730325944, events = 8, fd = 565109288, user_data = 0x8229d3408}, {pos = 565109416, events = 8, fd = 730325944, user_data = 0x821aee290}, {pos = -2112424859, events = 3111, fd = 580751416, user_data = 0x800000001}, {pos = 580727816, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 565109800, user_data = 0x272620}, {pos = 565109904, events = 8, fd = 565109904, user_data = 0x821aee448}, {pos = 30, events = 0, fd = 730289376, user_data = 0x821aee338}, {pos = 580747848, events = 8, fd = 565110008, user_data = 0x821aee320}, {pos = -2112406109, events = 3111, fd = 580751416, user_data = 0x29123d}} [00:10:16.942] last_touch_time = 1710547648 [00:10:16.942] last_lockfile_recheck_time = 1710547648 [00:10:16.942] nevents = 1 [00:10:16.942] #16 0x000000000082e5b6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821aeecb8) at ../src/backend/postmaster/postmaster.c:1478 [00:10:16.942] userDoption = [00:10:16.942] listen_addr_saved = false [00:10:16.942] output_config_variable = [00:10:16.942] opt = [00:10:16.942] status = [00:10:16.942] #17 0x000000000076b7f5 in main (argc=8, argv=0x821aeecb8) at ../src/backend/main/main.c:197 [00:10:16.942] do_check_root = [00:10:16.951] [00:10:16.951] [00:10:16.951] [00:10:17.006] dumping /tmp/cores/postgres.11651.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:10:17.131] [New LWP 101846] [00:10:17.198] Core was generated by `postgres: old_node: postgres regression [local] SELECT'. [00:10:17.198] Program terminated with signal SIGSEGV, Segmentation fault. [00:10:17.198] Address not mapped to object. [00:10:17.198] #0 equal (a=0x44eae6f8, b=b@entry=0x844eaafe8) at ../src/backend/nodes/equalfuncs.c:239 [00:10:17.198] 239 if (nodeTag(a) != nodeTag(b)) [00:10:17.220] [00:10:17.220] Thread 1 (LWP 101846): [00:10:17.220] #0 equal (a=0x44eae6f8, b=b@entry=0x844eaafe8) at ../src/backend/nodes/equalfuncs.c:239 [00:10:17.220] retval = [00:10:17.220] #1 0x000000000076ef32 in list_member (list=0x844eae768, datum=datum@entry=0x844eaafe8) at ../src/backend/nodes/list.c:670 [00:10:17.220] cell__state = {l = 0x844eae768, i = 0} [00:10:17.220] cell = 0x0 [00:10:17.220] cell__state = [00:10:17.220] #2 0x00000000007e2915 in add_new_column_to_pathtarget (target=0x844eae688, expr=) at ../src/backend/optimizer/util/tlist.c:743 [00:10:17.220] No locals. [00:10:17.220] #3 add_new_columns_to_pathtarget (target=target@entry=0x844eae688, exprs=0x844eae898) at ../src/backend/optimizer/util/tlist.c:760 [00:10:17.220] expr = [00:10:17.220] lc__state = {l = 0x844eae898, i = 0} [00:10:17.220] lc = 0xfffffe3b [00:10:17.220] #4 0x00000000007b2309 in make_group_input_target (root=0x8384ba828, final_target=0x844eae528) at ../src/backend/optimizer/plan/planner.c:5472 [00:10:17.220] parse = 0x844e93010 [00:10:17.220] input_target = 0x844eae688 [00:10:17.220] non_group_cols = 0x844eae848 [00:10:17.220] i = [00:10:17.220] lc = [00:10:17.220] non_group_vars = 0x844eae898 [00:10:17.220] #5 grouping_planner (root=root@entry=0x8384ba828, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:10:17.220] qp_extra = {activeWindows = 0x0, gset_data = 0x844eac438} [00:10:17.220] activeWindows = 0x0 [00:10:17.220] sort_input_target_parallel_safe = false [00:10:17.220] grouping_target = 0x844eae528 [00:10:17.220] scanjoin_target = [00:10:17.220] sort_input_targets = [00:10:17.220] wflists = 0x0 [00:10:17.220] gset_data = 0x844eac438 [00:10:17.220] have_grouping = false [00:10:17.220] sort_input_targets_contain_srfs = [00:10:17.220] sort_input_target = 0x844eae528 [00:10:17.220] grouping_target_parallel_safe = false [00:10:17.220] scanjoin_target_parallel_safe = [00:10:17.220] grouping_targets = [00:10:17.220] scanjoin_targets = [00:10:17.220] grouping_targets_contain_srfs = [00:10:17.220] scanjoin_targets_contain_srfs = [00:10:17.220] scanjoin_target_same_exprs = [00:10:17.220] extra = {limit_needed = 24, limit_tuples = 1.7547222161640426e-313, count_est = 72, offset_est = 34914074880} [00:10:17.220] parse = 0x844e93010 [00:10:17.220] offset_est = [00:10:17.220] count_est = [00:10:17.220] limit_tuples = -1 [00:10:17.220] have_postponed_srfs = false [00:10:17.220] current_rel = 0x8384bac38 [00:10:17.220] final_target = 0x844eae528 [00:10:17.220] final_targets_contain_srfs = [00:10:17.220] final_targets = [00:10:17.220] final_rel = [00:10:17.220] lc = [00:10:17.220] final_target_parallel_safe = [00:10:17.220] #6 0x00000000007b0214 in subquery_planner (glob=glob@entry=0x844ea8ce0, parse=parse@entry=0x844e93010, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:10:17.220] root = 0x8384ba828 [00:10:17.220] hasOuterJoins = false [00:10:17.220] hasResultRTEs = false [00:10:17.220] l = [00:10:17.220] newWithCheckOptions = [00:10:17.220] newHaving = 0x0 [00:10:17.220] final_rel = [00:10:17.220] #7 0x00000000007aed38 in standard_planner (parse=0x844e93010, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [00:10:17.220] glob = 0x844ea8ce0 [00:10:17.220] tuple_fraction = 0 [00:10:17.220] root = [00:10:17.220] final_rel = [00:10:17.220] best_path = [00:10:17.220] top_plan = [00:10:17.220] lp = [00:10:17.220] lr = [00:10:17.220] result = [00:10:17.220] #8 0x00000000007aec0c in planner (parse=0x44eae6f8, parse@entry=0x844e93010, query_string=0x844eaafe8 "\006", query_string@entry=0x8383d9100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=554336336, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [00:10:17.220] result = [00:10:17.220] #9 0x00000000008d2255 in pg_plan_query (querytree=querytree@entry=0x844e93010, query_string=query_string@entry=0x8383d9100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [00:10:17.220] plan = [00:10:17.220] #10 0x00000000008d2332 in pg_plan_queries (querytrees=0x844ea8c90, query_string=query_string@entry=0x8383d9100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=554336336, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [00:10:17.220] query = 0x844e93010 [00:10:17.220] stmt = [00:10:17.220] query_list__state = {l = 0x844ea8c90, i = 0} [00:10:17.220] stmt_list = 0x0 [00:10:17.220] query_list = [00:10:17.220] #11 0x00000000008d64cc in exec_simple_query (query_string=query_string@entry=0x8383d9100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [00:10:17.220] cmdtaglen = [00:10:17.220] snapshot_set = [00:10:17.220] per_parsetree_context = 0x0 [00:10:17.220] plantree_list = [00:10:17.220] qc = {commandTag = 336, nprocessed = 6} [00:10:17.220] parsetree = 0x838536600 [00:10:17.220] commandTag = [00:10:17.220] cmdtagname = [00:10:17.220] querytree_list = 0x0 [00:10:17.220] portal = [00:10:17.220] format = [00:10:17.220] receiver = [00:10:17.220] parsetree_item__state = {l = 0x8384b7378, i = 0} [00:10:17.220] msec_str = "P\001\000\000\000\000\000\000\006\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:10:17.220] dest = DestRemote [00:10:17.220] was_logged = [00:10:17.220] oldcontext = 0x8383e5000 [00:10:17.220] parsetree_list = 0x8384b7378 [00:10:17.220] use_implicit_block = false [00:10:17.220] parsetree_item = 0x8384b7390 [00:10:17.220] save_log_statement_stats = [00:10:17.220] #12 0x00000000008d43a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:10:17.220] query_string = 0x8383d9100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [00:10:17.220] input_message = {data = 0x8383d9100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [00:10:17.220] firstchar = [00:10:17.220] local_sigjmp_buf = {{_sjb = {9255024, 34914075856, 34914075816, 34914076416, 11914584, 11861056, 8192, 8388608, 72057628951970687, 0, 0, 34359738369}}} [00:10:17.220] send_ready_for_query = false [00:10:17.220] idle_in_transaction_timeout_enabled = false [00:10:17.220] idle_session_timeout_enabled = false [00:10:17.220] #13 0x000000000083303a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:10:17.220] No locals. [00:10:17.220] #14 0x00000000008312c0 in BackendStartup (client_sock=0x8210a9128) at ../src/backend/postmaster/postmaster.c:4117 [00:10:17.220] bn = 0x8383e50d8 [00:10:17.220] cac = CAC_OK [00:10:17.220] pid = [00:10:17.220] __error = [00:10:17.220] __error = [00:10:17.220] __error = [00:10:17.220] save_errno = [00:10:17.220] __error = [00:10:17.220] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:10:17.220] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X|\375+\000\000\000\000\001\000\000\000\000\000\000\000\320\356\264", '\000' , "\300Ƶ\000\000\000\000\000\v\000\000\000\000\000\000\000\240\221\n!\b\000\000\000ؕx+\b\000\000\000\320\356\264\000\000\000\000\000\016\026y+\b", '\000' , "\340\221\n!\b\000\000\000\264Â\000\000\000\000"}, salen = 16}} [00:10:17.220] i = 0 [00:10:17.220] now = [00:10:17.220] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 736214116, events = 8, fd = 554338160, user_data = 0x8210a8900}, {pos = 556549128, events = 8, fd = 32, user_data = 0x8210a88f0}, {pos = -1852999020, events = 3672, fd = 556519432, user_data = 0x8212bd408}, {pos = 556521480, events = 8, fd = 556522504, user_data = 0x8212c1008}, {pos = 556536840, events = 8, fd = 556537864, user_data = 0x8212c1c08}, {pos = 556539912, events = 8, fd = 556540936, user_data = 0x8212c2808}, {pos = 556542984, events = 8, fd = 556544008, user_data = 0x8212c3408}, {pos = 556546056, events = 8, fd = 556547080, user_data = 0x8212c4008}, {pos = 556549128, events = 8, fd = 556568712, user_data = 0x8210a8a78}, {pos = 554338464, events = 8, fd = -1852973661, user_data = 0x0}, {pos = 2565846, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 556572728, events = 8, fd = 1, user_data = 0x8212c4408}, {pos = 736122024, events = 8, fd = 554339192, user_data = 0x8212c4408}, {pos = 554338448, events = 0, fd = 736229732, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 556575288, user_data = 0x1}, {pos = 556549128, events = 8, fd = 736143576, user_data = 0x8210a89b8}, {pos = 554338160, events = 8, fd = 32, user_data = 0x82be1bc64}, {pos = 556549128, events = 8, fd = 556575288, user_data = 0x0}, {pos = 2625, events = 0, fd = 554338720, user_data = 0xe58918d7645}, {pos = 736229732, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 556575288, events = 8, fd = 1, user_data = 0x8212c4408}, {pos = 943493120, events = 8, fd = 1, user_data = 0x8383c9194}, {pos = 0, events = 0, fd = 554338672, user_data = 0x82b790c0c}, {pos = 1, events = 0, fd = 943493120, user_data = 0x8210a89a0}, {pos = 729349812, events = 8, fd = 737956192, user_data = 0x82bfc5160 }, {pos = 736325824, events = 8, fd = 556549128, user_data = 0x8210a8a80}, {pos = -1853000660, events = 3672, fd = 556548104, user_data = 0x800000001}, {pos = -1853001042, events = 3672, fd = 12240, user_data = 0x8210a89a8}, {pos = 554338944, events = 8, fd = 944289768, user_data = 0x8210a8ff0}, {pos = -1852920176, events = 3672, fd = 556549128, user_data = 0x8210a037f}, {pos = 737612978, events = 8, fd = 556519432, user_data = 0x0}, {pos = 556549128, events = 8, fd = 12240, user_data = 0x82bdfb000}, {pos = 1964368, events = 0, fd = 737956192, user_data = 0x82be1bc64}, {pos = 15616, events = 0, fd = 554340128, user_data = 0x8210a8af0}, {pos = 736887182, events = 8, fd = 737994808, user_data = 0x8210a8ab4}, {pos = 943945178, events = 8, fd = 554340128, user_data = 0x8210a8af0}, {pos = 736978437, events = 8, fd = 554338994, user_data = 0x8210a8f20}, {pos = 554340128, events = 8, fd = 0, user_data = 0xbb0f6ab280b6bec}, {pos = 554340128, events = 8, fd = 943945176, user_data = 0x8210a8ff0}, {pos = 737994808, events = 8, fd = 0, user_data = 0x8210a8f60}, {pos = 736978701, events = 8, fd = 0, user_data = 0x0}, {pos = 554340496, events = 8, fd = 943945176, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1852972023, events = 3672, fd = 554339400, user_data = 0x82be1bc64}, {pos = 2503, events = 0, fd = -1852972023, user_data = 0x8210a8c68}, {pos = 736214116, events = 8, fd = 2758, user_data = 0x82be15120}, {pos = 554339304, events = 8, fd = 556549128, user_data = 0x8210a8c68}, {pos = 736186656, events = 8, fd = 554339408, user_data = 0xe58918d9465}, {pos = 0, events = 0, fd = 0, user_data = 0x82bfe70f0}, {pos = 736146768, events = 8, fd = 0, user_data = 0x0}, {pos = 738023856, events = 8, fd = 16, user_data = 0x0}, {pos = 554339544, events = 8, fd = 556568712, user_data = 0xe58918de409}, {pos = 554339608, events = 8, fd = 736214116, user_data = 0xb6c}, {pos = 736187320, events = 8, fd = 554339480, user_data = 0x8212c4408}, {pos = 554339608, events = 8, fd = 736187320, user_data = 0x8210a8d00}, {pos = -1852992411, events = 3672, fd = 556572728, user_data = 0x800000001}, {pos = 556549128, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 554339992, user_data = 0x272620}, {pos = 554340096, events = 8, fd = 554340096, user_data = 0x8210a8eb8}, {pos = 30, events = 0, fd = 736150752, user_data = 0x8210a8da8}, {pos = 556569160, events = 8, fd = 554340200, user_data = 0x8210a8d90}, {pos = -1852973661, events = 3672, fd = 556572728, user_data = 0x29123d}} [00:10:17.220] last_touch_time = 1710547650 [00:10:17.220] last_lockfile_recheck_time = 1710547650 [00:10:17.220] nevents = 1 [00:10:17.220] #16 0x000000000082e5b6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8210a9728) at ../src/backend/postmaster/postmaster.c:1478 [00:10:17.220] userDoption = [00:10:17.220] listen_addr_saved = false [00:10:17.220] output_config_variable = [00:10:17.220] opt = [00:10:17.220] status = [00:10:17.220] #17 0x000000000076b7f5 in main (argc=4, argv=0x8210a9728) at ../src/backend/main/main.c:197 [00:10:17.220] do_check_root = [00:10:17.228] [00:10:17.228] [00:10:17.228] [00:10:17.286] dumping /tmp/cores/postgres.12925.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:10:17.413] [New LWP 100109] [00:10:17.482] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [00:10:17.482] Program terminated with signal SIGSEGV, Segmentation fault. [00:10:17.482] Address not mapped to object. [00:10:17.482] #0 equal (a=0x32a4ccb0, b=b@entry=0x8329b6678) at ../src/backend/nodes/equalfuncs.c:239 [00:10:17.482] 239 if (nodeTag(a) != nodeTag(b)) [00:10:18.074] [00:10:18.074] Thread 1 (LWP 100109): [00:10:18.074] #0 equal (a=0x32a4ccb0, b=b@entry=0x8329b6678) at ../src/backend/nodes/equalfuncs.c:239 [00:10:18.074] retval = [00:10:18.074] #1 0x000000000076ef32 in list_member (list=0x832a4cd20, datum=datum@entry=0x8329b6678) at ../src/backend/nodes/list.c:670 [00:10:18.074] cell__state = {l = 0x832a4cd20, i = 0} [00:10:18.074] cell = 0x0 [00:10:18.074] cell__state = [00:10:18.074] #2 0x00000000007e2915 in add_new_column_to_pathtarget (target=0x832a4cc40, expr=) at ../src/backend/optimizer/util/tlist.c:743 [00:10:18.074] No locals. [00:10:18.074] #3 add_new_columns_to_pathtarget (target=target@entry=0x832a4cc40, exprs=0x832a4cdd8) at ../src/backend/optimizer/util/tlist.c:760 [00:10:18.074] expr = [00:10:18.074] lc__state = {l = 0x832a4cdd8, i = 0} [00:10:18.074] lc = 0xfffffe3b [00:10:18.074] #4 0x00000000007b2309 in make_group_input_target (root=0x8329b6038, final_target=0x832a4cb70) at ../src/backend/optimizer/plan/planner.c:5472 [00:10:18.074] parse = 0x8359907c8 [00:10:18.074] input_target = 0x832a4cc40 [00:10:18.074] non_group_cols = 0x832a4cd88 [00:10:18.074] i = [00:10:18.074] lc = [00:10:18.074] non_group_vars = 0x832a4cdd8 [00:10:18.074] #5 grouping_planner (root=root@entry=0x8329b6038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:10:18.074] qp_extra = {activeWindows = 0x0, gset_data = 0x8329b6718} [00:10:18.074] activeWindows = 0x0 [00:10:18.074] sort_input_target_parallel_safe = false [00:10:18.074] grouping_target = 0x832a4cb70 [00:10:18.074] scanjoin_target = [00:10:18.074] sort_input_targets = [00:10:18.074] wflists = 0x0 [00:10:18.074] gset_data = 0x8329b6718 [00:10:18.074] have_grouping = false [00:10:18.074] sort_input_targets_contain_srfs = [00:10:18.074] sort_input_target = 0x832a4cb70 [00:10:18.074] grouping_target_parallel_safe = false [00:10:18.074] scanjoin_target_parallel_safe = [00:10:18.074] grouping_targets = [00:10:18.074] scanjoin_targets = [00:10:18.074] grouping_targets_contain_srfs = [00:10:18.074] scanjoin_targets_contain_srfs = [00:10:18.074] scanjoin_target_same_exprs = [00:10:18.074] extra = {limit_needed = 16, limit_tuples = 1.7395450230755057e-313, count_est = 0, offset_est = 34924843728} [00:10:18.074] parse = 0x8359907c8 [00:10:18.074] offset_est = [00:10:18.074] count_est = [00:10:18.074] limit_tuples = -1 [00:10:18.074] have_postponed_srfs = false [00:10:18.074] current_rel = 0x8329b54c8 [00:10:18.074] final_target = 0x832a4cb70 [00:10:18.074] final_targets_contain_srfs = [00:10:18.074] final_targets = [00:10:18.074] final_rel = [00:10:18.074] lc = [00:10:18.074] final_target_parallel_safe = [00:10:18.074] #6 0x00000000007b0214 in subquery_planner (glob=glob@entry=0x832a31ef8, parse=parse@entry=0x8359907c8, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=1.741974827249935e-313) at ../src/backend/optimizer/plan/planner.c:1084 [00:10:18.074] root = 0x8329b6038 [00:10:18.074] hasOuterJoins = false [00:10:18.074] hasResultRTEs = false [00:10:18.074] l = [00:10:18.074] newWithCheckOptions = [00:10:18.074] newHaving = 0x0 [00:10:18.074] final_rel = [00:10:18.074] #7 0x00000000007aed38 in standard_planner (parse=0x8359907c8, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [00:10:18.074] glob = 0x832a31ef8 [00:10:18.074] tuple_fraction = 0 [00:10:18.074] root = [00:10:18.074] final_rel = [00:10:18.074] best_path = [00:10:18.074] top_plan = [00:10:18.074] lp = [00:10:18.074] lr = [00:10:18.074] result = [00:10:18.074] #8 0x00000000007aec0c in planner (parse=0x32a4ccb0, parse@entry=0x8359907c8, query_string=0x8329b6678 "\006", query_string@entry=0x83299c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=565105168, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [00:10:18.074] result = [00:10:18.074] #9 0x00000000008d2255 in pg_plan_query (querytree=querytree@entry=0x8359907c8, query_string=query_string@entry=0x83299c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [00:10:18.074] plan = [00:10:18.074] #10 0x0000000000685da9 in standard_ExplainOneQuery (query=0x8359907c8, cursorOptions=565105168, cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x832b37748, queryString=0x8329b6678 "\006", params=0xfffffe3b, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:441 [00:10:18.074] planduration = {ticks = 7790944} [00:10:18.074] bufusage_start = {shared_blks_hit = 34924844655, shared_blks_read = 0, shared_blks_dirtied = 35258960088, shared_blks_written = 35258960744, local_blks_hit = 34924844480, local_blks_read = 10587121, local_blks_dirtied = 70368744214795, local_blks_written = 0, temp_blks_read = 34924844512, temp_blks_written = 5658122, shared_blk_read_time = {ticks = 70368744214795}, shared_blk_write_time = {ticks = 1}, local_blk_read_time = {ticks = 34924844528}, local_blk_write_time = {ticks = 6205849}, temp_blk_read_time = {ticks = 34924844704}, temp_blk_write_time = {ticks = 8916107}} [00:10:18.074] bufusage = {shared_blks_hit = 147, shared_blks_read = 733294142, shared_blks_dirtied = 34924844640, shared_blks_written = 35258957968, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 35258123616, temp_blks_written = 10800259, shared_blk_read_time = {ticks = 35258961816}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35258959816}, local_blk_write_time = {ticks = 35258959816}, temp_blk_read_time = {ticks = 34924844672}, temp_blk_write_time = {ticks = 10835824}} [00:10:18.074] mem_counters = {nblocks = 34924844448, freechunks = 9140805, totalspace = 34924844448, freespace = 35258123616} [00:10:18.074] planner_ctx = 0x0 [00:10:18.074] saved_ctx = [00:10:18.074] planstart = {ticks = -147733294142} [00:10:18.074] plan = [00:10:18.074] #11 0x000000000068577c in ExplainOneQuery (query=0x32a4ccb0, cursorOptions=2048, into=0x0, es=0x832b37748, queryString=0x3 , params=0x832a4b000, queryEnv=) at ../src/backend/commands/explain.c:397 [00:10:18.074] No locals. [00:10:18.074] #12 ExplainQuery (pstate=pstate@entry=0x832b37638, stmt=stmt@entry=0x835990798, params=0x832a4b000, params@entry=0x0, dest=0x832b375a8) at ../src/backend/commands/explain.c:293 [00:10:18.074] l__state = {l = , i = 0} [00:10:18.074] l = 0x832a31cb0 [00:10:18.074] es = 0x832b37748 [00:10:18.074] jstate = [00:10:18.074] timing_set = false [00:10:18.074] summary_set = false [00:10:18.074] lc = [00:10:18.074] query = [00:10:18.074] rewritten = 0x832a31c98 [00:10:18.074] tstate = [00:10:18.074] #13 0x00000000008d935f in standard_ProcessUtility (pstmt=0x835991410, queryString=0x83299c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x821aed210, queryEnv=0x0, dest=0x832b375a8, qc=0x821aed858) at ../src/backend/tcop/utility.c:863 [00:10:18.074] isAtomicContext = true [00:10:18.074] parsetree = 0x835990798 [00:10:18.074] readonly_flags = [00:10:18.074] pstate = 0x832b37638 [00:10:18.074] isTopLevel = [00:10:18.074] #14 0x00000000008d8c8d in ProcessUtility (pstmt=0x32a4ccb0, pstmt@entry=0x835991410, queryString=0x8329b6678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x832a4b000, dest=0x832b375a8, qc=0x821aed858) at ../src/backend/tcop/utility.c:523 [00:10:18.074] No locals. [00:10:18.074] #15 0x00000000008d87b3 in PortalRunUtility (portal=portal@entry=0x832a71100, pstmt=0x835991410, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x832b375a8, qc=qc@entry=0x821aed858) at ../src/backend/tcop/pquery.c:1158 [00:10:18.074] No locals. [00:10:18.074] #16 0x00000000008d79aa in FillPortalStore (portal=portal@entry=0x832a71100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [00:10:18.074] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:10:18.074] treceiver = 0x832b375a8 [00:10:18.074] #17 0x00000000008d76b0 in PortalRun (portal=portal@entry=0x832a71100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x835991570, altdest=altdest@entry=0x835991570, qc=0x821aed990) at ../src/backend/tcop/pquery.c:763 [00:10:18.074] _local_sigjmp_buf = {{_sjb = {9270863, 35209608768, 34924845192, 34924845424, 34924845200, 11905848, 11873632, 35209548032, 4860019583, 35209556224, 3554698, 34359738368}}} [00:10:18.074] _save_exception_stack = 0x821aeda60 [00:10:18.074] _save_context_stack = 0x0 [00:10:18.074] _do_rethrow = false [00:10:18.074] saveTopTransactionResourceOwner = 0x832a7fe40 [00:10:18.074] saveTopTransactionContext = 0x832b5d000 [00:10:18.074] saveActivePortal = 0x0 [00:10:18.074] saveResourceOwner = 0x832a7fe40 [00:10:18.074] savePortalContext = 0x0 [00:10:18.074] saveMemoryContext = 0x832b5d000 [00:10:18.074] result = [00:10:18.074] nprocessed = [00:10:18.074] #18 0x00000000008d65bb in exec_simple_query (query_string=query_string@entry=0x83299c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1274 [00:10:18.074] cmdtaglen = [00:10:18.074] snapshot_set = [00:10:18.074] per_parsetree_context = 0x0 [00:10:18.074] plantree_list = [00:10:18.074] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:10:18.074] parsetree = 0x832a65c58 [00:10:18.074] commandTag = CMDTAG_EXPLAIN [00:10:18.074] cmdtagname = [00:10:18.074] querytree_list = [00:10:18.074] portal = 0x832a71100 [00:10:18.074] format = 0 [00:10:18.074] receiver = 0x835991570 [00:10:18.074] parsetree_item__state = {l = 0x832a664e0, i = 0} [00:10:18.074] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:10:18.074] dest = DestRemote [00:10:18.074] was_logged = [00:10:18.074] oldcontext = 0x832b5d000 [00:10:18.074] parsetree_list = 0x832a664e0 [00:10:18.074] use_implicit_block = false [00:10:18.074] parsetree_item = 0x832a664f8 [00:10:18.074] save_log_statement_stats = [00:10:18.074] #19 0x00000000008d43a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:10:18.074] query_string = 0x83299c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [00:10:18.074] input_message = {data = 0x83299c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [00:10:18.074] firstchar = [00:10:18.074] local_sigjmp_buf = {{_sjb = {9255024, 34924845664, 34924845624, 34924846224, 11914584, 11861056, 8192, 8388608, 72057628962718591, 0, 0, 34359738369}}} [00:10:18.074] send_ready_for_query = false [00:10:18.074] idle_in_transaction_timeout_enabled = false [00:10:18.074] idle_session_timeout_enabled = false [00:10:18.074] #20 0x000000000083303a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:10:18.074] No locals. [00:10:18.074] #21 0x00000000008312c0 in BackendStartup (client_sock=0x821aee6b8) at ../src/backend/postmaster/postmaster.c:4117 [00:10:18.074] bn = 0x8329a8498 [00:10:18.074] cac = CAC_OK [00:10:18.074] pid = [00:10:18.074] __error = [00:10:18.074] __error = [00:10:18.074] __error = [00:10:18.074] save_errno = [00:10:18.074] __error = [00:10:18.074] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:10:18.074] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X\f\244+\000\000\000\000\001\000\000\000\000\000\000\000\320\356\264", '\000' , "\300Ƶ\000\000\000\000\000\v\000\000\000\000\000\000\0000\347\256!\b\000\000\000\330\205;+\b\000\000\000\320\356\264\000\000\000\000\000\016\006<+\b", '\000' , "p\347\256!\b\000\000\000\264Â\000\000\000\000"}, salen = 16}} [00:10:18.074] i = 0 [00:10:18.074] now = [00:10:18.074] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 730352740, events = 8, fd = 565107968, user_data = 0x821aede90}, {pos = 580727816, events = 8, fd = 32, user_data = 0x821aede80}, {pos = -2112431468, events = 3111, fd = 580698120, user_data = 0x8229cc408}, {pos = 580700168, events = 8, fd = 580701192, user_data = 0x8229d0008}, {pos = 580715528, events = 8, fd = 580716552, user_data = 0x8229d0c08}, {pos = 580718600, events = 8, fd = 580719624, user_data = 0x8229d1808}, {pos = 580721672, events = 8, fd = 580722696, user_data = 0x8229d2408}, {pos = 580724744, events = 8, fd = 580725768, user_data = 0x8229d3008}, {pos = 580727816, events = 8, fd = -1, user_data = 0x82ba5c2e0}, {pos = 565108208, events = 8, fd = 731943337, user_data = 0x0}, {pos = 4096, events = 0, fd = -1443945139, user_data = 0x82ba5c7e8}, {pos = 838900704, events = 8, fd = 160, user_data = 0x0}, {pos = 822538384, events = 8, fd = 565108416, user_data = 0x82b9e792c}, {pos = 4096, events = 0, fd = 730368356, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 580753976, user_data = 0x800000001}, {pos = 580727816, events = 8, fd = 730282200, user_data = 0x821aedf48}, {pos = 565107968, events = 8, fd = 32, user_data = 0x82b884c64}, {pos = 580727816, events = 8, fd = 580753976, user_data = 0x0}, {pos = 2625, events = 0, fd = 565108528, user_data = 0xc278216d645}, {pos = 730368356, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 580753976, events = 8, fd = 1, user_data = 0x8229d3408}, {pos = 848871424, events = 8, fd = 1, user_data = 0x83298c194}, {pos = 0, events = 0, fd = 565108480, user_data = 0x82b3bfc0c}, {pos = 1, events = 0, fd = 848871424, user_data = 0x821aedf30}, {pos = 725348020, events = 8, fd = 732094816, user_data = 0x82ba2e160 }, {pos = 730464448, events = 8, fd = 580727816, user_data = 0x821aee010}, {pos = -2112433108, events = 3111, fd = 822538384, user_data = 0x800000001}, {pos = -2112433490, events = 3111, fd = 12240, user_data = 0x821aedf38}, {pos = 565108752, events = 8, fd = 849549288, user_data = 0x821aee580}, {pos = -2112352624, events = 3111, fd = 580727816, user_data = 0x821ae037f}, {pos = 731751836, events = 8, fd = 580698120, user_data = 0x0}, {pos = 580727816, events = 8, fd = 12240, user_data = 0x82b864000}, {pos = 1964368, events = 0, fd = 732094816, user_data = 0x82b884c64}, {pos = 15616, events = 0, fd = 565109936, user_data = 0x821aee080}, {pos = 731025806, events = 8, fd = 732133432, user_data = 0x821aee044}, {pos = 849286618, events = 8, fd = 565109936, user_data = 0x821aee080}, {pos = 731117061, events = 8, fd = 565108802, user_data = 0x821aee4b0}, {pos = 565109936, events = 8, fd = 0, user_data = 0xbdffb2c5a9ef254d}, {pos = 565109936, events = 8, fd = 849286616, user_data = 0x821aee580}, {pos = 732133432, events = 8, fd = 0, user_data = 0x821aee4f0}, {pos = 731117325, events = 8, fd = 0, user_data = 0x0}, {pos = 565110304, events = 8, fd = 849286616, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -2112404471, events = 3111, fd = 565109208, user_data = 0x82b884c64}, {pos = 2503, events = 0, fd = -2112404471, user_data = 0x821aee1f8}, {pos = 730352740, events = 8, fd = 2758, user_data = 0x82b87e120}, {pos = 565109112, events = 8, fd = 580727816, user_data = 0x821aee1f8}, {pos = 730325280, events = 8, fd = 565109216, user_data = 0xc278216f465}, {pos = 0, events = 0, fd = 0, user_data = 0x82ba500f0}, {pos = 730285392, events = 8, fd = 0, user_data = 0x0}, {pos = 732162480, events = 8, fd = 16, user_data = 0x0}, {pos = 565109352, events = 8, fd = 580747400, user_data = 0xc2782174409}, {pos = 565109416, events = 8, fd = 730352740, user_data = 0xb6c}, {pos = 730325944, events = 8, fd = 565109288, user_data = 0x8229d3408}, {pos = 565109416, events = 8, fd = 730325944, user_data = 0x821aee290}, {pos = -2112424859, events = 3111, fd = 580751416, user_data = 0x800000001}, {pos = 580727816, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 565109800, user_data = 0x272620}, {pos = 565109904, events = 8, fd = 565109904, user_data = 0x821aee448}, {pos = 30, events = 0, fd = 730289376, user_data = 0x821aee338}, {pos = 580747848, events = 8, fd = 565110008, user_data = 0x821aee320}, {pos = -2112406109, events = 3111, fd = 580751416, user_data = 0x29123d}} [00:10:18.074] last_touch_time = 1710547648 [00:10:18.074] last_lockfile_recheck_time = 1710547648 [00:10:18.074] nevents = 1 [00:10:18.074] #23 0x000000000082e5b6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821aeecb8) at ../src/backend/postmaster/postmaster.c:1478 [00:10:18.074] userDoption = [00:10:18.074] listen_addr_saved = false [00:10:18.074] output_config_variable = [00:10:18.074] opt = [00:10:18.074] status = [00:10:18.074] #24 0x000000000076b7f5 in main (argc=8, argv=0x821aeecb8) at ../src/backend/main/main.c:197 [00:10:18.074] do_check_root = [00:10:18.084] [00:10:18.084] [00:10:18.084] [00:10:18.142] dumping /tmp/cores/postgres.17259.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:10:18.266] [New LWP 101949] [00:10:18.340] Core was generated by `postgres: primary: postgres regression [local] SELECT'. [00:10:18.340] Program terminated with signal SIGSEGV, Segmentation fault. [00:10:18.340] Address not mapped to object. [00:10:18.340] #0 equal (a=0x3c7812e8, b=b@entry=0x83c77dbd8) at ../src/backend/nodes/equalfuncs.c:239 [00:10:18.340] 239 if (nodeTag(a) != nodeTag(b)) [00:10:18.390] [00:10:18.390] Thread 1 (LWP 101949): [00:10:18.390] #0 equal (a=0x3c7812e8, b=b@entry=0x83c77dbd8) at ../src/backend/nodes/equalfuncs.c:239 [00:10:18.390] retval = [00:10:18.390] #1 0x000000000076ef32 in list_member (list=0x83c781358, datum=datum@entry=0x83c77dbd8) at ../src/backend/nodes/list.c:670 [00:10:18.390] cell__state = {l = 0x83c781358, i = 0} [00:10:18.390] cell = 0x0 [00:10:18.390] cell__state = [00:10:18.390] #2 0x00000000007e2915 in add_new_column_to_pathtarget (target=0x83c781278, expr=) at ../src/backend/optimizer/util/tlist.c:743 [00:10:18.390] No locals. [00:10:18.390] #3 add_new_columns_to_pathtarget (target=target@entry=0x83c781278, exprs=0x83c781488) at ../src/backend/optimizer/util/tlist.c:760 [00:10:18.390] expr = [00:10:18.390] lc__state = {l = 0x83c781488, i = 0} [00:10:18.390] lc = 0xfffffe3b [00:10:18.390] #4 0x00000000007b2309 in make_group_input_target (root=0x8363e89e0, final_target=0x83c781118) at ../src/backend/optimizer/plan/planner.c:5472 [00:10:18.390] parse = 0x83c699660 [00:10:18.390] input_target = 0x83c781278 [00:10:18.390] non_group_cols = 0x83c781438 [00:10:18.390] i = [00:10:18.390] lc = [00:10:18.390] non_group_vars = 0x83c781488 [00:10:18.390] #5 grouping_planner (root=root@entry=0x8363e89e0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:10:18.390] qp_extra = {activeWindows = 0x0, gset_data = 0x83c77f028} [00:10:18.390] activeWindows = 0x0 [00:10:18.390] sort_input_target_parallel_safe = false [00:10:18.390] grouping_target = 0x83c781118 [00:10:18.390] scanjoin_target = [00:10:18.390] sort_input_targets = [00:10:18.390] wflists = 0x0 [00:10:18.390] gset_data = 0x83c77f028 [00:10:18.390] have_grouping = false [00:10:18.390] sort_input_targets_contain_srfs = [00:10:18.390] sort_input_target = 0x83c781118 [00:10:18.390] grouping_target_parallel_safe = false [00:10:18.390] scanjoin_target_parallel_safe = [00:10:18.390] grouping_targets = [00:10:18.390] scanjoin_targets = [00:10:18.390] grouping_targets_contain_srfs = [00:10:18.390] scanjoin_targets_contain_srfs = [00:10:18.390] scanjoin_target_same_exprs = [00:10:18.390] extra = {limit_needed = 8, limit_tuples = 1.7477191755514072e-313, count_est = 72, offset_est = 34918816752} [00:10:18.390] parse = 0x83c699660 [00:10:18.390] offset_est = [00:10:18.390] count_est = [00:10:18.390] limit_tuples = -1 [00:10:18.390] have_postponed_srfs = false [00:10:18.390] current_rel = 0x83c7627c8 [00:10:18.390] final_target = 0x83c781118 [00:10:18.390] final_targets_contain_srfs = [00:10:18.390] final_targets = [00:10:18.390] final_rel = [00:10:18.390] lc = [00:10:18.390] final_target_parallel_safe = [00:10:18.390] #6 0x00000000007b0214 in subquery_planner (glob=glob@entry=0x83c77b4c0, parse=parse@entry=0x83c699660, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:10:18.390] root = 0x8363e89e0 [00:10:18.390] hasOuterJoins = false [00:10:18.390] hasResultRTEs = false [00:10:18.390] l = [00:10:18.390] newWithCheckOptions = [00:10:18.390] newHaving = 0x0 [00:10:18.390] final_rel = [00:10:18.390] #7 0x00000000007aed38 in standard_planner (parse=0x83c699660, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [00:10:18.390] glob = 0x83c77b4c0 [00:10:18.390] tuple_fraction = 0 [00:10:18.390] root = [00:10:18.390] final_rel = [00:10:18.390] best_path = [00:10:18.390] top_plan = [00:10:18.390] lp = [00:10:18.390] lr = [00:10:18.390] result = [00:10:18.390] #8 0x0000000838d6f6af in pgss_planner (parse=0x83c699660, query_string=0x83c77dbd8 "\006", cursorOptions=559078208, boundParams=0xfffffe3b) at ../contrib/pg_stat_statements/pg_stat_statements.c:972 [00:10:18.390] _local_sigjmp_buf = {{_sjb = {35313349981, 11905848, 34918817336, 34918817792, 34918817376, 0, 35373291104, 34918818192, 35374171007, 35373288912, 34918817488, 0}}} [00:10:18.390] _save_exception_stack = 0x82152e190 [00:10:18.390] _save_context_stack = 0x0 [00:10:18.390] _do_rethrow = false [00:10:18.390] result = [00:10:18.390] #9 0x00000000007aec05 in planner (parse=0x3c7812e8, parse@entry=0x83c699660, query_string=0x83c77dbd8 "\006", query_string@entry=0x8362b0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=559078208, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [00:10:18.390] result = [00:10:18.390] #10 0x00000000008d2255 in pg_plan_query (querytree=querytree@entry=0x83c699660, query_string=query_string@entry=0x8362b0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [00:10:18.390] plan = [00:10:18.390] #11 0x00000000008d2332 in pg_plan_queries (querytrees=0x83c77b470, query_string=query_string@entry=0x8362b0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=559078208, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [00:10:18.390] query = 0x83c699660 [00:10:18.390] stmt = [00:10:18.390] query_list__state = {l = 0x83c77b470, i = 0} [00:10:18.390] stmt_list = 0x0 [00:10:18.390] query_list = [00:10:18.390] #12 0x00000000008d64cc in exec_simple_query (query_string=query_string@entry=0x8362b0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [00:10:18.390] cmdtaglen = [00:10:18.390] snapshot_set = [00:10:18.390] per_parsetree_context = 0x0 [00:10:18.390] plantree_list = [00:10:18.390] qc = {commandTag = 336, nprocessed = 6} [00:10:18.390] parsetree = 0x8363e9600 [00:10:18.390] commandTag = [00:10:18.390] cmdtagname = [00:10:18.390] querytree_list = 0x0 [00:10:18.390] portal = [00:10:18.390] format = [00:10:18.390] receiver = [00:10:18.390] parsetree_item__state = {l = 0x83c7623f8, i = 0} [00:10:18.390] msec_str = "P\001\000\000\000\000\000\000\006\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:10:18.390] dest = DestRemote [00:10:18.390] was_logged = [00:10:18.390] oldcontext = 0x8362bc000 [00:10:18.390] parsetree_list = 0x83c7623f8 [00:10:18.390] use_implicit_block = false [00:10:18.390] parsetree_item = 0x83c762410 [00:10:18.390] save_log_statement_stats = [00:10:18.390] #13 0x00000000008d43a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:10:18.390] query_string = 0x8362b0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [00:10:18.390] input_message = {data = 0x8362b0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [00:10:18.390] firstchar = [00:10:18.390] local_sigjmp_buf = {{_sjb = {9255024, 34918818192, 34918818152, 34918818752, 11914584, 11861056, 8192, 8388608, 72057628956689279, 0, 0, 1}}} [00:10:18.390] send_ready_for_query = false [00:10:18.390] idle_in_transaction_timeout_enabled = false [00:10:18.390] idle_session_timeout_enabled = false [00:10:18.390] #14 0x000000000083303a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:10:18.390] No locals. [00:10:18.390] #15 0x00000000008312c0 in BackendStartup (client_sock=0x82152ede8) at ../src/backend/postmaster/postmaster.c:4117 [00:10:18.390] bn = 0x8362bc178 [00:10:18.390] cac = CAC_OK [00:10:18.390] pid = [00:10:18.390] __error = [00:10:18.390] __error = [00:10:18.390] __error = [00:10:18.390] save_errno = [00:10:18.390] __error = [00:10:18.390] #16 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:10:18.390] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X\234A-\000\000\000\000\001\000\000\000\000\000\000\000\320\356\264", '\000' , "\300Ƶ\000\000\000\000\000\v\000\000\000\000\000\000\000`\356R!\b\000\000\000\330U\005)\b\000\000\000\320\356\264\000\000\000\000\000\016\326\005)\b", '\000' , "\240\356R!\b\000\000\000\264Â\000\000\000\000"}, salen = 16}} [00:10:18.390] i = 0 [00:10:18.390] now = [00:10:18.390] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 559080896, events = 8, fd = 559313928, user_data = 0x21}, {pos = 559080880, events = 8, fd = -2039756140, user_data = 0x821560008}, {pos = 559285256, events = 8, fd = 559286280, user_data = 0x821560c08}, {pos = 559300616, events = 8, fd = 559301640, user_data = 0x821564808}, {pos = 559303688, events = 8, fd = 559304712, user_data = 0x821565408}, {pos = 559306760, events = 8, fd = 559307784, user_data = 0x821566008}, {pos = 559309832, events = 8, fd = 559310856, user_data = 0x821566c08}, {pos = 559312904, events = 8, fd = 559313928, user_data = 0x82156c088}, {pos = 559081272, events = 8, fd = 559080784, user_data = 0x2ff5866c2da3}, {pos = 559313928, events = 8, fd = 2565846, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 559337528, user_data = 0x1}, {pos = 559313928, events = 8, fd = 757363880, user_data = 0x82152e838}, {pos = 559313928, events = 8, fd = 559080752, user_data = 0x272620}, {pos = 559081344, events = 8, fd = 757471588, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 559340088, user_data = 0x2ff500000001}, {pos = 559313928, events = 8, fd = 757385432, user_data = 0x82152e678}, {pos = 559080480, events = 8, fd = 33, user_data = 0x82d25dc64}, {pos = 559313928, events = 8, fd = 559340088, user_data = 0x0}, {pos = 2625, events = 0, fd = 559081056, user_data = 0x2ff5866bc645}, {pos = 757471588, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 559340088, events = 8, fd = 1, user_data = 0x821567408}, {pos = 908722176, events = 8, fd = 1, user_data = 0x8362a0194}, {pos = 0, events = 0, fd = 559081008, user_data = 0x82905cc0c}, {pos = 1, events = 0, fd = 908722176, user_data = 0x82152e660}, {pos = 688242356, events = 8, fd = 759198048, user_data = 0x82d407160 }, {pos = 757567680, events = 8, fd = 559313928, user_data = 0x82152e740}, {pos = -2039757780, events = 12277, fd = 80627796, user_data = 0x1}, {pos = -2039758162, events = 12277, fd = 12240, user_data = 0x82152e668}, {pos = 559081280, events = 8, fd = 909518824, user_data = 0x82152ecb0}, {pos = -2039677296, events = 12277, fd = 559313928, user_data = 0x82152037f}, {pos = 758854834, events = 8, fd = 559081584, user_data = 0x2ff500000000}, {pos = 559313928, events = 8, fd = 12240, user_data = 0x82d23d000}, {pos = 1964368, events = 0, fd = 759198048, user_data = 0x82d25dc64}, {pos = 15616, events = 0, fd = 559082464, user_data = 0x82152e7b0}, {pos = 758129038, events = 8, fd = 759236664, user_data = 0x82152e774}, {pos = 909145562, events = 8, fd = 559082464, user_data = 0x82152e7b0}, {pos = 758220293, events = 8, fd = 559081330, user_data = 0x82152ebe0}, {pos = 559082464, events = 8, fd = 0, user_data = 0xc72b5c5c360114a1}, {pos = 559082464, events = 8, fd = 909145560, user_data = 0x82152ecb0}, {pos = 759236664, events = 8, fd = 0, user_data = 0x82152ec20}, {pos = 758220557, events = 8, fd = 0, user_data = 0x0}, {pos = 559082832, events = 8, fd = 909145560, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2039729143, user_data = 0x82152e8f8}, {pos = 757455972, events = 8, fd = 2503, user_data = 0x2ff5866c3409}, {pos = 559081752, events = 8, fd = 757455972, user_data = 0xac6}, {pos = 757428512, events = 8, fd = 559081624, user_data = 0x821567408}, {pos = 559081752, events = 8, fd = 757428512, user_data = 0x82152e900}, {pos = -2039749531, events = 12277, fd = 0, user_data = 0x800000000}, {pos = 559081712, events = 8, fd = 757388624, user_data = 0x0}, {pos = 0, events = 0, fd = 559081680, user_data = 0x10}, {pos = 0, events = 0, fd = 559081864, user_data = 0x82156c088}, {pos = -2039729143, events = 12277, fd = 559081928, user_data = 0x82d25dc64}, {pos = 2924, events = 0, fd = 757429176, user_data = 0x82152e948}, {pos = 559313928, events = 8, fd = 559081928, user_data = 0x82d2573b8}, {pos = 559081904, events = 8, fd = -2039749531, user_data = 0x82156d038}, {pos = 1, events = 8, fd = 559313928, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x2152eb58}, {pos = 2565664, events = 0, fd = 559082432, user_data = 0x82152ebc0}, {pos = 559082360, events = 8, fd = 31, user_data = 0x0}, {pos = 559082072, events = 8, fd = 559335304, user_data = 0x82152ec28}, {pos = 559082048, events = 8, fd = -2039730781, user_data = 0x82156d038}, {pos = 2691645, events = 0, fd = 448139, user_data = 0x87c96e577}} [00:10:18.390] last_touch_time = 1710547674 [00:10:18.390] last_lockfile_recheck_time = 1710547674 [00:10:18.390] nevents = 1 [00:10:18.390] #17 0x000000000082e5b6 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82152f3e8) at ../src/backend/postmaster/postmaster.c:1478 [00:10:18.390] userDoption = [00:10:18.390] listen_addr_saved = false [00:10:18.390] output_config_variable = [00:10:18.390] opt = [00:10:18.390] status = [00:10:18.390] #18 0x000000000076b7f5 in main (argc=4, argv=0x82152f3e8) at ../src/backend/main/main.c:197 [00:10:18.390] do_check_root = [00:10:18.398] [00:10:18.398] [00:10:18.398] [00:10:18.457] dumping /tmp/cores/postgres.18685.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:10:18.584] [New LWP 101873] [00:10:18.657] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT'. [00:10:18.657] Program terminated with signal SIGSEGV, Segmentation fault. [00:10:18.657] Address not mapped to object. [00:10:18.657] #0 get_expr_width (root=root@entry=0x837fd99c0, expr=expr@entry=0x37ff1bb0) at ../src/backend/optimizer/path/costsize.c:6328 [00:10:18.657] 6328 if (IsA(expr, Var)) [00:10:18.680] [00:10:18.680] Thread 1 (LWP 101873): [00:10:18.680] #0 get_expr_width (root=root@entry=0x837fd99c0, expr=expr@entry=0x37ff1bb0) at ../src/backend/optimizer/path/costsize.c:6328 [00:10:18.680] width = [00:10:18.680] #1 0x0000000000789cc5 in set_pathtarget_cost_width (root=root@entry=0x837fd99c0, target=target@entry=0x837ff1b40) at ../src/backend/optimizer/path/costsize.c:6299 [00:10:18.680] node = 0x37ff1bb0 [00:10:18.680] lc__state = {l = 0x837ff1c20, i = 0} [00:10:18.680] tuple_width = 0 [00:10:18.680] lc = 0x837ff1c38 [00:10:18.680] #2 0x00000000007b2324 in make_group_input_target (root=0x837fd99c0, final_target=0x837ff1a80) at ../src/backend/optimizer/plan/planner.c:5479 [00:10:18.680] parse = 0x837fdcdf0 [00:10:18.680] input_target = 0x837ff1b40 [00:10:18.680] non_group_cols = 0x0 [00:10:18.680] i = [00:10:18.680] lc = [00:10:18.680] non_group_vars = 0x0 [00:10:18.680] #3 grouping_planner (root=root@entry=0x837fd99c0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:10:18.680] qp_extra = {activeWindows = 0x0, gset_data = 0x837fee738} [00:10:18.680] activeWindows = 0x0 [00:10:18.680] sort_input_target_parallel_safe = false [00:10:18.680] grouping_target = 0x837ff1a80 [00:10:18.680] scanjoin_target = [00:10:18.680] sort_input_targets = [00:10:18.680] wflists = 0x0 [00:10:18.680] gset_data = 0x837fee738 [00:10:18.680] have_grouping = false [00:10:18.680] sort_input_targets_contain_srfs = [00:10:18.680] sort_input_target = 0x837ff1a80 [00:10:18.680] grouping_target_parallel_safe = false [00:10:18.680] scanjoin_target_parallel_safe = [00:10:18.680] grouping_targets = [00:10:18.680] scanjoin_targets = [00:10:18.680] grouping_targets_contain_srfs = [00:10:18.680] scanjoin_targets_contain_srfs = [00:10:18.680] scanjoin_target_same_exprs = [00:10:18.680] extra = {limit_needed = 144, limit_tuples = 1.7249664861680146e-313, count_est = 16, offset_est = 34913710400} [00:10:18.680] parse = 0x837fdcdf0 [00:10:18.680] offset_est = [00:10:18.680] count_est = [00:10:18.680] limit_tuples = -1 [00:10:18.680] have_postponed_srfs = false [00:10:18.680] current_rel = 0x837ff0070 [00:10:18.680] final_target = 0x837ff1a80 [00:10:18.680] final_targets_contain_srfs = [00:10:18.680] final_targets = [00:10:18.680] final_rel = [00:10:18.680] lc = [00:10:18.680] final_target_parallel_safe = [00:10:18.680] #4 0x00000000007b0214 in subquery_planner (glob=glob@entry=0x837fde718, parse=parse@entry=0x837fdcdf0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:10:18.680] root = 0x837fd99c0 [00:10:18.680] hasOuterJoins = false [00:10:18.680] hasResultRTEs = false [00:10:18.680] l = [00:10:18.680] newWithCheckOptions = [00:10:18.680] newHaving = 0x0 [00:10:18.680] final_rel = [00:10:18.680] #5 0x00000000007aed38 in standard_planner (parse=0x837fdcdf0, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [00:10:18.680] glob = 0x837fde718 [00:10:18.680] tuple_fraction = 0 [00:10:18.680] root = [00:10:18.680] final_rel = [00:10:18.680] best_path = [00:10:18.680] top_plan = [00:10:18.680] lp = [00:10:18.680] lr = [00:10:18.680] result = [00:10:18.680] #6 0x0000000838c49712 in pgss_planner (parse=0x837fdcdf0, query_string=0x833e52100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=8, boundParams=0x837ff1c38) at ../contrib/pg_stat_statements/pg_stat_statements.c:926 [00:10:18.680] _local_sigjmp_buf = {{_sjb = {35312146031, 35230392576, 34913710984, 34913711440, 11905848, 35299118576, 34913711152, 0, 34913649535, 11092085, 2, 34359738368}}} [00:10:18.680] _save_exception_stack = 0x82104f6e0 [00:10:18.680] _save_context_stack = 0x0 [00:10:18.680] _do_rethrow = false [00:10:18.680] bufusage = {shared_blks_hit = 35312146031, shared_blks_read = 35230392576, shared_blks_dirtied = 34913710984, shared_blks_written = 34913711440, local_blks_hit = 11905848, local_blks_read = 35299118576, local_blks_dirtied = 34913711152, local_blks_written = 0, temp_blks_read = 34913649535, temp_blks_written = 11092085, shared_blk_read_time = {ticks = 2}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 34913711296}, local_blk_write_time = {ticks = 11121071}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 35299124760}} [00:10:18.680] walusage_start = {wal_records = 1349, wal_fpi = 2, wal_bytes = 170536} [00:10:18.680] duration = [00:10:18.680] bufusage_start = {shared_blks_hit = 27833, shared_blks_read = 4, shared_blks_dirtied = 18, shared_blks_written = 18, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [00:10:18.680] walusage = {wal_records = 35299118576, wal_fpi = 35299172856, wal_bytes = 34913711360} [00:10:18.680] start = [00:10:18.680] result = [00:10:18.680] #7 0x00000000007aec05 in planner (parse=0x837fd99c0, parse@entry=0x837fdcdf0, query_string=0x37ff1bb0 , query_string@entry=0x833e52100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=8, cursorOptions@entry=2048, boundParams=0x837ff1c38, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [00:10:18.680] result = [00:10:18.680] #8 0x00000000008d2255 in pg_plan_query (querytree=querytree@entry=0x837fdcdf0, query_string=query_string@entry=0x833e52100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [00:10:18.680] plan = [00:10:18.680] #9 0x00000000008d2332 in pg_plan_queries (querytrees=0x837fde6c8, query_string=query_string@entry=0x833e52100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=8, cursorOptions@entry=2048, boundParams=0x837ff1c38, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [00:10:18.680] query = 0x837fdcdf0 [00:10:18.680] stmt = [00:10:18.680] query_list__state = {l = 0x837fde6c8, i = 0} [00:10:18.680] stmt_list = 0x0 [00:10:18.680] query_list = [00:10:18.680] #10 0x00000000008d64cc in exec_simple_query (query_string=query_string@entry=0x833e52100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;") at ../src/backend/tcop/postgres.c:1193 [00:10:18.680] cmdtaglen = [00:10:18.680] snapshot_set = [00:10:18.680] per_parsetree_context = 0x0 [00:10:18.680] plantree_list = [00:10:18.680] qc = {commandTag = 336, nprocessed = 6} [00:10:18.680] parsetree = 0x837f97cb0 [00:10:18.680] commandTag = [00:10:18.680] cmdtagname = [00:10:18.680] querytree_list = 0x0 [00:10:18.680] portal = [00:10:18.680] format = [00:10:18.680] receiver = [00:10:18.680] parsetree_item__state = {l = 0x837fea1a8, i = 0} [00:10:18.680] msec_str = "P\001\000\000\000\000\000\000\006\000\000\000\000\000\000\000\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:10:18.680] dest = DestRemote [00:10:18.680] was_logged = [00:10:18.680] oldcontext = 0x833e5e000 [00:10:18.680] parsetree_list = 0x837fea1a8 [00:10:18.680] use_implicit_block = false [00:10:18.680] parsetree_item = 0x837fea1c0 [00:10:18.680] save_log_statement_stats = [00:10:18.680] #11 0x00000000008d43a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:10:18.680] query_string = 0x833e52100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;" [00:10:18.680] input_message = {data = 0x833e52100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", len = 133, maxlen = 1024, cursor = 133} [00:10:18.680] firstchar = [00:10:18.680] local_sigjmp_buf = {{_sjb = {9255024, 34913711840, 34913711800, 34913712400, 11914584, 11861056, 8192, 8388608, 72057628951577471, 0, 0, 34359738369}}} [00:10:18.680] send_ready_for_query = false [00:10:18.680] idle_in_transaction_timeout_enabled = false [00:10:18.680] idle_session_timeout_enabled = false [00:10:18.680] #12 0x000000000083303a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:10:18.680] No locals. [00:10:18.680] #13 0x00000000008312c0 in BackendStartup (client_sock=0x821050338) at ../src/backend/postmaster/postmaster.c:4117 [00:10:18.680] bn = 0x833e5e238 [00:10:18.680] cac = CAC_OK [00:10:18.680] pid = [00:10:18.680] __error = [00:10:18.680] __error = [00:10:18.680] __error = [00:10:18.680] save_errno = [00:10:18.680] __error = [00:10:18.680] #14 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:10:18.680] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X<\276*\000\000\000\000\001\000\000\000\000\000\000\000\320\356\264", '\000' , "\300Ƶ\000\000\000\000\000\v\000\000\000\000\000\000\000\260\003\005!\b\000\000\000\330\305\356)\b\000\000\000\320\356\264\000\000\000\000\000\016F\357)\b", '\000' , "\360\003\005!\b\000\000\000\264Â\000\000\000\000"}, salen = 16}} [00:10:18.680] i = 0 [00:10:18.680] now = [00:10:18.680] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 553974544, events = 8, fd = 566846472, user_data = 0x21}, {pos = 553974528, events = 8, fd = -1391613292, user_data = 0x821c8f008}, {pos = 566817800, events = 8, fd = 566818824, user_data = 0x821c8fc08}, {pos = 566833160, events = 8, fd = 566834184, user_data = 0x821c93808}, {pos = 566836232, events = 8, fd = 566837256, user_data = 0x821c94408}, {pos = 566839304, events = 8, fd = 566840328, user_data = 0x821c95008}, {pos = 566842376, events = 8, fd = 566843400, user_data = 0x821c95c08}, {pos = 566845448, events = 8, fd = 566846472, user_data = 0x832e09be0}, {pos = 160, events = 0, fd = -1, user_data = 0x82abff2e0}, {pos = 553974384, events = 8, fd = 716882345, user_data = 0x0}, {pos = 4096, events = 0, fd = 1540299503, user_data = 0x82abff7e8}, {pos = 853580768, events = 8, fd = 160, user_data = 0x0}, {pos = 837116048, events = 8, fd = 553974592, user_data = 0x82ab8a92c}, {pos = 4096, events = 0, fd = 715307364, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 566872632, user_data = 0x800000001}, {pos = 566846472, events = 8, fd = 715221208, user_data = 0x82104fbc8}, {pos = 553974128, events = 8, fd = 33, user_data = 0x82aa27c64}, {pos = 566846472, events = 8, fd = 566872632, user_data = 0x0}, {pos = 2625, events = 0, fd = 553974704, user_data = 0xe36ad0da645}, {pos = 715307364, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 566872632, events = 8, fd = 1, user_data = 0x821c96408}, {pos = 870588416, events = 8, fd = 1, user_data = 0x833e42194}, {pos = 0, events = 0, fd = 553974656, user_data = 0x829ef3c0c}, {pos = 1, events = 0, fd = 870588416, user_data = 0x82104fbb0}, {pos = 703540916, events = 8, fd = 717033824, user_data = 0x82abd1160 }, {pos = 715403456, events = 8, fd = 566846472, user_data = 0x82104fc90}, {pos = -1391614932, events = 3638, fd = 837116048, user_data = 0x800000001}, {pos = -1391615314, events = 3638, fd = 12240, user_data = 0x82104fbb8}, {pos = 553974928, events = 8, fd = 871245800, user_data = 0x821050200}, {pos = -1391534448, events = 3638, fd = 566846472, user_data = 0x82104037f}, {pos = 716690844, events = 8, fd = 553975232, user_data = 0xe3600000000}, {pos = 566846472, events = 8, fd = 12240, user_data = 0x82aa07000}, {pos = 1964368, events = 0, fd = 717033824, user_data = 0x82aa27c64}, {pos = 15616, events = 0, fd = 553976112, user_data = 0x82104fd00}, {pos = 715964814, events = 8, fd = 717072440, user_data = 0x82104fcc4}, {pos = 870983130, events = 8, fd = 553976112, user_data = 0x82104fd00}, {pos = 716056069, events = 8, fd = 553974978, user_data = 0x821050130}, {pos = 553976112, events = 8, fd = 0, user_data = 0x458a8ddb5bcf1aef}, {pos = 553976112, events = 8, fd = 870983128, user_data = 0x821050200}, {pos = 717072440, events = 8, fd = 0, user_data = 0x821050170}, {pos = 716056333, events = 8, fd = 0, user_data = 0x0}, {pos = 553976480, events = 8, fd = 870983128, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1391586295, user_data = 0x82104fe48}, {pos = 715291748, events = 8, fd = 2503, user_data = 0xe36ad0e1409}, {pos = 553975400, events = 8, fd = 715291748, user_data = 0xac6}, {pos = 715264288, events = 8, fd = 553975272, user_data = 0x821c96408}, {pos = 553975400, events = 8, fd = 715264288, user_data = 0x82104fe50}, {pos = -1391606683, events = 3638, fd = 0, user_data = 0x800000000}, {pos = 553975360, events = 8, fd = 715224400, user_data = 0x0}, {pos = 0, events = 0, fd = 553975328, user_data = 0x10}, {pos = 0, events = 0, fd = 553975512, user_data = 0x821c9b088}, {pos = -1391586295, events = 3638, fd = 553975576, user_data = 0x82aa27c64}, {pos = 2924, events = 0, fd = 715264952, user_data = 0x82104fe98}, {pos = 566846472, events = 8, fd = 553975576, user_data = 0x82aa213b8}, {pos = 553975552, events = 8, fd = -1391606683, user_data = 0x821c9c038}, {pos = 1, events = 8, fd = 566846472, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x210500a8}, {pos = 2565664, events = 0, fd = 553976080, user_data = 0x821050110}, {pos = 553976008, events = 8, fd = 31, user_data = 0x0}, {pos = 553975720, events = 8, fd = 566867848, user_data = 0x821050178}, {pos = 553975696, events = 8, fd = -1391587933, user_data = 0x821c9c038}, {pos = 2691645, events = 0, fd = 448139, user_data = 0x87c96e577}} [00:10:18.680] last_touch_time = 1710547695 [00:10:18.680] last_lockfile_recheck_time = 1710547695 [00:10:18.680] nevents = 1 [00:10:18.680] #15 0x000000000082e5b6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821050930) at ../src/backend/postmaster/postmaster.c:1478 [00:10:18.680] userDoption = [00:10:18.680] listen_addr_saved = false [00:10:18.680] output_config_variable = [00:10:18.680] opt = [00:10:18.680] status = [00:10:18.680] #16 0x000000000076b7f5 in main (argc=8, argv=0x821050930) at ../src/backend/main/main.c:197 [00:10:18.680] do_check_root = [00:10:18.688] [00:10:18.688] [00:10:18.688] [00:10:18.748] dumping /tmp/cores/postgres.18961.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:10:18.874] [New LWP 100111] [00:10:18.951] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN'. [00:10:18.951] Program terminated with signal SIGSEGV, Segmentation fault. [00:10:18.951] Address not mapped to object. [00:10:18.951] #0 equal (a=0x377380d8, b=b@entry=0x8376df678) at ../src/backend/nodes/equalfuncs.c:239 [00:10:18.951] 239 if (nodeTag(a) != nodeTag(b)) [00:10:19.518] [00:10:19.518] Thread 1 (LWP 100111): [00:10:19.518] #0 equal (a=0x377380d8, b=b@entry=0x8376df678) at ../src/backend/nodes/equalfuncs.c:239 [00:10:19.518] retval = [00:10:19.518] #1 0x000000000076ef32 in list_member (list=0x837738148, datum=datum@entry=0x8376df678) at ../src/backend/nodes/list.c:670 [00:10:19.518] cell__state = {l = 0x837738148, i = 0} [00:10:19.518] cell = 0x0 [00:10:19.518] cell__state = [00:10:19.518] #2 0x00000000007e2915 in add_new_column_to_pathtarget (target=0x837738088, expr=) at ../src/backend/optimizer/util/tlist.c:743 [00:10:19.518] No locals. [00:10:19.518] #3 add_new_columns_to_pathtarget (target=target@entry=0x837738088, exprs=0x8377381e8) at ../src/backend/optimizer/util/tlist.c:760 [00:10:19.518] expr = [00:10:19.518] lc__state = {l = 0x8377381e8, i = 0} [00:10:19.518] lc = 0xfffffe3b [00:10:19.518] #4 0x00000000007b2309 in make_group_input_target (root=0x8376df038, final_target=0x837853fa8) at ../src/backend/optimizer/plan/planner.c:5472 [00:10:19.518] parse = 0x842f70de0 [00:10:19.518] input_target = 0x837738088 [00:10:19.518] non_group_cols = 0x837738198 [00:10:19.518] i = [00:10:19.518] lc = [00:10:19.518] non_group_vars = 0x8377381e8 [00:10:19.518] #5 grouping_planner (root=root@entry=0x8376df038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:10:19.518] qp_extra = {activeWindows = 0x0, gset_data = 0x8376df8a8} [00:10:19.518] activeWindows = 0x0 [00:10:19.518] sort_input_target_parallel_safe = false [00:10:19.518] grouping_target = 0x837853fa8 [00:10:19.518] scanjoin_target = [00:10:19.518] sort_input_targets = [00:10:19.518] wflists = 0x0 [00:10:19.518] gset_data = 0x8376df8a8 [00:10:19.518] have_grouping = false [00:10:19.518] sort_input_targets_contain_srfs = [00:10:19.518] sort_input_target = 0x837853fa8 [00:10:19.518] grouping_target_parallel_safe = false [00:10:19.518] scanjoin_target_parallel_safe = [00:10:19.518] grouping_targets = [00:10:19.518] scanjoin_targets = [00:10:19.518] grouping_targets_contain_srfs = [00:10:19.518] scanjoin_targets_contain_srfs = [00:10:19.518] scanjoin_target_same_exprs = [00:10:19.518] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 34916873456} [00:10:19.518] parse = 0x842f70de0 [00:10:19.518] offset_est = [00:10:19.518] count_est = [00:10:19.518] limit_tuples = -1 [00:10:19.518] have_postponed_srfs = false [00:10:19.518] current_rel = 0x837718dd8 [00:10:19.518] final_target = 0x837853fa8 [00:10:19.518] final_targets_contain_srfs = [00:10:19.518] final_targets = [00:10:19.518] final_rel = [00:10:19.518] lc = [00:10:19.518] final_target_parallel_safe = [00:10:19.518] #6 0x00000000007b0214 in subquery_planner (glob=glob@entry=0x837718998, parse=parse@entry=0x842f70de0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:10:19.518] root = 0x8376df038 [00:10:19.518] hasOuterJoins = false [00:10:19.518] hasResultRTEs = false [00:10:19.518] l = [00:10:19.518] newWithCheckOptions = [00:10:19.518] newHaving = 0x0 [00:10:19.518] final_rel = [00:10:19.518] #7 0x00000000007aed38 in standard_planner (parse=0x842f70de0, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [00:10:19.518] glob = 0x837718998 [00:10:19.518] tuple_fraction = 0 [00:10:19.518] root = [00:10:19.518] final_rel = [00:10:19.518] best_path = [00:10:19.518] top_plan = [00:10:19.518] lp = [00:10:19.518] lr = [00:10:19.518] result = [00:10:19.518] #8 0x00000000007aec0c in planner (parse=0x377380d8, parse@entry=0x842f70de0, query_string=0x8376df678 "\006", query_string@entry=0x837683100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=557134896, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [00:10:19.518] result = [00:10:19.518] #9 0x00000000008d2255 in pg_plan_query (querytree=querytree@entry=0x842f70de0, query_string=query_string@entry=0x837683100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [00:10:19.518] plan = [00:10:19.518] #10 0x0000000000685da9 in standard_ExplainOneQuery (query=0x842f70de0, cursorOptions=557134896, cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x837691748, queryString=0x8376df678 "\006", params=0xfffffe3b, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:441 [00:10:19.518] planduration = {ticks = 7790944} [00:10:19.518] bufusage_start = {shared_blks_hit = 1, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 34916874208, local_blks_read = 10587121, local_blks_dirtied = 70368744194107, local_blks_written = 0, temp_blks_read = 34916874240, temp_blks_written = 5658122, shared_blk_read_time = {ticks = 70368744194107}, shared_blk_write_time = {ticks = 35483225568}, local_blk_read_time = {ticks = 34916874256}, local_blk_write_time = {ticks = 6205849}, temp_blk_read_time = {ticks = 34916874432}, temp_blk_write_time = {ticks = 8915925}} [00:10:19.518] bufusage = {shared_blks_hit = 172, shared_blks_read = 510332841, shared_blks_dirtied = 34916874368, shared_blks_written = 35483224393, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = -3231234170121539880, local_blks_written = 34916874396, temp_blks_read = -1, temp_blks_written = 10800259, shared_blk_read_time = {ticks = 35483228304}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35483225568}, local_blk_write_time = {ticks = 35483225568}, temp_blk_read_time = {ticks = 34916874400}, temp_blk_write_time = {ticks = 10835824}} [00:10:19.518] mem_counters = {nblocks = 34916874176, freechunks = 9140805, totalspace = 34916874176, freespace = 35485241352} [00:10:19.518] planner_ctx = 0x0 [00:10:19.518] saved_ctx = [00:10:19.518] planstart = {ticks = -172510332841} [00:10:19.518] plan = [00:10:19.518] #11 0x000000000068577c in ExplainOneQuery (query=0x377380d8, cursorOptions=2048, into=0x0, es=0x837691748, queryString=0x3 , params=0x837738000, queryEnv=) at ../src/backend/commands/explain.c:397 [00:10:19.518] No locals. [00:10:19.518] #12 ExplainQuery (pstate=pstate@entry=0x837691638, stmt=stmt@entry=0x842f70db0, params=0x837738000, params@entry=0x0, dest=0x8376915a8) at ../src/backend/commands/explain.c:293 [00:10:19.518] l__state = {l = , i = 0} [00:10:19.518] l = 0x83771f4b0 [00:10:19.518] es = 0x837691748 [00:10:19.518] jstate = [00:10:19.518] timing_set = false [00:10:19.518] summary_set = false [00:10:19.518] lc = [00:10:19.518] query = [00:10:19.518] rewritten = 0x83771f498 [00:10:19.518] tstate = [00:10:19.518] #13 0x00000000008d935f in standard_ProcessUtility (pstmt=0x837836c28, queryString=0x837683100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x821353430, queryEnv=0x0, dest=0x8376915a8, qc=0x821353a78) at ../src/backend/tcop/utility.c:863 [00:10:19.518] isAtomicContext = true [00:10:19.518] parsetree = 0x842f70db0 [00:10:19.518] readonly_flags = [00:10:19.518] pstate = 0x837691638 [00:10:19.518] isTopLevel = [00:10:19.518] #14 0x00000000008d8c8d in ProcessUtility (pstmt=0x377380d8, pstmt@entry=0x837836c28, queryString=0x8376df678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x837738000, dest=0x8376915a8, qc=0x821353a78) at ../src/backend/tcop/utility.c:523 [00:10:19.518] No locals. [00:10:19.518] #15 0x00000000008d87b3 in PortalRunUtility (portal=portal@entry=0x837758100, pstmt=0x837836c28, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x8376915a8, qc=qc@entry=0x821353a78) at ../src/backend/tcop/pquery.c:1158 [00:10:19.518] No locals. [00:10:19.518] #16 0x00000000008d79aa in FillPortalStore (portal=portal@entry=0x837758100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [00:10:19.518] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:10:19.518] treceiver = 0x8376915a8 [00:10:19.518] #17 0x00000000008d76b0 in PortalRun (portal=portal@entry=0x837758100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x837836d88, altdest=altdest@entry=0x837836d88, qc=0x821353bb0) at ../src/backend/tcop/pquery.c:763 [00:10:19.518] _local_sigjmp_buf = {{_sjb = {9270863, 35290236312, 34916874920, 34916875152, 34916874928, 11905848, 11873632, 35290185984, 4852089727, 35290194176, 3554698, 34359738368}}} [00:10:19.518] _save_exception_stack = 0x821353c80 [00:10:19.518] _save_context_stack = 0x0 [00:10:19.518] _do_rethrow = false [00:10:19.518] saveTopTransactionResourceOwner = 0x837764598 [00:10:19.518] saveTopTransactionContext = 0x83768f000 [00:10:19.518] saveActivePortal = 0x0 [00:10:19.518] saveResourceOwner = 0x837764598 [00:10:19.518] savePortalContext = 0x0 [00:10:19.518] saveMemoryContext = 0x83768f000 [00:10:19.518] result = [00:10:19.518] nprocessed = [00:10:19.518] #18 0x00000000008d65bb in exec_simple_query (query_string=query_string@entry=0x837683100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;") at ../src/backend/tcop/postgres.c:1274 [00:10:19.518] cmdtaglen = [00:10:19.518] snapshot_set = [00:10:19.518] per_parsetree_context = 0x0 [00:10:19.518] plantree_list = [00:10:19.518] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:10:19.518] parsetree = 0x83774ce60 [00:10:19.518] commandTag = CMDTAG_EXPLAIN [00:10:19.518] cmdtagname = [00:10:19.518] querytree_list = [00:10:19.518] portal = 0x837758100 [00:10:19.518] format = 0 [00:10:19.518] receiver = 0x837836d88 [00:10:19.518] parsetree_item__state = {l = 0x83774d9b0, i = 0} [00:10:19.518] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [00:10:19.518] dest = DestRemote [00:10:19.518] was_logged = [00:10:19.518] oldcontext = 0x83768f000 [00:10:19.518] parsetree_list = 0x83774d9b0 [00:10:19.518] use_implicit_block = false [00:10:19.518] parsetree_item = 0x83774d9c8 [00:10:19.518] save_log_statement_stats = [00:10:19.518] #19 0x00000000008d43a4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [00:10:19.518] query_string = 0x837683100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [00:10:19.518] input_message = {data = 0x837683100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", len = 113, maxlen = 1024, cursor = 113} [00:10:19.518] firstchar = [00:10:19.518] local_sigjmp_buf = {{_sjb = {9255024, 34916875392, 34916875352, 34916875952, 11914584, 11861056, 8192, 8388608, 72057628954788735, 0, 0, 34359738369}}} [00:10:19.518] send_ready_for_query = false [00:10:19.518] idle_in_transaction_timeout_enabled = false [00:10:19.518] idle_session_timeout_enabled = false [00:10:19.518] #20 0x000000000083303a in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:10:19.518] No locals. [00:10:19.518] #21 0x00000000008312c0 in BackendStartup (client_sock=0x8213548d8) at ../src/backend/postmaster/postmaster.c:4117 [00:10:19.518] bn = 0x83768f0d8 [00:10:19.518] cac = CAC_OK [00:10:19.518] pid = [00:10:19.518] __error = [00:10:19.518] __error = [00:10:19.518] __error = [00:10:19.518] save_errno = [00:10:19.518] __error = [00:10:19.518] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:10:19.518] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "X\254\331+\000\000\000\000\001\000\000\000\000\000\000\000\320\356\264", '\000' , "\300Ƶ\000\000\000\000\000\v\000\000\000\000\000\000\000PI5!\b\000\000\000\330\3455+\b\000\000\000\320\356\264\000\000\000\000\000\016f6+\b", '\000' , "\220I5!\b\000\000\000\264Â\000\000\000\000"}, salen = 16}} [00:10:19.518] i = 0 [00:10:19.518] now = [00:10:19.518] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 733867108, events = 8, fd = 557137696, user_data = 0x8213540b0}, {pos = 563663880, events = 8, fd = 32, user_data = 0x8213540a0}, {pos = 1950743188, events = 15405, fd = 563634184, user_data = 0x821986408}, {pos = 563636232, events = 8, fd = 563637256, user_data = 0x82198a008}, {pos = 563651592, events = 8, fd = 563652616, user_data = 0x82198ac08}, {pos = 563654664, events = 8, fd = 563655688, user_data = 0x82198b808}, {pos = 563657736, events = 8, fd = 563658760, user_data = 0x82198c408}, {pos = 563660808, events = 8, fd = 563661832, user_data = 0x82198d008}, {pos = 563663880, events = 8, fd = -1, user_data = 0x82bdb62e0}, {pos = 557137936, events = 8, fd = 735457705, user_data = 0x0}, {pos = 4096, events = 0, fd = 1607282392, user_data = 0x82bdb67e8}, {pos = 918592480, events = 8, fd = 160, user_data = 0x0}, {pos = 898044048, events = 8, fd = 557138144, user_data = 0x82bd4192c}, {pos = 4096, events = 0, fd = 733882724, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 563690040, user_data = 0x800000001}, {pos = 563663880, events = 8, fd = 733796568, user_data = 0x821354168}, {pos = 557137696, events = 8, fd = 32, user_data = 0x82bbdec64}, {pos = 563663880, events = 8, fd = 563690040, user_data = 0x0}, {pos = 2625, events = 0, fd = 557138256, user_data = 0x3c2d7445f645}, {pos = 733882724, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 563690040, events = 8, fd = 1, user_data = 0x82198d408}, {pos = 929509376, events = 8, fd = 1, user_data = 0x837673194}, {pos = 0, events = 0, fd = 557138208, user_data = 0x82b365c0c}, {pos = 1, events = 0, fd = 929509376, user_data = 0x821354150}, {pos = 724979380, events = 8, fd = 735609184, user_data = 0x82bd88160 }, {pos = 733978816, events = 8, fd = 563663880, user_data = 0x821354230}, {pos = 1950741548, events = 15405, fd = 898044048, user_data = 0x800000001}, {pos = 1950741166, events = 15405, fd = 12240, user_data = 0x821354158}, {pos = 557138480, events = 8, fd = 930187240, user_data = 0x8213547a0}, {pos = 1950822032, events = 15405, fd = 563663880, user_data = 0x82135037f}, {pos = 735266204, events = 8, fd = 563634184, user_data = 0x0}, {pos = 563663880, events = 8, fd = 12240, user_data = 0x82bbbe000}, {pos = 1964368, events = 0, fd = 735609184, user_data = 0x82bbdec64}, {pos = 15616, events = 0, fd = 557139664, user_data = 0x8213542a0}, {pos = 734540174, events = 8, fd = 735647800, user_data = 0x821354264}, {pos = 929924570, events = 8, fd = 557139664, user_data = 0x8213542a0}, {pos = 734631429, events = 8, fd = 557138530, user_data = 0x8213546d0}, {pos = 557139664, events = 8, fd = 0, user_data = 0xd32859a45fcd2ed8}, {pos = 557139664, events = 8, fd = 929924568, user_data = 0x8213547a0}, {pos = 735647800, events = 8, fd = 0, user_data = 0x821354710}, {pos = 734631693, events = 8, fd = 0, user_data = 0x0}, {pos = 557140032, events = 8, fd = 929924568, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1950770185, events = 15405, fd = 557138936, user_data = 0x82bbdec64}, {pos = 2503, events = 0, fd = 1950770185, user_data = 0x821354418}, {pos = 733867108, events = 8, fd = 2758, user_data = 0x82bbd8120}, {pos = 557138840, events = 8, fd = 563663880, user_data = 0x821354418}, {pos = 733839648, events = 8, fd = 557138944, user_data = 0x3c2d74461465}, {pos = 0, events = 0, fd = 0, user_data = 0x82bdaa0f0}, {pos = 733799760, events = 8, fd = 0, user_data = 0x0}, {pos = 735676848, events = 8, fd = 16, user_data = 0x0}, {pos = 557139080, events = 8, fd = 563683464, user_data = 0x3c2d74466409}, {pos = 557139144, events = 8, fd = 733867108, user_data = 0xb6c}, {pos = 733840312, events = 8, fd = 557139016, user_data = 0x82198d408}, {pos = 557139144, events = 8, fd = 733840312, user_data = 0x8213544b0}, {pos = 1950749797, events = 15405, fd = 563687480, user_data = 0x800000001}, {pos = 563663880, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 557139528, user_data = 0x272620}, {pos = 557139632, events = 8, fd = 557139632, user_data = 0x821354668}, {pos = 30, events = 0, fd = 733803744, user_data = 0x821354558}, {pos = 563683912, events = 8, fd = 557139736, user_data = 0x821354540}, {pos = 1950768547, events = 15405, fd = 563687480, user_data = 0x29123d}} [00:10:19.518] last_touch_time = 1710547696 [00:10:19.518] last_lockfile_recheck_time = 1710547696 [00:10:19.518] nevents = 1 [00:10:19.518] #23 0x000000000082e5b6 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821354ed0) at ../src/backend/postmaster/postmaster.c:1478 [00:10:19.518] userDoption = [00:10:19.518] listen_addr_saved = false [00:10:19.518] output_config_variable = [00:10:19.518] opt = [00:10:19.518] status = [00:10:19.518] #24 0x000000000076b7f5 in main (argc=8, argv=0x821354ed0) at ../src/backend/main/main.c:197 [00:10:19.518] do_check_root =