[22:57:05.637] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [22:57:05.996] dumping /tmp/cores/postgres.10464.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:57:06.126] [New LWP 100178] [22:57:06.205] Core was generated by `postgres: postgres regression [local] SELECT'. [22:57:06.205] Program terminated with signal SIGSEGV, Segmentation fault. [22:57:06.205] Address not mapped to object. [22:57:06.205] #0 equal (a=0x37137778, b=b@entry=0x837134068) at ../src/backend/nodes/equalfuncs.c:239 [22:57:06.205] 239 if (nodeTag(a) != nodeTag(b)) [22:57:06.237] [22:57:06.237] Thread 1 (LWP 100178): [22:57:06.237] #0 equal (a=0x37137778, b=b@entry=0x837134068) at ../src/backend/nodes/equalfuncs.c:239 [22:57:06.237] retval = [22:57:06.237] #1 0x000000000077c142 in list_member (list=0x8371377e8, datum=datum@entry=0x837134068) at ../src/backend/nodes/list.c:670 [22:57:06.237] cell__state = {l = 0x8371377e8, i = 0} [22:57:06.237] cell = 0x0 [22:57:06.237] cell__state = [22:57:06.237] #2 0x00000000007efbb5 in add_new_column_to_pathtarget (target=0x837137708, expr=) at ../src/backend/optimizer/util/tlist.c:743 [22:57:06.237] No locals. [22:57:06.237] #3 add_new_columns_to_pathtarget (target=target@entry=0x837137708, exprs=0x837137918) at ../src/backend/optimizer/util/tlist.c:760 [22:57:06.237] expr = [22:57:06.237] lc__state = {l = 0x837137918, i = 0} [22:57:06.237] lc = 0xfffffe3a [22:57:06.237] #4 0x00000000007bf539 in make_group_input_target (root=0x83524af68, final_target=0x8371375a8) at ../src/backend/optimizer/plan/planner.c:5472 [22:57:06.237] parse = 0x83711ce50 [22:57:06.237] input_target = 0x837137708 [22:57:06.237] non_group_cols = 0x8371378c8 [22:57:06.237] i = [22:57:06.237] lc = [22:57:06.237] non_group_vars = 0x837137918 [22:57:06.237] #5 grouping_planner (root=root@entry=0x83524af68, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:57:06.237] qp_extra = {activeWindows = 0x0, gset_data = 0x8371354b8} [22:57:06.237] activeWindows = 0x0 [22:57:06.237] sort_input_target_parallel_safe = false [22:57:06.237] grouping_target = 0x8371375a8 [22:57:06.237] scanjoin_target = [22:57:06.237] sort_input_targets = [22:57:06.237] wflists = 0x0 [22:57:06.237] gset_data = 0x8371354b8 [22:57:06.237] have_grouping = false [22:57:06.237] sort_input_targets_contain_srfs = [22:57:06.237] sort_input_target = 0x8371375a8 [22:57:06.237] grouping_target_parallel_safe = false [22:57:06.237] scanjoin_target_parallel_safe = [22:57:06.237] grouping_targets = [22:57:06.237] scanjoin_targets = [22:57:06.237] grouping_targets_contain_srfs = [22:57:06.237] scanjoin_targets_contain_srfs = [22:57:06.237] scanjoin_target_same_exprs = [22:57:06.237] extra = {limit_needed = 152, limit_tuples = 1.7432488956745017e-313, count_est = 72, offset_est = 34908785888} [22:57:06.237] parse = 0x83711ce50 [22:57:06.237] offset_est = [22:57:06.237] count_est = [22:57:06.237] limit_tuples = -1 [22:57:06.237] have_postponed_srfs = false [22:57:06.237] current_rel = 0x83524b378 [22:57:06.237] final_target = 0x8371375a8 [22:57:06.237] final_targets_contain_srfs = [22:57:06.237] final_targets = [22:57:06.237] final_rel = [22:57:06.237] lc = [22:57:06.237] final_target_parallel_safe = [22:57:06.237] #6 0x00000000007bd444 in subquery_planner (glob=glob@entry=0x837131d60, parse=parse@entry=0x83711ce50, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:57:06.237] root = 0x83524af68 [22:57:06.237] hasOuterJoins = false [22:57:06.237] hasResultRTEs = false [22:57:06.237] l = [22:57:06.237] newWithCheckOptions = [22:57:06.237] newHaving = 0x0 [22:57:06.237] final_rel = [22:57:06.237] #7 0x00000000007bbf68 in standard_planner (parse=0x83711ce50, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [22:57:06.237] glob = 0x837131d60 [22:57:06.237] tuple_fraction = 0 [22:57:06.237] root = [22:57:06.237] final_rel = [22:57:06.237] best_path = [22:57:06.237] top_plan = [22:57:06.237] lp = [22:57:06.237] lr = [22:57:06.237] result = [22:57:06.237] #8 0x00000000007bbe3c in planner (parse=0x37137778, parse@entry=0x83711ce50, query_string=0x837134068 "\006", query_string@entry=0x83516c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=549047344, cursorOptions@entry=2048, boundParams=0xfffffe3a, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [22:57:06.237] result = [22:57:06.237] #9 0x00000000008dfbd5 in pg_plan_query (querytree=querytree@entry=0x83711ce50, query_string=query_string@entry=0x83516c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [22:57:06.237] plan = [22:57:06.237] #10 0x00000000008dfcb2 in pg_plan_queries (querytrees=0x837131d10, query_string=query_string@entry=0x83516c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=549047344, cursorOptions@entry=2048, boundParams=0xfffffe3a, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [22:57:06.237] query = 0x83711ce50 [22:57:06.237] stmt = [22:57:06.237] query_list__state = {l = 0x837131d10, i = 0} [22:57:06.237] stmt_list = 0x0 [22:57:06.237] query_list = [22:57:06.237] #11 0x00000000008e3e4c in exec_simple_query (query_string=query_string@entry=0x83516c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [22:57:06.237] cmdtaglen = [22:57:06.237] snapshot_set = [22:57:06.237] per_parsetree_context = 0x0 [22:57:06.237] plantree_list = [22:57:06.237] qc = {commandTag = 336, nprocessed = 6} [22:57:06.237] parsetree = 0x8352c6600 [22:57:06.237] commandTag = [22:57:06.237] cmdtagname = [22:57:06.237] querytree_list = 0x0 [22:57:06.237] portal = [22:57:06.237] format = [22:57:06.237] receiver = [22:57:06.237] parsetree_item__state = {l = 0x835247ab8, i = 0} [22:57:06.237] 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" [22:57:06.237] dest = DestRemote [22:57:06.237] was_logged = [22:57:06.237] oldcontext = 0x835178000 [22:57:06.237] parsetree_list = 0x835247ab8 [22:57:06.237] use_implicit_block = false [22:57:06.237] parsetree_item = 0x835247ad0 [22:57:06.237] save_log_statement_stats = [22:57:06.237] #12 0x00000000008e1d24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [22:57:06.237] query_string = 0x83516c100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [22:57:06.237] input_message = {data = 0x83516c100 "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} [22:57:06.237] firstchar = [22:57:06.237] local_sigjmp_buf = {{_sjb = {9310704, 34908786864, 34908786824, 34908787424, 11976360, 11922832, 8192, 8388608, 72057628946662271, 0, 0, 34359738369}}} [22:57:06.237] send_ready_for_query = false [22:57:06.237] idle_in_transaction_timeout_enabled = false [22:57:06.237] idle_session_timeout_enabled = false [22:57:06.237] #13 0x00000000008dca89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:57:06.237] bsdata = [22:57:06.237] #14 0x000000000083991c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820b9ddf0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820b9dd38) at ../src/backend/postmaster/launch_backend.c:267 [22:57:06.237] pid = [22:57:06.237] #15 0x000000000083e131 in BackendStartup (client_sock=0x820b9dd38) at ../src/backend/postmaster/postmaster.c:3593 [22:57:06.237] startup_data = {canAcceptConnections = CAC_OK} [22:57:06.237] bn = 0x835178268 [22:57:06.237] pid = [22:57:06.237] __error = [22:57:06.237] __error = [22:57:06.237] save_errno = [22:57:06.237] __error = [22:57:06.237] __error = [22:57:06.237] #16 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:57:06.237] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "\220ݹ \b\000\000\000\330Ō)\b", '\000' , "\016F\215)\b", '\000' , "\320ݹ \b\000\000\000\264\226\203\000\000\000\000\000\340ݹ \b", '\000' , "\v\000\000\000\000\000\000"}, salen = 16}} [22:57:06.237] i = 0 [22:57:06.237] now = [22:57:06.237] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 713550948, events = 8, fd = 549049216, user_data = 0x820b9d510}, {pos = 552985608, events = 8, fd = 32, user_data = 0x820b9d500}, {pos = -270779756, events = 9478, fd = 552955912, user_data = 0x820f57408}, {pos = 552957960, events = 8, fd = 552958984, user_data = 0x820f5b008}, {pos = 552973320, events = 8, fd = 552974344, user_data = 0x820f5bc08}, {pos = 552976392, events = 8, fd = 552977416, user_data = 0x820f5c808}, {pos = 552979464, events = 8, fd = 552980488, user_data = 0x820f5d408}, {pos = 552982536, events = 8, fd = 552983560, user_data = 0x820f5e008}, {pos = 552985608, events = 8, fd = -1, user_data = 0x82aa562e0}, {pos = 549049456, events = 8, fd = 715141545, user_data = 0x0}, {pos = 4096, events = 0, fd = -257925346, user_data = 0x82aa567e8}, {pos = 882940896, events = 8, fd = 160, user_data = 0x0}, {pos = 864657552, events = 8, fd = 549049664, user_data = 0x82a9e192c}, {pos = 4096, events = 0, fd = 713566564, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 553011768, user_data = 0x800000001}, {pos = 552985608, events = 8, fd = 713480408, user_data = 0x820b9d5c8}, {pos = 549049216, events = 8, fd = 32, user_data = 0x82a87ec64}, {pos = 552985608, events = 8, fd = 553011768, user_data = 0x0}, {pos = 2625, events = 0, fd = 549049776, user_data = 0x2506efdc3645}, {pos = 713566564, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 553011768, events = 8, fd = 1, user_data = 0x820f5e408}, {pos = 890617856, events = 8, fd = 1, user_data = 0x83515c194}, {pos = 0, events = 0, fd = 549049728, user_data = 0x8298d3c0c}, {pos = 1, events = 0, fd = 890617856, user_data = 0x820b9d5b0}, {pos = 697118388, events = 8, fd = 715293024, user_data = 0x82aa28160 }, {pos = 713662656, events = 8, fd = 552985608, user_data = 0x820b9d690}, {pos = -270781396, events = 9478, fd = 864657552, user_data = 0x800000001}, {pos = -270781778, events = 9478, fd = 12240, user_data = 0x820b9d5b8}, {pos = 549050000, events = 8, fd = 891295720, user_data = 0x820b9dc00}, {pos = -270700912, events = 9478, fd = 552985608, user_data = 0x820b9037f}, {pos = 714950044, events = 8, fd = 552955912, user_data = 0x0}, {pos = 552985608, events = 8, fd = 12240, user_data = 0x82a85e000}, {pos = 1964368, events = 0, fd = 715293024, user_data = 0x82a87ec64}, {pos = 15616, events = 0, fd = 549051184, user_data = 0x820b9d700}, {pos = 714224014, events = 8, fd = 715331640, user_data = 0x820b9d6c4}, {pos = 891033050, events = 8, fd = 549051184, user_data = 0x820b9d700}, {pos = 714315269, events = 8, fd = 549050050, user_data = 0x820b9db30}, {pos = 549051184, events = 8, fd = 0, user_data = 0x538003a0f0a05f1e}, {pos = 549051184, events = 8, fd = 891033048, user_data = 0x820b9dc00}, {pos = 715331640, events = 8, fd = 0, user_data = 0x820b9db70}, {pos = 714315533, events = 8, fd = 0, user_data = 0x0}, {pos = 549051552, events = 8, fd = 891033048, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -270752759, events = 9478, fd = 549050456, user_data = 0x82a87ec64}, {pos = 2503, events = 0, fd = -270752759, user_data = 0x820b9d878}, {pos = 713550948, events = 8, fd = 2758, user_data = 0x82a878120}, {pos = 549050360, events = 8, fd = 552985608, user_data = 0x820b9d878}, {pos = 713523488, events = 8, fd = 549050464, user_data = 0x2506efdc5465}, {pos = 0, events = 0, fd = 0, user_data = 0x82aa4a0f0}, {pos = 713483600, events = 8, fd = 0, user_data = 0x0}, {pos = 715360688, events = 8, fd = -270752759, user_data = 0x820b9d908}, {pos = 713550948, events = 8, fd = 2924, user_data = 0x82a8783b8}, {pos = 549050504, events = 8, fd = 552985608, user_data = 0x820b9d908}, {pos = 713524152, events = 8, fd = 549050608, user_data = 0x2506efdc5465}, {pos = 553009208, events = 8, fd = 2669238, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 552985608, events = 8, fd = 713483600, user_data = 0x820b9dbc8}, {pos = 552985608, events = 8, fd = 549051048, user_data = 0x1e}, {pos = 713487584, events = 8, fd = 549050776, user_data = 0x820f63248}, {pos = 549051224, events = 8, fd = 549050752, user_data = 0x2506efdc9da3}, {pos = 553009208, events = 8, fd = 2692555, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 553009208, user_data = 0x1}} [22:57:06.237] last_touch_time = 1710888857 [22:57:06.237] last_lockfile_recheck_time = 1710888857 [22:57:06.237] nevents = 1 [22:57:06.237] #17 0x000000000083ba06 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820b9e330) at ../src/backend/postmaster/postmaster.c:1372 [22:57:06.237] userDoption = [22:57:06.237] listen_addr_saved = false [22:57:06.237] output_config_variable = [22:57:06.237] opt = [22:57:06.237] status = [22:57:06.237] #18 0x0000000000778a05 in main (argc=8, argv=0x820b9e330) at ../src/backend/main/main.c:197 [22:57:06.237] do_check_root = [22:57:06.246] [22:57:06.246] [22:57:06.246] [22:57:06.300] dumping /tmp/cores/postgres.11272.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:57:06.425] [New LWP 101853] [22:57:06.498] Core was generated by `postgres: old_node: postgres regression [local] SELECT'. [22:57:06.498] Program terminated with signal SIGSEGV, Segmentation fault. [22:57:06.498] Address not mapped to object. [22:57:06.498] #0 equal (a=0x39a17e78, b=b@entry=0x839a14768) at ../src/backend/nodes/equalfuncs.c:239 [22:57:06.498] 239 if (nodeTag(a) != nodeTag(b)) [22:57:06.520] [22:57:06.520] Thread 1 (LWP 101853): [22:57:06.520] #0 equal (a=0x39a17e78, b=b@entry=0x839a14768) at ../src/backend/nodes/equalfuncs.c:239 [22:57:06.520] retval = [22:57:06.520] #1 0x000000000077c142 in list_member (list=0x839a17ee8, datum=datum@entry=0x839a14768) at ../src/backend/nodes/list.c:670 [22:57:06.520] cell__state = {l = 0x839a17ee8, i = 0} [22:57:06.520] cell = 0x0 [22:57:06.520] cell__state = [22:57:06.520] #2 0x00000000007efbb5 in add_new_column_to_pathtarget (target=0x839a17e08, expr=) at ../src/backend/optimizer/util/tlist.c:743 [22:57:06.520] No locals. [22:57:06.520] #3 add_new_columns_to_pathtarget (target=target@entry=0x839a17e08, exprs=0x839a18018) at ../src/backend/optimizer/util/tlist.c:760 [22:57:06.520] expr = [22:57:06.520] lc__state = {l = 0x839a18018, i = 0} [22:57:06.520] lc = 0xfffffe3a [22:57:06.520] #4 0x00000000007bf539 in make_group_input_target (root=0x8376a7d28, final_target=0x839a17ca8) at ../src/backend/optimizer/plan/planner.c:5472 [22:57:06.520] parse = 0x8399fd990 [22:57:06.520] input_target = 0x839a17e08 [22:57:06.520] non_group_cols = 0x839a17fc8 [22:57:06.520] i = [22:57:06.520] lc = [22:57:06.520] non_group_vars = 0x839a18018 [22:57:06.520] #5 grouping_planner (root=root@entry=0x8376a7d28, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:57:06.520] qp_extra = {activeWindows = 0x0, gset_data = 0x839a15bb8} [22:57:06.520] activeWindows = 0x0 [22:57:06.520] sort_input_target_parallel_safe = false [22:57:06.520] grouping_target = 0x839a17ca8 [22:57:06.520] scanjoin_target = [22:57:06.520] sort_input_targets = [22:57:06.520] wflists = 0x0 [22:57:06.520] gset_data = 0x839a15bb8 [22:57:06.520] have_grouping = false [22:57:06.520] sort_input_targets_contain_srfs = [22:57:06.520] sort_input_target = 0x839a17ca8 [22:57:06.520] grouping_target_parallel_safe = false [22:57:06.520] scanjoin_target_parallel_safe = [22:57:06.520] grouping_targets = [22:57:06.520] scanjoin_targets = [22:57:06.520] grouping_targets_contain_srfs = [22:57:06.520] scanjoin_targets_contain_srfs = [22:57:06.520] scanjoin_target_same_exprs = [22:57:06.520] extra = {limit_needed = 152, limit_tuples = 1.7453665764463122e-313, count_est = 72, offset_est = 34924227168} [22:57:06.520] parse = 0x8399fd990 [22:57:06.520] offset_est = [22:57:06.520] count_est = [22:57:06.520] limit_tuples = -1 [22:57:06.520] have_postponed_srfs = false [22:57:06.520] current_rel = 0x8376a8138 [22:57:06.520] final_target = 0x839a17ca8 [22:57:06.520] final_targets_contain_srfs = [22:57:06.520] final_targets = [22:57:06.520] final_rel = [22:57:06.520] lc = [22:57:06.520] final_target_parallel_safe = [22:57:06.520] #6 0x00000000007bd444 in subquery_planner (glob=glob@entry=0x839a12460, parse=parse@entry=0x8399fd990, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:57:06.520] root = 0x8376a7d28 [22:57:06.520] hasOuterJoins = false [22:57:06.520] hasResultRTEs = false [22:57:06.520] l = [22:57:06.520] newWithCheckOptions = [22:57:06.520] newHaving = 0x0 [22:57:06.520] final_rel = [22:57:06.520] #7 0x00000000007bbf68 in standard_planner (parse=0x8399fd990, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [22:57:06.520] glob = 0x839a12460 [22:57:06.520] tuple_fraction = 0 [22:57:06.520] root = [22:57:06.520] final_rel = [22:57:06.520] best_path = [22:57:06.520] top_plan = [22:57:06.520] lp = [22:57:06.520] lr = [22:57:06.520] result = [22:57:06.520] #8 0x00000000007bbe3c in planner (parse=0x39a17e78, parse@entry=0x8399fd990, query_string=0x839a14768 "\006", query_string@entry=0x8375c7100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=564488624, cursorOptions@entry=2048, boundParams=0xfffffe3a, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [22:57:06.520] result = [22:57:06.520] #9 0x00000000008dfbd5 in pg_plan_query (querytree=querytree@entry=0x8399fd990, query_string=query_string@entry=0x8375c7100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [22:57:06.520] plan = [22:57:06.520] #10 0x00000000008dfcb2 in pg_plan_queries (querytrees=0x839a12410, query_string=query_string@entry=0x8375c7100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=564488624, cursorOptions@entry=2048, boundParams=0xfffffe3a, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [22:57:06.520] query = 0x8399fd990 [22:57:06.520] stmt = [22:57:06.520] query_list__state = {l = 0x839a12410, i = 0} [22:57:06.520] stmt_list = 0x0 [22:57:06.520] query_list = [22:57:06.520] #11 0x00000000008e3e4c in exec_simple_query (query_string=query_string@entry=0x8375c7100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [22:57:06.520] cmdtaglen = [22:57:06.520] snapshot_set = [22:57:06.520] per_parsetree_context = 0x0 [22:57:06.520] plantree_list = [22:57:06.520] qc = {commandTag = 336, nprocessed = 6} [22:57:06.520] parsetree = 0x837724600 [22:57:06.520] commandTag = [22:57:06.520] cmdtagname = [22:57:06.520] querytree_list = 0x0 [22:57:06.520] portal = [22:57:06.520] format = [22:57:06.520] receiver = [22:57:06.520] parsetree_item__state = {l = 0x8376a4878, i = 0} [22:57:06.520] 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" [22:57:06.520] dest = DestRemote [22:57:06.520] was_logged = [22:57:06.520] oldcontext = 0x8375d3000 [22:57:06.520] parsetree_list = 0x8376a4878 [22:57:06.520] use_implicit_block = false [22:57:06.520] parsetree_item = 0x8376a4890 [22:57:06.520] save_log_statement_stats = [22:57:06.520] #12 0x00000000008e1d24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [22:57:06.520] query_string = 0x8375c7100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [22:57:06.520] input_message = {data = 0x8375c7100 "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} [22:57:06.520] firstchar = [22:57:06.520] local_sigjmp_buf = {{_sjb = {9310704, 34924228144, 34924228104, 34924228704, 11976360, 11922832, 8192, 8388608, 72057628962128767, 0, 0, 34359738369}}} [22:57:06.520] send_ready_for_query = false [22:57:06.520] idle_in_transaction_timeout_enabled = false [22:57:06.520] idle_session_timeout_enabled = false [22:57:06.520] #13 0x00000000008dca89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:57:06.520] bsdata = [22:57:06.520] #14 0x000000000083991c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821a57b70 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821a57ab8) at ../src/backend/postmaster/launch_backend.c:267 [22:57:06.520] pid = [22:57:06.520] #15 0x000000000083e131 in BackendStartup (client_sock=0x821a57ab8) at ../src/backend/postmaster/postmaster.c:3593 [22:57:06.520] startup_data = {canAcceptConnections = CAC_OK} [22:57:06.520] bn = 0x8375d3358 [22:57:06.520] pid = [22:57:06.520] __error = [22:57:06.520] __error = [22:57:06.520] save_errno = [22:57:06.520] __error = [22:57:06.520] __error = [22:57:06.520] #16 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:57:06.520] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "\020{\245!\b\000\000\000\330%'*\b", '\000' , "\016\246'*\b", '\000' , "P{\245!\b\000\000\000\264\226\203\000\000\000\000\000`{\245!\b", '\000' , "\v\000\000\000\000\000\000"}, salen = 16}} [22:57:06.520] i = 0 [22:57:06.520] now = [22:57:06.520] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 775117924, events = 8, fd = 564490496, user_data = 0x821a57290}, {pos = 572019720, events = 8, fd = 32, user_data = 0x821a57280}, {pos = -1711297900, events = 9416, fd = 571990024, user_data = 0x82217e408}, {pos = 571992072, events = 8, fd = 571993096, user_data = 0x822182008}, {pos = 572007432, events = 8, fd = 572008456, user_data = 0x822182c08}, {pos = 572010504, events = 8, fd = 572011528, user_data = 0x822183808}, {pos = 572013576, events = 8, fd = 572014600, user_data = 0x822184408}, {pos = 572016648, events = 8, fd = 572017672, user_data = 0x822185008}, {pos = 572019720, events = 8, fd = 572039304, user_data = 0x821a57408}, {pos = 564490800, events = 8, fd = -1711272541, user_data = 0x0}, {pos = 2566710, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 572043320, events = 8, fd = 1, user_data = 0x822185408}, {pos = 775025832, events = 8, fd = 564491528, user_data = 0x822185408}, {pos = 564490784, events = 0, fd = 775133540, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 572045880, user_data = 0x1}, {pos = 572019720, events = 8, fd = 775047384, user_data = 0x821a57348}, {pos = 564490496, events = 8, fd = 32, user_data = 0x82e335c64}, {pos = 572019720, events = 8, fd = 572045880, user_data = 0x0}, {pos = 2625, events = 0, fd = 564491056, user_data = 0x24c899ffa645}, {pos = 775133540, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 572045880, events = 8, fd = 1, user_data = 0x822185408}, {pos = 928739328, events = 8, fd = 1, user_data = 0x8375b7194}, {pos = 0, events = 0, fd = 564491008, user_data = 0x82a279c0c}, {pos = 1, events = 0, fd = 928739328, user_data = 0x821a57330}, {pos = 707235508, events = 8, fd = 776860000, user_data = 0x82e4df160 }, {pos = 775229632, events = 8, fd = 572019720, user_data = 0x821a57410}, {pos = -1711299540, events = 9416, fd = 572018696, user_data = 0x800000001}, {pos = -1711299922, events = 9416, fd = 12240, user_data = 0x821a57338}, {pos = 564491280, events = 8, fd = 929535976, user_data = 0x821a57980}, {pos = -1711219056, events = 9416, fd = 572019720, user_data = 0x821a5037f}, {pos = 776516786, events = 8, fd = 571990024, user_data = 0x0}, {pos = 572019720, events = 8, fd = 12240, user_data = 0x82e315000}, {pos = 1964368, events = 0, fd = 776860000, user_data = 0x82e335c64}, {pos = 15616, events = 0, fd = 564492464, user_data = 0x821a57480}, {pos = 775790990, events = 8, fd = 776898616, user_data = 0x821a57444}, {pos = 929191386, events = 8, fd = 564492464, user_data = 0x821a57480}, {pos = 775882245, events = 8, fd = 564491330, user_data = 0x821a578b0}, {pos = 564492464, events = 8, fd = 0, user_data = 0x4f7e9a694cf16a69}, {pos = 564492464, events = 8, fd = 929191384, user_data = 0x821a57980}, {pos = 776898616, events = 8, fd = 0, user_data = 0x821a578f0}, {pos = 775882509, events = 8, fd = 0, user_data = 0x0}, {pos = 564492832, events = 8, fd = 929191384, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1711270903, events = 9416, fd = 564491736, user_data = 0x82e335c64}, {pos = 2503, events = 0, fd = -1711270903, user_data = 0x821a575f8}, {pos = 775117924, events = 8, fd = 2758, user_data = 0x82e32f120}, {pos = 564491640, events = 8, fd = 572019720, user_data = 0x821a575f8}, {pos = 775090464, events = 8, fd = 564491744, user_data = 0x24c899ffc465}, {pos = 0, events = 0, fd = 0, user_data = 0x82e5010f0}, {pos = 775050576, events = 8, fd = 0, user_data = 0x0}, {pos = 776927664, events = 8, fd = -1711270903, user_data = 0x821a57688}, {pos = 775117924, events = 8, fd = 2924, user_data = 0x82e32f3b8}, {pos = 564491784, events = 8, fd = 572019720, user_data = 0x821a57688}, {pos = 775091128, events = 8, fd = 564491888, user_data = 0x24c899ffc465}, {pos = 572043320, events = 8, fd = 2669238, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 572019720, events = 8, fd = 775050576, user_data = 0x821a57948}, {pos = 572019720, events = 8, fd = 564492328, user_data = 0x1e}, {pos = 775054560, events = 8, fd = 564492056, user_data = 0x82218a248}, {pos = 564492504, events = 8, fd = 564492032, user_data = 0x24c89a000da3}, {pos = 572043320, events = 8, fd = 2692555, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 572043320, user_data = 0x1}} [22:57:06.520] last_touch_time = 1710888858 [22:57:06.520] last_lockfile_recheck_time = 1710888858 [22:57:06.520] nevents = 1 [22:57:06.520] #17 0x000000000083ba06 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a580b8) at ../src/backend/postmaster/postmaster.c:1372 [22:57:06.520] userDoption = [22:57:06.520] listen_addr_saved = false [22:57:06.520] output_config_variable = [22:57:06.520] opt = [22:57:06.520] status = [22:57:06.520] #18 0x0000000000778a05 in main (argc=4, argv=0x821a580b8) at ../src/backend/main/main.c:197 [22:57:06.520] do_check_root = [22:57:06.528] [22:57:06.528] [22:57:06.528] [22:57:06.580] dumping /tmp/cores/postgres.12956.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:57:06.701] [New LWP 101874] [22:57:06.766] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [22:57:06.766] Program terminated with signal SIGSEGV, Segmentation fault. [22:57:06.766] Address not mapped to object. [22:57:06.766] #0 equal (a=0x3521ccb0, b=b@entry=0x835186678) at ../src/backend/nodes/equalfuncs.c:239 [22:57:06.766] 239 if (nodeTag(a) != nodeTag(b)) [22:57:07.257] [22:57:07.257] Thread 1 (LWP 101874): [22:57:07.257] #0 equal (a=0x3521ccb0, b=b@entry=0x835186678) at ../src/backend/nodes/equalfuncs.c:239 [22:57:07.257] retval = [22:57:07.257] #1 0x000000000077c142 in list_member (list=0x83521cd20, datum=datum@entry=0x835186678) at ../src/backend/nodes/list.c:670 [22:57:07.257] cell__state = {l = 0x83521cd20, i = 0} [22:57:07.257] cell = 0x0 [22:57:07.257] cell__state = [22:57:07.257] #2 0x00000000007efbb5 in add_new_column_to_pathtarget (target=0x83521cc40, expr=) at ../src/backend/optimizer/util/tlist.c:743 [22:57:07.257] No locals. [22:57:07.257] #3 add_new_columns_to_pathtarget (target=target@entry=0x83521cc40, exprs=0x83521cdd8) at ../src/backend/optimizer/util/tlist.c:760 [22:57:07.257] expr = [22:57:07.257] lc__state = {l = 0x83521cdd8, i = 0} [22:57:07.257] lc = 0xfffffe3a [22:57:07.257] #4 0x00000000007bf539 in make_group_input_target (root=0x835186038, final_target=0x83521cb70) at ../src/backend/optimizer/plan/planner.c:5472 [22:57:07.257] parse = 0x836ee27c8 [22:57:07.257] input_target = 0x83521cc40 [22:57:07.257] non_group_cols = 0x83521cd88 [22:57:07.257] i = [22:57:07.257] lc = [22:57:07.257] non_group_vars = 0x83521cdd8 [22:57:07.257] #5 grouping_planner (root=root@entry=0x835186038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:57:07.257] qp_extra = {activeWindows = 0x0, gset_data = 0x835186718} [22:57:07.257] activeWindows = 0x0 [22:57:07.257] sort_input_target_parallel_safe = false [22:57:07.257] grouping_target = 0x83521cb70 [22:57:07.257] scanjoin_target = [22:57:07.257] sort_input_targets = [22:57:07.257] wflists = 0x0 [22:57:07.257] gset_data = 0x835186718 [22:57:07.257] have_grouping = false [22:57:07.257] sort_input_targets_contain_srfs = [22:57:07.257] sort_input_target = 0x83521cb70 [22:57:07.257] grouping_target_parallel_safe = false [22:57:07.257] scanjoin_target_parallel_safe = [22:57:07.257] grouping_targets = [22:57:07.257] scanjoin_targets = [22:57:07.257] grouping_targets_contain_srfs = [22:57:07.257] scanjoin_targets_contain_srfs = [22:57:07.257] scanjoin_target_same_exprs = [22:57:07.257] extra = {limit_needed = 16, limit_tuples = 1.7416075708642705e-313, count_est = 0, offset_est = 34908784928} [22:57:07.257] parse = 0x836ee27c8 [22:57:07.257] offset_est = [22:57:07.257] count_est = [22:57:07.257] limit_tuples = -1 [22:57:07.257] have_postponed_srfs = false [22:57:07.257] current_rel = 0x8351854c8 [22:57:07.257] final_target = 0x83521cb70 [22:57:07.257] final_targets_contain_srfs = [22:57:07.257] final_targets = [22:57:07.257] final_rel = [22:57:07.257] lc = [22:57:07.257] final_target_parallel_safe = [22:57:07.257] #6 0x00000000007bd444 in subquery_planner (glob=glob@entry=0x835201ef8, parse=parse@entry=0x836ee27c8, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=1.7430876022132554e-313) at ../src/backend/optimizer/plan/planner.c:1084 [22:57:07.257] root = 0x835186038 [22:57:07.257] hasOuterJoins = false [22:57:07.257] hasResultRTEs = false [22:57:07.257] l = [22:57:07.257] newWithCheckOptions = [22:57:07.257] newHaving = 0x0 [22:57:07.257] final_rel = [22:57:07.257] #7 0x00000000007bbf68 in standard_planner (parse=0x836ee27c8, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [22:57:07.257] glob = 0x835201ef8 [22:57:07.257] tuple_fraction = 0 [22:57:07.257] root = [22:57:07.257] final_rel = [22:57:07.257] best_path = [22:57:07.257] top_plan = [22:57:07.257] lp = [22:57:07.257] lr = [22:57:07.257] result = [22:57:07.257] #8 0x00000000007bbe3c in planner (parse=0x3521ccb0, parse@entry=0x836ee27c8, query_string=0x835186678 "\006", query_string@entry=0x83516c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=549046368, cursorOptions@entry=2048, boundParams=0xfffffe3a, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [22:57:07.257] result = [22:57:07.257] #9 0x00000000008dfbd5 in pg_plan_query (querytree=querytree@entry=0x836ee27c8, query_string=query_string@entry=0x83516c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [22:57:07.257] plan = [22:57:07.257] #10 0x0000000000692ca9 in standard_ExplainOneQuery (query=0x836ee27c8, cursorOptions=549046368, cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x835307748, queryString=0x835186678 "\006", params=0xfffffe3a, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:440 [22:57:07.257] planduration = {ticks = 7844720} [22:57:07.257] bufusage_start = {shared_blks_hit = 34908785855, shared_blks_read = 0, shared_blks_dirtied = 35281316056, shared_blks_written = 35281316712, local_blks_hit = 34908785680, local_blks_read = 10646145, local_blks_dirtied = 70368744214659, local_blks_written = 0, temp_blks_read = 34908785712, temp_blks_written = 5711082, shared_blk_read_time = {ticks = 70368744214659}, shared_blk_write_time = {ticks = 1}, local_blk_read_time = {ticks = 34908785728}, local_blk_write_time = {ticks = 6258969}, temp_blk_read_time = {ticks = 34908785904}, temp_blk_write_time = {ticks = 8967531}} [22:57:07.257] bufusage = {shared_blks_hit = 142, shared_blks_read = 822033665, shared_blks_dirtied = 0, shared_blks_written = 549755813893, local_blks_hit = 6016813091933675294, local_blks_read = 34908785852, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 35280646432, temp_blks_written = 10859347, shared_blk_read_time = {ticks = 35281317784}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35281315784}, local_blk_write_time = {ticks = 35281315784}, temp_blk_read_time = {ticks = 34908785872}, temp_blk_write_time = {ticks = 10894912}} [22:57:07.257] mem_counters = {nblocks = 34908785648, freechunks = 9192341, totalspace = 34908785648, freespace = 35280646432} [22:57:07.257] planner_ctx = 0x0 [22:57:07.257] saved_ctx = [22:57:07.257] planstart = {ticks = -142822033665} [22:57:07.257] plan = [22:57:07.257] #11 0x000000000069267c in ExplainOneQuery (query=0x3521ccb0, cursorOptions=2048, into=0x0, es=0x835307748, queryString=0x3 , params=0x83521b000, queryEnv=) at ../src/backend/commands/explain.c:396 [22:57:07.257] No locals. [22:57:07.257] #12 ExplainQuery (pstate=pstate@entry=0x835307638, stmt=stmt@entry=0x836ee2798, params=0x83521b000, params@entry=0x0, dest=0x8353075a8) at ../src/backend/commands/explain.c:292 [22:57:07.257] l__state = {l = , i = 0} [22:57:07.257] l = 0x835201cb0 [22:57:07.257] es = 0x835307748 [22:57:07.257] jstate = [22:57:07.257] timing_set = false [22:57:07.257] summary_set = false [22:57:07.257] lc = [22:57:07.257] query = [22:57:07.257] rewritten = 0x835201c98 [22:57:07.257] tstate = [22:57:07.257] #13 0x00000000008e6cdf in standard_ProcessUtility (pstmt=0x836ee3410, queryString=0x83516c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x820b9c860, queryEnv=0x0, dest=0x8353075a8, qc=0x820b9cea8) at ../src/backend/tcop/utility.c:863 [22:57:07.257] isAtomicContext = true [22:57:07.257] parsetree = 0x836ee2798 [22:57:07.257] readonly_flags = [22:57:07.257] pstate = 0x835307638 [22:57:07.257] isTopLevel = [22:57:07.257] #14 0x00000000008e660d in ProcessUtility (pstmt=0x3521ccb0, pstmt@entry=0x836ee3410, queryString=0x835186678 "\006", readOnlyTree=, context=4294966842, params=0x3, queryEnv=0x83521b000, dest=0x8353075a8, qc=0x820b9cea8) at ../src/backend/tcop/utility.c:523 [22:57:07.257] No locals. [22:57:07.257] #15 0x00000000008e6133 in PortalRunUtility (portal=portal@entry=0x835241100, pstmt=0x836ee3410, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x8353075a8, qc=qc@entry=0x820b9cea8) at ../src/backend/tcop/pquery.c:1158 [22:57:07.257] No locals. [22:57:07.257] #16 0x00000000008e532a in FillPortalStore (portal=portal@entry=0x835241100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [22:57:07.257] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:57:07.257] treceiver = 0x8353075a8 [22:57:07.257] #17 0x00000000008e5030 in PortalRun (portal=portal@entry=0x835241100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x836ee3570, altdest=altdest@entry=0x836ee3570, qc=0x820b9cfe0) at ../src/backend/tcop/pquery.c:763 [22:57:07.257] _local_sigjmp_buf = {{_sjb = {9326543, 35251356224, 34908786392, 34908786624, 34908786400, 11967624, 11935408, 35251294464, 7112098687, 35251302656, 3555360, 34359738368}}} [22:57:07.257] _save_exception_stack = 0x820b9d0b0 [22:57:07.257] _save_context_stack = 0x0 [22:57:07.257] _do_rethrow = false [22:57:07.257] saveTopTransactionResourceOwner = 0x835250240 [22:57:07.257] saveTopTransactionContext = 0x83532d000 [22:57:07.257] saveActivePortal = 0x0 [22:57:07.257] saveResourceOwner = 0x835250240 [22:57:07.257] savePortalContext = 0x0 [22:57:07.257] saveMemoryContext = 0x83532d000 [22:57:07.257] result = [22:57:07.257] nprocessed = [22:57:07.257] #18 0x00000000008e3f3b in exec_simple_query (query_string=query_string@entry=0x83516c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1274 [22:57:07.257] cmdtaglen = [22:57:07.257] snapshot_set = [22:57:07.257] per_parsetree_context = 0x0 [22:57:07.257] plantree_list = [22:57:07.257] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:57:07.257] parsetree = 0x835235c58 [22:57:07.257] commandTag = CMDTAG_EXPLAIN [22:57:07.257] cmdtagname = [22:57:07.257] querytree_list = [22:57:07.257] portal = 0x835241100 [22:57:07.257] format = 0 [22:57:07.257] receiver = 0x836ee3570 [22:57:07.257] parsetree_item__state = {l = 0x8352364e0, i = 0} [22:57:07.257] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [22:57:07.257] dest = DestRemote [22:57:07.257] was_logged = [22:57:07.257] oldcontext = 0x83532d000 [22:57:07.257] parsetree_list = 0x8352364e0 [22:57:07.257] use_implicit_block = false [22:57:07.257] parsetree_item = 0x8352364f8 [22:57:07.257] save_log_statement_stats = [22:57:07.257] #19 0x00000000008e1d24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [22:57:07.257] query_string = 0x83516c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [22:57:07.257] input_message = {data = 0x83516c100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [22:57:07.257] firstchar = [22:57:07.257] local_sigjmp_buf = {{_sjb = {9310704, 34908786864, 34908786824, 34908787424, 11976360, 11922832, 8192, 8388608, 72057628946662271, 0, 0, 34359738369}}} [22:57:07.257] send_ready_for_query = false [22:57:07.257] idle_in_transaction_timeout_enabled = false [22:57:07.257] idle_session_timeout_enabled = false [22:57:07.257] #20 0x00000000008dca89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:57:07.257] bsdata = [22:57:07.257] #21 0x000000000083991c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820b9ddf0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820b9dd38) at ../src/backend/postmaster/launch_backend.c:267 [22:57:07.257] pid = [22:57:07.257] #22 0x000000000083e131 in BackendStartup (client_sock=0x820b9dd38) at ../src/backend/postmaster/postmaster.c:3593 [22:57:07.257] startup_data = {canAcceptConnections = CAC_OK} [22:57:07.257] bn = 0x835178538 [22:57:07.257] pid = [22:57:07.257] __error = [22:57:07.257] __error = [22:57:07.257] save_errno = [22:57:07.257] __error = [22:57:07.257] __error = [22:57:07.257] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:57:07.257] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "\220ݹ \b\000\000\000\330Ō)\b", '\000' , "\016F\215)\b", '\000' , "\320ݹ \b\000\000\000\264\226\203\000\000\000\000\000\340ݹ \b", '\000' , "\v\000\000\000\000\000\000"}, salen = 16}} [22:57:07.257] i = 0 [22:57:07.257] now = [22:57:07.257] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 549049216, user_data = 0x0}, {pos = 552985608, events = 8, fd = 32, user_data = 0x820b9d500}, {pos = -270779756, events = 9478, fd = 552955912, user_data = 0x820f57408}, {pos = 552957960, events = 8, fd = 552958984, user_data = 0x820f5b008}, {pos = 552973320, events = 8, fd = 552974344, user_data = 0x820f5bc08}, {pos = 552976392, events = 8, fd = 552977416, user_data = 0x820f5c808}, {pos = 552979464, events = 8, fd = 552980488, user_data = 0x820f5d408}, {pos = 552982536, events = 8, fd = 552983560, user_data = 0x820f5e008}, {pos = 552985608, events = 8, fd = -1, user_data = 0x82aa562e0}, {pos = 549049456, events = 8, fd = 715141545, user_data = 0x0}, {pos = 4096, events = 0, fd = -257925346, user_data = 0x82aa567e8}, {pos = 882940896, events = 8, fd = 160, user_data = 0x0}, {pos = 864657552, events = 8, fd = 549049664, user_data = 0x82a9e192c}, {pos = 4096, events = 0, fd = 713566564, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 553011768, user_data = 0x800000001}, {pos = 552985608, events = 8, fd = 713480408, user_data = 0x820b9d5c8}, {pos = 549049216, events = 8, fd = 32, user_data = 0x82a87ec64}, {pos = 552985608, events = 8, fd = 553011768, user_data = 0x0}, {pos = 2625, events = 0, fd = 549049776, user_data = 0x2506efdc3645}, {pos = 713566564, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 553011768, events = 8, fd = 1, user_data = 0x820f5e408}, {pos = 890617856, events = 8, fd = 1, user_data = 0x83515c194}, {pos = 0, events = 0, fd = 549049728, user_data = 0x8298d3c0c}, {pos = 1, events = 0, fd = 890617856, user_data = 0x820b9d5b0}, {pos = 697118388, events = 8, fd = 715293024, user_data = 0x82aa28160 }, {pos = 713662656, events = 8, fd = 552985608, user_data = 0x820b9d690}, {pos = -270781396, events = 9478, fd = 864657552, user_data = 0x800000001}, {pos = -270781778, events = 9478, fd = 12240, user_data = 0x820b9d5b8}, {pos = 549050000, events = 8, fd = 891295720, user_data = 0x820b9dc00}, {pos = -270700912, events = 9478, fd = 552985608, user_data = 0x820b9037f}, {pos = 714950044, events = 8, fd = 552955912, user_data = 0x0}, {pos = 552985608, events = 8, fd = 12240, user_data = 0x82a85e000}, {pos = 1964368, events = 0, fd = 715293024, user_data = 0x82a87ec64}, {pos = 15616, events = 0, fd = 549051184, user_data = 0x820b9d700}, {pos = 714224014, events = 8, fd = 715331640, user_data = 0x820b9d6c4}, {pos = 891033050, events = 8, fd = 549051184, user_data = 0x820b9d700}, {pos = 714315269, events = 8, fd = 549050050, user_data = 0x820b9db30}, {pos = 549051184, events = 8, fd = 0, user_data = 0x538003a0f0a05f1e}, {pos = 549051184, events = 8, fd = 891033048, user_data = 0x820b9dc00}, {pos = 715331640, events = 8, fd = 0, user_data = 0x820b9db70}, {pos = 714315533, events = 8, fd = 0, user_data = 0x0}, {pos = 549051552, events = 8, fd = 891033048, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -270752759, events = 9478, fd = 549050456, user_data = 0x82a87ec64}, {pos = 2503, events = 0, fd = -270752759, user_data = 0x820b9d878}, {pos = 713550948, events = 8, fd = 2758, user_data = 0x82a878120}, {pos = 549050360, events = 8, fd = 552985608, user_data = 0x820b9d878}, {pos = 713523488, events = 8, fd = 549050464, user_data = 0x2506efdc5465}, {pos = 0, events = 0, fd = 0, user_data = 0x82aa4a0f0}, {pos = 713483600, events = 8, fd = 0, user_data = 0x0}, {pos = 715360688, events = 8, fd = -270752759, user_data = 0x820b9d908}, {pos = 713550948, events = 8, fd = 2924, user_data = 0x82a8783b8}, {pos = 549050504, events = 8, fd = 552985608, user_data = 0x820b9d908}, {pos = 713524152, events = 8, fd = 549050608, user_data = 0x2506efdc5465}, {pos = 553009208, events = 8, fd = 2669238, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 552985608, events = 8, fd = 713483600, user_data = 0x820b9dbc8}, {pos = 552985608, events = 8, fd = 549051048, user_data = 0x1e}, {pos = 713487584, events = 8, fd = 549050776, user_data = 0x820f63248}, {pos = 549051224, events = 8, fd = 549050752, user_data = 0x2506efdc9da3}, {pos = 553009208, events = 8, fd = 2692555, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 553009208, user_data = 0x1}} [22:57:07.258] last_touch_time = 1710888857 [22:57:07.258] last_lockfile_recheck_time = 1710888857 [22:57:07.258] nevents = 1 [22:57:07.258] #24 0x000000000083ba06 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820b9e330) at ../src/backend/postmaster/postmaster.c:1372 [22:57:07.258] userDoption = [22:57:07.258] listen_addr_saved = false [22:57:07.258] output_config_variable = [22:57:07.258] opt = [22:57:07.258] status = [22:57:07.258] #25 0x0000000000778a05 in main (argc=8, argv=0x820b9e330) at ../src/backend/main/main.c:197 [22:57:07.258] do_check_root = [22:57:07.268] [22:57:07.268] [22:57:07.268] [22:57:07.327] dumping /tmp/cores/postgres.17288.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:57:07.449] [New LWP 101785] [22:57:07.518] Core was generated by `postgres: primary: postgres regression [local] SELECT'. [22:57:07.518] Program terminated with signal SIGSEGV, Segmentation fault. [22:57:07.518] Address not mapped to object. [22:57:07.518] #0 equal (a=0x3d7f7828, b=b@entry=0x83d7f4118) at ../src/backend/nodes/equalfuncs.c:239 [22:57:07.518] 239 if (nodeTag(a) != nodeTag(b)) [22:57:07.571] [22:57:07.571] Thread 1 (LWP 101785): [22:57:07.571] #0 equal (a=0x3d7f7828, b=b@entry=0x83d7f4118) at ../src/backend/nodes/equalfuncs.c:239 [22:57:07.571] retval = [22:57:07.571] #1 0x000000000077c142 in list_member (list=0x83d7f7898, datum=datum@entry=0x83d7f4118) at ../src/backend/nodes/list.c:670 [22:57:07.571] cell__state = {l = 0x83d7f7898, i = 0} [22:57:07.571] cell = 0x0 [22:57:07.571] cell__state = [22:57:07.571] #2 0x00000000007efbb5 in add_new_column_to_pathtarget (target=0x83d7f77b8, expr=) at ../src/backend/optimizer/util/tlist.c:743 [22:57:07.571] No locals. [22:57:07.571] #3 add_new_columns_to_pathtarget (target=target@entry=0x83d7f77b8, exprs=0x83d7f79c8) at ../src/backend/optimizer/util/tlist.c:760 [22:57:07.571] expr = [22:57:07.571] lc__state = {l = 0x83d7f79c8, i = 0} [22:57:07.571] lc = 0xfffffe3a [22:57:07.571] #4 0x00000000007bf539 in make_group_input_target (root=0x835d079e0, final_target=0x83d7f7658) at ../src/backend/optimizer/plan/planner.c:5472 [22:57:07.571] parse = 0x83d715da0 [22:57:07.571] input_target = 0x83d7f77b8 [22:57:07.571] non_group_cols = 0x83d7f7978 [22:57:07.571] i = [22:57:07.571] lc = [22:57:07.571] non_group_vars = 0x83d7f79c8 [22:57:07.571] #5 grouping_planner (root=root@entry=0x835d079e0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:57:07.571] qp_extra = {activeWindows = 0x0, gset_data = 0x83d7f5568} [22:57:07.571] activeWindows = 0x0 [22:57:07.571] sort_input_target_parallel_safe = false [22:57:07.571] grouping_target = 0x83d7f7658 [22:57:07.571] scanjoin_target = [22:57:07.571] sort_input_targets = [22:57:07.571] wflists = 0x0 [22:57:07.571] gset_data = 0x83d7f5568 [22:57:07.571] have_grouping = false [22:57:07.571] sort_input_targets_contain_srfs = [22:57:07.571] sort_input_target = 0x83d7f7658 [22:57:07.571] grouping_target_parallel_safe = false [22:57:07.571] scanjoin_target_parallel_safe = [22:57:07.571] grouping_targets = [22:57:07.571] scanjoin_targets = [22:57:07.571] grouping_targets_contain_srfs = [22:57:07.571] scanjoin_targets_contain_srfs = [22:57:07.571] scanjoin_target_same_exprs = [22:57:07.571] extra = {limit_needed = 72, limit_tuples = 1.7485720261357232e-313, count_est = 72, offset_est = 34917989040} [22:57:07.571] parse = 0x83d715da0 [22:57:07.571] offset_est = [22:57:07.571] count_est = [22:57:07.571] limit_tuples = -1 [22:57:07.571] have_postponed_srfs = false [22:57:07.571] current_rel = 0x83d7d9688 [22:57:07.571] final_target = 0x83d7f7658 [22:57:07.571] final_targets_contain_srfs = [22:57:07.571] final_targets = [22:57:07.571] final_rel = [22:57:07.571] lc = [22:57:07.571] final_target_parallel_safe = [22:57:07.571] #6 0x00000000007bd444 in subquery_planner (glob=glob@entry=0x83d7f1a00, parse=parse@entry=0x83d715da0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:57:07.571] root = 0x835d079e0 [22:57:07.571] hasOuterJoins = false [22:57:07.571] hasResultRTEs = false [22:57:07.571] l = [22:57:07.571] newWithCheckOptions = [22:57:07.571] newHaving = 0x0 [22:57:07.571] final_rel = [22:57:07.571] #7 0x00000000007bbf68 in standard_planner (parse=0x83d715da0, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [22:57:07.571] glob = 0x83d7f1a00 [22:57:07.571] tuple_fraction = 0 [22:57:07.571] root = [22:57:07.571] final_rel = [22:57:07.571] best_path = [22:57:07.571] top_plan = [22:57:07.571] lp = [22:57:07.571] lr = [22:57:07.571] result = [22:57:07.571] #8 0x00000008386636af in pgss_planner (parse=0x83d715da0, query_string=0x83d7f4118 "\006", cursorOptions=558250496, boundParams=0xfffffe3a) at ../contrib/pg_stat_statements/pg_stat_statements.c:972 [22:57:07.571] _local_sigjmp_buf = {{_sjb = {35305960797, 11967624, 34917989624, 34917990080, 34917989664, 0, 35390578080, 34917990480, 35391472511, 35390575888, 34917989776, 0}}} [22:57:07.571] _save_exception_stack = 0x821464050 [22:57:07.571] _save_context_stack = 0x0 [22:57:07.571] _do_rethrow = false [22:57:07.571] result = [22:57:07.571] #9 0x00000000007bbe35 in planner (parse=0x3d7f7828, parse@entry=0x83d715da0, query_string=0x83d7f4118 "\006", query_string@entry=0x835bcf100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=558250496, cursorOptions@entry=2048, boundParams=0xfffffe3a, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [22:57:07.571] result = [22:57:07.571] #10 0x00000000008dfbd5 in pg_plan_query (querytree=querytree@entry=0x83d715da0, query_string=query_string@entry=0x835bcf100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [22:57:07.571] plan = [22:57:07.571] #11 0x00000000008dfcb2 in pg_plan_queries (querytrees=0x83d7f19b0, query_string=query_string@entry=0x835bcf100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=558250496, cursorOptions@entry=2048, boundParams=0xfffffe3a, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [22:57:07.571] query = 0x83d715da0 [22:57:07.571] stmt = [22:57:07.571] query_list__state = {l = 0x83d7f19b0, i = 0} [22:57:07.571] stmt_list = 0x0 [22:57:07.571] query_list = [22:57:07.571] #12 0x00000000008e3e4c in exec_simple_query (query_string=query_string@entry=0x835bcf100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [22:57:07.571] cmdtaglen = [22:57:07.571] snapshot_set = [22:57:07.571] per_parsetree_context = 0x0 [22:57:07.571] plantree_list = [22:57:07.571] qc = {commandTag = 336, nprocessed = 6} [22:57:07.571] parsetree = 0x835d08600 [22:57:07.571] commandTag = [22:57:07.571] cmdtagname = [22:57:07.571] querytree_list = 0x0 [22:57:07.571] portal = [22:57:07.571] format = [22:57:07.571] receiver = [22:57:07.571] parsetree_item__state = {l = 0x83d7d92b8, i = 0} [22:57:07.571] 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" [22:57:07.571] dest = DestRemote [22:57:07.571] was_logged = [22:57:07.571] oldcontext = 0x835bdb000 [22:57:07.571] parsetree_list = 0x83d7d92b8 [22:57:07.571] use_implicit_block = false [22:57:07.571] parsetree_item = 0x83d7d92d0 [22:57:07.571] save_log_statement_stats = [22:57:07.571] #13 0x00000000008e1d24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [22:57:07.571] query_string = 0x835bcf100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [22:57:07.571] input_message = {data = 0x835bcf100 "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} [22:57:07.571] firstchar = [22:57:07.571] local_sigjmp_buf = {{_sjb = {9310704, 34917990480, 34917990440, 34917991040, 11976360, 11922832, 8192, 8388608, 72057628955902847, 0, 0, 1}}} [22:57:07.571] send_ready_for_query = false [22:57:07.571] idle_in_transaction_timeout_enabled = false [22:57:07.571] idle_session_timeout_enabled = false [22:57:07.571] #14 0x00000000008dca89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:57:07.571] bsdata = [22:57:07.571] #15 0x000000000083991c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x821464d90 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x821464cd8) at ../src/backend/postmaster/launch_backend.c:267 [22:57:07.571] pid = [22:57:07.571] #16 0x000000000083e131 in BackendStartup (client_sock=0x821464cd8) at ../src/backend/postmaster/postmaster.c:3593 [22:57:07.571] startup_data = {canAcceptConnections = CAC_OK} [22:57:07.571] bn = 0x835bdb538 [22:57:07.571] pid = [22:57:07.571] __error = [22:57:07.571] __error = [22:57:07.571] save_errno = [22:57:07.571] __error = [22:57:07.571] __error = [22:57:07.571] #17 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:57:07.571] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "0MF!\b\000\000\000\330\325!*\b", '\000' , "\016V\"*\b", '\000' , "pMF!\b\000\000\000\264\226\203\000\000\000\000\000\200MF!\b", '\000' , "\v\000\000\000\000\000\000"}, salen = 16}} [22:57:07.571] i = 0 [22:57:07.571] now = [22:57:07.571] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 558253232, events = 8, fd = 558666760, user_data = 0x21}, {pos = 558253216, events = 8, fd = -1243952492, user_data = 0x8214c2008}, {pos = 558638088, events = 8, fd = 558639112, user_data = 0x8214c2c08}, {pos = 558653448, events = 8, fd = 558654472, user_data = 0x8214c6808}, {pos = 558656520, events = 8, fd = 558657544, user_data = 0x8214c7408}, {pos = 558659592, events = 8, fd = 558660616, user_data = 0x8214c8008}, {pos = 558662664, events = 8, fd = 558663688, user_data = 0x8214c8c08}, {pos = 558665736, events = 8, fd = 558666760, user_data = 0x8214ce088}, {pos = 558253608, events = 8, fd = 558253120, user_data = 0x3b38b5db2da3}, {pos = 558666760, events = 8, fd = 2566710, user_data = 0x6de90a5}, {pos = -25761258, events = 0, fd = 558690360, user_data = 0x1}, {pos = 558666760, events = 8, fd = 729576616, user_data = 0x821464728}, {pos = 558666760, events = 8, fd = 558253088, user_data = 0x272980}, {pos = 558253680, events = 8, fd = 729684324, user_data = 0x7ab9a6e}, {pos = 479451855, events = 0, fd = 558692920, user_data = 0x3b3800000001}, {pos = 558666760, events = 8, fd = 729598168, user_data = 0x821464568}, {pos = 558252816, events = 8, fd = 33, user_data = 0x82b7ddc64}, {pos = 558666760, events = 8, fd = 558692920, user_data = 0x0}, {pos = 2625, events = 0, fd = 558253392, user_data = 0x3b38b5dac645}, {pos = 729684324, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 558692920, events = 8, fd = 1, user_data = 0x8214c9408}, {pos = 901509120, events = 8, fd = 1, user_data = 0x835bbf194}, {pos = 0, events = 0, fd = 558253344, user_data = 0x82a224c0c}, {pos = 1, events = 0, fd = 901509120, user_data = 0x821464550}, {pos = 706887348, events = 8, fd = 731410784, user_data = 0x82b987160 }, {pos = 729780416, events = 8, fd = 558666760, user_data = 0x821464630}, {pos = -1243954132, events = 15160, fd = 80627796, user_data = 0x1}, {pos = -1243954514, events = 15160, fd = 12240, user_data = 0x821464558}, {pos = 558253616, events = 8, fd = 902305768, user_data = 0x821464ba0}, {pos = -1243873648, events = 15160, fd = 558666760, user_data = 0x82146037f}, {pos = 731067570, events = 8, fd = 558253920, user_data = 0x3b3800000000}, {pos = 558666760, events = 8, fd = 12240, user_data = 0x82b7bd000}, {pos = 1964368, events = 0, fd = 731410784, user_data = 0x82b7ddc64}, {pos = 15616, events = 0, fd = 558254800, user_data = 0x8214646a0}, {pos = 730341774, events = 8, fd = 731449400, user_data = 0x821464664}, {pos = 901932506, events = 8, fd = 558254800, user_data = 0x8214646a0}, {pos = 730433029, events = 8, fd = 558253666, user_data = 0x821464ad0}, {pos = 558254800, events = 8, fd = 0, user_data = 0xd7182f5eae508570}, {pos = 558254800, events = 8, fd = 901932504, user_data = 0x821464ba0}, {pos = 731449400, events = 8, fd = 0, user_data = 0x821464b10}, {pos = 730433293, events = 8, fd = 0, user_data = 0x0}, {pos = 558255168, events = 8, fd = 901932504, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1243925495, user_data = 0x8214647e8}, {pos = 729668708, events = 8, fd = 2503, user_data = 0x3b38b5db3409}, {pos = 558254088, events = 8, fd = 729668708, user_data = 0xac6}, {pos = 729641248, events = 8, fd = 558253960, user_data = 0x8214c9408}, {pos = 558254088, events = 8, fd = 729641248, user_data = 0x8214647f0}, {pos = -1243945883, events = 15160, fd = 0, user_data = 0x800000000}, {pos = 558254048, events = 8, fd = 729601360, user_data = 0x0}, {pos = 0, events = 0, fd = 558254016, user_data = 0x3b38b5db3409}, {pos = 558254232, events = 8, fd = 729668708, user_data = 0xb6c}, {pos = 729641912, events = 8, fd = 558254104, user_data = 0x8214c9408}, {pos = 558254232, events = 8, fd = 729641912, user_data = 0x821464880}, {pos = -1243945883, events = 15160, fd = 558690360, user_data = 0x28bab6}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 558666760, user_data = 0x82b7cd550}, {pos = 558254952, events = 8, fd = 558666760, user_data = 0x21464a48}, {pos = 31, events = 0, fd = 0, user_data = 0x821464928}, {pos = 558688136, events = 8, fd = 558254840, user_data = 0x821464910}, {pos = -1243927133, events = 15160, fd = 558690360, user_data = 0x2915cb}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8214cf038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [22:57:07.571] last_touch_time = 1710888882 [22:57:07.571] last_lockfile_recheck_time = 1710888882 [22:57:07.571] nevents = 1 [22:57:07.571] #18 0x000000000083ba06 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8214652d8) at ../src/backend/postmaster/postmaster.c:1372 [22:57:07.571] userDoption = [22:57:07.571] listen_addr_saved = false [22:57:07.571] output_config_variable = [22:57:07.571] opt = [22:57:07.571] status = [22:57:07.571] #19 0x0000000000778a05 in main (argc=4, argv=0x8214652d8) at ../src/backend/main/main.c:197 [22:57:07.571] do_check_root = [22:57:07.579] [22:57:07.579] [22:57:07.579] [22:57:07.640] dumping /tmp/cores/postgres.18711.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:57:07.761] [New LWP 101834] [22:57:07.834] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT'. [22:57:07.834] Program terminated with signal SIGSEGV, Segmentation fault. [22:57:07.834] Address not mapped to object. [22:57:07.834] #0 get_expr_width (root=root@entry=0x8363826c0, expr=expr@entry=0x36439630) at ../src/backend/optimizer/path/costsize.c:6328 [22:57:07.834] 6328 if (IsA(expr, Var)) [22:57:07.859] [22:57:07.859] Thread 1 (LWP 101834): [22:57:07.859] #0 get_expr_width (root=root@entry=0x8363826c0, expr=expr@entry=0x36439630) at ../src/backend/optimizer/path/costsize.c:6328 [22:57:07.859] width = [22:57:07.859] #1 0x0000000000796ed5 in set_pathtarget_cost_width (root=root@entry=0x8363826c0, target=target@entry=0x8364395c0) at ../src/backend/optimizer/path/costsize.c:6299 [22:57:07.859] node = 0x36439630 [22:57:07.859] lc__state = {l = 0x8364396a0, i = 0} [22:57:07.859] tuple_width = 0 [22:57:07.859] lc = 0x8364396b8 [22:57:07.859] #2 0x00000000007bf554 in make_group_input_target (root=0x8363826c0, final_target=0x836439500) at ../src/backend/optimizer/plan/planner.c:5479 [22:57:07.859] parse = 0x836385af0 [22:57:07.859] input_target = 0x8364395c0 [22:57:07.859] non_group_cols = 0x0 [22:57:07.859] i = [22:57:07.859] lc = [22:57:07.859] non_group_vars = 0x0 [22:57:07.859] #3 grouping_planner (root=root@entry=0x8363826c0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:57:07.859] qp_extra = {activeWindows = 0x0, gset_data = 0x8364361b8} [22:57:07.859] activeWindows = 0x0 [22:57:07.859] sort_input_target_parallel_safe = false [22:57:07.859] grouping_target = 0x836439500 [22:57:07.859] scanjoin_target = [22:57:07.859] sort_input_targets = [22:57:07.859] wflists = 0x0 [22:57:07.859] gset_data = 0x8364361b8 [22:57:07.859] have_grouping = false [22:57:07.859] sort_input_targets_contain_srfs = [22:57:07.859] sort_input_target = 0x836439500 [22:57:07.859] grouping_target_parallel_safe = false [22:57:07.859] scanjoin_target_parallel_safe = [22:57:07.859] grouping_targets = [22:57:07.859] scanjoin_targets = [22:57:07.859] grouping_targets_contain_srfs = [22:57:07.859] scanjoin_targets_contain_srfs = [22:57:07.859] scanjoin_target_same_exprs = [22:57:07.859] extra = {limit_needed = 144, limit_tuples = 1.7254389536353347e-313, count_est = 16, offset_est = 34923273248} [22:57:07.859] parse = 0x836385af0 [22:57:07.859] offset_est = [22:57:07.859] count_est = [22:57:07.859] limit_tuples = -1 [22:57:07.859] have_postponed_srfs = false [22:57:07.859] current_rel = 0x836437af0 [22:57:07.859] final_target = 0x836439500 [22:57:07.859] final_targets_contain_srfs = [22:57:07.859] final_targets = [22:57:07.859] final_rel = [22:57:07.859] lc = [22:57:07.859] final_target_parallel_safe = [22:57:07.859] #4 0x00000000007bd444 in subquery_planner (glob=glob@entry=0x836387418, parse=parse@entry=0x836385af0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:57:07.859] root = 0x8363826c0 [22:57:07.859] hasOuterJoins = false [22:57:07.859] hasResultRTEs = false [22:57:07.859] l = [22:57:07.859] newWithCheckOptions = [22:57:07.859] newHaving = 0x0 [22:57:07.859] final_rel = [22:57:07.859] #5 0x00000000007bbf68 in standard_planner (parse=0x836385af0, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [22:57:07.859] glob = 0x836387418 [22:57:07.859] tuple_fraction = 0 [22:57:07.859] root = [22:57:07.859] final_rel = [22:57:07.859] best_path = [22:57:07.859] top_plan = [22:57:07.859] lp = [22:57:07.859] lr = [22:57:07.859] result = [22:57:07.859] #6 0x00000008361f0712 in pgss_planner (parse=0x836385af0, query_string=0x83480c100 "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=0x8364396b8) at ../contrib/pg_stat_statements/pg_stat_statements.c:926 [22:57:07.859] _local_sigjmp_buf = {{_sjb = {35267741295, 35240591616, 34923273832, 34923274288, 11967624, 35269401328, 34923274000, 0, 34923217791, 11152765, 2, 34359738368}}} [22:57:07.859] _save_exception_stack = 0x82196e1c0 [22:57:07.859] _save_context_stack = 0x0 [22:57:07.859] _do_rethrow = false [22:57:07.859] bufusage = {shared_blks_hit = 35267741295, shared_blks_read = 35240591616, shared_blks_dirtied = 34923273832, shared_blks_written = 34923274288, local_blks_hit = 11967624, local_blks_read = 35269401328, local_blks_dirtied = 34923274000, local_blks_written = 0, temp_blks_read = 34923217791, temp_blks_written = 11152765, shared_blk_read_time = {ticks = 2}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 34923274144}, local_blk_write_time = {ticks = 11181727}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 35269407512}} [22:57:07.859] walusage_start = {wal_records = 1346, wal_fpi = 2, wal_bytes = 170363} [22:57:07.859] duration = [22:57:07.859] 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}} [22:57:07.859] walusage = {wal_records = 35269401328, wal_fpi = 35270240632, wal_bytes = 34923274208} [22:57:07.859] start = [22:57:07.859] result = [22:57:07.859] #7 0x00000000007bbe35 in planner (parse=0x8363826c0, parse@entry=0x836385af0, query_string=0x36439630 , query_string@entry=0x83480c100 "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=0x8364396b8, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [22:57:07.859] result = [22:57:07.859] #8 0x00000000008dfbd5 in pg_plan_query (querytree=querytree@entry=0x836385af0, query_string=query_string@entry=0x83480c100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [22:57:07.859] plan = [22:57:07.859] #9 0x00000000008dfcb2 in pg_plan_queries (querytrees=0x8363873c8, query_string=query_string@entry=0x83480c100 "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=0x8364396b8, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [22:57:07.859] query = 0x836385af0 [22:57:07.859] stmt = [22:57:07.859] query_list__state = {l = 0x8363873c8, i = 0} [22:57:07.859] stmt_list = 0x0 [22:57:07.859] query_list = [22:57:07.859] #10 0x00000000008e3e4c in exec_simple_query (query_string=query_string@entry=0x83480c100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;") at ../src/backend/tcop/postgres.c:1193 [22:57:07.859] cmdtaglen = [22:57:07.859] snapshot_set = [22:57:07.859] per_parsetree_context = 0x0 [22:57:07.859] plantree_list = [22:57:07.859] qc = {commandTag = 336, nprocessed = 6} [22:57:07.859] parsetree = 0x8363f5cb0 [22:57:07.859] commandTag = [22:57:07.859] cmdtagname = [22:57:07.859] querytree_list = 0x0 [22:57:07.859] portal = [22:57:07.859] format = [22:57:07.859] receiver = [22:57:07.859] parsetree_item__state = {l = 0x836452928, i = 0} [22:57:07.859] 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" [22:57:07.859] dest = DestRemote [22:57:07.859] was_logged = [22:57:07.859] oldcontext = 0x834818000 [22:57:07.859] parsetree_list = 0x836452928 [22:57:07.859] use_implicit_block = false [22:57:07.859] parsetree_item = 0x836452940 [22:57:07.859] save_log_statement_stats = [22:57:07.859] #11 0x00000000008e1d24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [22:57:07.859] query_string = 0x83480c100 "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;" [22:57:07.859] input_message = {data = 0x83480c100 "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} [22:57:07.859] firstchar = [22:57:07.859] local_sigjmp_buf = {{_sjb = {9310704, 34923274688, 34923274648, 34923275248, 11976360, 11922832, 8192, 8388608, 72057628961145727, 0, 0, 34359738369}}} [22:57:07.859] send_ready_for_query = false [22:57:07.859] idle_in_transaction_timeout_enabled = false [22:57:07.859] idle_session_timeout_enabled = false [22:57:07.859] #12 0x00000000008dca89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:57:07.859] bsdata = [22:57:07.859] #13 0x000000000083991c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82196ef00 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82196ee48) at ../src/backend/postmaster/launch_backend.c:267 [22:57:07.859] pid = [22:57:07.859] #14 0x000000000083e131 in BackendStartup (client_sock=0x82196ee48) at ../src/backend/postmaster/postmaster.c:3593 [22:57:07.859] startup_data = {canAcceptConnections = CAC_OK} [22:57:07.859] bn = 0x834818238 [22:57:07.859] pid = [22:57:07.859] __error = [22:57:07.859] __error = [22:57:07.859] save_errno = [22:57:07.859] __error = [22:57:07.859] __error = [22:57:07.859] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:57:07.859] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "\240\356\226!\b\000\000\000\3305\206*\b", '\000' , "\016\266\206*\b", '\000' , "\340\356\226!\b\000\000\000\264\226\203\000\000\000\000\000\360\356\226!\b", '\000' , "\v\000\000\000\000\000\000"}, salen = 16}} [22:57:07.859] i = 0 [22:57:07.859] now = [22:57:07.859] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 563537440, events = 8, fd = 567055368, user_data = 0x21}, {pos = 563537424, events = 8, fd = 928299668, user_data = 0x821cc2008}, {pos = 567026696, events = 8, fd = 567027720, user_data = 0x821cc2c08}, {pos = 567042056, events = 8, fd = 567043080, user_data = 0x821cc6808}, {pos = 567045128, events = 8, fd = 567046152, user_data = 0x821cc7408}, {pos = 567048200, events = 8, fd = 567049224, user_data = 0x821cc8008}, {pos = 567051272, events = 8, fd = 567052296, user_data = 0x821cc8c08}, {pos = 567054344, events = 8, fd = 567055368, user_data = 0x833a09be0}, {pos = 160, events = 0, fd = -1, user_data = 0x82ad7c2e0}, {pos = 563537280, events = 8, fd = 718442921, user_data = 0x0}, {pos = 4096, events = 0, fd = 523677790, user_data = 0x82ad7c7e8}, {pos = 866163680, events = 8, fd = 160, user_data = 0x0}, {pos = 843546768, events = 8, fd = 563537488, user_data = 0x82ad0792c}, {pos = 4096, events = 0, fd = 716867940, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 567081528, user_data = 0x800000001}, {pos = 567055368, events = 8, fd = 716781784, user_data = 0x82196e6d8}, {pos = 563537024, events = 8, fd = 33, user_data = 0x82aba4c64}, {pos = 567055368, events = 8, fd = 567081528, user_data = 0x0}, {pos = 2625, events = 0, fd = 563537600, user_data = 0xb2e3754b645}, {pos = 716867940, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 567081528, events = 8, fd = 1, user_data = 0x821cc9408}, {pos = 880787456, events = 8, fd = 1, user_data = 0x8347fc194}, {pos = 0, events = 0, fd = 563537552, user_data = 0x82a86ac0c}, {pos = 1, events = 0, fd = 880787456, user_data = 0x82196e6c0}, {pos = 713465524, events = 8, fd = 718594400, user_data = 0x82ad4e160 }, {pos = 716964032, events = 8, fd = 567055368, user_data = 0x82196e7a0}, {pos = 928298028, events = 2862, fd = 843546768, user_data = 0x800000001}, {pos = 928297646, events = 2862, fd = 12240, user_data = 0x82196e6c8}, {pos = 563537824, events = 8, fd = 881444840, user_data = 0x82196ed10}, {pos = 928378512, events = 2862, fd = 567055368, user_data = 0x82196037f}, {pos = 718251420, events = 8, fd = 563538128, user_data = 0xb2e00000000}, {pos = 567055368, events = 8, fd = 12240, user_data = 0x82ab84000}, {pos = 1964368, events = 0, fd = 718594400, user_data = 0x82aba4c64}, {pos = 15616, events = 0, fd = 563539008, user_data = 0x82196e810}, {pos = 717525390, events = 8, fd = 718633016, user_data = 0x82196e7d4}, {pos = 881182170, events = 8, fd = 563539008, user_data = 0x82196e810}, {pos = 717616645, events = 8, fd = 563537874, user_data = 0x82196ec40}, {pos = 563539008, events = 8, fd = 0, user_data = 0xd56a4a7e1f36b05e}, {pos = 563539008, events = 8, fd = 881182168, user_data = 0x82196ed10}, {pos = 718633016, events = 8, fd = 0, user_data = 0x82196ec80}, {pos = 717616909, events = 8, fd = 0, user_data = 0x0}, {pos = 563539376, events = 8, fd = 881182168, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 928326665, user_data = 0x82196e958}, {pos = 716852324, events = 8, fd = 2503, user_data = 0xb2e37552409}, {pos = 563538296, events = 8, fd = 716852324, user_data = 0xac6}, {pos = 716824864, events = 8, fd = 563538168, user_data = 0x821cc9408}, {pos = 563538296, events = 8, fd = 716824864, user_data = 0x82196e960}, {pos = 928306277, events = 2862, fd = 0, user_data = 0x800000000}, {pos = 563538256, events = 8, fd = 716784976, user_data = 0x0}, {pos = 0, events = 0, fd = 563538224, user_data = 0xb2e37552409}, {pos = 563538440, events = 8, fd = 716852324, user_data = 0xb6c}, {pos = 716825528, events = 8, fd = 563538312, user_data = 0x821cc9408}, {pos = 563538440, events = 8, fd = 716825528, user_data = 0x82196e9f0}, {pos = 928306277, events = 2862, fd = 567078968, user_data = 0x28bab6}, {pos = 207642559, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 567055368, user_data = 0x82ab94550}, {pos = 563539160, events = 8, fd = 567055368, user_data = 0x2196ebb8}, {pos = 31, events = 0, fd = 0, user_data = 0x82196ea98}, {pos = 567076744, events = 8, fd = 563539048, user_data = 0x82196ea80}, {pos = 928325027, events = 2862, fd = 567078968, user_data = 0x2915cb}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ccf038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}} [22:57:07.859] last_touch_time = 1710888903 [22:57:07.859] last_lockfile_recheck_time = 1710888903 [22:57:07.859] nevents = 1 [22:57:07.859] #16 0x000000000083ba06 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82196f448) at ../src/backend/postmaster/postmaster.c:1372 [22:57:07.859] userDoption = [22:57:07.859] listen_addr_saved = false [22:57:07.859] output_config_variable = [22:57:07.859] opt = [22:57:07.859] status = [22:57:07.859] #17 0x0000000000778a05 in main (argc=8, argv=0x82196f448) at ../src/backend/main/main.c:197 [22:57:07.859] do_check_root = [22:57:07.867] [22:57:07.867] [22:57:07.867] [22:57:07.930] dumping /tmp/cores/postgres.18875.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:57:08.054] [New LWP 101812] [22:57:08.128] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN'. [22:57:08.128] Program terminated with signal SIGSEGV, Segmentation fault. [22:57:08.128] Address not mapped to object. [22:57:08.128] #0 equal (a=0x3488e0d8, b=b@entry=0x834835678) at ../src/backend/nodes/equalfuncs.c:239 [22:57:08.128] 239 if (nodeTag(a) != nodeTag(b)) [22:57:08.616] [22:57:08.616] Thread 1 (LWP 101812): [22:57:08.616] #0 equal (a=0x3488e0d8, b=b@entry=0x834835678) at ../src/backend/nodes/equalfuncs.c:239 [22:57:08.616] retval = [22:57:08.616] #1 0x000000000077c142 in list_member (list=0x83488e148, datum=datum@entry=0x834835678) at ../src/backend/nodes/list.c:670 [22:57:08.616] cell__state = {l = 0x83488e148, i = 0} [22:57:08.616] cell = 0x0 [22:57:08.616] cell__state = [22:57:08.616] #2 0x00000000007efbb5 in add_new_column_to_pathtarget (target=0x83488e088, expr=) at ../src/backend/optimizer/util/tlist.c:743 [22:57:08.616] No locals. [22:57:08.616] #3 add_new_columns_to_pathtarget (target=target@entry=0x83488e088, exprs=0x83488e1e8) at ../src/backend/optimizer/util/tlist.c:760 [22:57:08.616] expr = [22:57:08.616] lc__state = {l = 0x83488e1e8, i = 0} [22:57:08.616] lc = 0xfffffe3a [22:57:08.616] #4 0x00000000007bf539 in make_group_input_target (root=0x834835038, final_target=0x8349a9fa8) at ../src/backend/optimizer/plan/planner.c:5472 [22:57:08.616] parse = 0x841ebcda0 [22:57:08.616] input_target = 0x83488e088 [22:57:08.616] non_group_cols = 0x83488e198 [22:57:08.616] i = [22:57:08.616] lc = [22:57:08.616] non_group_vars = 0x83488e1e8 [22:57:08.616] #5 grouping_planner (root=root@entry=0x834835038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:57:08.616] qp_extra = {activeWindows = 0x0, gset_data = 0x8348358a8} [22:57:08.616] activeWindows = 0x0 [22:57:08.616] sort_input_target_parallel_safe = false [22:57:08.616] grouping_target = 0x8349a9fa8 [22:57:08.616] scanjoin_target = [22:57:08.616] sort_input_targets = [22:57:08.616] wflists = 0x0 [22:57:08.616] gset_data = 0x8348358a8 [22:57:08.616] have_grouping = false [22:57:08.616] sort_input_targets_contain_srfs = [22:57:08.616] sort_input_target = 0x8349a9fa8 [22:57:08.616] grouping_target_parallel_safe = false [22:57:08.616] scanjoin_target_parallel_safe = [22:57:08.616] grouping_targets = [22:57:08.616] scanjoin_targets = [22:57:08.616] grouping_targets_contain_srfs = [22:57:08.616] scanjoin_targets_contain_srfs = [22:57:08.616] scanjoin_target_same_exprs = [22:57:08.616] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 34922337792} [22:57:08.616] parse = 0x841ebcda0 [22:57:08.616] offset_est = [22:57:08.616] count_est = [22:57:08.616] limit_tuples = -1 [22:57:08.616] have_postponed_srfs = false [22:57:08.616] current_rel = 0x83486edd8 [22:57:08.616] final_target = 0x8349a9fa8 [22:57:08.616] final_targets_contain_srfs = [22:57:08.616] final_targets = [22:57:08.616] final_rel = [22:57:08.616] lc = [22:57:08.616] final_target_parallel_safe = [22:57:08.616] #6 0x00000000007bd444 in subquery_planner (glob=glob@entry=0x83486e998, parse=parse@entry=0x841ebcda0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:57:08.616] root = 0x834835038 [22:57:08.616] hasOuterJoins = false [22:57:08.616] hasResultRTEs = false [22:57:08.616] l = [22:57:08.616] newWithCheckOptions = [22:57:08.616] newHaving = 0x0 [22:57:08.616] final_rel = [22:57:08.616] #7 0x00000000007bbf68 in standard_planner (parse=0x841ebcda0, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [22:57:08.616] glob = 0x83486e998 [22:57:08.616] tuple_fraction = 0 [22:57:08.616] root = [22:57:08.616] final_rel = [22:57:08.616] best_path = [22:57:08.616] top_plan = [22:57:08.616] lp = [22:57:08.616] lr = [22:57:08.616] result = [22:57:08.616] #8 0x00000000007bbe3c in planner (parse=0x3488e0d8, parse@entry=0x841ebcda0, query_string=0x834835678 "\006", query_string@entry=0x8347d9100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=562599232, cursorOptions@entry=2048, boundParams=0xfffffe3a, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [22:57:08.616] result = [22:57:08.616] #9 0x00000000008dfbd5 in pg_plan_query (querytree=querytree@entry=0x841ebcda0, query_string=query_string@entry=0x8347d9100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [22:57:08.616] plan = [22:57:08.616] #10 0x0000000000692ca9 in standard_ExplainOneQuery (query=0x841ebcda0, cursorOptions=562599232, cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x8347e7748, queryString=0x834835678 "\006", params=0xfffffe3a, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:440 [22:57:08.616] planduration = {ticks = 7844720} [22:57:08.616] bufusage_start = {shared_blks_hit = 1, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 34922338544, local_blks_read = 10646145, local_blks_dirtied = 70368744194107, local_blks_written = 0, temp_blks_read = 34922338576, temp_blks_written = 5711082, shared_blk_read_time = {ticks = 70368744194107}, shared_blk_write_time = {ticks = 35465711008}, local_blk_read_time = {ticks = 34922338592}, local_blk_write_time = {ticks = 6258969}, temp_blk_read_time = {ticks = 34922338768}, temp_blk_write_time = {ticks = 8967349}} [22:57:08.616] bufusage = {shared_blks_hit = 167, shared_blks_read = 347827289, shared_blks_dirtied = 0, shared_blks_written = 549755813893, local_blks_hit = -7874352849789094788, local_blks_read = 34922338716, local_blks_dirtied = 123, local_blks_written = 35465709758, temp_blks_read = -1, temp_blks_written = 10859347, shared_blk_read_time = {ticks = 35465713744}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35465711008}, local_blk_write_time = {ticks = 35465711008}, temp_blk_read_time = {ticks = 34922338736}, temp_blk_write_time = {ticks = 10894912}} [22:57:08.616] mem_counters = {nblocks = 34922338512, freechunks = 9192341, totalspace = 34922338512, freespace = 35467723144} [22:57:08.616] planner_ctx = 0x0 [22:57:08.616] saved_ctx = [22:57:08.616] planstart = {ticks = -167347827289} [22:57:08.616] plan = [22:57:08.616] #11 0x000000000069267c in ExplainOneQuery (query=0x3488e0d8, cursorOptions=2048, into=0x0, es=0x8347e7748, queryString=0x3 , params=0x83488e000, queryEnv=) at ../src/backend/commands/explain.c:396 [22:57:08.616] No locals. [22:57:08.616] #12 ExplainQuery (pstate=pstate@entry=0x8347e7638, stmt=stmt@entry=0x841ebcd70, params=0x83488e000, params@entry=0x0, dest=0x8347e75a8) at ../src/backend/commands/explain.c:292 [22:57:08.616] l__state = {l = , i = 0} [22:57:08.616] l = 0x8348754b0 [22:57:08.616] es = 0x8347e7748 [22:57:08.616] jstate = [22:57:08.616] timing_set = false [22:57:08.616] summary_set = false [22:57:08.616] lc = [22:57:08.616] query = [22:57:08.616] rewritten = 0x834875498 [22:57:08.616] tstate = [22:57:08.616] #13 0x00000000008e6cdf in standard_ProcessUtility (pstmt=0x83498d268, queryString=0x8347d9100 "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=0x821889540, queryEnv=0x0, dest=0x8347e75a8, qc=0x821889b88) at ../src/backend/tcop/utility.c:863 [22:57:08.616] isAtomicContext = true [22:57:08.616] parsetree = 0x841ebcd70 [22:57:08.616] readonly_flags = [22:57:08.616] pstate = 0x8347e7638 [22:57:08.616] isTopLevel = [22:57:08.616] #14 0x00000000008e660d in ProcessUtility (pstmt=0x3488e0d8, pstmt@entry=0x83498d268, queryString=0x834835678 "\006", readOnlyTree=, context=4294966842, params=0x3, queryEnv=0x83488e000, dest=0x8347e75a8, qc=0x821889b88) at ../src/backend/tcop/utility.c:523 [22:57:08.616] No locals. [22:57:08.616] #15 0x00000000008e6133 in PortalRunUtility (portal=portal@entry=0x8348ae100, pstmt=0x83498d268, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x8347e75a8, qc=qc@entry=0x821889b88) at ../src/backend/tcop/pquery.c:1158 [22:57:08.616] No locals. [22:57:08.616] #16 0x00000000008e532a in FillPortalStore (portal=portal@entry=0x8348ae100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [22:57:08.616] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:57:08.616] treceiver = 0x8347e75a8 [22:57:08.616] #17 0x00000000008e5030 in PortalRun (portal=portal@entry=0x8348ae100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83498d3c8, altdest=altdest@entry=0x83498d3c8, qc=0x821889cc0) at ../src/backend/tcop/pquery.c:763 [22:57:08.616] _local_sigjmp_buf = {{_sjb = {9326543, 35241305368, 34922339256, 34922339488, 34922339264, 11967624, 11935408, 35241255168, 7112098687, 35241263360, 3555360, 34359738368}}} [22:57:08.616] _save_exception_stack = 0x821889d90 [22:57:08.616] _save_context_stack = 0x0 [22:57:08.616] _do_rethrow = false [22:57:08.616] saveTopTransactionResourceOwner = 0x8348ba518 [22:57:08.616] saveTopTransactionContext = 0x8347e5000 [22:57:08.616] saveActivePortal = 0x0 [22:57:08.616] saveResourceOwner = 0x8348ba518 [22:57:08.616] savePortalContext = 0x0 [22:57:08.616] saveMemoryContext = 0x8347e5000 [22:57:08.616] result = [22:57:08.616] nprocessed = [22:57:08.616] #18 0x00000000008e3f3b in exec_simple_query (query_string=query_string@entry=0x8347d9100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;") at ../src/backend/tcop/postgres.c:1274 [22:57:08.616] cmdtaglen = [22:57:08.616] snapshot_set = [22:57:08.616] per_parsetree_context = 0x0 [22:57:08.616] plantree_list = [22:57:08.616] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:57:08.616] parsetree = 0x8348a2e60 [22:57:08.616] commandTag = CMDTAG_EXPLAIN [22:57:08.616] cmdtagname = [22:57:08.616] querytree_list = [22:57:08.616] portal = 0x8348ae100 [22:57:08.616] format = 0 [22:57:08.616] receiver = 0x83498d3c8 [22:57:08.616] parsetree_item__state = {l = 0x8348a39b0, i = 0} [22:57:08.616] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [22:57:08.616] dest = DestRemote [22:57:08.616] was_logged = [22:57:08.616] oldcontext = 0x8347e5000 [22:57:08.616] parsetree_list = 0x8348a39b0 [22:57:08.616] use_implicit_block = false [22:57:08.616] parsetree_item = 0x8348a39c8 [22:57:08.616] save_log_statement_stats = [22:57:08.616] #19 0x00000000008e1d24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4676 [22:57:08.616] query_string = 0x8347d9100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [22:57:08.616] input_message = {data = 0x8347d9100 "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} [22:57:08.616] firstchar = [22:57:08.616] local_sigjmp_buf = {{_sjb = {9310704, 34922339728, 34922339688, 34922340288, 11976360, 11922832, 8192, 8388608, 72057628960228223, 0, 0, 34359738369}}} [22:57:08.616] send_ready_for_query = false [22:57:08.616] idle_in_transaction_timeout_enabled = false [22:57:08.616] idle_session_timeout_enabled = false [22:57:08.616] #20 0x00000000008dca89 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:57:08.616] bsdata = [22:57:08.616] #21 0x000000000083991c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x82188aad0 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82188aa18) at ../src/backend/postmaster/launch_backend.c:267 [22:57:08.616] pid = [22:57:08.616] #22 0x000000000083e131 in BackendStartup (client_sock=0x82188aa18) at ../src/backend/postmaster/postmaster.c:3593 [22:57:08.616] startup_data = {canAcceptConnections = CAC_OK} [22:57:08.616] bn = 0x8347e50d8 [22:57:08.616] pid = [22:57:08.616] __error = [22:57:08.616] __error = [22:57:08.616] save_errno = [22:57:08.616] __error = [22:57:08.616] __error = [22:57:08.616] #23 ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:57:08.616] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = '\000' , "p\252\210!\b\000\000\000\330\005\377*\b", '\000' , "\016\206\377*\b", '\000' , "\260\252\210!\b\000\000\000\264\226\203\000\000\000\000\000\300\252\210!\b", '\000' , "\v\000\000\000\000\000\000"}, salen = 16}} [22:57:08.616] i = 0 [22:57:08.616] now = [22:57:08.616] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 730917988, events = 8, fd = 562602080, user_data = 0x82188a1f0}, {pos = 569447432, events = 8, fd = 32, user_data = 0x82188a1e0}, {pos = -116159852, events = 15323, fd = 569417736, user_data = 0x821f0a408}, {pos = 569419784, events = 8, fd = 569420808, user_data = 0x821f0e008}, {pos = 569435144, events = 8, fd = 569436168, user_data = 0x821f0ec08}, {pos = 569438216, events = 8, fd = 569439240, user_data = 0x821f0f808}, {pos = 569441288, events = 8, fd = 569442312, user_data = 0x821f10408}, {pos = 569444360, events = 8, fd = 569445384, user_data = 0x821f11008}, {pos = 569447432, events = 8, fd = -1, user_data = 0x82bae62e0}, {pos = 562602320, events = 8, fd = 732508585, user_data = 0x0}, {pos = 4096, events = 0, fd = -1606650756, user_data = 0x82bae67e8}, {pos = 868260832, events = 8, fd = 160, user_data = 0x0}, {pos = 856326288, events = 8, fd = 562602528, user_data = 0x82ba7192c}, {pos = 4096, events = 0, fd = 730933604, user_data = 0x7ab9a6e}, {pos = 479451855, events = 8, fd = 569473592, user_data = 0x800000001}, {pos = 569447432, events = 8, fd = 730847448, user_data = 0x82188a2a8}, {pos = 562602080, events = 8, fd = 32, user_data = 0x82b90ec64}, {pos = 569447432, events = 8, fd = 569473592, user_data = 0x0}, {pos = 2625, events = 0, fd = 562602640, user_data = 0x3bdbf9138645}, {pos = 730933604, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 569473592, events = 8, fd = 1, user_data = 0x821f11408}, {pos = 880578560, events = 8, fd = 1, user_data = 0x8347c9194}, {pos = 0, events = 0, fd = 562602592, user_data = 0x82aff7c0c}, {pos = 1, events = 0, fd = 880578560, user_data = 0x82188a290}, {pos = 721383092, events = 8, fd = 732660064, user_data = 0x82bab8160 }, {pos = 731029696, events = 8, fd = 569447432, user_data = 0x82188a370}, {pos = -116161492, events = 15323, fd = 856326288, user_data = 0x800000001}, {pos = -116161874, events = 15323, fd = 12240, user_data = 0x82188a298}, {pos = 562602864, events = 8, fd = 881256424, user_data = 0x82188a8e0}, {pos = -116081008, events = 15323, fd = 569447432, user_data = 0x82188037f}, {pos = 732317084, events = 8, fd = 569417736, user_data = 0x0}, {pos = 569447432, events = 8, fd = 12240, user_data = 0x82b8ee000}, {pos = 1964368, events = 0, fd = 732660064, user_data = 0x82b90ec64}, {pos = 15616, events = 0, fd = 562604048, user_data = 0x82188a3e0}, {pos = 731591054, events = 8, fd = 732698680, user_data = 0x82188a3a4}, {pos = 880993754, events = 8, fd = 562604048, user_data = 0x82188a3e0}, {pos = 731682309, events = 8, fd = 562602914, user_data = 0x82188a810}, {pos = 562604048, events = 8, fd = 0, user_data = 0x92b8adcda03c747c}, {pos = 562604048, events = 8, fd = 880993752, user_data = 0x82188a8e0}, {pos = 732698680, events = 8, fd = 0, user_data = 0x82188a850}, {pos = 731682573, events = 8, fd = 0, user_data = 0x0}, {pos = 562604416, events = 8, fd = 880993752, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -116132855, events = 15323, fd = 562603320, user_data = 0x82b90ec64}, {pos = 2503, events = 0, fd = -116132855, user_data = 0x82188a558}, {pos = 730917988, events = 8, fd = 2758, user_data = 0x82b908120}, {pos = 562603224, events = 8, fd = 569447432, user_data = 0x82188a558}, {pos = 730890528, events = 8, fd = 562603328, user_data = 0x3bdbf913a465}, {pos = 0, events = 0, fd = 0, user_data = 0x82bada0f0}, {pos = 730850640, events = 8, fd = 0, user_data = 0x0}, {pos = 732727728, events = 8, fd = -116132855, user_data = 0x82188a5e8}, {pos = 730917988, events = 8, fd = 2924, user_data = 0x82b9083b8}, {pos = 562603368, events = 8, fd = 569447432, user_data = 0x82188a5e8}, {pos = 730891192, events = 8, fd = 562603472, user_data = 0x3bdbf913a465}, {pos = 569471032, events = 8, fd = 2669238, user_data = 0xc605fbf}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 569447432, events = 8, fd = 730850640, user_data = 0x82188a8a8}, {pos = 569447432, events = 8, fd = 562603912, user_data = 0x1e}, {pos = 730854624, events = 8, fd = 562603640, user_data = 0x821f16248}, {pos = 562604088, events = 8, fd = 562603616, user_data = 0x3bdbf913eda3}, {pos = 569471032, events = 8, fd = 2692555, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 569471032, user_data = 0x1}} [22:57:08.616] last_touch_time = 1710888903 [22:57:08.616] last_lockfile_recheck_time = 1710888903 [22:57:08.616] nevents = 1 [22:57:08.616] #24 0x000000000083ba06 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82188b010) at ../src/backend/postmaster/postmaster.c:1372 [22:57:08.616] userDoption = [22:57:08.616] listen_addr_saved = false [22:57:08.616] output_config_variable = [22:57:08.616] opt = [22:57:08.616] status = [22:57:08.616] #25 0x0000000000778a05 in main (argc=8, argv=0x82188b010) at ../src/backend/main/main.c:197 [22:57:08.616] do_check_root =