[15:56:37.933] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [15:56:38.266] dumping /tmp/cores/postgres.8518.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:56:38.387] [New LWP 101819] [15:56:38.465] Core was generated by `postgres: postgres regression [local] SELECT'. [15:56:38.465] Program terminated with signal SIGSEGV, Segmentation fault. [15:56:38.465] Address not mapped to object. [15:56:38.465] #0 equal (a=0x41217238, b=b@entry=0x841213b28) at ../src/backend/nodes/equalfuncs.c:239 [15:56:38.465] 239 if (nodeTag(a) != nodeTag(b)) [15:56:38.494] [15:56:38.494] Thread 1 (LWP 101819): [15:56:38.494] #0 equal (a=0x41217238, b=b@entry=0x841213b28) at ../src/backend/nodes/equalfuncs.c:239 [15:56:38.494] retval = [15:56:38.494] #1 0x000000000076ea82 in list_member (list=0x8412172a8, datum=datum@entry=0x841213b28) at ../src/backend/nodes/list.c:670 [15:56:38.494] cell__state = {l = 0x8412172a8, i = 0} [15:56:38.494] cell = 0x0 [15:56:38.494] cell__state = [15:56:38.494] #2 0x00000000007e2425 in add_new_column_to_pathtarget (target=0x8412171c8, expr=) at ../src/backend/optimizer/util/tlist.c:743 [15:56:38.494] No locals. [15:56:38.494] #3 add_new_columns_to_pathtarget (target=target@entry=0x8412171c8, exprs=0x8412173d8) at ../src/backend/optimizer/util/tlist.c:760 [15:56:38.494] expr = [15:56:38.494] lc__state = {l = 0x8412173d8, i = 0} [15:56:38.494] lc = 0xfffffe3b [15:56:38.494] #4 0x00000000007b1e59 in make_group_input_target (root=0x835b6e2e8, final_target=0x841217068) at ../src/backend/optimizer/plan/planner.c:5472 [15:56:38.494] parse = 0x8411f7310 [15:56:38.494] input_target = 0x8412171c8 [15:56:38.494] non_group_cols = 0x841217388 [15:56:38.494] i = [15:56:38.494] lc = [15:56:38.494] non_group_vars = 0x8412173d8 [15:56:38.494] #5 grouping_planner (root=root@entry=0x835b6e2e8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [15:56:38.494] qp_extra = {activeWindows = 0x0, gset_data = 0x841214f78} [15:56:38.494] activeWindows = 0x0 [15:56:38.494] sort_input_target_parallel_safe = false [15:56:38.494] grouping_target = 0x841217068 [15:56:38.494] scanjoin_target = [15:56:38.494] sort_input_targets = [15:56:38.494] wflists = 0x0 [15:56:38.494] gset_data = 0x841214f78 [15:56:38.494] have_grouping = false [15:56:38.494] sort_input_targets_contain_srfs = [15:56:38.494] sort_input_target = 0x841217068 [15:56:38.494] grouping_target_parallel_safe = false [15:56:38.494] scanjoin_target_parallel_safe = [15:56:38.494] grouping_targets = [15:56:38.494] scanjoin_targets = [15:56:38.494] grouping_targets_contain_srfs = [15:56:38.494] scanjoin_targets_contain_srfs = [15:56:38.494] scanjoin_target_same_exprs = [15:56:38.494] extra = {limit_needed = 88, limit_tuples = 1.7515832060511692e-313, count_est = 72, offset_est = 34915443408} [15:56:38.494] parse = 0x8411f7310 [15:56:38.494] offset_est = [15:56:38.494] count_est = [15:56:38.494] limit_tuples = -1 [15:56:38.494] have_postponed_srfs = false [15:56:38.494] current_rel = 0x835b6e6f8 [15:56:38.494] final_target = 0x841217068 [15:56:38.494] final_targets_contain_srfs = [15:56:38.494] final_targets = [15:56:38.494] final_rel = [15:56:38.494] lc = [15:56:38.494] final_target_parallel_safe = [15:56:38.494] #6 0x00000000007afd64 in subquery_planner (glob=glob@entry=0x841211820, parse=parse@entry=0x8411f7310, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [15:56:38.494] root = 0x835b6e2e8 [15:56:38.494] hasOuterJoins = false [15:56:38.494] hasResultRTEs = false [15:56:38.494] l = [15:56:38.494] newWithCheckOptions = [15:56:38.494] newHaving = 0x0 [15:56:38.494] final_rel = [15:56:38.494] #7 0x00000000007ae888 in standard_planner (parse=0x8411f7310, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [15:56:38.494] glob = 0x841211820 [15:56:38.494] tuple_fraction = 0 [15:56:38.494] root = [15:56:38.494] final_rel = [15:56:38.494] best_path = [15:56:38.494] top_plan = [15:56:38.494] lp = [15:56:38.494] lr = [15:56:38.494] result = [15:56:38.494] #8 0x00000000007ae75c in planner (parse=0x41217238, parse@entry=0x8411f7310, query_string=0x841213b28 "\006", query_string@entry=0x835a8d100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=555704864, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [15:56:38.494] result = [15:56:38.494] #9 0x00000000008d1c45 in pg_plan_query (querytree=querytree@entry=0x8411f7310, query_string=query_string@entry=0x835a8d100 "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:903 [15:56:38.494] plan = [15:56:38.494] #10 0x00000000008d1d22 in pg_plan_queries (querytrees=0x8412117d0, query_string=query_string@entry=0x835a8d100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=555704864, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [15:56:38.494] query = 0x8411f7310 [15:56:38.494] stmt = [15:56:38.494] query_list__state = {l = 0x8412117d0, i = 0} [15:56:38.494] stmt_list = 0x0 [15:56:38.494] query_list = [15:56:38.494] #11 0x00000000008d5ebc in exec_simple_query (query_string=query_string@entry=0x835a8d100 "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:1192 [15:56:38.494] cmdtaglen = [15:56:38.494] snapshot_set = [15:56:38.494] per_parsetree_context = 0x0 [15:56:38.494] plantree_list = [15:56:38.494] qc = {commandTag = 336, nprocessed = 6} [15:56:38.494] parsetree = 0x835be9600 [15:56:38.494] commandTag = [15:56:38.494] cmdtagname = [15:56:38.494] querytree_list = 0x0 [15:56:38.494] portal = [15:56:38.494] format = [15:56:38.494] receiver = [15:56:38.494] parsetree_item__state = {l = 0x835b6ae38, i = 0} [15:56:38.494] 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" [15:56:38.494] dest = DestRemote [15:56:38.494] was_logged = [15:56:38.494] oldcontext = 0x835a99000 [15:56:38.494] parsetree_list = 0x835b6ae38 [15:56:38.494] use_implicit_block = false [15:56:38.494] parsetree_item = 0x835b6ae50 [15:56:38.494] save_log_statement_stats = [15:56:38.494] #12 0x00000000008d3d94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [15:56:38.494] query_string = 0x835a8d100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [15:56:38.494] input_message = {data = 0x835a8d100 "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} [15:56:38.494] firstchar = [15:56:38.494] local_sigjmp_buf = {{_sjb = {9253472, 34915444384, 34915444344, 34915444944, 11911512, 11858000, 8192, 8388608, 72057628953346943, 0, 0, 34359738369}}} [15:56:38.494] send_ready_for_query = false [15:56:38.494] idle_in_transaction_timeout_enabled = false [15:56:38.494] idle_session_timeout_enabled = false [15:56:38.494] #13 0x0000000000832a85 in BackendRun (port=port@entry=0x835b68000) at ../src/backend/postmaster/postmaster.c:4475 [15:56:38.494] No locals. [15:56:38.494] #14 0x0000000000830dbd in BackendStartup (port=0x835b68000) at ../src/backend/postmaster/postmaster.c:4151 [15:56:38.494] bn = 0x835a993f8 [15:56:38.494] pid = [15:56:38.494] __error = [15:56:38.494] __error = [15:56:38.494] __error = [15:56:38.494] save_errno = [15:56:38.494] __error = [15:56:38.494] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [15:56:38.494] port = 0x835b68000 [15:56:38.494] i = 0 [15:56:38.494] now = [15:56:38.494] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 571507720, events = 8, fd = 571508744, user_data = 0x822108c08}, {pos = 571510792, events = 8, fd = 571511816, user_data = 0x822109808}, {pos = 571513864, events = 8, fd = 571514888, user_data = 0x82210a408}, {pos = -1, events = 0, fd = 743703264, user_data = 0x8211f69c0}, {pos = 743362985, events = 8, fd = 0, user_data = 0x1000}, {pos = -1175523720, events = 1332161381, fd = 743704552, user_data = 0x834a09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x8340a8090}, {pos = 555707024, events = 8, fd = 743225644, user_data = 0x1000}, {pos = 741788004, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 571542072, events = 8, fd = 1, user_data = 0x82210a408}, {pos = 741701848, events = 8, fd = 555707160, user_data = 0x8211f68d0}, {pos = 32, events = 18, fd = 741772388, user_data = 0x82210a408}, {pos = 571542072, events = 8, fd = 0, user_data = 0xa41}, {pos = 555707136, events = 8, fd = -696629691, user_data = 0x82c36c964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822110a38}, {pos = 1, events = 0, fd = 571515912, user_data = 0x835a7d000}, {pos = 1, events = 0, fd = 900190612, user_data = 0x0}, {pos = 555707088, events = 8, fd = 752065548, user_data = 0x1}, {pos = 900190208, events = 8, fd = 555707136, user_data = 0x82cd38eb4}, {pos = 743514464, events = 8, fd = 743514464, user_data = 0x82c3840c0}, {pos = 571515912, events = 8, fd = 555707360, user_data = 0x3775d67a442c}, {pos = 873103504, events = 8, fd = 1, user_data = 0x3775d67a42ae}, {pos = 12240, events = 0, fd = 555707144, user_data = 0x8211f6be0}, {pos = 900868072, events = 8, fd = 555708752, user_data = 0x3775d67b7e90}, {pos = 571515912, events = 8, fd = 555680639, user_data = 0x82c4be59c}, {pos = 571486216, events = 8, fd = 0, user_data = 0x82210a408}, {pos = 12240, events = 0, fd = 741638144, user_data = 0x1df950}, {pos = 743514464, events = 8, fd = 741772388, user_data = 0x3d00}, {pos = 555708544, events = 8, fd = 555707472, user_data = 0x82c40d18e }, {pos = 743553080, events = 8, fd = 555707412, user_data = 0x835ae25da}, {pos = 555708544, events = 8, fd = 555707472, user_data = 0x82c423605}, {pos = 555707410, events = 8, fd = 555708544, user_data = 0x8211f7080}, {pos = 0, events = 16777216, fd = -1175523720, user_data = 0x8211f7080}, {pos = 900605400, events = 8, fd = 555708752, user_data = 0x82c51b838}, {pos = 0, events = 0, fd = 555708608, user_data = 0x82c42370d}, {pos = 0, events = 0, fd = 0, user_data = 0x8211f71f0}, {pos = 900605400, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3775d67ab409}, {pos = 555707816, events = 8, fd = 741772388, user_data = 0x9c7}, {pos = -696601591, events = 14197, fd = 555707848, user_data = 0x82c368c64}, {pos = 2758, events = 0, fd = 741744928, user_data = 0x8211f6d48}, {pos = 571515912, events = 8, fd = 555707848, user_data = 0x82c362120}, {pos = 555707824, events = 8, fd = -696621979, user_data = 0x0}, {pos = 0, events = 0, fd = 743653616, user_data = 0x82c358550}, {pos = 0, events = 0, fd = 0, user_data = 0x82c5229b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x8211f6e38}, {pos = 571535496, events = 8, fd = -696601591, user_data = 0x8211f6e78}, {pos = 741772388, events = 8, fd = 2924, user_data = 0x82c3623b8}, {pos = 555707896, events = 8, fd = 571515912, user_data = 0x8211f6e78}, {pos = 741745592, events = 8, fd = 555708000, user_data = 0x3775d67a6465}, {pos = 571539512, events = 8, fd = 1, user_data = 0x82210a408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 555708408, events = 0, fd = 2565592, user_data = 0x8211f7060}, {pos = 555708512, events = 8, fd = 555708440, user_data = 0x1e}, {pos = 741709024, events = 8, fd = 555708168, user_data = 0x82210f248}, {pos = 555708616, events = 8, fd = 555708144, user_data = 0x3775d67aada3}, {pos = 571539512, events = 8, fd = 2691550, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 571539512, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8211f71c8}, {pos = 571515912, events = 8, fd = 555708496, user_data = 0x2725d8}, {pos = 555708688, events = 8, fd = 555708688, user_data = 0x8211f70c8}, {pos = 32, events = 0, fd = 555708272, user_data = 0x3775d67aab83}} [15:56:38.494] last_touch_time = 1709999503 [15:56:38.494] last_lockfile_recheck_time = 1709999503 [15:56:38.494] nevents = 1 [15:56:38.494] #16 0x000000000082e0c3 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8211f7888) at ../src/backend/postmaster/postmaster.c:1468 [15:56:38.494] userDoption = [15:56:38.494] listen_addr_saved = false [15:56:38.494] output_config_variable = [15:56:38.494] opt = [15:56:38.494] status = [15:56:38.494] #17 0x000000000076b345 in main (argc=8, argv=0x8211f7888) at ../src/backend/main/main.c:197 [15:56:38.494] do_check_root = [15:56:38.501] [15:56:38.501] [15:56:38.501] [15:56:38.554] dumping /tmp/cores/postgres.9198.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:56:38.674] [New LWP 100186] [15:56:38.741] Core was generated by `postgres: old_node: postgres regression [local] SELECT'. [15:56:38.741] Program terminated with signal SIGSEGV, Segmentation fault. [15:56:38.741] Address not mapped to object. [15:56:38.741] #0 equal (a=0x46b41538, b=b@entry=0x846b3de28) at ../src/backend/nodes/equalfuncs.c:239 [15:56:38.741] 239 if (nodeTag(a) != nodeTag(b)) [15:56:38.763] [15:56:38.763] Thread 1 (LWP 100186): [15:56:38.763] #0 equal (a=0x46b41538, b=b@entry=0x846b3de28) at ../src/backend/nodes/equalfuncs.c:239 [15:56:38.763] retval = [15:56:38.763] #1 0x000000000076ea82 in list_member (list=0x846b415a8, datum=datum@entry=0x846b3de28) at ../src/backend/nodes/list.c:670 [15:56:38.763] cell__state = {l = 0x846b415a8, i = 0} [15:56:38.763] cell = 0x0 [15:56:38.763] cell__state = [15:56:38.763] #2 0x00000000007e2425 in add_new_column_to_pathtarget (target=0x846b414c8, expr=) at ../src/backend/optimizer/util/tlist.c:743 [15:56:38.763] No locals. [15:56:38.763] #3 add_new_columns_to_pathtarget (target=target@entry=0x846b414c8, exprs=0x846b416d8) at ../src/backend/optimizer/util/tlist.c:760 [15:56:38.763] expr = [15:56:38.763] lc__state = {l = 0x846b416d8, i = 0} [15:56:38.763] lc = 0xfffffe3b [15:56:38.763] #4 0x00000000007b1e59 in make_group_input_target (root=0x8357dec68, final_target=0x846b41368) at ../src/backend/optimizer/plan/planner.c:5472 [15:56:38.763] parse = 0x846b260d0 [15:56:38.763] input_target = 0x846b414c8 [15:56:38.763] non_group_cols = 0x846b41688 [15:56:38.763] i = [15:56:38.763] lc = [15:56:38.763] non_group_vars = 0x846b416d8 [15:56:38.763] #5 grouping_planner (root=root@entry=0x8357dec68, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [15:56:38.763] qp_extra = {activeWindows = 0x0, gset_data = 0x846b3f278} [15:56:38.763] activeWindows = 0x0 [15:56:38.763] sort_input_target_parallel_safe = false [15:56:38.763] grouping_target = 0x846b41368 [15:56:38.763] scanjoin_target = [15:56:38.763] sort_input_targets = [15:56:38.763] wflists = 0x0 [15:56:38.763] gset_data = 0x846b3f278 [15:56:38.763] have_grouping = false [15:56:38.763] sort_input_targets_contain_srfs = [15:56:38.763] sort_input_target = 0x846b41368 [15:56:38.763] grouping_target_parallel_safe = false [15:56:38.763] scanjoin_target_parallel_safe = [15:56:38.763] grouping_targets = [15:56:38.763] scanjoin_targets = [15:56:38.763] grouping_targets_contain_srfs = [15:56:38.763] scanjoin_targets_contain_srfs = [15:56:38.763] scanjoin_target_same_exprs = [15:56:38.763] extra = {limit_needed = 88, limit_tuples = 1.7562025253755467e-313, count_est = 72, offset_est = 34912157456} [15:56:38.763] parse = 0x846b260d0 [15:56:38.763] offset_est = [15:56:38.763] count_est = [15:56:38.763] limit_tuples = -1 [15:56:38.763] have_postponed_srfs = false [15:56:38.763] current_rel = 0x8357df078 [15:56:38.763] final_target = 0x846b41368 [15:56:38.763] final_targets_contain_srfs = [15:56:38.763] final_targets = [15:56:38.763] final_rel = [15:56:38.763] lc = [15:56:38.763] final_target_parallel_safe = [15:56:38.763] #6 0x00000000007afd64 in subquery_planner (glob=glob@entry=0x846b3bb20, parse=parse@entry=0x846b260d0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [15:56:38.763] root = 0x8357dec68 [15:56:38.763] hasOuterJoins = false [15:56:38.763] hasResultRTEs = false [15:56:38.763] l = [15:56:38.763] newWithCheckOptions = [15:56:38.763] newHaving = 0x0 [15:56:38.763] final_rel = [15:56:38.763] #7 0x00000000007ae888 in standard_planner (parse=0x846b260d0, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [15:56:38.763] glob = 0x846b3bb20 [15:56:38.763] tuple_fraction = 0 [15:56:38.763] root = [15:56:38.763] final_rel = [15:56:38.763] best_path = [15:56:38.763] top_plan = [15:56:38.763] lp = [15:56:38.763] lr = [15:56:38.763] result = [15:56:38.763] #8 0x00000000007ae75c in planner (parse=0x46b41538, parse@entry=0x846b260d0, query_string=0x846b3de28 "\006", query_string@entry=0x835703100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=552418912, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [15:56:38.763] result = [15:56:38.763] #9 0x00000000008d1c45 in pg_plan_query (querytree=querytree@entry=0x846b260d0, query_string=query_string@entry=0x835703100 "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:903 [15:56:38.763] plan = [15:56:38.763] #10 0x00000000008d1d22 in pg_plan_queries (querytrees=0x846b3bad0, query_string=query_string@entry=0x835703100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=552418912, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [15:56:38.763] query = 0x846b260d0 [15:56:38.763] stmt = [15:56:38.763] query_list__state = {l = 0x846b3bad0, i = 0} [15:56:38.763] stmt_list = 0x0 [15:56:38.763] query_list = [15:56:38.763] #11 0x00000000008d5ebc in exec_simple_query (query_string=query_string@entry=0x835703100 "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:1192 [15:56:38.763] cmdtaglen = [15:56:38.763] snapshot_set = [15:56:38.763] per_parsetree_context = 0x0 [15:56:38.763] plantree_list = [15:56:38.763] qc = {commandTag = 336, nprocessed = 6} [15:56:38.763] parsetree = 0x83585a600 [15:56:38.763] commandTag = [15:56:38.763] cmdtagname = [15:56:38.763] querytree_list = 0x0 [15:56:38.763] portal = [15:56:38.763] format = [15:56:38.763] receiver = [15:56:38.763] parsetree_item__state = {l = 0x8357db7b8, i = 0} [15:56:38.763] 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" [15:56:38.763] dest = DestRemote [15:56:38.763] was_logged = [15:56:38.763] oldcontext = 0x83570f000 [15:56:38.763] parsetree_list = 0x8357db7b8 [15:56:38.763] use_implicit_block = false [15:56:38.763] parsetree_item = 0x8357db7d0 [15:56:38.763] save_log_statement_stats = [15:56:38.763] #12 0x00000000008d3d94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [15:56:38.763] query_string = 0x835703100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [15:56:38.763] input_message = {data = 0x835703100 "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} [15:56:38.763] firstchar = [15:56:38.763] local_sigjmp_buf = {{_sjb = {9253472, 34912158432, 34912158392, 34912158992, 11911512, 11858000, 8192, 8388608, 72057628950070143, 0, 0, 34359738369}}} [15:56:38.763] send_ready_for_query = false [15:56:38.763] idle_in_transaction_timeout_enabled = false [15:56:38.763] idle_session_timeout_enabled = false [15:56:38.763] #13 0x0000000000832a85 in BackendRun (port=port@entry=0x8357b6000) at ../src/backend/postmaster/postmaster.c:4475 [15:56:38.763] No locals. [15:56:38.763] #14 0x0000000000830dbd in BackendStartup (port=0x8357b6000) at ../src/backend/postmaster/postmaster.c:4151 [15:56:38.763] bn = 0x83570f498 [15:56:38.763] pid = [15:56:38.763] __error = [15:56:38.763] __error = [15:56:38.763] __error = [15:56:38.763] save_errno = [15:56:38.763] __error = [15:56:38.763] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [15:56:38.763] port = 0x8357b6000 [15:56:38.763] i = 0 [15:56:38.763] now = [15:56:38.763] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 556315656, events = 8, fd = 556316680, user_data = 0x82128bc08}, {pos = 556318728, events = 8, fd = 556319752, user_data = 0x82128c808}, {pos = 556321800, events = 8, fd = 556322824, user_data = 0x82128d408}, {pos = 556343432, events = 8, fd = 552421400, user_data = 0x820ed4640}, {pos = 179342755, events = 1537, fd = 0, user_data = 0x27268e}, {pos = 115249317, events = 0, fd = -25761258, user_data = 0x821293038}, {pos = 1, events = 0, fd = 556323848, user_data = 0x829f914a8}, {pos = 552421656, events = 8, fd = 556323848, user_data = 0x20ed4630}, {pos = 704297316, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 556350008, events = 8, fd = 1, user_data = 0x82128d408}, {pos = 704211160, events = 8, fd = 552421208, user_data = 0x820ed4510}, {pos = 32, events = 18, fd = 704281700, user_data = 0x82128d408}, {pos = 556350008, events = 8, fd = 0, user_data = 0xa41}, {pos = 552421184, events = 8, fd = 179316293, user_data = 0x829fab964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821293a38}, {pos = 1, events = 0, fd = 556323848, user_data = 0x8356f3000}, {pos = 1, events = 0, fd = 896479636, user_data = 0x0}, {pos = 552421136, events = 8, fd = 687590412, user_data = 0x1}, {pos = 896479232, events = 8, fd = 552421184, user_data = 0x828fbbeb4}, {pos = 706023776, events = 8, fd = 706023776, user_data = 0x829fc30c0}, {pos = 556323848, events = 8, fd = 552421408, user_data = 0x6010ab0242c}, {pos = 556322824, events = 8, fd = 1, user_data = 0x6010ab022ae}, {pos = 12240, events = 0, fd = 552421192, user_data = 0x820ed4820}, {pos = 897259496, events = 8, fd = 552422800, user_data = 0x6010ab15e90}, {pos = 556323848, events = 8, fd = 552403839, user_data = 0x82a0fd4b2}, {pos = 556294152, events = 8, fd = 0, user_data = 0x82128d408}, {pos = 12240, events = 0, fd = 704147456, user_data = 0x1df950}, {pos = 706023776, events = 8, fd = 704281700, user_data = 0x3d00}, {pos = 552422592, events = 8, fd = 552421520, user_data = 0x82a04c18e }, {pos = 706062392, events = 8, fd = 552421460, user_data = 0x8357615da}, {pos = 552422592, events = 8, fd = 552421520, user_data = 0x82a062605}, {pos = 552421458, events = 8, fd = 552422592, user_data = 0x820ed4cc0}, {pos = 0, events = 16777216, fd = -86562437, user_data = 0x820ed4cc0}, {pos = 896931288, events = 8, fd = 552422800, user_data = 0x82a15a838}, {pos = 0, events = 0, fd = 552422656, user_data = 0x82a06270d}, {pos = 0, events = 0, fd = 0, user_data = 0x820ed4e30}, {pos = 896931288, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x6010ab09409}, {pos = 552421864, events = 8, fd = 704281700, user_data = 0x9c7}, {pos = 179344393, events = 1537, fd = 552421896, user_data = 0x829fa7c64}, {pos = 2758, events = 0, fd = 704254240, user_data = 0x820ed4988}, {pos = 556323848, events = 8, fd = 552421896, user_data = 0x829fa1120}, {pos = 552421872, events = 8, fd = 179324005, user_data = 0x0}, {pos = 0, events = 0, fd = 706162928, user_data = 0x829f97550}, {pos = 0, events = 0, fd = 0, user_data = 0x82a1619b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x820ed4a78}, {pos = 556343432, events = 8, fd = 179344393, user_data = 0x820ed4ab8}, {pos = 704281700, events = 8, fd = 2924, user_data = 0x829fa13b8}, {pos = 552421944, events = 8, fd = 556323848, user_data = 0x820ed4ab8}, {pos = 704254904, events = 8, fd = 552422048, user_data = 0x6010ab04465}, {pos = 556347448, events = 8, fd = 1, user_data = 0x82128d408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 552422456, events = 0, fd = 2565592, user_data = 0x820ed4ca0}, {pos = 552422560, events = 8, fd = 552422488, user_data = 0x1e}, {pos = 704218336, events = 8, fd = 552422216, user_data = 0x821292248}, {pos = 552422664, events = 8, fd = 552422192, user_data = 0x6010ab08da3}, {pos = 556347448, events = 8, fd = 2691550, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 556347448, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820ed4e08}, {pos = 556323848, events = 8, fd = 552422544, user_data = 0x2725d8}, {pos = 552422736, events = 8, fd = 552422736, user_data = 0x820ed4d08}, {pos = 32, events = 0, fd = 552422320, user_data = 0x6010ab08b83}} [15:56:38.763] last_touch_time = 1709999505 [15:56:38.763] last_lockfile_recheck_time = 1709999505 [15:56:38.763] nevents = 1 [15:56:38.763] #16 0x000000000082e0c3 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820ed54c8) at ../src/backend/postmaster/postmaster.c:1468 [15:56:38.763] userDoption = [15:56:38.763] listen_addr_saved = false [15:56:38.763] output_config_variable = [15:56:38.763] opt = [15:56:38.763] status = [15:56:38.763] #17 0x000000000076b345 in main (argc=4, argv=0x820ed54c8) at ../src/backend/main/main.c:197 [15:56:38.763] do_check_root = [15:56:38.771] [15:56:38.771] [15:56:38.771] [15:56:38.825] dumping /tmp/cores/postgres.9537.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:56:38.943] [New LWP 100155] [15:56:39.007] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [15:56:39.007] Program terminated with signal SIGSEGV, Segmentation fault. [15:56:39.007] Address not mapped to object. [15:56:39.007] #0 equal (a=0x35b3dcb0, b=b@entry=0x835aa7678) at ../src/backend/nodes/equalfuncs.c:239 [15:56:39.007] 239 if (nodeTag(a) != nodeTag(b)) [15:56:39.460] [15:56:39.460] Thread 1 (LWP 100155): [15:56:39.460] #0 equal (a=0x35b3dcb0, b=b@entry=0x835aa7678) at ../src/backend/nodes/equalfuncs.c:239 [15:56:39.460] retval = [15:56:39.460] #1 0x000000000076ea82 in list_member (list=0x835b3dd20, datum=datum@entry=0x835aa7678) at ../src/backend/nodes/list.c:670 [15:56:39.460] cell__state = {l = 0x835b3dd20, i = 0} [15:56:39.460] cell = 0x0 [15:56:39.460] cell__state = [15:56:39.460] #2 0x00000000007e2425 in add_new_column_to_pathtarget (target=0x835b3dc40, expr=) at ../src/backend/optimizer/util/tlist.c:743 [15:56:39.460] No locals. [15:56:39.460] #3 add_new_columns_to_pathtarget (target=target@entry=0x835b3dc40, exprs=0x835b3ddd8) at ../src/backend/optimizer/util/tlist.c:760 [15:56:39.460] expr = [15:56:39.460] lc__state = {l = 0x835b3ddd8, i = 0} [15:56:39.460] lc = 0xfffffe3b [15:56:39.460] #4 0x00000000007b1e59 in make_group_input_target (root=0x835aa7038, final_target=0x835b3db70) at ../src/backend/optimizer/plan/planner.c:5472 [15:56:39.460] parse = 0x8422a3c88 [15:56:39.460] input_target = 0x835b3dc40 [15:56:39.460] non_group_cols = 0x835b3dd88 [15:56:39.460] i = [15:56:39.460] lc = [15:56:39.460] non_group_vars = 0x835b3ddd8 [15:56:39.460] #5 grouping_planner (root=root@entry=0x835aa7038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [15:56:39.460] qp_extra = {activeWindows = 0x0, gset_data = 0x835aa7718} [15:56:39.460] activeWindows = 0x0 [15:56:39.460] sort_input_target_parallel_safe = false [15:56:39.460] grouping_target = 0x835b3db70 [15:56:39.460] scanjoin_target = [15:56:39.460] sort_input_targets = [15:56:39.460] wflists = 0x0 [15:56:39.460] gset_data = 0x835aa7718 [15:56:39.460] have_grouping = false [15:56:39.460] sort_input_targets_contain_srfs = [15:56:39.460] sort_input_target = 0x835b3db70 [15:56:39.460] grouping_target_parallel_safe = false [15:56:39.460] scanjoin_target_parallel_safe = [15:56:39.460] grouping_targets = [15:56:39.460] scanjoin_targets = [15:56:39.460] grouping_targets_contain_srfs = [15:56:39.460] scanjoin_targets_contain_srfs = [15:56:39.460] scanjoin_target_same_exprs = [15:56:39.460] extra = {limit_needed = 16, limit_tuples = 1.7420805078915804e-313, count_est = 0, offset_est = 34915442448} [15:56:39.460] parse = 0x8422a3c88 [15:56:39.460] offset_est = [15:56:39.460] count_est = [15:56:39.460] limit_tuples = -1 [15:56:39.460] have_postponed_srfs = false [15:56:39.460] current_rel = 0x835aa64c8 [15:56:39.460] final_target = 0x835b3db70 [15:56:39.460] final_targets_contain_srfs = [15:56:39.460] final_targets = [15:56:39.460] final_rel = [15:56:39.460] lc = [15:56:39.460] final_target_parallel_safe = [15:56:39.460] #6 0x00000000007afd64 in subquery_planner (glob=glob@entry=0x835b22ef8, parse=parse@entry=0x8422a3c88, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=1.752390192719208e-313) at ../src/backend/optimizer/plan/planner.c:1084 [15:56:39.460] root = 0x835aa7038 [15:56:39.460] hasOuterJoins = false [15:56:39.460] hasResultRTEs = false [15:56:39.460] l = [15:56:39.460] newWithCheckOptions = [15:56:39.460] newHaving = 0x0 [15:56:39.460] final_rel = [15:56:39.460] #7 0x00000000007ae888 in standard_planner (parse=0x8422a3c88, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [15:56:39.460] glob = 0x835b22ef8 [15:56:39.460] tuple_fraction = 0 [15:56:39.460] root = [15:56:39.460] final_rel = [15:56:39.460] best_path = [15:56:39.460] top_plan = [15:56:39.460] lp = [15:56:39.460] lr = [15:56:39.460] result = [15:56:39.460] #8 0x00000000007ae75c in planner (parse=0x35b3dcb0, parse@entry=0x8422a3c88, query_string=0x835aa7678 "\006", query_string@entry=0x835a8d100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=555703888, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [15:56:39.460] result = [15:56:39.460] #9 0x00000000008d1c45 in pg_plan_query (querytree=querytree@entry=0x8422a3c88, query_string=query_string@entry=0x835a8d100 "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:903 [15:56:39.460] plan = [15:56:39.460] #10 0x0000000000685803 in ExplainOneQuery (query=0x8422a3c88, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x835c28748, queryString=0x835a8d100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", params=0xfffffe3b, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:428 [15:56:39.460] bufusage = {shared_blks_hit = 163, shared_blks_read = 356372929, shared_blks_dirtied = 34915443360, shared_blks_written = 35469800784, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 35468932960, temp_blks_written = 10797587, shared_blk_read_time = {ticks = 35469804632}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35469802632}, local_blk_write_time = {ticks = 35469802632}, temp_blk_read_time = {ticks = 34915443392}, temp_blk_write_time = {ticks = 10833152}} [15:56:39.460] saved_ctx = 0x0 [15:56:39.460] planstart = {ticks = -163356372929} [15:56:39.460] planduration = {ticks = 7789744} [15:56:39.460] bufusage_start = {shared_blks_hit = 34915443375, shared_blks_read = 0, shared_blks_dirtied = 35469802904, shared_blks_written = 35469803560, local_blks_hit = 34915443200, local_blks_read = 10584417, local_blks_dirtied = 70368744214817, local_blks_written = 0, temp_blks_read = 34915443232, temp_blks_written = 5658010, shared_blk_read_time = {ticks = 70368744214817}, shared_blk_write_time = {ticks = 1}, local_blk_read_time = {ticks = 34915443248}, local_blk_write_time = {ticks = 6206329}, temp_blk_read_time = {ticks = 34915443424}, temp_blk_write_time = {ticks = 8914763}} [15:56:39.460] mem_counters = {nblocks = 34915443168, freechunks = 9139333, totalspace = 34915443168, freespace = 35468932960} [15:56:39.460] planner_ctx = [15:56:39.460] plan = [15:56:39.460] #11 0x0000000000685322 in ExplainQuery (pstate=pstate@entry=0x835c28638, stmt=stmt@entry=0x8422a3c58, params=0x835b3c000, params@entry=0x0, dest=0x835c285a8) at ../src/backend/commands/explain.c:293 [15:56:39.460] l__state = {l = , i = 0} [15:56:39.460] l = 0x835b22cb0 [15:56:39.460] es = 0x835c28748 [15:56:39.460] jstate = [15:56:39.460] timing_set = false [15:56:39.460] summary_set = false [15:56:39.460] lc = [15:56:39.460] query = [15:56:39.460] rewritten = 0x835b22c98 [15:56:39.460] tstate = [15:56:39.460] #12 0x00000000008d8d4f in standard_ProcessUtility (pstmt=0x8422a48d0, queryString=0x835a8d100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x8211f5e50, queryEnv=0x0, dest=0x835c285a8, qc=0x8211f6498) at ../src/backend/tcop/utility.c:863 [15:56:39.460] isAtomicContext = true [15:56:39.460] parsetree = 0x8422a3c58 [15:56:39.460] readonly_flags = [15:56:39.460] pstate = 0x835c28638 [15:56:39.460] isTopLevel = [15:56:39.460] #13 0x00000000008d867d in ProcessUtility (pstmt=0x35b3dcb0, pstmt@entry=0x8422a48d0, queryString=0x835aa7678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x835b3c000, dest=0x835c285a8, qc=0x8211f6498) at ../src/backend/tcop/utility.c:523 [15:56:39.460] No locals. [15:56:39.460] #14 0x00000000008d81a3 in PortalRunUtility (portal=portal@entry=0x835b62100, pstmt=0x8422a48d0, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x835c285a8, qc=qc@entry=0x8211f6498) at ../src/backend/tcop/pquery.c:1158 [15:56:39.460] No locals. [15:56:39.460] #15 0x00000000008d739a in FillPortalStore (portal=portal@entry=0x835b62100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [15:56:39.460] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:56:39.460] treceiver = 0x835c285a8 [15:56:39.460] #16 0x00000000008d70a0 in PortalRun (portal=portal@entry=0x835b62100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8422a4a30, altdest=altdest@entry=0x8422a4a30, qc=0x8211f65d0) at ../src/backend/tcop/pquery.c:763 [15:56:39.460] _local_sigjmp_buf = {{_sjb = {9269311, 35260935152, 34915443912, 34915444144, 34915443920, 11902776, 11870560, 35260866816, -6347183290304232577, 35260875008, 3553568, 34359738368}}} [15:56:39.460] _save_exception_stack = 0x8211f66a0 [15:56:39.460] _save_context_stack = 0x0 [15:56:39.460] _do_rethrow = false [15:56:39.460] saveTopTransactionResourceOwner = 0x835b72bf0 [15:56:39.460] saveTopTransactionContext = 0x835c4e000 [15:56:39.460] saveActivePortal = 0x0 [15:56:39.460] saveResourceOwner = 0x835b72bf0 [15:56:39.460] savePortalContext = 0x0 [15:56:39.460] saveMemoryContext = 0x835c4e000 [15:56:39.460] result = [15:56:39.460] nprocessed = [15:56:39.460] #17 0x00000000008d5fab in exec_simple_query (query_string=query_string@entry=0x835a8d100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1273 [15:56:39.460] cmdtaglen = [15:56:39.460] snapshot_set = [15:56:39.460] per_parsetree_context = 0x0 [15:56:39.460] plantree_list = [15:56:39.460] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:56:39.460] parsetree = 0x835b56c58 [15:56:39.460] commandTag = CMDTAG_EXPLAIN [15:56:39.460] cmdtagname = [15:56:39.460] querytree_list = [15:56:39.460] portal = 0x835b62100 [15:56:39.460] format = 0 [15:56:39.460] receiver = 0x8422a4a30 [15:56:39.460] parsetree_item__state = {l = 0x835b574e0, i = 0} [15:56:39.460] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [15:56:39.460] dest = DestRemote [15:56:39.460] was_logged = [15:56:39.460] oldcontext = 0x835c4e000 [15:56:39.460] parsetree_list = 0x835b574e0 [15:56:39.460] use_implicit_block = false [15:56:39.460] parsetree_item = 0x835b574f8 [15:56:39.460] save_log_statement_stats = [15:56:39.460] #18 0x00000000008d3d94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [15:56:39.460] query_string = 0x835a8d100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [15:56:39.460] input_message = {data = 0x835a8d100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [15:56:39.460] firstchar = [15:56:39.460] local_sigjmp_buf = {{_sjb = {9253472, 34915444384, 34915444344, 34915444944, 11911512, 11858000, 8192, 8388608, 72057628953346943, 0, 0, 34359738369}}} [15:56:39.460] send_ready_for_query = false [15:56:39.460] idle_in_transaction_timeout_enabled = false [15:56:39.460] idle_session_timeout_enabled = false [15:56:39.460] #19 0x0000000000832a85 in BackendRun (port=port@entry=0x835b68000) at ../src/backend/postmaster/postmaster.c:4475 [15:56:39.460] No locals. [15:56:39.460] #20 0x0000000000830dbd in BackendStartup (port=0x835b68000) at ../src/backend/postmaster/postmaster.c:4151 [15:56:39.460] bn = 0x835a99308 [15:56:39.460] pid = [15:56:39.460] __error = [15:56:39.460] __error = [15:56:39.460] __error = [15:56:39.460] save_errno = [15:56:39.460] __error = [15:56:39.460] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [15:56:39.460] port = 0x835b68000 [15:56:39.460] i = 0 [15:56:39.460] now = [15:56:39.460] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 571508744, user_data = 0x0}, {pos = 571510792, events = 8, fd = 571511816, user_data = 0x822109808}, {pos = 571513864, events = 8, fd = 571514888, user_data = 0x82210a408}, {pos = -1, events = 0, fd = 743703264, user_data = 0x8211f69c0}, {pos = 743362985, events = 8, fd = 0, user_data = 0x1000}, {pos = -1175523720, events = 1332161381, fd = 743704552, user_data = 0x834a09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x8340a8090}, {pos = 555707024, events = 8, fd = 743225644, user_data = 0x1000}, {pos = 741788004, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 571542072, events = 8, fd = 1, user_data = 0x82210a408}, {pos = 741701848, events = 8, fd = 555707160, user_data = 0x8211f68d0}, {pos = 32, events = 18, fd = 741772388, user_data = 0x82210a408}, {pos = 571542072, events = 8, fd = 0, user_data = 0xa41}, {pos = 555707136, events = 8, fd = -696629691, user_data = 0x82c36c964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822110a38}, {pos = 1, events = 0, fd = 571515912, user_data = 0x835a7d000}, {pos = 1, events = 0, fd = 900190612, user_data = 0x0}, {pos = 555707088, events = 8, fd = 752065548, user_data = 0x1}, {pos = 900190208, events = 8, fd = 555707136, user_data = 0x82cd38eb4}, {pos = 743514464, events = 8, fd = 743514464, user_data = 0x82c3840c0}, {pos = 571515912, events = 8, fd = 555707360, user_data = 0x3775d67a442c}, {pos = 873103504, events = 8, fd = 1, user_data = 0x3775d67a42ae}, {pos = 12240, events = 0, fd = 555707144, user_data = 0x8211f6be0}, {pos = 900868072, events = 8, fd = 555708752, user_data = 0x3775d67b7e90}, {pos = 571515912, events = 8, fd = 555680639, user_data = 0x82c4be59c}, {pos = 571486216, events = 8, fd = 0, user_data = 0x82210a408}, {pos = 12240, events = 0, fd = 741638144, user_data = 0x1df950}, {pos = 743514464, events = 8, fd = 741772388, user_data = 0x3d00}, {pos = 555708544, events = 8, fd = 555707472, user_data = 0x82c40d18e }, {pos = 743553080, events = 8, fd = 555707412, user_data = 0x835ae25da}, {pos = 555708544, events = 8, fd = 555707472, user_data = 0x82c423605}, {pos = 555707410, events = 8, fd = 555708544, user_data = 0x8211f7080}, {pos = 0, events = 16777216, fd = -1175523720, user_data = 0x8211f7080}, {pos = 900605400, events = 8, fd = 555708752, user_data = 0x82c51b838}, {pos = 0, events = 0, fd = 555708608, user_data = 0x82c42370d}, {pos = 0, events = 0, fd = 0, user_data = 0x8211f71f0}, {pos = 900605400, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3775d67ab409}, {pos = 555707816, events = 8, fd = 741772388, user_data = 0x9c7}, {pos = -696601591, events = 14197, fd = 555707848, user_data = 0x82c368c64}, {pos = 2758, events = 0, fd = 741744928, user_data = 0x8211f6d48}, {pos = 571515912, events = 8, fd = 555707848, user_data = 0x82c362120}, {pos = 555707824, events = 8, fd = -696621979, user_data = 0x0}, {pos = 0, events = 0, fd = 743653616, user_data = 0x82c358550}, {pos = 0, events = 0, fd = 0, user_data = 0x82c5229b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x8211f6e38}, {pos = 571535496, events = 8, fd = -696601591, user_data = 0x8211f6e78}, {pos = 741772388, events = 8, fd = 2924, user_data = 0x82c3623b8}, {pos = 555707896, events = 8, fd = 571515912, user_data = 0x8211f6e78}, {pos = 741745592, events = 8, fd = 555708000, user_data = 0x3775d67a6465}, {pos = 571539512, events = 8, fd = 1, user_data = 0x82210a408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 555708408, events = 0, fd = 2565592, user_data = 0x8211f7060}, {pos = 555708512, events = 8, fd = 555708440, user_data = 0x1e}, {pos = 741709024, events = 8, fd = 555708168, user_data = 0x82210f248}, {pos = 555708616, events = 8, fd = 555708144, user_data = 0x3775d67aada3}, {pos = 571539512, events = 8, fd = 2691550, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 571539512, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8211f71c8}, {pos = 571515912, events = 8, fd = 555708496, user_data = 0x2725d8}, {pos = 555708688, events = 8, fd = 555708688, user_data = 0x8211f70c8}, {pos = 32, events = 0, fd = 555708272, user_data = 0x3775d67aab83}} [15:56:39.460] last_touch_time = 1709999503 [15:56:39.460] last_lockfile_recheck_time = 1709999503 [15:56:39.460] nevents = 1 [15:56:39.460] #22 0x000000000082e0c3 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8211f7888) at ../src/backend/postmaster/postmaster.c:1468 [15:56:39.460] userDoption = [15:56:39.460] listen_addr_saved = false [15:56:39.460] output_config_variable = [15:56:39.460] opt = [15:56:39.460] status = [15:56:39.460] #23 0x000000000076b345 in main (argc=8, argv=0x8211f7888) at ../src/backend/main/main.c:197 [15:56:39.460] do_check_root = [15:56:39.470] [15:56:39.470] [15:56:39.470] [15:56:39.525] dumping /tmp/cores/postgres.15811.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [15:56:39.644] [New LWP 100103] [15:56:39.714] Core was generated by `postgres: primary: postgres regression [local] SELECT'. [15:56:39.714] Program terminated with signal SIGSEGV, Segmentation fault. [15:56:39.714] Address not mapped to object. [15:56:39.714] #0 equal (a=0x37c07968, b=b@entry=0x837c04258) at ../src/backend/nodes/equalfuncs.c:239 [15:56:39.714] 239 if (nodeTag(a) != nodeTag(b)) [15:56:39.763] [15:56:39.763] Thread 1 (LWP 100103): [15:56:39.763] #0 equal (a=0x37c07968, b=b@entry=0x837c04258) at ../src/backend/nodes/equalfuncs.c:239 [15:56:39.763] retval = [15:56:39.763] #1 0x000000000076ea82 in list_member (list=0x837c079d8, datum=datum@entry=0x837c04258) at ../src/backend/nodes/list.c:670 [15:56:39.763] cell__state = {l = 0x837c079d8, i = 0} [15:56:39.763] cell = 0x0 [15:56:39.763] cell__state = [15:56:39.763] #2 0x00000000007e2425 in add_new_column_to_pathtarget (target=0x837c078f8, expr=) at ../src/backend/optimizer/util/tlist.c:743 [15:56:39.763] No locals. [15:56:39.763] #3 add_new_columns_to_pathtarget (target=target@entry=0x837c078f8, exprs=0x837c07b08) at ../src/backend/optimizer/util/tlist.c:760 [15:56:39.763] expr = [15:56:39.763] lc__state = {l = 0x837c07b08, i = 0} [15:56:39.763] lc = 0xfffffe3b [15:56:39.763] #4 0x00000000007b1e59 in make_group_input_target (root=0x8356af9e0, final_target=0x837c07798) at ../src/backend/optimizer/plan/planner.c:5472 [15:56:39.763] parse = 0x837b250e0 [15:56:39.763] input_target = 0x837c078f8 [15:56:39.763] non_group_cols = 0x837c07ab8 [15:56:39.763] i = [15:56:39.763] lc = [15:56:39.763] non_group_vars = 0x837c07b08 [15:56:39.763] #5 grouping_planner (root=root@entry=0x8356af9e0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [15:56:39.763] qp_extra = {activeWindows = 0x0, gset_data = 0x837c056a8} [15:56:39.763] activeWindows = 0x0 [15:56:39.763] sort_input_target_parallel_safe = false [15:56:39.763] grouping_target = 0x837c07798 [15:56:39.763] scanjoin_target = [15:56:39.763] sort_input_targets = [15:56:39.763] wflists = 0x0 [15:56:39.763] gset_data = 0x837c056a8 [15:56:39.763] have_grouping = false [15:56:39.763] sort_input_targets_contain_srfs = [15:56:39.763] sort_input_target = 0x837c07798 [15:56:39.763] grouping_target_parallel_safe = false [15:56:39.763] scanjoin_target_parallel_safe = [15:56:39.763] grouping_targets = [15:56:39.763] scanjoin_targets = [15:56:39.763] grouping_targets_contain_srfs = [15:56:39.763] scanjoin_targets_contain_srfs = [15:56:39.763] scanjoin_target_same_exprs = [15:56:39.763] extra = {limit_needed = 136, limit_tuples = 1.743809078370827e-313, count_est = 72, offset_est = 34910320656} [15:56:39.763] parse = 0x837b250e0 [15:56:39.763] offset_est = [15:56:39.763] count_est = [15:56:39.763] limit_tuples = -1 [15:56:39.763] have_postponed_srfs = false [15:56:39.763] current_rel = 0x837be89c8 [15:56:39.763] final_target = 0x837c07798 [15:56:39.763] final_targets_contain_srfs = [15:56:39.763] final_targets = [15:56:39.763] final_rel = [15:56:39.763] lc = [15:56:39.763] final_target_parallel_safe = [15:56:39.763] #6 0x00000000007afd64 in subquery_planner (glob=glob@entry=0x837c01b40, parse=parse@entry=0x837b250e0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [15:56:39.763] root = 0x8356af9e0 [15:56:39.763] hasOuterJoins = false [15:56:39.763] hasResultRTEs = false [15:56:39.763] l = [15:56:39.763] newWithCheckOptions = [15:56:39.763] newHaving = 0x0 [15:56:39.763] final_rel = [15:56:39.763] #7 0x00000000007ae888 in standard_planner (parse=0x837b250e0, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [15:56:39.763] glob = 0x837c01b40 [15:56:39.763] tuple_fraction = 0 [15:56:39.763] root = [15:56:39.763] final_rel = [15:56:39.763] best_path = [15:56:39.763] top_plan = [15:56:39.763] lp = [15:56:39.763] lr = [15:56:39.763] result = [15:56:39.763] #8 0x00000008393ce6af in pgss_planner (parse=0x837b250e0, query_string=0x837c04258 "\006", cursorOptions=550582112, boundParams=0xfffffe3b) at ../contrib/pg_stat_statements/pg_stat_statements.c:972 [15:56:39.763] _local_sigjmp_buf = {{_sjb = {35320030557, 11902776, 34910321240, 34910321696, 34910321280, 0, 35294171360, 34910322096, 35295069055, 35294169168, 34910321392, 0}}} [15:56:39.763] _save_exception_stack = 0x820d13db0 [15:56:39.763] _save_context_stack = 0x0 [15:56:39.763] _do_rethrow = false [15:56:39.763] result = [15:56:39.763] #9 0x00000000007ae755 in planner (parse=0x37c07968, parse@entry=0x837b250e0, query_string=0x837c04258 "\006", query_string@entry=0x835575100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=550582112, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [15:56:39.763] result = [15:56:39.763] #10 0x00000000008d1c45 in pg_plan_query (querytree=querytree@entry=0x837b250e0, query_string=query_string@entry=0x835575100 "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:903 [15:56:39.763] plan = [15:56:39.763] #11 0x00000000008d1d22 in pg_plan_queries (querytrees=0x837c01af0, query_string=query_string@entry=0x835575100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=550582112, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [15:56:39.763] query = 0x837b250e0 [15:56:39.763] stmt = [15:56:39.763] query_list__state = {l = 0x837c01af0, i = 0} [15:56:39.763] stmt_list = 0x0 [15:56:39.763] query_list = [15:56:39.763] #12 0x00000000008d5ebc in exec_simple_query (query_string=query_string@entry=0x835575100 "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:1192 [15:56:39.763] cmdtaglen = [15:56:39.763] snapshot_set = [15:56:39.763] per_parsetree_context = 0x0 [15:56:39.763] plantree_list = [15:56:39.763] qc = {commandTag = 336, nprocessed = 6} [15:56:39.763] parsetree = 0x8356b0600 [15:56:39.763] commandTag = [15:56:39.763] cmdtagname = [15:56:39.763] querytree_list = 0x0 [15:56:39.763] portal = [15:56:39.763] format = [15:56:39.763] receiver = [15:56:39.763] parsetree_item__state = {l = 0x837be85f8, i = 0} [15:56:39.763] 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" [15:56:39.763] dest = DestRemote [15:56:39.763] was_logged = [15:56:39.763] oldcontext = 0x835581000 [15:56:39.763] parsetree_list = 0x837be85f8 [15:56:39.763] use_implicit_block = false [15:56:39.763] parsetree_item = 0x837be8610 [15:56:39.763] save_log_statement_stats = [15:56:39.763] #13 0x00000000008d3d94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [15:56:39.763] query_string = 0x835575100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [15:56:39.763] input_message = {data = 0x835575100 "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} [15:56:39.763] firstchar = [15:56:39.763] local_sigjmp_buf = {{_sjb = {9253472, 34910322096, 34910322056, 34910322656, 11911512, 11858000, 8192, 8388608, 72057628948235135, 0, 0, 1}}} [15:56:39.763] send_ready_for_query = false [15:56:39.763] idle_in_transaction_timeout_enabled = false [15:56:39.763] idle_session_timeout_enabled = false [15:56:39.763] #14 0x0000000000832a85 in BackendRun (port=port@entry=0x835652000) at ../src/backend/postmaster/postmaster.c:4475 [15:56:39.763] No locals. [15:56:39.763] #15 0x0000000000830dbd in BackendStartup (port=0x835652000) at ../src/backend/postmaster/postmaster.c:4151 [15:56:39.763] bn = 0x8355811c8 [15:56:39.763] pid = [15:56:39.763] __error = [15:56:39.763] __error = [15:56:39.763] __error = [15:56:39.763] save_errno = [15:56:39.763] __error = [15:56:39.763] #16 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [15:56:39.763] port = 0x835652000 [15:56:39.763] i = 0 [15:56:39.763] now = [15:56:39.763] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 564485128, events = 8, fd = 564486152, user_data = 0x821a56408}, {pos = 564488200, events = 8, fd = 564489224, user_data = 0x821a57008}, {pos = 564491272, events = 8, fd = 564510856, user_data = 0x820d142e8}, {pos = 550584576, events = 8, fd = -796189277, user_data = 0x821a57408}, {pos = 2565774, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 564514872, events = 8, fd = 1, user_data = 0x821a57408}, {pos = 711074984, events = 8, fd = 550585320, user_data = 0x821a57408}, {pos = 550584544, events = 0, fd = 2565592, user_data = 0x820d14330}, {pos = 711182692, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 564517432, events = 8, fd = 1, user_data = 0x821a57408}, {pos = 711096536, events = 8, fd = 550584872, user_data = 0x820d13fd0}, {pos = 33, events = 18, fd = 711167076, user_data = 0x821a57408}, {pos = 564517432, events = 8, fd = 0, user_data = 0xa41}, {pos = 550584848, events = 8, fd = -796215739, user_data = 0x82a63c964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821a5da38}, {pos = 1, events = 0, fd = 564491272, user_data = 0x835565000}, {pos = 1, events = 0, fd = 894849428, user_data = 0x0}, {pos = 550584800, events = 8, fd = 732396556, user_data = 0x1}, {pos = 894849024, events = 8, fd = 550584848, user_data = 0x82ba76eb4}, {pos = 712909152, events = 8, fd = 712909152, user_data = 0x82a6540c0}, {pos = 564491272, events = 8, fd = 550585072, user_data = 0x340ed08ab42c}, {pos = 80627796, events = 0, fd = 1, user_data = 0x340ed08ab2ae}, {pos = 12240, events = 0, fd = 550584856, user_data = 0x820d142f0}, {pos = 895645672, events = 8, fd = 550586464, user_data = 0x340ed08bee90}, {pos = 564491272, events = 8, fd = 550568831, user_data = 0x82a78e4b2}, {pos = 550585376, events = 8, fd = 0, user_data = 0x821a57408}, {pos = 12240, events = 0, fd = 711032832, user_data = 0x1df950}, {pos = 712909152, events = 8, fd = 711167076, user_data = 0x3d00}, {pos = 550586256, events = 8, fd = 550585184, user_data = 0x82a6dd18e }, {pos = 712947768, events = 8, fd = 550585124, user_data = 0x8355cc5da}, {pos = 550586256, events = 8, fd = 550585184, user_data = 0x82a6f3605}, {pos = 550585122, events = 8, fd = 550586256, user_data = 0x820d14790}, {pos = 0, events = 16777216, fd = -1512021097, user_data = 0x820d14790}, {pos = 895272408, events = 8, fd = 550586464, user_data = 0x82a7eb838}, {pos = 0, events = 0, fd = 550586320, user_data = 0x82a6f370d}, {pos = 0, events = 0, fd = 0, user_data = 0x820d14900}, {pos = 895272408, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -796187639, events = 13326, fd = 550585512, user_data = 0x82a638c64}, {pos = 2503, events = 0, fd = -796187639, user_data = 0x820d144c8}, {pos = 711167076, events = 8, fd = 2758, user_data = 0x82a632120}, {pos = 550585416, events = 8, fd = 564491272, user_data = 0x820d144c8}, {pos = 711139616, events = 8, fd = 550585520, user_data = 0x340ed08ad465}, {pos = 0, events = 0, fd = 0, user_data = 0x820d144a0}, {pos = 711099728, events = 8, fd = 0, user_data = 0x0}, {pos = 550585472, events = 8, fd = 16, user_data = 0x0}, {pos = 550585656, events = 8, fd = 564510856, user_data = 0x340ed08b2409}, {pos = 550585720, events = 8, fd = 711167076, user_data = 0xb6c}, {pos = 711140280, events = 8, fd = 550585592, user_data = 0x821a57408}, {pos = 550585720, events = 8, fd = 711140280, user_data = 0x820d14560}, {pos = -796208027, events = 13326, fd = 564514872, user_data = 0x800000001}, {pos = 564491272, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 550586120, user_data = 0x2725d8}, {pos = 550586224, events = 8, fd = 550586224, user_data = 0x820d14728}, {pos = 31, events = 0, fd = 0, user_data = 0x820d14608}, {pos = 564512648, events = 8, fd = 550586328, user_data = 0x820d145f0}, {pos = -796189277, events = 13326, fd = 564514872, user_data = 0x2911de}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821a5d038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550586584, events = 8, fd = 0, user_data = 0x320d14760}, {pos = 564512744, events = 8, fd = 550586400, user_data = 0x290}, {pos = 550586328, events = 8, fd = 550585864, user_data = 0x820d14670}, {pos = -796189651, events = 13326, fd = 564480008, user_data = 0x0}} [15:56:39.763] last_touch_time = 1709999564 [15:56:39.763] last_lockfile_recheck_time = 1709999564 [15:56:39.763] nevents = 1 [15:56:39.763] #17 0x000000000082e0c3 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820d14f98) at ../src/backend/postmaster/postmaster.c:1468 [15:56:39.763] userDoption = [15:56:39.763] listen_addr_saved = false [15:56:39.763] output_config_variable = [15:56:39.763] opt = [15:56:39.763] status = [15:56:39.763] #18 0x000000000076b345 in main (argc=4, argv=0x820d14f98) at ../src/backend/main/main.c:197 [15:56:39.763] do_check_root = [15:56:39.770] [15:56:39.770] [15:56:39.770] [15:56:39.827] dumping /tmp/cores/postgres.18957.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:56:39.950] [New LWP 100160] [15:56:40.020] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT'. [15:56:40.020] Program terminated with signal SIGSEGV, Segmentation fault. [15:56:40.020] Address not mapped to object. [15:56:40.020] #0 get_expr_width (root=root@entry=0x839b29c00, expr=expr@entry=0x39be2170) at ../src/backend/optimizer/path/costsize.c:6328 [15:56:40.020] 6328 if (IsA(expr, Var)) [15:56:40.042] [15:56:40.042] Thread 1 (LWP 100160): [15:56:40.042] #0 get_expr_width (root=root@entry=0x839b29c00, expr=expr@entry=0x39be2170) at ../src/backend/optimizer/path/costsize.c:6328 [15:56:40.042] width = [15:56:40.042] #1 0x0000000000789815 in set_pathtarget_cost_width (root=root@entry=0x839b29c00, target=target@entry=0x839be2100) at ../src/backend/optimizer/path/costsize.c:6299 [15:56:40.042] node = 0x39be2170 [15:56:40.042] lc__state = {l = 0x839be21e0, i = 0} [15:56:40.042] tuple_width = 0 [15:56:40.042] lc = 0x839be21f8 [15:56:40.042] #2 0x00000000007b1e74 in make_group_input_target (root=0x839b29c00, final_target=0x839be2040) at ../src/backend/optimizer/plan/planner.c:5479 [15:56:40.042] parse = 0x839b2d030 [15:56:40.042] input_target = 0x839be2100 [15:56:40.042] non_group_cols = 0x0 [15:56:40.042] i = [15:56:40.042] lc = [15:56:40.042] non_group_vars = 0x0 [15:56:40.042] #3 grouping_planner (root=root@entry=0x839b29c00, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [15:56:40.042] qp_extra = {activeWindows = 0x0, gset_data = 0x839bdecf8} [15:56:40.042] activeWindows = 0x0 [15:56:40.042] sort_input_target_parallel_safe = false [15:56:40.042] grouping_target = 0x839be2040 [15:56:40.042] scanjoin_target = [15:56:40.042] sort_input_targets = [15:56:40.042] wflists = 0x0 [15:56:40.042] gset_data = 0x839bdecf8 [15:56:40.042] have_grouping = false [15:56:40.042] sort_input_targets_contain_srfs = [15:56:40.042] sort_input_target = 0x839be2040 [15:56:40.042] grouping_target_parallel_safe = false [15:56:40.042] scanjoin_target_parallel_safe = [15:56:40.042] grouping_targets = [15:56:40.042] scanjoin_targets = [15:56:40.042] grouping_targets_contain_srfs = [15:56:40.042] scanjoin_targets_contain_srfs = [15:56:40.042] scanjoin_target_same_exprs = [15:56:40.042] extra = {limit_needed = 208, limit_tuples = 1.7251706601795423e-313, count_est = 16, offset_est = 34917842928} [15:56:40.042] parse = 0x839b2d030 [15:56:40.042] offset_est = [15:56:40.042] count_est = [15:56:40.042] limit_tuples = -1 [15:56:40.042] have_postponed_srfs = false [15:56:40.042] current_rel = 0x839be0630 [15:56:40.042] final_target = 0x839be2040 [15:56:40.042] final_targets_contain_srfs = [15:56:40.042] final_targets = [15:56:40.042] final_rel = [15:56:40.042] lc = [15:56:40.042] final_target_parallel_safe = [15:56:40.042] #4 0x00000000007afd64 in subquery_planner (glob=glob@entry=0x839b2e958, parse=parse@entry=0x839b2d030, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [15:56:40.042] root = 0x839b29c00 [15:56:40.042] hasOuterJoins = false [15:56:40.042] hasResultRTEs = false [15:56:40.042] l = [15:56:40.042] newWithCheckOptions = [15:56:40.042] newHaving = 0x0 [15:56:40.042] final_rel = [15:56:40.042] #5 0x00000000007ae888 in standard_planner (parse=0x839b2d030, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [15:56:40.042] glob = 0x839b2e958 [15:56:40.042] tuple_fraction = 0 [15:56:40.042] root = [15:56:40.042] final_rel = [15:56:40.042] best_path = [15:56:40.042] top_plan = [15:56:40.042] lp = [15:56:40.042] lr = [15:56:40.042] result = [15:56:40.042] #6 0x000000083a7d9712 in pgss_planner (parse=0x839b2d030, query_string=0x836e34100 "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=0x839be21f8) at ../contrib/pg_stat_statements/pg_stat_statements.c:926 [15:56:40.042] _local_sigjmp_buf = {{_sjb = {35341047407, 35280601344, 34917843512, 34917843968, 11902776, 35327758384, 34917843680, 0, 34917843839, 11089109, 2, 34359738368}}} [15:56:40.042] _save_exception_stack = 0x821440590 [15:56:40.042] _save_context_stack = 0x0 [15:56:40.042] _do_rethrow = false [15:56:40.042] bufusage = {shared_blks_hit = 35341047407, shared_blks_read = 35280601344, shared_blks_dirtied = 34917843512, shared_blks_written = 34917843968, local_blks_hit = 11902776, local_blks_read = 35327758384, local_blks_dirtied = 34917843680, local_blks_written = 0, temp_blks_read = 34917843839, temp_blks_written = 11089109, shared_blk_read_time = {ticks = 2}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 34917843824}, local_blk_write_time = {ticks = 11118095}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 35327764568}} [15:56:40.042] walusage_start = {wal_records = 1346, wal_fpi = 2, wal_bytes = 170363} [15:56:40.042] duration = [15:56:40.042] bufusage_start = {shared_blks_hit = 27812, 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}} [15:56:40.042] walusage = {wal_records = 35327758384, wal_fpi = 35328558520, wal_bytes = 34917843888} [15:56:40.042] start = [15:56:40.042] result = [15:56:40.042] #7 0x00000000007ae755 in planner (parse=0x839b29c00, parse@entry=0x839b2d030, query_string=0x39be2170 , query_string@entry=0x836e34100 "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=0x839be21f8, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [15:56:40.042] result = [15:56:40.042] #8 0x00000000008d1c45 in pg_plan_query (querytree=querytree@entry=0x839b2d030, query_string=query_string@entry=0x836e34100 "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:903 [15:56:40.042] plan = [15:56:40.042] #9 0x00000000008d1d22 in pg_plan_queries (querytrees=0x839b2e908, query_string=query_string@entry=0x836e34100 "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=0x839be21f8, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [15:56:40.042] query = 0x839b2d030 [15:56:40.042] stmt = [15:56:40.042] query_list__state = {l = 0x839b2e908, i = 0} [15:56:40.042] stmt_list = 0x0 [15:56:40.042] query_list = [15:56:40.042] #10 0x00000000008d5ebc in exec_simple_query (query_string=query_string@entry=0x836e34100 "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:1192 [15:56:40.042] cmdtaglen = [15:56:40.042] snapshot_set = [15:56:40.042] per_parsetree_context = 0x0 [15:56:40.042] plantree_list = [15:56:40.042] qc = {commandTag = 336, nprocessed = 6} [15:56:40.042] parsetree = 0x839b9dcb0 [15:56:40.042] commandTag = [15:56:40.042] cmdtagname = [15:56:40.042] querytree_list = 0x0 [15:56:40.042] portal = [15:56:40.042] format = [15:56:40.042] receiver = [15:56:40.042] parsetree_item__state = {l = 0x839bf0568, i = 0} [15:56:40.042] 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" [15:56:40.042] dest = DestRemote [15:56:40.042] was_logged = [15:56:40.042] oldcontext = 0x836e40000 [15:56:40.042] parsetree_list = 0x839bf0568 [15:56:40.042] use_implicit_block = false [15:56:40.042] parsetree_item = 0x839bf0580 [15:56:40.042] save_log_statement_stats = [15:56:40.042] #11 0x00000000008d3d94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [15:56:40.042] query_string = 0x836e34100 "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;" [15:56:40.042] input_message = {data = 0x836e34100 "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} [15:56:40.042] firstchar = [15:56:40.042] local_sigjmp_buf = {{_sjb = {9253472, 34917844368, 34917844328, 34917844928, 11911512, 11858000, 8192, 8388608, 72057628955771775, 0, 0, 34359738369}}} [15:56:40.042] send_ready_for_query = false [15:56:40.042] idle_in_transaction_timeout_enabled = false [15:56:40.042] idle_session_timeout_enabled = false [15:56:40.042] #12 0x0000000000832a85 in BackendRun (port=port@entry=0x836f0a000) at ../src/backend/postmaster/postmaster.c:4475 [15:56:40.042] No locals. [15:56:40.042] #13 0x0000000000830dbd in BackendStartup (port=0x836f0a000) at ../src/backend/postmaster/postmaster.c:4151 [15:56:40.042] bn = 0x836e40238 [15:56:40.042] pid = [15:56:40.042] __error = [15:56:40.042] __error = [15:56:40.042] __error = [15:56:40.042] save_errno = [15:56:40.042] __error = [15:56:40.042] #14 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [15:56:40.042] port = 0x836f0a000 [15:56:40.042] i = 0 [15:56:40.042] now = [15:56:40.042] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 564562952, events = 8, fd = 564563976, user_data = 0x821a69408}, {pos = 564566024, events = 8, fd = 564567048, user_data = 0x821a6a008}, {pos = 564569096, events = 8, fd = 912301024, user_data = 0xa0}, {pos = -1, events = 0, fd = 781812448, user_data = 0x8214408b0}, {pos = 781472169, events = 8, fd = 0, user_data = 0x1000}, {pos = 522211382, events = 2618009276, fd = 781813736, user_data = 0x836609be0}, {pos = 160, events = 0, fd = 0, user_data = 0x8354cd090}, {pos = 558107008, events = 8, fd = 781334828, user_data = 0x1000}, {pos = 779897188, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 564595256, events = 8, fd = 1, user_data = 0x821a6a408}, {pos = 779811032, events = 8, fd = 558107144, user_data = 0x8214407b0}, {pos = 33, events = 18, fd = 779881572, user_data = 0x821a6a408}, {pos = 564595256, events = 8, fd = 0, user_data = 0xa41}, {pos = 558107120, events = 8, fd = -648894907, user_data = 0x82e7c4964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821a70a38}, {pos = 1, events = 0, fd = 564569096, user_data = 0x836e24000}, {pos = 1, events = 0, fd = 920797588, user_data = 0x0}, {pos = 558107072, events = 8, fd = 761510924, user_data = 0x1}, {pos = 920797184, events = 8, fd = 558107120, user_data = 0x82d63aeb4}, {pos = 781623648, events = 8, fd = 781623648, user_data = 0x82e7dc0c0}, {pos = 564569096, events = 8, fd = 558107344, user_data = 0x3ebfd952a42c}, {pos = 894226576, events = 8, fd = 1, user_data = 0x3ebfd952a2ae}, {pos = 12240, events = 0, fd = 558107128, user_data = 0x821440ad0}, {pos = 921454568, events = 8, fd = 558108736, user_data = 0x3ebfd953de90}, {pos = 564569096, events = 8, fd = 558105471, user_data = 0x82e91659c}, {pos = 558107648, events = 8, fd = 0, user_data = 0x821a6a408}, {pos = 12240, events = 0, fd = 779747328, user_data = 0x1df950}, {pos = 781623648, events = 8, fd = 779881572, user_data = 0x3d00}, {pos = 558108528, events = 8, fd = 558107456, user_data = 0x82e86518e }, {pos = 781662264, events = 8, fd = 558107396, user_data = 0x836e845da}, {pos = 558108528, events = 8, fd = 558107456, user_data = 0x82e87b605}, {pos = 558107394, events = 8, fd = 558108528, user_data = 0x821440f70}, {pos = 0, events = 16777216, fd = 522211382, user_data = 0x821440f70}, {pos = 921191896, events = 8, fd = 558108736, user_data = 0x82e973838}, {pos = 0, events = 0, fd = 558108592, user_data = 0x82e87b70d}, {pos = 0, events = 0, fd = 0, user_data = 0x8214410e0}, {pos = 921191896, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -648866807, events = 16063, fd = 558107784, user_data = 0x82e7c0c64}, {pos = 2503, events = 0, fd = -648866807, user_data = 0x821440ca8}, {pos = 779881572, events = 8, fd = 2758, user_data = 0x82e7ba120}, {pos = 558107688, events = 8, fd = 564569096, user_data = 0x821440ca8}, {pos = 779854112, events = 8, fd = 558107792, user_data = 0x3ebfd952c465}, {pos = 0, events = 0, fd = 0, user_data = 0x821440c80}, {pos = 779814224, events = 8, fd = 0, user_data = 0x0}, {pos = 558107744, events = 8, fd = 16, user_data = 0x0}, {pos = 558107928, events = 8, fd = 564588680, user_data = 0x3ebfd9531409}, {pos = 558107992, events = 8, fd = 779881572, user_data = 0xb6c}, {pos = 779854776, events = 8, fd = 558107864, user_data = 0x821a6a408}, {pos = 558107992, events = 8, fd = 779854776, user_data = 0x821440d40}, {pos = -648887195, events = 16063, fd = 564592696, user_data = 0x800000001}, {pos = 564569096, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 558108392, user_data = 0x2725d8}, {pos = 558108496, events = 8, fd = 558108496, user_data = 0x821440f08}, {pos = 31, events = 0, fd = 0, user_data = 0x821440de8}, {pos = 564590472, events = 8, fd = 558108600, user_data = 0x821440dd0}, {pos = -648868445, events = 16063, fd = 564592696, user_data = 0x2911de}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821a70038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558108856, events = 8, fd = 0, user_data = 0x321440f40}, {pos = 564590568, events = 8, fd = 558108672, user_data = 0x290}, {pos = 558108600, events = 8, fd = 558108136, user_data = 0x821440e50}, {pos = -648868819, events = 16063, fd = 564557832, user_data = 0x0}} [15:56:40.042] last_touch_time = 1709999601 [15:56:40.042] last_lockfile_recheck_time = 1709999601 [15:56:40.042] nevents = 1 [15:56:40.042] #15 0x000000000082e0c3 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821441770) at ../src/backend/postmaster/postmaster.c:1468 [15:56:40.042] userDoption = [15:56:40.042] listen_addr_saved = false [15:56:40.042] output_config_variable = [15:56:40.042] opt = [15:56:40.042] status = [15:56:40.042] #16 0x000000000076b345 in main (argc=8, argv=0x821441770) at ../src/backend/main/main.c:197 [15:56:40.042] do_check_root = [15:56:40.050] [15:56:40.050] [15:56:40.050] [15:56:40.109] dumping /tmp/cores/postgres.19151.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [15:56:40.233] [New LWP 100107] [15:56:40.308] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN'. [15:56:40.308] Program terminated with signal SIGSEGV, Segmentation fault. [15:56:40.308] Address not mapped to object. [15:56:40.308] #0 equal (a=0x351190d8, b=b@entry=0x8350bd678) at ../src/backend/nodes/equalfuncs.c:239 [15:56:40.308] 239 if (nodeTag(a) != nodeTag(b)) [15:56:40.763] [15:56:40.763] Thread 1 (LWP 100107): [15:56:40.763] #0 equal (a=0x351190d8, b=b@entry=0x8350bd678) at ../src/backend/nodes/equalfuncs.c:239 [15:56:40.763] retval = [15:56:40.763] #1 0x000000000076ea82 in list_member (list=0x835119148, datum=datum@entry=0x8350bd678) at ../src/backend/nodes/list.c:670 [15:56:40.763] cell__state = {l = 0x835119148, i = 0} [15:56:40.763] cell = 0x0 [15:56:40.763] cell__state = [15:56:40.763] #2 0x00000000007e2425 in add_new_column_to_pathtarget (target=0x835119088, expr=) at ../src/backend/optimizer/util/tlist.c:743 [15:56:40.763] No locals. [15:56:40.763] #3 add_new_columns_to_pathtarget (target=target@entry=0x835119088, exprs=0x8351191e8) at ../src/backend/optimizer/util/tlist.c:760 [15:56:40.763] expr = [15:56:40.763] lc__state = {l = 0x8351191e8, i = 0} [15:56:40.763] lc = 0xfffffe3b [15:56:40.763] #4 0x00000000007b1e59 in make_group_input_target (root=0x8350bd038, final_target=0x842239fa8) at ../src/backend/optimizer/plan/planner.c:5472 [15:56:40.763] parse = 0x8422751a0 [15:56:40.763] input_target = 0x835119088 [15:56:40.763] non_group_cols = 0x835119198 [15:56:40.763] i = [15:56:40.763] lc = [15:56:40.763] non_group_vars = 0x8351191e8 [15:56:40.763] #5 grouping_planner (root=root@entry=0x8350bd038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [15:56:40.763] qp_extra = {activeWindows = 0x0, gset_data = 0x8350bd8a8} [15:56:40.763] activeWindows = 0x0 [15:56:40.763] sort_input_target_parallel_safe = false [15:56:40.763] grouping_target = 0x842239fa8 [15:56:40.763] scanjoin_target = [15:56:40.763] sort_input_targets = [15:56:40.763] wflists = 0x0 [15:56:40.763] gset_data = 0x8350bd8a8 [15:56:40.763] have_grouping = false [15:56:40.763] sort_input_targets_contain_srfs = [15:56:40.763] sort_input_target = 0x842239fa8 [15:56:40.763] grouping_target_parallel_safe = false [15:56:40.763] scanjoin_target_parallel_safe = [15:56:40.763] grouping_targets = [15:56:40.763] scanjoin_targets = [15:56:40.763] grouping_targets_contain_srfs = [15:56:40.763] scanjoin_targets_contain_srfs = [15:56:40.763] scanjoin_target_same_exprs = [15:56:40.763] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 34913397296} [15:56:40.763] parse = 0x8422751a0 [15:56:40.763] offset_est = [15:56:40.763] count_est = [15:56:40.763] limit_tuples = -1 [15:56:40.763] have_postponed_srfs = false [15:56:40.763] current_rel = 0x8350fddd8 [15:56:40.763] final_target = 0x842239fa8 [15:56:40.763] final_targets_contain_srfs = [15:56:40.763] final_targets = [15:56:40.763] final_rel = [15:56:40.763] lc = [15:56:40.763] final_target_parallel_safe = [15:56:40.763] #6 0x00000000007afd64 in subquery_planner (glob=glob@entry=0x8350fd998, parse=parse@entry=0x8422751a0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [15:56:40.763] root = 0x8350bd038 [15:56:40.763] hasOuterJoins = false [15:56:40.763] hasResultRTEs = false [15:56:40.763] l = [15:56:40.763] newWithCheckOptions = [15:56:40.763] newHaving = 0x0 [15:56:40.763] final_rel = [15:56:40.763] #7 0x00000000007ae888 in standard_planner (parse=0x8422751a0, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [15:56:40.763] glob = 0x8350fd998 [15:56:40.763] tuple_fraction = 0 [15:56:40.763] root = [15:56:40.763] final_rel = [15:56:40.763] best_path = [15:56:40.763] top_plan = [15:56:40.763] lp = [15:56:40.763] lr = [15:56:40.763] result = [15:56:40.763] #8 0x00000000007ae75c in planner (parse=0x351190d8, parse@entry=0x8422751a0, query_string=0x8350bd678 "\006", query_string@entry=0x835061100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=553658736, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [15:56:40.763] result = [15:56:40.763] #9 0x00000000008d1c45 in pg_plan_query (querytree=querytree@entry=0x8422751a0, query_string=query_string@entry=0x835061100 "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:903 [15:56:40.763] plan = [15:56:40.763] #10 0x0000000000685803 in ExplainOneQuery (query=0x8422751a0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x83506f748, queryString=0x835061100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", params=0xfffffe3b, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:428 [15:56:40.763] bufusage = {shared_blks_hit = 247, shared_blks_read = 126141978, shared_blks_dirtied = 34913398208, shared_blks_written = 35469610249, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = -8535939591996549385, local_blks_written = 34913398236, temp_blks_read = -1, temp_blks_written = 10797587, shared_blk_read_time = {ticks = 35469614160}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35469611424}, local_blk_write_time = {ticks = 35469611424}, temp_blk_read_time = {ticks = 34913398240}, temp_blk_write_time = {ticks = 10833152}} [15:56:40.763] saved_ctx = 0x0 [15:56:40.763] planstart = {ticks = -247126141978} [15:56:40.763] planduration = {ticks = 7789744} [15:56:40.763] bufusage_start = {shared_blks_hit = 1, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 34913398048, local_blks_read = 10584417, local_blks_dirtied = 70368744194107, local_blks_written = 0, temp_blks_read = 34913398080, temp_blks_written = 5658010, shared_blk_read_time = {ticks = 70368744194107}, shared_blk_write_time = {ticks = 35469611424}, local_blk_read_time = {ticks = 34913398096}, local_blk_write_time = {ticks = 6206329}, temp_blk_read_time = {ticks = 34913398272}, temp_blk_write_time = {ticks = 8914581}} [15:56:40.763] mem_counters = {nblocks = 34913398016, freechunks = 9139333, totalspace = 34913398016, freespace = 35547259944} [15:56:40.763] planner_ctx = [15:56:40.763] plan = [15:56:40.763] #11 0x0000000000685322 in ExplainQuery (pstate=pstate@entry=0x83506f638, stmt=stmt@entry=0x842275170, params=0x835119000, params@entry=0x0, dest=0x83506f5a8) at ../src/backend/commands/explain.c:293 [15:56:40.763] l__state = {l = , i = 0} [15:56:40.763] l = 0x8350fd4b0 [15:56:40.763] es = 0x83506f748 [15:56:40.763] jstate = [15:56:40.763] timing_set = false [15:56:40.763] summary_set = false [15:56:40.763] lc = [15:56:40.763] query = [15:56:40.763] rewritten = 0x8350fd498 [15:56:40.763] tstate = [15:56:40.763] #12 0x00000000008d8d4f in standard_ProcessUtility (pstmt=0x835214d68, queryString=0x835061100 "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=0x821002970, queryEnv=0x0, dest=0x83506f5a8, qc=0x821002fb8) at ../src/backend/tcop/utility.c:863 [15:56:40.763] isAtomicContext = true [15:56:40.763] parsetree = 0x842275170 [15:56:40.763] readonly_flags = [15:56:40.763] pstate = 0x83506f638 [15:56:40.763] isTopLevel = [15:56:40.763] #13 0x00000000008d867d in ProcessUtility (pstmt=0x351190d8, pstmt@entry=0x835214d68, queryString=0x8350bd678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x835119000, dest=0x83506f5a8, qc=0x821002fb8) at ../src/backend/tcop/utility.c:523 [15:56:40.763] No locals. [15:56:40.763] #14 0x00000000008d81a3 in PortalRunUtility (portal=portal@entry=0x835136100, pstmt=0x835214d68, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x83506f5a8, qc=qc@entry=0x821002fb8) at ../src/backend/tcop/pquery.c:1158 [15:56:40.763] No locals. [15:56:40.763] #15 0x00000000008d739a in FillPortalStore (portal=portal@entry=0x835136100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [15:56:40.763] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:56:40.763] treceiver = 0x83506f5a8 [15:56:40.763] #16 0x00000000008d70a0 in PortalRun (portal=portal@entry=0x835136100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x835214ec8, altdest=altdest@entry=0x835214ec8, qc=0x8210030f0) at ../src/backend/tcop/pquery.c:763 [15:56:40.763] _local_sigjmp_buf = {{_sjb = {9269311, 35250251008, 34913398760, 34913398992, 34913398768, 11902776, 11870560, 35250200832, -6347183290306264193, 35250209024, 3553568, 34359738368}}} [15:56:40.763] _save_exception_stack = 0x8210031c0 [15:56:40.763] _save_context_stack = 0x0 [15:56:40.763] _do_rethrow = false [15:56:40.763] saveTopTransactionResourceOwner = 0x835142500 [15:56:40.763] saveTopTransactionContext = 0x83506d000 [15:56:40.763] saveActivePortal = 0x0 [15:56:40.763] saveResourceOwner = 0x835142500 [15:56:40.763] savePortalContext = 0x0 [15:56:40.763] saveMemoryContext = 0x83506d000 [15:56:40.763] result = [15:56:40.763] nprocessed = [15:56:40.763] #17 0x00000000008d5fab in exec_simple_query (query_string=query_string@entry=0x835061100 "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:1273 [15:56:40.763] cmdtaglen = [15:56:40.763] snapshot_set = [15:56:40.763] per_parsetree_context = 0x0 [15:56:40.763] plantree_list = [15:56:40.763] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [15:56:40.763] parsetree = 0x8351b5e60 [15:56:40.763] commandTag = CMDTAG_EXPLAIN [15:56:40.763] cmdtagname = [15:56:40.763] querytree_list = [15:56:40.763] portal = 0x835136100 [15:56:40.763] format = 0 [15:56:40.763] receiver = 0x835214ec8 [15:56:40.763] parsetree_item__state = {l = 0x8351b69b0, i = 0} [15:56:40.763] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [15:56:40.763] dest = DestRemote [15:56:40.763] was_logged = [15:56:40.763] oldcontext = 0x83506d000 [15:56:40.763] parsetree_list = 0x8351b69b0 [15:56:40.763] use_implicit_block = false [15:56:40.763] parsetree_item = 0x8351b69c8 [15:56:40.763] save_log_statement_stats = [15:56:40.763] #18 0x00000000008d3d94 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [15:56:40.763] query_string = 0x835061100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [15:56:40.763] input_message = {data = 0x835061100 "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} [15:56:40.763] firstchar = [15:56:40.763] local_sigjmp_buf = {{_sjb = {9253472, 34913399232, 34913399192, 34913399792, 11911512, 11858000, 8192, 8388608, 72057628951315327, 0, 0, 34359738369}}} [15:56:40.763] send_ready_for_query = false [15:56:40.763] idle_in_transaction_timeout_enabled = false [15:56:40.763] idle_session_timeout_enabled = false [15:56:40.763] #19 0x0000000000832a85 in BackendRun (port=port@entry=0x83513c000) at ../src/backend/postmaster/postmaster.c:4475 [15:56:40.763] No locals. [15:56:40.763] #20 0x0000000000830dbd in BackendStartup (port=0x83513c000) at ../src/backend/postmaster/postmaster.c:4151 [15:56:40.763] bn = 0x83506d128 [15:56:40.763] pid = [15:56:40.763] __error = [15:56:40.763] __error = [15:56:40.763] __error = [15:56:40.763] save_errno = [15:56:40.763] __error = [15:56:40.763] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [15:56:40.763] port = 0x83513c000 [15:56:40.763] i = 0 [15:56:40.763] now = [15:56:40.763] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 555824136, events = 8, fd = 555825160, user_data = 0x821213c08}, {pos = 555827208, events = 8, fd = 555828232, user_data = 0x821214808}, {pos = 555830280, events = 8, fd = 555831304, user_data = 0x821215408}, {pos = -1, events = 0, fd = 718480096, user_data = 0x8210034e0}, {pos = 718139817, events = 8, fd = 0, user_data = 0x1000}, {pos = -1696966921, events = 2307538986, fd = 718481384, user_data = 0x834409be0}, {pos = 160, events = 0, fd = 0, user_data = 0x83301d090}, {pos = 553661872, events = 8, fd = 718002476, user_data = 0x1000}, {pos = 716564836, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 555858488, events = 8, fd = 1, user_data = 0x821215408}, {pos = 716478680, events = 8, fd = 553662008, user_data = 0x8210033f0}, {pos = 32, events = 18, fd = 716549220, user_data = 0x821215408}, {pos = 555858488, events = 8, fd = 0, user_data = 0xa41}, {pos = 553661984, events = 8, fd = -368843195, user_data = 0x82ab5e964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x82121ba38}, {pos = 1, events = 0, fd = 555832328, user_data = 0x835051000}, {pos = 1, events = 0, fd = 889524628, user_data = 0x0}, {pos = 553661936, events = 8, fd = 702348300, user_data = 0x1}, {pos = 889524224, events = 8, fd = 553661984, user_data = 0x829dceeb4}, {pos = 718291296, events = 8, fd = 718291296, user_data = 0x82ab760c0}, {pos = 555832328, events = 8, fd = 553662208, user_data = 0x3d56ea03e42c}, {pos = 855756944, events = 8, fd = 1, user_data = 0x3d56ea03e2ae}, {pos = 12240, events = 0, fd = 553661992, user_data = 0x821003700}, {pos = 890202088, events = 8, fd = 553663600, user_data = 0x3d56ea051e90}, {pos = 555832328, events = 8, fd = 553649023, user_data = 0x82acb059c}, {pos = 555802632, events = 8, fd = 0, user_data = 0x821215408}, {pos = 12240, events = 0, fd = 716414976, user_data = 0x1df950}, {pos = 718291296, events = 8, fd = 716549220, user_data = 0x3d00}, {pos = 553663392, events = 8, fd = 553662320, user_data = 0x82abff18e }, {pos = 718329912, events = 8, fd = 553662260, user_data = 0x8350b65da}, {pos = 553663392, events = 8, fd = 553662320, user_data = 0x82ac15605}, {pos = 553662258, events = 8, fd = 553663392, user_data = 0x821003ba0}, {pos = 0, events = 16777216, fd = -1696966921, user_data = 0x821003ba0}, {pos = 889939416, events = 8, fd = 553663600, user_data = 0x82ad0d838}, {pos = 0, events = 0, fd = 553663456, user_data = 0x82ac1570d}, {pos = 0, events = 0, fd = 0, user_data = 0x821003d10}, {pos = 889939416, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3d56ea045409}, {pos = 553662664, events = 8, fd = 716549220, user_data = 0x9c7}, {pos = -368815095, events = 15702, fd = 553662696, user_data = 0x82ab5ac64}, {pos = 2758, events = 0, fd = 716521760, user_data = 0x821003868}, {pos = 555832328, events = 8, fd = 553662696, user_data = 0x82ab54120}, {pos = 553662672, events = 8, fd = -368835483, user_data = 0x0}, {pos = 0, events = 0, fd = 718430448, user_data = 0x82ab4a550}, {pos = 0, events = 0, fd = 0, user_data = 0x82ad149b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x821003958}, {pos = 555851912, events = 8, fd = -368815095, user_data = 0x821003998}, {pos = 716549220, events = 8, fd = 2924, user_data = 0x82ab543b8}, {pos = 553662744, events = 8, fd = 555832328, user_data = 0x821003998}, {pos = 716522424, events = 8, fd = 553662848, user_data = 0x3d56ea040465}, {pos = 555855928, events = 8, fd = 1, user_data = 0x821215408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 553663256, events = 0, fd = 2565592, user_data = 0x821003b80}, {pos = 553663360, events = 8, fd = 553663288, user_data = 0x1e}, {pos = 716485856, events = 8, fd = 553663016, user_data = 0x82121a248}, {pos = 553663464, events = 8, fd = 553662992, user_data = 0x3d56ea044da3}, {pos = 555855928, events = 8, fd = 2691550, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 555855928, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821003ce8}, {pos = 555832328, events = 8, fd = 553663344, user_data = 0x2725d8}, {pos = 553663536, events = 8, fd = 553663536, user_data = 0x821003be8}, {pos = 32, events = 0, fd = 553663120, user_data = 0x3d56ea044b83}} [15:56:40.763] last_touch_time = 1709999602 [15:56:40.763] last_lockfile_recheck_time = 1709999602 [15:56:40.763] nevents = 1 [15:56:40.763] #22 0x000000000082e0c3 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8210043a0) at ../src/backend/postmaster/postmaster.c:1468 [15:56:40.763] userDoption = [15:56:40.763] listen_addr_saved = false [15:56:40.763] output_config_variable = [15:56:40.763] opt = [15:56:40.763] status = [15:56:40.763] #23 0x000000000076b345 in main (argc=8, argv=0x8210043a0) at ../src/backend/main/main.c:197 [15:56:40.763] do_check_root =