[18:20:36.781] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [18:20:37.216] dumping /tmp/cores/postgres.8578.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:37.396] [New LWP 101784] [18:20:37.503] Core was generated by `postgres: postgres regression [local] SELECT'. [18:20:37.503] Program terminated with signal SIGSEGV, Segmentation fault. [18:20:37.503] Address not mapped to object. [18:20:37.503] #0 equal (a=0x3cfb2df8, b=b@entry=0x83cfaf6e8) at ../src/backend/nodes/equalfuncs.c:239 [18:20:37.503] 239 if (nodeTag(a) != nodeTag(b)) [18:20:37.540] [18:20:37.540] Thread 1 (LWP 101784): [18:20:37.540] #0 equal (a=0x3cfb2df8, b=b@entry=0x83cfaf6e8) at ../src/backend/nodes/equalfuncs.c:239 [18:20:37.540] retval = [18:20:37.540] #1 0x000000000076ead2 in list_member (list=0x83cfb2e68, datum=datum@entry=0x83cfaf6e8) at ../src/backend/nodes/list.c:670 [18:20:37.540] cell__state = {l = 0x83cfb2e68, i = 0} [18:20:37.540] cell = 0x0 [18:20:37.540] cell__state = [18:20:37.540] #2 0x00000000007e2475 in add_new_column_to_pathtarget (target=0x83cfb2d88, expr=) at ../src/backend/optimizer/util/tlist.c:743 [18:20:37.540] No locals. [18:20:37.540] #3 add_new_columns_to_pathtarget (target=target@entry=0x83cfb2d88, exprs=0x83cfb2f98) at ../src/backend/optimizer/util/tlist.c:760 [18:20:37.540] expr = [18:20:37.540] lc__state = {l = 0x83cfb2f98, i = 0} [18:20:37.540] lc = 0xfffffe3b [18:20:37.540] #4 0x00000000007b1ea9 in make_group_input_target (root=0x839c44328, final_target=0x83cfb2c28) at ../src/backend/optimizer/plan/planner.c:5472 [18:20:37.540] parse = 0x83cf96f50 [18:20:37.540] input_target = 0x83cfb2d88 [18:20:37.540] non_group_cols = 0x83cfb2f48 [18:20:37.540] i = [18:20:37.540] lc = [18:20:37.540] non_group_vars = 0x83cfb2f98 [18:20:37.540] #5 grouping_planner (root=root@entry=0x839c44328, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:20:37.540] qp_extra = {activeWindows = 0x0, gset_data = 0x83cfb0b38} [18:20:37.540] activeWindows = 0x0 [18:20:37.540] sort_input_target_parallel_safe = false [18:20:37.540] grouping_target = 0x83cfb2c28 [18:20:37.540] scanjoin_target = [18:20:37.540] sort_input_targets = [18:20:37.540] wflists = 0x0 [18:20:37.540] gset_data = 0x83cfb0b38 [18:20:37.540] have_grouping = false [18:20:37.540] sort_input_targets_contain_srfs = [18:20:37.540] sort_input_target = 0x83cfb2c28 [18:20:37.540] grouping_target_parallel_safe = false [18:20:37.540] scanjoin_target_parallel_safe = [18:20:37.540] grouping_targets = [18:20:37.540] scanjoin_targets = [18:20:37.540] grouping_targets_contain_srfs = [18:20:37.540] scanjoin_targets_contain_srfs = [18:20:37.540] scanjoin_target_same_exprs = [18:20:37.540] extra = {limit_needed = 24, limit_tuples = 1.7481436838688593e-313, count_est = 72, offset_est = 34924883040} [18:20:37.540] parse = 0x83cf96f50 [18:20:37.540] offset_est = [18:20:37.540] count_est = [18:20:37.540] limit_tuples = -1 [18:20:37.540] have_postponed_srfs = false [18:20:37.540] current_rel = 0x839c44738 [18:20:37.540] final_target = 0x83cfb2c28 [18:20:37.540] final_targets_contain_srfs = [18:20:37.540] final_targets = [18:20:37.540] final_rel = [18:20:37.540] lc = [18:20:37.540] final_target_parallel_safe = [18:20:37.540] #6 0x00000000007afdb4 in subquery_planner (glob=glob@entry=0x83cfad3e0, parse=parse@entry=0x83cf96f50, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:20:37.540] root = 0x839c44328 [18:20:37.540] hasOuterJoins = false [18:20:37.540] hasResultRTEs = false [18:20:37.540] l = [18:20:37.540] newWithCheckOptions = [18:20:37.540] newHaving = 0x0 [18:20:37.540] final_rel = [18:20:37.540] #7 0x00000000007ae8d8 in standard_planner (parse=0x83cf96f50, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [18:20:37.540] glob = 0x83cfad3e0 [18:20:37.540] tuple_fraction = 0 [18:20:37.540] root = [18:20:37.540] final_rel = [18:20:37.540] best_path = [18:20:37.540] top_plan = [18:20:37.540] lp = [18:20:37.540] lr = [18:20:37.540] result = [18:20:37.540] #8 0x00000000007ae7ac in planner (parse=0x3cfb2df8, parse@entry=0x83cf96f50, query_string=0x83cfaf6e8 "\006", query_string@entry=0x839b63100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=565144496, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [18:20:37.540] result = [18:20:37.540] #9 0x00000000008d1c95 in pg_plan_query (querytree=querytree@entry=0x83cf96f50, query_string=query_string@entry=0x839b63100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:20:37.540] plan = [18:20:37.540] #10 0x00000000008d1d72 in pg_plan_queries (querytrees=0x83cfad390, query_string=query_string@entry=0x839b63100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=565144496, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [18:20:37.540] query = 0x83cf96f50 [18:20:37.540] stmt = [18:20:37.540] query_list__state = {l = 0x83cfad390, i = 0} [18:20:37.540] stmt_list = 0x0 [18:20:37.540] query_list = [18:20:37.540] #11 0x00000000008d5f0c in exec_simple_query (query_string=query_string@entry=0x839b63100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [18:20:37.540] cmdtaglen = [18:20:37.540] snapshot_set = [18:20:37.540] per_parsetree_context = 0x0 [18:20:37.540] plantree_list = [18:20:37.540] qc = {commandTag = 336, nprocessed = 6} [18:20:37.540] parsetree = 0x839cbf600 [18:20:37.540] commandTag = [18:20:37.540] cmdtagname = [18:20:37.540] querytree_list = 0x0 [18:20:37.540] portal = [18:20:37.540] format = [18:20:37.540] receiver = [18:20:37.540] parsetree_item__state = {l = 0x839c40e78, i = 0} [18:20:37.540] 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" [18:20:37.540] dest = DestRemote [18:20:37.540] was_logged = [18:20:37.540] oldcontext = 0x839b6f000 [18:20:37.540] parsetree_list = 0x839c40e78 [18:20:37.540] use_implicit_block = false [18:20:37.540] parsetree_item = 0x839c40e90 [18:20:37.540] save_log_statement_stats = [18:20:37.540] #12 0x00000000008d3de4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [18:20:37.540] query_string = 0x839b63100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [18:20:37.540] input_message = {data = 0x839b63100 "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} [18:20:37.540] firstchar = [18:20:37.540] local_sigjmp_buf = {{_sjb = {9253552, 34924884016, 34924883976, 34924884576, 11911656, 11858144, 8192, 8388608, 72057628962784127, 0, 0, 34359738369}}} [18:20:37.540] send_ready_for_query = false [18:20:37.540] idle_in_transaction_timeout_enabled = false [18:20:37.540] idle_session_timeout_enabled = false [18:20:37.540] #13 0x0000000000832ad5 in BackendRun (port=port@entry=0x839c3e000) at ../src/backend/postmaster/postmaster.c:4475 [18:20:37.540] No locals. [18:20:37.540] #14 0x0000000000830e0d in BackendStartup (port=0x839c3e000) at ../src/backend/postmaster/postmaster.c:4151 [18:20:37.540] bn = 0x839b6f628 [18:20:37.540] pid = [18:20:37.540] __error = [18:20:37.540] __error = [18:20:37.540] __error = [18:20:37.540] save_errno = [18:20:37.540] __error = [18:20:37.540] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:20:37.540] port = 0x839c3e000 [18:20:37.540] i = 0 [18:20:37.540] now = [18:20:37.540] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 570049544, events = 8, fd = 570050568, user_data = 0x821fa4c08}, {pos = 570052616, events = 8, fd = 570053640, user_data = 0x821fa5808}, {pos = 570055688, events = 8, fd = 570056712, user_data = 0x821fa6408}, {pos = -1, events = 0, fd = 748516064, user_data = 0x821af7350}, {pos = 748175785, events = 8, fd = 0, user_data = 0x1000}, {pos = 1390623999, events = 2087227605, fd = 748517352, user_data = 0x838c09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x836f71090}, {pos = 565146656, events = 8, fd = 748038444, user_data = 0x1000}, {pos = 746600804, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 570083896, events = 8, fd = 1, user_data = 0x821fa6408}, {pos = 746514648, events = 8, fd = 565146792, user_data = 0x821af7260}, {pos = 32, events = 18, fd = 746585188, user_data = 0x821fa6408}, {pos = 570083896, events = 8, fd = 0, user_data = 0xa41}, {pos = 565146768, events = 8, fd = 1024136773, user_data = 0x82c803964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821faca38}, {pos = 1, events = 0, fd = 570057736, user_data = 0x839b53000}, {pos = 1, events = 0, fd = 968176020, user_data = 0x0}, {pos = 565146720, events = 8, fd = 769903628, user_data = 0x1}, {pos = 968175616, events = 8, fd = 565146768, user_data = 0x82de3beb4}, {pos = 748327264, events = 8, fd = 748327264, user_data = 0x82c81b0c0}, {pos = 570057736, events = 8, fd = 565146992, user_data = 0x3bee3d0b142c}, {pos = 922161296, events = 8, fd = 1, user_data = 0x3bee3d0b12ae}, {pos = 12240, events = 0, fd = 565146776, user_data = 0x821af7570}, {pos = 968853480, events = 8, fd = 565148384, user_data = 0x3bee3d0c4e90}, {pos = 570057736, events = 8, fd = 565117823, user_data = 0x82c95559c}, {pos = 570028040, events = 8, fd = 0, user_data = 0x821fa6408}, {pos = 12240, events = 0, fd = 746450944, user_data = 0x1df950}, {pos = 748327264, events = 8, fd = 746585188, user_data = 0x3d00}, {pos = 565148176, events = 8, fd = 565147104, user_data = 0x82c8a418e }, {pos = 748365880, events = 8, fd = 565147044, user_data = 0x839bb85da}, {pos = 565148176, events = 8, fd = 565147104, user_data = 0x82c8ba605}, {pos = 565147042, events = 8, fd = 565148176, user_data = 0x821af7a10}, {pos = 0, events = 16777216, fd = 1390623999, user_data = 0x821af7a10}, {pos = 968590808, events = 8, fd = 565148384, user_data = 0x82c9b2838}, {pos = 0, events = 0, fd = 565148240, user_data = 0x82c8ba70d}, {pos = 0, events = 0, fd = 0, user_data = 0x821af7b80}, {pos = 968590808, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3bee3d0b8409}, {pos = 565147448, events = 8, fd = 746585188, user_data = 0x9c7}, {pos = 1024164873, events = 15342, fd = 565147480, user_data = 0x82c7ffc64}, {pos = 2758, events = 0, fd = 746557728, user_data = 0x821af76d8}, {pos = 570057736, events = 8, fd = 565147480, user_data = 0x82c7f9120}, {pos = 565147456, events = 8, fd = 1024144485, user_data = 0x0}, {pos = 0, events = 0, fd = 748466416, user_data = 0x82c7ef550}, {pos = 0, events = 0, fd = 0, user_data = 0x82c9b99b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x821af77c8}, {pos = 570077320, events = 8, fd = 1024164873, user_data = 0x821af7808}, {pos = 746585188, events = 8, fd = 2924, user_data = 0x82c7f93b8}, {pos = 565147528, events = 8, fd = 570057736, user_data = 0x821af7808}, {pos = 746558392, events = 8, fd = 565147632, user_data = 0x3bee3d0b3465}, {pos = 570081336, events = 8, fd = 1, user_data = 0x821fa6408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 565148040, events = 0, fd = 2565628, user_data = 0x821af79f0}, {pos = 565148144, events = 8, fd = 565148072, user_data = 0x1e}, {pos = 746521824, events = 8, fd = 565147800, user_data = 0x821fab248}, {pos = 565148248, events = 8, fd = 565147776, user_data = 0x3bee3d0b7da3}, {pos = 570081336, events = 8, fd = 2691611, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 570081336, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821af7b58}, {pos = 570057736, events = 8, fd = 565148128, user_data = 0x2725fc}, {pos = 565148320, events = 8, fd = 565148320, user_data = 0x821af7a58}, {pos = 32, events = 0, fd = 565147904, user_data = 0x3bee3d0b7b83}} [18:20:37.540] last_touch_time = 1710180859 [18:20:37.540] last_lockfile_recheck_time = 1710180859 [18:20:37.540] nevents = 1 [18:20:37.540] #16 0x000000000082e113 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821af8210) at ../src/backend/postmaster/postmaster.c:1468 [18:20:37.540] userDoption = [18:20:37.540] listen_addr_saved = false [18:20:37.540] output_config_variable = [18:20:37.540] opt = [18:20:37.540] status = [18:20:37.540] #17 0x000000000076b395 in main (argc=8, argv=0x821af8210) at ../src/backend/main/main.c:197 [18:20:37.540] do_check_root = [18:20:37.552] [18:20:37.552] [18:20:37.552] [18:20:37.623] dumping /tmp/cores/postgres.9224.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:20:37.790] [New LWP 101782] [18:20:37.888] Core was generated by `postgres: old_node: postgres regression [local] SELECT'. [18:20:37.888] Program terminated with signal SIGSEGV, Segmentation fault. [18:20:37.888] Address not mapped to object. [18:20:37.888] #0 equal (a=0x3ae0d078, b=b@entry=0x83ae09968) at ../src/backend/nodes/equalfuncs.c:239 [18:20:37.888] 239 if (nodeTag(a) != nodeTag(b)) [18:20:37.919] [18:20:37.919] Thread 1 (LWP 101782): [18:20:37.919] #0 equal (a=0x3ae0d078, b=b@entry=0x83ae09968) at ../src/backend/nodes/equalfuncs.c:239 [18:20:37.919] retval = [18:20:37.919] #1 0x000000000076ead2 in list_member (list=0x83ae0d0e8, datum=datum@entry=0x83ae09968) at ../src/backend/nodes/list.c:670 [18:20:37.919] cell__state = {l = 0x83ae0d0e8, i = 0} [18:20:37.919] cell = 0x0 [18:20:37.919] cell__state = [18:20:37.919] #2 0x00000000007e2475 in add_new_column_to_pathtarget (target=0x83ae0d008, expr=) at ../src/backend/optimizer/util/tlist.c:743 [18:20:37.919] No locals. [18:20:37.919] #3 add_new_columns_to_pathtarget (target=target@entry=0x83ae0d008, exprs=0x83ae0d218) at ../src/backend/optimizer/util/tlist.c:760 [18:20:37.919] expr = [18:20:37.919] lc__state = {l = 0x83ae0d218, i = 0} [18:20:37.919] lc = 0xfffffe3b [18:20:37.919] #4 0x00000000007b1ea9 in make_group_input_target (root=0x83771f0a8, final_target=0x83ae0cea8) at ../src/backend/optimizer/plan/planner.c:5472 [18:20:37.919] parse = 0x83adf1fd0 [18:20:37.919] input_target = 0x83ae0d008 [18:20:37.919] non_group_cols = 0x83ae0d1c8 [18:20:37.919] i = [18:20:37.919] lc = [18:20:37.919] non_group_vars = 0x83ae0d218 [18:20:37.919] #5 grouping_planner (root=root@entry=0x83771f0a8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:20:37.919] qp_extra = {activeWindows = 0x0, gset_data = 0x83ae0adb8} [18:20:37.919] activeWindows = 0x0 [18:20:37.919] sort_input_target_parallel_safe = false [18:20:37.919] grouping_target = 0x83ae0cea8 [18:20:37.919] scanjoin_target = [18:20:37.919] sort_input_targets = [18:20:37.919] wflists = 0x0 [18:20:37.919] gset_data = 0x83ae0adb8 [18:20:37.919] have_grouping = false [18:20:37.919] sort_input_targets_contain_srfs = [18:20:37.919] sort_input_target = 0x83ae0cea8 [18:20:37.919] grouping_target_parallel_safe = false [18:20:37.919] scanjoin_target_parallel_safe = [18:20:37.919] grouping_targets = [18:20:37.919] scanjoin_targets = [18:20:37.919] grouping_targets_contain_srfs = [18:20:37.919] scanjoin_targets_contain_srfs = [18:20:37.919] scanjoin_target_same_exprs = [18:20:37.919] extra = {limit_needed = 152, limit_tuples = 1.7464005064376066e-313, count_est = 72, offset_est = 34923097536} [18:20:37.919] parse = 0x83adf1fd0 [18:20:37.919] offset_est = [18:20:37.919] count_est = [18:20:37.919] limit_tuples = -1 [18:20:37.919] have_postponed_srfs = false [18:20:37.919] current_rel = 0x83771f4b8 [18:20:37.919] final_target = 0x83ae0cea8 [18:20:37.919] final_targets_contain_srfs = [18:20:37.919] final_targets = [18:20:37.919] final_rel = [18:20:37.919] lc = [18:20:37.919] final_target_parallel_safe = [18:20:37.919] #6 0x00000000007afdb4 in subquery_planner (glob=glob@entry=0x83ae07660, parse=parse@entry=0x83adf1fd0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:20:37.919] root = 0x83771f0a8 [18:20:37.919] hasOuterJoins = false [18:20:37.919] hasResultRTEs = false [18:20:37.919] l = [18:20:37.919] newWithCheckOptions = [18:20:37.919] newHaving = 0x0 [18:20:37.919] final_rel = [18:20:37.919] #7 0x00000000007ae8d8 in standard_planner (parse=0x83adf1fd0, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [18:20:37.919] glob = 0x83ae07660 [18:20:37.919] tuple_fraction = 0 [18:20:37.919] root = [18:20:37.919] final_rel = [18:20:37.919] best_path = [18:20:37.919] top_plan = [18:20:37.919] lp = [18:20:37.919] lr = [18:20:37.919] result = [18:20:37.919] #8 0x00000000007ae7ac in planner (parse=0x3ae0d078, parse@entry=0x83adf1fd0, query_string=0x83ae09968 "\006", query_string@entry=0x837643100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=563358992, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [18:20:37.919] result = [18:20:37.919] #9 0x00000000008d1c95 in pg_plan_query (querytree=querytree@entry=0x83adf1fd0, query_string=query_string@entry=0x837643100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:20:37.919] plan = [18:20:37.919] #10 0x00000000008d1d72 in pg_plan_queries (querytrees=0x83ae07610, query_string=query_string@entry=0x837643100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=563358992, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [18:20:37.919] query = 0x83adf1fd0 [18:20:37.919] stmt = [18:20:37.919] query_list__state = {l = 0x83ae07610, i = 0} [18:20:37.919] stmt_list = 0x0 [18:20:37.919] query_list = [18:20:37.919] #11 0x00000000008d5f0c in exec_simple_query (query_string=query_string@entry=0x837643100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [18:20:37.919] cmdtaglen = [18:20:37.919] snapshot_set = [18:20:37.919] per_parsetree_context = 0x0 [18:20:37.919] plantree_list = [18:20:37.919] qc = {commandTag = 336, nprocessed = 6} [18:20:37.919] parsetree = 0x83779a600 [18:20:37.919] commandTag = [18:20:37.919] cmdtagname = [18:20:37.919] querytree_list = 0x0 [18:20:37.919] portal = [18:20:37.919] format = [18:20:37.919] receiver = [18:20:37.919] parsetree_item__state = {l = 0x83771bbf8, i = 0} [18:20:37.919] 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" [18:20:37.919] dest = DestRemote [18:20:37.919] was_logged = [18:20:37.919] oldcontext = 0x83764f000 [18:20:37.919] parsetree_list = 0x83771bbf8 [18:20:37.919] use_implicit_block = false [18:20:37.919] parsetree_item = 0x83771bc10 [18:20:37.919] save_log_statement_stats = [18:20:37.919] #12 0x00000000008d3de4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [18:20:37.919] query_string = 0x837643100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [18:20:37.919] input_message = {data = 0x837643100 "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} [18:20:37.919] firstchar = [18:20:37.919] local_sigjmp_buf = {{_sjb = {9253552, 34923098512, 34923098472, 34923099072, 11911656, 11858144, 8192, 8388608, 72057628961014655, 0, 0, 34359738369}}} [18:20:37.919] send_ready_for_query = false [18:20:37.919] idle_in_transaction_timeout_enabled = false [18:20:37.919] idle_session_timeout_enabled = false [18:20:37.919] #13 0x0000000000832ad5 in BackendRun (port=port@entry=0x8376f6000) at ../src/backend/postmaster/postmaster.c:4475 [18:20:37.919] No locals. [18:20:37.919] #14 0x0000000000830e0d in BackendStartup (port=0x8376f6000) at ../src/backend/postmaster/postmaster.c:4151 [18:20:37.919] bn = 0x83764f358 [18:20:37.919] pid = [18:20:37.919] __error = [18:20:37.919] __error = [18:20:37.919] __error = [18:20:37.919] save_errno = [18:20:37.919] __error = [18:20:37.919] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:20:37.919] port = 0x8376f6000 [18:20:37.919] i = 0 [18:20:37.919] now = [18:20:37.919] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 571114504, events = 8, fd = 571115528, user_data = 0x8220a8c08}, {pos = 571117576, events = 8, fd = 571118600, user_data = 0x8220a9808}, {pos = 571120648, events = 8, fd = 571121672, user_data = 0x8220aa408}, {pos = 571142280, events = 8, fd = 563361480, user_data = 0x8219434f0}, {pos = 1315773859, events = 482, fd = 0, user_data = 0x2726b2}, {pos = 115249317, events = 0, fd = -25761258, user_data = 0x8220b0038}, {pos = 1, events = 0, fd = 571122696, user_data = 0x82af864a8}, {pos = 563361736, events = 8, fd = 571122696, user_data = 0x219434e0}, {pos = 721029476, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 571148856, events = 8, fd = 1, user_data = 0x8220aa408}, {pos = 720943320, events = 8, fd = 563361288, user_data = 0x8219433c0}, {pos = 32, events = 18, fd = 721013860, user_data = 0x8220aa408}, {pos = 571148856, events = 8, fd = 0, user_data = 0xa41}, {pos = 563361264, events = 8, fd = 1315747397, user_data = 0x82afa0964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x8220b0a38}, {pos = 1, events = 0, fd = 571122696, user_data = 0x837633000}, {pos = 1, events = 0, fd = 929247636, user_data = 0x0}, {pos = 563361216, events = 8, fd = 739933196, user_data = 0x1}, {pos = 929247232, events = 8, fd = 563361264, user_data = 0x82c1a6eb4}, {pos = 722755936, events = 8, fd = 722755936, user_data = 0x82afb80c0}, {pos = 571122696, events = 8, fd = 563361488, user_data = 0x1e24e6cb42c}, {pos = 571121672, events = 8, fd = 1, user_data = 0x1e24e6cb2ae}, {pos = 12240, events = 0, fd = 563361272, user_data = 0x8219436d0}, {pos = 930027496, events = 8, fd = 563362880, user_data = 0x1e24e6dee90}, {pos = 571122696, events = 8, fd = 563348351, user_data = 0x82b0f24b2}, {pos = 571093000, events = 8, fd = 0, user_data = 0x8220aa408}, {pos = 12240, events = 0, fd = 720879616, user_data = 0x1df950}, {pos = 722755936, events = 8, fd = 721013860, user_data = 0x3d00}, {pos = 563362672, events = 8, fd = 563361600, user_data = 0x82b04118e }, {pos = 722794552, events = 8, fd = 563361540, user_data = 0x8376a15da}, {pos = 563362672, events = 8, fd = 563361600, user_data = 0x82b057605}, {pos = 563361538, events = 8, fd = 563362672, user_data = 0x821943b70}, {pos = 0, events = 16777216, fd = -1145603838, user_data = 0x821943b70}, {pos = 929699288, events = 8, fd = 563362880, user_data = 0x82b14f838}, {pos = 0, events = 0, fd = 563362736, user_data = 0x82b05770d}, {pos = 0, events = 0, fd = 0, user_data = 0x821943ce0}, {pos = 929699288, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1e24e6d2409}, {pos = 563361944, events = 8, fd = 721013860, user_data = 0x9c7}, {pos = 1315775497, events = 482, fd = 563361976, user_data = 0x82af9cc64}, {pos = 2758, events = 0, fd = 720986400, user_data = 0x821943838}, {pos = 571122696, events = 8, fd = 563361976, user_data = 0x82af96120}, {pos = 563361952, events = 8, fd = 1315755109, user_data = 0x0}, {pos = 0, events = 0, fd = 722895088, user_data = 0x82af8c550}, {pos = 0, events = 0, fd = 0, user_data = 0x82b1569b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x821943928}, {pos = 571142280, events = 8, fd = 1315775497, user_data = 0x821943968}, {pos = 721013860, events = 8, fd = 2924, user_data = 0x82af963b8}, {pos = 563362024, events = 8, fd = 571122696, user_data = 0x821943968}, {pos = 720987064, events = 8, fd = 563362128, user_data = 0x1e24e6cd465}, {pos = 571146296, events = 8, fd = 1, user_data = 0x8220aa408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 563362536, events = 0, fd = 2565628, user_data = 0x821943b50}, {pos = 563362640, events = 8, fd = 563362568, user_data = 0x1e}, {pos = 720950496, events = 8, fd = 563362296, user_data = 0x8220af248}, {pos = 563362744, events = 8, fd = 563362272, user_data = 0x1e24e6d1da3}, {pos = 571146296, events = 8, fd = 2691611, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 571146296, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821943cb8}, {pos = 571122696, events = 8, fd = 563362624, user_data = 0x2725fc}, {pos = 563362816, events = 8, fd = 563362816, user_data = 0x821943bb8}, {pos = 32, events = 0, fd = 563362400, user_data = 0x1e24e6d1b83}} [18:20:37.919] last_touch_time = 1710180861 [18:20:37.919] last_lockfile_recheck_time = 1710180861 [18:20:37.919] nevents = 1 [18:20:37.919] #16 0x000000000082e113 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821944378) at ../src/backend/postmaster/postmaster.c:1468 [18:20:37.919] userDoption = [18:20:37.919] listen_addr_saved = false [18:20:37.919] output_config_variable = [18:20:37.919] opt = [18:20:37.919] status = [18:20:37.919] #17 0x000000000076b395 in main (argc=4, argv=0x821944378) at ../src/backend/main/main.c:197 [18:20:37.919] do_check_root = [18:20:37.932] [18:20:37.932] [18:20:37.932] [18:20:38.010] dumping /tmp/cores/postgres.9705.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:38.184] [New LWP 101808] [18:20:38.278] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [18:20:38.278] Program terminated with signal SIGSEGV, Segmentation fault. [18:20:38.278] Address not mapped to object. [18:20:38.278] #0 equal (a=0x39c13cb0, b=b@entry=0x839b7d678) at ../src/backend/nodes/equalfuncs.c:239 [18:20:38.278] 239 if (nodeTag(a) != nodeTag(b)) [18:20:38.907] [18:20:38.907] Thread 1 (LWP 101808): [18:20:38.907] #0 equal (a=0x39c13cb0, b=b@entry=0x839b7d678) at ../src/backend/nodes/equalfuncs.c:239 [18:20:38.907] retval = [18:20:38.907] #1 0x000000000076ead2 in list_member (list=0x839c13d20, datum=datum@entry=0x839b7d678) at ../src/backend/nodes/list.c:670 [18:20:38.907] cell__state = {l = 0x839c13d20, i = 0} [18:20:38.907] cell = 0x0 [18:20:38.907] cell__state = [18:20:38.907] #2 0x00000000007e2475 in add_new_column_to_pathtarget (target=0x839c13c40, expr=) at ../src/backend/optimizer/util/tlist.c:743 [18:20:38.907] No locals. [18:20:38.907] #3 add_new_columns_to_pathtarget (target=target@entry=0x839c13c40, exprs=0x839c13dd8) at ../src/backend/optimizer/util/tlist.c:760 [18:20:38.907] expr = [18:20:38.907] lc__state = {l = 0x839c13dd8, i = 0} [18:20:38.907] lc = 0xfffffe3b [18:20:38.907] #4 0x00000000007b1ea9 in make_group_input_target (root=0x839b7d038, final_target=0x839c13b70) at ../src/backend/optimizer/plan/planner.c:5472 [18:20:38.907] parse = 0x83d34c8c8 [18:20:38.907] input_target = 0x839c13c40 [18:20:38.907] non_group_cols = 0x839c13d88 [18:20:38.907] i = [18:20:38.907] lc = [18:20:38.907] non_group_vars = 0x839c13dd8 [18:20:38.907] #5 grouping_planner (root=root@entry=0x839b7d038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:20:38.907] qp_extra = {activeWindows = 0x0, gset_data = 0x839b7d718} [18:20:38.907] activeWindows = 0x0 [18:20:38.907] sort_input_target_parallel_safe = false [18:20:38.907] grouping_target = 0x839c13b70 [18:20:38.907] scanjoin_target = [18:20:38.907] sort_input_targets = [18:20:38.907] wflists = 0x0 [18:20:38.907] gset_data = 0x839b7d718 [18:20:38.907] have_grouping = false [18:20:38.907] sort_input_targets_contain_srfs = [18:20:38.907] sort_input_target = 0x839c13b70 [18:20:38.907] grouping_target_parallel_safe = false [18:20:38.907] scanjoin_target_parallel_safe = [18:20:38.907] grouping_targets = [18:20:38.907] scanjoin_targets = [18:20:38.907] grouping_targets_contain_srfs = [18:20:38.907] scanjoin_targets_contain_srfs = [18:20:38.907] scanjoin_target_same_exprs = [18:20:38.907] extra = {limit_needed = 16, limit_tuples = 1.7454394333427105e-313, count_est = 0, offset_est = 34924882080} [18:20:38.907] parse = 0x83d34c8c8 [18:20:38.907] offset_est = [18:20:38.907] count_est = [18:20:38.907] limit_tuples = -1 [18:20:38.907] have_postponed_srfs = false [18:20:38.907] current_rel = 0x839b7c4c8 [18:20:38.907] final_target = 0x839c13b70 [18:20:38.907] final_targets_contain_srfs = [18:20:38.907] final_targets = [18:20:38.907] final_rel = [18:20:38.907] lc = [18:20:38.907] final_target_parallel_safe = [18:20:38.907] #6 0x00000000007afdb4 in subquery_planner (glob=glob@entry=0x839bf8ef8, parse=parse@entry=0x83d34c8c8, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=1.7482897830328597e-313) at ../src/backend/optimizer/plan/planner.c:1084 [18:20:38.907] root = 0x839b7d038 [18:20:38.907] hasOuterJoins = false [18:20:38.907] hasResultRTEs = false [18:20:38.907] l = [18:20:38.907] newWithCheckOptions = [18:20:38.907] newHaving = 0x0 [18:20:38.907] final_rel = [18:20:38.907] #7 0x00000000007ae8d8 in standard_planner (parse=0x83d34c8c8, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [18:20:38.907] glob = 0x839bf8ef8 [18:20:38.907] tuple_fraction = 0 [18:20:38.907] root = [18:20:38.907] final_rel = [18:20:38.907] best_path = [18:20:38.907] top_plan = [18:20:38.907] lp = [18:20:38.907] lr = [18:20:38.907] result = [18:20:38.907] #8 0x00000000007ae7ac in planner (parse=0x39c13cb0, parse@entry=0x83d34c8c8, query_string=0x839b7d678 "\006", query_string@entry=0x839b63100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=565143520, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [18:20:38.907] result = [18:20:38.907] #9 0x00000000008d1c95 in pg_plan_query (querytree=querytree@entry=0x83d34c8c8, query_string=query_string@entry=0x839b63100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:20:38.907] plan = [18:20:38.907] #10 0x00000000006859c9 in standard_ExplainOneQuery (query=0x83d34c8c8, cursorOptions=565143520, cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x839cfe748, queryString=0x839b7d678 "\006", params=0xfffffe3b, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:441 [18:20:38.907] planduration = {ticks = 7789824} [18:20:38.907] bufusage_start = {shared_blks_hit = 34924883007, shared_blks_read = 0, shared_blks_dirtied = 35386608088, shared_blks_written = 35386608744, local_blks_hit = 34924882832, local_blks_read = 10584593, local_blks_dirtied = 70368744214820, local_blks_written = 0, temp_blks_read = 34924882864, temp_blks_written = 5658010, shared_blk_read_time = {ticks = 70368744214820}, shared_blk_write_time = {ticks = 1}, local_blk_read_time = {ticks = 34924882880}, local_blk_write_time = {ticks = 6206329}, temp_blk_read_time = {ticks = 34924883056}, temp_blk_write_time = {ticks = 8914843}} [18:20:38.907] bufusage = {shared_blks_hit = 200, shared_blks_read = 738774971, shared_blks_dirtied = 34924882992, shared_blks_written = 35386605968, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 35385939744, temp_blks_written = 10797731, shared_blk_read_time = {ticks = 35386609816}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35386607816}, local_blk_write_time = {ticks = 35386607816}, temp_blk_read_time = {ticks = 34924883024}, temp_blk_write_time = {ticks = 10833296}} [18:20:38.907] mem_counters = {nblocks = 34924882800, freechunks = 9139413, totalspace = 34924882800, freespace = 35385939744} [18:20:38.907] planner_ctx = 0x0 [18:20:38.907] saved_ctx = [18:20:38.907] planstart = {ticks = -200738774971} [18:20:38.907] plan = [18:20:38.907] #11 0x000000000068539c in ExplainOneQuery (query=0x39c13cb0, cursorOptions=2048, into=0x0, es=0x839cfe748, queryString=0x3 , params=0x839c12000, queryEnv=) at ../src/backend/commands/explain.c:397 [18:20:38.907] No locals. [18:20:38.907] #12 ExplainQuery (pstate=pstate@entry=0x839cfe638, stmt=stmt@entry=0x83d34c898, params=0x839c12000, params@entry=0x0, dest=0x839cfe5a8) at ../src/backend/commands/explain.c:293 [18:20:38.907] l__state = {l = , i = 0} [18:20:38.907] l = 0x839bf8cb0 [18:20:38.907] es = 0x839cfe748 [18:20:38.907] jstate = [18:20:38.907] timing_set = false [18:20:38.907] summary_set = false [18:20:38.907] lc = [18:20:38.907] query = [18:20:38.907] rewritten = 0x839bf8c98 [18:20:38.907] tstate = [18:20:38.907] #13 0x00000000008d8d9f in standard_ProcessUtility (pstmt=0x83d34d510, queryString=0x839b63100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x821af67e0, queryEnv=0x0, dest=0x839cfe5a8, qc=0x821af6e28) at ../src/backend/tcop/utility.c:863 [18:20:38.907] isAtomicContext = true [18:20:38.907] parsetree = 0x83d34c898 [18:20:38.907] readonly_flags = [18:20:38.907] pstate = 0x839cfe638 [18:20:38.907] isTopLevel = [18:20:38.907] #14 0x00000000008d86cd in ProcessUtility (pstmt=0x39c13cb0, pstmt@entry=0x83d34d510, queryString=0x839b7d678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x839c12000, dest=0x839cfe5a8, qc=0x821af6e28) at ../src/backend/tcop/utility.c:523 [18:20:38.907] No locals. [18:20:38.907] #15 0x00000000008d81f3 in PortalRunUtility (portal=portal@entry=0x839c38100, pstmt=0x83d34d510, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x839cfe5a8, qc=qc@entry=0x821af6e28) at ../src/backend/tcop/pquery.c:1158 [18:20:38.907] No locals. [18:20:38.907] #16 0x00000000008d73ea in FillPortalStore (portal=portal@entry=0x839c38100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [18:20:38.907] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:38.907] treceiver = 0x839cfe5a8 [18:20:38.907] #17 0x00000000008d70f0 in PortalRun (portal=portal@entry=0x839c38100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83d34d670, altdest=altdest@entry=0x83d34d670, qc=0x821af6f60) at ../src/backend/tcop/pquery.c:763 [18:20:38.907] _local_sigjmp_buf = {{_sjb = {9269391, 35328921648, 34924883544, 34924883776, 34924883552, 11902920, 11870704, 35328852224, -6347183290294795393, 35328860416, 3553530, 34359738368}}} [18:20:38.907] _save_exception_stack = 0x821af7030 [18:20:38.907] _save_context_stack = 0x0 [18:20:38.907] _do_rethrow = false [18:20:38.907] saveTopTransactionResourceOwner = 0x839c49030 [18:20:38.907] saveTopTransactionContext = 0x839d24000 [18:20:38.907] saveActivePortal = 0x0 [18:20:38.907] saveResourceOwner = 0x839c49030 [18:20:38.907] savePortalContext = 0x0 [18:20:38.907] saveMemoryContext = 0x839d24000 [18:20:38.907] result = [18:20:38.907] nprocessed = [18:20:38.907] #18 0x00000000008d5ffb in exec_simple_query (query_string=query_string@entry=0x839b63100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1273 [18:20:38.907] cmdtaglen = [18:20:38.907] snapshot_set = [18:20:38.907] per_parsetree_context = 0x0 [18:20:38.907] plantree_list = [18:20:38.907] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:38.907] parsetree = 0x839c2cc58 [18:20:38.907] commandTag = CMDTAG_EXPLAIN [18:20:38.907] cmdtagname = [18:20:38.907] querytree_list = [18:20:38.907] portal = 0x839c38100 [18:20:38.907] format = 0 [18:20:38.907] receiver = 0x83d34d670 [18:20:38.907] parsetree_item__state = {l = 0x839c2d4e0, i = 0} [18:20:38.907] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [18:20:38.907] dest = DestRemote [18:20:38.907] was_logged = [18:20:38.907] oldcontext = 0x839d24000 [18:20:38.907] parsetree_list = 0x839c2d4e0 [18:20:38.907] use_implicit_block = false [18:20:38.907] parsetree_item = 0x839c2d4f8 [18:20:38.907] save_log_statement_stats = [18:20:38.907] #19 0x00000000008d3de4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [18:20:38.907] query_string = 0x839b63100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [18:20:38.907] input_message = {data = 0x839b63100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [18:20:38.907] firstchar = [18:20:38.907] local_sigjmp_buf = {{_sjb = {9253552, 34924884016, 34924883976, 34924884576, 11911656, 11858144, 8192, 8388608, 72057628962784127, 0, 0, 34359738369}}} [18:20:38.907] send_ready_for_query = false [18:20:38.907] idle_in_transaction_timeout_enabled = false [18:20:38.907] idle_session_timeout_enabled = false [18:20:38.907] #20 0x0000000000832ad5 in BackendRun (port=port@entry=0x839c3e000) at ../src/backend/postmaster/postmaster.c:4475 [18:20:38.907] No locals. [18:20:38.907] #21 0x0000000000830e0d in BackendStartup (port=0x839c3e000) at ../src/backend/postmaster/postmaster.c:4151 [18:20:38.907] bn = 0x839b6f4e8 [18:20:38.907] pid = [18:20:38.907] __error = [18:20:38.907] __error = [18:20:38.907] __error = [18:20:38.907] save_errno = [18:20:38.907] __error = [18:20:38.907] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:20:38.907] port = 0x839c3e000 [18:20:38.907] i = 0 [18:20:38.907] now = [18:20:38.907] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 570049544, events = 8, fd = 570050568, user_data = 0x821fa4c08}, {pos = 570052616, events = 8, fd = 570053640, user_data = 0x821fa5808}, {pos = 570055688, events = 8, fd = 570056712, user_data = 0x821fa6408}, {pos = -1, events = 0, fd = 748516064, user_data = 0x821af7350}, {pos = 748175785, events = 8, fd = 0, user_data = 0x1000}, {pos = 1390623999, events = 2087227605, fd = 748517352, user_data = 0x838c09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x836f71090}, {pos = 565146656, events = 8, fd = 748038444, user_data = 0x1000}, {pos = 746600804, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 570083896, events = 8, fd = 1, user_data = 0x821fa6408}, {pos = 746514648, events = 8, fd = 565146792, user_data = 0x821af7260}, {pos = 32, events = 18, fd = 746585188, user_data = 0x821fa6408}, {pos = 570083896, events = 8, fd = 0, user_data = 0xa41}, {pos = 565146768, events = 8, fd = 1024136773, user_data = 0x82c803964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821faca38}, {pos = 1, events = 0, fd = 570057736, user_data = 0x839b53000}, {pos = 1, events = 0, fd = 968176020, user_data = 0x0}, {pos = 565146720, events = 8, fd = 769903628, user_data = 0x1}, {pos = 968175616, events = 8, fd = 565146768, user_data = 0x82de3beb4}, {pos = 748327264, events = 8, fd = 748327264, user_data = 0x82c81b0c0}, {pos = 570057736, events = 8, fd = 565146992, user_data = 0x3bee3d0b142c}, {pos = 922161296, events = 8, fd = 1, user_data = 0x3bee3d0b12ae}, {pos = 12240, events = 0, fd = 565146776, user_data = 0x821af7570}, {pos = 968853480, events = 8, fd = 565148384, user_data = 0x3bee3d0c4e90}, {pos = 570057736, events = 8, fd = 565117823, user_data = 0x82c95559c}, {pos = 570028040, events = 8, fd = 0, user_data = 0x821fa6408}, {pos = 12240, events = 0, fd = 746450944, user_data = 0x1df950}, {pos = 748327264, events = 8, fd = 746585188, user_data = 0x3d00}, {pos = 565148176, events = 8, fd = 565147104, user_data = 0x82c8a418e }, {pos = 748365880, events = 8, fd = 565147044, user_data = 0x839bb85da}, {pos = 565148176, events = 8, fd = 565147104, user_data = 0x82c8ba605}, {pos = 565147042, events = 8, fd = 565148176, user_data = 0x821af7a10}, {pos = 0, events = 16777216, fd = 1390623999, user_data = 0x821af7a10}, {pos = 968590808, events = 8, fd = 565148384, user_data = 0x82c9b2838}, {pos = 0, events = 0, fd = 565148240, user_data = 0x82c8ba70d}, {pos = 0, events = 0, fd = 0, user_data = 0x821af7b80}, {pos = 968590808, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3bee3d0b8409}, {pos = 565147448, events = 8, fd = 746585188, user_data = 0x9c7}, {pos = 1024164873, events = 15342, fd = 565147480, user_data = 0x82c7ffc64}, {pos = 2758, events = 0, fd = 746557728, user_data = 0x821af76d8}, {pos = 570057736, events = 8, fd = 565147480, user_data = 0x82c7f9120}, {pos = 565147456, events = 8, fd = 1024144485, user_data = 0x0}, {pos = 0, events = 0, fd = 748466416, user_data = 0x82c7ef550}, {pos = 0, events = 0, fd = 0, user_data = 0x82c9b99b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x821af77c8}, {pos = 570077320, events = 8, fd = 1024164873, user_data = 0x821af7808}, {pos = 746585188, events = 8, fd = 2924, user_data = 0x82c7f93b8}, {pos = 565147528, events = 8, fd = 570057736, user_data = 0x821af7808}, {pos = 746558392, events = 8, fd = 565147632, user_data = 0x3bee3d0b3465}, {pos = 570081336, events = 8, fd = 1, user_data = 0x821fa6408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 565148040, events = 0, fd = 2565628, user_data = 0x821af79f0}, {pos = 565148144, events = 8, fd = 565148072, user_data = 0x1e}, {pos = 746521824, events = 8, fd = 565147800, user_data = 0x821fab248}, {pos = 565148248, events = 8, fd = 565147776, user_data = 0x3bee3d0b7da3}, {pos = 570081336, events = 8, fd = 2691611, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 570081336, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x821af7b58}, {pos = 570057736, events = 8, fd = 565148128, user_data = 0x2725fc}, {pos = 565148320, events = 8, fd = 565148320, user_data = 0x821af7a58}, {pos = 32, events = 0, fd = 565147904, user_data = 0x3bee3d0b7b83}} [18:20:38.907] last_touch_time = 1710180859 [18:20:38.907] last_lockfile_recheck_time = 1710180859 [18:20:38.907] nevents = 1 [18:20:38.907] #23 0x000000000082e113 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821af8210) at ../src/backend/postmaster/postmaster.c:1468 [18:20:38.907] userDoption = [18:20:38.907] listen_addr_saved = false [18:20:38.907] output_config_variable = [18:20:38.907] opt = [18:20:38.907] status = [18:20:38.907] #24 0x000000000076b395 in main (argc=8, argv=0x821af8210) at ../src/backend/main/main.c:197 [18:20:38.907] do_check_root = [18:20:38.921] [18:20:38.921] [18:20:38.921] [18:20:39.000] dumping /tmp/cores/postgres.16648.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:20:39.168] [New LWP 100135] [18:20:39.273] Core was generated by `postgres: primary: postgres regression [local] SELECT'. [18:20:39.273] Program terminated with signal SIGSEGV, Segmentation fault. [18:20:39.273] Address not mapped to object. [18:20:39.273] #0 equal (a=0x36ac97e8, b=b@entry=0x836ac60d8) at ../src/backend/nodes/equalfuncs.c:239 [18:20:39.273] 239 if (nodeTag(a) != nodeTag(b)) [18:20:39.347] [18:20:39.347] Thread 1 (LWP 100135): [18:20:39.347] #0 equal (a=0x36ac97e8, b=b@entry=0x836ac60d8) at ../src/backend/nodes/equalfuncs.c:239 [18:20:39.347] retval = [18:20:39.347] #1 0x000000000076ead2 in list_member (list=0x836ac9858, datum=datum@entry=0x836ac60d8) at ../src/backend/nodes/list.c:670 [18:20:39.347] cell__state = {l = 0x836ac9858, i = 0} [18:20:39.347] cell = 0x0 [18:20:39.347] cell__state = [18:20:39.347] #2 0x00000000007e2475 in add_new_column_to_pathtarget (target=0x836ac9778, expr=) at ../src/backend/optimizer/util/tlist.c:743 [18:20:39.347] No locals. [18:20:39.347] #3 add_new_columns_to_pathtarget (target=target@entry=0x836ac9778, exprs=0x836ac9988) at ../src/backend/optimizer/util/tlist.c:760 [18:20:39.347] expr = [18:20:39.347] lc__state = {l = 0x836ac9988, i = 0} [18:20:39.347] lc = 0xfffffe3b [18:20:39.347] #4 0x00000000007b1ea9 in make_group_input_target (root=0x83462f9e0, final_target=0x836ac9618) at ../src/backend/optimizer/plan/planner.c:5472 [18:20:39.347] parse = 0x8369f0ae0 [18:20:39.347] input_target = 0x836ac9778 [18:20:39.347] non_group_cols = 0x836ac9938 [18:20:39.347] i = [18:20:39.347] lc = [18:20:39.347] non_group_vars = 0x836ac9988 [18:20:39.347] #5 grouping_planner (root=root@entry=0x83462f9e0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:20:39.347] qp_extra = {activeWindows = 0x0, gset_data = 0x836ac7528} [18:20:39.347] activeWindows = 0x0 [18:20:39.347] sort_input_target_parallel_safe = false [18:20:39.347] grouping_target = 0x836ac9618 [18:20:39.347] scanjoin_target = [18:20:39.347] sort_input_targets = [18:20:39.347] wflists = 0x0 [18:20:39.347] gset_data = 0x836ac7528 [18:20:39.347] have_grouping = false [18:20:39.347] sort_input_targets_contain_srfs = [18:20:39.347] sort_input_target = 0x836ac9618 [18:20:39.347] grouping_target_parallel_safe = false [18:20:39.347] scanjoin_target_parallel_safe = [18:20:39.347] grouping_targets = [18:20:39.347] scanjoin_targets = [18:20:39.347] grouping_targets_contain_srfs = [18:20:39.347] scanjoin_targets_contain_srfs = [18:20:39.347] scanjoin_target_same_exprs = [18:20:39.347] extra = {limit_needed = 8, limit_tuples = 1.7429158013591058e-313, count_est = 72, offset_est = 34917744256} [18:20:39.347] parse = 0x8369f0ae0 [18:20:39.347] offset_est = [18:20:39.347] count_est = [18:20:39.347] limit_tuples = -1 [18:20:39.347] have_postponed_srfs = false [18:20:39.347] current_rel = 0x836aab208 [18:20:39.347] final_target = 0x836ac9618 [18:20:39.347] final_targets_contain_srfs = [18:20:39.347] final_targets = [18:20:39.347] final_rel = [18:20:39.347] lc = [18:20:39.347] final_target_parallel_safe = [18:20:39.347] #6 0x00000000007afdb4 in subquery_planner (glob=glob@entry=0x836ac39c0, parse=parse@entry=0x8369f0ae0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:20:39.347] root = 0x83462f9e0 [18:20:39.347] hasOuterJoins = false [18:20:39.347] hasResultRTEs = false [18:20:39.347] l = [18:20:39.347] newWithCheckOptions = [18:20:39.347] newHaving = 0x0 [18:20:39.347] final_rel = [18:20:39.347] #7 0x00000000007ae8d8 in standard_planner (parse=0x8369f0ae0, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [18:20:39.347] glob = 0x836ac39c0 [18:20:39.347] tuple_fraction = 0 [18:20:39.347] root = [18:20:39.347] final_rel = [18:20:39.347] best_path = [18:20:39.347] top_plan = [18:20:39.347] lp = [18:20:39.347] lr = [18:20:39.347] result = [18:20:39.347] #8 0x00000008367b76af in pgss_planner (parse=0x8369f0ae0, query_string=0x836ac60d8 "\006", cursorOptions=558005712, boundParams=0xfffffe3b) at ../contrib/pg_stat_statements/pg_stat_statements.c:972 [18:20:39.347] _local_sigjmp_buf = {{_sjb = {35273799005, 11902920, 34917744840, 34917745296, 34917744880, 0, 35276131040, 34917745696, 35276981119, 35276128848, 34917744992, 0}}} [18:20:39.347] _save_exception_stack = 0x821428420 [18:20:39.347] _save_context_stack = 0x0 [18:20:39.347] _do_rethrow = false [18:20:39.347] result = [18:20:39.347] #9 0x00000000007ae7a5 in planner (parse=0x36ac97e8, parse@entry=0x8369f0ae0, query_string=0x836ac60d8 "\006", query_string@entry=0x8344f5100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=558005712, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [18:20:39.347] result = [18:20:39.347] #10 0x00000000008d1c95 in pg_plan_query (querytree=querytree@entry=0x8369f0ae0, query_string=query_string@entry=0x8344f5100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:20:39.347] plan = [18:20:39.347] #11 0x00000000008d1d72 in pg_plan_queries (querytrees=0x836ac3970, query_string=query_string@entry=0x8344f5100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=558005712, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [18:20:39.347] query = 0x8369f0ae0 [18:20:39.347] stmt = [18:20:39.347] query_list__state = {l = 0x836ac3970, i = 0} [18:20:39.347] stmt_list = 0x0 [18:20:39.347] query_list = [18:20:39.347] #12 0x00000000008d5f0c in exec_simple_query (query_string=query_string@entry=0x8344f5100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [18:20:39.347] cmdtaglen = [18:20:39.347] snapshot_set = [18:20:39.347] per_parsetree_context = 0x0 [18:20:39.347] plantree_list = [18:20:39.347] qc = {commandTag = 336, nprocessed = 6} [18:20:39.347] parsetree = 0x834630600 [18:20:39.347] commandTag = [18:20:39.347] cmdtagname = [18:20:39.347] querytree_list = 0x0 [18:20:39.347] portal = [18:20:39.347] format = [18:20:39.347] receiver = [18:20:39.347] parsetree_item__state = {l = 0x836aaae38, i = 0} [18:20:39.347] 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" [18:20:39.347] dest = DestRemote [18:20:39.347] was_logged = [18:20:39.347] oldcontext = 0x834501000 [18:20:39.347] parsetree_list = 0x836aaae38 [18:20:39.347] use_implicit_block = false [18:20:39.347] parsetree_item = 0x836aaae50 [18:20:39.347] save_log_statement_stats = [18:20:39.347] #13 0x00000000008d3de4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [18:20:39.347] query_string = 0x8344f5100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [18:20:39.347] input_message = {data = 0x8344f5100 "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} [18:20:39.347] firstchar = [18:20:39.347] local_sigjmp_buf = {{_sjb = {9253552, 34917745696, 34917745656, 34917746256, 11911656, 11858144, 8192, 8388608, 72057628955640703, 0, 0, 1}}} [18:20:39.347] send_ready_for_query = false [18:20:39.347] idle_in_transaction_timeout_enabled = false [18:20:39.347] idle_session_timeout_enabled = false [18:20:39.347] #14 0x0000000000832ad5 in BackendRun (port=port@entry=0x8345d2000) at ../src/backend/postmaster/postmaster.c:4475 [18:20:39.347] No locals. [18:20:39.347] #15 0x0000000000830e0d in BackendStartup (port=0x8345d2000) at ../src/backend/postmaster/postmaster.c:4151 [18:20:39.347] bn = 0x8345013a8 [18:20:39.347] pid = [18:20:39.347] __error = [18:20:39.347] __error = [18:20:39.347] __error = [18:20:39.347] save_errno = [18:20:39.347] __error = [18:20:39.347] #16 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:20:39.347] port = 0x8345d2000 [18:20:39.347] i = 0 [18:20:39.347] now = [18:20:39.347] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 566488072, events = 8, fd = 566489096, user_data = 0x821c3f408}, {pos = 566491144, events = 8, fd = 566492168, user_data = 0x821c40008}, {pos = 566494216, events = 8, fd = 566513800, user_data = 0x821428958}, {pos = 558008176, events = 8, fd = 1333005731, user_data = 0x821c40408}, {pos = 2565810, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 566517816, events = 8, fd = 1, user_data = 0x821c40408}, {pos = 719742120, events = 8, fd = 558008920, user_data = 0x821c40408}, {pos = 558008144, events = 0, fd = 2565628, user_data = 0x8214289a0}, {pos = 719849828, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 566520376, events = 8, fd = 1, user_data = 0x821c40408}, {pos = 719763672, events = 8, fd = 558008472, user_data = 0x821428640}, {pos = 33, events = 18, fd = 719834212, user_data = 0x821c40408}, {pos = 566520376, events = 8, fd = 0, user_data = 0xa41}, {pos = 558008448, events = 8, fd = 1332979269, user_data = 0x82ae80964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821c46a38}, {pos = 1, events = 0, fd = 566494216, user_data = 0x8344e5000}, {pos = 1, events = 0, fd = 877547924, user_data = 0x0}, {pos = 558008400, events = 8, fd = 712465420, user_data = 0x1}, {pos = 877547520, events = 8, fd = 558008448, user_data = 0x82a774eb4}, {pos = 721576288, events = 8, fd = 721576288, user_data = 0x82ae980c0}, {pos = 566494216, events = 8, fd = 558008672, user_data = 0x179e4f73a42c}, {pos = 80627796, events = 0, fd = 1, user_data = 0x179e4f73a2ae}, {pos = 12240, events = 0, fd = 558008456, user_data = 0x821428960}, {pos = 878344168, events = 8, fd = 558010064, user_data = 0x179e4f74de90}, {pos = 566494216, events = 8, fd = 557974399, user_data = 0x82afd24b2}, {pos = 558008976, events = 8, fd = 0, user_data = 0x821c40408}, {pos = 12240, events = 0, fd = 719699968, user_data = 0x1df950}, {pos = 721576288, events = 8, fd = 719834212, user_data = 0x3d00}, {pos = 558009856, events = 8, fd = 558008784, user_data = 0x82af2118e }, {pos = 721614904, events = 8, fd = 558008724, user_data = 0x83454c5da}, {pos = 558009856, events = 8, fd = 558008784, user_data = 0x82af37605}, {pos = 558008722, events = 8, fd = 558009856, user_data = 0x821428e00}, {pos = 0, events = 16777216, fd = -1430708012, user_data = 0x821428e00}, {pos = 877970904, events = 8, fd = 558010064, user_data = 0x82b02f838}, {pos = 0, events = 0, fd = 558009920, user_data = 0x82af3770d}, {pos = 0, events = 0, fd = 0, user_data = 0x821428f70}, {pos = 877970904, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1333007369, events = 6046, fd = 558009112, user_data = 0x82ae7cc64}, {pos = 2503, events = 0, fd = 1333007369, user_data = 0x821428b38}, {pos = 719834212, events = 8, fd = 2758, user_data = 0x82ae76120}, {pos = 558009016, events = 8, fd = 566494216, user_data = 0x821428b38}, {pos = 719806752, events = 8, fd = 558009120, user_data = 0x179e4f73c465}, {pos = 0, events = 0, fd = 0, user_data = 0x821428b10}, {pos = 719766864, events = 8, fd = 0, user_data = 0x0}, {pos = 558009072, events = 8, fd = 16, user_data = 0x0}, {pos = 558009256, events = 8, fd = 566513800, user_data = 0x179e4f741409}, {pos = 558009320, events = 8, fd = 719834212, user_data = 0xb6c}, {pos = 719807416, events = 8, fd = 558009192, user_data = 0x821c40408}, {pos = 558009320, events = 8, fd = 719807416, user_data = 0x821428bd0}, {pos = 1332986981, events = 6046, fd = 566517816, user_data = 0x800000001}, {pos = 566494216, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 558009720, user_data = 0x2725fc}, {pos = 558009824, events = 8, fd = 558009824, user_data = 0x821428d98}, {pos = 31, events = 0, fd = 0, user_data = 0x821428c78}, {pos = 566515592, events = 8, fd = 558009928, user_data = 0x821428c60}, {pos = 1333005731, events = 6046, fd = 566517816, user_data = 0x29121b}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821c46038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558010184, events = 8, fd = 0, user_data = 0x321428dd0}, {pos = 566515688, events = 8, fd = 558010000, user_data = 0x290}, {pos = 558009928, events = 8, fd = 558009464, user_data = 0x821428ce0}, {pos = 1333005357, events = 6046, fd = 566482952, user_data = 0x0}} [18:20:39.347] last_touch_time = 1710180953 [18:20:39.347] last_lockfile_recheck_time = 1710180953 [18:20:39.347] nevents = 1 [18:20:39.347] #17 0x000000000082e113 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821429600) at ../src/backend/postmaster/postmaster.c:1468 [18:20:39.347] userDoption = [18:20:39.347] listen_addr_saved = false [18:20:39.347] output_config_variable = [18:20:39.347] opt = [18:20:39.347] status = [18:20:39.347] #18 0x000000000076b395 in main (argc=4, argv=0x821429600) at ../src/backend/main/main.c:197 [18:20:39.347] do_check_root = [18:20:39.359] [18:20:39.359] [18:20:39.359] [18:20:39.441] dumping /tmp/cores/postgres.21119.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:39.613] [New LWP 100099] [18:20:39.716] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT'. [18:20:39.716] Program terminated with signal SIGSEGV, Segmentation fault. [18:20:39.716] Address not mapped to object. [18:20:39.716] #0 get_expr_width (root=root@entry=0x8449a7000, expr=expr@entry=0x44a5eef0) at ../src/backend/optimizer/path/costsize.c:6328 [18:20:39.716] 6328 if (IsA(expr, Var)) [18:20:39.748] [18:20:39.748] Thread 1 (LWP 100099): [18:20:39.748] #0 get_expr_width (root=root@entry=0x8449a7000, expr=expr@entry=0x44a5eef0) at ../src/backend/optimizer/path/costsize.c:6328 [18:20:39.748] width = [18:20:39.748] #1 0x0000000000789865 in set_pathtarget_cost_width (root=root@entry=0x8449a7000, target=target@entry=0x844a5ee80) at ../src/backend/optimizer/path/costsize.c:6299 [18:20:39.748] node = 0x44a5eef0 [18:20:39.748] lc__state = {l = 0x844a5ef60, i = 0} [18:20:39.748] tuple_width = 0 [18:20:39.748] lc = 0x844a5ef78 [18:20:39.748] #2 0x00000000007b1ec4 in make_group_input_target (root=0x8449a7000, final_target=0x844a5edc0) at ../src/backend/optimizer/plan/planner.c:5479 [18:20:39.748] parse = 0x8449aa430 [18:20:39.748] input_target = 0x844a5ee80 [18:20:39.748] non_group_cols = 0x0 [18:20:39.748] i = [18:20:39.748] lc = [18:20:39.748] non_group_vars = 0x0 [18:20:39.748] #3 grouping_planner (root=root@entry=0x8449a7000, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:20:39.748] qp_extra = {activeWindows = 0x0, gset_data = 0x844a5ba78} [18:20:39.748] activeWindows = 0x0 [18:20:39.748] sort_input_target_parallel_safe = false [18:20:39.748] grouping_target = 0x844a5edc0 [18:20:39.748] scanjoin_target = [18:20:39.748] sort_input_targets = [18:20:39.748] wflists = 0x0 [18:20:39.748] gset_data = 0x844a5ba78 [18:20:39.748] have_grouping = false [18:20:39.748] sort_input_targets_contain_srfs = [18:20:39.748] sort_input_target = 0x844a5edc0 [18:20:39.748] grouping_target_parallel_safe = false [18:20:39.748] scanjoin_target_parallel_safe = [18:20:39.748] grouping_targets = [18:20:39.748] scanjoin_targets = [18:20:39.748] grouping_targets_contain_srfs = [18:20:39.748] scanjoin_targets_contain_srfs = [18:20:39.748] scanjoin_target_same_exprs = [18:20:39.748] extra = {limit_needed = 208, limit_tuples = 1.7248160269735027e-313, count_est = 16, offset_est = 34910665072} [18:20:39.748] parse = 0x8449aa430 [18:20:39.748] offset_est = [18:20:39.748] count_est = [18:20:39.748] limit_tuples = -1 [18:20:39.748] have_postponed_srfs = false [18:20:39.748] current_rel = 0x844a5d3b0 [18:20:39.748] final_target = 0x844a5edc0 [18:20:39.748] final_targets_contain_srfs = [18:20:39.748] final_targets = [18:20:39.748] final_rel = [18:20:39.748] lc = [18:20:39.748] final_target_parallel_safe = [18:20:39.748] #4 0x00000000007afdb4 in subquery_planner (glob=glob@entry=0x8449abd58, parse=parse@entry=0x8449aa430, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:20:39.748] root = 0x8449a7000 [18:20:39.748] hasOuterJoins = false [18:20:39.748] hasResultRTEs = false [18:20:39.748] l = [18:20:39.748] newWithCheckOptions = [18:20:39.748] newHaving = 0x0 [18:20:39.748] final_rel = [18:20:39.748] #5 0x00000000007ae8d8 in standard_planner (parse=0x8449aa430, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [18:20:39.748] glob = 0x8449abd58 [18:20:39.748] tuple_fraction = 0 [18:20:39.748] root = [18:20:39.748] final_rel = [18:20:39.748] best_path = [18:20:39.748] top_plan = [18:20:39.748] lp = [18:20:39.748] lr = [18:20:39.748] result = [18:20:39.748] #6 0x000000083895a712 in pgss_planner (parse=0x8449aa430, query_string=0x836202100 "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=0x844a5ef78) at ../contrib/pg_stat_statements/pg_stat_statements.c:926 [18:20:39.748] _local_sigjmp_buf = {{_sjb = {35309069935, 35267813632, 34910665656, 34910666112, 11902920, 35510723632, 34910665824, 0, 34910634879, 11089253, 2, 34359738368}}} [18:20:39.748] _save_exception_stack = 0x820d67f10 [18:20:39.748] _save_context_stack = 0x0 [18:20:39.748] _do_rethrow = false [18:20:39.748] bufusage = {shared_blks_hit = 35309069935, shared_blks_read = 35267813632, shared_blks_dirtied = 34910665656, shared_blks_written = 34910666112, local_blks_hit = 11902920, local_blks_read = 35510723632, local_blks_dirtied = 34910665824, local_blks_written = 0, temp_blks_read = 34910634879, temp_blks_written = 11089253, shared_blk_read_time = {ticks = 2}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 34910665968}, local_blk_write_time = {ticks = 11118239}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 35510729816}} [18:20:39.748] walusage_start = {wal_records = 1346, wal_fpi = 2, wal_bytes = 170363} [18:20:39.748] duration = [18:20:39.748] 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}} [18:20:39.748] walusage = {wal_records = 35510723632, wal_fpi = 35511522360, wal_bytes = 34910666032} [18:20:39.748] start = [18:20:39.748] result = [18:20:39.748] #7 0x00000000007ae7a5 in planner (parse=0x8449a7000, parse@entry=0x8449aa430, query_string=0x44a5eef0 , query_string@entry=0x836202100 "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=0x844a5ef78, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [18:20:39.748] result = [18:20:39.748] #8 0x00000000008d1c95 in pg_plan_query (querytree=querytree@entry=0x8449aa430, query_string=query_string@entry=0x836202100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:20:39.748] plan = [18:20:39.748] #9 0x00000000008d1d72 in pg_plan_queries (querytrees=0x8449abd08, query_string=query_string@entry=0x836202100 "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=0x844a5ef78, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [18:20:39.748] query = 0x8449aa430 [18:20:39.748] stmt = [18:20:39.748] query_list__state = {l = 0x8449abd08, i = 0} [18:20:39.748] stmt_list = 0x0 [18:20:39.748] query_list = [18:20:39.748] #10 0x00000000008d5f0c in exec_simple_query (query_string=query_string@entry=0x836202100 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;") at ../src/backend/tcop/postgres.c:1192 [18:20:39.748] cmdtaglen = [18:20:39.748] snapshot_set = [18:20:39.748] per_parsetree_context = 0x0 [18:20:39.748] plantree_list = [18:20:39.748] qc = {commandTag = 336, nprocessed = 6} [18:20:39.748] parsetree = 0x844a1acb0 [18:20:39.748] commandTag = [18:20:39.748] cmdtagname = [18:20:39.748] querytree_list = 0x0 [18:20:39.748] portal = [18:20:39.748] format = [18:20:39.748] receiver = [18:20:39.748] parsetree_item__state = {l = 0x844a6d3e8, i = 0} [18:20:39.748] 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" [18:20:39.748] dest = DestRemote [18:20:39.748] was_logged = [18:20:39.748] oldcontext = 0x83620e000 [18:20:39.748] parsetree_list = 0x844a6d3e8 [18:20:39.748] use_implicit_block = false [18:20:39.748] parsetree_item = 0x844a6d400 [18:20:39.748] save_log_statement_stats = [18:20:39.748] #11 0x00000000008d3de4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [18:20:39.748] query_string = 0x836202100 "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;" [18:20:39.748] input_message = {data = 0x836202100 "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} [18:20:39.748] firstchar = [18:20:39.748] local_sigjmp_buf = {{_sjb = {9253552, 34910666512, 34910666472, 34910667072, 11911656, 11858144, 8192, 8388608, 72057628948562815, 0, 0, 34359738369}}} [18:20:39.748] send_ready_for_query = false [18:20:39.748] idle_in_transaction_timeout_enabled = false [18:20:39.748] idle_session_timeout_enabled = false [18:20:39.748] #12 0x0000000000832ad5 in BackendRun (port=port@entry=0x8362d8000) at ../src/backend/postmaster/postmaster.c:4475 [18:20:39.748] No locals. [18:20:39.748] #13 0x0000000000830e0d in BackendStartup (port=0x8362d8000) at ../src/backend/postmaster/postmaster.c:4151 [18:20:39.748] bn = 0x83620e238 [18:20:39.748] pid = [18:20:39.748] __error = [18:20:39.748] __error = [18:20:39.748] __error = [18:20:39.748] save_errno = [18:20:39.748] __error = [18:20:39.748] #14 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:20:39.748] port = 0x8362d8000 [18:20:39.748] i = 0 [18:20:39.748] now = [18:20:39.748] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 554335240, events = 8, fd = 554336264, user_data = 0x8210a8408}, {pos = 554338312, events = 8, fd = 554339336, user_data = 0x8210a9008}, {pos = 554341384, events = 8, fd = 895523808, user_data = 0xa0}, {pos = -1, events = 0, fd = 732758752, user_data = 0x820d68230}, {pos = 732418473, events = 8, fd = 0, user_data = 0x1000}, {pos = 1276383113, events = 250981642, fd = 732760040, user_data = 0x835609be0}, {pos = 160, events = 0, fd = 0, user_data = 0x834148090}, {pos = 550929152, events = 8, fd = 732281132, user_data = 0x1000}, {pos = 730843492, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 554367544, events = 8, fd = 1, user_data = 0x8210a9408}, {pos = 730757336, events = 8, fd = 550929288, user_data = 0x820d68130}, {pos = 33, events = 18, fd = 730827876, user_data = 0x8210a9408}, {pos = 554367544, events = 8, fd = 0, user_data = 0xa41}, {pos = 550929264, events = 8, fd = -1219488187, user_data = 0x82b8fc964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x8210afa38}, {pos = 1, events = 0, fd = 554341384, user_data = 0x8361f2000}, {pos = 1, events = 0, fd = 908009876, user_data = 0x0}, {pos = 550929216, events = 8, fd = 701434892, user_data = 0x1}, {pos = 908009472, events = 8, fd = 550929264, user_data = 0x829cefeb4}, {pos = 732569952, events = 8, fd = 732569952, user_data = 0x82b9140c0}, {pos = 554341384, events = 8, fd = 550929488, user_data = 0x4afb750142c}, {pos = 873758864, events = 8, fd = 1, user_data = 0x4afb75012ae}, {pos = 12240, events = 0, fd = 550929272, user_data = 0x820d68450}, {pos = 908666856, events = 8, fd = 550930880, user_data = 0x4afb7514e90}, {pos = 554341384, events = 8, fd = 550896511, user_data = 0x82ba4e59c}, {pos = 550929792, events = 8, fd = 0, user_data = 0x8210a9408}, {pos = 12240, events = 0, fd = 730693632, user_data = 0x1df950}, {pos = 732569952, events = 8, fd = 730827876, user_data = 0x3d00}, {pos = 550930672, events = 8, fd = 550929600, user_data = 0x82b99d18e }, {pos = 732608568, events = 8, fd = 550929540, user_data = 0x8362525da}, {pos = 550930672, events = 8, fd = 550929600, user_data = 0x82b9b3605}, {pos = 550929538, events = 8, fd = 550930672, user_data = 0x820d688f0}, {pos = 0, events = 16777216, fd = 1276383113, user_data = 0x820d688f0}, {pos = 908404184, events = 8, fd = 550930880, user_data = 0x82baab838}, {pos = 0, events = 0, fd = 550930736, user_data = 0x82b9b370d}, {pos = 0, events = 0, fd = 0, user_data = 0x820d68a60}, {pos = 908404184, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1219460087, events = 1199, fd = 550929928, user_data = 0x82b8f8c64}, {pos = 2503, events = 0, fd = -1219460087, user_data = 0x820d68628}, {pos = 730827876, events = 8, fd = 2758, user_data = 0x82b8f2120}, {pos = 550929832, events = 8, fd = 554341384, user_data = 0x820d68628}, {pos = 730800416, events = 8, fd = 550929936, user_data = 0x4afb7503465}, {pos = 0, events = 0, fd = 0, user_data = 0x820d68600}, {pos = 730760528, events = 8, fd = 0, user_data = 0x0}, {pos = 550929888, events = 8, fd = 16, user_data = 0x0}, {pos = 550930072, events = 8, fd = 554360968, user_data = 0x4afb7508409}, {pos = 550930136, events = 8, fd = 730827876, user_data = 0xb6c}, {pos = 730801080, events = 8, fd = 550930008, user_data = 0x8210a9408}, {pos = 550930136, events = 8, fd = 730801080, user_data = 0x820d686c0}, {pos = -1219480475, events = 1199, fd = 554364984, user_data = 0x800000001}, {pos = 554341384, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 550930536, user_data = 0x2725fc}, {pos = 550930640, events = 8, fd = 550930640, user_data = 0x820d68888}, {pos = 31, events = 0, fd = 0, user_data = 0x820d68768}, {pos = 554362760, events = 8, fd = 550930744, user_data = 0x820d68750}, {pos = -1219461725, events = 1199, fd = 554364984, user_data = 0x29121b}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x8210af038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 550931000, events = 8, fd = 0, user_data = 0x320d688c0}, {pos = 554362856, events = 8, fd = 550930816, user_data = 0x290}, {pos = 550930744, events = 8, fd = 550930280, user_data = 0x820d687d0}, {pos = -1219462099, events = 1199, fd = 554330120, user_data = 0x0}} [18:20:39.748] last_touch_time = 1710181008 [18:20:39.748] last_lockfile_recheck_time = 1710181008 [18:20:39.748] nevents = 1 [18:20:39.748] #15 0x000000000082e113 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820d690f0) at ../src/backend/postmaster/postmaster.c:1468 [18:20:39.748] userDoption = [18:20:39.748] listen_addr_saved = false [18:20:39.748] output_config_variable = [18:20:39.748] opt = [18:20:39.748] status = [18:20:39.748] #16 0x000000000076b395 in main (argc=8, argv=0x820d690f0) at ../src/backend/main/main.c:197 [18:20:39.748] do_check_root = [18:20:39.760] [18:20:39.760] [18:20:39.760] [18:20:39.845] dumping /tmp/cores/postgres.21349.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:20:40.014] [New LWP 101799] [18:20:40.121] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN'. [18:20:40.121] Program terminated with signal SIGSEGV, Segmentation fault. [18:20:40.121] Address not mapped to object. [18:20:40.121] #0 equal (a=0x33dfd0d8, b=b@entry=0x833da4678) at ../src/backend/nodes/equalfuncs.c:239 [18:20:40.121] 239 if (nodeTag(a) != nodeTag(b)) [18:20:40.755] [18:20:40.755] Thread 1 (LWP 101799): [18:20:40.755] #0 equal (a=0x33dfd0d8, b=b@entry=0x833da4678) at ../src/backend/nodes/equalfuncs.c:239 [18:20:40.755] retval = [18:20:40.755] #1 0x000000000076ead2 in list_member (list=0x833dfd148, datum=datum@entry=0x833da4678) at ../src/backend/nodes/list.c:670 [18:20:40.755] cell__state = {l = 0x833dfd148, i = 0} [18:20:40.755] cell = 0x0 [18:20:40.755] cell__state = [18:20:40.755] #2 0x00000000007e2475 in add_new_column_to_pathtarget (target=0x833dfd088, expr=) at ../src/backend/optimizer/util/tlist.c:743 [18:20:40.755] No locals. [18:20:40.755] #3 add_new_columns_to_pathtarget (target=target@entry=0x833dfd088, exprs=0x833dfd1e8) at ../src/backend/optimizer/util/tlist.c:760 [18:20:40.755] expr = [18:20:40.755] lc__state = {l = 0x833dfd1e8, i = 0} [18:20:40.755] lc = 0xfffffe3b [18:20:40.755] #4 0x00000000007b1ea9 in make_group_input_target (root=0x833da4038, final_target=0x833f18fa8) at ../src/backend/optimizer/plan/planner.c:5472 [18:20:40.755] parse = 0x8367fcc60 [18:20:40.755] input_target = 0x833dfd088 [18:20:40.755] non_group_cols = 0x833dfd198 [18:20:40.755] i = [18:20:40.755] lc = [18:20:40.755] non_group_vars = 0x833dfd1e8 [18:20:40.755] #5 grouping_planner (root=root@entry=0x833da4038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:20:40.755] qp_extra = {activeWindows = 0x0, gset_data = 0x833da48a8} [18:20:40.755] activeWindows = 0x0 [18:20:40.755] sort_input_target_parallel_safe = false [18:20:40.755] grouping_target = 0x833f18fa8 [18:20:40.755] scanjoin_target = [18:20:40.755] sort_input_targets = [18:20:40.755] wflists = 0x0 [18:20:40.755] gset_data = 0x833da48a8 [18:20:40.755] have_grouping = false [18:20:40.755] sort_input_targets_contain_srfs = [18:20:40.755] sort_input_target = 0x833f18fa8 [18:20:40.755] grouping_target_parallel_safe = false [18:20:40.755] scanjoin_target_parallel_safe = [18:20:40.755] grouping_targets = [18:20:40.755] scanjoin_targets = [18:20:40.755] grouping_targets_contain_srfs = [18:20:40.755] scanjoin_targets_contain_srfs = [18:20:40.755] scanjoin_target_same_exprs = [18:20:40.755] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 34911130624} [18:20:40.755] parse = 0x8367fcc60 [18:20:40.755] offset_est = [18:20:40.755] count_est = [18:20:40.755] limit_tuples = -1 [18:20:40.755] have_postponed_srfs = false [18:20:40.755] current_rel = 0x833ddddd8 [18:20:40.755] final_target = 0x833f18fa8 [18:20:40.755] final_targets_contain_srfs = [18:20:40.755] final_targets = [18:20:40.755] final_rel = [18:20:40.755] lc = [18:20:40.755] final_target_parallel_safe = [18:20:40.755] #6 0x00000000007afdb4 in subquery_planner (glob=glob@entry=0x833ddd998, parse=parse@entry=0x8367fcc60, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:20:40.755] root = 0x833da4038 [18:20:40.755] hasOuterJoins = false [18:20:40.755] hasResultRTEs = false [18:20:40.755] l = [18:20:40.755] newWithCheckOptions = [18:20:40.755] newHaving = 0x0 [18:20:40.755] final_rel = [18:20:40.755] #7 0x00000000007ae8d8 in standard_planner (parse=0x8367fcc60, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [18:20:40.755] glob = 0x833ddd998 [18:20:40.755] tuple_fraction = 0 [18:20:40.755] root = [18:20:40.755] final_rel = [18:20:40.755] best_path = [18:20:40.755] top_plan = [18:20:40.755] lp = [18:20:40.755] lr = [18:20:40.755] result = [18:20:40.755] #8 0x00000000007ae7ac in planner (parse=0x33dfd0d8, parse@entry=0x8367fcc60, query_string=0x833da4678 "\006", query_string@entry=0x833d48100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=551392064, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [18:20:40.755] result = [18:20:40.755] #9 0x00000000008d1c95 in pg_plan_query (querytree=querytree@entry=0x8367fcc60, query_string=query_string@entry=0x833d48100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:20:40.755] plan = [18:20:40.755] #10 0x00000000006859c9 in standard_ExplainOneQuery (query=0x8367fcc60, cursorOptions=551392064, cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x833d56748, queryString=0x833da4678 "\006", params=0xfffffe3b, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:441 [18:20:40.755] planduration = {ticks = 7789824} [18:20:40.755] bufusage_start = {shared_blks_hit = 1, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 34911131376, local_blks_read = 10584593, local_blks_dirtied = 70368744194107, local_blks_written = 0, temp_blks_read = 34911131408, temp_blks_written = 5658010, shared_blk_read_time = {ticks = 70368744194107}, shared_blk_write_time = {ticks = 35274083424}, local_blk_read_time = {ticks = 34911131424}, local_blk_write_time = {ticks = 6206329}, temp_blk_read_time = {ticks = 34911131600}, temp_blk_write_time = {ticks = 8914661}} [18:20:40.755] bufusage = {shared_blks_hit = 330, shared_blks_read = 717733331, shared_blks_dirtied = 34911131536, shared_blks_written = 35274082249, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = -3047711002350967416, local_blks_written = 34911131564, temp_blks_read = -1, temp_blks_written = 10797731, shared_blk_read_time = {ticks = 35274086160}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35274083424}, local_blk_write_time = {ticks = 35274083424}, temp_blk_read_time = {ticks = 34911131568}, temp_blk_write_time = {ticks = 10833296}} [18:20:40.755] mem_counters = {nblocks = 34911131344, freechunks = 9139413, totalspace = 34911131344, freespace = 35276097864} [18:20:40.755] planner_ctx = 0x0 [18:20:40.755] saved_ctx = [18:20:40.755] planstart = {ticks = -330717733331} [18:20:40.755] plan = [18:20:40.755] #11 0x000000000068539c in ExplainOneQuery (query=0x33dfd0d8, cursorOptions=2048, into=0x0, es=0x833d56748, queryString=0x3 , params=0x833dfd000, queryEnv=) at ../src/backend/commands/explain.c:397 [18:20:40.755] No locals. [18:20:40.755] #12 ExplainQuery (pstate=pstate@entry=0x833d56638, stmt=stmt@entry=0x8367fcc30, params=0x833dfd000, params@entry=0x0, dest=0x833d565a8) at ../src/backend/commands/explain.c:293 [18:20:40.755] l__state = {l = , i = 0} [18:20:40.755] l = 0x833de44b0 [18:20:40.755] es = 0x833d56748 [18:20:40.755] jstate = [18:20:40.755] timing_set = false [18:20:40.755] summary_set = false [18:20:40.755] lc = [18:20:40.755] query = [18:20:40.755] rewritten = 0x833de4498 [18:20:40.755] tstate = [18:20:40.755] #13 0x00000000008d8d9f in standard_ProcessUtility (pstmt=0x833efc3a8, queryString=0x833d48100 "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=0x820dd9340, queryEnv=0x0, dest=0x833d565a8, qc=0x820dd9988) at ../src/backend/tcop/utility.c:863 [18:20:40.755] isAtomicContext = true [18:20:40.755] parsetree = 0x8367fcc30 [18:20:40.755] readonly_flags = [18:20:40.755] pstate = 0x833d56638 [18:20:40.755] isTopLevel = [18:20:40.755] #14 0x00000000008d86cd in ProcessUtility (pstmt=0x33dfd0d8, pstmt@entry=0x833efc3a8, queryString=0x833da4678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x833dfd000, dest=0x833d565a8, qc=0x820dd9988) at ../src/backend/tcop/utility.c:523 [18:20:40.755] No locals. [18:20:40.755] #15 0x00000000008d81f3 in PortalRunUtility (portal=portal@entry=0x833e1d100, pstmt=0x833efc3a8, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x833d565a8, qc=qc@entry=0x820dd9988) at ../src/backend/tcop/pquery.c:1158 [18:20:40.755] No locals. [18:20:40.755] #16 0x00000000008d73ea in FillPortalStore (portal=portal@entry=0x833e1d100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [18:20:40.755] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:40.755] treceiver = 0x833d565a8 [18:20:40.755] #17 0x00000000008d70f0 in PortalRun (portal=portal@entry=0x833e1d100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x833efc508, altdest=altdest@entry=0x833efc508, qc=0x820dd9ac0) at ../src/backend/tcop/pquery.c:763 [18:20:40.755] _local_sigjmp_buf = {{_sjb = {9269391, 35230223296, 34911132088, 34911132320, 34911132096, 11902920, 11870704, 35230175488, -6347183290308557953, 35230183680, 3553530, 34359738368}}} [18:20:40.755] _save_exception_stack = 0x820dd9b90 [18:20:40.755] _save_context_stack = 0x0 [18:20:40.755] _do_rethrow = false [18:20:40.755] saveTopTransactionResourceOwner = 0x833e28bc0 [18:20:40.755] saveTopTransactionContext = 0x833d54000 [18:20:40.755] saveActivePortal = 0x0 [18:20:40.755] saveResourceOwner = 0x833e28bc0 [18:20:40.755] savePortalContext = 0x0 [18:20:40.755] saveMemoryContext = 0x833d54000 [18:20:40.755] result = [18:20:40.755] nprocessed = [18:20:40.755] #18 0x00000000008d5ffb in exec_simple_query (query_string=query_string@entry=0x833d48100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;") at ../src/backend/tcop/postgres.c:1273 [18:20:40.755] cmdtaglen = [18:20:40.755] snapshot_set = [18:20:40.755] per_parsetree_context = 0x0 [18:20:40.755] plantree_list = [18:20:40.755] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:20:40.755] parsetree = 0x833e11e60 [18:20:40.755] commandTag = CMDTAG_EXPLAIN [18:20:40.755] cmdtagname = [18:20:40.755] querytree_list = [18:20:40.755] portal = 0x833e1d100 [18:20:40.755] format = 0 [18:20:40.755] receiver = 0x833efc508 [18:20:40.755] parsetree_item__state = {l = 0x833e129b0, i = 0} [18:20:40.755] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [18:20:40.755] dest = DestRemote [18:20:40.755] was_logged = [18:20:40.755] oldcontext = 0x833d54000 [18:20:40.755] parsetree_list = 0x833e129b0 [18:20:40.755] use_implicit_block = false [18:20:40.755] parsetree_item = 0x833e129c8 [18:20:40.755] save_log_statement_stats = [18:20:40.755] #19 0x00000000008d3de4 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [18:20:40.755] query_string = 0x833d48100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [18:20:40.755] input_message = {data = 0x833d48100 "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} [18:20:40.755] firstchar = [18:20:40.755] local_sigjmp_buf = {{_sjb = {9253552, 34911132560, 34911132520, 34911133120, 11911656, 11858144, 8192, 8388608, 72057628949021567, 0, 0, 34359738369}}} [18:20:40.755] send_ready_for_query = false [18:20:40.755] idle_in_transaction_timeout_enabled = false [18:20:40.755] idle_session_timeout_enabled = false [18:20:40.755] #20 0x0000000000832ad5 in BackendRun (port=port@entry=0x833e23000) at ../src/backend/postmaster/postmaster.c:4475 [18:20:40.755] No locals. [18:20:40.755] #21 0x0000000000830e0d in BackendStartup (port=0x833e23000) at ../src/backend/postmaster/postmaster.c:4151 [18:20:40.755] bn = 0x833d54128 [18:20:40.755] pid = [18:20:40.755] __error = [18:20:40.755] __error = [18:20:40.755] __error = [18:20:40.755] save_errno = [18:20:40.755] __error = [18:20:40.755] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:20:40.755] port = 0x833e23000 [18:20:40.755] i = 0 [18:20:40.755] now = [18:20:40.755] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 563758088, events = 8, fd = 563759112, user_data = 0x8219a4c08}, {pos = 563761160, events = 8, fd = 563762184, user_data = 0x8219a5808}, {pos = 563764232, events = 8, fd = 563765256, user_data = 0x8219a6408}, {pos = -1, events = 0, fd = 667611872, user_data = 0x820dd9eb0}, {pos = 667271593, events = 8, fd = 0, user_data = 0x1000}, {pos = -1496177272, events = 3585366781, fd = 667613160, user_data = 0x832e09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x8316f2090}, {pos = 551395200, events = 8, fd = 667134252, user_data = 0x1000}, {pos = 665696612, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 563792440, events = 8, fd = 1, user_data = 0x8219a6408}, {pos = 665610456, events = 8, fd = 551395336, user_data = 0x820dd9dc0}, {pos = 32, events = 18, fd = 665680996, user_data = 0x8219a6408}, {pos = 563792440, events = 8, fd = 0, user_data = 0xa41}, {pos = 551395312, events = 8, fd = -1282828731, user_data = 0x827adb964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x8219aca38}, {pos = 1, events = 0, fd = 563766280, user_data = 0x833d38000}, {pos = 1, events = 0, fd = 869499284, user_data = 0x0}, {pos = 551395264, events = 8, fd = 656796684, user_data = 0x1}, {pos = 869498880, events = 8, fd = 551395312, user_data = 0x82725deb4}, {pos = 667423072, events = 8, fd = 667423072, user_data = 0x827af30c0}, {pos = 563766280, events = 8, fd = 551395536, user_data = 0xafeb389942c}, {pos = 829366416, events = 8, fd = 1, user_data = 0xafeb38992ae}, {pos = 12240, events = 0, fd = 551395320, user_data = 0x820dda0d0}, {pos = 870176744, events = 8, fd = 551396928, user_data = 0xafeb38ace90}, {pos = 563766280, events = 8, fd = 551355263, user_data = 0x827c2d59c}, {pos = 563736584, events = 8, fd = 0, user_data = 0x8219a6408}, {pos = 12240, events = 0, fd = 665546752, user_data = 0x1df950}, {pos = 667423072, events = 8, fd = 665680996, user_data = 0x3d00}, {pos = 551396720, events = 8, fd = 551395648, user_data = 0x827b7c18e }, {pos = 667461688, events = 8, fd = 551395588, user_data = 0x833d9d5da}, {pos = 551396720, events = 8, fd = 551395648, user_data = 0x827b92605}, {pos = 551395586, events = 8, fd = 551396720, user_data = 0x820dda570}, {pos = 0, events = 16777216, fd = -1496177272, user_data = 0x820dda570}, {pos = 869914072, events = 8, fd = 551396928, user_data = 0x827c8a838}, {pos = 0, events = 0, fd = 551396784, user_data = 0x827b9270d}, {pos = 0, events = 0, fd = 0, user_data = 0x820dda6e0}, {pos = 869914072, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xafeb38a0409}, {pos = 551395992, events = 8, fd = 665680996, user_data = 0x9c7}, {pos = -1282800631, events = 2814, fd = 551396024, user_data = 0x827ad7c64}, {pos = 2758, events = 0, fd = 665653536, user_data = 0x820dda238}, {pos = 563766280, events = 8, fd = 551396024, user_data = 0x827ad1120}, {pos = 551396000, events = 8, fd = -1282821019, user_data = 0x0}, {pos = 0, events = 0, fd = 667562224, user_data = 0x827ac7550}, {pos = 0, events = 0, fd = 0, user_data = 0x827c919b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x820dda328}, {pos = 563785864, events = 8, fd = -1282800631, user_data = 0x820dda368}, {pos = 665680996, events = 8, fd = 2924, user_data = 0x827ad13b8}, {pos = 551396072, events = 8, fd = 563766280, user_data = 0x820dda368}, {pos = 665654200, events = 8, fd = 551396176, user_data = 0xafeb389b465}, {pos = 563789880, events = 8, fd = 1, user_data = 0x8219a6408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 551396584, events = 0, fd = 2565628, user_data = 0x820dda550}, {pos = 551396688, events = 8, fd = 551396616, user_data = 0x1e}, {pos = 665617632, events = 8, fd = 551396344, user_data = 0x8219ab248}, {pos = 551396792, events = 8, fd = 551396320, user_data = 0xafeb389fda3}, {pos = 563789880, events = 8, fd = 2691611, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 563789880, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820dda6b8}, {pos = 563766280, events = 8, fd = 551396672, user_data = 0x2725fc}, {pos = 551396864, events = 8, fd = 551396864, user_data = 0x820dda5b8}, {pos = 32, events = 0, fd = 551396448, user_data = 0xafeb389fb83}} [18:20:40.755] last_touch_time = 1710181010 [18:20:40.755] last_lockfile_recheck_time = 1710181010 [18:20:40.755] nevents = 1 [18:20:40.755] #23 0x000000000082e113 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820ddad78) at ../src/backend/postmaster/postmaster.c:1468 [18:20:40.755] userDoption = [18:20:40.755] listen_addr_saved = false [18:20:40.755] output_config_variable = [18:20:40.755] opt = [18:20:40.755] status = [18:20:40.755] #24 0x000000000076b395 in main (argc=8, argv=0x820ddad78) at ../src/backend/main/main.c:197 [18:20:40.755] do_check_root =