[09:19:49.230] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [09:19:49.587] dumping /tmp/cores/postgres.8583.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:19:49.732] [New LWP 100160] [09:19:49.815] Core was generated by `postgres: postgres regression [local] SELECT'. [09:19:49.815] Program terminated with signal SIGSEGV, Segmentation fault. [09:19:49.815] Address not mapped to object. [09:19:49.815] #0 equal (a=0x38d82df8, b=b@entry=0x838d7f6e8) at ../src/backend/nodes/equalfuncs.c:239 [09:19:49.815] 239 if (nodeTag(a) != nodeTag(b)) [09:19:49.847] [09:19:49.847] Thread 1 (LWP 100160): [09:19:49.847] #0 equal (a=0x38d82df8, b=b@entry=0x838d7f6e8) at ../src/backend/nodes/equalfuncs.c:239 [09:19:49.847] retval = [09:19:49.847] #1 0x0000000000767442 in list_member (list=0x838d82e68, datum=datum@entry=0x838d7f6e8) at ../src/backend/nodes/list.c:670 [09:19:49.847] cell__state = {l = 0x838d82e68, i = 0} [09:19:49.847] cell = 0x0 [09:19:49.847] cell__state = [09:19:49.847] #2 0x00000000007dae95 in add_new_column_to_pathtarget (target=0x838d82d88, expr=) at ../src/backend/optimizer/util/tlist.c:743 [09:19:49.847] No locals. [09:19:49.847] #3 add_new_columns_to_pathtarget (target=target@entry=0x838d82d88, exprs=0x838d82f98) at ../src/backend/optimizer/util/tlist.c:760 [09:19:49.847] expr = [09:19:49.847] lc__state = {l = 0x838d82f98, i = 0} [09:19:49.847] lc = 0xfffffe3b [09:19:49.847] #4 0x00000000007aa8a9 in make_group_input_target (root=0x8364acda8, final_target=0x838d82c28) at ../src/backend/optimizer/plan/planner.c:5472 [09:19:49.847] parse = 0x838d67d10 [09:19:49.847] input_target = 0x838d82d88 [09:19:49.847] non_group_cols = 0x838d82f48 [09:19:49.847] i = [09:19:49.847] lc = [09:19:49.847] non_group_vars = 0x838d82f98 [09:19:49.847] #5 grouping_planner (root=root@entry=0x8364acda8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [09:19:49.847] qp_extra = {activeWindows = 0x0, gset_data = 0x838d80b38} [09:19:49.847] activeWindows = 0x0 [09:19:49.847] sort_input_target_parallel_safe = false [09:19:49.847] grouping_target = 0x838d82c28 [09:19:49.847] scanjoin_target = [09:19:49.847] sort_input_targets = [09:19:49.847] wflists = 0x0 [09:19:49.847] gset_data = 0x838d80b38 [09:19:49.847] have_grouping = false [09:19:49.847] sort_input_targets_contain_srfs = [09:19:49.847] sort_input_target = 0x838d82c28 [09:19:49.847] grouping_target_parallel_safe = false [09:19:49.847] scanjoin_target_parallel_safe = [09:19:49.847] grouping_targets = [09:19:49.847] scanjoin_targets = [09:19:49.847] grouping_targets_contain_srfs = [09:19:49.847] scanjoin_targets_contain_srfs = [09:19:49.847] scanjoin_target_same_exprs = [09:19:49.847] extra = {limit_needed = 24, limit_tuples = 1.7447147386438956e-313, count_est = 72, offset_est = 34922143792} [09:19:49.847] parse = 0x838d67d10 [09:19:49.847] offset_est = [09:19:49.847] count_est = [09:19:49.847] limit_tuples = -1 [09:19:49.847] have_postponed_srfs = false [09:19:49.847] current_rel = 0x8364ad1b8 [09:19:49.847] final_target = 0x838d82c28 [09:19:49.847] final_targets_contain_srfs = [09:19:49.847] final_targets = [09:19:49.847] final_rel = [09:19:49.847] lc = [09:19:49.847] final_target_parallel_safe = [09:19:49.847] #6 0x00000000007a87b4 in subquery_planner (glob=glob@entry=0x838d7d3e0, parse=parse@entry=0x838d67d10, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [09:19:49.847] root = 0x8364acda8 [09:19:49.847] hasOuterJoins = false [09:19:49.847] hasResultRTEs = false [09:19:49.847] l = [09:19:49.847] newWithCheckOptions = [09:19:49.847] newHaving = 0x0 [09:19:49.847] final_rel = [09:19:49.847] #7 0x00000000007a72c8 in standard_planner (parse=0x838d67d10, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [09:19:49.847] glob = 0x838d7d3e0 [09:19:49.847] tuple_fraction = 0 [09:19:49.847] root = [09:19:49.847] final_rel = [09:19:49.847] best_path = [09:19:49.847] top_plan = [09:19:49.847] lp = [09:19:49.847] lr = [09:19:49.847] result = [09:19:49.847] #8 0x00000000007a719c in planner (parse=0x38d82df8, parse@entry=0x838d67d10, query_string=0x838d7f6e8 "\006", query_string@entry=0x8363cc100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=562405248, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [09:19:49.847] result = [09:19:49.847] #9 0x00000000008c9bd5 in pg_plan_query (querytree=querytree@entry=0x838d67d10, query_string=query_string@entry=0x8363cc100 "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 [09:19:49.847] plan = [09:19:49.847] #10 0x00000000008c9cb2 in pg_plan_queries (querytrees=0x838d7d390, query_string=query_string@entry=0x8363cc100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=562405248, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [09:19:49.847] query = 0x838d67d10 [09:19:49.847] stmt = [09:19:49.847] query_list__state = {l = 0x838d7d390, i = 0} [09:19:49.847] stmt_list = 0x0 [09:19:49.847] query_list = [09:19:49.847] #11 0x00000000008cde4c in exec_simple_query (query_string=query_string@entry=0x8363cc100 "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 [09:19:49.847] cmdtaglen = [09:19:49.847] snapshot_set = [09:19:49.847] per_parsetree_context = 0x0 [09:19:49.847] plantree_list = [09:19:49.847] qc = {commandTag = 336, nprocessed = 6} [09:19:49.847] parsetree = 0x836528600 [09:19:49.847] commandTag = [09:19:49.847] cmdtagname = [09:19:49.847] querytree_list = 0x0 [09:19:49.847] portal = [09:19:49.847] format = [09:19:49.847] receiver = [09:19:49.847] parsetree_item__state = {l = 0x8364a98f8, i = 0} [09:19:49.847] 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" [09:19:49.847] dest = DestRemote [09:19:49.847] was_logged = [09:19:49.847] oldcontext = 0x8363d8000 [09:19:49.847] parsetree_list = 0x8364a98f8 [09:19:49.847] use_implicit_block = false [09:19:49.847] parsetree_item = 0x8364a9910 [09:19:49.847] save_log_statement_stats = [09:19:49.847] #12 0x00000000008cbd24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [09:19:49.847] query_string = 0x8363cc100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [09:19:49.847] input_message = {data = 0x8363cc100 "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} [09:19:49.847] firstchar = [09:19:49.847] local_sigjmp_buf = {{_sjb = {9220592, 34922144768, 34922144728, 34922145328, 11873192, 11819680, 8192, 8388608, 72057628960031615, 0, 0, 34359738369}}} [09:19:49.847] send_ready_for_query = false [09:19:49.847] idle_in_transaction_timeout_enabled = false [09:19:49.847] idle_session_timeout_enabled = false [09:19:49.847] #13 0x000000000082b515 in BackendRun (port=port@entry=0x8364a7000) at ../src/backend/postmaster/postmaster.c:4475 [09:19:49.847] No locals. [09:19:49.847] #14 0x000000000082984d in BackendStartup (port=0x8364a7000) at ../src/backend/postmaster/postmaster.c:4151 [09:19:49.847] bn = 0x8363d8678 [09:19:49.847] pid = [09:19:49.847] __error = [09:19:49.847] __error = [09:19:49.847] __error = [09:19:49.847] save_errno = [09:19:49.847] __error = [09:19:49.847] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [09:19:49.847] port = 0x8364a7000 [09:19:49.847] i = 0 [09:19:49.847] now = [09:19:49.847] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 576193544, events = 8, fd = 576194568, user_data = 0x822580c08}, {pos = 576196616, events = 8, fd = 576197640, user_data = 0x822581808}, {pos = 576199688, events = 8, fd = 576200712, user_data = 0x822582408}, {pos = -1, events = 0, fd = 774009568, user_data = 0x82185a720}, {pos = 773669289, events = 8, fd = 0, user_data = 0x1000}, {pos = -1518899769, events = 3661151618, fd = 774010856, user_data = 0x835409be0}, {pos = 160, events = 0, fd = 0, user_data = 0x833248090}, {pos = 562407408, events = 8, fd = 773531948, user_data = 0x1000}, {pos = 772094308, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 576227896, events = 8, fd = 1, user_data = 0x822582408}, {pos = 772008152, events = 8, fd = 562407544, user_data = 0x82185a630}, {pos = 32, events = 18, fd = 772078692, user_data = 0x822582408}, {pos = 576227896, events = 8, fd = 0, user_data = 0xa41}, {pos = 562407520, events = 8, fd = 788862533, user_data = 0x82e053964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822588a38}, {pos = 1, events = 0, fd = 576201736, user_data = 0x8363bc000}, {pos = 1, events = 0, fd = 909885844, user_data = 0x0}, {pos = 562407472, events = 8, fd = 736472076, user_data = 0x1}, {pos = 909885440, events = 8, fd = 562407520, user_data = 0x82be59eb4}, {pos = 773820768, events = 8, fd = 773820768, user_data = 0x82e06b0c0}, {pos = 576201736, events = 8, fd = 562407744, user_data = 0x3dbe2f05142c}, {pos = 858030224, events = 8, fd = 1, user_data = 0x3dbe2f0512ae}, {pos = 12240, events = 0, fd = 562407528, user_data = 0x82185a940}, {pos = 910563304, events = 8, fd = 562409136, user_data = 0x3dbe2f064e90}, {pos = 576201736, events = 8, fd = 562365311, user_data = 0x82e1a559c}, {pos = 576172040, events = 8, fd = 0, user_data = 0x822582408}, {pos = 12240, events = 0, fd = 771944448, user_data = 0x1df950}, {pos = 773820768, events = 8, fd = 772078692, user_data = 0x3d00}, {pos = 562408928, events = 8, fd = 562407856, user_data = 0x82e0f418e }, {pos = 773859384, events = 8, fd = 562407796, user_data = 0x8364215da}, {pos = 562408928, events = 8, fd = 562407856, user_data = 0x82e10a605}, {pos = 562407794, events = 8, fd = 562408928, user_data = 0x82185ade0}, {pos = 0, events = 16777216, fd = -1518899769, user_data = 0x82185ade0}, {pos = 910300632, events = 8, fd = 562409136, user_data = 0x82e202838}, {pos = 0, events = 0, fd = 562408992, user_data = 0x82e10a70d}, {pos = 0, events = 0, fd = 0, user_data = 0x82185af50}, {pos = 910300632, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3dbe2f058409}, {pos = 562408200, events = 8, fd = 772078692, user_data = 0x9c7}, {pos = 788890633, events = 15806, fd = 562408232, user_data = 0x82e04fc64}, {pos = 2758, events = 0, fd = 772051232, user_data = 0x82185aaa8}, {pos = 576201736, events = 8, fd = 562408232, user_data = 0x82e049120}, {pos = 562408208, events = 8, fd = 788870245, user_data = 0x0}, {pos = 0, events = 0, fd = 773959920, user_data = 0x82e03f550}, {pos = 0, events = 0, fd = 0, user_data = 0x82e2099b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x82185ab98}, {pos = 576221320, events = 8, fd = 788890633, user_data = 0x82185abd8}, {pos = 772078692, events = 8, fd = 2924, user_data = 0x82e0493b8}, {pos = 562408280, events = 8, fd = 576201736, user_data = 0x82185abd8}, {pos = 772051896, events = 8, fd = 562408384, user_data = 0x3dbe2f053465}, {pos = 576225336, events = 8, fd = 1, user_data = 0x822582408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562408792, events = 0, fd = 2564492, user_data = 0x82185adc0}, {pos = 562408896, events = 8, fd = 562408824, user_data = 0x1e}, {pos = 772015328, events = 8, fd = 562408552, user_data = 0x822587248}, {pos = 562409000, events = 8, fd = 562408528, user_data = 0x3dbe2f057da3}, {pos = 576225336, events = 8, fd = 2690432, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 576225336, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82185af28}, {pos = 576201736, events = 8, fd = 562408880, user_data = 0x27218c}, {pos = 562409072, events = 8, fd = 562409072, user_data = 0x82185ae28}, {pos = 32, events = 0, fd = 562408656, user_data = 0x3dbe2f057b83}} [09:19:49.847] last_touch_time = 1709630090 [09:19:49.847] last_lockfile_recheck_time = 1709630090 [09:19:49.847] nevents = 1 [09:19:49.847] #16 0x0000000000826b53 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82185b5e8) at ../src/backend/postmaster/postmaster.c:1468 [09:19:49.847] userDoption = [09:19:49.847] listen_addr_saved = false [09:19:49.847] output_config_variable = [09:19:49.847] opt = [09:19:49.847] status = [09:19:49.847] #17 0x0000000000763d05 in main (argc=8, argv=0x82185b5e8) at ../src/backend/main/main.c:197 [09:19:49.847] do_check_root = [09:19:49.856] [09:19:49.856] [09:19:49.856] [09:19:49.917] dumping /tmp/cores/postgres.9035.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:19:50.049] [New LWP 100122] [09:19:50.122] Core was generated by `postgres: old_node: postgres regression [local] SELECT'. [09:19:50.122] Program terminated with signal SIGSEGV, Segmentation fault. [09:19:50.122] Address not mapped to object. [09:19:50.122] #0 equal (a=0x42fcc768, b=b@entry=0x842fc9168) at ../src/backend/nodes/equalfuncs.c:239 [09:19:50.122] 239 if (nodeTag(a) != nodeTag(b)) [09:19:50.145] [09:19:50.145] Thread 1 (LWP 100122): [09:19:50.145] #0 equal (a=0x42fcc768, b=b@entry=0x842fc9168) at ../src/backend/nodes/equalfuncs.c:239 [09:19:50.145] retval = [09:19:50.145] #1 0x0000000000767442 in list_member (list=0x842fcc7d8, datum=datum@entry=0x842fc9168) at ../src/backend/nodes/list.c:670 [09:19:50.145] cell__state = {l = 0x842fcc7d8, i = 0} [09:19:50.145] cell = 0x0 [09:19:50.145] cell__state = [09:19:50.145] #2 0x00000000007dae95 in add_new_column_to_pathtarget (target=0x842fcc6f8, expr=) at ../src/backend/optimizer/util/tlist.c:743 [09:19:50.145] No locals. [09:19:50.145] #3 add_new_columns_to_pathtarget (target=target@entry=0x842fcc6f8, exprs=0x842fcc908) at ../src/backend/optimizer/util/tlist.c:760 [09:19:50.145] expr = [09:19:50.145] lc__state = {l = 0x842fcc908, i = 0} [09:19:50.145] lc = 0xfffffe3b [09:19:50.145] #4 0x00000000007aa8a9 in make_group_input_target (root=0x842fa87a8, final_target=0x842fcc598) at ../src/backend/optimizer/plan/planner.c:5472 [09:19:50.145] parse = 0x842fb1490 [09:19:50.145] input_target = 0x842fcc6f8 [09:19:50.145] non_group_cols = 0x842fcc8b8 [09:19:50.145] i = [09:19:50.145] lc = [09:19:50.145] non_group_vars = 0x842fcc908 [09:19:50.145] #5 grouping_planner (root=root@entry=0x842fa87a8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [09:19:50.145] qp_extra = {activeWindows = 0x0, gset_data = 0x842fca5b8} [09:19:50.145] activeWindows = 0x0 [09:19:50.145] sort_input_target_parallel_safe = false [09:19:50.145] grouping_target = 0x842fcc598 [09:19:50.145] scanjoin_target = [09:19:50.145] sort_input_targets = [09:19:50.145] wflists = 0x0 [09:19:50.145] gset_data = 0x842fca5b8 [09:19:50.145] have_grouping = false [09:19:50.145] sort_input_targets_contain_srfs = [09:19:50.145] sort_input_target = 0x842fcc598 [09:19:50.145] grouping_target_parallel_safe = false [09:19:50.145] scanjoin_target_parallel_safe = [09:19:50.145] grouping_targets = [09:19:50.145] scanjoin_targets = [09:19:50.145] grouping_targets_contain_srfs = [09:19:50.145] scanjoin_targets_contain_srfs = [09:19:50.145] scanjoin_target_same_exprs = [09:19:50.145] extra = {limit_needed = 152, limit_tuples = 1.7531223035409932e-313, count_est = 72, offset_est = 34908897696} [09:19:50.145] parse = 0x842fb1490 [09:19:50.145] offset_est = [09:19:50.145] count_est = [09:19:50.145] limit_tuples = -1 [09:19:50.145] have_postponed_srfs = false [09:19:50.145] current_rel = 0x842fa8bb8 [09:19:50.145] final_target = 0x842fcc598 [09:19:50.145] final_targets_contain_srfs = [09:19:50.145] final_targets = [09:19:50.145] final_rel = [09:19:50.145] lc = [09:19:50.145] final_target_parallel_safe = [09:19:50.145] #6 0x00000000007a87b4 in subquery_planner (glob=glob@entry=0x842fc6e60, parse=parse@entry=0x842fb1490, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [09:19:50.145] root = 0x842fa87a8 [09:19:50.145] hasOuterJoins = false [09:19:50.145] hasResultRTEs = false [09:19:50.145] l = [09:19:50.145] newWithCheckOptions = [09:19:50.145] newHaving = 0x0 [09:19:50.145] final_rel = [09:19:50.145] #7 0x00000000007a72c8 in standard_planner (parse=0x842fb1490, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [09:19:50.145] glob = 0x842fc6e60 [09:19:50.145] tuple_fraction = 0 [09:19:50.145] root = [09:19:50.145] final_rel = [09:19:50.145] best_path = [09:19:50.145] top_plan = [09:19:50.145] lp = [09:19:50.145] lr = [09:19:50.145] result = [09:19:50.145] #8 0x00000000007a719c in planner (parse=0x42fcc768, parse@entry=0x842fb1490, query_string=0x842fc9168 "\006", query_string@entry=0x8354d0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=549159152, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [09:19:50.145] result = [09:19:50.145] #9 0x00000000008c9bd5 in pg_plan_query (querytree=querytree@entry=0x842fb1490, query_string=query_string@entry=0x8354d0100 "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 [09:19:50.145] plan = [09:19:50.145] #10 0x00000000008c9cb2 in pg_plan_queries (querytrees=0x842fc6e10, query_string=query_string@entry=0x8354d0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=549159152, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [09:19:50.145] query = 0x842fb1490 [09:19:50.145] stmt = [09:19:50.145] query_list__state = {l = 0x842fc6e10, i = 0} [09:19:50.145] stmt_list = 0x0 [09:19:50.145] query_list = [09:19:50.145] #11 0x00000000008cde4c in exec_simple_query (query_string=query_string@entry=0x8354d0100 "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 [09:19:50.145] cmdtaglen = [09:19:50.145] snapshot_set = [09:19:50.145] per_parsetree_context = 0x0 [09:19:50.145] plantree_list = [09:19:50.145] qc = {commandTag = 336, nprocessed = 6} [09:19:50.145] parsetree = 0x842f68600 [09:19:50.145] commandTag = [09:19:50.145] cmdtagname = [09:19:50.145] querytree_list = 0x0 [09:19:50.145] portal = [09:19:50.145] format = [09:19:50.145] receiver = [09:19:50.145] parsetree_item__state = {l = 0x842fa52f8, i = 0} [09:19:50.145] 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" [09:19:50.145] dest = DestRemote [09:19:50.145] was_logged = [09:19:50.145] oldcontext = 0x8354dc000 [09:19:50.145] parsetree_list = 0x842fa52f8 [09:19:50.145] use_implicit_block = false [09:19:50.145] parsetree_item = 0x842fa5310 [09:19:50.145] save_log_statement_stats = [09:19:50.145] #12 0x00000000008cbd24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [09:19:50.145] query_string = 0x8354d0100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [09:19:50.145] input_message = {data = 0x8354d0100 "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} [09:19:50.145] firstchar = [09:19:50.145] local_sigjmp_buf = {{_sjb = {9220592, 34908898672, 34908898632, 34908899232, 11873192, 11819680, 8192, 8388608, 72057628946793343, 0, 0, 34359738369}}} [09:19:50.145] send_ready_for_query = false [09:19:50.145] idle_in_transaction_timeout_enabled = false [09:19:50.145] idle_session_timeout_enabled = false [09:19:50.145] #13 0x000000000082b515 in BackendRun (port=port@entry=0x835583000) at ../src/backend/postmaster/postmaster.c:4475 [09:19:50.145] No locals. [09:19:50.145] #14 0x000000000082984d in BackendStartup (port=0x835583000) at ../src/backend/postmaster/postmaster.c:4151 [09:19:50.145] bn = 0x8354dc128 [09:19:50.145] pid = [09:19:50.145] __error = [09:19:50.145] __error = [09:19:50.145] __error = [09:19:50.145] save_errno = [09:19:50.145] __error = [09:19:50.145] #15 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [09:19:50.145] port = 0x835583000 [09:19:50.145] i = 0 [09:19:50.145] now = [09:19:50.145] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 560321544, events = 8, fd = 560322568, user_data = 0x82165dc08}, {pos = 560324616, events = 8, fd = 560325640, user_data = 0x82165e808}, {pos = 560327688, events = 8, fd = 560328712, user_data = 0x82165f408}, {pos = 560349320, events = 8, fd = 549161640, user_data = 0x820bb88d0}, {pos = 241778083, events = 10400, fd = 0, user_data = 0x272242}, {pos = 115249317, events = 0, fd = -25761258, user_data = 0x821665038}, {pos = 1, events = 0, fd = 560329736, user_data = 0x82a2fb4a8}, {pos = 549161896, events = 8, fd = 560329736, user_data = 0x20bb88c0}, {pos = 707877220, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 560355896, events = 8, fd = 1, user_data = 0x82165f408}, {pos = 707791064, events = 8, fd = 549161448, user_data = 0x820bb87a0}, {pos = 32, events = 18, fd = 707861604, user_data = 0x82165f408}, {pos = 560355896, events = 8, fd = 0, user_data = 0xa41}, {pos = 549161424, events = 8, fd = 241751621, user_data = 0x82a315964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821665a38}, {pos = 1, events = 0, fd = 560329736, user_data = 0x8354c0000}, {pos = 1, events = 0, fd = 894173588, user_data = 0x0}, {pos = 549161376, events = 8, fd = 686545932, user_data = 0x1}, {pos = 894173184, events = 8, fd = 549161424, user_data = 0x828ebceb4}, {pos = 709603680, events = 8, fd = 709603680, user_data = 0x82a32d0c0}, {pos = 560329736, events = 8, fd = 549161648, user_data = 0x28a00e68d42c}, {pos = 560328712, events = 8, fd = 1, user_data = 0x28a00e68d2ae}, {pos = 12240, events = 0, fd = 549161432, user_data = 0x820bb8ab0}, {pos = 894953448, events = 8, fd = 549163040, user_data = 0x28a00e6a0e90}, {pos = 560329736, events = 8, fd = 549127039, user_data = 0x82a4674b2}, {pos = 560300040, events = 8, fd = 0, user_data = 0x82165f408}, {pos = 12240, events = 0, fd = 707727360, user_data = 0x1df950}, {pos = 709603680, events = 8, fd = 707861604, user_data = 0x3d00}, {pos = 549162832, events = 8, fd = 549161760, user_data = 0x82a3b618e }, {pos = 709642296, events = 8, fd = 549161700, user_data = 0x83552e5da}, {pos = 549162832, events = 8, fd = 549161760, user_data = 0x82a3cc605}, {pos = 549161698, events = 8, fd = 549162832, user_data = 0x820bb8f50}, {pos = 0, events = 16777216, fd = 898072187, user_data = 0x820bb8f50}, {pos = 894625240, events = 8, fd = 549163040, user_data = 0x82a4c4838}, {pos = 0, events = 0, fd = 549162896, user_data = 0x82a3cc70d}, {pos = 0, events = 0, fd = 0, user_data = 0x820bb90c0}, {pos = 894625240, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x28a00e694409}, {pos = 549162104, events = 8, fd = 707861604, user_data = 0x9c7}, {pos = 241779721, events = 10400, fd = 549162136, user_data = 0x82a311c64}, {pos = 2758, events = 0, fd = 707834144, user_data = 0x820bb8c18}, {pos = 560329736, events = 8, fd = 549162136, user_data = 0x82a30b120}, {pos = 549162112, events = 8, fd = 241759333, user_data = 0x0}, {pos = 0, events = 0, fd = 709742832, user_data = 0x82a301550}, {pos = 0, events = 0, fd = 0, user_data = 0x82a4cb9b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x820bb8d08}, {pos = 560349320, events = 8, fd = 241779721, user_data = 0x820bb8d48}, {pos = 707861604, events = 8, fd = 2924, user_data = 0x82a30b3b8}, {pos = 549162184, events = 8, fd = 560329736, user_data = 0x820bb8d48}, {pos = 707834808, events = 8, fd = 549162288, user_data = 0x28a00e68f465}, {pos = 560353336, events = 8, fd = 1, user_data = 0x82165f408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 549162696, events = 0, fd = 2564492, user_data = 0x820bb8f30}, {pos = 549162800, events = 8, fd = 549162728, user_data = 0x1e}, {pos = 707798240, events = 8, fd = 549162456, user_data = 0x821664248}, {pos = 549162904, events = 8, fd = 549162432, user_data = 0x28a00e693da3}, {pos = 560353336, events = 8, fd = 2690432, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 560353336, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820bb9098}, {pos = 560329736, events = 8, fd = 549162784, user_data = 0x27218c}, {pos = 549162976, events = 8, fd = 549162976, user_data = 0x820bb8f98}, {pos = 32, events = 0, fd = 549162560, user_data = 0x28a00e693b83}} [09:19:50.145] last_touch_time = 1709630092 [09:19:50.145] last_lockfile_recheck_time = 1709630092 [09:19:50.145] nevents = 1 [09:19:50.145] #16 0x0000000000826b53 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820bb9758) at ../src/backend/postmaster/postmaster.c:1468 [09:19:50.145] userDoption = [09:19:50.145] listen_addr_saved = false [09:19:50.145] output_config_variable = [09:19:50.145] opt = [09:19:50.145] status = [09:19:50.145] #17 0x0000000000763d05 in main (argc=4, argv=0x820bb9758) at ../src/backend/main/main.c:197 [09:19:50.145] do_check_root = [09:19:50.154] [09:19:50.154] [09:19:50.154] [09:19:50.216] dumping /tmp/cores/postgres.10010.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:19:50.349] [New LWP 101788] [09:19:50.422] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [09:19:50.422] Program terminated with signal SIGSEGV, Segmentation fault. [09:19:50.422] Address not mapped to object. [09:19:50.422] #0 equal (a=0x3647ccb0, b=b@entry=0x8363e6678) at ../src/backend/nodes/equalfuncs.c:239 [09:19:50.422] 239 if (nodeTag(a) != nodeTag(b)) [09:19:50.988] [09:19:50.988] Thread 1 (LWP 101788): [09:19:50.988] #0 equal (a=0x3647ccb0, b=b@entry=0x8363e6678) at ../src/backend/nodes/equalfuncs.c:239 [09:19:50.988] retval = [09:19:50.988] #1 0x0000000000767442 in list_member (list=0x83647cd20, datum=datum@entry=0x8363e6678) at ../src/backend/nodes/list.c:670 [09:19:50.988] cell__state = {l = 0x83647cd20, i = 0} [09:19:50.988] cell = 0x0 [09:19:50.988] cell__state = [09:19:50.988] #2 0x00000000007dae95 in add_new_column_to_pathtarget (target=0x83647cc40, expr=) at ../src/backend/optimizer/util/tlist.c:743 [09:19:50.988] No locals. [09:19:50.988] #3 add_new_columns_to_pathtarget (target=target@entry=0x83647cc40, exprs=0x83647cdd8) at ../src/backend/optimizer/util/tlist.c:760 [09:19:50.988] expr = [09:19:50.988] lc__state = {l = 0x83647cdd8, i = 0} [09:19:50.988] lc = 0xfffffe3b [09:19:50.988] #4 0x00000000007aa8a9 in make_group_input_target (root=0x8363e6038, final_target=0x83647cb70) at ../src/backend/optimizer/plan/planner.c:5472 [09:19:50.988] parse = 0x838553688 [09:19:50.988] input_target = 0x83647cc40 [09:19:50.988] non_group_cols = 0x83647cd88 [09:19:50.988] i = [09:19:50.988] lc = [09:19:50.988] non_group_vars = 0x83647cdd8 [09:19:50.988] #5 grouping_planner (root=root@entry=0x8363e6038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [09:19:50.988] qp_extra = {activeWindows = 0x0, gset_data = 0x8363e6718} [09:19:50.988] activeWindows = 0x0 [09:19:50.988] sort_input_target_parallel_safe = false [09:19:50.988] grouping_target = 0x83647cb70 [09:19:50.988] scanjoin_target = [09:19:50.988] sort_input_targets = [09:19:50.988] wflists = 0x0 [09:19:50.988] gset_data = 0x8363e6718 [09:19:50.988] have_grouping = false [09:19:50.988] sort_input_targets_contain_srfs = [09:19:50.988] sort_input_target = 0x83647cb70 [09:19:50.988] grouping_target_parallel_safe = false [09:19:50.988] scanjoin_target_parallel_safe = [09:19:50.988] grouping_targets = [09:19:50.988] scanjoin_targets = [09:19:50.988] grouping_targets_contain_srfs = [09:19:50.988] scanjoin_targets_contain_srfs = [09:19:50.988] scanjoin_target_same_exprs = [09:19:50.988] extra = {limit_needed = 16, limit_tuples = 1.7425595159975465e-313, count_est = 0, offset_est = 34922142832} [09:19:50.988] parse = 0x838553688 [09:19:50.988] offset_est = [09:19:50.988] count_est = [09:19:50.988] limit_tuples = -1 [09:19:50.988] have_postponed_srfs = false [09:19:50.988] current_rel = 0x8363e54c8 [09:19:50.988] final_target = 0x83647cb70 [09:19:50.988] final_targets_contain_srfs = [09:19:50.988] final_targets = [09:19:50.988] final_rel = [09:19:50.988] lc = [09:19:50.988] final_target_parallel_safe = [09:19:50.988] #6 0x00000000007a87b4 in subquery_planner (glob=glob@entry=0x836461ef8, parse=parse@entry=0x838553688, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=1.7442419071490076e-313) at ../src/backend/optimizer/plan/planner.c:1084 [09:19:50.988] root = 0x8363e6038 [09:19:50.988] hasOuterJoins = false [09:19:50.988] hasResultRTEs = false [09:19:50.988] l = [09:19:50.988] newWithCheckOptions = [09:19:50.988] newHaving = 0x0 [09:19:50.988] final_rel = [09:19:50.988] #7 0x00000000007a72c8 in standard_planner (parse=0x838553688, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [09:19:50.988] glob = 0x836461ef8 [09:19:50.988] tuple_fraction = 0 [09:19:50.988] root = [09:19:50.988] final_rel = [09:19:50.988] best_path = [09:19:50.988] top_plan = [09:19:50.988] lp = [09:19:50.988] lr = [09:19:50.988] result = [09:19:50.988] #8 0x00000000007a719c in planner (parse=0x3647ccb0, parse@entry=0x838553688, query_string=0x8363e6678 "\006", query_string@entry=0x8363cc100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=562404272, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [09:19:50.988] result = [09:19:50.988] #9 0x00000000008c9bd5 in pg_plan_query (querytree=querytree@entry=0x838553688, query_string=query_string@entry=0x8363cc100 "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 [09:19:50.988] plan = [09:19:50.988] #10 0x000000000067e2e3 in ExplainOneQuery (query=0x838553688, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x836567748, queryString=0x8363cc100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", params=0xfffffe3b, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:428 [09:19:50.988] bufusage = {shared_blks_hit = 179, shared_blks_read = 745796210, shared_blks_dirtied = 34922143744, shared_blks_written = 35304845136, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 35304010768, temp_blks_written = 10764739, shared_blk_read_time = {ticks = 35304848984}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35304846984}, local_blk_write_time = {ticks = 35304846984}, temp_blk_read_time = {ticks = 34922143776}, temp_blk_write_time = {ticks = 10799744}} [09:19:50.988] saved_ctx = 0x0 [09:19:50.988] planstart = {ticks = -179745796210} [09:19:50.988] planduration = {ticks = 7759472} [09:19:50.988] bufusage_start = {shared_blks_hit = 34922143759, shared_blks_read = 0, shared_blks_dirtied = 35304847256, shared_blks_written = 35304847912, local_blks_hit = 34922143584, local_blks_read = 10551649, local_blks_dirtied = 70368744218554, local_blks_written = 0, temp_blks_read = 34922143616, temp_blks_written = 5627946, shared_blk_read_time = {ticks = 70368744218554}, shared_blk_write_time = {ticks = 1}, local_blk_read_time = {ticks = 34922143632}, local_blk_write_time = {ticks = 6176265}, temp_blk_read_time = {ticks = 34922143808}, temp_blk_write_time = {ticks = 8881819}} [09:19:50.988] mem_counters = {nblocks = 34922143552, freechunks = 9106453, totalspace = 34922143552, freespace = 35304010768} [09:19:50.988] planner_ctx = [09:19:50.988] plan = [09:19:50.988] #11 0x000000000067de02 in ExplainQuery (pstate=pstate@entry=0x836567638, stmt=stmt@entry=0x838553658, params=0x83647b000, params@entry=0x0, dest=0x8365675a8) at ../src/backend/commands/explain.c:293 [09:19:50.988] l__state = {l = , i = 0} [09:19:50.988] l = 0x836461cb0 [09:19:50.988] es = 0x836567748 [09:19:50.988] jstate = [09:19:50.988] timing_set = false [09:19:50.988] summary_set = false [09:19:50.988] lc = [09:19:50.988] query = [09:19:50.988] rewritten = 0x836461c98 [09:19:50.988] tstate = [09:19:50.988] #12 0x00000000008d0cdf in standard_ProcessUtility (pstmt=0x8385542d0, queryString=0x8363cc100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x821859bb0, queryEnv=0x0, dest=0x8365675a8, qc=0x82185a1f8) at ../src/backend/tcop/utility.c:863 [09:19:50.988] isAtomicContext = true [09:19:50.988] parsetree = 0x838553658 [09:19:50.988] readonly_flags = [09:19:50.988] pstate = 0x836567638 [09:19:50.988] isTopLevel = [09:19:50.988] #13 0x00000000008d060d in ProcessUtility (pstmt=0x3647ccb0, pstmt@entry=0x8385542d0, queryString=0x8363e6678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x83647b000, dest=0x8365675a8, qc=0x82185a1f8) at ../src/backend/tcop/utility.c:523 [09:19:50.988] No locals. [09:19:50.988] #14 0x00000000008d0133 in PortalRunUtility (portal=portal@entry=0x8364a1100, pstmt=0x8385542d0, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x8365675a8, qc=qc@entry=0x82185a1f8) at ../src/backend/tcop/pquery.c:1158 [09:19:50.988] No locals. [09:19:50.988] #15 0x00000000008cf32a in FillPortalStore (portal=portal@entry=0x8364a1100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [09:19:50.988] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:19:50.988] treceiver = 0x8365675a8 [09:19:50.988] #16 0x00000000008cf030 in PortalRun (portal=portal@entry=0x8364a1100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x838554430, altdest=altdest@entry=0x838554430, qc=0x82185a330) at ../src/backend/tcop/pquery.c:763 [09:19:50.988] _local_sigjmp_buf = {{_sjb = {9236431, 35270632624, 34922144296, 34922144528, 34922144304, 11864456, 11832240, 35270562048, -6347183290297547905, 35270570240, 3552407, 34359738368}}} [09:19:50.988] _save_exception_stack = 0x82185a400 [09:19:50.988] _save_context_stack = 0x0 [09:19:50.988] _do_rethrow = false [09:19:50.988] saveTopTransactionResourceOwner = 0x8364b24b0 [09:19:50.988] saveTopTransactionContext = 0x8384a5000 [09:19:50.988] saveActivePortal = 0x0 [09:19:50.988] saveResourceOwner = 0x8364b24b0 [09:19:50.988] savePortalContext = 0x0 [09:19:50.988] saveMemoryContext = 0x8384a5000 [09:19:50.988] result = [09:19:50.988] nprocessed = [09:19:50.988] #17 0x00000000008cdf3b in exec_simple_query (query_string=query_string@entry=0x8363cc100 "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 [09:19:50.988] cmdtaglen = [09:19:50.988] snapshot_set = [09:19:50.988] per_parsetree_context = 0x0 [09:19:50.988] plantree_list = [09:19:50.988] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:19:50.988] parsetree = 0x836495c58 [09:19:50.988] commandTag = CMDTAG_EXPLAIN [09:19:50.988] cmdtagname = [09:19:50.988] querytree_list = [09:19:50.988] portal = 0x8364a1100 [09:19:50.988] format = 0 [09:19:50.988] receiver = 0x838554430 [09:19:50.988] parsetree_item__state = {l = 0x8364964e0, i = 0} [09:19:50.988] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [09:19:50.988] dest = DestRemote [09:19:50.988] was_logged = [09:19:50.988] oldcontext = 0x8384a5000 [09:19:50.988] parsetree_list = 0x8364964e0 [09:19:50.988] use_implicit_block = false [09:19:50.988] parsetree_item = 0x8364964f8 [09:19:50.988] save_log_statement_stats = [09:19:50.988] #18 0x00000000008cbd24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [09:19:50.988] query_string = 0x8363cc100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [09:19:50.988] input_message = {data = 0x8363cc100 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [09:19:50.988] firstchar = [09:19:50.988] local_sigjmp_buf = {{_sjb = {9220592, 34922144768, 34922144728, 34922145328, 11873192, 11819680, 8192, 8388608, 72057628960031615, 0, 0, 34359738369}}} [09:19:50.988] send_ready_for_query = false [09:19:50.988] idle_in_transaction_timeout_enabled = false [09:19:50.988] idle_session_timeout_enabled = false [09:19:50.988] #19 0x000000000082b515 in BackendRun (port=port@entry=0x8364a7000) at ../src/backend/postmaster/postmaster.c:4475 [09:19:50.988] No locals. [09:19:50.988] #20 0x000000000082984d in BackendStartup (port=0x8364a7000) at ../src/backend/postmaster/postmaster.c:4151 [09:19:50.988] bn = 0x8363d81c8 [09:19:50.988] pid = [09:19:50.988] __error = [09:19:50.988] __error = [09:19:50.988] __error = [09:19:50.988] save_errno = [09:19:50.988] __error = [09:19:50.988] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [09:19:50.988] port = 0x8364a7000 [09:19:50.988] i = 0 [09:19:50.988] now = [09:19:50.988] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 576194568, user_data = 0x0}, {pos = 576196616, events = 8, fd = 576197640, user_data = 0x822581808}, {pos = 576199688, events = 8, fd = 576200712, user_data = 0x822582408}, {pos = -1, events = 0, fd = 774009568, user_data = 0x82185a720}, {pos = 773669289, events = 8, fd = 0, user_data = 0x1000}, {pos = -1518899769, events = 3661151618, fd = 774010856, user_data = 0x835409be0}, {pos = 160, events = 0, fd = 0, user_data = 0x833248090}, {pos = 562407408, events = 8, fd = 773531948, user_data = 0x1000}, {pos = 772094308, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 576227896, events = 8, fd = 1, user_data = 0x822582408}, {pos = 772008152, events = 8, fd = 562407544, user_data = 0x82185a630}, {pos = 32, events = 18, fd = 772078692, user_data = 0x822582408}, {pos = 576227896, events = 8, fd = 0, user_data = 0xa41}, {pos = 562407520, events = 8, fd = 788862533, user_data = 0x82e053964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x822588a38}, {pos = 1, events = 0, fd = 576201736, user_data = 0x8363bc000}, {pos = 1, events = 0, fd = 909885844, user_data = 0x0}, {pos = 562407472, events = 8, fd = 736472076, user_data = 0x1}, {pos = 909885440, events = 8, fd = 562407520, user_data = 0x82be59eb4}, {pos = 773820768, events = 8, fd = 773820768, user_data = 0x82e06b0c0}, {pos = 576201736, events = 8, fd = 562407744, user_data = 0x3dbe2f05142c}, {pos = 858030224, events = 8, fd = 1, user_data = 0x3dbe2f0512ae}, {pos = 12240, events = 0, fd = 562407528, user_data = 0x82185a940}, {pos = 910563304, events = 8, fd = 562409136, user_data = 0x3dbe2f064e90}, {pos = 576201736, events = 8, fd = 562365311, user_data = 0x82e1a559c}, {pos = 576172040, events = 8, fd = 0, user_data = 0x822582408}, {pos = 12240, events = 0, fd = 771944448, user_data = 0x1df950}, {pos = 773820768, events = 8, fd = 772078692, user_data = 0x3d00}, {pos = 562408928, events = 8, fd = 562407856, user_data = 0x82e0f418e }, {pos = 773859384, events = 8, fd = 562407796, user_data = 0x8364215da}, {pos = 562408928, events = 8, fd = 562407856, user_data = 0x82e10a605}, {pos = 562407794, events = 8, fd = 562408928, user_data = 0x82185ade0}, {pos = 0, events = 16777216, fd = -1518899769, user_data = 0x82185ade0}, {pos = 910300632, events = 8, fd = 562409136, user_data = 0x82e202838}, {pos = 0, events = 0, fd = 562408992, user_data = 0x82e10a70d}, {pos = 0, events = 0, fd = 0, user_data = 0x82185af50}, {pos = 910300632, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3dbe2f058409}, {pos = 562408200, events = 8, fd = 772078692, user_data = 0x9c7}, {pos = 788890633, events = 15806, fd = 562408232, user_data = 0x82e04fc64}, {pos = 2758, events = 0, fd = 772051232, user_data = 0x82185aaa8}, {pos = 576201736, events = 8, fd = 562408232, user_data = 0x82e049120}, {pos = 562408208, events = 8, fd = 788870245, user_data = 0x0}, {pos = 0, events = 0, fd = 773959920, user_data = 0x82e03f550}, {pos = 0, events = 0, fd = 0, user_data = 0x82e2099b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x82185ab98}, {pos = 576221320, events = 8, fd = 788890633, user_data = 0x82185abd8}, {pos = 772078692, events = 8, fd = 2924, user_data = 0x82e0493b8}, {pos = 562408280, events = 8, fd = 576201736, user_data = 0x82185abd8}, {pos = 772051896, events = 8, fd = 562408384, user_data = 0x3dbe2f053465}, {pos = 576225336, events = 8, fd = 1, user_data = 0x822582408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562408792, events = 0, fd = 2564492, user_data = 0x82185adc0}, {pos = 562408896, events = 8, fd = 562408824, user_data = 0x1e}, {pos = 772015328, events = 8, fd = 562408552, user_data = 0x822587248}, {pos = 562409000, events = 8, fd = 562408528, user_data = 0x3dbe2f057da3}, {pos = 576225336, events = 8, fd = 2690432, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 576225336, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x82185af28}, {pos = 576201736, events = 8, fd = 562408880, user_data = 0x27218c}, {pos = 562409072, events = 8, fd = 562409072, user_data = 0x82185ae28}, {pos = 32, events = 0, fd = 562408656, user_data = 0x3dbe2f057b83}} [09:19:50.988] last_touch_time = 1709630090 [09:19:50.988] last_lockfile_recheck_time = 1709630090 [09:19:50.988] nevents = 1 [09:19:50.988] #22 0x0000000000826b53 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82185b5e8) at ../src/backend/postmaster/postmaster.c:1468 [09:19:50.988] userDoption = [09:19:50.988] listen_addr_saved = false [09:19:50.988] output_config_variable = [09:19:50.988] opt = [09:19:50.988] status = [09:19:50.988] #23 0x0000000000763d05 in main (argc=8, argv=0x82185b5e8) at ../src/backend/main/main.c:197 [09:19:50.988] do_check_root = [09:19:50.999] [09:19:50.999] [09:19:50.999] [09:19:51.061] dumping /tmp/cores/postgres.15803.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:19:51.187] [New LWP 101803] [09:19:51.274] Core was generated by `postgres: primary: postgres regression [local] SELECT'. [09:19:51.274] Program terminated with signal SIGSEGV, Segmentation fault. [09:19:51.274] Address not mapped to object. [09:19:51.274] #0 equal (a=0x3872b3c8, b=b@entry=0x838727cb8) at ../src/backend/nodes/equalfuncs.c:239 [09:19:51.274] 239 if (nodeTag(a) != nodeTag(b)) [09:19:51.332] [09:19:51.332] Thread 1 (LWP 101803): [09:19:51.332] #0 equal (a=0x3872b3c8, b=b@entry=0x838727cb8) at ../src/backend/nodes/equalfuncs.c:239 [09:19:51.332] retval = [09:19:51.332] #1 0x0000000000767442 in list_member (list=0x83872b438, datum=datum@entry=0x838727cb8) at ../src/backend/nodes/list.c:670 [09:19:51.332] cell__state = {l = 0x83872b438, i = 0} [09:19:51.332] cell = 0x0 [09:19:51.332] cell__state = [09:19:51.332] #2 0x00000000007dae95 in add_new_column_to_pathtarget (target=0x83872b358, expr=) at ../src/backend/optimizer/util/tlist.c:743 [09:19:51.332] No locals. [09:19:51.332] #3 add_new_columns_to_pathtarget (target=target@entry=0x83872b358, exprs=0x83872b568) at ../src/backend/optimizer/util/tlist.c:760 [09:19:51.332] expr = [09:19:51.332] lc__state = {l = 0x83872b568, i = 0} [09:19:51.332] lc = 0xfffffe3b [09:19:51.332] #4 0x00000000007aa8a9 in make_group_input_target (root=0x8335d09e0, final_target=0x83872b1f8) at ../src/backend/optimizer/plan/planner.c:5472 [09:19:51.332] parse = 0x838722f48 [09:19:51.332] input_target = 0x83872b358 [09:19:51.332] non_group_cols = 0x83872b518 [09:19:51.332] i = [09:19:51.332] lc = [09:19:51.332] non_group_vars = 0x83872b568 [09:19:51.332] #5 grouping_planner (root=root@entry=0x8335d09e0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [09:19:51.332] qp_extra = {activeWindows = 0x0, gset_data = 0x838729108} [09:19:51.332] activeWindows = 0x0 [09:19:51.332] sort_input_target_parallel_safe = false [09:19:51.332] grouping_target = 0x83872b1f8 [09:19:51.332] scanjoin_target = [09:19:51.332] sort_input_targets = [09:19:51.332] wflists = 0x0 [09:19:51.332] gset_data = 0x838729108 [09:19:51.332] have_grouping = false [09:19:51.332] sort_input_targets_contain_srfs = [09:19:51.332] sort_input_target = 0x83872b1f8 [09:19:51.332] grouping_target_parallel_safe = false [09:19:51.332] scanjoin_target_parallel_safe = [09:19:51.332] grouping_targets = [09:19:51.332] scanjoin_targets = [09:19:51.332] grouping_targets_contain_srfs = [09:19:51.332] scanjoin_targets_contain_srfs = [09:19:51.332] scanjoin_target_same_exprs = [09:19:51.332] extra = {limit_needed = 232, limit_tuples = 1.7443861644362803e-313, count_est = 72, offset_est = 34916738288} [09:19:51.332] parse = 0x838722f48 [09:19:51.332] offset_est = [09:19:51.332] count_est = [09:19:51.332] limit_tuples = -1 [09:19:51.332] have_postponed_srfs = false [09:19:51.332] current_rel = 0x838704e48 [09:19:51.332] final_target = 0x83872b1f8 [09:19:51.332] final_targets_contain_srfs = [09:19:51.332] final_targets = [09:19:51.332] final_rel = [09:19:51.332] lc = [09:19:51.332] final_target_parallel_safe = [09:19:51.332] #6 0x00000000007a87b4 in subquery_planner (glob=glob@entry=0x8387255a0, parse=parse@entry=0x838722f48, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [09:19:51.332] root = 0x8335d09e0 [09:19:51.332] hasOuterJoins = false [09:19:51.332] hasResultRTEs = false [09:19:51.332] l = [09:19:51.332] newWithCheckOptions = [09:19:51.332] newHaving = 0x0 [09:19:51.332] final_rel = [09:19:51.332] #7 0x00000000007a72c8 in standard_planner (parse=0x838722f48, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [09:19:51.332] glob = 0x8387255a0 [09:19:51.332] tuple_fraction = 0 [09:19:51.332] root = [09:19:51.332] final_rel = [09:19:51.332] best_path = [09:19:51.332] top_plan = [09:19:51.332] lp = [09:19:51.332] lr = [09:19:51.332] result = [09:19:51.332] #8 0x0000000835d126af in pgss_planner (parse=0x838722f48, query_string=0x838727cb8 "\006", cursorOptions=556999744, boundParams=0xfffffe3b) at ../contrib/pg_stat_statements/pg_stat_statements.c:972 [09:19:51.332] _local_sigjmp_buf = {{_sjb = {35262637405, 11864456, 34916738872, 34916739328, 34916738912, 0, 35306745672, 34916739728, 35306734463, 35305855152, 34916739024, 0}}} [09:19:51.332] _save_exception_stack = 0x821332a90 [09:19:51.332] _save_context_stack = 0x0 [09:19:51.332] _do_rethrow = false [09:19:51.332] result = [09:19:51.332] #9 0x00000000007a7195 in planner (parse=0x3872b3c8, parse@entry=0x838722f48, query_string=0x838727cb8 "\006", query_string@entry=0x833496100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=556999744, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [09:19:51.332] result = [09:19:51.332] #10 0x00000000008c9bd5 in pg_plan_query (querytree=querytree@entry=0x838722f48, query_string=query_string@entry=0x833496100 "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 [09:19:51.332] plan = [09:19:51.332] #11 0x00000000008c9cb2 in pg_plan_queries (querytrees=0x838725550, query_string=query_string@entry=0x833496100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=556999744, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [09:19:51.332] query = 0x838722f48 [09:19:51.332] stmt = [09:19:51.332] query_list__state = {l = 0x838725550, i = 0} [09:19:51.332] stmt_list = 0x0 [09:19:51.332] query_list = [09:19:51.332] #12 0x00000000008cde4c in exec_simple_query (query_string=query_string@entry=0x833496100 "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 [09:19:51.332] cmdtaglen = [09:19:51.332] snapshot_set = [09:19:51.332] per_parsetree_context = 0x0 [09:19:51.332] plantree_list = [09:19:51.332] qc = {commandTag = 336, nprocessed = 6} [09:19:51.332] parsetree = 0x8335d1600 [09:19:51.332] commandTag = [09:19:51.332] cmdtagname = [09:19:51.332] querytree_list = 0x0 [09:19:51.332] portal = [09:19:51.332] format = [09:19:51.332] receiver = [09:19:51.332] parsetree_item__state = {l = 0x838704a78, i = 0} [09:19:51.332] 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" [09:19:51.332] dest = DestRemote [09:19:51.332] was_logged = [09:19:51.332] oldcontext = 0x8334a2000 [09:19:51.332] parsetree_list = 0x838704a78 [09:19:51.332] use_implicit_block = false [09:19:51.332] parsetree_item = 0x838704a90 [09:19:51.332] save_log_statement_stats = [09:19:51.332] #13 0x00000000008cbd24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [09:19:51.332] query_string = 0x833496100 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [09:19:51.332] input_message = {data = 0x833496100 "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} [09:19:51.332] firstchar = [09:19:51.332] local_sigjmp_buf = {{_sjb = {9220592, 34916739728, 34916739688, 34916740288, 11873192, 11819680, 8192, 8388608, 72057628954657663, 0, 0, 1}}} [09:19:51.332] send_ready_for_query = false [09:19:51.332] idle_in_transaction_timeout_enabled = false [09:19:51.332] idle_session_timeout_enabled = false [09:19:51.332] #14 0x000000000082b515 in BackendRun (port=port@entry=0x833573000) at ../src/backend/postmaster/postmaster.c:4475 [09:19:51.332] No locals. [09:19:51.332] #15 0x000000000082984d in BackendStartup (port=0x833573000) at ../src/backend/postmaster/postmaster.c:4151 [09:19:51.332] bn = 0x8334a2448 [09:19:51.332] pid = [09:19:51.332] __error = [09:19:51.332] __error = [09:19:51.332] __error = [09:19:51.332] save_errno = [09:19:51.332] __error = [09:19:51.332] #16 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [09:19:51.332] port = 0x833573000 [09:19:51.332] i = 0 [09:19:51.332] now = [09:19:51.332] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 557235208, events = 8, fd = 557236232, user_data = 0x82136c408}, {pos = 557238280, events = 8, fd = 557239304, user_data = 0x82136d008}, {pos = 557241352, events = 8, fd = 557260936, user_data = 0x821332fc8}, {pos = 557002208, events = 8, fd = -131060317, user_data = 0x82136d408}, {pos = 2564674, events = 0, fd = 115249317, user_data = 0xfe76ea16}, {pos = 557264952, events = 8, fd = 1, user_data = 0x82136d408}, {pos = 725062824, events = 8, fd = 557002952, user_data = 0x82136d408}, {pos = 557002176, events = 0, fd = 2564492, user_data = 0x821333010}, {pos = 725170532, events = 8, fd = 128686702, user_data = 0x1c93dacf}, {pos = 557267512, events = 8, fd = 1, user_data = 0x82136d408}, {pos = 725084376, events = 8, fd = 557002504, user_data = 0x821332cb0}, {pos = 33, events = 18, fd = 725154916, user_data = 0x82136d408}, {pos = 557267512, events = 8, fd = 0, user_data = 0xa41}, {pos = 557002480, events = 8, fd = -131086779, user_data = 0x82b393964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821373a38}, {pos = 1, events = 0, fd = 557241352, user_data = 0x833486000}, {pos = 1, events = 0, fd = 860381588, user_data = 0x0}, {pos = 557002432, events = 8, fd = 711748620, user_data = 0x1}, {pos = 860381184, events = 8, fd = 557002480, user_data = 0x82a6c5eb4}, {pos = 726896992, events = 8, fd = 726896992, user_data = 0x82b3ab0c0}, {pos = 557241352, events = 8, fd = 557002704, user_data = 0x27f9f82fc42c}, {pos = 80627796, events = 0, fd = 1, user_data = 0x27f9f82fc2ae}, {pos = 12240, events = 0, fd = 557002488, user_data = 0x821332fd0}, {pos = 861177832, events = 8, fd = 557004096, user_data = 0x27f9f830fe90}, {pos = 557241352, events = 8, fd = 556991359, user_data = 0x82b4e54b2}, {pos = 557003008, events = 8, fd = 0, user_data = 0x82136d408}, {pos = 12240, events = 0, fd = 725020672, user_data = 0x1df950}, {pos = 726896992, events = 8, fd = 725154916, user_data = 0x3d00}, {pos = 557003888, events = 8, fd = 557002816, user_data = 0x82b43418e }, {pos = 726935608, events = 8, fd = 557002756, user_data = 0x8334ed5da}, {pos = 557003888, events = 8, fd = 557002816, user_data = 0x82b44a605}, {pos = 557002754, events = 8, fd = 557003888, user_data = 0x821333470}, {pos = 0, events = 16777216, fd = -102641797, user_data = 0x821333470}, {pos = 860804568, events = 8, fd = 557004096, user_data = 0x82b542838}, {pos = 0, events = 0, fd = 557003952, user_data = 0x82b44a70d}, {pos = 0, events = 0, fd = 0, user_data = 0x8213335e0}, {pos = 860804568, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -131058679, events = 10233, fd = 557003144, user_data = 0x82b38fc64}, {pos = 2503, events = 0, fd = -131058679, user_data = 0x8213331a8}, {pos = 725154916, events = 8, fd = 2758, user_data = 0x82b389120}, {pos = 557003048, events = 8, fd = 557241352, user_data = 0x8213331a8}, {pos = 725127456, events = 8, fd = 557003152, user_data = 0x27f9f82fe465}, {pos = 0, events = 0, fd = 0, user_data = 0x821333180}, {pos = 725087568, events = 8, fd = 0, user_data = 0x0}, {pos = 557003104, events = 8, fd = 16, user_data = 0x0}, {pos = 557003288, events = 8, fd = 557260936, user_data = 0x27f9f8303409}, {pos = 557003352, events = 8, fd = 725154916, user_data = 0xb6c}, {pos = 725128120, events = 8, fd = 557003224, user_data = 0x82136d408}, {pos = 557003352, events = 8, fd = 725128120, user_data = 0x821333240}, {pos = -131079067, events = 10233, fd = 557264952, user_data = 0x800000001}, {pos = 557241352, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 557003752, user_data = 0x27218c}, {pos = 557003856, events = 8, fd = 557003856, user_data = 0x821333408}, {pos = 31, events = 0, fd = 0, user_data = 0x8213332e8}, {pos = 557262728, events = 8, fd = 557003960, user_data = 0x8213332d0}, {pos = -131060317, events = 10233, fd = 557264952, user_data = 0x290d80}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821373038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 557004216, events = 8, fd = 0, user_data = 0x321333440}, {pos = 557262824, events = 8, fd = 557004032, user_data = 0x290}, {pos = 557003960, events = 8, fd = 557003496, user_data = 0x821333350}, {pos = -131060691, events = 10233, fd = 557230088, user_data = 0x0}} [09:19:51.332] last_touch_time = 1709630156 [09:19:51.332] last_lockfile_recheck_time = 1709630156 [09:19:51.332] nevents = 1 [09:19:51.332] #17 0x0000000000826b53 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821333c70) at ../src/backend/postmaster/postmaster.c:1468 [09:19:51.332] userDoption = [09:19:51.332] listen_addr_saved = false [09:19:51.332] output_config_variable = [09:19:51.332] opt = [09:19:51.332] status = [09:19:51.332] #18 0x0000000000763d05 in main (argc=4, argv=0x821333c70) at ../src/backend/main/main.c:197 [09:19:51.332] do_check_root = [09:19:51.342] [09:19:51.342] [09:19:51.342] [09:19:51.407] dumping /tmp/cores/postgres.18790.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:19:51.547] [New LWP 100114] [09:19:51.633] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT'. [09:19:51.633] Program terminated with signal SIGSEGV, Segmentation fault. [09:19:51.633] Address not mapped to object. [09:19:51.633] #0 get_expr_width (root=root@entry=0x8466a9840, expr=expr@entry=0x46760d70) at ../src/backend/optimizer/path/costsize.c:6328 [09:19:51.633] 6328 if (IsA(expr, Var)) [09:19:51.659] [09:19:51.659] Thread 1 (LWP 100114): [09:19:51.659] #0 get_expr_width (root=root@entry=0x8466a9840, expr=expr@entry=0x46760d70) at ../src/backend/optimizer/path/costsize.c:6328 [09:19:51.659] width = [09:19:51.659] #1 0x0000000000782225 in set_pathtarget_cost_width (root=root@entry=0x8466a9840, target=target@entry=0x846760d00) at ../src/backend/optimizer/path/costsize.c:6299 [09:19:51.659] node = 0x46760d70 [09:19:51.659] lc__state = {l = 0x846760de0, i = 0} [09:19:51.659] tuple_width = 0 [09:19:51.659] lc = 0x846760df8 [09:19:51.659] #2 0x00000000007aa8c4 in make_group_input_target (root=0x8466a9840, final_target=0x846760c40) at ../src/backend/optimizer/plan/planner.c:5479 [09:19:51.659] parse = 0x8466acc70 [09:19:51.659] input_target = 0x846760d00 [09:19:51.659] non_group_cols = 0x0 [09:19:51.659] i = [09:19:51.659] lc = [09:19:51.659] non_group_vars = 0x0 [09:19:51.659] #3 grouping_planner (root=root@entry=0x8466a9840, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [09:19:51.659] qp_extra = {activeWindows = 0x0, gset_data = 0x84675d8f8} [09:19:51.659] activeWindows = 0x0 [09:19:51.659] sort_input_target_parallel_safe = false [09:19:51.659] grouping_target = 0x846760c40 [09:19:51.659] scanjoin_target = [09:19:51.659] sort_input_targets = [09:19:51.659] wflists = 0x0 [09:19:51.659] gset_data = 0x84675d8f8 [09:19:51.659] have_grouping = false [09:19:51.659] sort_input_targets_contain_srfs = [09:19:51.659] sort_input_target = 0x846760c40 [09:19:51.659] grouping_target_parallel_safe = false [09:19:51.659] scanjoin_target_parallel_safe = [09:19:51.659] grouping_targets = [09:19:51.659] scanjoin_targets = [09:19:51.659] grouping_targets_contain_srfs = [09:19:51.659] scanjoin_targets_contain_srfs = [09:19:51.659] scanjoin_target_same_exprs = [09:19:51.659] extra = {limit_needed = 16, limit_tuples = 1.7249454547816024e-313, count_est = 16, offset_est = 34913284720} [09:19:51.659] parse = 0x8466acc70 [09:19:51.659] offset_est = [09:19:51.659] count_est = [09:19:51.659] limit_tuples = -1 [09:19:51.659] have_postponed_srfs = false [09:19:51.659] current_rel = 0x84675f230 [09:19:51.659] final_target = 0x846760c40 [09:19:51.659] final_targets_contain_srfs = [09:19:51.659] final_targets = [09:19:51.659] final_rel = [09:19:51.659] lc = [09:19:51.659] final_target_parallel_safe = [09:19:51.659] #4 0x00000000007a87b4 in subquery_planner (glob=glob@entry=0x8466ae598, parse=parse@entry=0x8466acc70, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [09:19:51.659] root = 0x8466a9840 [09:19:51.659] hasOuterJoins = false [09:19:51.659] hasResultRTEs = false [09:19:51.659] l = [09:19:51.659] newWithCheckOptions = [09:19:51.659] newHaving = 0x0 [09:19:51.659] final_rel = [09:19:51.659] #5 0x00000000007a72c8 in standard_planner (parse=0x8466acc70, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [09:19:51.659] glob = 0x8466ae598 [09:19:51.659] tuple_fraction = 0 [09:19:51.659] root = [09:19:51.659] final_rel = [09:19:51.659] best_path = [09:19:51.659] top_plan = [09:19:51.659] lp = [09:19:51.659] lr = [09:19:51.659] result = [09:19:51.659] #6 0x000000083a7e5712 in pgss_planner (parse=0x8466acc70, query_string=0x83750a100 "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=0x846760df8) at ../contrib/pg_stat_statements/pg_stat_statements.c:926 [09:19:51.659] _local_sigjmp_buf = {{_sjb = {35341096559, 35287769344, 34913285304, 34913285760, 11864456, 35541142640, 34913285472, 0, 34913256319, 11051221, 2, 34359738368}}} [09:19:51.659] _save_exception_stack = 0x820fe7810 [09:19:51.659] _save_context_stack = 0x0 [09:19:51.659] _do_rethrow = false [09:19:51.659] bufusage = {shared_blks_hit = 35341096559, shared_blks_read = 35287769344, shared_blks_dirtied = 34913285304, shared_blks_written = 34913285760, local_blks_hit = 11864456, local_blks_read = 35541142640, local_blks_dirtied = 34913285472, local_blks_written = 0, temp_blks_read = 34913256319, temp_blks_written = 11051221, shared_blk_read_time = {ticks = 2}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 34913285616}, local_blk_write_time = {ticks = 11080223}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 35541148824}} [09:19:51.659] walusage_start = {wal_records = 1346, wal_fpi = 2, wal_bytes = 170389} [09:19:51.659] duration = [09:19:51.659] bufusage_start = {shared_blks_hit = 27805, shared_blks_read = 4, shared_blks_dirtied = 19, shared_blks_written = 19, 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}} [09:19:51.659] walusage = {wal_records = 35541142640, wal_fpi = 35541940216, wal_bytes = 34913285680} [09:19:51.659] start = [09:19:51.659] result = [09:19:51.659] #7 0x00000000007a7195 in planner (parse=0x8466a9840, parse@entry=0x8466acc70, query_string=0x46760d70 , query_string@entry=0x83750a100 "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=0x846760df8, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [09:19:51.659] result = [09:19:51.659] #8 0x00000000008c9bd5 in pg_plan_query (querytree=querytree@entry=0x8466acc70, query_string=query_string@entry=0x83750a100 "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 [09:19:51.659] plan = [09:19:51.659] #9 0x00000000008c9cb2 in pg_plan_queries (querytrees=0x8466ae548, query_string=query_string@entry=0x83750a100 "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=0x846760df8, boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [09:19:51.659] query = 0x8466acc70 [09:19:51.659] stmt = [09:19:51.659] query_list__state = {l = 0x8466ae548, i = 0} [09:19:51.659] stmt_list = 0x0 [09:19:51.659] query_list = [09:19:51.659] #10 0x00000000008cde4c in exec_simple_query (query_string=query_string@entry=0x83750a100 "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 [09:19:51.659] cmdtaglen = [09:19:51.659] snapshot_set = [09:19:51.659] per_parsetree_context = 0x0 [09:19:51.659] plantree_list = [09:19:51.659] qc = {commandTag = 336, nprocessed = 6} [09:19:51.659] parsetree = 0x84671ccb0 [09:19:51.659] commandTag = [09:19:51.659] cmdtagname = [09:19:51.659] querytree_list = 0x0 [09:19:51.659] portal = [09:19:51.659] format = [09:19:51.659] receiver = [09:19:51.659] parsetree_item__state = {l = 0x84676f7a8, i = 0} [09:19:51.659] 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" [09:19:51.659] dest = DestRemote [09:19:51.659] was_logged = [09:19:51.659] oldcontext = 0x837516000 [09:19:51.659] parsetree_list = 0x84676f7a8 [09:19:51.659] use_implicit_block = false [09:19:51.659] parsetree_item = 0x84676f7c0 [09:19:51.659] save_log_statement_stats = [09:19:51.659] #11 0x00000000008cbd24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [09:19:51.659] query_string = 0x83750a100 "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;" [09:19:51.659] input_message = {data = 0x83750a100 "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} [09:19:51.659] firstchar = [09:19:51.659] local_sigjmp_buf = {{_sjb = {9220592, 34913286160, 34913286120, 34913286720, 11873192, 11819680, 8192, 8388608, 72057628951184255, 0, 0, 34359738369}}} [09:19:51.659] send_ready_for_query = false [09:19:51.659] idle_in_transaction_timeout_enabled = false [09:19:51.659] idle_session_timeout_enabled = false [09:19:51.659] #12 0x000000000082b515 in BackendRun (port=port@entry=0x8375e0000) at ../src/backend/postmaster/postmaster.c:4475 [09:19:51.659] No locals. [09:19:51.659] #13 0x000000000082984d in BackendStartup (port=0x8375e0000) at ../src/backend/postmaster/postmaster.c:4151 [09:19:51.659] bn = 0x837516238 [09:19:51.659] pid = [09:19:51.659] __error = [09:19:51.659] __error = [09:19:51.659] __error = [09:19:51.659] save_errno = [09:19:51.659] __error = [09:19:51.659] #14 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [09:19:51.659] port = 0x8375e0000 [09:19:51.659] i = 0 [09:19:51.659] now = [09:19:51.659] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 568687624, events = 8, fd = 568688648, user_data = 0x821e58408}, {pos = 568690696, events = 8, fd = 568691720, user_data = 0x821e59008}, {pos = 568693768, events = 8, fd = 920689632, user_data = 0xa0}, {pos = -1, events = 0, fd = 749101792, user_data = 0x820fe7b30}, {pos = 748761513, events = 8, fd = 0, user_data = 0x1000}, {pos = 667471209, events = 1148973705, fd = 749103080, user_data = 0x836e09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x834cf1090}, {pos = 553548800, events = 8, fd = 748624172, user_data = 0x1000}, {pos = 747186532, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 568719928, events = 8, fd = 1, user_data = 0x821e59408}, {pos = 747100376, events = 8, fd = 553548936, user_data = 0x820fe7a30}, {pos = 33, events = 18, fd = 747170916, user_data = 0x821e59408}, {pos = 568719928, events = 8, fd = 0, user_data = 0xa41}, {pos = 553548912, events = 8, fd = 265287237, user_data = 0x82c892964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821e5fa38}, {pos = 1, events = 0, fd = 568693768, user_data = 0x8374fa000}, {pos = 1, events = 0, fd = 927965588, user_data = 0x0}, {pos = 553548864, events = 8, fd = 731487244, user_data = 0x1}, {pos = 927965184, events = 8, fd = 553548912, user_data = 0x82b998eb4}, {pos = 748912992, events = 8, fd = 748912992, user_data = 0x82c8aa0c0}, {pos = 568693768, events = 8, fd = 553549136, user_data = 0xf8d0fcff42c}, {pos = 885985424, events = 8, fd = 1, user_data = 0xf8d0fcff2ae}, {pos = 12240, events = 0, fd = 553548920, user_data = 0x820fe7d50}, {pos = 928622568, events = 8, fd = 553550528, user_data = 0xf8d0fd12e90}, {pos = 568693768, events = 8, fd = 553517951, user_data = 0x82c9e459c}, {pos = 553549440, events = 8, fd = 0, user_data = 0x821e59408}, {pos = 12240, events = 0, fd = 747036672, user_data = 0x1df950}, {pos = 748912992, events = 8, fd = 747170916, user_data = 0x3d00}, {pos = 553550320, events = 8, fd = 553549248, user_data = 0x82c93318e }, {pos = 748951608, events = 8, fd = 553549188, user_data = 0x83755a5da}, {pos = 553550320, events = 8, fd = 553549248, user_data = 0x82c949605}, {pos = 553549186, events = 8, fd = 553550320, user_data = 0x820fe81f0}, {pos = 0, events = 16777216, fd = 667471209, user_data = 0x820fe81f0}, {pos = 928359896, events = 8, fd = 553550528, user_data = 0x82ca41838}, {pos = 0, events = 0, fd = 553550384, user_data = 0x82c94970d}, {pos = 0, events = 0, fd = 0, user_data = 0x820fe8360}, {pos = 928359896, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 265315337, events = 3981, fd = 553549576, user_data = 0x82c88ec64}, {pos = 2503, events = 0, fd = 265315337, user_data = 0x820fe7f28}, {pos = 747170916, events = 8, fd = 2758, user_data = 0x82c888120}, {pos = 553549480, events = 8, fd = 568693768, user_data = 0x820fe7f28}, {pos = 747143456, events = 8, fd = 553549584, user_data = 0xf8d0fd01465}, {pos = 0, events = 0, fd = 0, user_data = 0x820fe7f00}, {pos = 747103568, events = 8, fd = 0, user_data = 0x0}, {pos = 553549536, events = 8, fd = 16, user_data = 0x0}, {pos = 553549720, events = 8, fd = 568713352, user_data = 0xf8d0fd06409}, {pos = 553549784, events = 8, fd = 747170916, user_data = 0xb6c}, {pos = 747144120, events = 8, fd = 553549656, user_data = 0x821e59408}, {pos = 553549784, events = 8, fd = 747144120, user_data = 0x820fe7fc0}, {pos = 265294949, events = 3981, fd = 568717368, user_data = 0x800000001}, {pos = 568693768, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 8, fd = 553550184, user_data = 0x27218c}, {pos = 553550288, events = 8, fd = 553550288, user_data = 0x820fe8188}, {pos = 31, events = 0, fd = 0, user_data = 0x820fe8068}, {pos = 568715144, events = 8, fd = 553550392, user_data = 0x820fe8050}, {pos = 265313699, events = 3981, fd = 568717368, user_data = 0x290d80}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821e5f038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 553550648, events = 8, fd = 0, user_data = 0x320fe81c0}, {pos = 568715240, events = 8, fd = 553550464, user_data = 0x290}, {pos = 553550392, events = 8, fd = 553549928, user_data = 0x820fe80d0}, {pos = 265313325, events = 3981, fd = 568682504, user_data = 0x0}} [09:19:51.659] last_touch_time = 1709630193 [09:19:51.659] last_lockfile_recheck_time = 1709630193 [09:19:51.659] nevents = 1 [09:19:51.659] #15 0x0000000000826b53 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x820fe89f0) at ../src/backend/postmaster/postmaster.c:1468 [09:19:51.659] userDoption = [09:19:51.659] listen_addr_saved = false [09:19:51.659] output_config_variable = [09:19:51.659] opt = [09:19:51.659] status = [09:19:51.659] #16 0x0000000000763d05 in main (argc=8, argv=0x820fe89f0) at ../src/backend/main/main.c:197 [09:19:51.659] do_check_root = [09:19:51.668] [09:19:51.668] [09:19:51.668] [09:19:51.737] dumping /tmp/cores/postgres.18967.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:19:51.872] [New LWP 100173] [09:19:51.959] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN'. [09:19:51.959] Program terminated with signal SIGSEGV, Segmentation fault. [09:19:51.959] Address not mapped to object. [09:19:51.959] #0 equal (a=0x349f10d8, b=b@entry=0x834995678) at ../src/backend/nodes/equalfuncs.c:239 [09:19:51.959] 239 if (nodeTag(a) != nodeTag(b)) [09:19:52.503] [09:19:52.503] Thread 1 (LWP 100173): [09:19:52.503] #0 equal (a=0x349f10d8, b=b@entry=0x834995678) at ../src/backend/nodes/equalfuncs.c:239 [09:19:52.503] retval = [09:19:52.503] #1 0x0000000000767442 in list_member (list=0x8349f1148, datum=datum@entry=0x834995678) at ../src/backend/nodes/list.c:670 [09:19:52.503] cell__state = {l = 0x8349f1148, i = 0} [09:19:52.503] cell = 0x0 [09:19:52.503] cell__state = [09:19:52.503] #2 0x00000000007dae95 in add_new_column_to_pathtarget (target=0x8349f1088, expr=) at ../src/backend/optimizer/util/tlist.c:743 [09:19:52.503] No locals. [09:19:52.503] #3 add_new_columns_to_pathtarget (target=target@entry=0x8349f1088, exprs=0x8349f11e8) at ../src/backend/optimizer/util/tlist.c:760 [09:19:52.503] expr = [09:19:52.503] lc__state = {l = 0x8349f11e8, i = 0} [09:19:52.503] lc = 0xfffffe3b [09:19:52.503] #4 0x00000000007aa8a9 in make_group_input_target (root=0x834995038, final_target=0x842ef5fa8) at ../src/backend/optimizer/plan/planner.c:5472 [09:19:52.503] parse = 0x842f30820 [09:19:52.503] input_target = 0x8349f1088 [09:19:52.503] non_group_cols = 0x8349f1198 [09:19:52.503] i = [09:19:52.503] lc = [09:19:52.503] non_group_vars = 0x8349f11e8 [09:19:52.503] #5 grouping_planner (root=root@entry=0x834995038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [09:19:52.503] qp_extra = {activeWindows = 0x0, gset_data = 0x8349958a8} [09:19:52.503] activeWindows = 0x0 [09:19:52.503] sort_input_target_parallel_safe = false [09:19:52.503] grouping_target = 0x842ef5fa8 [09:19:52.503] scanjoin_target = [09:19:52.503] sort_input_targets = [09:19:52.503] wflists = 0x0 [09:19:52.503] gset_data = 0x8349958a8 [09:19:52.503] have_grouping = false [09:19:52.503] sort_input_targets_contain_srfs = [09:19:52.503] sort_input_target = 0x842ef5fa8 [09:19:52.503] grouping_target_parallel_safe = false [09:19:52.503] scanjoin_target_parallel_safe = [09:19:52.503] grouping_targets = [09:19:52.503] scanjoin_targets = [09:19:52.503] grouping_targets_contain_srfs = [09:19:52.503] scanjoin_targets_contain_srfs = [09:19:52.503] scanjoin_target_same_exprs = [09:19:52.503] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 34921968672} [09:19:52.503] parse = 0x842f30820 [09:19:52.503] offset_est = [09:19:52.503] count_est = [09:19:52.503] limit_tuples = -1 [09:19:52.503] have_postponed_srfs = false [09:19:52.503] current_rel = 0x8349d5dd8 [09:19:52.503] final_target = 0x842ef5fa8 [09:19:52.503] final_targets_contain_srfs = [09:19:52.503] final_targets = [09:19:52.503] final_rel = [09:19:52.503] lc = [09:19:52.503] final_target_parallel_safe = [09:19:52.503] #6 0x00000000007a87b4 in subquery_planner (glob=glob@entry=0x8349d5998, parse=parse@entry=0x842f30820, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=0) at ../src/backend/optimizer/plan/planner.c:1084 [09:19:52.503] root = 0x834995038 [09:19:52.503] hasOuterJoins = false [09:19:52.503] hasResultRTEs = false [09:19:52.503] l = [09:19:52.503] newWithCheckOptions = [09:19:52.503] newHaving = 0x0 [09:19:52.503] final_rel = [09:19:52.503] #7 0x00000000007a72c8 in standard_planner (parse=0x842f30820, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:412 [09:19:52.503] glob = 0x8349d5998 [09:19:52.503] tuple_fraction = 0 [09:19:52.503] root = [09:19:52.503] final_rel = [09:19:52.503] best_path = [09:19:52.503] top_plan = [09:19:52.503] lp = [09:19:52.503] lr = [09:19:52.503] result = [09:19:52.503] #8 0x00000000007a719c in planner (parse=0x349f10d8, parse@entry=0x842f30820, query_string=0x834995678 "\006", query_string@entry=0x834939100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=562230112, cursorOptions@entry=2048, boundParams=0xfffffe3b, boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [09:19:52.503] result = [09:19:52.503] #9 0x00000000008c9bd5 in pg_plan_query (querytree=querytree@entry=0x842f30820, query_string=query_string@entry=0x834939100 "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 [09:19:52.503] plan = [09:19:52.503] #10 0x000000000067e2e3 in ExplainOneQuery (query=0x842f30820, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x834947748, queryString=0x834939100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", params=0xfffffe3b, params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:428 [09:19:52.503] bufusage = {shared_blks_hit = 263, shared_blks_read = 235689088, shared_blks_dirtied = 34921969584, shared_blks_written = 35482960777, local_blks_hit = 0, local_blks_read = 549755813893, local_blks_dirtied = 5374873834369509787, local_blks_written = 34921969612, temp_blks_read = -1, temp_blks_written = 10764739, shared_blk_read_time = {ticks = 35482964688}, shared_blk_write_time = {ticks = 1024}, local_blk_read_time = {ticks = 35482961952}, local_blk_write_time = {ticks = 35482961952}, temp_blk_read_time = {ticks = 34921969616}, temp_blk_write_time = {ticks = 10799744}} [09:19:52.503] saved_ctx = 0x0 [09:19:52.503] planstart = {ticks = -263235689088} [09:19:52.503] planduration = {ticks = 7759472} [09:19:52.503] bufusage_start = {shared_blks_hit = 1, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 34921969424, local_blks_read = 10551649, local_blks_dirtied = 70368744194107, local_blks_written = 0, temp_blks_read = 34921969456, temp_blks_written = 5627946, shared_blk_read_time = {ticks = 70368744194107}, shared_blk_write_time = {ticks = 35482961952}, local_blk_read_time = {ticks = 34921969472}, local_blk_write_time = {ticks = 6176265}, temp_blk_read_time = {ticks = 34921969648}, temp_blk_write_time = {ticks = 8881637}} [09:19:52.503] mem_counters = {nblocks = 34921969392, freechunks = 9106453, totalspace = 34921969392, freespace = 35540130344} [09:19:52.503] planner_ctx = [09:19:52.503] plan = [09:19:52.503] #11 0x000000000067de02 in ExplainQuery (pstate=pstate@entry=0x834947638, stmt=stmt@entry=0x842f307f0, params=0x8349f1000, params@entry=0x0, dest=0x8349475a8) at ../src/backend/commands/explain.c:293 [09:19:52.503] l__state = {l = , i = 0} [09:19:52.503] l = 0x8349d54b0 [09:19:52.503] es = 0x834947748 [09:19:52.503] jstate = [09:19:52.503] timing_set = false [09:19:52.503] summary_set = false [09:19:52.503] lc = [09:19:52.503] query = [09:19:52.503] rewritten = 0x8349d5498 [09:19:52.503] tstate = [09:19:52.503] #12 0x00000000008d0cdf in standard_ProcessUtility (pstmt=0x834aed068, queryString=0x834939100 "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=0x82182f360, queryEnv=0x0, dest=0x8349475a8, qc=0x82182f9a8) at ../src/backend/tcop/utility.c:863 [09:19:52.503] isAtomicContext = true [09:19:52.503] parsetree = 0x842f307f0 [09:19:52.503] readonly_flags = [09:19:52.503] pstate = 0x834947638 [09:19:52.503] isTopLevel = [09:19:52.503] #13 0x00000000008d060d in ProcessUtility (pstmt=0x349f10d8, pstmt@entry=0x834aed068, queryString=0x834995678 "\006", readOnlyTree=, context=4294966843, params=0x3, queryEnv=0x8349f1000, dest=0x8349475a8, qc=0x82182f9a8) at ../src/backend/tcop/utility.c:523 [09:19:52.503] No locals. [09:19:52.503] #14 0x00000000008d0133 in PortalRunUtility (portal=portal@entry=0x834a0e100, pstmt=0x834aed068, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x8349475a8, qc=qc@entry=0x82182f9a8) at ../src/backend/tcop/pquery.c:1158 [09:19:52.503] No locals. [09:19:52.503] #15 0x00000000008cf32a in FillPortalStore (portal=portal@entry=0x834a0e100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1031 [09:19:52.503] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:19:52.503] treceiver = 0x8349475a8 [09:19:52.503] #16 0x00000000008cf030 in PortalRun (portal=portal@entry=0x834a0e100, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x834aed1c8, altdest=altdest@entry=0x834aed1c8, qc=0x82182fae0) at ../src/backend/tcop/pquery.c:763 [09:19:52.503] _local_sigjmp_buf = {{_sjb = {9236431, 35242748032, 34921970136, 34921970368, 34921970144, 11864456, 11832240, 35242696960, -6347183290297744513, 35242705152, 3552407, 34359738368}}} [09:19:52.503] _save_exception_stack = 0x82182fbb0 [09:19:52.503] _save_context_stack = 0x0 [09:19:52.503] _do_rethrow = false [09:19:52.503] saveTopTransactionResourceOwner = 0x834a1a880 [09:19:52.503] saveTopTransactionContext = 0x834945000 [09:19:52.503] saveActivePortal = 0x0 [09:19:52.503] saveResourceOwner = 0x834a1a880 [09:19:52.503] savePortalContext = 0x0 [09:19:52.503] saveMemoryContext = 0x834945000 [09:19:52.503] result = [09:19:52.503] nprocessed = [09:19:52.503] #17 0x00000000008cdf3b in exec_simple_query (query_string=query_string@entry=0x834939100 "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 [09:19:52.503] cmdtaglen = [09:19:52.503] snapshot_set = [09:19:52.503] per_parsetree_context = 0x0 [09:19:52.503] plantree_list = [09:19:52.503] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:19:52.503] parsetree = 0x834a8de60 [09:19:52.503] commandTag = CMDTAG_EXPLAIN [09:19:52.503] cmdtagname = [09:19:52.503] querytree_list = [09:19:52.503] portal = 0x834a0e100 [09:19:52.503] format = 0 [09:19:52.503] receiver = 0x834aed1c8 [09:19:52.503] parsetree_item__state = {l = 0x834a8e9b0, i = 0} [09:19:52.503] msec_str = '\000' , "\006\000\000\000\000\000\000\000\004\000\000\000\000\000\000" [09:19:52.503] dest = DestRemote [09:19:52.503] was_logged = [09:19:52.503] oldcontext = 0x834945000 [09:19:52.503] parsetree_list = 0x834a8e9b0 [09:19:52.503] use_implicit_block = false [09:19:52.503] parsetree_item = 0x834a8e9c8 [09:19:52.503] save_log_statement_stats = [09:19:52.503] #18 0x00000000008cbd24 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4671 [09:19:52.503] query_string = 0x834939100 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [09:19:52.503] input_message = {data = 0x834939100 "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} [09:19:52.503] firstchar = [09:19:52.503] local_sigjmp_buf = {{_sjb = {9220592, 34921970608, 34921970568, 34921971168, 11873192, 11819680, 8192, 8388608, 72057628959835007, 0, 0, 34359738369}}} [09:19:52.503] send_ready_for_query = false [09:19:52.503] idle_in_transaction_timeout_enabled = false [09:19:52.503] idle_session_timeout_enabled = false [09:19:52.503] #19 0x000000000082b515 in BackendRun (port=port@entry=0x834a14000) at ../src/backend/postmaster/postmaster.c:4475 [09:19:52.503] No locals. [09:19:52.503] #20 0x000000000082984d in BackendStartup (port=0x834a14000) at ../src/backend/postmaster/postmaster.c:4151 [09:19:52.503] bn = 0x834945128 [09:19:52.503] pid = [09:19:52.503] __error = [09:19:52.503] __error = [09:19:52.503] __error = [09:19:52.503] save_errno = [09:19:52.503] __error = [09:19:52.503] #21 ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [09:19:52.503] port = 0x834a14000 [09:19:52.503] i = 0 [09:19:52.503] now = [09:19:52.503] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 568710152, events = 8, fd = 568711176, user_data = 0x821e5dc08}, {pos = 568713224, events = 8, fd = 568714248, user_data = 0x821e5e808}, {pos = 568716296, events = 8, fd = 568717320, user_data = 0x821e5f408}, {pos = -1, events = 0, fd = 743277280, user_data = 0x82182fed0}, {pos = 742937001, events = 8, fd = 0, user_data = 0x1000}, {pos = 1780672923, events = 1251435334, fd = 743278568, user_data = 0x833c09be0}, {pos = 160, events = 0, fd = 0, user_data = 0x83213a090}, {pos = 562233248, events = 8, fd = 742799660, user_data = 0x1000}, {pos = 741362020, events = 8, fd = 128686702, user_data = 0x81c93dacf}, {pos = 568744504, events = 8, fd = 1, user_data = 0x821e5f408}, {pos = 741275864, events = 8, fd = 562233384, user_data = 0x82182fde0}, {pos = 32, events = 18, fd = 741346404, user_data = 0x821e5f408}, {pos = 568744504, events = 8, fd = 0, user_data = 0xa41}, {pos = 562233360, events = 8, fd = -1841387963, user_data = 0x82c304964}, {pos = 128686702, events = 0, fd = 479451855, user_data = 0x821e65a38}, {pos = 1, events = 0, fd = 568718344, user_data = 0x834929000}, {pos = 1, events = 0, fd = 882020756, user_data = 0x0}, {pos = 562233312, events = 8, fd = 717909004, user_data = 0x1}, {pos = 882020352, events = 8, fd = 562233360, user_data = 0x82aca5eb4}, {pos = 743088480, events = 8, fd = 743088480, user_data = 0x82c31c0c0}, {pos = 568718344, events = 8, fd = 562233584, user_data = 0x1a24923ea42c}, {pos = 840147088, events = 8, fd = 1, user_data = 0x1a24923ea2ae}, {pos = 12240, events = 0, fd = 562233368, user_data = 0x8218300f0}, {pos = 882698216, events = 8, fd = 562234976, user_data = 0x1a24923fde90}, {pos = 568718344, events = 8, fd = 562234239, user_data = 0x82c45659c}, {pos = 568688648, events = 8, fd = 0, user_data = 0x821e5f408}, {pos = 12240, events = 0, fd = 741212160, user_data = 0x1df950}, {pos = 743088480, events = 8, fd = 741346404, user_data = 0x3d00}, {pos = 562234768, events = 8, fd = 562233696, user_data = 0x82c3a518e }, {pos = 743127096, events = 8, fd = 562233636, user_data = 0x83498e5da}, {pos = 562234768, events = 8, fd = 562233696, user_data = 0x82c3bb605}, {pos = 562233634, events = 8, fd = 562234768, user_data = 0x821830590}, {pos = 0, events = 16777216, fd = 1780672923, user_data = 0x821830590}, {pos = 882435544, events = 8, fd = 562234976, user_data = 0x82c4b3838}, {pos = 0, events = 0, fd = 562234832, user_data = 0x82c3bb70d}, {pos = 0, events = 0, fd = 0, user_data = 0x821830700}, {pos = 882435544, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1a24923f1409}, {pos = 562234040, events = 8, fd = 741346404, user_data = 0x9c7}, {pos = -1841359863, events = 6692, fd = 562234072, user_data = 0x82c300c64}, {pos = 2758, events = 0, fd = 741318944, user_data = 0x821830258}, {pos = 568718344, events = 8, fd = 562234072, user_data = 0x82c2fa120}, {pos = 562234048, events = 8, fd = -1841380251, user_data = 0x0}, {pos = 0, events = 0, fd = 743227632, user_data = 0x82c2f0550}, {pos = 0, events = 0, fd = 0, user_data = 0x82c4ba9b0 <__thr_jtable>}, {pos = 16, events = 0, fd = 0, user_data = 0x821830348}, {pos = 568737928, events = 8, fd = -1841359863, user_data = 0x821830388}, {pos = 741346404, events = 8, fd = 2924, user_data = 0x82c2fa3b8}, {pos = 562234120, events = 8, fd = 568718344, user_data = 0x821830388}, {pos = 741319608, events = 8, fd = 562234224, user_data = 0x1a24923ec465}, {pos = 568741944, events = 8, fd = 1, user_data = 0x821e5f408}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 562234632, events = 0, fd = 2564492, user_data = 0x821830570}, {pos = 562234736, events = 8, fd = 562234664, user_data = 0x1e}, {pos = 741283040, events = 8, fd = 562234392, user_data = 0x821e64248}, {pos = 562234840, events = 8, fd = 562234368, user_data = 0x1a24923f0da3}, {pos = 568741944, events = 8, fd = 2690432, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 568741944, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x8218306d8}, {pos = 568718344, events = 8, fd = 562234720, user_data = 0x27218c}, {pos = 562234912, events = 8, fd = 562234912, user_data = 0x8218305d8}, {pos = 32, events = 0, fd = 562234496, user_data = 0x1a24923f0b83}} [09:19:52.503] last_touch_time = 1709630194 [09:19:52.503] last_lockfile_recheck_time = 1709630194 [09:19:52.503] nevents = 1 [09:19:52.503] #22 0x0000000000826b53 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821830d90) at ../src/backend/postmaster/postmaster.c:1468 [09:19:52.503] userDoption = [09:19:52.503] listen_addr_saved = false [09:19:52.503] output_config_variable = [09:19:52.503] opt = [09:19:52.503] status = [09:19:52.503] #23 0x0000000000763d05 in main (argc=8, argv=0x821830d90) at ../src/backend/main/main.c:197 [09:19:52.503] do_check_root =