[14:32:22.297] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [14:32:22.653] dumping /tmp/cores/postgres.8677.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [14:32:22.789] [New LWP 100152] [14:32:22.867] Core was generated by `postgres: postgres regression [local] SELECT'. [14:32:22.867] Program terminated with signal SIGSEGV, Segmentation fault. [14:32:22.867] Address not mapped to object. [14:32:22.867] #0 equal (a=0x378b6e38, b=b@entry=0x8378b3728) at ../src/backend/nodes/equalfuncs.c:239 [14:32:22.867] 239 if (nodeTag(a) != nodeTag(b)) [14:32:22.897] [14:32:22.897] Thread 1 (LWP 100152): [14:32:22.897] #0 equal (a=0x378b6e38, b=b@entry=0x8378b3728) at ../src/backend/nodes/equalfuncs.c:239 [14:32:22.897] retval = [14:32:22.897] #1 0x000000000076d752 in list_member (list=0x8378b6ea8, datum=datum@entry=0x8378b3728) at ../src/backend/nodes/list.c:670 [14:32:22.897] cell__state = {l = 0x8378b6ea8, i = 0} [14:32:22.897] cell = 0x0 [14:32:22.897] cell__state = [14:32:22.897] #2 0x00000000007e10f5 in add_new_column_to_pathtarget (target=0x8378b6dc8, expr=) at ../src/backend/optimizer/util/tlist.c:743 [14:32:22.897] No locals. [14:32:22.897] #3 add_new_columns_to_pathtarget (target=target@entry=0x8378b6dc8, exprs=0x8378b6fd8) at ../src/backend/optimizer/util/tlist.c:760 [14:32:22.897] expr = [14:32:22.897] lc__state = {l = 0x8378b6fd8, i = 0} [14:32:22.897] lc = 0xfffffe3b [14:32:22.897] #4 0x00000000007b0b29 in make_group_input_target (root=0x8359214e8, final_target=0x8378b6c68) at ../src/backend/optimizer/plan/planner.c:5472 [14:32:22.897] parse = 0x83789b110 [14:32:22.897] input_target = 0x8378b6dc8 [14:32:22.897] non_group_cols = 0x8378b6f88 [14:32:22.897] i = [14:32:22.897] lc = [14:32:22.897] non_group_vars = 0x8378b6fd8 [14:32:22.897] #5 grouping_planner (root=root@entry=0x8359214e8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [14:32:22.897] qp_extra = {activeWindows = 0x0, gset_data = 0x8378b4b78} [14:32:22.897] activeWindows = 0x0 [14:32:22.897] sort_input_target_parallel_safe = false [14:32:22.897] grouping_target = 0x8378b6c68 [14:32:22.897] scanjoin_target = [14:32:22.897] sort_input_targets = [14:32:22.897] wflists = 0x0 [14:32:22.897] gset_data = 0x8378b4b78 [14:32:22.897] have_grouping = false [14:32:22.897] sort_input_targets_contain_srfs = [14:32:22.897] sort_input_target = 0x8378b6c68 [14:32:22.897] grouping_target_parallel_safe = false [14:32:22.897] scanjoin_target_parallel_safe = [14:32:22.897] grouping_targets = [14:32:22.897] scanjoin_targets = [14:32:22.897] grouping_targets_contain_srfs = [14:32:22.897] scanjoin_targets_contain_srfs = [14:32:22.897] scanjoin_target_same_exprs = [14:32:22.897] extra = {limit_needed = 88, limit_tuples = 1.743637327713747e-313, count_est = 72, offset_est = 34917436528} [14:32:22.897] parse = 0x83789b110 [14:32:22.897] offset_est = [14:32:22.897] count_est = [14:32:22.897] limit_tuples = -1 [14:32:22.897] have_postponed_srfs = false [14:32:22.897] current_rel = 0x8359218f8 [14:32:22.897] final_target = 0x8378b6c68 [14:32:22.897] final_targets_contain_srfs = [14:32:22.897] final_targets = [14:32:22.897] final_rel = [14:32:22.897] lc = [14:32:22.897] final_target_parallel_safe = [14:32:22.897] #6 0x00000000007aea34 in subquery_planner (glob=glob@entry=0x8378b1420, parse=parse@entry=0x83789b110, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [14:32:22.897] root = 0x8359214e8 [14:32:22.897] hasOuterJoins = false [14:32:22.897] hasResultRTEs = false [14:32:22.897] l = [14:32:22.897] newWithCheckOptions = [14:32:22.897] newHaving = 0x0 [14:32:22.897] final_rel = [14:32:22.897] #7 0x00000000007ad558 in standard_planner (parse=0x83789b110, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [14:32:22.897] glob = 0x8378b1420 [14:32:22.897] tuple_fraction = 0 [14:32:22.897] root = [14:32:22.897] final_rel = [14:32:22.897] best_path = [14:32:22.897] top_plan = [14:32:22.897] lp = [14:32:22.897] lr = [14:32:22.897] result = [14:32:22.897] #8 0x00000000007ad42c in planner (parse=0x378b6e38, parse@entry=0x83789b110, query_string=0x8378b3728 "\006", query_string@entry=0x835840100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=557697984, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [14:32:22.897] result = [14:32:22.897] #9 0x00000000008cfdd5 in pg_plan_query (querytree=querytree@entry=0x83789b110, query_string=query_string@entry=0x835840100 "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 [14:32:22.897] plan = [14:32:22.897] #10 0x00000000008cfeb2 in pg_plan_queries (querytrees=0x8378b13d0, query_string=query_string@entry=0x835840100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=557697984, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [14:32:22.897] query = 0x83789b110 [14:32:22.897] stmt = [14:32:22.897] query_list__state = {l = 0x8378b13d0, i = 0} [14:32:22.897] stmt_list = 0x0 [14:32:22.897] query_list = [14:32:22.897] #11 0x00000000008d404c in exec_simple_query (query_string=query_string@entry=0x835840100 "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 [14:32:22.897] cmdtaglen = [14:32:22.897] snapshot_set = [14:32:22.897] per_parsetree_context = 0x0 [14:32:22.897] plantree_list = [14:32:22.897] qc = {commandTag = 336, nprocessed = 6} [14:32:22.897] parsetree = 0x83599c600 [14:32:22.897] commandTag = [14:32:22.897] cmdtagname = [14:32:22.897] querytree_list = 0x0 [14:32:22.897] portal = [14:32:22.897] format = [14:32:22.897] receiver = [14:32:22.897] parsetree_item__state = {l = 0x83591e038, i = 0} [14:32:22.897] 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" [14:32:22.897] dest = DestRemote [14:32:22.897] was_logged = [14:32:22.897] oldcontext = 0x83584c000 [14:32:22.897] parsetree_list = 0x83591e038 [14:32:22.897] use_implicit_block = false [14:32:22.897] parsetree_item = 0x83591e050 [14:32:22.897] save_log_statement_stats = [14:32:22.897] #12 0x00000000008d1f24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [14:32:22.897] query_string = 0x835840100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [14:32:22.897] input_message = {data = 0x835840100 "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} [14:32:22.897] firstchar = [14:32:22.897] local_sigjmp_buf = {{_sjb = {9245680, 34917437504, 34917437464, 34917438064, 11902728, 11849216, 8192, 8388608, 72057628955313023, 0, 0, 34359738369}}} [14:32:22.897] send_ready_for_query = false [14:32:22.897] idle_in_transaction_timeout_enabled = false [14:32:22.897] idle_session_timeout_enabled = false [14:32:22.897] #13 0x0000000000831755 in BackendRun (port=port@entry=0x83591b000) at ../src/backend/postmaster/postmaster.c:4475 [14:32:22.897] No locals. [14:32:22.897] #14 0x000000000082fa8d in BackendStartup (port=0x83591b000) at ../src/backend/postmaster/postmaster.c:4151 [14:32:22.897] bn = 0x83584c538 [14:32:22.897] pid = [14:32:22.897] __error = [14:32:22.897] __error = [14:32:22.897] __error = [14:32:22.897] save_errno = [14:32:22.897] __error = [14:32:22.897] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [14:32:22.897] port = 0x83591b000 [14:32:22.897] i = 0 [14:32:22.897] now = [14:32:22.897] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 564933640, events = 8, fd = 564934664, user_data = 0x821ac3c08}, {pos = 564936712, events = 8, fd = 564937736, user_data = 0x821ac4808}, {pos = 564939784, events = 8, fd = 564940808, user_data = 0x821ac5408}, {pos = -1, events = 0, fd = 765940448, user_data = 0x8213dd360}, {pos = 765600169, events = 8, fd = 0, user_data = 0x1000}, {pos = -1710438277, events = 3269413265, fd = 765941736, user_data = 0x834c09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x833a20090}, {pos = 557700144, events = 8, fd = 765462828, user_data = 0x1000}, {pos = 764025188, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 564967992, events = 8, fd = 1, user_data = 0x821ac5408}, {pos = 763939032, events = 8, fd = 557700280, user_data = 0x8213dd270}, {pos = 32, events = 18, fd = 764009572, user_data = 0x821ac5408}, {pos = 564967992, events = 8, fd = 0, user_data = 0xa41}, {pos = 557700256, events = 8, fd = -303061435, user_data = 0x82d8a1964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821acba38}, {pos = 1, events = 0, fd = 564941832, user_data = 0x835830000}, {pos = 1, events = 0, fd = 897778068, user_data = 0x0}, {pos = 557700208, events = 8, fd = 729054220, user_data = 0x1}, {pos = 897777664, events = 8, fd = 557700256, user_data = 0x82b746eb4}, {pos = 765751648, events = 8, fd = 765751648, user_data = 0x82d8b90c0}, {pos = 564941832, events = 8, fd = 557700480, user_data = 0x227eedefa42c}, {pos = 866254992, events = 8, fd = 1, user_data = 0x227eedefa2ae}, {pos = 12240, events = 0, fd = 557700264, user_data = 0x8213dd580}, {pos = 898455528, events = 8, fd = 557701872, user_data = 0x227eedf0de90}, {pos = 564941832, events = 8, fd = 557646719, user_data = 0x82d9f359c}, {pos = 564912136, events = 8, fd = 0, user_data = 0x821ac5408}, {pos = 12240, events = 0, fd = 763875328, user_data = 0x1df950}, {pos = 765751648, events = 8, fd = 764009572, user_data = 0x3d00}, {pos = 557701664, events = 8, fd = 557700592, user_data = 0x82d94218e }, {pos = 765790264, events = 8, fd = 557700532, user_data = 0x8358955da}, {pos = 557701664, events = 8, fd = 557700592, user_data = 0x82d958605}, {pos = 557700530, events = 8, fd = 557701664, user_data = 0x8213dda20}, {pos = 0, events = 16777216, fd = -1710438277, user_data = 0x8213dda20}, {pos = 898192856, events = 8, fd = 557701872, user_data = 0x82da50838}, {pos = 0, events = 0, fd = 557701728, user_data = 0x82d95870d}, {pos = 0, events = 0, fd = 0, user_data = 0x8213ddb90}, {pos = 898192856, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x227eedf01409}, {pos = 557700936, events = 8, fd = 764009572, user_data = 0x9c7}, {pos = -303033335, events = 8830, fd = 557700968, user_data = 0x82d89dc64}, {pos = 2758, events = 0, fd = 763982112, user_data = 0x8213dd6e8}, {pos = 564941832, events = 8, fd = 557700968, user_data = 0x82d897120}, {pos = 557700944, events = 8, fd = -303053723, user_data = 0x0}, {pos = 0, events = 0, fd = 765890800, user_data = 0x82d88d550}, {pos = 0, events = 0, fd = 0, user_data = 0x82da579b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x8213dd7d8}, {pos = 564961416, events = 8, fd = -303033335, user_data = 0x8213dd818}, {pos = 764009572, events = 8, fd = 2924, user_data = 0x82d8973b8}, {pos = 557701016, events = 8, fd = 564941832, user_data = 0x8213dd818}, {pos = 763982776, events = 8, fd = 557701120, user_data = 0x227eedefc465}, {pos = 564965432, events = 8, fd = 1, user_data = 0x821ac5408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 557701528, events = 0, fd = 2565348, user_data = 0x8213dda00}, {pos = 557701632, events = 8, fd = 557701560, user_data = 0x1e}, {pos = 763946208, events = 8, fd = 557701288, user_data = 0x821aca248}, {pos = 557701736, events = 8, fd = 557701264, user_data = 0x227eedf00da3}, {pos = 564965432, events = 8, fd = 2691288, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 564965432, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8213ddb68}, {pos = 564941832, events = 8, fd = 557701616, user_data = 0x2724e4}, {pos = 557701808, events = 8, fd = 557701808, user_data = 0x8213dda68}, {pos = 32, events = 0, fd = 557701392, user_data = 0x227eedf00b83}} [14:32:22.898] last_touch_time = 1709821624 [14:32:22.898] last_lockfile_recheck_time = 1709821624 [14:32:22.898] nevents = 1 [14:32:22.898] #16 0x000000000082cd93 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8213de228) at ../src/backend/postmaster/postmaster.c:1468 [14:32:22.898] userDoption = [14:32:22.898] listen_addr_saved = false [14:32:22.898] output_config_variable = [14:32:22.898] opt = [14:32:22.898] status = [14:32:22.898] #17 0x000000000076a015 in main (argc=8, argv=0x8213de228) at ../src/backend/main/main.c:197 [14:32:22.898] do_check_root = [14:32:22.907] [14:32:22.907] [14:32:22.907] [14:32:22.965] dumping /tmp/cores/postgres.9091.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [14:32:23.090] [New LWP 100172] [14:32:23.165] Core was generated by `postgres: old_node: postgres regression [local] SELECT'. [14:32:23.165] Program terminated with signal SIGSEGV, Segmentation fault. [14:32:23.165] Address not mapped to object. [14:32:23.165] #0 equal (a=0x43669a78, b=b@entry=0x843666368) at ../src/backend/nodes/equalfuncs.c:239 [14:32:23.165] 239 if (nodeTag(a) != nodeTag(b)) [14:32:23.190] [14:32:23.190] Thread 1 (LWP 100172): [14:32:23.190] #0 equal (a=0x43669a78, b=b@entry=0x843666368) at ../src/backend/nodes/equalfuncs.c:239 [14:32:23.190] retval = [14:32:23.190] #1 0x000000000076d752 in list_member (list=0x843669ae8, datum=datum@entry=0x843666368) at ../src/backend/nodes/list.c:670 [14:32:23.190] cell__state = {l = 0x843669ae8, i = 0} [14:32:23.190] cell = 0x0 [14:32:23.190] cell__state = [14:32:23.190] #2 0x00000000007e10f5 in add_new_column_to_pathtarget (target=0x843669a08, expr=) at ../src/backend/optimizer/util/tlist.c:743 [14:32:23.190] No locals. [14:32:23.190] #3 add_new_columns_to_pathtarget (target=target@entry=0x843669a08, exprs=0x843669c18) at ../src/backend/optimizer/util/tlist.c:760 [14:32:23.190] expr = [14:32:23.190] lc__state = {l = 0x843669c18, i = 0} [14:32:23.190] lc = 0xfffffe3b [14:32:23.190] #4 0x00000000007b0b29 in make_group_input_target (root=0x835f83ae8, final_target=0x8436698a8) at ../src/backend/optimizer/plan/planner.c:5472 [14:32:23.190] parse = 0x84364ee10 [14:32:23.190] input_target = 0x843669a08 [14:32:23.190] non_group_cols = 0x843669bc8 [14:32:23.190] i = [14:32:23.190] lc = [14:32:23.190] non_group_vars = 0x843669c18 [14:32:23.190] #5 grouping_planner (root=root@entry=0x835f83ae8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [14:32:23.190] qp_extra = {activeWindows = 0x0, gset_data = 0x8436677b8} [14:32:23.190] activeWindows = 0x0 [14:32:23.190] sort_input_target_parallel_safe = false [14:32:23.190] grouping_target = 0x8436698a8 [14:32:23.190] scanjoin_target = [14:32:23.190] sort_input_targets = [14:32:23.190] wflists = 0x0 [14:32:23.190] gset_data = 0x8436677b8 [14:32:23.190] have_grouping = false [14:32:23.190] sort_input_targets_contain_srfs = [14:32:23.190] sort_input_target = 0x8436698a8 [14:32:23.190] grouping_target_parallel_safe = false [14:32:23.190] scanjoin_target_parallel_safe = [14:32:23.190] grouping_targets = [14:32:23.190] scanjoin_targets = [14:32:23.190] grouping_targets_contain_srfs = [14:32:23.190] scanjoin_targets_contain_srfs = [14:32:23.190] scanjoin_target_same_exprs = [14:32:23.190] extra = {limit_needed = 152, limit_tuples = 1.7534649400426467e-313, count_est = 72, offset_est = 34916007776} [14:32:23.190] parse = 0x84364ee10 [14:32:23.190] offset_est = [14:32:23.190] count_est = [14:32:23.190] limit_tuples = -1 [14:32:23.190] have_postponed_srfs = false [14:32:23.190] current_rel = 0x835f83ef8 [14:32:23.190] final_target = 0x8436698a8 [14:32:23.190] final_targets_contain_srfs = [14:32:23.190] final_targets = [14:32:23.190] final_rel = [14:32:23.190] lc = [14:32:23.190] final_target_parallel_safe = [14:32:23.190] #6 0x00000000007aea34 in subquery_planner (glob=glob@entry=0x843664060, parse=parse@entry=0x84364ee10, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [14:32:23.190] root = 0x835f83ae8 [14:32:23.190] hasOuterJoins = false [14:32:23.190] hasResultRTEs = false [14:32:23.190] l = [14:32:23.190] newWithCheckOptions = [14:32:23.190] newHaving = 0x0 [14:32:23.190] final_rel = [14:32:23.190] #7 0x00000000007ad558 in standard_planner (parse=0x84364ee10, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [14:32:23.190] glob = 0x843664060 [14:32:23.190] tuple_fraction = 0 [14:32:23.190] root = [14:32:23.190] final_rel = [14:32:23.190] best_path = [14:32:23.190] top_plan = [14:32:23.190] lp = [14:32:23.190] lr = [14:32:23.190] result = [14:32:23.190] #8 0x00000000007ad42c in planner (parse=0x43669a78, parse@entry=0x84364ee10, query_string=0x843666368 "\006", query_string@entry=0x835ea8100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=556269232, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [14:32:23.190] result = [14:32:23.190] #9 0x00000000008cfdd5 in pg_plan_query (querytree=querytree@entry=0x84364ee10, query_string=query_string@entry=0x835ea8100 "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 [14:32:23.190] plan = [14:32:23.190] #10 0x00000000008cfeb2 in pg_plan_queries (querytrees=0x843664010, query_string=query_string@entry=0x835ea8100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=556269232, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [14:32:23.190] query = 0x84364ee10 [14:32:23.190] stmt = [14:32:23.190] query_list__state = {l = 0x843664010, i = 0} [14:32:23.190] stmt_list = 0x0 [14:32:23.190] query_list = [14:32:23.190] #11 0x00000000008d404c in exec_simple_query (query_string=query_string@entry=0x835ea8100 "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 [14:32:23.190] cmdtaglen = [14:32:23.190] snapshot_set = [14:32:23.190] per_parsetree_context = 0x0 [14:32:23.190] plantree_list = [14:32:23.190] qc = {commandTag = 336, nprocessed = 6} [14:32:23.190] parsetree = 0x835fff600 [14:32:23.190] commandTag = [14:32:23.190] cmdtagname = [14:32:23.190] querytree_list = 0x0 [14:32:23.190] portal = [14:32:23.190] format = [14:32:23.190] receiver = [14:32:23.190] parsetree_item__state = {l = 0x835f80638, i = 0} [14:32:23.190] 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" [14:32:23.190] dest = DestRemote [14:32:23.190] was_logged = [14:32:23.190] oldcontext = 0x835eb4000 [14:32:23.190] parsetree_list = 0x835f80638 [14:32:23.190] use_implicit_block = false [14:32:23.190] parsetree_item = 0x835f80650 [14:32:23.190] save_log_statement_stats = [14:32:23.190] #12 0x00000000008d1f24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [14:32:23.190] query_string = 0x835ea8100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [14:32:23.190] input_message = {data = 0x835ea8100 "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} [14:32:23.190] firstchar = [14:32:23.190] local_sigjmp_buf = {{_sjb = {9245680, 34916008752, 34916008712, 34916009312, 11902728, 11849216, 8192, 8388608, 72057628953936767, 0, 0, 34359738369}}} [14:32:23.190] send_ready_for_query = false [14:32:23.190] idle_in_transaction_timeout_enabled = false [14:32:23.190] idle_session_timeout_enabled = false [14:32:23.190] #13 0x0000000000831755 in BackendRun (port=port@entry=0x835f5b000) at ../src/backend/postmaster/postmaster.c:4475 [14:32:23.190] No locals. [14:32:23.190] #14 0x000000000082fa8d in BackendStartup (port=0x835f5b000) at ../src/backend/postmaster/postmaster.c:4151 [14:32:23.190] bn = 0x835eb42b8 [14:32:23.190] pid = [14:32:23.190] __error = [14:32:23.190] __error = [14:32:23.190] __error = [14:32:23.190] save_errno = [14:32:23.190] __error = [14:32:23.190] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [14:32:23.190] port = 0x835f5b000 [14:32:23.190] i = 0 [14:32:23.190] now = [14:32:23.190] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 565646344, events = 8, fd = 565647368, user_data = 0x821b71c08}, {pos = 565649416, events = 8, fd = 565650440, user_data = 0x821b72808}, {pos = 565652488, events = 8, fd = 565653512, user_data = 0x821b73408}, {pos = 565674120, events = 8, fd = 556271720, user_data = 0x821280690}, {pos = 1968561571, events = 7158, fd = 0, user_data = 0x27259a}, {pos = 115249317, events = 0, fd = -25761258, user_data = 0x821b79038}, {pos = 1, events = 0, fd = 565654536, user_data = 0x82b1e24a8}, {pos = 556271976, events = 8, fd = 565654536, user_data = 0x21280680}, {pos = 723503460, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 565680696, events = 8, fd = 1, user_data = 0x821b73408}, {pos = 723417304, events = 8, fd = 556271528, user_data = 0x821280560}, {pos = 32, events = 18, fd = 723487844, user_data = 0x821b73408}, {pos = 565680696, events = 8, fd = 0, user_data = 0xa41}, {pos = 556271504, events = 8, fd = 1968535109, user_data = 0x82b1fc964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821b79a38}, {pos = 1, events = 0, fd = 565654536, user_data = 0x835e98000}, {pos = 1, events = 0, fd = 904495508, user_data = 0x0}, {pos = 556271456, events = 8, fd = 687705100, user_data = 0x1}, {pos = 904495104, events = 8, fd = 556271504, user_data = 0x828fd7eb4}, {pos = 725229920, events = 8, fd = 725229920, user_data = 0x82b2140c0}, {pos = 565654536, events = 8, fd = 556271728, user_data = 0x1bf67555742c}, {pos = 565653512, events = 8, fd = 1, user_data = 0x1bf6755572ae}, {pos = 12240, events = 0, fd = 556271512, user_data = 0x821280870}, {pos = 905275368, events = 8, fd = 556273120, user_data = 0x1bf67556ae90}, {pos = 565654536, events = 8, fd = 556270463, user_data = 0x82b34e4b2}, {pos = 565624840, events = 8, fd = 0, user_data = 0x821b73408}, {pos = 12240, events = 0, fd = 723353600, user_data = 0x1df950}, {pos = 725229920, events = 8, fd = 723487844, user_data = 0x3d00}, {pos = 556272912, events = 8, fd = 556271840, user_data = 0x82b29d18e }, {pos = 725268536, events = 8, fd = 556271780, user_data = 0x835f065da}, {pos = 556272912, events = 8, fd = 556271840, user_data = 0x82b2b3605}, {pos = 556271778, events = 8, fd = 556272912, user_data = 0x821280d10}, {pos = 0, events = 16777216, fd = 150972230, user_data = 0x821280d10}, {pos = 904947160, events = 8, fd = 556273120, user_data = 0x82b3ab838}, {pos = 0, events = 0, fd = 556272976, user_data = 0x82b2b370d}, {pos = 0, events = 0, fd = 0, user_data = 0x821280e80}, {pos = 904947160, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1bf67555e409}, {pos = 556272184, events = 8, fd = 723487844, user_data = 0x9c7}, {pos = 1968563209, events = 7158, fd = 556272216, user_data = 0x82b1f8c64}, {pos = 2758, events = 0, fd = 723460384, user_data = 0x8212809d8}, {pos = 565654536, events = 8, fd = 556272216, user_data = 0x82b1f2120}, {pos = 556272192, events = 8, fd = 1968542821, user_data = 0x0}, {pos = 0, events = 0, fd = 725369072, user_data = 0x82b1e8550}, {pos = 0, events = 0, fd = 0, user_data = 0x82b3b29b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x821280ac8}, {pos = 565674120, events = 8, fd = 1968563209, user_data = 0x821280b08}, {pos = 723487844, events = 8, fd = 2924, user_data = 0x82b1f23b8}, {pos = 556272264, events = 8, fd = 565654536, user_data = 0x821280b08}, {pos = 723461048, events = 8, fd = 556272368, user_data = 0x1bf675559465}, {pos = 565678136, events = 8, fd = 1, user_data = 0x821b73408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 556272776, events = 0, fd = 2565348, user_data = 0x821280cf0}, {pos = 556272880, events = 8, fd = 556272808, user_data = 0x1e}, {pos = 723424480, events = 8, fd = 556272536, user_data = 0x821b78248}, {pos = 556272984, events = 8, fd = 556272512, user_data = 0x1bf67555dda3}, {pos = 565678136, events = 8, fd = 2691288, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 565678136, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821280e58}, {pos = 565654536, events = 8, fd = 556272864, user_data = 0x2724e4}, {pos = 556273056, events = 8, fd = 556273056, user_data = 0x821280d58}, {pos = 32, events = 0, fd = 556272640, user_data = 0x1bf67555db83}} [14:32:23.190] last_touch_time = 1709821626 [14:32:23.190] last_lockfile_recheck_time = 1709821626 [14:32:23.190] nevents = 1 [14:32:23.190] #16 0x000000000082cd93 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821281518) at ../src/backend/postmaster/postmaster.c:1468 [14:32:23.190] userDoption = [14:32:23.190] listen_addr_saved = false [14:32:23.190] output_config_variable = [14:32:23.190] opt = [14:32:23.190] status = [14:32:23.190] #17 0x000000000076a015 in main (argc=4, argv=0x821281518) at ../src/backend/main/main.c:197 [14:32:23.190] do_check_root = [14:32:23.200] [14:32:23.200] [14:32:23.200] [14:32:23.260] dumping /tmp/cores/postgres.9809.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [14:32:23.388] [New LWP 101819] [14:32:23.455] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [14:32:23.455] Program terminated with signal SIGSEGV, Segmentation fault. [14:32:23.455] Address not mapped to object. [14:32:23.455] #0 equal (a=0x358f0cb0, b=b@entry=0x83585a678) at ../src/backend/nodes/equalfuncs.c:239 [14:32:23.455] 239 if (nodeTag(a) != nodeTag(b)) [14:32:24.053] [14:32:24.053] Thread 1 (LWP 101819): [14:32:24.053] #0 equal (a=0x358f0cb0, b=b@entry=0x83585a678) at ../src/backend/nodes/equalfuncs.c:239 [14:32:24.053] retval = [14:32:24.053] #1 0x000000000076d752 in list_member (list=0x8358f0d20, datum=datum@entry=0x83585a678) at ../src/backend/nodes/list.c:670 [14:32:24.053] cell__state = {l = 0x8358f0d20, i = 0} [14:32:24.053] cell = 0x0 [14:32:24.053] cell__state = [14:32:24.053] #2 0x00000000007e10f5 in add_new_column_to_pathtarget (target=0x8358f0c40, expr=) at ../src/backend/optimizer/util/tlist.c:743 [14:32:24.053] No locals. [14:32:24.053] #3 add_new_columns_to_pathtarget (target=target@entry=0x8358f0c40, exprs=0x8358f0dd8) at ../src/backend/optimizer/util/tlist.c:760 [14:32:24.053] expr = [14:32:24.053] lc__state = {l = 0x8358f0dd8, i = 0} [14:32:24.053] lc = 0xfffffe3b [14:32:24.053] #4 0x00000000007b0b29 in make_group_input_target (root=0x83585a038, final_target=0x8358f0b70) at ../src/backend/optimizer/plan/planner.c:5472 [14:32:24.053] parse = 0x838283a88 [14:32:24.053] input_target = 0x8358f0c40 [14:32:24.053] non_group_cols = 0x8358f0d88 [14:32:24.053] i = [14:32:24.053] lc = [14:32:24.053] non_group_vars = 0x8358f0dd8 [14:32:24.053] #5 grouping_planner (root=root@entry=0x83585a038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [14:32:24.053] qp_extra = {activeWindows = 0x0, gset_data = 0x83585a718} [14:32:24.053] activeWindows = 0x0 [14:32:24.053] sort_input_target_parallel_safe = false [14:32:24.053] grouping_target = 0x8358f0b70 [14:32:24.053] scanjoin_target = [14:32:24.053] sort_input_targets = [14:32:24.053] wflists = 0x0 [14:32:24.053] gset_data = 0x83585a718 [14:32:24.053] have_grouping = false [14:32:24.053] sort_input_targets_contain_srfs = [14:32:24.053] sort_input_target = 0x8358f0b70 [14:32:24.053] grouping_target_parallel_safe = false [14:32:24.053] scanjoin_target_parallel_safe = [14:32:24.053] grouping_targets = [14:32:24.053] scanjoin_targets = [14:32:24.053] grouping_targets_contain_srfs = [14:32:24.053] scanjoin_targets_contain_srfs = [14:32:24.053] scanjoin_target_same_exprs = [14:32:24.053] extra = {limit_needed = 16, limit_tuples = 1.7419613123806324e-313, count_est = 0, offset_est = 34917435568} [14:32:24.053] parse = 0x838283a88 [14:32:24.053] offset_est = [14:32:24.053] count_est = [14:32:24.053] limit_tuples = -1 [14:32:24.053] have_postponed_srfs = false [14:32:24.053] current_rel = 0x8358594c8 [14:32:24.053] final_target = 0x8358f0b70 [14:32:24.053] final_targets_contain_srfs = [14:32:24.053] final_targets = [14:32:24.053] final_rel = [14:32:24.053] lc = [14:32:24.053] final_target_parallel_safe = [14:32:24.053] #6 0x00000000007aea34 in subquery_planner (glob=glob@entry=0x8358d5ef8, parse=parse@entry=0x838283a88, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=1.7441046912853194e-313) at ../src/backend/optimizer/plan/planner.c:1084 [14:32:24.053] root = 0x83585a038 [14:32:24.053] hasOuterJoins = false [14:32:24.053] hasResultRTEs = false [14:32:24.053] l = [14:32:24.053] newWithCheckOptions = [14:32:24.053] newHaving = 0x0 [14:32:24.053] final_rel = [14:32:24.053] #7 0x00000000007ad558 in standard_planner (parse=0x838283a88, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [14:32:24.053] glob = 0x8358d5ef8 [14:32:24.053] tuple_fraction = 0 [14:32:24.053] root = [14:32:24.053] final_rel = [14:32:24.053] best_path = [14:32:24.053] top_plan = [14:32:24.053] lp = [14:32:24.053] lr = [14:32:24.053] result = [14:32:24.053] #8 0x00000000007ad42c in planner (parse=0x358f0cb0, parse@entry=0x838283a88, query_string=0x83585a678 "\006", query_string@entry=0x835840100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=557697008, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [14:32:24.053] result = [14:32:24.053] #9 0x00000000008cfdd5 in pg_plan_query (querytree=querytree@entry=0x838283a88, query_string=query_string@entry=0x835840100 "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 [14:32:24.053] plan = [14:32:24.053] #10 0x0000000000684513 in ExplainOneQuery (query=0x838283a88, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x8359db748, queryString=0x835840100 "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 [14:32:24.053] bufusage = {shared_blks_hit = 175, shared_blks_read = 310077013, shared_blks_dirtied = 34917436480, shared_blks_written = 35301897040, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 35301232544, temp_blks_written = 10789715, shared_blk_read_time = {ticks = 35301900888}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35301898888}, local_blk_write_time = {ticks = 35301898888}, temp_blk_read_time = {ticks = 34917436512}, temp_blk_write_time = {ticks = 10824784}} [14:32:24.053] saved_ctx = 0x0 [14:32:24.053] planstart = {ticks = -175310077013} [14:32:24.053] planduration = {ticks = 7784832} [14:32:24.053] bufusage_start = {shared_blks_hit = 34917436495, shared_blks_read = 0, shared_blks_dirtied = 35301899160, shared_blks_written = 35301899816, local_blks_hit = 34917436320, local_blks_read = 10576625, local_blks_dirtied = 70368744214742, local_blks_written = 0, temp_blks_read = 34917436352, temp_blks_written = 5653178, shared_blk_read_time = {ticks = 70368744214742}, shared_blk_write_time = {ticks = 1}, local_blk_read_time = {ticks = 34917436368}, local_blk_write_time = {ticks = 6201497}, temp_blk_read_time = {ticks = 34917436544}, temp_blk_write_time = {ticks = 8906971}} [14:32:24.053] mem_counters = {nblocks = 34917436288, freechunks = 9131541, totalspace = 34917436288, freespace = 35301232544} [14:32:24.053] planner_ctx = [14:32:24.053] plan = [14:32:24.053] #11 0x0000000000684032 in ExplainQuery (pstate=pstate@entry=0x8359db638, stmt=stmt@entry=0x838283a58, params=0x8358ef000, params@entry=0x0, dest=0x8359db5a8) at ../src/backend/commands/explain.c:293 [14:32:24.053] l__state = {l = , i = 0} [14:32:24.053] l = 0x8358d5cb0 [14:32:24.053] es = 0x8359db748 [14:32:24.053] jstate = [14:32:24.053] timing_set = false [14:32:24.053] summary_set = false [14:32:24.053] lc = [14:32:24.053] query = [14:32:24.053] rewritten = 0x8358d5c98 [14:32:24.053] tstate = [14:32:24.053] #12 0x00000000008d6edf in standard_ProcessUtility (pstmt=0x8382846d0, queryString=0x835840100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x8213dc7f0, queryEnv=0x0, dest=0x8359db5a8, qc=0x8213dce38) at ../src/backend/tcop/utility.c:863 [14:32:24.053] isAtomicContext = true [14:32:24.053] parsetree = 0x838283a58 [14:32:24.053] readonly_flags = [14:32:24.053] pstate = 0x8359db638 [14:32:24.053] isTopLevel = [14:32:24.053] #13 0x00000000008d680d in ProcessUtility (pstmt=0x358f0cb0, pstmt@entry=0x8382846d0, queryString=0x83585a678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x8358ef000, dest=0x8359db5a8, qc=0x8213dce38) at ../src/backend/tcop/utility.c:523 [14:32:24.053] No locals. [14:32:24.053] #14 0x00000000008d6333 in PortalRunUtility (portal=portal@entry=0x835915100, pstmt=0x8382846d0, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x8359db5a8, qc=qc@entry=0x8213dce38) at ../src/backend/tcop/pquery.c:1158 [14:32:24.053] No locals. [14:32:24.053] #15 0x00000000008d552a in FillPortalStore (portal=portal@entry=0x835915100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [14:32:24.053] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:32:24.053] treceiver = 0x8359db5a8 [14:32:24.053] #16 0x00000000008d5230 in PortalRun (portal=portal@entry=0x835915100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x838284830, altdest=altdest@entry=0x838284830, qc=0x8213dcf70) at ../src/backend/tcop/pquery.c:763 [14:32:24.053] _local_sigjmp_buf = {{_sjb = {9261519, 35258523696, 34917437032, 34917437264, 34917437040, 11893992, 11861776, 35258454272, -6347183290302266497, 35258462464, 3552332, 34359738368}}} [14:32:24.053] _save_exception_stack = 0x8213dd040 [14:32:24.053] _save_context_stack = 0x0 [14:32:24.053] _do_rethrow = false [14:32:24.053] saveTopTransactionResourceOwner = 0x835926030 [14:32:24.053] saveTopTransactionContext = 0x835a01000 [14:32:24.053] saveActivePortal = 0x0 [14:32:24.053] saveResourceOwner = 0x835926030 [14:32:24.053] savePortalContext = 0x0 [14:32:24.053] saveMemoryContext = 0x835a01000 [14:32:24.053] result = [14:32:24.053] nprocessed = [14:32:24.053] #17 0x00000000008d413b in exec_simple_query (query_string=query_string@entry=0x835840100 "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 [14:32:24.053] cmdtaglen = [14:32:24.053] snapshot_set = [14:32:24.053] per_parsetree_context = 0x0 [14:32:24.053] plantree_list = [14:32:24.053] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:32:24.053] parsetree = 0x835909c58 [14:32:24.053] commandTag = CMDTAG_EXPLAIN [14:32:24.053] cmdtagname = [14:32:24.053] querytree_list = [14:32:24.053] portal = 0x835915100 [14:32:24.053] format = 0 [14:32:24.053] receiver = 0x838284830 [14:32:24.053] parsetree_item__state = {l = 0x83590a4e0, i = 0} [14:32:24.053] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [14:32:24.053] dest = DestRemote [14:32:24.053] was_logged = [14:32:24.053] oldcontext = 0x835a01000 [14:32:24.053] parsetree_list = 0x83590a4e0 [14:32:24.053] use_implicit_block = false [14:32:24.053] parsetree_item = 0x83590a4f8 [14:32:24.053] save_log_statement_stats = [14:32:24.053] #18 0x00000000008d1f24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [14:32:24.053] query_string = 0x835840100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [14:32:24.053] input_message = {data = 0x835840100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [14:32:24.053] firstchar = [14:32:24.053] local_sigjmp_buf = {{_sjb = {9245680, 34917437504, 34917437464, 34917438064, 11902728, 11849216, 8192, 8388608, 72057628955313023, 0, 0, 34359738369}}} [14:32:24.053] send_ready_for_query = false [14:32:24.053] idle_in_transaction_timeout_enabled = false [14:32:24.053] idle_session_timeout_enabled = false [14:32:24.053] #19 0x0000000000831755 in BackendRun (port=port@entry=0x83591b000) at ../src/backend/postmaster/postmaster.c:4475 [14:32:24.053] No locals. [14:32:24.053] #20 0x000000000082fa8d in BackendStartup (port=0x83591b000) at ../src/backend/postmaster/postmaster.c:4151 [14:32:24.053] bn = 0x83584c0d8 [14:32:24.053] pid = [14:32:24.053] __error = [14:32:24.053] __error = [14:32:24.053] __error = [14:32:24.053] save_errno = [14:32:24.053] __error = [14:32:24.053] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [14:32:24.053] port = 0x83591b000 [14:32:24.053] i = 0 [14:32:24.053] now = [14:32:24.053] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 564933640, events = 8, fd = 564934664, user_data = 0x821ac3c08}, {pos = 564936712, events = 8, fd = 564937736, user_data = 0x821ac4808}, {pos = 564939784, events = 8, fd = 564940808, user_data = 0x821ac5408}, {pos = -1, events = 0, fd = 765940448, user_data = 0x8213dd360}, {pos = 765600169, events = 8, fd = 0, user_data = 0x1000}, {pos = -1710438277, events = 3269413265, fd = 765941736, user_data = 0x834c09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x833a20090}, {pos = 557700144, events = 8, fd = 765462828, user_data = 0x1000}, {pos = 764025188, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 564967992, events = 8, fd = 1, user_data = 0x821ac5408}, {pos = 763939032, events = 8, fd = 557700280, user_data = 0x8213dd270}, {pos = 32, events = 18, fd = 764009572, user_data = 0x821ac5408}, {pos = 564967992, events = 8, fd = 0, user_data = 0xa41}, {pos = 557700256, events = 8, fd = -303061435, user_data = 0x82d8a1964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821acba38}, {pos = 1, events = 0, fd = 564941832, user_data = 0x835830000}, {pos = 1, events = 0, fd = 897778068, user_data = 0x0}, {pos = 557700208, events = 8, fd = 729054220, user_data = 0x1}, {pos = 897777664, events = 8, fd = 557700256, user_data = 0x82b746eb4}, {pos = 765751648, events = 8, fd = 765751648, user_data = 0x82d8b90c0}, {pos = 564941832, events = 8, fd = 557700480, user_data = 0x227eedefa42c}, {pos = 866254992, events = 8, fd = 1, user_data = 0x227eedefa2ae}, {pos = 12240, events = 0, fd = 557700264, user_data = 0x8213dd580}, {pos = 898455528, events = 8, fd = 557701872, user_data = 0x227eedf0de90}, {pos = 564941832, events = 8, fd = 557646719, user_data = 0x82d9f359c}, {pos = 564912136, events = 8, fd = 0, user_data = 0x821ac5408}, {pos = 12240, events = 0, fd = 763875328, user_data = 0x1df950}, {pos = 765751648, events = 8, fd = 764009572, user_data = 0x3d00}, {pos = 557701664, events = 8, fd = 557700592, user_data = 0x82d94218e }, {pos = 765790264, events = 8, fd = 557700532, user_data = 0x8358955da}, {pos = 557701664, events = 8, fd = 557700592, user_data = 0x82d958605}, {pos = 557700530, events = 8, fd = 557701664, user_data = 0x8213dda20}, {pos = 0, events = 16777216, fd = -1710438277, user_data = 0x8213dda20}, {pos = 898192856, events = 8, fd = 557701872, user_data = 0x82da50838}, {pos = 0, events = 0, fd = 557701728, user_data = 0x82d95870d}, {pos = 0, events = 0, fd = 0, user_data = 0x8213ddb90}, {pos = 898192856, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x227eedf01409}, {pos = 557700936, events = 8, fd = 764009572, user_data = 0x9c7}, {pos = -303033335, events = 8830, fd = 557700968, user_data = 0x82d89dc64}, {pos = 2758, events = 0, fd = 763982112, user_data = 0x8213dd6e8}, {pos = 564941832, events = 8, fd = 557700968, user_data = 0x82d897120}, {pos = 557700944, events = 8, fd = -303053723, user_data = 0x0}, {pos = 0, events = 0, fd = 765890800, user_data = 0x82d88d550}, {pos = 0, events = 0, fd = 0, user_data = 0x82da579b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x8213dd7d8}, {pos = 564961416, events = 8, fd = -303033335, user_data = 0x8213dd818}, {pos = 764009572, events = 8, fd = 2924, user_data = 0x82d8973b8}, {pos = 557701016, events = 8, fd = 564941832, user_data = 0x8213dd818}, {pos = 763982776, events = 8, fd = 557701120, user_data = 0x227eedefc465}, {pos = 564965432, events = 8, fd = 1, user_data = 0x821ac5408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 557701528, events = 0, fd = 2565348, user_data = 0x8213dda00}, {pos = 557701632, events = 8, fd = 557701560, user_data = 0x1e}, {pos = 763946208, events = 8, fd = 557701288, user_data = 0x821aca248}, {pos = 557701736, events = 8, fd = 557701264, user_data = 0x227eedf00da3}, {pos = 564965432, events = 8, fd = 2691288, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 564965432, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8213ddb68}, {pos = 564941832, events = 8, fd = 557701616, user_data = 0x2724e4}, {pos = 557701808, events = 8, fd = 557701808, user_data = 0x8213dda68}, {pos = 32, events = 0, fd = 557701392, user_data = 0x227eedf00b83}} [14:32:24.053] last_touch_time = 1709821624 [14:32:24.053] last_lockfile_recheck_time = 1709821624 [14:32:24.053] nevents = 1 [14:32:24.053] #22 0x000000000082cd93 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8213de228) at ../src/backend/postmaster/postmaster.c:1468 [14:32:24.053] userDoption = [14:32:24.053] listen_addr_saved = false [14:32:24.053] output_config_variable = [14:32:24.053] opt = [14:32:24.053] status = [14:32:24.053] #23 0x000000000076a015 in main (argc=8, argv=0x8213de228) at ../src/backend/main/main.c:197 [14:32:24.053] do_check_root = [14:32:24.065] [14:32:24.065] [14:32:24.065] [14:32:24.126] dumping /tmp/cores/postgres.15658.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [14:32:24.256] [New LWP 100165] [14:32:24.328] Core was generated by `postgres: primary: postgres regression [local] SELECT'. [14:32:24.328] Program terminated with signal SIGSEGV, Segmentation fault. [14:32:24.328] Address not mapped to object. [14:32:24.328] #0 equal (a=0x3bdec7a8, b=b@entry=0x83bde9098) at ../src/backend/nodes/equalfuncs.c:239 [14:32:24.328] 239 if (nodeTag(a) != nodeTag(b)) [14:32:24.381] [14:32:24.381] Thread 1 (LWP 100165): [14:32:24.381] #0 equal (a=0x3bdec7a8, b=b@entry=0x83bde9098) at ../src/backend/nodes/equalfuncs.c:239 [14:32:24.381] retval = [14:32:24.381] #1 0x000000000076d752 in list_member (list=0x83bdec818, datum=datum@entry=0x83bde9098) at ../src/backend/nodes/list.c:670 [14:32:24.381] cell__state = {l = 0x83bdec818, i = 0} [14:32:24.381] cell = 0x0 [14:32:24.381] cell__state = [14:32:24.381] #2 0x00000000007e10f5 in add_new_column_to_pathtarget (target=0x83bdec738, expr=) at ../src/backend/optimizer/util/tlist.c:743 [14:32:24.381] No locals. [14:32:24.381] #3 add_new_columns_to_pathtarget (target=target@entry=0x83bdec738, exprs=0x83bdec948) at ../src/backend/optimizer/util/tlist.c:760 [14:32:24.381] expr = [14:32:24.381] lc__state = {l = 0x83bdec948, i = 0} [14:32:24.381] lc = 0xfffffe3b [14:32:24.381] #4 0x00000000007b0b29 in make_group_input_target (root=0x8359d49e0, final_target=0x83bdec5d8) at ../src/backend/optimizer/plan/planner.c:5472 [14:32:24.381] parse = 0x83bd05660 [14:32:24.381] input_target = 0x83bdec738 [14:32:24.381] non_group_cols = 0x83bdec8f8 [14:32:24.381] i = [14:32:24.381] lc = [14:32:24.381] non_group_vars = 0x83bdec948 [14:32:24.381] #5 grouping_planner (root=root@entry=0x8359d49e0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [14:32:24.381] qp_extra = {activeWindows = 0x0, gset_data = 0x83bdea4e8} [14:32:24.381] activeWindows = 0x0 [14:32:24.381] sort_input_target_parallel_safe = false [14:32:24.381] grouping_target = 0x83bdec5d8 [14:32:24.381] scanjoin_target = [14:32:24.381] sort_input_targets = [14:32:24.381] wflists = 0x0 [14:32:24.381] gset_data = 0x83bdea4e8 [14:32:24.381] have_grouping = false [14:32:24.381] sort_input_targets_contain_srfs = [14:32:24.381] sort_input_target = 0x83bdec5d8 [14:32:24.381] grouping_target_parallel_safe = false [14:32:24.381] scanjoin_target_parallel_safe = [14:32:24.381] grouping_targets = [14:32:24.381] scanjoin_targets = [14:32:24.381] grouping_targets_contain_srfs = [14:32:24.381] scanjoin_targets_contain_srfs = [14:32:24.381] scanjoin_target_same_exprs = [14:32:24.381] extra = {limit_needed = 200, limit_tuples = 1.7472228237650095e-313, count_est = 72, offset_est = 34911321776} [14:32:24.381] parse = 0x83bd05660 [14:32:24.381] offset_est = [14:32:24.381] count_est = [14:32:24.381] limit_tuples = -1 [14:32:24.381] have_postponed_srfs = false [14:32:24.381] current_rel = 0x83bdce448 [14:32:24.381] final_target = 0x83bdec5d8 [14:32:24.381] final_targets_contain_srfs = [14:32:24.381] final_targets = [14:32:24.381] final_rel = [14:32:24.381] lc = [14:32:24.381] final_target_parallel_safe = [14:32:24.381] #6 0x00000000007aea34 in subquery_planner (glob=glob@entry=0x83bde6980, parse=parse@entry=0x83bd05660, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [14:32:24.381] root = 0x8359d49e0 [14:32:24.381] hasOuterJoins = false [14:32:24.381] hasResultRTEs = false [14:32:24.381] l = [14:32:24.381] newWithCheckOptions = [14:32:24.381] newHaving = 0x0 [14:32:24.381] final_rel = [14:32:24.381] #7 0x00000000007ad558 in standard_planner (parse=0x83bd05660, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [14:32:24.381] glob = 0x83bde6980 [14:32:24.381] tuple_fraction = 0 [14:32:24.381] root = [14:32:24.381] final_rel = [14:32:24.381] best_path = [14:32:24.381] top_plan = [14:32:24.381] lp = [14:32:24.381] lr = [14:32:24.381] result = [14:32:24.381] #8 0x0000000838e316af in pgss_planner (parse=0x83bd05660, query_string=0x83bde9098 "\006", cursorOptions=551583232, boundParams=0xfffffe3b) at ../contrib/pg_stat_statements/pg_stat_statements.c:972 [14:32:24.381] _local_sigjmp_buf = {{_sjb = {35314144605, 11893992, 34911322360, 34911322816, 34911322400, 0, 35363247712, 34911323216, 35364143999, 35363245520, 34911322512, 0}}} [14:32:24.381] _save_exception_stack = 0x820e08450 [14:32:24.381] _save_context_stack = 0x0 [14:32:24.381] _do_rethrow = false [14:32:24.381] result = [14:32:24.381] #9 0x00000000007ad425 in planner (parse=0x3bdec7a8, parse@entry=0x83bd05660, query_string=0x83bde9098 "\006", query_string@entry=0x83589a100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=551583232, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [14:32:24.381] result = [14:32:24.381] #10 0x00000000008cfdd5 in pg_plan_query (querytree=querytree@entry=0x83bd05660, query_string=query_string@entry=0x83589a100 "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 [14:32:24.381] plan = [14:32:24.381] #11 0x00000000008cfeb2 in pg_plan_queries (querytrees=0x83bde6930, query_string=query_string@entry=0x83589a100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=551583232, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [14:32:24.381] query = 0x83bd05660 [14:32:24.381] stmt = [14:32:24.381] query_list__state = {l = 0x83bde6930, i = 0} [14:32:24.381] stmt_list = 0x0 [14:32:24.381] query_list = [14:32:24.381] #12 0x00000000008d404c in exec_simple_query (query_string=query_string@entry=0x83589a100 "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 [14:32:24.381] cmdtaglen = [14:32:24.381] snapshot_set = [14:32:24.381] per_parsetree_context = 0x0 [14:32:24.381] plantree_list = [14:32:24.381] qc = {commandTag = 336, nprocessed = 6} [14:32:24.381] parsetree = 0x8359d5600 [14:32:24.381] commandTag = [14:32:24.381] cmdtagname = [14:32:24.381] querytree_list = 0x0 [14:32:24.381] portal = [14:32:24.381] format = [14:32:24.381] receiver = [14:32:24.381] parsetree_item__state = {l = 0x83bdce078, i = 0} [14:32:24.381] 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" [14:32:24.381] dest = DestRemote [14:32:24.381] was_logged = [14:32:24.381] oldcontext = 0x8358a6000 [14:32:24.381] parsetree_list = 0x83bdce078 [14:32:24.381] use_implicit_block = false [14:32:24.381] parsetree_item = 0x83bdce090 [14:32:24.381] save_log_statement_stats = [14:32:24.381] #13 0x00000000008d1f24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [14:32:24.381] query_string = 0x83589a100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [14:32:24.381] input_message = {data = 0x83589a100 "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} [14:32:24.381] firstchar = [14:32:24.381] local_sigjmp_buf = {{_sjb = {9245680, 34911323216, 34911323176, 34911323776, 11902728, 11849216, 8192, 8388608, 72057628949218175, 0, 0, 1}}} [14:32:24.381] send_ready_for_query = false [14:32:24.381] idle_in_transaction_timeout_enabled = false [14:32:24.381] idle_session_timeout_enabled = false [14:32:24.381] #14 0x0000000000831755 in BackendRun (port=port@entry=0x835977000) at ../src/backend/postmaster/postmaster.c:4475 [14:32:24.381] No locals. [14:32:24.381] #15 0x000000000082fa8d in BackendStartup (port=0x835977000) at ../src/backend/postmaster/postmaster.c:4151 [14:32:24.381] bn = 0x8358a6218 [14:32:24.381] pid = [14:32:24.381] __error = [14:32:24.381] __error = [14:32:24.381] __error = [14:32:24.381] save_errno = [14:32:24.381] __error = [14:32:24.381] #16 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [14:32:24.381] port = 0x835977000 [14:32:24.381] i = 0 [14:32:24.381] now = [14:32:24.381] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 552656904, user_data = 0x0}, {pos = 552658952, events = 8, fd = 552659976, user_data = 0x820f0f008}, {pos = 552662024, events = 8, fd = 552681608, user_data = 0x820e08988}, {pos = 551585696, events = 8, fd = -456069725, user_data = 0x820f0f408}, {pos = 2565530, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 552685624, events = 8, fd = 1, user_data = 0x820f0f408}, {pos = 746210472, events = 8, fd = 551586440, user_data = 0x820f0f408}, {pos = 551585664, events = 0, fd = 2565348, user_data = 0x820e089d0}, {pos = 746318180, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 552688184, events = 8, fd = 1, user_data = 0x820f0f408}, {pos = 746232024, events = 8, fd = 551585992, user_data = 0x820e08670}, {pos = 33, events = 18, fd = 746302564, user_data = 0x820f0f408}, {pos = 552688184, events = 8, fd = 0, user_data = 0xa41}, {pos = 551585968, events = 8, fd = -456096187, user_data = 0x82c7be964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x820f15a38}, {pos = 1, events = 0, fd = 552662024, user_data = 0x83588a000}, {pos = 1, events = 0, fd = 898146708, user_data = 0x0}, {pos = 551585920, events = 8, fd = 723491852, user_data = 0x1}, {pos = 898146304, events = 8, fd = 551585968, user_data = 0x82b1f8eb4}, {pos = 748044640, events = 8, fd = 748044640, user_data = 0x82c7d60c0}, {pos = 552662024, events = 8, fd = 551586192, user_data = 0xe2be4d0842c}, {pos = 80627796, events = 0, fd = 1, user_data = 0xe2be4d082ae}, {pos = 12240, events = 0, fd = 551585976, user_data = 0x820e08990}, {pos = 898942952, events = 8, fd = 551587584, user_data = 0xe2be4d1be90}, {pos = 552662024, events = 8, fd = 551551871, user_data = 0x82c9104b2}, {pos = 551586496, events = 8, fd = 0, user_data = 0x820f0f408}, {pos = 12240, events = 0, fd = 746168320, user_data = 0x1df950}, {pos = 748044640, events = 8, fd = 746302564, user_data = 0x3d00}, {pos = 551587376, events = 8, fd = 551586304, user_data = 0x82c85f18e }, {pos = 748083256, events = 8, fd = 551586244, user_data = 0x8358f15da}, {pos = 551587376, events = 8, fd = 551586304, user_data = 0x82c875605}, {pos = 551586242, events = 8, fd = 551587376, user_data = 0x820e08e30}, {pos = 0, events = 16777216, fd = 1229971213, user_data = 0x820e08e30}, {pos = 898569688, events = 8, fd = 551587584, user_data = 0x82c96d838}, {pos = 0, events = 0, fd = 551587440, user_data = 0x82c87570d}, {pos = 0, events = 0, fd = 0, user_data = 0x820e08fa0}, {pos = 898569688, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -456068087, events = 3627, fd = 551586632, user_data = 0x82c7bac64}, {pos = 2503, events = 0, fd = -456068087, user_data = 0x820e08b68}, {pos = 746302564, events = 8, fd = 2758, user_data = 0x82c7b4120}, {pos = 551586536, events = 8, fd = 552662024, user_data = 0x820e08b68}, {pos = 746275104, events = 8, fd = 551586640, user_data = 0xe2be4d0a465}, {pos = 0, events = 0, fd = 0, user_data = 0x820e08b40}, {pos = 746235216, events = 8, fd = 0, user_data = 0x0}, {pos = 551586592, events = 8, fd = 16, user_data = 0x0}, {pos = 551586776, events = 8, fd = 552681608, user_data = 0xe2be4d0f409}, {pos = 551586840, events = 8, fd = 746302564, user_data = 0xb6c}, {pos = 746275768, events = 8, fd = 551586712, user_data = 0x820f0f408}, {pos = 551586840, events = 8, fd = 746275768, user_data = 0x820e08c00}, {pos = -456088475, events = 3627, fd = 552685624, user_data = 0x800000001}, {pos = 552662024, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 551587240, user_data = 0x2724e4}, {pos = 551587344, events = 8, fd = 551587344, user_data = 0x820e08dc8}, {pos = 31, events = 0, fd = 0, user_data = 0x820e08ca8}, {pos = 552683400, events = 8, fd = 551587448, user_data = 0x820e08c90}, {pos = -456069725, events = 3627, fd = 552685624, user_data = 0x2910d8}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x820f15038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 551587704, events = 8, fd = 0, user_data = 0x320e08e00}, {pos = 552683496, events = 8, fd = 551587520, user_data = 0x290}, {pos = 551587448, events = 8, fd = 551586984, user_data = 0x820e08d10}, {pos = -456070099, events = 3627, fd = 552650760, user_data = 0x0}} [14:32:24.381] last_touch_time = 1709821688 [14:32:24.381] last_lockfile_recheck_time = 1709821688 [14:32:24.381] nevents = 1 [14:32:24.381] #17 0x000000000082cd93 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820e09638) at ../src/backend/postmaster/postmaster.c:1468 [14:32:24.381] userDoption = [14:32:24.381] listen_addr_saved = false [14:32:24.381] output_config_variable = [14:32:24.381] opt = [14:32:24.381] status = [14:32:24.381] #18 0x000000000076a015 in main (argc=4, argv=0x820e09638) at ../src/backend/main/main.c:197 [14:32:24.381] do_check_root = [14:32:24.390] [14:32:24.390] [14:32:24.390] [14:32:24.452] dumping /tmp/cores/postgres.18882.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [14:32:24.580] [New LWP 101795] [14:32:24.654] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT'. [14:32:24.654] Program terminated with signal SIGSEGV, Segmentation fault. [14:32:24.654] Address not mapped to object. [14:32:24.654] #0 get_expr_width (root=root@entry=0x842c527c0, expr=expr@entry=0x42d09e70) at ../src/backend/optimizer/path/costsize.c:6328 [14:32:24.654] 6328 if (IsA(expr, Var)) [14:32:24.677] [14:32:24.677] Thread 1 (LWP 101795): [14:32:24.677] #0 get_expr_width (root=root@entry=0x842c527c0, expr=expr@entry=0x42d09e70) at ../src/backend/optimizer/path/costsize.c:6328 [14:32:24.677] width = [14:32:24.677] #1 0x00000000007884e5 in set_pathtarget_cost_width (root=root@entry=0x842c527c0, target=target@entry=0x842d09e00) at ../src/backend/optimizer/path/costsize.c:6299 [14:32:24.677] node = 0x42d09e70 [14:32:24.677] lc__state = {l = 0x842d09ee0, i = 0} [14:32:24.677] tuple_width = 0 [14:32:24.677] lc = 0x842d09ef8 [14:32:24.677] #2 0x00000000007b0b44 in make_group_input_target (root=0x842c527c0, final_target=0x842d09d40) at ../src/backend/optimizer/plan/planner.c:5479 [14:32:24.677] parse = 0x842c55bf0 [14:32:24.677] input_target = 0x842d09e00 [14:32:24.677] non_group_cols = 0x0 [14:32:24.677] i = [14:32:24.677] lc = [14:32:24.677] non_group_vars = 0x0 [14:32:24.677] #3 grouping_planner (root=root@entry=0x842c527c0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [14:32:24.677] qp_extra = {activeWindows = 0x0, gset_data = 0x842d069f8} [14:32:24.677] activeWindows = 0x0 [14:32:24.677] sort_input_target_parallel_safe = false [14:32:24.677] grouping_target = 0x842d09d40 [14:32:24.677] scanjoin_target = [14:32:24.677] sort_input_targets = [14:32:24.677] wflists = 0x0 [14:32:24.677] gset_data = 0x842d069f8 [14:32:24.677] have_grouping = false [14:32:24.677] sort_input_targets_contain_srfs = [14:32:24.677] sort_input_target = 0x842d09d40 [14:32:24.677] grouping_target_parallel_safe = false [14:32:24.677] scanjoin_target_parallel_safe = [14:32:24.677] grouping_targets = [14:32:24.677] scanjoin_targets = [14:32:24.677] grouping_targets_contain_srfs = [14:32:24.677] scanjoin_targets_contain_srfs = [14:32:24.677] scanjoin_target_same_exprs = [14:32:24.677] extra = {limit_needed = 144, limit_tuples = 1.725205739630902e-313, count_est = 16, offset_est = 34918552944} [14:32:24.677] parse = 0x842c55bf0 [14:32:24.677] offset_est = [14:32:24.677] count_est = [14:32:24.677] limit_tuples = -1 [14:32:24.677] have_postponed_srfs = false [14:32:24.677] current_rel = 0x842d08330 [14:32:24.677] final_target = 0x842d09d40 [14:32:24.677] final_targets_contain_srfs = [14:32:24.677] final_targets = [14:32:24.677] final_rel = [14:32:24.677] lc = [14:32:24.677] final_target_parallel_safe = [14:32:24.677] #4 0x00000000007aea34 in subquery_planner (glob=glob@entry=0x842c57518, parse=parse@entry=0x842c55bf0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [14:32:24.677] root = 0x842c527c0 [14:32:24.677] hasOuterJoins = false [14:32:24.677] hasResultRTEs = false [14:32:24.677] l = [14:32:24.677] newWithCheckOptions = [14:32:24.677] newHaving = 0x0 [14:32:24.677] final_rel = [14:32:24.677] #5 0x00000000007ad558 in standard_planner (parse=0x842c55bf0, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [14:32:24.677] glob = 0x842c57518 [14:32:24.677] tuple_fraction = 0 [14:32:24.677] root = [14:32:24.677] final_rel = [14:32:24.677] best_path = [14:32:24.677] top_plan = [14:32:24.677] lp = [14:32:24.677] lr = [14:32:24.677] result = [14:32:24.677] #6 0x00000008378f0712 in pgss_planner (parse=0x842c55bf0, query_string=0x834e41100 "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=0x842d09ef8) at ../contrib/pg_stat_statements/pg_stat_statements.c:926 [14:32:24.677] _local_sigjmp_buf = {{_sjb = {35291858543, 35247100160, 34918553528, 34918553984, 11893992, 35479968752, 34918553696, 0, 34918499199, 11080661, 2, 34359738368}}} [14:32:24.677] _save_exception_stack = 0x8214edb10 [14:32:24.677] _save_context_stack = 0x0 [14:32:24.677] _do_rethrow = false [14:32:24.677] bufusage = {shared_blks_hit = 35291858543, shared_blks_read = 35247100160, shared_blks_dirtied = 34918553528, shared_blks_written = 34918553984, local_blks_hit = 11893992, local_blks_read = 35479968752, local_blks_dirtied = 34918553696, local_blks_written = 0, temp_blks_read = 34918499199, temp_blks_written = 11080661, shared_blk_read_time = {ticks = 2}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 34918553840}, local_blk_write_time = {ticks = 11109647}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 35479974936}} [14:32:24.677] walusage_start = {wal_records = 1346, wal_fpi = 2, wal_bytes = 170363} [14:32:24.677] duration = [14:32:24.677] bufusage_start = {shared_blks_hit = 27809, 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}} [14:32:24.677] walusage = {wal_records = 35479968752, wal_fpi = 35480765688, wal_bytes = 34918553904} [14:32:24.677] start = [14:32:24.677] result = [14:32:24.677] #7 0x00000000007ad425 in planner (parse=0x842c527c0, parse@entry=0x842c55bf0, query_string=0x42d09e70 , query_string@entry=0x834e41100 "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=0x842d09ef8, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [14:32:24.677] result = [14:32:24.677] #8 0x00000000008cfdd5 in pg_plan_query (querytree=querytree@entry=0x842c55bf0, query_string=query_string@entry=0x834e41100 "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 [14:32:24.677] plan = [14:32:24.677] #9 0x00000000008cfeb2 in pg_plan_queries (querytrees=0x842c574c8, query_string=query_string@entry=0x834e41100 "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=0x842d09ef8, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [14:32:24.677] query = 0x842c55bf0 [14:32:24.677] stmt = [14:32:24.677] query_list__state = {l = 0x842c574c8, i = 0} [14:32:24.677] stmt_list = 0x0 [14:32:24.677] query_list = [14:32:24.677] #10 0x00000000008d404c in exec_simple_query (query_string=query_string@entry=0x834e41100 "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 [14:32:24.677] cmdtaglen = [14:32:24.677] snapshot_set = [14:32:24.677] per_parsetree_context = 0x0 [14:32:24.677] plantree_list = [14:32:24.677] qc = {commandTag = 336, nprocessed = 6} [14:32:24.677] parsetree = 0x842cc5cb0 [14:32:24.677] commandTag = [14:32:24.677] cmdtagname = [14:32:24.677] querytree_list = 0x0 [14:32:24.677] portal = [14:32:24.677] format = [14:32:24.677] receiver = [14:32:24.677] parsetree_item__state = {l = 0x842d184a8, i = 0} [14:32:24.677] 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" [14:32:24.677] dest = DestRemote [14:32:24.677] was_logged = [14:32:24.677] oldcontext = 0x834e4d000 [14:32:24.677] parsetree_list = 0x842d184a8 [14:32:24.677] use_implicit_block = false [14:32:24.677] parsetree_item = 0x842d184c0 [14:32:24.677] save_log_statement_stats = [14:32:24.677] #11 0x00000000008d1f24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [14:32:24.677] query_string = 0x834e41100 "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;" [14:32:24.677] input_message = {data = 0x834e41100 "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} [14:32:24.677] firstchar = [14:32:24.677] local_sigjmp_buf = {{_sjb = {9245680, 34918554384, 34918554344, 34918554944, 11902728, 11849216, 8192, 8388608, 72057628956427135, 0, 0, 34359738369}}} [14:32:24.677] send_ready_for_query = false [14:32:24.677] idle_in_transaction_timeout_enabled = false [14:32:24.677] idle_session_timeout_enabled = false [14:32:24.677] #12 0x0000000000831755 in BackendRun (port=port@entry=0x834f17000) at ../src/backend/postmaster/postmaster.c:4475 [14:32:24.677] No locals. [14:32:24.677] #13 0x000000000082fa8d in BackendStartup (port=0x834f17000) at ../src/backend/postmaster/postmaster.c:4151 [14:32:24.677] bn = 0x834e4d238 [14:32:24.677] pid = [14:32:24.677] __error = [14:32:24.677] __error = [14:32:24.677] __error = [14:32:24.677] save_errno = [14:32:24.677] __error = [14:32:24.677] #14 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [14:32:24.677] port = 0x834f17000 [14:32:24.677] i = 0 [14:32:24.677] now = [14:32:24.677] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 561347592, events = 8, fd = 561348616, user_data = 0x821758408}, {pos = 561350664, events = 8, fd = 561351688, user_data = 0x821759008}, {pos = 561353736, events = 8, fd = 885038048, user_data = 0xa0}, {pos = -1, events = 0, fd = 737751776, user_data = 0x8214ede30}, {pos = 737411497, events = 8, fd = 0, user_data = 0x1000}, {pos = -973294625, events = 1980917212, fd = 737753064, user_data = 0x834c09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x8324ec090}, {pos = 558817024, events = 8, fd = 737274156, user_data = 0x1000}, {pos = 735836516, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 561379896, events = 8, fd = 1, user_data = 0x821759408}, {pos = 735750360, events = 8, fd = 558817160, user_data = 0x8214edd30}, {pos = 33, events = 18, fd = 735820900, user_data = 0x821759408}, {pos = 561379896, events = 8, fd = 0, user_data = 0xa41}, {pos = 558817136, events = 8, fd = 551601733, user_data = 0x82bdbf964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x82175fa38}, {pos = 1, events = 0, fd = 561353736, user_data = 0x834e31000}, {pos = 1, events = 0, fd = 887296404, user_data = 0x0}, {pos = 558817088, events = 8, fd = 729086988, user_data = 0x1}, {pos = 887296000, events = 8, fd = 558817136, user_data = 0x82b74eeb4}, {pos = 737562976, events = 8, fd = 737562976, user_data = 0x82bdd70c0}, {pos = 561353736, events = 8, fd = 558817360, user_data = 0x38b720e0c42c}, {pos = 844021904, events = 8, fd = 1, user_data = 0x38b720e0c2ae}, {pos = 12240, events = 0, fd = 558817144, user_data = 0x8214ee050}, {pos = 887953384, events = 8, fd = 558818752, user_data = 0x38b720e1fe90}, {pos = 561353736, events = 8, fd = 558760831, user_data = 0x82bf1159c}, {pos = 558817664, events = 8, fd = 0, user_data = 0x821759408}, {pos = 12240, events = 0, fd = 735686656, user_data = 0x1df950}, {pos = 737562976, events = 8, fd = 735820900, user_data = 0x3d00}, {pos = 558818544, events = 8, fd = 558817472, user_data = 0x82be6018e }, {pos = 737601592, events = 8, fd = 558817412, user_data = 0x834e915da}, {pos = 558818544, events = 8, fd = 558817472, user_data = 0x82be76605}, {pos = 558817410, events = 8, fd = 558818544, user_data = 0x8214ee4f0}, {pos = 0, events = 16777216, fd = -973294625, user_data = 0x8214ee4f0}, {pos = 887690712, events = 8, fd = 558818752, user_data = 0x82bf6e838}, {pos = 0, events = 0, fd = 558818608, user_data = 0x82be7670d}, {pos = 0, events = 0, fd = 0, user_data = 0x8214ee660}, {pos = 887690712, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 551629833, events = 14519, fd = 558817800, user_data = 0x82bdbbc64}, {pos = 2503, events = 0, fd = 551629833, user_data = 0x8214ee228}, {pos = 735820900, events = 8, fd = 2758, user_data = 0x82bdb5120}, {pos = 558817704, events = 8, fd = 561353736, user_data = 0x8214ee228}, {pos = 735793440, events = 8, fd = 558817808, user_data = 0x38b720e0e465}, {pos = 0, events = 0, fd = 0, user_data = 0x8214ee200}, {pos = 735753552, events = 8, fd = 0, user_data = 0x0}, {pos = 558817760, events = 8, fd = 16, user_data = 0x0}, {pos = 558817944, events = 8, fd = 561373320, user_data = 0x38b720e13409}, {pos = 558818008, events = 8, fd = 735820900, user_data = 0xb6c}, {pos = 735794104, events = 8, fd = 558817880, user_data = 0x821759408}, {pos = 558818008, events = 8, fd = 735794104, user_data = 0x8214ee2c0}, {pos = 551609445, events = 14519, fd = 561377336, user_data = 0x800000001}, {pos = 561353736, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 558818408, user_data = 0x2724e4}, {pos = 558818512, events = 8, fd = 558818512, user_data = 0x8214ee488}, {pos = 31, events = 0, fd = 0, user_data = 0x8214ee368}, {pos = 561375112, events = 8, fd = 558818616, user_data = 0x8214ee350}, {pos = 551628195, events = 14519, fd = 561377336, user_data = 0x2910d8}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82175f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558818872, events = 8, fd = 0, user_data = 0x3214ee4c0}, {pos = 561375208, events = 8, fd = 558818688, user_data = 0x290}, {pos = 558818616, events = 8, fd = 558818152, user_data = 0x8214ee3d0}, {pos = 551627821, events = 14519, fd = 561342472, user_data = 0x0}} [14:32:24.678] last_touch_time = 1709821726 [14:32:24.678] last_lockfile_recheck_time = 1709821726 [14:32:24.678] nevents = 1 [14:32:24.678] #15 0x000000000082cd93 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214eecf0) at ../src/backend/postmaster/postmaster.c:1468 [14:32:24.678] userDoption = [14:32:24.678] listen_addr_saved = false [14:32:24.678] output_config_variable = [14:32:24.678] opt = [14:32:24.678] status = [14:32:24.678] #16 0x000000000076a015 in main (argc=8, argv=0x8214eecf0) at ../src/backend/main/main.c:197 [14:32:24.678] do_check_root = [14:32:24.686] [14:32:24.686] [14:32:24.686] [14:32:24.750] dumping /tmp/cores/postgres.19053.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [14:32:24.875] [New LWP 100179] [14:32:24.953] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN'. [14:32:24.953] Program terminated with signal SIGSEGV, Segmentation fault. [14:32:24.953] Address not mapped to object. [14:32:24.953] #0 equal (a=0x354ae0d8, b=b@entry=0x835452678) at ../src/backend/nodes/equalfuncs.c:239 [14:32:24.953] 239 if (nodeTag(a) != nodeTag(b)) [14:32:25.556] [14:32:25.556] Thread 1 (LWP 100179): [14:32:25.556] #0 equal (a=0x354ae0d8, b=b@entry=0x835452678) at ../src/backend/nodes/equalfuncs.c:239 [14:32:25.556] retval = [14:32:25.556] #1 0x000000000076d752 in list_member (list=0x8354ae148, datum=datum@entry=0x835452678) at ../src/backend/nodes/list.c:670 [14:32:25.556] cell__state = {l = 0x8354ae148, i = 0} [14:32:25.556] cell = 0x0 [14:32:25.556] cell__state = [14:32:25.556] #2 0x00000000007e10f5 in add_new_column_to_pathtarget (target=0x8354ae088, expr=) at ../src/backend/optimizer/util/tlist.c:743 [14:32:25.556] No locals. [14:32:25.556] #3 add_new_columns_to_pathtarget (target=target@entry=0x8354ae088, exprs=0x8354ae1e8) at ../src/backend/optimizer/util/tlist.c:760 [14:32:25.556] expr = [14:32:25.556] lc__state = {l = 0x8354ae1e8, i = 0} [14:32:25.556] lc = 0xfffffe3b [14:32:25.556] #4 0x00000000007b0b29 in make_group_input_target (root=0x835452038, final_target=0x842a1afa8) at ../src/backend/optimizer/plan/planner.c:5472 [14:32:25.556] parse = 0x842a557e0 [14:32:25.556] input_target = 0x8354ae088 [14:32:25.556] non_group_cols = 0x8354ae198 [14:32:25.556] i = [14:32:25.556] lc = [14:32:25.556] non_group_vars = 0x8354ae1e8 [14:32:25.556] #5 grouping_planner (root=root@entry=0x835452038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [14:32:25.556] qp_extra = {activeWindows = 0x0, gset_data = 0x8354528a8} [14:32:25.556] activeWindows = 0x0 [14:32:25.556] sort_input_target_parallel_safe = false [14:32:25.556] grouping_target = 0x842a1afa8 [14:32:25.556] scanjoin_target = [14:32:25.556] sort_input_targets = [14:32:25.556] wflists = 0x0 [14:32:25.556] gset_data = 0x8354528a8 [14:32:25.556] have_grouping = false [14:32:25.556] sort_input_targets_contain_srfs = [14:32:25.556] sort_input_target = 0x842a1afa8 [14:32:25.556] grouping_target_parallel_safe = false [14:32:25.556] scanjoin_target_parallel_safe = [14:32:25.556] grouping_targets = [14:32:25.556] scanjoin_targets = [14:32:25.556] grouping_targets_contain_srfs = [14:32:25.556] scanjoin_targets_contain_srfs = [14:32:25.556] scanjoin_target_same_exprs = [14:32:25.556] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 34919880144} [14:32:25.556] parse = 0x842a557e0 [14:32:25.556] offset_est = [14:32:25.556] count_est = [14:32:25.556] limit_tuples = -1 [14:32:25.556] have_postponed_srfs = false [14:32:25.556] current_rel = 0x835492dd8 [14:32:25.556] final_target = 0x842a1afa8 [14:32:25.556] final_targets_contain_srfs = [14:32:25.556] final_targets = [14:32:25.556] final_rel = [14:32:25.556] lc = [14:32:25.556] final_target_parallel_safe = [14:32:25.556] #6 0x00000000007aea34 in subquery_planner (glob=glob@entry=0x835492998, parse=parse@entry=0x842a557e0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [14:32:25.556] root = 0x835452038 [14:32:25.556] hasOuterJoins = false [14:32:25.556] hasResultRTEs = false [14:32:25.556] l = [14:32:25.556] newWithCheckOptions = [14:32:25.556] newHaving = 0x0 [14:32:25.556] final_rel = [14:32:25.556] #7 0x00000000007ad558 in standard_planner (parse=0x842a557e0, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [14:32:25.556] glob = 0x835492998 [14:32:25.556] tuple_fraction = 0 [14:32:25.556] root = [14:32:25.556] final_rel = [14:32:25.556] best_path = [14:32:25.556] top_plan = [14:32:25.556] lp = [14:32:25.556] lr = [14:32:25.556] result = [14:32:25.556] #8 0x00000000007ad42c in planner (parse=0x354ae0d8, parse@entry=0x842a557e0, query_string=0x835452678 "\006", query_string@entry=0x8353f6100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=560141584, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [14:32:25.556] result = [14:32:25.556] #9 0x00000000008cfdd5 in pg_plan_query (querytree=querytree@entry=0x842a557e0, query_string=query_string@entry=0x8353f6100 "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 [14:32:25.556] plan = [14:32:25.556] #10 0x0000000000684513 in ExplainOneQuery (query=0x842a557e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x835404748, queryString=0x8353f6100 "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 [14:32:25.556] bufusage = {shared_blks_hit = 262, shared_blks_read = 338929702, shared_blks_dirtied = 34919881056, shared_blks_written = 35477869385, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = -7190060735009890023, local_blks_written = 34919881084, temp_blks_read = -1, temp_blks_written = 10789715, shared_blk_read_time = {ticks = 35477873296}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35477870560}, local_blk_write_time = {ticks = 35477870560}, temp_blk_read_time = {ticks = 34919881088}, temp_blk_write_time = {ticks = 10824784}} [14:32:25.556] saved_ctx = 0x0 [14:32:25.556] planstart = {ticks = -262338929702} [14:32:25.556] planduration = {ticks = 7784832} [14:32:25.556] bufusage_start = {shared_blks_hit = 1, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 34919880896, local_blks_read = 10576625, local_blks_dirtied = 70368744194107, local_blks_written = 0, temp_blks_read = 34919880928, temp_blks_written = 5653178, shared_blk_read_time = {ticks = 70368744194107}, shared_blk_write_time = {ticks = 35477870560}, local_blk_read_time = {ticks = 34919880944}, local_blk_write_time = {ticks = 6201497}, temp_blk_read_time = {ticks = 34919881120}, temp_blk_write_time = {ticks = 8906789}} [14:32:25.556] mem_counters = {nblocks = 34919880864, freechunks = 9131541, totalspace = 34919880864, freespace = 35556390376} [14:32:25.556] planner_ctx = [14:32:25.556] plan = [14:32:25.556] #11 0x0000000000684032 in ExplainQuery (pstate=pstate@entry=0x835404638, stmt=stmt@entry=0x842a557b0, params=0x8354ae000, params@entry=0x0, dest=0x8354045a8) at ../src/backend/commands/explain.c:293 [14:32:25.556] l__state = {l = , i = 0} [14:32:25.556] l = 0x8354924b0 [14:32:25.556] es = 0x835404748 [14:32:25.556] jstate = [14:32:25.556] timing_set = false [14:32:25.556] summary_set = false [14:32:25.556] lc = [14:32:25.556] query = [14:32:25.556] rewritten = 0x835492498 [14:32:25.556] tstate = [14:32:25.556] #12 0x00000000008d6edf in standard_ProcessUtility (pstmt=0x8355a98e8, queryString=0x8353f6100 "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=0x821631510, queryEnv=0x0, dest=0x8354045a8, qc=0x821631b58) at ../src/backend/tcop/utility.c:863 [14:32:25.556] isAtomicContext = true [14:32:25.556] parsetree = 0x842a557b0 [14:32:25.556] readonly_flags = [14:32:25.556] pstate = 0x835404638 [14:32:25.556] isTopLevel = [14:32:25.556] #13 0x00000000008d680d in ProcessUtility (pstmt=0x354ae0d8, pstmt@entry=0x8355a98e8, queryString=0x835452678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x8354ae000, dest=0x8354045a8, qc=0x821631b58) at ../src/backend/tcop/utility.c:523 [14:32:25.556] No locals. [14:32:25.556] #14 0x00000000008d6333 in PortalRunUtility (portal=portal@entry=0x8354cb100, pstmt=0x8355a98e8, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x8354045a8, qc=qc@entry=0x821631b58) at ../src/backend/tcop/pquery.c:1158 [14:32:25.556] No locals. [14:32:25.556] #15 0x00000000008d552a in FillPortalStore (portal=portal@entry=0x8354cb100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [14:32:25.556] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:32:25.556] treceiver = 0x8354045a8 [14:32:25.556] #16 0x00000000008d5230 in PortalRun (portal=portal@entry=0x8354cb100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x8355a9a48, altdest=altdest@entry=0x8355a9a48, qc=0x821631c90) at ../src/backend/tcop/pquery.c:763 [14:32:25.556] _local_sigjmp_buf = {{_sjb = {9261519, 35254007808, 34919881608, 34919881840, 34919881616, 11893992, 11861776, 35253956864, -6347183290299776129, 35253965056, 3552332, 34359738368}}} [14:32:25.556] _save_exception_stack = 0x821631d60 [14:32:25.556] _save_context_stack = 0x0 [14:32:25.556] _do_rethrow = false [14:32:25.556] saveTopTransactionResourceOwner = 0x8354d7800 [14:32:25.556] saveTopTransactionContext = 0x835402000 [14:32:25.556] saveActivePortal = 0x0 [14:32:25.556] saveResourceOwner = 0x8354d7800 [14:32:25.556] savePortalContext = 0x0 [14:32:25.556] saveMemoryContext = 0x835402000 [14:32:25.556] result = [14:32:25.556] nprocessed = [14:32:25.556] #17 0x00000000008d413b in exec_simple_query (query_string=query_string@entry=0x8353f6100 "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 [14:32:25.556] cmdtaglen = [14:32:25.556] snapshot_set = [14:32:25.556] per_parsetree_context = 0x0 [14:32:25.556] plantree_list = [14:32:25.556] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [14:32:25.556] parsetree = 0x83554ae60 [14:32:25.556] commandTag = CMDTAG_EXPLAIN [14:32:25.556] cmdtagname = [14:32:25.556] querytree_list = [14:32:25.556] portal = 0x8354cb100 [14:32:25.556] format = 0 [14:32:25.556] receiver = 0x8355a9a48 [14:32:25.556] parsetree_item__state = {l = 0x83554b9b0, i = 0} [14:32:25.556] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [14:32:25.556] dest = DestRemote [14:32:25.556] was_logged = [14:32:25.556] oldcontext = 0x835402000 [14:32:25.556] parsetree_list = 0x83554b9b0 [14:32:25.556] use_implicit_block = false [14:32:25.556] parsetree_item = 0x83554b9c8 [14:32:25.556] save_log_statement_stats = [14:32:25.556] #18 0x00000000008d1f24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [14:32:25.556] query_string = 0x8353f6100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [14:32:25.556] input_message = {data = 0x8353f6100 "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} [14:32:25.556] firstchar = [14:32:25.556] local_sigjmp_buf = {{_sjb = {9245680, 34919882080, 34919882040, 34919882640, 11902728, 11849216, 8192, 8388608, 72057628957803391, 0, 0, 34359738369}}} [14:32:25.556] send_ready_for_query = false [14:32:25.556] idle_in_transaction_timeout_enabled = false [14:32:25.556] idle_session_timeout_enabled = false [14:32:25.556] #19 0x0000000000831755 in BackendRun (port=port@entry=0x8354d1000) at ../src/backend/postmaster/postmaster.c:4475 [14:32:25.556] No locals. [14:32:25.556] #20 0x000000000082fa8d in BackendStartup (port=0x8354d1000) at ../src/backend/postmaster/postmaster.c:4151 [14:32:25.556] bn = 0x835402128 [14:32:25.556] pid = [14:32:25.556] __error = [14:32:25.556] __error = [14:32:25.556] __error = [14:32:25.556] save_errno = [14:32:25.556] __error = [14:32:25.556] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [14:32:25.556] port = 0x8354d1000 [14:32:25.556] i = 0 [14:32:25.556] now = [14:32:25.556] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 576164872, events = 8, fd = 576165896, user_data = 0x822579c08}, {pos = 576167944, events = 8, fd = 576168968, user_data = 0x82257a808}, {pos = 576171016, events = 8, fd = 576172040, user_data = 0x82257b408}, {pos = -1, events = 0, fd = 759063264, user_data = 0x821632080}, {pos = 758722985, events = 8, fd = 0, user_data = 0x1000}, {pos = 675307801, events = 2620900827, fd = 759064552, user_data = 0x834609be0}, {pos = 160, events = 0, fd = 0, user_data = 0x833a09090}, {pos = 560144720, events = 8, fd = 758585644, user_data = 0x1000}, {pos = 757148004, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 576199224, events = 8, fd = 1, user_data = 0x82257b408}, {pos = 757061848, events = 8, fd = 560144856, user_data = 0x821631f90}, {pos = 32, events = 18, fd = 757132388, user_data = 0x82257b408}, {pos = 576199224, events = 8, fd = 0, user_data = 0xa41}, {pos = 560144832, events = 8, fd = -1476901307, user_data = 0x82d212964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822581a38}, {pos = 1, events = 0, fd = 576173064, user_data = 0x8353e6000}, {pos = 1, events = 0, fd = 893280660, user_data = 0x0}, {pos = 560144784, events = 8, fd = 735083532, user_data = 0x1}, {pos = 893280256, events = 8, fd = 560144832, user_data = 0x82bd06eb4}, {pos = 758874464, events = 8, fd = 758874464, user_data = 0x82d22a0c0}, {pos = 576173064, events = 8, fd = 560145056, user_data = 0x1035a7f8442c}, {pos = 866160784, events = 8, fd = 1, user_data = 0x1035a7f842ae}, {pos = 12240, events = 0, fd = 560144840, user_data = 0x8216322a0}, {pos = 893958120, events = 8, fd = 560146448, user_data = 0x1035a7f97e90}, {pos = 576173064, events = 8, fd = 560137087, user_data = 0x82d36459c}, {pos = 576143368, events = 8, fd = 0, user_data = 0x82257b408}, {pos = 12240, events = 0, fd = 756998144, user_data = 0x1df950}, {pos = 758874464, events = 8, fd = 757132388, user_data = 0x3d00}, {pos = 560146240, events = 8, fd = 560145168, user_data = 0x82d2b318e }, {pos = 758913080, events = 8, fd = 560145108, user_data = 0x83544b5da}, {pos = 560146240, events = 8, fd = 560145168, user_data = 0x82d2c9605}, {pos = 560145106, events = 8, fd = 560146240, user_data = 0x821632740}, {pos = 0, events = 16777216, fd = 675307801, user_data = 0x821632740}, {pos = 893695448, events = 8, fd = 560146448, user_data = 0x82d3c1838}, {pos = 0, events = 0, fd = 560146304, user_data = 0x82d2c970d}, {pos = 0, events = 0, fd = 0, user_data = 0x8216328b0}, {pos = 893695448, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1035a7f8b409}, {pos = 560145512, events = 8, fd = 757132388, user_data = 0x9c7}, {pos = -1476873207, events = 4149, fd = 560145544, user_data = 0x82d20ec64}, {pos = 2758, events = 0, fd = 757104928, user_data = 0x821632408}, {pos = 576173064, events = 8, fd = 560145544, user_data = 0x82d208120}, {pos = 560145520, events = 8, fd = -1476893595, user_data = 0x0}, {pos = 0, events = 0, fd = 759013616, user_data = 0x82d1fe550}, {pos = 0, events = 0, fd = 0, user_data = 0x82d3c89b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x8216324f8}, {pos = 576192648, events = 8, fd = -1476873207, user_data = 0x821632538}, {pos = 757132388, events = 8, fd = 2924, user_data = 0x82d2083b8}, {pos = 560145592, events = 8, fd = 576173064, user_data = 0x821632538}, {pos = 757105592, events = 8, fd = 560145696, user_data = 0x1035a7f86465}, {pos = 576196664, events = 8, fd = 1, user_data = 0x82257b408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 560146104, events = 0, fd = 2565348, user_data = 0x821632720}, {pos = 560146208, events = 8, fd = 560146136, user_data = 0x1e}, {pos = 757069024, events = 8, fd = 560145864, user_data = 0x822580248}, {pos = 560146312, events = 8, fd = 560145840, user_data = 0x1035a7f8ada3}, {pos = 576196664, events = 8, fd = 2691288, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 576196664, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821632888}, {pos = 576173064, events = 8, fd = 560146192, user_data = 0x2724e4}, {pos = 560146384, events = 8, fd = 560146384, user_data = 0x821632788}, {pos = 32, events = 0, fd = 560145968, user_data = 0x1035a7f8ab83}} [14:32:25.556] last_touch_time = 1709821727 [14:32:25.556] last_lockfile_recheck_time = 1709821727 [14:32:25.556] nevents = 1 [14:32:25.556] #22 0x000000000082cd93 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821632f48) at ../src/backend/postmaster/postmaster.c:1468 [14:32:25.556] userDoption = [14:32:25.556] listen_addr_saved = false [14:32:25.556] output_config_variable = [14:32:25.556] opt = [14:32:25.556] status = [14:32:25.556] #23 0x000000000076a015 in main (argc=8, argv=0x821632f48) at ../src/backend/main/main.c:197 [14:32:25.556] do_check_root =