[23:10:58.912] src/tools/ci/cores_backtrace.sh linux /tmp/cores [23:10:59.628] dumping /tmp/cores/postgres-11-30510.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:11:01.304] [New LWP 30510] [23:11:01.304] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [23:11:02.067] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [23:11:02.831] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [23:11:04.062] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [23:11:06.460] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [23:11:06.460] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [23:11:08.339] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [23:11:09.569] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [23:11:11.158] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [23:11:12.222] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [23:11:12.984] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [23:11:14.214] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [23:11:15.837] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [23:11:17.260] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [23:11:18.186] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [23:11:19.754] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [23:11:21.149] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [23:11:21.625] [Thread debugging using libthread_db enabled] [23:11:21.625] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:11:22.721] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [23:11:24.147] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [23:11:25.227] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [23:11:25.852] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [23:11:26.618] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [23:11:28.903] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [23:11:29.824] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [23:11:30.608] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [23:11:31.545] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [23:11:32.472] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [23:11:34.084] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [23:11:35.176] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [23:11:35.943] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [23:11:37.341] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [23:11:37.970] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [23:11:39.540] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [23:11:40.303] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [23:11:41.525] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [23:11:42.293] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [23:11:43.357] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [23:11:44.279] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [23:11:45.504] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [23:11:46.121] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [23:11:47.042] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [23:11:47.816] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [23:11:48.312] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [23:11:48.312] Program terminated with signal SIGSEGV, Segmentation fault. [23:11:48.312] #0 0x000055e094428fe6 in equal (a=0xffffffff96571180, b=b@entry=0x55e0965a2688) at ../src/backend/nodes/equalfuncs.c:239 [23:11:48.312] 239 if (nodeTag(a) != nodeTag(b)) [23:11:48.555] [23:11:48.555] Thread 1 (Thread 0x7fe49826fa40 (LWP 30510)): [23:11:48.555] #0 0x000055e094428fe6 in equal (a=0xffffffff96571180, b=b@entry=0x55e0965a2688) at ../src/backend/nodes/equalfuncs.c:239 [23:11:48.555] retval = [23:11:48.555] __func__ = "equal" [23:11:48.555] #1 0x000055e093d60b29 in list_member (list=0x55e0965711f0, datum=datum@entry=0x55e0965a2688) at ../src/backend/nodes/list.c:670 [23:11:48.555] cell__state = {l = , i = } [23:11:48.555] cell = [23:11:48.555] #2 0x000055e093e8502d in add_new_column_to_pathtarget (target=target@entry=0x55e096571110, expr=0x55e0965a2688) at ../src/backend/optimizer/util/tlist.c:743 [23:11:48.555] No locals. [23:11:48.555] #3 0x000055e093e850c8 in add_new_columns_to_pathtarget (target=target@entry=0x55e096571110, exprs=exprs@entry=0x55e0965712a8) at ../src/backend/optimizer/util/tlist.c:760 [23:11:48.555] expr = [23:11:48.555] lc__state = {l = , i = } [23:11:48.555] lc = [23:11:48.555] #4 0x000055e093dfd370 in make_group_input_target (root=root@entry=0x55e0965a1f98, final_target=final_target@entry=0x55e096571028) at ../src/backend/optimizer/plan/planner.c:5472 [23:11:48.555] parse = 0x55e096451788 [23:11:48.555] input_target = 0x55e096571110 [23:11:48.555] non_group_cols = 0x55e096571258 [23:11:48.555] non_group_vars = 0x55e0965712a8 [23:11:48.555] i = 2 [23:11:48.555] lc = 0x0 [23:11:48.555] #5 0x000055e093e10732 in grouping_planner (root=root@entry=0x55e0965a1f98, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:11:48.555] sort_input_targets = 0x55e0965a24b8 [23:11:48.555] sort_input_target_parallel_safe = true [23:11:48.555] grouping_target = 0x55e096571028 [23:11:48.555] scanjoin_target = [23:11:48.555] activeWindows = 0x0 [23:11:48.555] qp_extra = {activeWindows = 0x0, gset_data = 0x55e0965a5768} [23:11:48.555] sort_input_targets_contain_srfs = 0x55e093e46ae0 [23:11:48.555] have_grouping = [23:11:48.555] wflists = 0x0 [23:11:48.555] gset_data = 0x55e0965a5768 [23:11:48.555] sort_input_target = 0x55e096571028 [23:11:48.555] grouping_targets = 0x0 [23:11:48.555] grouping_target_parallel_safe = true [23:11:48.555] scanjoin_targets = 0x0 [23:11:48.555] scanjoin_target_parallel_safe = [23:11:48.555] grouping_targets_contain_srfs = 0x55e093d6e81d [23:11:48.555] scanjoin_targets_contain_srfs = 0x0 [23:11:48.555] scanjoin_target_same_exprs = [23:11:48.555] parse = 0x55e096451788 [23:11:48.555] offset_est = 0 [23:11:48.555] count_est = 0 [23:11:48.555] limit_tuples = -1 [23:11:48.555] have_postponed_srfs = false [23:11:48.555] final_target = 0x55e096571028 [23:11:48.555] final_targets = 0x55e096533448 [23:11:48.555] final_targets_contain_srfs = 0x55e093e46b15 [23:11:48.555] final_target_parallel_safe = true [23:11:48.555] current_rel = 0x55e0965a1d48 [23:11:48.555] final_rel = [23:11:48.555] extra = {limit_needed = 152, limit_tuples = 4.9406564584124654e-324, count_est = 94423083523992, offset_est = 1} [23:11:48.555] lc = [23:11:48.555] __func__ = "grouping_planner" [23:11:48.555] #6 0x000055e093e135d6 in subquery_planner (glob=glob@entry=0x55e0965a1c38, parse=parse@entry=0x55e096451788, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:11:48.555] root = 0x55e0965a1f98 [23:11:48.555] newWithCheckOptions = [23:11:48.555] newHaving = 0x0 [23:11:48.555] hasOuterJoins = [23:11:48.555] hasResultRTEs = false [23:11:48.555] final_rel = [23:11:48.555] l = 0x0 [23:11:48.555] #7 0x000055e093e1422b in standard_planner (parse=0x55e096451788, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [23:11:48.555] result = [23:11:48.555] glob = 0x55e0965a1c38 [23:11:48.555] tuple_fraction = 0 [23:11:48.555] root = [23:11:48.555] final_rel = [23:11:48.555] best_path = [23:11:48.555] top_plan = [23:11:48.555] lp = [23:11:48.555] lr = [23:11:48.555] #8 0x000055e093e152ef in planner (parse=parse@entry=0x55e096451788, query_string=query_string@entry=0x55e096450260 "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/optimizer/plan/planner.c:280 [23:11:48.555] result = [23:11:48.555] #9 0x000055e09408594c in pg_plan_query (querytree=querytree@entry=0x55e096451788, query_string=query_string@entry=0x55e096450260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [23:11:48.555] plan = [23:11:48.555] #10 0x000055e093b707d0 in standard_ExplainOneQuery (query=0x55e096451788, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55e09647b318, queryString=0x55e096450260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:440 [23:11:48.555] plan = [23:11:48.555] planstart = {ticks = } [23:11:48.555] planduration = {ticks = 94423082145672} [23:11:48.555] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94423036629848, shared_blks_dirtied = 0, shared_blks_written = 70368744218555, local_blks_hit = 94423082145944, local_blks_read = 94423037995741, local_blks_dirtied = 140722158158414, local_blks_written = 94423043854050, temp_blks_read = 1, temp_blks_written = 140619628849936, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94420561035264}, local_blk_read_time = {ticks = 94423083068152}, local_blk_write_time = {ticks = 94423047777562}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94423041308964}} [23:11:48.555] bufusage = {shared_blks_hit = 94423083522968, shared_blks_read = 4294967297, shared_blks_dirtied = 0, shared_blks_written = 10, local_blks_hit = 0, local_blks_read = 94423044373294, local_blks_dirtied = 175625507717120, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 40891, shared_blk_read_time = {ticks = 140619628849936}, shared_blk_write_time = {ticks = 94423082146760}, local_blk_read_time = {ticks = 94423082145672}, local_blk_write_time = {ticks = 94423047293632}, temp_blk_read_time = {ticks = 140619628849936}, temp_blk_write_time = {ticks = 94423047293651}} [23:11:48.555] mem_counters = {nblocks = 140722158158416, freechunks = 94423082145672, totalspace = 140722158158413, freespace = 94423043938712} [23:11:48.555] planner_ctx = 0x0 [23:11:48.555] saved_ctx = 0x0 [23:11:48.555] #11 0x000055e093b70a68 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55e09647b318, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:396 [23:11:48.555] No locals. [23:11:48.555] #12 0x000055e093b7205f in ExplainQuery (pstate=pstate@entry=0x55e09647b208, stmt=stmt@entry=0x55e0964515c8, params=params@entry=0x0, dest=dest@entry=0x55e09647b178) at ../src/include/nodes/nodes.h:172 [23:11:48.555] l__state = {l = , i = } [23:11:48.555] l = 0x55e0965a1c00 [23:11:48.555] es = 0x55e09647b318 [23:11:48.555] tstate = [23:11:48.555] jstate = [23:11:48.555] query = [23:11:48.555] rewritten = 0x55e0965a1be8 [23:11:48.555] lc = 0x0 [23:11:48.555] timing_set = false [23:11:48.555] summary_set = false [23:11:48.555] __func__ = "ExplainQuery" [23:11:48.555] #13 0x000055e09409035a in standard_ProcessUtility (pstmt=0x55e096451678, queryString=0x55e096450260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55e09647b178, qc=0x7ffc6e3fc440) at ../src/backend/tcop/utility.c:863 [23:11:48.555] parsetree = 0x55e0964515c8 [23:11:48.555] isTopLevel = true [23:11:48.555] isAtomicContext = false [23:11:48.555] pstate = 0x55e09647b208 [23:11:48.555] readonly_flags = [23:11:48.555] __func__ = "standard_ProcessUtility" [23:11:48.555] #14 0x000055e094090a83 in ProcessUtility (pstmt=pstmt@entry=0x55e096451678, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55e09647b178, qc=0x7ffc6e3fc440) at ../src/backend/tcop/utility.c:523 [23:11:48.555] No locals. [23:11:48.555] #15 0x000055e09408c1e1 in PortalRunUtility (portal=portal@entry=0x55e0964d0f90, pstmt=0x55e096451678, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55e09647b178, qc=qc@entry=0x7ffc6e3fc440) at ../src/backend/tcop/pquery.c:1158 [23:11:48.555] No locals. [23:11:48.555] #16 0x000055e09408cbc4 in FillPortalStore (portal=portal@entry=0x55e0964d0f90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [23:11:48.555] treceiver = 0x55e09647b178 [23:11:48.555] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:11:48.555] __func__ = "FillPortalStore" [23:11:48.555] #17 0x000055e09408d246 in PortalRun (portal=portal@entry=0x55e0964d0f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55e096532b88, altdest=altdest@entry=0x55e096532b88, qc=0x7ffc6e3fc620) at ../src/backend/tcop/pquery.c:763 [23:11:48.555] _save_exception_stack = 0x7ffc6e3fc6d0 [23:11:48.555] _save_context_stack = 0x0 [23:11:48.555] _local_sigjmp_buf = {{__jmpbuf = {1, -2695585240613169384, 94423083068296, 94423082145344, 94423082667920, 94423082145272, 2697524230829332248, 8166842040796141336}, __mask_was_saved = 0, __saved_mask = {__val = {94423082679480, 94423050524734, 94423082676128, 94423050524734, 1, 140722158159279, 94423082145320, 94423082145272, 94423047517296, 94423050111273, 94423082667920, 94423050524734, 1, 1, 94423047777964, 153}}}} [23:11:48.555] _do_rethrow = [23:11:48.555] result = [23:11:48.555] nprocessed = [23:11:48.555] saveTopTransactionResourceOwner = 0x55e09648e5c0 [23:11:48.555] saveTopTransactionContext = 0x55e09653a520 [23:11:48.555] saveActivePortal = 0x0 [23:11:48.555] saveResourceOwner = 0x55e09648e5c0 [23:11:48.555] savePortalContext = 0x0 [23:11:48.555] saveMemoryContext = 0x55e09653a520 [23:11:48.555] __func__ = "PortalRun" [23:11:48.555] #18 0x000055e0940861db in exec_simple_query (query_string=query_string@entry=0x55e096450260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1274 [23:11:48.555] cmdtaglen = 7 [23:11:48.555] snapshot_set = [23:11:48.555] per_parsetree_context = 0x0 [23:11:48.555] plantree_list = 0x55e0965336a8 [23:11:48.555] parsetree = 0x55e0964515f8 [23:11:48.555] commandTag = [23:11:48.555] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:11:48.555] querytree_list = [23:11:48.555] portal = 0x55e0964d0f90 [23:11:48.555] receiver = 0x55e096532b88 [23:11:48.555] format = 0 [23:11:48.555] cmdtagname = [23:11:48.555] parsetree_item__state = {l = , i = } [23:11:48.555] dest = DestRemote [23:11:48.555] oldcontext = 0x55e09653a520 [23:11:48.555] parsetree_list = 0x55e096451628 [23:11:48.555] parsetree_item = 0x55e096451640 [23:11:48.555] save_log_statement_stats = false [23:11:48.555] was_logged = false [23:11:48.555] use_implicit_block = false [23:11:48.555] msec_str = "\200\310?n\374\177\000\000\t\221\065\224\340U\000\000\260\306?n\374\177\000\000U\000\000\000\000\000\000" [23:11:48.555] __func__ = "exec_simple_query" [23:11:48.555] #19 0x000055e094088f93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [23:11:48.555] query_string = 0x55e096450260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [23:11:48.555] firstchar = [23:11:48.555] input_message = {data = 0x55e096450260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [23:11:48.555] local_sigjmp_buf = {{__jmpbuf = {94423060058712, 8166840770716194584, 4, 140722158160000, 140722158160148, 1, 2697524230741251864, 8166842038581417752}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140619822554596, 94423082114800, 15616, 15680, 94423047689354, 94423060058720, 94423082114800, 94423060052792, 140722158160000, 140722158160148, 94423047693422, 140722158159776}}}} [23:11:48.555] send_ready_for_query = false [23:11:48.555] idle_in_transaction_timeout_enabled = false [23:11:48.555] idle_session_timeout_enabled = false [23:11:48.555] __func__ = "PostgresMain" [23:11:48.555] #20 0x000055e09407f74a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [23:11:48.555] bsdata = [23:11:48.555] #21 0x000055e093f29fed in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc6e3fc82c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc6e3fc880) at ../src/backend/postmaster/launch_backend.c:265 [23:11:48.555] pid = [23:11:48.555] #22 0x000055e093f3016d in BackendStartup (client_sock=client_sock@entry=0x7ffc6e3fc880) at ../src/backend/postmaster/postmaster.c:3593 [23:11:48.555] bn = 0x55e096478f18 [23:11:48.555] pid = [23:11:48.555] startup_data = {canAcceptConnections = CAC_OK} [23:11:48.555] __func__ = "BackendStartup" [23:11:48.555] #23 0x000055e093f3071b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [23:11:48.555] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\247\232\344\177\000\000\001\000\000\000\000\000\000\000\244\363!\234\344\177\000\000-\000\000\000\000\000\000\000\020\036\213\232\344\177\000\000 \351Z\233\344\177\000\000H\311?n\374\177\000\000D\311?n\374\177\000\000\004\311?n\374\177\000\000@\216\000\000\001\000\000\000\000\000\000\000\340U\000\000\020\036\213\232\344\177\000\000\340?\212\232\344\177\000\000\352\177\247\232\344\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [23:11:48.555] i = 0 [23:11:48.555] now = [23:11:48.555] last_lockfile_recheck_time = 1711062487 [23:11:48.555] last_touch_time = 1711062487 [23:11:48.555] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1849674240, events = 32764, fd = 45, user_data = 0x7ffc6e3fc9c0}, {pos = 1849674192, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = -1688541304, user_data = 0x7fe49aa77fea}, {pos = 1849674408, events = 32764, fd = 1849674240, user_data = 0x7ffc6e3fca10}, {pos = -1675494175, events = 32740, fd = 18, user_data = 0x7fe498275618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1688542176, events = 32740, fd = -1, user_data = 0x7fe498275618}, {pos = -1688542176, events = 32740, fd = 1024, user_data = 0x7fe49b5ae788}, {pos = 0, events = 0, fd = 8, user_data = 0x7ffc6e3fca10}, {pos = -1, events = 0, fd = -1701434182, user_data = 0x7fe49a8a4418}, {pos = -1688540896, events = 32740, fd = -1773675512, user_data = 0x55e09647b708}, {pos = -1773708816, events = 21984, fd = -1773675480, user_data = 0x55e09647db61}, {pos = -1675475421, events = 32740, fd = 1, user_data = 0x7fe49aa910f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -1773854672, user_data = 0x7fe49c224623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x55e0964759f0}, {pos = -1702214632, events = 32740, fd = 1849675344, user_data = 0x7fe49c22b68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffc6e3fce70}, {pos = -1796001760, events = 21984, fd = 2, user_data = 0x55e094f33020 }, {pos = 0, events = 0, fd = 7, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x2ffff00001fa0}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -1773681768, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1734701663, user_data = 0xa5866574459442d}, {pos = 762540901, events = 1464097092, fd = 168450150, user_data = 0x30313137310a6174}, {pos = 942944822, events = 808716855, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = -1701696517, user_data = 0x400}, {pos = -1773871216, events = 21984, fd = -1700350848, user_data = 0x19644df90}, {pos = 784, events = 0, fd = -1806013460, user_data = 0x55e09647b3e0}, {pos = 1852123136, events = 1465987973, fd = 4, user_data = 0x55e09647c360}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55e09647b3e0}, {pos = 1, events = 0, fd = -1773685592, user_data = 0x400}, {pos = 0, events = 0, fd = -1808232914, user_data = 0x55e094f41210 }, {pos = -1808299238, events = 21984, fd = -1773685792, user_data = 0x55e096450160}, {pos = -1773685792, events = 21984, fd = 15, user_data = 0x4a}, {pos = -1808231146, events = 21984, fd = -1773685792, user_data = 0x55e094389658 }, {pos = -1773871216, events = 21984, fd = -1701696517, user_data = 0x0}, {pos = -1814778373, events = 21984, fd = -1773697184, user_data = 0x7fe49a91f1aa}, {pos = 1849675528, events = 1, fd = 0, user_data = 0x7fe49a91d8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 23865, user_data = 0x7fe49a967b05 }, {pos = 0, events = 0, fd = 1852123136, user_data = 0x0}, {pos = -1812816621, events = 21984, fd = 4194304, user_data = 0x55e0943789ae }, {pos = -1773697184, events = 21984, fd = -1773862560, user_data = 0x55e096478760}, {pos = 1, events = 0, fd = 0, user_data = 0x55e094389516 }, {pos = -1773697184, events = 21984, fd = -1808230824, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55e093d4a9ce }, {pos = 0, events = 0, fd = -1814755420, user_data = 0xb}, {pos = -1812795201, events = 21984, fd = 0, user_data = 0x0}} [23:11:48.555] nevents = 1 [23:11:48.555] __func__ = "ServerLoop" [23:11:48.555] #24 0x000055e093f3213d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55e096449e50) at ../src/backend/postmaster/postmaster.c:1372 [23:11:48.555] opt = [23:11:48.555] status = [23:11:48.555] userDoption = [23:11:48.555] listen_addr_saved = false [23:11:48.555] output_config_variable = [23:11:48.555] __func__ = "PostmasterMain" [23:11:48.555] #25 0x000055e093d5b7fe in main (argc=8, argv=0x55e096449e50) at ../src/backend/main/main.c:197 [23:11:48.555] do_check_root = [23:11:48.574] -e [23:11:48.574] [23:11:48.574] [23:11:49.121] dumping /tmp/cores/postgres-11-28422.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:11:49.437] [New LWP 28422] [23:11:50.603] [Thread debugging using libthread_db enabled] [23:11:50.603] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:11:52.052] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [23:11:52.052] Program terminated with signal SIGSEGV, Segmentation fault. [23:11:52.052] #0 0x000055d09d3effe6 in equal (a=0xffffffff9e549bd8, b=b@entry=0x55d09e5469d8) at ../src/backend/nodes/equalfuncs.c:239 [23:11:52.052] 239 if (nodeTag(a) != nodeTag(b)) [23:11:52.174] [23:11:52.174] Thread 1 (Thread 0x7f783a048a40 (LWP 28422)): [23:11:52.174] #0 0x000055d09d3effe6 in equal (a=0xffffffff9e549bd8, b=b@entry=0x55d09e5469d8) at ../src/backend/nodes/equalfuncs.c:239 [23:11:52.174] retval = [23:11:52.174] __func__ = "equal" [23:11:52.174] #1 0x000055d09cd27b29 in list_member (list=0x55d09e549c48, datum=datum@entry=0x55d09e5469d8) at ../src/backend/nodes/list.c:670 [23:11:52.174] cell__state = {l = , i = } [23:11:52.174] cell = [23:11:52.174] #2 0x000055d09ce4c02d in add_new_column_to_pathtarget (target=target@entry=0x55d09e549b68, expr=0x55d09e5469d8) at ../src/backend/optimizer/util/tlist.c:743 [23:11:52.174] No locals. [23:11:52.174] #3 0x000055d09ce4c0c8 in add_new_columns_to_pathtarget (target=target@entry=0x55d09e549b68, exprs=exprs@entry=0x55d09e549d78) at ../src/backend/optimizer/util/tlist.c:760 [23:11:52.174] expr = [23:11:52.174] lc__state = {l = , i = } [23:11:52.174] lc = [23:11:52.174] #4 0x000055d09cdc4370 in make_group_input_target (root=root@entry=0x55d09e53ebe8, final_target=final_target@entry=0x55d09e549a08) at ../src/backend/optimizer/plan/planner.c:5472 [23:11:52.174] parse = 0x55d09e41cd08 [23:11:52.174] input_target = 0x55d09e549b68 [23:11:52.174] non_group_cols = 0x55d09e549d28 [23:11:52.174] non_group_vars = 0x55d09e549d78 [23:11:52.174] i = 6 [23:11:52.174] lc = 0x0 [23:11:52.174] #5 0x000055d09cdd7732 in grouping_planner (root=root@entry=0x55d09e53ebe8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:11:52.174] sort_input_targets = 0x55d09e546848 [23:11:52.174] sort_input_target_parallel_safe = true [23:11:52.174] grouping_target = 0x55d09e549a08 [23:11:52.174] scanjoin_target = [23:11:52.174] activeWindows = 0x0 [23:11:52.174] qp_extra = {activeWindows = 0x0, gset_data = 0x55d09e547e68} [23:11:52.174] sort_input_targets_contain_srfs = 0x55d09ce0dae0 [23:11:52.174] have_grouping = [23:11:52.174] wflists = 0x0 [23:11:52.174] gset_data = 0x55d09e547e68 [23:11:52.174] sort_input_target = 0x55d09e549a08 [23:11:52.174] grouping_targets = 0x0 [23:11:52.174] grouping_target_parallel_safe = true [23:11:52.174] scanjoin_targets = 0x0 [23:11:52.174] scanjoin_target_parallel_safe = [23:11:52.174] grouping_targets_contain_srfs = 0x55d09cd3581d [23:11:52.174] scanjoin_targets_contain_srfs = 0x55d09e5430b8 [23:11:52.174] scanjoin_target_same_exprs = [23:11:52.174] parse = 0x55d09e41cd08 [23:11:52.174] offset_est = 0 [23:11:52.174] count_est = 0 [23:11:52.174] limit_tuples = -1 [23:11:52.174] have_postponed_srfs = false [23:11:52.174] final_target = 0x55d09e549a08 [23:11:52.174] final_targets = 0x0 [23:11:52.174] final_targets_contain_srfs = 0x55d09ce13dd7 [23:11:52.174] final_target_parallel_safe = true [23:11:52.174] current_rel = 0x55d09e53eff8 [23:11:52.174] final_rel = [23:11:52.174] extra = {limit_needed = 232, limit_tuples = 1.9762625833649862e-323, count_est = 94354497858536, offset_est = 0} [23:11:52.174] lc = [23:11:52.174] __func__ = "grouping_planner" [23:11:52.174] #6 0x000055d09cdda5d6 in subquery_planner (glob=glob@entry=0x55d09e41cf78, parse=parse@entry=0x55d09e41cd08, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:11:52.174] root = 0x55d09e53ebe8 [23:11:52.174] newWithCheckOptions = [23:11:52.174] newHaving = 0x0 [23:11:52.174] hasOuterJoins = [23:11:52.174] hasResultRTEs = false [23:11:52.174] final_rel = [23:11:52.174] l = 0x0 [23:11:52.174] #7 0x000055d09cddb22b in standard_planner (parse=0x55d09e41cd08, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [23:11:52.174] result = [23:11:52.174] glob = 0x55d09e41cf78 [23:11:52.174] tuple_fraction = 0 [23:11:52.174] root = [23:11:52.174] final_rel = [23:11:52.174] best_path = [23:11:52.174] top_plan = [23:11:52.174] lp = [23:11:52.174] lr = [23:11:52.174] #8 0x000055d09cddc2ef in planner (parse=parse@entry=0x55d09e41cd08, query_string=query_string@entry=0x55d09e41b250 "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/optimizer/plan/planner.c:280 [23:11:52.174] result = [23:11:52.174] #9 0x000055d09d04c94c in pg_plan_query (querytree=querytree@entry=0x55d09e41cd08, query_string=query_string@entry=0x55d09e41b250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [23:11:52.174] plan = [23:11:52.174] #10 0x000055d09d04ccb9 in pg_plan_queries (querytrees=0x55d09e543458, query_string=query_string@entry=0x55d09e41b250 "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:996 [23:11:52.174] query = 0x55d09e41cd08 [23:11:52.174] stmt = [23:11:52.174] query_list__state = {l = , i = } [23:11:52.174] stmt_list = 0x0 [23:11:52.174] query_list = [23:11:52.174] #11 0x000055d09d04d093 in exec_simple_query (query_string=query_string@entry=0x55d09e41b250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [23:11:52.174] cmdtaglen = 6 [23:11:52.174] snapshot_set = true [23:11:52.174] per_parsetree_context = 0x0 [23:11:52.174] plantree_list = [23:11:52.174] parsetree = 0x55d09e41cb78 [23:11:52.174] commandTag = CMDTAG_SELECT [23:11:52.174] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94354496664144} [23:11:52.174] querytree_list = [23:11:52.174] portal = [23:11:52.174] receiver = [23:11:52.174] format = 0 [23:11:52.174] cmdtagname = [23:11:52.174] parsetree_item__state = {l = , i = } [23:11:52.174] dest = DestRemote [23:11:52.174] oldcontext = 0x55d09e4f5350 [23:11:52.174] parsetree_list = 0x55d09e41cba8 [23:11:52.174] parsetree_item = 0x55d09e41cbc0 [23:11:52.174] save_log_statement_stats = false [23:11:52.174] was_logged = true [23:11:52.174] use_implicit_block = false [23:11:52.174] msec_str = "\000\372x\370\377\177\000\000\t\001\062\235\320U\000\000\060\370x\370\377\177\000\000[\000\000\000\000\000\000" [23:11:52.174] __func__ = "exec_simple_query" [23:11:52.174] #12 0x000055d09d04ff93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [23:11:52.174] query_string = 0x55d09e41b250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [23:11:52.174] firstchar = [23:11:52.174] input_message = {data = 0x55d09e41b250 "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} [23:11:52.174] local_sigjmp_buf = {{__jmpbuf = {94354491343448, 2928710985563996095, 4, 140737362065920, 140737362066068, 1, 9005532460287754175, 2928710810903216063}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 140154386771428, 94354496638720, 14336, 14400, 94354478974090, 94354491343456, 94354496638720, 94354491337528, 140737362065920, 140737362066068, 94354478978158, 140737362065696}}}} [23:11:52.174] send_ready_for_query = false [23:11:52.174] idle_in_transaction_timeout_enabled = false [23:11:52.174] idle_session_timeout_enabled = false [23:11:52.174] __func__ = "PostgresMain" [23:11:52.174] #13 0x000055d09d04674a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [23:11:52.174] bsdata = [23:11:52.174] #14 0x000055d09cef0fed in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffff878f9ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffff878fa00) at ../src/backend/postmaster/launch_backend.c:265 [23:11:52.174] pid = [23:11:52.174] #15 0x000055d09cef716d in BackendStartup (client_sock=client_sock@entry=0x7ffff878fa00) at ../src/backend/postmaster/postmaster.c:3593 [23:11:52.174] bn = 0x55d09e4514d8 [23:11:52.174] pid = [23:11:52.174] startup_data = {canAcceptConnections = CAC_OK} [23:11:52.174] __func__ = "BackendStartup" [23:11:52.174] #16 0x000055d09cef771b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [23:11:52.174] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\204 [23:11:52.174] last_lockfile_recheck_time = 1711062489 [23:11:52.174] last_touch_time = 1711062489 [23:11:52.174] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -126289024, events = 32767, fd = 45, user_data = 0x7ffff878fb40}, {pos = -126289072, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 1027110792, user_data = 0x7f783c850fea}, {pos = -126288856, events = 32767, fd = -126289024, user_data = 0x7ffff878fb90}, {pos = 1040182497, events = 32632, fd = 18, user_data = 0x7f783a04e618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1027109920, events = 32632, fd = -1, user_data = 0x7f783a04e618}, {pos = 1027109920, events = 32632, fd = 1024, user_data = 0x7f783d387788}, {pos = 0, events = 0, fd = 7, user_data = 0x7ffff878fb90}, {pos = -1, events = 0, fd = 1014217914, user_data = 0x7f783c67d418}, {pos = 1027111200, events = 32632, fd = -1639693320, user_data = 0x55d09e444288}, {pos = -1639686000, events = 21968, fd = -1639693288, user_data = 0x55d09e445371}, {pos = 1040201251, events = 32632, fd = 1, user_data = 0x7f783c86a0f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -1639854096, user_data = 0x7f783e003623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x55d09e446090}, {pos = 1013437464, events = 32632, fd = -126287920, user_data = 0x7f783e00a68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffff878fff0}, {pos = -1645240288, events = 21968, fd = 2, user_data = 0x55d09defa020 }, {pos = 0, events = 0, fd = 7, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x2ffff00001fa0}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -1639693400, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x3836343736202020}, {pos = 538976304, events = 538976288, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = 1013955886, user_data = 0x400}, {pos = -1639870560, events = 21968, fd = 1015301248, user_data = 0x19e418fa0}, {pos = 784, events = 0, fd = -1655251988, user_data = 0x55d09e443f60}, {pos = -1043161088, events = 2843071162, fd = 4, user_data = 0x55d09e444370}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55d09e443f60}, {pos = 1, events = 0, fd = -1639694296, user_data = 0x400}, {pos = 0, events = 0, fd = -1657471442, user_data = 0x55d09df08210 }, {pos = -1657537766, events = 21968, fd = -1639694496, user_data = 0x55d09e41b150}, {pos = -1639694496, events = 21968, fd = 15, user_data = 0x4a}, {pos = -1657469674, events = 21968, fd = -1639694496, user_data = 0x55d09d350658 }, {pos = -1639870560, events = 21968, fd = 1013955886, user_data = 0x0}, {pos = -1664016901, events = 21968, fd = -1639699648, user_data = 0x7f783c6f81aa}, {pos = -126287736, events = 1, fd = 0, user_data = 0x7f783c6f68f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 24511, user_data = 0x7f783c740b05 }, {pos = 0, events = 0, fd = -1043161088, user_data = 0x0}, {pos = -1662055149, events = 21968, fd = 4194304, user_data = 0x55d09d33f9ae }, {pos = -1639699648, events = 21968, fd = -1639861936, user_data = 0x55d09e442b40}, {pos = 1, events = 0, fd = 0, user_data = 0x55d09d350516 }, {pos = -1639699648, events = 21968, fd = -1657469352, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55d09cd119ce }, {pos = 0, events = 0, fd = -1663993948, user_data = 0xb}, {pos = -1662033729, events = 21968, fd = 0, user_data = 0x0}} [23:11:52.175] nevents = 1 [23:11:52.175] __func__ = "ServerLoop" [23:11:52.175] #17 0x000055d09cef913d in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55d09e414e10) at ../src/backend/postmaster/postmaster.c:1372 [23:11:52.175] opt = [23:11:52.175] status = [23:11:52.175] userDoption = [23:11:52.175] listen_addr_saved = false [23:11:52.175] output_config_variable = [23:11:52.175] __func__ = "PostmasterMain" [23:11:52.175] #18 0x000055d09cd227fe in main (argc=4, argv=0x55d09e414e10) at ../src/backend/main/main.c:197 [23:11:52.175] do_check_root = [23:11:52.193] -e [23:11:52.193] [23:11:52.193] [23:11:52.752] dumping /tmp/cores/postgres-11-34760.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:11:53.065] [New LWP 34760] [23:11:54.226] [Thread debugging using libthread_db enabled] [23:11:54.226] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:11:55.672] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [23:11:55.672] Program terminated with signal SIGSEGV, Segmentation fault. [23:11:55.672] #0 0x00005642a1637fe6 in equal (a=0xffffffffa3fe7150, b=b@entry=0x5642a3fe3e48) at ../src/backend/nodes/equalfuncs.c:239 [23:11:55.672] 239 if (nodeTag(a) != nodeTag(b)) [23:11:55.813] [23:11:55.813] Thread 1 (Thread 0x7fc1a13d3a40 (LWP 34760)): [23:11:55.813] #0 0x00005642a1637fe6 in equal (a=0xffffffffa3fe7150, b=b@entry=0x5642a3fe3e48) at ../src/backend/nodes/equalfuncs.c:239 [23:11:55.813] retval = [23:11:55.813] __func__ = "equal" [23:11:55.813] #1 0x00005642a0f6fb29 in list_member (list=0x5642a3fe71c0, datum=datum@entry=0x5642a3fe3e48) at ../src/backend/nodes/list.c:670 [23:11:55.813] cell__state = {l = , i = } [23:11:55.813] cell = [23:11:55.813] #2 0x00005642a109402d in add_new_column_to_pathtarget (target=target@entry=0x5642a3fe70e0, expr=0x5642a3fe3e48) at ../src/backend/optimizer/util/tlist.c:743 [23:11:55.813] No locals. [23:11:55.813] #3 0x00005642a10940c8 in add_new_columns_to_pathtarget (target=target@entry=0x5642a3fe70e0, exprs=exprs@entry=0x5642a3fe72f0) at ../src/backend/optimizer/util/tlist.c:760 [23:11:55.813] expr = [23:11:55.813] lc__state = {l = , i = } [23:11:55.813] lc = [23:11:55.813] #4 0x00005642a100c370 in make_group_input_target (root=root@entry=0x5642a3fe16e0, final_target=final_target@entry=0x5642a3fe6f80) at ../src/backend/optimizer/plan/planner.c:5472 [23:11:55.813] parse = 0x5642a3ebed48 [23:11:55.813] input_target = 0x5642a3fe70e0 [23:11:55.813] non_group_cols = 0x5642a3fe72a0 [23:11:55.813] non_group_vars = 0x5642a3fe72f0 [23:11:55.813] i = 6 [23:11:55.813] lc = 0x0 [23:11:55.813] #5 0x00005642a101f732 in grouping_planner (root=root@entry=0x5642a3fe16e0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:11:55.813] sort_input_targets = 0x5642a3fe3cb8 [23:11:55.813] sort_input_target_parallel_safe = true [23:11:55.813] grouping_target = 0x5642a3fe6f80 [23:11:55.813] scanjoin_target = [23:11:55.813] activeWindows = 0x0 [23:11:55.813] qp_extra = {activeWindows = 0x0, gset_data = 0x5642a3fe5318} [23:11:55.813] sort_input_targets_contain_srfs = 0x5642a1055ae0 [23:11:55.813] have_grouping = [23:11:55.813] wflists = 0x0 [23:11:55.813] gset_data = 0x5642a3fe5318 [23:11:55.813] sort_input_target = 0x5642a3fe6f80 [23:11:55.813] grouping_targets = 0x0 [23:11:55.813] grouping_target_parallel_safe = true [23:11:55.813] scanjoin_targets = 0x0 [23:11:55.813] scanjoin_target_parallel_safe = [23:11:55.813] grouping_targets_contain_srfs = 0x5642a0f7d81d [23:11:55.813] scanjoin_targets_contain_srfs = 0x5642a3fe00c8 [23:11:55.813] scanjoin_target_same_exprs = [23:11:55.813] parse = 0x5642a3ebed48 [23:11:55.813] offset_est = 0 [23:11:55.813] count_est = 0 [23:11:55.813] limit_tuples = -1 [23:11:55.813] have_postponed_srfs = false [23:11:55.813] final_target = 0x5642a3fe6f80 [23:11:55.813] final_targets = 0x0 [23:11:55.813] final_targets_contain_srfs = 0x5642a105bdd7 [23:11:55.813] final_target_parallel_safe = true [23:11:55.813] current_rel = 0x5642a3fcf488 [23:11:55.813] final_rel = [23:11:55.813] extra = {limit_needed = 224, limit_tuples = 1.9762625833649862e-323, count_est = 94844219168480, offset_est = 0} [23:11:55.813] lc = [23:11:55.813] __func__ = "grouping_planner" [23:11:55.813] #6 0x00005642a10225d6 in subquery_planner (glob=glob@entry=0x5642a3fb2308, parse=parse@entry=0x5642a3ebed48, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:11:55.813] root = 0x5642a3fe16e0 [23:11:55.813] newWithCheckOptions = [23:11:55.813] newHaving = 0x0 [23:11:55.813] hasOuterJoins = [23:11:55.813] hasResultRTEs = false [23:11:55.813] final_rel = [23:11:55.813] l = 0x0 [23:11:55.813] #7 0x00005642a102322b in standard_planner (parse=parse@entry=0x5642a3ebed48, query_string=query_string@entry=0x5642a3ebd290 "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/optimizer/plan/planner.c:412 [23:11:55.813] result = [23:11:55.813] glob = 0x5642a3fb2308 [23:11:55.813] tuple_fraction = 0 [23:11:55.813] root = [23:11:55.813] final_rel = [23:11:55.813] best_path = [23:11:55.813] top_plan = [23:11:55.813] lp = [23:11:55.813] lr = [23:11:55.813] #8 0x00007fc1a120073e in pgss_planner (parse=0x5642a3ebed48, query_string=0x5642a3ebd290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:972 [23:11:55.813] _save_exception_stack = 0x7ffcd80e77f0 [23:11:55.813] _save_context_stack = 0x0 [23:11:55.813] _local_sigjmp_buf = {{__jmpbuf = {94844217978184, -3902826000307946393, 0, 2048, 0, 94844217971344, -7301857110831367065, -7291215672751522713}, __mask_was_saved = 0, __saved_mask = {__val = {70368744203438, 1, 94844165053149, 1, 94844170909525, 1, 94844219163832, 0, 0, 0, 94844174834970, 0, 94844168366372, 0, 94844217978184, 0}}}} [23:11:55.813] _do_rethrow = false [23:11:55.813] result = 0x7ffcd80e7560 [23:11:55.813] #9 0x00005642a10242e5 in planner (parse=parse@entry=0x5642a3ebed48, query_string=query_string@entry=0x5642a3ebd290 "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/optimizer/plan/planner.c:278 [23:11:55.813] result = [23:11:55.813] #10 0x00005642a129494c in pg_plan_query (querytree=querytree@entry=0x5642a3ebed48, query_string=query_string@entry=0x5642a3ebd290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [23:11:55.813] plan = [23:11:55.813] #11 0x00005642a1294cb9 in pg_plan_queries (querytrees=0x5642a3fe04b8, query_string=query_string@entry=0x5642a3ebd290 "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:996 [23:11:55.813] query = 0x5642a3ebed48 [23:11:55.813] stmt = [23:11:55.813] query_list__state = {l = , i = } [23:11:55.813] stmt_list = 0x0 [23:11:55.813] query_list = [23:11:55.813] #12 0x00005642a1295093 in exec_simple_query (query_string=query_string@entry=0x5642a3ebd290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [23:11:55.813] cmdtaglen = 6 [23:11:55.813] snapshot_set = true [23:11:55.813] per_parsetree_context = 0x0 [23:11:55.813] plantree_list = [23:11:55.813] parsetree = 0x5642a3ebebb8 [23:11:55.813] commandTag = CMDTAG_SELECT [23:11:55.813] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94844217971344} [23:11:55.813] querytree_list = [23:11:55.813] portal = [23:11:55.813] receiver = [23:11:55.813] format = 0 [23:11:55.813] cmdtagname = [23:11:55.813] parsetree_item__state = {l = , i = } [23:11:55.813] dest = DestRemote [23:11:55.813] oldcontext = 0x5642a3ee9880 [23:11:55.813] parsetree_list = 0x5642a3ebebe8 [23:11:55.813] parsetree_item = 0x5642a3ebec00 [23:11:55.813] save_log_statement_stats = false [23:11:55.813] was_logged = true [23:11:55.813] use_implicit_block = false [23:11:55.813] msec_str = "\240y\016\330\374\177\000\000\t\201V\241BV\000\000\320w\016\330\374\177\000\000[\000\000\000\000\000\000" [23:11:55.813] __func__ = "exec_simple_query" [23:11:55.813] #13 0x00005642a1297f93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [23:11:55.813] query_string = 0x5642a3ebd290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [23:11:55.813] firstchar = [23:11:55.813] input_message = {data = 0x5642a3ebd290 "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} [23:11:55.813] local_sigjmp_buf = {{__jmpbuf = {94844187116120, -3902822540189598617, 4, 140723933313440, 140723933313588, 1, -7301857110680372121, -3902819966751835033}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94844217945920, 16384, 8248, 94844174748469, 0, 0, 0, 94844187116128, 94844217945920, 94844187110200, 140723933313440, 140723933313588, 1, 94844174751519, 140723933313216}}}} [23:11:55.813] send_ready_for_query = false [23:11:55.813] idle_in_transaction_timeout_enabled = false [23:11:55.813] idle_session_timeout_enabled = false [23:11:55.813] __func__ = "PostgresMain" [23:11:55.813] #14 0x00005642a128e74a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [23:11:55.813] bsdata = [23:11:55.813] #15 0x00005642a1138fed in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffcd80e794c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcd80e79a0) at ../src/backend/postmaster/launch_backend.c:265 [23:11:55.813] pid = [23:11:55.813] #16 0x00005642a113f16d in BackendStartup (client_sock=client_sock@entry=0x7ffcd80e79a0) at ../src/backend/postmaster/postmaster.c:3593 [23:11:55.813] bn = 0x5642a3ee9a48 [23:11:55.813] pid = [23:11:55.813] startup_data = {canAcceptConnections = CAC_OK} [23:11:55.813] __func__ = "BackendStartup" [23:11:55.813] #17 0x00005642a113f71b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [23:11:55.813] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\241\243\301\177\000\000 )q\244\301\177\000\000Hz\016\330\374\177\000\000Dz\016\330\374\177\000\000\000\000\000\000\374\177\000\000\340t\356\243BV\000\000\000\000\000\000\374\177\000\000\020^\241\243\301\177\000\000\340\177\240\243\301\177\000\000꿽\243\301\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000Dz\016\330\374\177\000\000\340t\356\243BV\000\000\020{\016\330\374\177\000", __ss_align = 140469652525856}, salen = 2}} [23:11:55.813] i = 0 [23:11:55.813] now = [23:11:55.813] last_lockfile_recheck_time = 1711062514 [23:11:55.813] last_touch_time = 1711062514 [23:11:55.813] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = -1536088184, events = 32705, fd = -1547845654, user_data = 0x7ffcd80e7ba8}, {pos = -670139648, events = 32764, fd = -670139632, user_data = 0x7fc1a5383ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -1589799400, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fc1a4712420}, {pos = -1, events = 0, fd = -1589799400, user_data = 0x7fc1a4712420}, {pos = -1536087776, events = 1, fd = -1536088184, user_data = 0x0}, {pos = -670139648, events = 32764, fd = 1024, user_data = 0xffffffff}, {pos = -670139360, events = 32764, fd = -1549761512, user_data = 0x7fc1a4712920}, {pos = -1544628920, events = 22082, fd = -1544629288, user_data = 0x5642a3ee8b60}, {pos = -1544628888, events = 22082, fd = -1544630127, user_data = 0x7fc1a5388623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = -1547742984, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = -1544818448, events = 22082, fd = -1523022301, user_data = 0x1}, {pos = 0, events = 0, fd = -1544647840, user_data = 0x7fc1a3a08418}, {pos = -670138512, events = 32764, fd = -1522993526, user_data = 0x0}, {pos = 0, events = 0, fd = -670138480, user_data = 0x5642a2142020 }, {pos = 2, events = 0, fd = -1575739360, user_data = 0x0}, {pos = -1549234612, events = 32705, fd = -1544607472, user_data = 0x7fc1a3bd2be0}, {pos = 255, events = 0, fd = 8096, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x0}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa67}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5642a3ebafe0}, {pos = -1544835104, events = 22082, fd = -1547900800, user_data = 0x7fc1a3a8151a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -1549243397, user_data = 0x400}, {pos = -1544835104, events = 22082, fd = -1547897728, user_data = 0x1a3ebafe0}, {pos = 784, events = 0, fd = -1585751060, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x5642a1587873 }, {pos = -1544630096, events = 22082, fd = -1544630096, user_data = 0x5642a3eed0b0}, {pos = 1, events = 0, fd = -1544629896, user_data = 0x400}, {pos = 0, events = 0, fd = -1587970514, user_data = 0x5642a2150210 }, {pos = -1588036838, events = 22082, fd = -1544630096, user_data = 0x5642a3ebd190}, {pos = -1544630096, events = 22082, fd = 15, user_data = 0x4a}, {pos = -1587968746, events = 22082, fd = -1544630096, user_data = 0x5642a1598658 }, {pos = -1544835104, events = 22082, fd = -1549243090, user_data = 0x0}, {pos = -1594515973, events = 22082, fd = -1544655936, user_data = 0x7fc1a3a831aa}, {pos = -670138328, events = 1, fd = 0, user_data = 0x7fc1a3a818f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 31029, user_data = 0x7fc1a3acbb05 }, {pos = 0, events = 0, fd = -1506778368, user_data = 0x0}, {pos = -1592554221, events = 22082, fd = 4194304, user_data = 0x5642a15879ae }, {pos = -1544655936, events = 22082, fd = -1544826480, user_data = 0x5642a3ee6bc0}, {pos = 1, events = 0, fd = 0, user_data = 0x5642a1598516 }, {pos = -1544655936, events = 22082, fd = -1587968424, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5642a0f599ce }, {pos = 0, events = 0, fd = -1594493020, user_data = 0xb}, {pos = -1592532801, events = 22082, fd = 0, user_data = 0x0}} [23:11:55.813] nevents = 1 [23:11:55.813] __func__ = "ServerLoop" [23:11:55.813] #18 0x00005642a114113d in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5642a3eb6e40) at ../src/backend/postmaster/postmaster.c:1372 [23:11:55.813] opt = [23:11:55.813] status = [23:11:55.813] userDoption = [23:11:55.813] listen_addr_saved = false [23:11:55.813] output_config_variable = [23:11:55.813] __func__ = "PostmasterMain" [23:11:55.813] #19 0x00005642a0f6a7fe in main (argc=4, argv=0x5642a3eb6e40) at ../src/backend/main/main.c:197 [23:11:55.813] do_check_root = [23:11:55.831] -e [23:11:55.831] [23:11:55.831] [23:11:56.378] dumping /tmp/cores/postgres-11-27271.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:11:56.692] [New LWP 27271] [23:11:57.850] [Thread debugging using libthread_db enabled] [23:11:57.850] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:11:59.272] Core was generated by `postgres: postgres regression [local] SELECT '. [23:11:59.272] Program terminated with signal SIGSEGV, Segmentation fault. [23:11:59.272] #0 0x000055e094428fe6 in equal (a=0xffffffff96584b08, b=b@entry=0x55e096581908) at ../src/backend/nodes/equalfuncs.c:239 [23:11:59.272] 239 if (nodeTag(a) != nodeTag(b)) [23:11:59.395] [23:11:59.395] Thread 1 (Thread 0x7fe49826fa40 (LWP 27271)): [23:11:59.395] #0 0x000055e094428fe6 in equal (a=0xffffffff96584b08, b=b@entry=0x55e096581908) at ../src/backend/nodes/equalfuncs.c:239 [23:11:59.395] retval = [23:11:59.395] __func__ = "equal" [23:11:59.395] #1 0x000055e093d60b29 in list_member (list=0x55e096584b78, datum=datum@entry=0x55e096581908) at ../src/backend/nodes/list.c:670 [23:11:59.395] cell__state = {l = , i = } [23:11:59.395] cell = [23:11:59.395] #2 0x000055e093e8502d in add_new_column_to_pathtarget (target=target@entry=0x55e096584a98, expr=0x55e096581908) at ../src/backend/optimizer/util/tlist.c:743 [23:11:59.395] No locals. [23:11:59.395] #3 0x000055e093e850c8 in add_new_columns_to_pathtarget (target=target@entry=0x55e096584a98, exprs=exprs@entry=0x55e096584ca8) at ../src/backend/optimizer/util/tlist.c:760 [23:11:59.395] expr = [23:11:59.395] lc__state = {l = , i = } [23:11:59.395] lc = [23:11:59.395] #4 0x000055e093dfd370 in make_group_input_target (root=root@entry=0x55e096579b18, final_target=final_target@entry=0x55e096584938) at ../src/backend/optimizer/plan/planner.c:5472 [23:11:59.395] parse = 0x55e096451d18 [23:11:59.395] input_target = 0x55e096584a98 [23:11:59.395] non_group_cols = 0x55e096584c58 [23:11:59.395] non_group_vars = 0x55e096584ca8 [23:11:59.395] i = 6 [23:11:59.395] lc = 0x0 [23:11:59.395] #5 0x000055e093e10732 in grouping_planner (root=root@entry=0x55e096579b18, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:11:59.395] sort_input_targets = 0x55e096581778 [23:11:59.395] sort_input_target_parallel_safe = true [23:11:59.395] grouping_target = 0x55e096584938 [23:11:59.395] scanjoin_target = [23:11:59.395] activeWindows = 0x0 [23:11:59.395] qp_extra = {activeWindows = 0x0, gset_data = 0x55e096582d98} [23:11:59.395] sort_input_targets_contain_srfs = 0x55e093e46ae0 [23:11:59.395] have_grouping = [23:11:59.395] wflists = 0x0 [23:11:59.395] gset_data = 0x55e096582d98 [23:11:59.395] sort_input_target = 0x55e096584938 [23:11:59.395] grouping_targets = 0x0 [23:11:59.395] grouping_target_parallel_safe = true [23:11:59.395] scanjoin_targets = 0x0 [23:11:59.395] scanjoin_target_parallel_safe = [23:11:59.395] grouping_targets_contain_srfs = 0x55e093d6e81d [23:11:59.395] scanjoin_targets_contain_srfs = 0x55e09657dfe8 [23:11:59.395] scanjoin_target_same_exprs = [23:11:59.395] parse = 0x55e096451d18 [23:11:59.395] offset_est = 0 [23:11:59.395] count_est = 0 [23:11:59.395] limit_tuples = -1 [23:11:59.395] have_postponed_srfs = false [23:11:59.395] final_target = 0x55e096584938 [23:11:59.395] final_targets = 0x0 [23:11:59.395] final_targets_contain_srfs = 0x55e093e4cdd7 [23:11:59.395] final_target_parallel_safe = true [23:11:59.395] current_rel = 0x55e096579f28 [23:11:59.395] final_rel = [23:11:59.395] extra = {limit_needed = 24, limit_tuples = 1.9762625833649862e-323, count_est = 94423083359000, offset_est = 0} [23:11:59.395] lc = [23:11:59.395] __func__ = "grouping_planner" [23:11:59.395] #6 0x000055e093e135d6 in subquery_planner (glob=glob@entry=0x55e096451f88, parse=parse@entry=0x55e096451d18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:11:59.395] root = 0x55e096579b18 [23:11:59.395] newWithCheckOptions = [23:11:59.395] newHaving = 0x0 [23:11:59.395] hasOuterJoins = [23:11:59.395] hasResultRTEs = false [23:11:59.395] final_rel = [23:11:59.395] l = 0x0 [23:11:59.395] #7 0x000055e093e1422b in standard_planner (parse=0x55e096451d18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [23:11:59.395] result = [23:11:59.395] glob = 0x55e096451f88 [23:11:59.395] tuple_fraction = 0 [23:11:59.395] root = [23:11:59.395] final_rel = [23:11:59.395] best_path = [23:11:59.395] top_plan = [23:11:59.395] lp = [23:11:59.395] lr = [23:11:59.395] #8 0x000055e093e152ef in planner (parse=parse@entry=0x55e096451d18, query_string=query_string@entry=0x55e096450260 "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/optimizer/plan/planner.c:280 [23:11:59.395] result = [23:11:59.395] #9 0x000055e09408594c in pg_plan_query (querytree=querytree@entry=0x55e096451d18, query_string=query_string@entry=0x55e096450260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [23:11:59.395] plan = [23:11:59.395] #10 0x000055e094085cb9 in pg_plan_queries (querytrees=0x55e09657e388, query_string=query_string@entry=0x55e096450260 "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:996 [23:11:59.395] query = 0x55e096451d18 [23:11:59.395] stmt = [23:11:59.395] query_list__state = {l = , i = } [23:11:59.395] stmt_list = 0x0 [23:11:59.395] query_list = [23:11:59.395] #11 0x000055e094086093 in exec_simple_query (query_string=query_string@entry=0x55e096450260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [23:11:59.395] cmdtaglen = 6 [23:11:59.395] snapshot_set = true [23:11:59.395] per_parsetree_context = 0x0 [23:11:59.395] plantree_list = [23:11:59.395] parsetree = 0x55e096451b88 [23:11:59.395] commandTag = CMDTAG_SELECT [23:11:59.395] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94423082140256} [23:11:59.395] querytree_list = [23:11:59.395] portal = [23:11:59.395] receiver = [23:11:59.395] format = 0 [23:11:59.395] cmdtagname = [23:11:59.395] parsetree_item__state = {l = , i = } [23:11:59.395] dest = DestRemote [23:11:59.395] oldcontext = 0x55e096478b70 [23:11:59.395] parsetree_list = 0x55e096451bb8 [23:11:59.395] parsetree_item = 0x55e096451bd0 [23:11:59.395] save_log_statement_stats = false [23:11:59.395] was_logged = false [23:11:59.395] use_implicit_block = false [23:11:59.395] msec_str = "\200\310?n\374\177\000\000\t\221\065\224\340U\000\000\260\306?n\374\177\000\000[\000\000\000\000\000\000" [23:11:59.395] __func__ = "exec_simple_query" [23:11:59.395] #12 0x000055e094088f93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [23:11:59.395] query_string = 0x55e096450260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [23:11:59.395] firstchar = [23:11:59.395] input_message = {data = 0x55e096450260 "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} [23:11:59.395] local_sigjmp_buf = {{__jmpbuf = {94423060058712, 8166840770716194584, 4, 140722158160000, 140722158160148, 1, 2697524230741251864, 8166842038581417752}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140619822554596, 94423082114800, 15616, 15680, 94423047689354, 94423060058720, 94423082114800, 94423060052792, 140722158160000, 140722158160148, 94423047693422, 140722158159776}}}} [23:11:59.395] send_ready_for_query = false [23:11:59.395] idle_in_transaction_timeout_enabled = false [23:11:59.395] idle_session_timeout_enabled = false [23:11:59.395] __func__ = "PostgresMain" [23:11:59.395] #13 0x000055e09407f74a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [23:11:59.395] bsdata = [23:11:59.395] #14 0x000055e093f29fed in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc6e3fc82c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc6e3fc880) at ../src/backend/postmaster/launch_backend.c:265 [23:11:59.395] pid = [23:11:59.395] #15 0x000055e093f3016d in BackendStartup (client_sock=client_sock@entry=0x7ffc6e3fc880) at ../src/backend/postmaster/postmaster.c:3593 [23:11:59.395] bn = 0x55e096478bf8 [23:11:59.395] pid = [23:11:59.395] startup_data = {canAcceptConnections = CAC_OK} [23:11:59.395] __func__ = "BackendStartup" [23:11:59.395] #16 0x000055e093f3071b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [23:11:59.395] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\247\232\344\177\000\000\001\000\000\000\000\000\000\000\244\363!\234\344\177\000\000-\000\000\000\000\000\000\000\020\036\213\232\344\177\000\000 \351Z\233\344\177\000\000H\311?n\374\177\000\000D\311?n\374\177\000\000\004\311?n\374\177\000\000@\216\000\000\001\000\000\000\000\000\000\000\340U\000\000\020\036\213\232\344\177\000\000\340?\212\232\344\177\000\000\352\177\247\232\344\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [23:11:59.395] i = 0 [23:11:59.395] now = [23:11:59.395] last_lockfile_recheck_time = 1711062487 [23:11:59.395] last_touch_time = 1711062487 [23:11:59.395] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1849674240, events = 32764, fd = 45, user_data = 0x7ffc6e3fc9c0}, {pos = 1849674192, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = -1688541304, user_data = 0x7fe49aa77fea}, {pos = 1849674408, events = 32764, fd = 1849674240, user_data = 0x7ffc6e3fca10}, {pos = -1675494175, events = 32740, fd = 18, user_data = 0x7fe498275618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1688542176, events = 32740, fd = -1, user_data = 0x7fe498275618}, {pos = -1688542176, events = 32740, fd = 1024, user_data = 0x7fe49b5ae788}, {pos = 0, events = 0, fd = 8, user_data = 0x7ffc6e3fca10}, {pos = -1, events = 0, fd = -1701434182, user_data = 0x7fe49a8a4418}, {pos = -1688540896, events = 32740, fd = -1773675512, user_data = 0x55e09647b708}, {pos = -1773708816, events = 21984, fd = -1773675480, user_data = 0x55e09647db61}, {pos = -1675475421, events = 32740, fd = 1, user_data = 0x7fe49aa910f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -1773854672, user_data = 0x7fe49c224623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x55e0964759f0}, {pos = -1702214632, events = 32740, fd = 1849675344, user_data = 0x7fe49c22b68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffc6e3fce70}, {pos = -1796001760, events = 21984, fd = 2, user_data = 0x55e094f33020 }, {pos = 0, events = 0, fd = 7, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x2ffff00001fa0}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -1773681768, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1734701663, user_data = 0xa5866574459442d}, {pos = 762540901, events = 1464097092, fd = 168450150, user_data = 0x30313137310a6174}, {pos = 942944822, events = 808716855, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = -1701696517, user_data = 0x400}, {pos = -1773871216, events = 21984, fd = -1700350848, user_data = 0x19644df90}, {pos = 784, events = 0, fd = -1806013460, user_data = 0x55e09647b3e0}, {pos = 1852123136, events = 1465987973, fd = 4, user_data = 0x55e09647c360}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55e09647b3e0}, {pos = 1, events = 0, fd = -1773685592, user_data = 0x400}, {pos = 0, events = 0, fd = -1808232914, user_data = 0x55e094f41210 }, {pos = -1808299238, events = 21984, fd = -1773685792, user_data = 0x55e096450160}, {pos = -1773685792, events = 21984, fd = 15, user_data = 0x4a}, {pos = -1808231146, events = 21984, fd = -1773685792, user_data = 0x55e094389658 }, {pos = -1773871216, events = 21984, fd = -1701696517, user_data = 0x0}, {pos = -1814778373, events = 21984, fd = -1773697184, user_data = 0x7fe49a91f1aa}, {pos = 1849675528, events = 1, fd = 0, user_data = 0x7fe49a91d8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 23865, user_data = 0x7fe49a967b05 }, {pos = 0, events = 0, fd = 1852123136, user_data = 0x0}, {pos = -1812816621, events = 21984, fd = 4194304, user_data = 0x55e0943789ae }, {pos = -1773697184, events = 21984, fd = -1773862560, user_data = 0x55e096478760}, {pos = 1, events = 0, fd = 0, user_data = 0x55e094389516 }, {pos = -1773697184, events = 21984, fd = -1808230824, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55e093d4a9ce }, {pos = 0, events = 0, fd = -1814755420, user_data = 0xb}, {pos = -1812795201, events = 21984, fd = 0, user_data = 0x0}} [23:11:59.396] nevents = 1 [23:11:59.396] __func__ = "ServerLoop" [23:11:59.396] #17 0x000055e093f3213d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55e096449e50) at ../src/backend/postmaster/postmaster.c:1372 [23:11:59.396] opt = [23:11:59.396] status = [23:11:59.396] userDoption = [23:11:59.396] listen_addr_saved = false [23:11:59.396] output_config_variable = [23:11:59.396] __func__ = "PostmasterMain" [23:11:59.396] #18 0x000055e093d5b7fe in main (argc=8, argv=0x55e096449e50) at ../src/backend/main/main.c:197 [23:11:59.396] do_check_root = [23:11:59.413] -e [23:11:59.413] [23:11:59.413] [23:11:59.977] dumping /tmp/cores/postgres-11-37388.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:12:00.292] [New LWP 37388] [23:12:01.469] [Thread debugging using libthread_db enabled] [23:12:01.469] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:12:02.914] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT '. [23:12:02.914] Program terminated with signal SIGSEGV, Segmentation fault. [23:12:02.914] #0 0x0000561a4f935cca in get_expr_width (root=root@entry=0x561a52a89038, expr=expr@entry=0x529dd078) at ../src/backend/optimizer/path/costsize.c:6329 [23:12:02.914] 6329 if (IsA(expr, Var)) [23:12:03.050] [23:12:03.050] Thread 1 (Thread 0x7fb9e5458a40 (LWP 37388)): [23:12:03.050] #0 0x0000561a4f935cca in get_expr_width (root=root@entry=0x561a52a89038, expr=expr@entry=0x529dd078) at ../src/backend/optimizer/path/costsize.c:6329 [23:12:03.050] width = [23:12:03.050] #1 0x0000561a4f9468e2 in set_pathtarget_cost_width (root=root@entry=0x561a52a89038, target=target@entry=0x561a529dd008) at ../src/backend/optimizer/path/costsize.c:6300 [23:12:03.050] node = 0x529dd078 [23:12:03.050] lc__state = {l = , i = } [23:12:03.050] tuple_width = 0 [23:12:03.050] lc = [23:12:03.050] #2 0x0000561a4f9a138b in make_group_input_target (root=root@entry=0x561a52a89038, final_target=final_target@entry=0x561a529dcf48) at ../src/backend/optimizer/plan/planner.c:5479 [23:12:03.050] parse = 0x561a52a95228 [23:12:03.050] input_target = 0x561a529dd008 [23:12:03.050] non_group_cols = 0x0 [23:12:03.050] non_group_vars = 0x0 [23:12:03.050] i = 3 [23:12:03.050] lc = 0x0 [23:12:03.050] #3 0x0000561a4f9b4732 in grouping_planner (root=root@entry=0x561a52a89038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:12:03.050] sort_input_targets = 0x561a52a8a7c0 [23:12:03.050] sort_input_target_parallel_safe = true [23:12:03.050] grouping_target = 0x561a529dcf48 [23:12:03.050] scanjoin_target = [23:12:03.050] activeWindows = 0x0 [23:12:03.050] qp_extra = {activeWindows = 0x0, gset_data = 0x561a52a8ad60} [23:12:03.050] sort_input_targets_contain_srfs = 0x561a4f9eaae0 [23:12:03.050] have_grouping = [23:12:03.050] wflists = 0x0 [23:12:03.050] gset_data = 0x561a52a8ad60 [23:12:03.050] sort_input_target = 0x561a529dcf48 [23:12:03.050] grouping_targets = 0x0 [23:12:03.050] grouping_target_parallel_safe = true [23:12:03.050] scanjoin_targets = 0x0 [23:12:03.050] scanjoin_target_parallel_safe = [23:12:03.050] grouping_targets_contain_srfs = 0x561a4f91281d [23:12:03.050] scanjoin_targets_contain_srfs = 0x561a52a970d0 [23:12:03.050] scanjoin_target_same_exprs = [23:12:03.050] parse = 0x561a52a95228 [23:12:03.050] offset_est = 0 [23:12:03.050] count_est = 0 [23:12:03.050] limit_tuples = -1 [23:12:03.050] have_postponed_srfs = false [23:12:03.050] final_target = 0x561a529dcf48 [23:12:03.050] final_targets = 0x0 [23:12:03.050] final_targets_contain_srfs = 0x561a4f9f0dd7 [23:12:03.050] final_target_parallel_safe = true [23:12:03.050] current_rel = 0x561a529db558 [23:12:03.050] final_rel = [23:12:03.050] extra = {limit_needed = 56, limit_tuples = 1.9762625833649862e-323, count_est = 94671055917112, offset_est = 0} [23:12:03.050] lc = [23:12:03.050] __func__ = "grouping_planner" [23:12:03.050] #4 0x0000561a4f9b75d6 in subquery_planner (glob=glob@entry=0x561a52989fd8, parse=parse@entry=0x561a52a95228, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:12:03.050] root = 0x561a52a89038 [23:12:03.050] newWithCheckOptions = [23:12:03.050] newHaving = 0x0 [23:12:03.050] hasOuterJoins = [23:12:03.050] hasResultRTEs = false [23:12:03.050] final_rel = [23:12:03.050] l = 0x0 [23:12:03.050] #5 0x0000561a4f9b822b in standard_planner (parse=parse@entry=0x561a52a95228, query_string=query_string@entry=0x561a529882c0 "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/optimizer/plan/planner.c:412 [23:12:03.050] result = [23:12:03.050] glob = 0x561a52989fd8 [23:12:03.050] tuple_fraction = 0 [23:12:03.050] root = [23:12:03.050] final_rel = [23:12:03.050] best_path = [23:12:03.050] top_plan = [23:12:03.050] lp = [23:12:03.050] lr = [23:12:03.050] #6 0x00007fb9e528559c in pgss_planner (parse=0x561a52a95228, query_string=0x561a529882c0 "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=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:926 [23:12:03.050] _save_exception_stack = 0x7fffcf67ee70 [23:12:03.050] _save_context_stack = 0x0 [23:12:03.050] _local_sigjmp_buf = {{__jmpbuf = {94671055966760, -8454750483999461031, 0, 2048, 0, 94671054865088, -2782790519409446567, -2743292114249944743}, __mask_was_saved = 0, __saved_mask = {__val = {140436385994280, 384, 94671054843472, 140736673082480, 1, 140736673082383, 140736673261397, 137, 6, 140436388171912, 94671009426270, 1711062535, 593194, 472, 94671010377349, 140436388171912}}}} [23:12:03.050] _do_rethrow = false [23:12:03.050] duration = {ticks = } [23:12:03.050] bufusage = {shared_blks_hit = 94671055916747, shared_blks_read = 94671055916745, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 94557999988736, local_blks_read = 8, local_blks_dirtied = 266, local_blks_written = 94671010708558, temp_blks_read = 0, temp_blks_written = 206158430232, shared_blk_read_time = {ticks = 140736673082336}, shared_blk_write_time = {ticks = 140736673082144}, local_blk_read_time = {ticks = 60}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 1199948501}, temp_blk_write_time = {ticks = 94671054843472}} [23:12:03.050] walusage_start = {wal_records = 1344, wal_fpi = 2, wal_bytes = 170221} [23:12:03.050] start = {ticks = } [23:12:03.050] bufusage_start = {shared_blks_hit = 6884, 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}} [23:12:03.050] walusage = {wal_records = 0, wal_fpi = 94671010458906, wal_bytes = 94671005264678} [23:12:03.050] result = 0x7fffcf67ebe0 [23:12:03.050] #7 0x0000561a4f9b92e5 in planner (parse=parse@entry=0x561a52a95228, query_string=query_string@entry=0x561a529882c0 "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/optimizer/plan/planner.c:278 [23:12:03.050] result = [23:12:03.050] #8 0x0000561a4fc2994c in pg_plan_query (querytree=querytree@entry=0x561a52a95228, query_string=query_string@entry=0x561a529882c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [23:12:03.050] plan = [23:12:03.050] #9 0x0000561a4fc29cb9 in pg_plan_queries (querytrees=0x561a52a88fe8, query_string=query_string@entry=0x561a529882c0 "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:996 [23:12:03.050] query = 0x561a52a95228 [23:12:03.050] stmt = [23:12:03.050] query_list__state = {l = , i = } [23:12:03.050] stmt_list = 0x0 [23:12:03.050] query_list = [23:12:03.050] #10 0x0000561a4fc2a093 in exec_simple_query (query_string=query_string@entry=0x561a529882c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;") at ../src/backend/tcop/postgres.c:1193 [23:12:03.050] cmdtaglen = 6 [23:12:03.050] snapshot_set = true [23:12:03.050] per_parsetree_context = 0x0 [23:12:03.050] plantree_list = [23:12:03.050] parsetree = 0x561a52989f58 [23:12:03.050] commandTag = CMDTAG_SELECT [23:12:03.050] qc = {commandTag = CMDTAG_DROP_ROLE, nprocessed = 94671054865088} [23:12:03.050] querytree_list = [23:12:03.050] portal = [23:12:03.050] receiver = [23:12:03.050] format = 0 [23:12:03.050] cmdtagname = [23:12:03.050] parsetree_item__state = {l = , i = } [23:12:03.050] dest = DestRemote [23:12:03.050] oldcontext = 0x561a529b3be0 [23:12:03.050] parsetree_list = 0x561a52989f88 [23:12:03.050] parsetree_item = 0x561a52989fa0 [23:12:03.050] save_log_statement_stats = false [23:12:03.050] was_logged = false [23:12:03.050] use_implicit_block = false [23:12:03.050] msec_str = " \360g\317\377\177\000\000\t\321\357O\032V\000\000P\356g\317\377\177\000\000\205\000\000\000\000\000\000" [23:12:03.050] __func__ = "exec_simple_query" [23:12:03.050] #11 0x0000561a4fc2cf93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [23:12:03.050] query_string = 0x561a529882c0 "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;" [23:12:03.050] firstchar = [23:12:03.050] input_message = {data = 0x561a529882c0 "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} [23:12:03.050] local_sigjmp_buf = {{__jmpbuf = {94671022740056, -8454745964062281383, 4, 140736673083424, 140736673083572, 1, -2782790519359114919, -8454791906485964455}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140436432809444, 94671054839632, 15616, 15680, 94671010370698, 94671022740064, 94671054839632, 94671022734136, 140736673083424, 140736673083572, 94671010374766, 140736673083200}}}} [23:12:03.050] send_ready_for_query = false [23:12:03.050] idle_in_transaction_timeout_enabled = false [23:12:03.050] idle_session_timeout_enabled = false [23:12:03.050] __func__ = "PostgresMain" [23:12:03.050] #12 0x0000561a4fc2374a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [23:12:03.050] bsdata = [23:12:03.050] #13 0x0000561a4facdfed in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffcf67efcc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffcf67f020) at ../src/backend/postmaster/launch_backend.c:265 [23:12:03.050] pid = [23:12:03.050] #14 0x0000561a4fad416d in BackendStartup (client_sock=client_sock@entry=0x7fffcf67f020) at ../src/backend/postmaster/postmaster.c:3593 [23:12:03.050] bn = 0x561a529b3e18 [23:12:03.050] pid = [23:12:03.050] startup_data = {canAcceptConnections = CAC_OK} [23:12:03.050] __func__ = "BackendStartup" [23:12:03.050] #15 0x0000561a4fad471b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [23:12:03.050] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\251\347\271\177\000\000 yy\350\271\177\000\000\310\360g\317\377\177\000\000\304\360g\317\377\177\000\000\000\000\000\000\377\177\000\000P\r\233R\032V\000\000\000\000\000\000\377\177\000\000\020\256\251\347\271\177\000\000\340Ϩ\347\271\177\000\000\352\017\306\347\271\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\304\360g\317\377\177\000\000P\r\233R\032V\000\000\220\361g\317\377\177\000", __ss_align = 140436434182944}, salen = 2}} [23:12:03.050] i = 0 [23:12:03.050] now = [23:12:03.050] last_lockfile_recheck_time = 1711062535 [23:12:03.050] last_touch_time = 1711062535 [23:12:03.050] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = -394692728, events = 32697, fd = -406450198, user_data = 0x7fffcf67f228}, {pos = -815271552, events = 32767, fd = -815271536, user_data = 0x7fb9e9408ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -448403944, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fb9e8797420}, {pos = -1, events = 0, fd = -448403944, user_data = 0x7fb9e8797420}, {pos = -394692320, events = 1, fd = -394692728, user_data = 0x0}, {pos = -815271552, events = 32767, fd = 1024, user_data = 0xffffffff}, {pos = -815271264, events = 32767, fd = -408366056, user_data = 0x7fb9e8797920}, {pos = 1385915528, events = 22042, fd = 1385901240, user_data = 0x561a529b2da0}, {pos = 1385915560, events = 22042, fd = 1385915361, user_data = 0x7fb9e940d623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = -406347528, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = 1385729488, events = 22042, fd = -381626845, user_data = 0x1}, {pos = 0, events = 0, fd = 1385901472, user_data = 0x7fb9e7a8d418}, {pos = -815270416, events = 32767, fd = -381598070, user_data = 0x0}, {pos = 0, events = 0, fd = -815270384, user_data = 0x561a50ad7020 }, {pos = 2, events = 0, fd = 1353543712, user_data = 0x0}, {pos = -407839322, events = 32697, fd = 1385938016, user_data = 0x7fb9e7c57be0}, {pos = 255, events = 0, fd = 8096, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x0}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -256, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1635021663, events = 1701668212, fd = 796095598, user_data = 0x6975622d69632d73}, {pos = 1647273068, events = 1684826485, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x561a52985ff0}, {pos = 1385717744, events = 22042, fd = -406505344, user_data = 0x7fb9e7b0651a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -407847941, user_data = 0x400}, {pos = 1385717744, events = 22042, fd = -406502272, user_data = 0x152985ff0}, {pos = 784, events = 0, fd = 1343532012, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x561a4ff1c873 }, {pos = 1385900432, events = 22042, fd = 1385900432, user_data = 0x561a529b2990}, {pos = 1, events = 0, fd = 1385900632, user_data = 0x400}, {pos = 0, events = 0, fd = 1341312558, user_data = 0x561a50ae5210 }, {pos = 1341246234, events = 22042, fd = 1385900432, user_data = 0x561a529881c0}, {pos = 1385900432, events = 22042, fd = 15, user_data = 0x4a}, {pos = 1341314326, events = 22042, fd = 1385900432, user_data = 0x561a4ff2d658 }, {pos = 1385717744, events = 22042, fd = -407847941, user_data = 0x0}, {pos = 1334767099, events = 22042, fd = 1385891824, user_data = 0x7fb9e7b081aa}, {pos = -815270232, events = 1, fd = 0, user_data = 0x7fb9e7b068f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 37331, user_data = 0x7fb9e7b50b05 }, {pos = 0, events = 0, fd = 2098417664, user_data = 0x0}, {pos = 1336728851, events = 22042, fd = 4194304, user_data = 0x561a4ff1c9ae }, {pos = 1385891824, events = 22042, fd = 1385726400, user_data = 0x561a529b07f0}, {pos = 1, events = 0, fd = 0, user_data = 0x561a4ff2d516 }, {pos = 1385891824, events = 22042, fd = 1341314648, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x561a4f8ee9ce }, {pos = 0, events = 0, fd = 1334790052, user_data = 0xb}, {pos = 1336750271, events = 22042, fd = 0, user_data = 0x0}} [23:12:03.050] nevents = 1 [23:12:03.050] __func__ = "ServerLoop" [23:12:03.050] #16 0x0000561a4fad613d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x561a52981ea0) at ../src/backend/postmaster/postmaster.c:1372 [23:12:03.050] opt = [23:12:03.050] status = [23:12:03.050] userDoption = [23:12:03.050] listen_addr_saved = false [23:12:03.050] output_config_variable = [23:12:03.050] __func__ = "PostmasterMain" [23:12:03.050] #17 0x0000561a4f8ff7fe in main (argc=8, argv=0x561a52981ea0) at ../src/backend/main/main.c:197 [23:12:03.050] do_check_root = [23:12:03.068] -e [23:12:03.068] [23:12:03.068] [23:12:03.612] dumping /tmp/cores/postgres-11-37743.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:12:03.924] [New LWP 37743] [23:12:05.080] [Thread debugging using libthread_db enabled] [23:12:05.080] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:12:07.220] Downloading separate debug info for /lib/x86_64-linux-gnu/libnss_files.so.2... [23:12:07.708] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN '. [23:12:07.708] Program terminated with signal SIGSEGV, Segmentation fault. [23:12:07.708] #0 0x0000563e07ce3fe6 in equal (a=0x9b7cfc8, b=b@entry=0x563e09b525b8) at ../src/backend/nodes/equalfuncs.c:239 [23:12:07.708] 239 if (nodeTag(a) != nodeTag(b)) [23:12:07.881] [23:12:07.881] Thread 1 (Thread 0x7f0e0f239a40 (LWP 37743)): [23:12:07.881] #0 0x0000563e07ce3fe6 in equal (a=0x9b7cfc8, b=b@entry=0x563e09b525b8) at ../src/backend/nodes/equalfuncs.c:239 [23:12:07.881] retval = [23:12:07.881] __func__ = "equal" [23:12:07.881] #1 0x0000563e0761bb29 in list_member (list=0x563e09b7d038, datum=datum@entry=0x563e09b525b8) at ../src/backend/nodes/list.c:670 [23:12:07.881] cell__state = {l = , i = } [23:12:07.881] cell = [23:12:07.881] #2 0x0000563e0774002d in add_new_column_to_pathtarget (target=target@entry=0x563e09b7cf58, expr=0x563e09b525b8) at ../src/backend/optimizer/util/tlist.c:743 [23:12:07.881] No locals. [23:12:07.881] #3 0x0000563e077400c8 in add_new_columns_to_pathtarget (target=target@entry=0x563e09b7cf58, exprs=exprs@entry=0x563e09b7d0d8) at ../src/backend/optimizer/util/tlist.c:760 [23:12:07.881] expr = [23:12:07.881] lc__state = {l = , i = } [23:12:07.881] lc = [23:12:07.881] #4 0x0000563e076b8370 in make_group_input_target (root=root@entry=0x563e09b51ec8, final_target=final_target@entry=0x563e09b7ceb8) at ../src/backend/optimizer/plan/planner.c:5472 [23:12:07.881] parse = 0x563e09a0e920 [23:12:07.881] input_target = 0x563e09b7cf58 [23:12:07.881] non_group_cols = 0x563e09b7d088 [23:12:07.881] non_group_vars = 0x563e09b7d0d8 [23:12:07.881] i = 2 [23:12:07.881] lc = 0x0 [23:12:07.881] #5 0x0000563e076cb732 in grouping_planner (root=root@entry=0x563e09b51ec8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:12:07.881] sort_input_targets = 0x563e09b523e8 [23:12:07.881] sort_input_target_parallel_safe = true [23:12:07.881] grouping_target = 0x563e09b7ceb8 [23:12:07.881] scanjoin_target = [23:12:07.881] activeWindows = 0x0 [23:12:07.881] qp_extra = {activeWindows = 0x0, gset_data = 0x563e09b41758} [23:12:07.881] sort_input_targets_contain_srfs = 0x563e09b416b8 [23:12:07.881] have_grouping = [23:12:07.881] wflists = 0x0 [23:12:07.881] gset_data = 0x563e09b41758 [23:12:07.881] sort_input_target = 0x563e09b7ceb8 [23:12:07.881] grouping_targets = 0x563e09b51ec8 [23:12:07.881] grouping_target_parallel_safe = true [23:12:07.881] scanjoin_targets = 0x1 [23:12:07.881] scanjoin_target_parallel_safe = [23:12:07.881] grouping_targets_contain_srfs = 0x563e07c45d1a [23:12:07.881] scanjoin_targets_contain_srfs = 0x563e0761a924 [23:12:07.881] scanjoin_target_same_exprs = [23:12:07.881] parse = 0x563e09a0e920 [23:12:07.881] offset_est = 0 [23:12:07.881] count_est = 0 [23:12:07.881] limit_tuples = -1 [23:12:07.881] have_postponed_srfs = false [23:12:07.881] final_target = 0x563e09b7ceb8 [23:12:07.881] final_targets = 0x563e09a5e588 [23:12:07.881] final_targets_contain_srfs = 0x563e076208ae [23:12:07.881] final_target_parallel_safe = true [23:12:07.881] current_rel = 0x563e09b39b68 [23:12:07.881] final_rel = [23:12:07.881] extra = {limit_needed = false, limit_tuples = 4.6849484258584592e-310, count_est = 94824450758328, offset_est = 94824450758328} [23:12:07.881] lc = [23:12:07.881] __func__ = "grouping_planner" [23:12:07.881] #6 0x0000563e076ce5d6 in subquery_planner (glob=glob@entry=0x563e09b39a58, parse=parse@entry=0x563e09a0e920, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:12:07.881] root = 0x563e09b51ec8 [23:12:07.881] newWithCheckOptions = [23:12:07.881] newHaving = 0x0 [23:12:07.881] hasOuterJoins = [23:12:07.881] hasResultRTEs = false [23:12:07.881] final_rel = [23:12:07.881] l = 0x0 [23:12:07.881] #7 0x0000563e076cf22b in standard_planner (parse=0x563e09a0e920, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [23:12:07.881] result = [23:12:07.881] glob = 0x563e09b39a58 [23:12:07.881] tuple_fraction = 0 [23:12:07.881] root = [23:12:07.881] final_rel = [23:12:07.881] best_path = [23:12:07.881] top_plan = [23:12:07.881] lp = [23:12:07.881] lr = [23:12:07.881] #8 0x0000563e076d02ef in planner (parse=parse@entry=0x563e09a0e920, query_string=query_string@entry=0x563e09a0d270 "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/optimizer/plan/planner.c:280 [23:12:07.881] result = [23:12:07.881] #9 0x0000563e0794094c in pg_plan_query (querytree=querytree@entry=0x563e09a0e920, query_string=query_string@entry=0x563e09a0d270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [23:12:07.881] plan = [23:12:07.881] #10 0x0000563e0742b7d0 in standard_ExplainOneQuery (query=0x563e09a0e920, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x563e09b5fa18, queryString=0x563e09a0d270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:440 [23:12:07.881] plan = [23:12:07.881] planstart = {ticks = } [23:12:07.881] planduration = {ticks = 94824449501472} [23:12:07.881] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94824407122776, shared_blks_dirtied = 94824449501744, shared_blks_written = 70368744194107, local_blks_hit = 0, local_blks_read = 94824408488669, local_blks_dirtied = 94824449501744, local_blks_written = 94824414345045, temp_blks_read = 1, temp_blks_written = 2048, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94824287961088}, local_blk_read_time = {ticks = 94824449501200}, local_blk_write_time = {ticks = 94824418270490}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94824411801892}} [23:12:07.881] bufusage = {shared_blks_hit = 94824450726328, shared_blks_read = 1, shared_blks_dirtied = 0, shared_blks_written = 1, local_blks_hit = 0, local_blks_read = 94824414866222, local_blks_dirtied = 70622147264512, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 16443, shared_blk_read_time = {ticks = 139698207041512}, shared_blk_write_time = {ticks = 94824450726328}, local_blk_read_time = {ticks = 94824449501472}, local_blk_write_time = {ticks = 94824417786560}, temp_blk_read_time = {ticks = 139698207041512}, temp_blk_write_time = {ticks = 94824417786579}} [23:12:07.881] mem_counters = {nblocks = 0, freechunks = 1, totalspace = 0, freespace = 94824418010224} [23:12:07.881] planner_ctx = 0x0 [23:12:07.881] saved_ctx = 0x0 [23:12:07.881] #11 0x0000563e0742ba68 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x563e09b5fa18, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:396 [23:12:07.881] No locals. [23:12:07.881] #12 0x0000563e0742d05f in ExplainQuery (pstate=pstate@entry=0x563e09b5f908, stmt=stmt@entry=0x563e09a0e760, params=params@entry=0x0, dest=dest@entry=0x563e09b5f878) at ../src/include/nodes/nodes.h:172 [23:12:07.881] l__state = {l = , i = } [23:12:07.881] l = 0x563e09b39a20 [23:12:07.881] es = 0x563e09b5fa18 [23:12:07.881] tstate = [23:12:07.881] jstate = [23:12:07.881] query = [23:12:07.881] rewritten = 0x563e09b39a08 [23:12:07.881] lc = 0x0 [23:12:07.881] timing_set = false [23:12:07.881] summary_set = false [23:12:07.881] __func__ = "ExplainQuery" [23:12:07.881] #13 0x0000563e0794b35a in standard_ProcessUtility (pstmt=0x563e09a0e810, queryString=0x563e09a0d270 "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=0x0, queryEnv=0x0, dest=0x563e09b5f878, qc=0x7ffe5f8c9ef0) at ../src/backend/tcop/utility.c:863 [23:12:07.881] parsetree = 0x563e09a0e760 [23:12:07.881] isTopLevel = true [23:12:07.881] isAtomicContext = false [23:12:07.881] pstate = 0x563e09b5f908 [23:12:07.881] readonly_flags = [23:12:07.881] __func__ = "standard_ProcessUtility" [23:12:07.881] #14 0x0000563e0794ba83 in ProcessUtility (pstmt=pstmt@entry=0x563e09a0e810, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x563e09b5f878, qc=0x7ffe5f8c9ef0) at ../src/backend/tcop/utility.c:523 [23:12:07.881] No locals. [23:12:07.881] #15 0x0000563e079471e1 in PortalRunUtility (portal=portal@entry=0x563e09a89f90, pstmt=0x563e09a0e810, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x563e09b5f878, qc=qc@entry=0x7ffe5f8c9ef0) at ../src/backend/tcop/pquery.c:1158 [23:12:07.881] No locals. [23:12:07.881] #16 0x0000563e07947bc4 in FillPortalStore (portal=portal@entry=0x563e09a89f90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [23:12:07.881] treceiver = 0x563e09b5f878 [23:12:07.881] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:12:07.881] __func__ = "FillPortalStore" [23:12:07.881] #17 0x0000563e07948246 in PortalRun (portal=portal@entry=0x563e09a89f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x563e09a5e948, altdest=altdest@entry=0x563e09a5e948, qc=0x7ffe5f8ca0d0) at ../src/backend/tcop/pquery.c:763 [23:12:07.881] _save_exception_stack = 0x7ffe5f8ca180 [23:12:07.881] _save_context_stack = 0x0 [23:12:07.881] _local_sigjmp_buf = {{__jmpbuf = {1, 1314621309026108690, 94824449829192, 94824449501144, 94824450006928, 94824449501072, -1314270417721424622, -4737093886025988846}, __mask_was_saved = 0, __saved_mask = {__val = {94824450018488, 94824421017662, 94824450015136, 94824421017662, 1, 140730501472351, 94824449501120, 94824449501072, 94824418010224, 94824420604201, 94824450006928, 94824421017662, 1, 1, 94824418270892, 153}}}} [23:12:07.881] _do_rethrow = [23:12:07.881] result = [23:12:07.881] nprocessed = [23:12:07.881] saveTopTransactionResourceOwner = 0x563e09a48c58 [23:12:07.881] saveTopTransactionContext = 0x563e09a35b80 [23:12:07.881] saveActivePortal = 0x0 [23:12:07.881] saveResourceOwner = 0x563e09a48c58 [23:12:07.881] savePortalContext = 0x0 [23:12:07.881] saveMemoryContext = 0x563e09a35b80 [23:12:07.881] __func__ = "PortalRun" [23:12:07.881] #18 0x0000563e079411db in exec_simple_query (query_string=query_string@entry=0x563e09a0d270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;") at ../src/backend/tcop/postgres.c:1274 [23:12:07.881] cmdtaglen = 7 [23:12:07.881] snapshot_set = [23:12:07.881] per_parsetree_context = 0x0 [23:12:07.881] plantree_list = 0x563e09a5e8f8 [23:12:07.881] parsetree = 0x563e09a0e790 [23:12:07.881] commandTag = [23:12:07.881] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:12:07.881] querytree_list = [23:12:07.881] portal = 0x563e09a89f90 [23:12:07.881] receiver = 0x563e09a5e948 [23:12:07.881] format = 0 [23:12:07.881] cmdtagname = [23:12:07.881] parsetree_item__state = {l = , i = } [23:12:07.881] dest = DestRemote [23:12:07.881] oldcontext = 0x563e09a35b80 [23:12:07.881] parsetree_list = 0x563e09a0e7c0 [23:12:07.881] parsetree_item = 0x563e09a0e7d8 [23:12:07.881] save_log_statement_stats = false [23:12:07.881] was_logged = false [23:12:07.881] use_implicit_block = false [23:12:07.881] msec_str = "0\243\214_\376\177\000\000\tA\301\a>V\000\000`\241\214_\376\177\000\000q\000\000\000\000\000\000" [23:12:07.881] __func__ = "exec_simple_query" [23:12:07.881] #19 0x0000563e07943f93 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [23:12:07.881] query_string = 0x563e09a0d270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [23:12:07.881] firstchar = [23:12:07.881] input_message = {data = 0x563e09a0d270 "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} [23:12:07.881] local_sigjmp_buf = {{__jmpbuf = {94824430551640, -4737107438415051502, 4, 140730501473072, 140730501473220, 1, -1314270417398463214, -4737093883815459566}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 139698400853476, 94824449470208, 15616, 15680, 94824418182282, 94824430551648, 94824449470208, 94824430545720, 140730501473072, 140730501473220, 94824418186350, 140730501472848}}}} [23:12:07.881] send_ready_for_query = false [23:12:07.881] idle_in_transaction_timeout_enabled = false [23:12:07.881] idle_session_timeout_enabled = false [23:12:07.881] __func__ = "PostgresMain" [23:12:07.881] #20 0x0000563e0793a74a in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [23:12:07.881] bsdata = [23:12:07.881] #21 0x0000563e077e4fed in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe5f8ca2dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe5f8ca330) at ../src/backend/postmaster/launch_backend.c:265 [23:12:07.881] pid = [23:12:07.881] #22 0x0000563e077eb16d in BackendStartup (client_sock=client_sock@entry=0x7ffe5f8ca330) at ../src/backend/postmaster/postmaster.c:3593 [23:12:07.881] bn = 0x563e09a35c58 [23:12:07.881] pid = [23:12:07.881] startup_data = {canAcceptConnections = CAC_OK} [23:12:07.881] __func__ = "BackendStartup" [23:12:07.881] #23 0x0000563e077eb71b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [23:12:07.881] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000\210\273\206\021\016\177\000\000 \363\243\021\016\177\000\000\001\000\000\000\000\000\000\000\244\223\036\023\016\177\000\000-\000\000\000\000\000\000\000\020\276\207\021\016\177\000\000 \211W\022\016\177\000\000\b\244\214_\376\177\000\000\004\244\214_\376\177\000\000`\211\243\t>V", '\000' , "\020\276\207\021\016\177\000\000\340߆\021\016\177\000", __ss_align = 139698402238442}, salen = 2}} [23:12:07.881] i = 0 [23:12:07.881] now = [23:12:07.881] last_lockfile_recheck_time = 1711062536 [23:12:07.881] last_touch_time = 1711062536 [23:12:07.881] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1603052752, events = 32766, fd = 295957280, user_data = 0x7ffe5f8ca4c0}, {pos = 45, events = 0, fd = 320909696, user_data = 0x5f8ca490}, {pos = 0, events = 0, fd = 320909696, user_data = 0x59e7c8ee}, {pos = 307726216, events = 32526, fd = 295968746, user_data = 0x7ffe5f8ca568}, {pos = 1603052736, events = 32766, fd = 1603052752, user_data = 0x7f0e131e9ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = 254015000, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f0e12578420}, {pos = 1603052688, events = 32766, fd = 254015000, user_data = 0x7f0e12578420}, {pos = 135465120, events = 1, fd = 307726216, user_data = 0x0}, {pos = 161688064, events = 22078, fd = 161721400, user_data = 0xffffffff}, {pos = 320792099, events = 32526, fd = 294052888, user_data = 0x7f0e12578920}, {pos = 161721368, events = 22078, fd = 294099448, user_data = 0x7ffe5f8ca8b0}, {pos = 320820874, events = 32526, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = 296071416, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = 161542208, events = 22078, fd = 320792099, user_data = 0x1}, {pos = 0, events = 0, fd = 161721192, user_data = 0x7f0e1186e418}, {pos = 1603053824, events = 32766, fd = 320820874, user_data = 0x0}, {pos = 0, events = 0, fd = 1603053856, user_data = 0x563e087ee020 }, {pos = 2, events = 0, fd = 142532640, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 8096, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x2020206c6c612020}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 161715112, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 161525664, user_data = 0x563e09a0afa0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1882157165, events = 1701994343, fd = 1936028263, user_data = 0x566874712d737365}, {pos = 168457315, events = 924852256, fd = 822763892, user_data = 0x30340a3633353236}, {pos = 1735684975, events = 1601398130, fd = 796353638, user_data = 0x2d7375727269632f}, {pos = 1647143267, events = 1684826485, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x400}, {pos = 161525664, events = 22078, fd = 295916672, user_data = 0x109a0afa0}, {pos = 784, events = 0, fd = 132520940, user_data = 0x563e09a383f0}, {pos = 1748407808, events = 4224987510, fd = 4, user_data = 0x563e09a39370}, {pos = 161711088, events = 22078, fd = 161711288, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 161711288, user_data = 0x400}, {pos = 0, events = 0, fd = 130301486, user_data = 0x563e087fc210 }, {pos = 130235162, events = 22078, fd = 161711088, user_data = 0x563e09a0d170}, {pos = 161711088, events = 22078, fd = 15, user_data = 0x4a}, {pos = 130303254, events = 22078, fd = 161711088, user_data = 0x563e07c44658 }, {pos = 161525664, events = 22078, fd = 294571003, user_data = 0x0}, {pos = 123756027, events = 22078, fd = 161699696, user_data = 0x7f0e118e91aa}, {pos = 1603054008, events = 1, fd = 0, user_data = 0x7f0e118e78f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 37615, user_data = 0x7f0e11931b05 }, {pos = 0, events = 0, fd = 1748407808, user_data = 0x0}, {pos = 125717779, events = 22078, fd = 4194304, user_data = 0x563e07c339ae }, {pos = 161699696, events = 22078, fd = 161534320, user_data = 0x563e09a35770}, {pos = 1, events = 0, fd = 0, user_data = 0x563e07c44516 }, {pos = 161699696, events = 22078, fd = 130303576, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x563e076059ce }, {pos = 0, events = 0, fd = 123778980, user_data = 0xb}, {pos = 125739199, events = 22078, fd = 0, user_data = 0x0}} [23:12:07.882] nevents = 1 [23:12:07.882] __func__ = "ServerLoop" [23:12:07.882] #24 0x0000563e077ed13d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x563e09a06e60) at ../src/backend/postmaster/postmaster.c:1372 [23:12:07.882] opt = [23:12:07.882] status = [23:12:07.882] userDoption = [23:12:07.882] listen_addr_saved = false [23:12:07.882] output_config_variable = [23:12:07.882] __func__ = "PostmasterMain" [23:12:07.882] #25 0x0000563e076167fe in main (argc=8, argv=0x563e09a06e60) at ../src/backend/main/main.c:197 [23:12:07.882] do_check_root =