[00:11:52.379] src/tools/ci/cores_backtrace.sh linux /tmp/cores [00:11:53.135] dumping /tmp/cores/postgres-11-29410.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:11:54.808] [New LWP 29410] [00:11:54.808] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [00:11:55.568] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [00:11:56.330] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [00:11:57.560] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [00:11:59.953] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [00:11:59.953] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [00:12:01.836] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [00:12:03.067] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [00:12:04.649] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [00:12:05.713] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [00:12:06.476] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [00:12:07.706] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [00:12:09.314] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [00:12:10.715] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [00:12:11.623] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [00:12:13.158] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [00:12:14.545] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [00:12:15.013] [Thread debugging using libthread_db enabled] [00:12:15.013] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:12:16.076] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [00:12:17.467] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [00:12:18.530] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [00:12:19.143] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [00:12:19.908] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [00:12:22.180] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [00:12:23.112] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [00:12:23.872] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [00:12:24.783] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [00:12:25.700] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [00:12:27.285] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [00:12:28.349] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [00:12:29.117] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [00:12:30.503] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [00:12:31.118] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [00:12:32.641] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [00:12:33.402] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [00:12:34.627] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [00:12:35.394] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [00:12:36.459] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [00:12:37.378] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [00:12:38.598] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [00:12:39.214] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [00:12:40.133] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [00:12:40.907] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [00:12:41.995] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [00:12:41.995] Program terminated with signal SIGSEGV, Segmentation fault. [00:12:41.995] #0 0x000055c02251cec7 in equal (a=0x246bd180, b=b@entry=0x55c0246ee688) at ../src/backend/nodes/equalfuncs.c:239 [00:12:41.995] 239 if (nodeTag(a) != nodeTag(b)) [00:12:42.196] [00:12:42.196] Thread 1 (Thread 0x7fc9e1dcaa40 (LWP 29410)): [00:12:42.196] #0 0x000055c02251cec7 in equal (a=0x246bd180, b=b@entry=0x55c0246ee688) at ../src/backend/nodes/equalfuncs.c:239 [00:12:42.196] retval = [00:12:42.196] __func__ = "equal" [00:12:42.196] #1 0x000055c021e5e396 in list_member (list=0x55c0246bd1f0, datum=datum@entry=0x55c0246ee688) at ../src/backend/nodes/list.c:670 [00:12:42.196] cell__state = {l = , i = } [00:12:42.196] cell = [00:12:42.196] #2 0x000055c021f81ab6 in add_new_column_to_pathtarget (target=target@entry=0x55c0246bd110, expr=0x55c0246ee688) at ../src/backend/optimizer/util/tlist.c:743 [00:12:42.196] No locals. [00:12:42.196] #3 0x000055c021f81b51 in add_new_columns_to_pathtarget (target=target@entry=0x55c0246bd110, exprs=exprs@entry=0x55c0246bd2a8) at ../src/backend/optimizer/util/tlist.c:760 [00:12:42.196] expr = [00:12:42.196] lc__state = {l = , i = } [00:12:42.196] lc = [00:12:42.196] #4 0x000055c021efa155 in make_group_input_target (root=root@entry=0x55c0246edf98, final_target=final_target@entry=0x55c0246bd028) at ../src/backend/optimizer/plan/planner.c:5472 [00:12:42.196] parse = 0x55c02459d788 [00:12:42.196] input_target = 0x55c0246bd110 [00:12:42.196] non_group_cols = 0x55c0246bd258 [00:12:42.196] non_group_vars = 0x55c0246bd2a8 [00:12:42.196] i = 2 [00:12:42.196] lc = 0x0 [00:12:42.196] #5 0x000055c021f0d517 in grouping_planner (root=root@entry=0x55c0246edf98, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:12:42.196] sort_input_targets = 0x55c0246ee4b8 [00:12:42.196] sort_input_target_parallel_safe = true [00:12:42.196] grouping_target = 0x55c0246bd028 [00:12:42.196] scanjoin_target = [00:12:42.196] activeWindows = 0x0 [00:12:42.196] qp_extra = {activeWindows = 0x0, gset_data = 0x55c0246f1768} [00:12:42.196] sort_input_targets_contain_srfs = 0x55c021f4398d [00:12:42.196] have_grouping = [00:12:42.196] wflists = 0x0 [00:12:42.196] gset_data = 0x55c0246f1768 [00:12:42.196] sort_input_target = 0x55c0246bd028 [00:12:42.196] grouping_targets = 0x0 [00:12:42.196] grouping_target_parallel_safe = true [00:12:42.196] scanjoin_targets = 0x0 [00:12:42.196] scanjoin_target_parallel_safe = [00:12:42.196] grouping_targets_contain_srfs = 0x55c021e6bae2 [00:12:42.196] scanjoin_targets_contain_srfs = 0x0 [00:12:42.196] scanjoin_target_same_exprs = [00:12:42.196] parse = 0x55c02459d788 [00:12:42.196] offset_est = 0 [00:12:42.196] count_est = 0 [00:12:42.196] limit_tuples = -1 [00:12:42.196] have_postponed_srfs = false [00:12:42.196] final_target = 0x55c0246bd028 [00:12:42.196] final_targets = 0x55c02467ef68 [00:12:42.196] final_targets_contain_srfs = 0x55c021f439c2 [00:12:42.196] final_target_parallel_safe = true [00:12:42.196] current_rel = 0x55c0246edd48 [00:12:42.196] final_rel = [00:12:42.196] extra = {limit_needed = 152, limit_tuples = 4.9406564584124654e-324, count_est = 94283733327768, offset_est = 1} [00:12:42.196] lc = [00:12:42.196] __func__ = "grouping_planner" [00:12:42.196] #6 0x000055c021f103bb in subquery_planner (glob=glob@entry=0x55c0246edc38, parse=parse@entry=0x55c02459d788, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:12:42.196] root = 0x55c0246edf98 [00:12:42.196] newWithCheckOptions = [00:12:42.196] newHaving = 0x0 [00:12:42.196] hasOuterJoins = [00:12:42.196] hasResultRTEs = false [00:12:42.196] final_rel = [00:12:42.196] l = 0x0 [00:12:42.196] #7 0x000055c021f11010 in standard_planner (parse=0x55c02459d788, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [00:12:42.196] result = [00:12:42.196] glob = 0x55c0246edc38 [00:12:42.196] tuple_fraction = 0 [00:12:42.196] root = [00:12:42.196] final_rel = [00:12:42.196] best_path = [00:12:42.196] top_plan = [00:12:42.196] lp = [00:12:42.196] lr = [00:12:42.196] #8 0x000055c021f120d4 in planner (parse=parse@entry=0x55c02459d788, query_string=query_string@entry=0x55c02459c260 "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 [00:12:42.196] result = [00:12:42.196] #9 0x000055c0221806a7 in pg_plan_query (querytree=querytree@entry=0x55c02459d788, query_string=query_string@entry=0x55c02459c260 "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 [00:12:42.196] plan = [00:12:42.196] #10 0x000055c021c71822 in standard_ExplainOneQuery (query=0x55c02459d788, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55c0245c7318, queryString=0x55c02459c260 "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:441 [00:12:42.196] plan = [00:12:42.196] planstart = {ticks = } [00:12:42.196] planduration = {ticks = 94283731949448} [00:12:42.196] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94283686171480, shared_blks_dirtied = 0, shared_blks_written = 70368744214847, local_blks_hit = 94283731949720, local_blks_read = 94283687493197, local_blks_dirtied = 140732199127806, local_blks_written = 94283693331329, temp_blks_read = 1, temp_blks_written = 140504901376528, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94283122081792}, local_blk_read_time = {ticks = 94283732871640}, local_blk_write_time = {ticks = 94283697228215}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94283690791313}} [00:12:42.196] bufusage = {shared_blks_hit = 140732199127805, shared_blks_read = 94283693415988, shared_blks_dirtied = 0, shared_blks_written = 4294967297, local_blks_hit = 0, local_blks_read = 94283122081802, local_blks_dirtied = 159699768983552, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 37183, shared_blk_read_time = {ticks = 140504901376528}, shared_blk_write_time = {ticks = 94283731950536}, local_blk_read_time = {ticks = 94283731949448}, local_blk_write_time = {ticks = 94283696745868}, temp_blk_read_time = {ticks = 140504901376528}, temp_blk_write_time = {ticks = 94283696745887}} [00:12:42.196] mem_counters = {nblocks = 94283731949720, freechunks = 140732199127816, totalspace = 140732199127808, freespace = 94283731949448} [00:12:42.196] planner_ctx = 0x0 [00:12:42.196] saved_ctx = 0x0 [00:12:42.196] #11 0x000055c021c71aba in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55c0245c7318, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:397 [00:12:42.196] No locals. [00:12:42.196] #12 0x000055c021c730b1 in ExplainQuery (pstate=pstate@entry=0x55c0245c7208, stmt=stmt@entry=0x55c02459d5c8, params=params@entry=0x0, dest=dest@entry=0x55c0245c7178) at ../src/include/nodes/nodes.h:172 [00:12:42.196] l__state = {l = , i = } [00:12:42.196] l = 0x55c0246edc00 [00:12:42.196] es = 0x55c0245c7318 [00:12:42.196] tstate = [00:12:42.196] jstate = [00:12:42.196] query = [00:12:42.196] rewritten = 0x55c0246edbe8 [00:12:42.196] lc = 0x0 [00:12:42.196] timing_set = false [00:12:42.196] summary_set = false [00:12:42.196] __func__ = "ExplainQuery" [00:12:42.196] #13 0x000055c02218b0b5 in standard_ProcessUtility (pstmt=0x55c02459d678, queryString=0x55c02459c260 "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=0x55c0245c7178, qc=0x7ffec4bcccf0) at ../src/backend/tcop/utility.c:863 [00:12:42.196] parsetree = 0x55c02459d5c8 [00:12:42.196] isTopLevel = true [00:12:42.196] isAtomicContext = false [00:12:42.196] pstate = 0x55c0245c7208 [00:12:42.196] readonly_flags = [00:12:42.196] __func__ = "standard_ProcessUtility" [00:12:42.196] #14 0x000055c02218b7de in ProcessUtility (pstmt=pstmt@entry=0x55c02459d678, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55c0245c7178, qc=0x7ffec4bcccf0) at ../src/backend/tcop/utility.c:523 [00:12:42.196] No locals. [00:12:42.196] #15 0x000055c022186f3c in PortalRunUtility (portal=portal@entry=0x55c02461cf90, pstmt=0x55c02459d678, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55c0245c7178, qc=qc@entry=0x7ffec4bcccf0) at ../src/backend/tcop/pquery.c:1158 [00:12:42.196] No locals. [00:12:42.196] #16 0x000055c02218791f in FillPortalStore (portal=portal@entry=0x55c02461cf90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [00:12:42.196] treceiver = 0x55c0245c7178 [00:12:42.196] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:12:42.196] __func__ = "FillPortalStore" [00:12:42.196] #17 0x000055c022187fa1 in PortalRun (portal=portal@entry=0x55c02461cf90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55c02467f328, altdest=altdest@entry=0x55c02467f328, qc=0x7ffec4bcced0) at ../src/backend/tcop/pquery.c:763 [00:12:42.196] _save_exception_stack = 0x7ffec4bccf80 [00:12:42.196] _save_context_stack = 0x0 [00:12:42.196] _local_sigjmp_buf = {{__jmpbuf = {1, 8565941011311462635, 94283732874024, 94283731949120, 94283732471696, 94283731949048, -8566448410785511189, -2494974643444152085}, __mask_was_saved = 0, __saved_mask = {__val = {94283732483256, 94283699944990, 94283732479904, 94283699944990, 1, 140732199128671, 94283731949096, 94283731949048, 94283696969306, 94283699534035, 94283732471696, 94283699944990, 1, 1, 94283697228617, 153}}}} [00:12:42.196] _do_rethrow = [00:12:42.196] result = [00:12:42.196] nprocessed = [00:12:42.196] saveTopTransactionResourceOwner = 0x55c0245dbce8 [00:12:42.196] saveTopTransactionContext = 0x55c024686520 [00:12:42.196] saveActivePortal = 0x0 [00:12:42.196] saveResourceOwner = 0x55c0245dbce8 [00:12:42.196] savePortalContext = 0x0 [00:12:42.196] saveMemoryContext = 0x55c024686520 [00:12:42.196] __func__ = "PortalRun" [00:12:42.196] #18 0x000055c022180f36 in exec_simple_query (query_string=query_string@entry=0x55c02459c260 "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 [00:12:42.196] cmdtaglen = 7 [00:12:42.196] snapshot_set = [00:12:42.196] per_parsetree_context = 0x0 [00:12:42.196] plantree_list = 0x55c02467f2d8 [00:12:42.196] parsetree = 0x55c02459d5f8 [00:12:42.196] commandTag = [00:12:42.196] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:12:42.196] querytree_list = [00:12:42.196] portal = 0x55c02461cf90 [00:12:42.196] receiver = 0x55c02467f328 [00:12:42.196] format = 0 [00:12:42.196] cmdtagname = [00:12:42.196] parsetree_item__state = {l = , i = } [00:12:42.196] dest = DestRemote [00:12:42.196] oldcontext = 0x55c024686520 [00:12:42.196] parsetree_list = 0x55c02459d628 [00:12:42.196] parsetree_item = 0x55c02459d640 [00:12:42.196] save_log_statement_stats = false [00:12:42.196] was_logged = false [00:12:42.196] use_implicit_block = false [00:12:42.196] msec_str = "\000\000\000\000\000\000\000\000\246\355D\"\300U\000\000`ϼ\304\376\177\000\000U\000\000\000\000\000\000" [00:12:42.196] __func__ = "exec_simple_query" [00:12:42.196] #19 0x000055c022183cee in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [00:12:42.196] query_string = 0x55c02459c260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [00:12:42.196] firstchar = [00:12:42.196] input_message = {data = 0x55c02459c260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [00:12:42.196] local_sigjmp_buf = {{__jmpbuf = {94283709344920, -2494972242196461333, 140732199129328, 0, 140732199129476, 1, -8566448410714208021, -2494974646060480277}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140505095081444, 94283731918576, 15616, 15680, 94283697140007, 94283709344928, 94283731943776, 94283709339032, 0, 140732199129476, 94283697144075, 1}}}} [00:12:42.196] send_ready_for_query = false [00:12:42.196] idle_in_transaction_timeout_enabled = false [00:12:42.196] idle_session_timeout_enabled = false [00:12:42.196] __func__ = "PostgresMain" [00:12:42.196] #20 0x000055c02202708d in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:12:42.196] No locals. [00:12:42.196] #21 0x000055c02202c8d2 in BackendStartup (client_sock=client_sock@entry=0x7ffec4bcd0f0) at ../src/backend/postmaster/postmaster.c:4117 [00:12:42.196] bn = 0x55c0245c5008 [00:12:42.196] pid = 0 [00:12:42.196] cac = CAC_OK [00:12:42.196] __func__ = "BackendStartup" [00:12:42.196] #22 0x000055c02202cceb in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:12:42.196] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000\210\313?\344\311\177\000\000 \003]\344\311\177\000\000\001\000\000\000\000\000\000\000\244\243\327\345\311\177\000\000-\000\000\000\000\000\000\000\020\316@\344\311\177\000\000 \231\020\345\311\177\000\000\310Ѽ\304\376\177\000\000\304Ѽ\304\376\177\000\000Py\\$\300U", '\000' , "\020\316@\344\311\177\000\000\340\357?\344\311\177\000", __ss_align = 140505096466410}, salen = 2}} [00:12:42.196] i = 0 [00:12:42.196] now = [00:12:42.196] last_lockfile_recheck_time = 1710547748 [00:12:42.196] last_touch_time = 1710547748 [00:12:42.196] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -994258288, events = 32766, fd = -463666400, user_data = 0x7ffec4bcd280}, {pos = 45, events = 0, fd = -438713984, user_data = 0xc4bcd250}, {pos = 0, events = 0, fd = -438713984, user_data = 0x59e7c8ee}, {pos = -451897464, events = 32713, fd = -463654934, user_data = 0x7ffec4bcd328}, {pos = -994258304, events = 32766, fd = -994258288, user_data = 0x7fc9e5d7ace1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -505608680, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fc9e5109420}, {pos = -994258352, events = 32766, fd = -505608680, user_data = 0x7fc9e5109420}, {pos = 580204704, events = 1, fd = -451897464, user_data = 0x0}, {pos = 610015728, events = 21952, fd = 610049064, user_data = 0xffffffff}, {pos = -438831581, events = 32713, fd = -465570792, user_data = 0x7fc9e5109920}, {pos = 610049032, events = 21952, fd = -465524232, user_data = 0x7ffec4bcd670}, {pos = -438802806, events = 32713, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = -463552264, user_data = 0x8}, {pos = 609869920, events = 21952, fd = 1, user_data = 0x1}, {pos = 609869872, events = 21952, fd = -438831581, user_data = 0x1}, {pos = 0, events = 0, fd = 610048856, user_data = 0x7fc9e43ff418}, {pos = -994257184, events = 32766, fd = -438802806, user_data = 0x0}, {pos = 0, events = 0, fd = -994257152, user_data = 0x55c023000a60 }, {pos = 2, events = 0, fd = 587205216, 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 = 610042776, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 609853328, user_data = 0x55c024599f90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294901760, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1734701663, events = 1936942450, fd = 828664365, user_data = 0x5931646a2d737365}, {pos = 168445519, events = 908075040, fd = 822763892, user_data = 0x30340a3834373734}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, 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 = 609853328, events = 21952, fd = -463707008, user_data = 0x124599f90}, {pos = 784, events = 0, fd = 577331660, user_data = 0x55c0245c73e0}, {pos = 20773888, events = 865353330, fd = 4, user_data = 0x55c0245c8360}, {pos = 610038752, events = 21952, fd = 610038952, 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 = 610038952, user_data = 0x400}, {pos = 0, events = 0, fd = 575138507, user_data = 0x55c02300ec50 }, {pos = 575072183, events = 21952, fd = 610038752, user_data = 0x55c02459c160}, {pos = 610038752, events = 21952, fd = 15, user_data = 0x4a}, {pos = 575140275, events = 21952, fd = 610038752, user_data = 0x55c02247f2f5 }, {pos = 609853328, events = 21952, fd = -465052677, user_data = 0x0}, {pos = 568624744, events = 21952, fd = 610027360, user_data = 0x124599f90}, {pos = -994257032, events = 32766, fd = 0, user_data = 0x55c0245c73e0}, {pos = -465067606, events = 32713, fd = 1024, user_data = 0x55c024599f90}, {pos = -465073936, events = 32713, fd = 0, user_data = 0x55c000000000}, {pos = 0, events = 0, fd = 609853328, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x5bd6}, {pos = -464770299, events = 32713, fd = 8, user_data = 0x33943e72013cfc00}, {pos = 1, events = 0, fd = 570575883, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x55c02247f1b3 }, {pos = 610027360, events = 21952, fd = 575140597, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55c021e4823b }, {pos = 0, events = 0, fd = 568647697, user_data = 0x55c02459c160}, {pos = 570603114, events = 21952, fd = 0, user_data = 0x0}} [00:12:42.197] nevents = 1 [00:12:42.197] __func__ = "ServerLoop" [00:12:42.197] #23 0x000055c02202e705 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55c024595e50) at ../src/backend/postmaster/postmaster.c:1478 [00:12:42.197] opt = [00:12:42.197] status = [00:12:42.197] userDoption = [00:12:42.197] listen_addr_saved = false [00:12:42.197] output_config_variable = [00:12:42.197] __func__ = "PostmasterMain" [00:12:42.197] #24 0x000055c021e5906b in main (argc=8, argv=0x55c024595e50) at ../src/backend/main/main.c:197 [00:12:42.197] do_check_root = [00:12:42.214] -e [00:12:42.214] [00:12:42.214] [00:12:42.733] dumping /tmp/cores/sh-3-30727.core for /bin/sh [00:12:43.743] Downloading separate debug info for /bin/sh... [00:12:44.213] [New LWP 30727] [00:12:44.213] [New LWP 30723] [00:12:44.687] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline'. [00:12:44.687] Program terminated with signal SIGQUIT, Quit. [00:12:44.687] #0 0x00007efd0fa9bfc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [00:12:44.700] [Current thread is 1 (LWP 30727)] [00:12:44.700] [00:12:44.700] Thread 2 (LWP 30723): [00:12:44.700] #0 0x00007efd0fb2abc8 in vfork () from /lib/x86_64-linux-gnu/libc.so.6 [00:12:44.700] No symbol table info available. [00:12:44.700] #1 0x000055d8cacb826b in vforkexec (n=n@entry=0x55d8cc24d928, argv=argv@entry=0x55d8cc24da48, path=path@entry=0x7ffd9d843093 "/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr"..., idx=6) at jobs.c:973 [00:12:44.700] jp = 0x55d8cc24db80 [00:12:44.700] pid = [00:12:44.700] #2 0x000055d8cacb232c in evalcommand (cmd=0x55d8cc24d928, flags=0) at eval.c:905 [00:12:44.700] i = [00:12:44.700] localvar_stop = 0x0 [00:12:44.700] file_stop = 0x55d8cc24d890 [00:12:44.700] redir_stop = 0x0 [00:12:44.700] argp = [00:12:44.700] arglist = {list = 0x55d8cc24d950, lastp = 0x55d8cc24da30} [00:12:44.700] varlist = {list = 0x0, lastp = 0x7ffd9d8411a0} [00:12:44.700] argv = 0x55d8cc24da48 [00:12:44.700] argc = 3 [00:12:44.700] osp = [00:12:44.700] sp = [00:12:44.700] cmdentry = {cmdtype = 0, u = {index = 6, cmd = 0x7676767600000006, func = 0x7676767600000006}} [00:12:44.700] jp = 0x0 [00:12:44.700] lastarg = 0x0 [00:12:44.700] path = 0x7ffd9d843093 "/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr"... [00:12:44.700] spclbltin = -1 [00:12:44.700] cmd_flag = 0 [00:12:44.700] execcmd = 0 [00:12:44.700] status = [00:12:44.700] nargv = [00:12:44.700] vflags = 0 [00:12:44.700] vlocal = [00:12:44.700] #3 0x000055d8cacb127e in evaltree (n=n@entry=0x55d8cc24d928, flags=0) at eval.c:303 [00:12:44.700] checkexit = 0 [00:12:44.700] evalfn = [00:12:44.700] smark = {stackp = 0x55d8cc24d920, stacknxt = 0x55d8cc24d948 "cp", stacknleft = 472} [00:12:44.700] isor = [00:12:44.700] status = [00:12:44.700] evaln = [00:12:44.700] #4 0x000055d8cacb1c6a in evalstring (s=0x55d8caccc7e8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000002", '0' , "4\" \"pg_wal/RECOVERYXLOG\"", flags=flags@entry=0) at eval.c:185 [00:12:44.700] i = [00:12:44.700] n = 0x55d8cc24d928 [00:12:44.700] smark = {stackp = 0x55d8caccc7e0 , stacknxt = 0x55d8caccc8a0 "cp", stacknleft = 320} [00:12:44.700] status = 0 [00:12:44.700] #5 0x000055d8cacaf67f in main (argc=3, argv=0x7ffd9d841418) at main.c:177 [00:12:44.700] shinit = [00:12:44.700] state = 4 [00:12:44.700] smark = {stackp = 0x55d8caccc7e0 , stacknxt = 0x55d8caccc7e8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000002", '0' , "4\" \"pg_wal/RECOVERYXLOG\"", stacknleft = 504} [00:12:44.700] login = [00:12:44.700] [00:12:44.700] Thread 1 (LWP 30727): [00:12:44.700] #0 0x00007efd0fa9bfc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [00:12:44.700] No symbol table info available. [00:12:44.700] #1 0x00007efd0fa9c2c7 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [00:12:44.700] No symbol table info available. [00:12:44.700] #2 0x000055d8cacb82b7 in sigclearmask () at system.h:46 [00:12:44.700] No locals. [00:12:44.700] #3 vforkexec (n=n@entry=0x55d8cc24d928, argv=argv@entry=0x55d8cc24da48, path=path@entry=0x7ffd9d843093 "/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr"..., idx=6) at jobs.c:977 [00:12:44.700] jp = 0x55d8cc24db80 [00:12:44.700] pid = [00:12:44.700] #4 0x000055d8cacb232c in evalcommand (cmd=0x55d8cc24d928, flags=0) at eval.c:905 [00:12:44.700] i = [00:12:44.700] localvar_stop = 0x0 [00:12:44.700] file_stop = 0x55d8cc24d890 [00:12:44.700] redir_stop = 0x0 [00:12:44.700] argp = [00:12:44.700] arglist = {list = 0x55d8cc24d950, lastp = 0x55d8cc24da30} [00:12:44.700] varlist = {list = 0x0, lastp = 0x7ffd9d8411a0} [00:12:44.700] argv = 0x55d8cc24da48 [00:12:44.700] argc = 3 [00:12:44.700] osp = [00:12:44.700] sp = [00:12:44.700] cmdentry = {cmdtype = 0, u = {index = 6, cmd = 0x7676767600000006, func = 0x7676767600000006}} [00:12:44.700] jp = 0x0 [00:12:44.700] lastarg = 0x0 [00:12:44.700] path = 0x7ffd9d843093 "/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr"... [00:12:44.700] spclbltin = -1 [00:12:44.700] cmd_flag = 0 [00:12:44.700] execcmd = 0 [00:12:44.700] status = [00:12:44.700] nargv = [00:12:44.700] vflags = 0 [00:12:44.700] vlocal = [00:12:44.700] #5 0x000055d8cacb127e in evaltree (n=n@entry=0x55d8cc24d928, flags=0) at eval.c:303 [00:12:44.700] checkexit = 0 [00:12:44.700] evalfn = [00:12:44.700] smark = {stackp = 0x55d8cc24d920, stacknxt = 0x55d8cc24d948 "cp", stacknleft = 472} [00:12:44.700] isor = [00:12:44.700] status = [00:12:44.700] evaln = [00:12:44.700] #6 0x000055d8cacb1c6a in evalstring (s=0x55d8caccc7e8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000002", '0' , "4\" \"pg_wal/RECOVERYXLOG\"", flags=flags@entry=0) at eval.c:185 [00:12:44.700] i = [00:12:44.700] n = 0x55d8cc24d928 [00:12:44.700] smark = {stackp = 0x55d8caccc7e0 , stacknxt = 0x55d8caccc8a0 "cp", stacknleft = 320} [00:12:44.700] status = 0 [00:12:44.700] #7 0x000055d8cacaf67f in main (argc=3, argv=0x7ffd9d841418) at main.c:177 [00:12:44.700] shinit = [00:12:44.700] state = 4 [00:12:44.700] smark = {stackp = 0x55d8caccc7e0 , stacknxt = 0x55d8caccc7e8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000002", '0' , "4\" \"pg_wal/RECOVERYXLOG\"", stacknleft = 504} [00:12:44.700] login = [00:12:44.708] -e [00:12:44.708] [00:12:44.708] [00:12:45.251] dumping /tmp/cores/postgres-11-27870.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:12:45.555] [New LWP 27870] [00:12:46.689] [Thread debugging using libthread_db enabled] [00:12:46.689] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:12:48.105] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [00:12:48.105] Program terminated with signal SIGSEGV, Segmentation fault. [00:12:48.105] #0 0x000055a206cd2ec7 in equal (a=0x8d06bd8, b=b@entry=0x55a208d039d8) at ../src/backend/nodes/equalfuncs.c:239 [00:12:48.105] 239 if (nodeTag(a) != nodeTag(b)) [00:12:48.216] [00:12:48.216] Thread 1 (Thread 0x7fbb29b4da40 (LWP 27870)): [00:12:48.216] #0 0x000055a206cd2ec7 in equal (a=0x8d06bd8, b=b@entry=0x55a208d039d8) at ../src/backend/nodes/equalfuncs.c:239 [00:12:48.216] retval = [00:12:48.216] __func__ = "equal" [00:12:48.216] #1 0x000055a206614396 in list_member (list=0x55a208d06c48, datum=datum@entry=0x55a208d039d8) at ../src/backend/nodes/list.c:670 [00:12:48.216] cell__state = {l = , i = } [00:12:48.216] cell = [00:12:48.216] #2 0x000055a206737ab6 in add_new_column_to_pathtarget (target=target@entry=0x55a208d06b68, expr=0x55a208d039d8) at ../src/backend/optimizer/util/tlist.c:743 [00:12:48.216] No locals. [00:12:48.216] #3 0x000055a206737b51 in add_new_columns_to_pathtarget (target=target@entry=0x55a208d06b68, exprs=exprs@entry=0x55a208d06d78) at ../src/backend/optimizer/util/tlist.c:760 [00:12:48.216] expr = [00:12:48.216] lc__state = {l = , i = } [00:12:48.216] lc = [00:12:48.216] #4 0x000055a2066b0155 in make_group_input_target (root=root@entry=0x55a208cfbbe8, final_target=final_target@entry=0x55a208d06a08) at ../src/backend/optimizer/plan/planner.c:5472 [00:12:48.216] parse = 0x55a208bd9d08 [00:12:48.216] input_target = 0x55a208d06b68 [00:12:48.216] non_group_cols = 0x55a208d06d28 [00:12:48.216] non_group_vars = 0x55a208d06d78 [00:12:48.216] i = 6 [00:12:48.216] lc = 0x0 [00:12:48.216] #5 0x000055a2066c3517 in grouping_planner (root=root@entry=0x55a208cfbbe8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:12:48.216] sort_input_targets = 0x55a208d03848 [00:12:48.216] sort_input_target_parallel_safe = true [00:12:48.216] grouping_target = 0x55a208d06a08 [00:12:48.216] scanjoin_target = [00:12:48.216] activeWindows = 0x0 [00:12:48.216] qp_extra = {activeWindows = 0x0, gset_data = 0x55a208d04e68} [00:12:48.216] sort_input_targets_contain_srfs = 0x55a2066f998d [00:12:48.216] have_grouping = [00:12:48.216] wflists = 0x0 [00:12:48.216] gset_data = 0x55a208d04e68 [00:12:48.216] sort_input_target = 0x55a208d06a08 [00:12:48.216] grouping_targets = 0x0 [00:12:48.216] grouping_target_parallel_safe = true [00:12:48.216] scanjoin_targets = 0x0 [00:12:48.216] scanjoin_target_parallel_safe = [00:12:48.216] grouping_targets_contain_srfs = 0x55a206621ae2 [00:12:48.216] scanjoin_targets_contain_srfs = 0x55a208d000b8 [00:12:48.216] scanjoin_target_same_exprs = [00:12:48.216] parse = 0x55a208bd9d08 [00:12:48.216] offset_est = 0 [00:12:48.216] count_est = 0 [00:12:48.216] limit_tuples = -1 [00:12:48.216] have_postponed_srfs = false [00:12:48.216] final_target = 0x55a208d06a08 [00:12:48.216] final_targets = 0x0 [00:12:48.216] final_targets_contain_srfs = 0x55a2066ffc84 [00:12:48.216] final_target_parallel_safe = true [00:12:48.216] current_rel = 0x55a208cfbff8 [00:12:48.216] final_rel = [00:12:48.216] extra = {limit_needed = 232, limit_tuples = 1.9762625833649862e-323, count_est = 94154420894696, offset_est = 0} [00:12:48.216] lc = [00:12:48.216] __func__ = "grouping_planner" [00:12:48.216] #6 0x000055a2066c63bb in subquery_planner (glob=glob@entry=0x55a208bd9f78, parse=parse@entry=0x55a208bd9d08, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:12:48.216] root = 0x55a208cfbbe8 [00:12:48.216] newWithCheckOptions = [00:12:48.216] newHaving = 0x0 [00:12:48.216] hasOuterJoins = [00:12:48.216] hasResultRTEs = false [00:12:48.216] final_rel = [00:12:48.216] l = 0x0 [00:12:48.216] #7 0x000055a2066c7010 in standard_planner (parse=0x55a208bd9d08, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [00:12:48.216] result = [00:12:48.216] glob = 0x55a208bd9f78 [00:12:48.216] tuple_fraction = 0 [00:12:48.216] root = [00:12:48.216] final_rel = [00:12:48.216] best_path = [00:12:48.216] top_plan = [00:12:48.216] lp = [00:12:48.216] lr = [00:12:48.216] #8 0x000055a2066c80d4 in planner (parse=parse@entry=0x55a208bd9d08, query_string=query_string@entry=0x55a208bd8250 "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 [00:12:48.216] result = [00:12:48.216] #9 0x000055a2069366a7 in pg_plan_query (querytree=querytree@entry=0x55a208bd9d08, query_string=query_string@entry=0x55a208bd8250 "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 [00:12:48.216] plan = [00:12:48.216] #10 0x000055a206936a14 in pg_plan_queries (querytrees=0x55a208d00458, query_string=query_string@entry=0x55a208bd8250 "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 [00:12:48.216] query = 0x55a208bd9d08 [00:12:48.216] stmt = [00:12:48.216] query_list__state = {l = , i = } [00:12:48.216] stmt_list = 0x0 [00:12:48.216] query_list = [00:12:48.216] #11 0x000055a206936dee in exec_simple_query (query_string=query_string@entry=0x55a208bd8250 "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 [00:12:48.216] cmdtaglen = 6 [00:12:48.216] snapshot_set = true [00:12:48.216] per_parsetree_context = 0x0 [00:12:48.216] plantree_list = [00:12:48.216] parsetree = 0x55a208bd9b78 [00:12:48.216] commandTag = CMDTAG_SELECT [00:12:48.216] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94154419700304} [00:12:48.216] querytree_list = [00:12:48.216] portal = [00:12:48.216] receiver = [00:12:48.216] format = 0 [00:12:48.216] cmdtagname = [00:12:48.216] parsetree_item__state = {l = , i = } [00:12:48.216] dest = DestRemote [00:12:48.216] oldcontext = 0x55a208cb2350 [00:12:48.216] parsetree_list = 0x55a208bd9ba8 [00:12:48.216] parsetree_item = 0x55a208bd9bc0 [00:12:48.216] save_log_statement_stats = false [00:12:48.216] was_logged = true [00:12:48.216] use_implicit_block = false [00:12:48.216] msec_str = "\000\000\000\000\000\000\000\000\246M\300\006\242U\000\000\340G\214U\374\177\000\000[\000\000\000\000\000\000" [00:12:48.216] __func__ = "exec_simple_query" [00:12:48.216] #12 0x000055a206939cee in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [00:12:48.216] query_string = 0x55a208bd8250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [00:12:48.216] firstchar = [00:12:48.216] input_message = {data = 0x55a208bd8250 "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} [00:12:48.216] local_sigjmp_buf = {{__jmpbuf = {94154398649496, 3988231053600955273, 140721743743344, 0, 140721743743492, 1, 7198351870858959753, 3988228690068577161}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 140441875922404, 94154419674880, 14336, 14400, 94154386444583, 94154398649504, 94154419700048, 94154398643608, 0, 140721743743492, 94154386448651, 1}}}} [00:12:48.216] send_ready_for_query = false [00:12:48.216] idle_in_transaction_timeout_enabled = false [00:12:48.216] idle_session_timeout_enabled = false [00:12:48.216] __func__ = "PostgresMain" [00:12:48.216] #13 0x000055a2067dd08d in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:12:48.216] No locals. [00:12:48.216] #14 0x000055a2067e28d2 in BackendStartup (client_sock=client_sock@entry=0x7ffc558c4970) at ../src/backend/postmaster/postmaster.c:4117 [00:12:48.216] bn = 0x55a208c10048 [00:12:48.216] pid = 0 [00:12:48.216] cac = CAC_OK [00:12:48.216] __func__ = "BackendStartup" [00:12:48.216] #15 0x000055a2067e2ceb in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:12:48.216] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000\210\373\027,\273\177\000\000 35,\273\177\000\000\001\000\000\000\000\000\000\000\244ӯ-\273\177\000\000-\000\000\000\000\000\000\000\020\376\030,\273\177\000\000 \311\350,\273\177\000\000HJ\214U\374\177\000\000DJ\214U\374\177\000\000@2\300\b\242U", '\000' , "\020\376\030,\273\177\000\000\340\037\030,\273\177\000", __ss_align = 140441877307370}, salen = 2}} [00:12:48.216] i = 0 [00:12:48.216] now = [00:12:48.216] last_lockfile_recheck_time = 1710547749 [00:12:48.216] last_touch_time = 1710547749 [00:12:48.216] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1435257616, events = 32764, fd = 741684000, user_data = 0x7ffc558c4b00}, {pos = 45, events = 0, fd = 766636416, user_data = 0x558c4ad0}, {pos = 0, events = 0, fd = 766636416, user_data = 0x59e7c8ee}, {pos = 753452936, events = 32699, fd = 741695466, user_data = 0x7ffc558c4ba8}, {pos = 1435257600, events = 32764, fd = 1435257616, user_data = 0x7fbb2dafdce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = 699741720, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fbb2ce8c420}, {pos = 1435257552, events = 32764, fd = 699741720, user_data = 0x7fbb2ce8c420}, {pos = 118528160, events = 1, fd = 753452936, user_data = 0x0}, {pos = 146813072, events = 21922, fd = 146805784, user_data = 0xffffffff}, {pos = 766518819, events = 32699, fd = 739779608, user_data = 0x7fbb2ce8c920}, {pos = 146805752, events = 21922, fd = 739826168, user_data = 0x7ffc558c4ef0}, {pos = 766547594, events = 32699, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = 741798136, user_data = 0x4}, {pos = 146645008, events = 21922, fd = 1, user_data = 0x1}, {pos = 146644976, events = 21922, fd = 766518819, user_data = 0x1}, {pos = 0, events = 0, fd = 146809704, user_data = 0x7fbb2c182418}, {pos = 1435258720, events = 32764, fd = 766547594, user_data = 0x0}, {pos = 0, events = 0, fd = 1435258752, user_data = 0x55a2077b6a60 }, {pos = 2, events = 0, fd = 125528672, 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 = 146805672, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 146628512, user_data = 0x55a208bd5fa0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 170996256, 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 = 146628512, events = 21922, fd = 741643392, user_data = 0x108bd5fa0}, {pos = 784, events = 0, fd = 115655116, user_data = 0x55a208c00f60}, {pos = 345845504, events = 4281822310, fd = 4, user_data = 0x55a208c01370}, {pos = 146804576, events = 21922, fd = 146804776, 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 = 146804776, user_data = 0x400}, {pos = 0, events = 0, fd = 113461963, user_data = 0x55a2077c4c50 }, {pos = 113395639, events = 21922, fd = 146804576, user_data = 0x55a208bd8150}, {pos = 146804576, events = 21922, fd = 15, user_data = 0x4a}, {pos = 113463731, events = 21922, fd = 146804576, user_data = 0x55a206c352f5 }, {pos = 146628512, events = 21922, fd = 740298030, user_data = 0x0}, {pos = 106948200, events = 21922, fd = 146799424, user_data = 0x108bd5fa0}, {pos = 1435258872, events = 32764, fd = 0, user_data = 0x55a208c00f60}, {pos = 740282794, events = 32699, fd = 1024, user_data = 0x55a208bd5fa0}, {pos = 740276464, events = 32699, fd = 0, user_data = 0x55a200000000}, {pos = 0, events = 0, fd = 146628512, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x5e4a}, {pos = 740580101, events = 32699, fd = 4, user_data = 0xff376c66149d2f00}, {pos = 1, events = 0, fd = 108899339, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x55a206c351b3 }, {pos = 146799424, events = 21922, fd = 113464053, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55a2065fe23b }, {pos = 0, events = 0, fd = 106971153, user_data = 0x55a208bd8150}, {pos = 108926570, events = 21922, fd = 0, user_data = 0x0}} [00:12:48.216] nevents = 1 [00:12:48.216] __func__ = "ServerLoop" [00:12:48.216] #16 0x000055a2067e4705 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a208bd1e10) at ../src/backend/postmaster/postmaster.c:1478 [00:12:48.216] opt = [00:12:48.216] status = [00:12:48.216] userDoption = [00:12:48.216] listen_addr_saved = false [00:12:48.216] output_config_variable = [00:12:48.216] __func__ = "PostmasterMain" [00:12:48.216] #17 0x000055a20660f06b in main (argc=4, argv=0x55a208bd1e10) at ../src/backend/main/main.c:197 [00:12:48.216] do_check_root = [00:12:48.233] -e [00:12:48.233] [00:12:48.233] [00:12:48.769] dumping /tmp/cores/postgres-11-37080.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:12:49.084] [New LWP 37080] [00:12:50.221] [Thread debugging using libthread_db enabled] [00:12:50.221] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:12:51.641] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT '. [00:12:51.641] Program terminated with signal SIGSEGV, Segmentation fault. [00:12:51.641] #0 0x0000562b2a033aa1 in get_expr_width (root=root@entry=0x562b2c7e49b8, expr=expr@entry=0x2c730078) at ../src/backend/optimizer/path/costsize.c:6328 [00:12:51.641] 6328 if (IsA(expr, Var)) [00:12:51.765] [00:12:51.765] Thread 1 (Thread 0x7fb3dc101a40 (LWP 37080)): [00:12:51.765] #0 0x0000562b2a033aa1 in get_expr_width (root=root@entry=0x562b2c7e49b8, expr=expr@entry=0x2c730078) at ../src/backend/optimizer/path/costsize.c:6328 [00:12:51.765] width = [00:12:51.765] #1 0x0000562b2a044740 in set_pathtarget_cost_width (root=root@entry=0x562b2c7e49b8, target=target@entry=0x562b2c730008) at ../src/backend/optimizer/path/costsize.c:6299 [00:12:51.765] node = 0x2c730078 [00:12:51.765] lc__state = {l = , i = } [00:12:51.765] tuple_width = 0 [00:12:51.765] lc = [00:12:51.765] #2 0x0000562b2a09f170 in make_group_input_target (root=root@entry=0x562b2c7e49b8, final_target=final_target@entry=0x562b2c72ff48) at ../src/backend/optimizer/plan/planner.c:5479 [00:12:51.765] parse = 0x562b2c7dac58 [00:12:51.765] input_target = 0x562b2c730008 [00:12:51.765] non_group_cols = 0x0 [00:12:51.765] non_group_vars = 0x0 [00:12:51.765] i = 3 [00:12:51.765] lc = 0x0 [00:12:51.765] #3 0x0000562b2a0b2517 in grouping_planner (root=root@entry=0x562b2c7e49b8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:12:51.765] sort_input_targets = 0x562b2c7e6140 [00:12:51.765] sort_input_target_parallel_safe = true [00:12:51.765] grouping_target = 0x562b2c72ff48 [00:12:51.765] scanjoin_target = [00:12:51.765] activeWindows = 0x0 [00:12:51.765] qp_extra = {activeWindows = 0x0, gset_data = 0x562b2c7e66e0} [00:12:51.765] sort_input_targets_contain_srfs = 0x562b2a0e898d [00:12:51.765] have_grouping = [00:12:51.765] wflists = 0x0 [00:12:51.765] gset_data = 0x562b2c7e66e0 [00:12:51.765] sort_input_target = 0x562b2c72ff48 [00:12:51.765] grouping_targets = 0x0 [00:12:51.765] grouping_target_parallel_safe = true [00:12:51.765] scanjoin_targets = 0x0 [00:12:51.765] scanjoin_target_parallel_safe = [00:12:51.765] grouping_targets_contain_srfs = 0x562b2a010ae2 [00:12:51.765] scanjoin_targets_contain_srfs = 0x562b2c7dcb00 [00:12:51.765] scanjoin_target_same_exprs = [00:12:51.765] parse = 0x562b2c7dac58 [00:12:51.765] offset_est = 0 [00:12:51.765] count_est = 0 [00:12:51.765] limit_tuples = -1 [00:12:51.765] have_postponed_srfs = false [00:12:51.765] final_target = 0x562b2c72ff48 [00:12:51.765] final_targets = 0x0 [00:12:51.765] final_targets_contain_srfs = 0x562b2a0eec84 [00:12:51.765] final_target_parallel_safe = true [00:12:51.765] current_rel = 0x562b2c72e558 [00:12:51.765] final_rel = [00:12:51.765] extra = {limit_needed = 184, limit_tuples = 1.9762625833649862e-323, count_est = 94743430056376, offset_est = 0} [00:12:51.765] lc = [00:12:51.765] __func__ = "grouping_planner" [00:12:51.765] #4 0x0000562b2a0b53bb in subquery_planner (glob=glob@entry=0x562b2c6dcfd8, parse=parse@entry=0x562b2c7dac58, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:12:51.765] root = 0x562b2c7e49b8 [00:12:51.765] newWithCheckOptions = [00:12:51.765] newHaving = 0x0 [00:12:51.765] hasOuterJoins = [00:12:51.765] hasResultRTEs = false [00:12:51.765] final_rel = [00:12:51.765] l = 0x0 [00:12:51.765] #5 0x0000562b2a0b6010 in standard_planner (parse=parse@entry=0x562b2c7dac58, query_string=query_string@entry=0x562b2c6db2c0 "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 [00:12:51.765] result = [00:12:51.765] glob = 0x562b2c6dcfd8 [00:12:51.765] tuple_fraction = 0 [00:12:51.765] root = [00:12:51.765] final_rel = [00:12:51.765] best_path = [00:12:51.765] top_plan = [00:12:51.765] lp = [00:12:51.765] lr = [00:12:51.765] #6 0x00007fb3dbf2e59c in pgss_planner (parse=0x562b2c7dac58, query_string=0x562b2c6db2c0 "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 [00:12:51.765] _save_exception_stack = 0x7ffca7b7a8a0 [00:12:51.765] _save_context_stack = 0x0 [00:12:51.765] _local_sigjmp_buf = {{__jmpbuf = {94743430016088, -1880143748628037171, 0, 2048, 0, 94743428969152, -5312149086619909683, -5271027929449709107}, __mask_was_saved = 0, __saved_mask = {__val = {140410461693728, 384, 94743428947536, 140723122316960, 1, 140723122316863, 140723122804565, 137, 6, 140410463871960, 94743393642903, 1710547795, 78221, 472, 94743394589474, 140410463871960}}}} [00:12:51.765] _do_rethrow = false [00:12:51.765] duration = {ticks = } [00:12:51.765] bufusage = {shared_blks_hit = 94743430056011, shared_blks_read = 94743430056009, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 94557999988736, local_blks_read = 8, local_blks_dirtied = 266, local_blks_written = 94743394920189, temp_blks_read = 0, temp_blks_written = 206158430232, shared_blk_read_time = {ticks = 140723122316816}, shared_blk_write_time = {ticks = 140723122316624}, local_blk_read_time = {ticks = 60}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 2795348724}, temp_blk_write_time = {ticks = 94743428947536}} [00:12:51.765] walusage_start = {wal_records = 1347, wal_fpi = 2, wal_bytes = 170394} [00:12:51.765] start = {ticks = } [00:12:51.765] bufusage_start = {shared_blks_hit = 6893, 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}} [00:12:51.765] walusage = {wal_records = 0, wal_fpi = 94743394671031, wal_bytes = 94743389504899} [00:12:51.765] result = 0x7ffca7b7a610 [00:12:51.765] #7 0x0000562b2a0b70ca in planner (parse=parse@entry=0x562b2c7dac58, query_string=query_string@entry=0x562b2c6db2c0 "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 [00:12:51.765] result = [00:12:51.765] #8 0x0000562b2a3256a7 in pg_plan_query (querytree=querytree@entry=0x562b2c7dac58, query_string=query_string@entry=0x562b2c6db2c0 "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 [00:12:51.765] plan = [00:12:51.765] #9 0x0000562b2a325a14 in pg_plan_queries (querytrees=0x562b2c7e4968, query_string=query_string@entry=0x562b2c6db2c0 "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 [00:12:51.765] query = 0x562b2c7dac58 [00:12:51.765] stmt = [00:12:51.765] query_list__state = {l = , i = } [00:12:51.765] stmt_list = 0x0 [00:12:51.765] query_list = [00:12:51.765] #10 0x0000562b2a325dee in exec_simple_query (query_string=query_string@entry=0x562b2c6db2c0 "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 [00:12:51.765] cmdtaglen = 6 [00:12:51.765] snapshot_set = true [00:12:51.765] per_parsetree_context = 0x0 [00:12:51.765] plantree_list = [00:12:51.765] parsetree = 0x562b2c6dcf58 [00:12:51.765] commandTag = CMDTAG_SELECT [00:12:51.765] qc = {commandTag = CMDTAG_DROP_ROLE, nprocessed = 94743428969152} [00:12:51.765] querytree_list = [00:12:51.765] portal = [00:12:51.765] receiver = [00:12:51.765] format = 0 [00:12:51.765] cmdtagname = [00:12:51.765] parsetree_item__state = {l = , i = } [00:12:51.765] dest = DestRemote [00:12:51.765] oldcontext = 0x562b2c706be0 [00:12:51.765] parsetree_list = 0x562b2c6dcf88 [00:12:51.765] parsetree_item = 0x562b2c6dcfa0 [00:12:51.765] save_log_statement_stats = false [00:12:51.765] was_logged = false [00:12:51.765] use_implicit_block = false [00:12:51.765] msec_str = "\000\000\000\000\000\000\000\000\246=_*+V\000\000\200\250\267\247\374\177\000\000\205\000\000\000\000\000\000" [00:12:51.765] __func__ = "exec_simple_query" [00:12:51.765] #11 0x0000562b2a328cee in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [00:12:51.765] query_string = 0x562b2c6db2c0 "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;" [00:12:51.765] firstchar = [00:12:51.765] input_message = {data = 0x562b2c6db2c0 "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} [00:12:51.765] local_sigjmp_buf = {{__jmpbuf = {94743406787736, -1880132079533243955, 140723122317840, 0, 140723122317988, 1, -5312149086838013491, -1880130220057116211}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140410508508644, 94743428943696, 15616, 15680, 94743394582823, 94743406787744, 94743428968896, 94743406781848, 0, 140723122317988, 94743394586891, 1}}}} [00:12:51.765] send_ready_for_query = false [00:12:51.765] idle_in_transaction_timeout_enabled = false [00:12:51.765] idle_session_timeout_enabled = false [00:12:51.765] __func__ = "PostgresMain" [00:12:51.765] #12 0x0000562b2a1cc08d in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:12:51.765] No locals. [00:12:51.765] #13 0x0000562b2a1d18d2 in BackendStartup (client_sock=client_sock@entry=0x7ffca7b7aa10) at ../src/backend/postmaster/postmaster.c:4117 [00:12:51.765] bn = 0x562b2c706e18 [00:12:51.765] pid = 0 [00:12:51.765] cac = CAC_OK [00:12:51.765] __func__ = "BackendStartup" [00:12:51.765] #14 0x0000562b2a1d1ceb in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:12:51.765] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\267\247\374\177\000\000\020>t\336\263\177\000\000\234\017\v\340\263\177\000\000\356\310\347Y\000\000\000\000\001\000\000\000\000\000\000\000\210;s\336\263\177\000\000 s\220\336\263\177\000\000\001\000\000\000\000\000\000\000\244\023\v\340\263\177\000\000-\000\000\000\000\000\000\000\020>t\336\263\177\000\000 \tD߳\177\000\000\b\253\267\247\374\177\000\000\004\253\267\247\374\177\000\000\000\000\000\000\000\000\000", __ss_align = 94743428960240}, salen = 2}} [00:12:51.765] i = 0 [00:12:51.765] now = [00:12:51.765] last_lockfile_recheck_time = 1710547794 [00:12:51.765] last_touch_time = 1710547794 [00:12:51.765] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1508362478, events = 0, fd = 23568163, user_data = 0x7ffca7b7ab04}, {pos = 745553232, events = 22059, fd = -1481135152, user_data = 0x7fb3de907320}, {pos = -1481135168, events = 32764, fd = 46, user_data = 0x7fb3e00d3180}, {pos = 64, events = 0, fd = 0, user_data = 0x7fb3e00d3180}, {pos = 1508362478, events = 0, fd = -549189752, user_data = 0x7fb3de909fea}, {pos = -1481135000, events = 32764, fd = -1481135168, user_data = 0x7ffca7b7abd0}, {pos = -536142623, events = 32691, fd = 18, user_data = 0x7fb3dc107618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -549190624, events = 32691, fd = 8, user_data = 0x7fb3dc107618}, {pos = -549190624, events = 32691, fd = 716146848, user_data = 0x7fb3df440788}, {pos = 0, events = 0, fd = 745561504, user_data = 0x562b2c7094a8}, {pos = -1, events = 0, fd = -536123869, user_data = 0x7fb3de736418}, {pos = -549189344, events = 32691, fd = 8, user_data = 0x7fb3de7419f8}, {pos = -1481134192, events = 32764, fd = -536095094, user_data = 0x10}, {pos = 16777343, events = 0, fd = 16, user_data = 0x7fb3de9230f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = 745389568, user_data = 0x1}, {pos = 1, events = 0, fd = 745389520, user_data = 0x7fb3e00b6623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x562b2c70ec60}, {pos = -562863080, events = 32691, fd = -1481134080, user_data = 0x7fb3e00bd68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffca7b7b020}, {pos = 723147360, events = 22059, fd = 2, user_data = 0x562b2b1a5a60 }, {pos = 0, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x2ffff00001fa0}, {pos = 8, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 745556408, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 745377776, user_data = 0x562b2c6d8ff0}, {pos = 0, events = 0, fd = -562422315, user_data = 0x801}, {pos = 674122, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 171193136, user_data = 0x726765725f67702f}, {pos = 762540901, events = 1483487578, fd = 168447586, user_data = 0x35303137310a6174}, {pos = 959919924, events = 808716852, fd = 1635021663, user_data = 0x726765722f73746e}, {pos = 1768107379, events = 1769300525, fd = 1647273068, user_data = 0x2020203231303538}, {pos = 859189536, events = 170932024, 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 = 784, events = 0, fd = 713273804, user_data = 0x562b2c705990}, {pos = -1151592704, events = 282171969, fd = 4, user_data = 0x562b2c704980}, {pos = 745560464, events = 22059, fd = 745560664, user_data = 0x400}, {pos = 745560664, events = 22059, fd = 0, user_data = 0x562b2a613510 }, {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 = 0x562b2b1b3c50 }, {pos = 711014327, events = 22059, fd = 745560464, user_data = 0x562b2c6db1c0}, {pos = 745560464, events = 22059, fd = 15, user_data = 0x4a}, {pos = 711082419, events = 22059, fd = 745560464, user_data = 0x562b2a6242f5 }, {pos = 745377776, events = 22059, fd = -562344965, user_data = 0x0}, {pos = 704566888, events = 22059, fd = 745551856, user_data = 0x12c6d8ff0}, {pos = -1481133928, events = 32764, fd = 0, user_data = 0x562b2c705990}, {pos = -562359894, events = 32691, fd = 1024, user_data = 0x562b2c6d8ff0}, {pos = -562366224, events = 32691, fd = 0, user_data = 0x562b00000000}, {pos = 0, events = 0, fd = 745377776, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x90ac}, {pos = -562062587, events = 32691, fd = 8, user_data = 0x10d19a41bb5c1700}, {pos = 1, events = 0, fd = 706518027, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x562b2a6241b3 }, {pos = 745551856, events = 22059, fd = 711082741, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x562b29fed23b }, {pos = 0, events = 0, fd = 704589841, user_data = 0x562b2c6db1c0}, {pos = 706545258, events = 22059, fd = 0, user_data = 0x0}} [00:12:51.765] nevents = 1 [00:12:51.765] __func__ = "ServerLoop" [00:12:51.765] #15 0x0000562b2a1d3705 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x562b2c6d4ea0) at ../src/backend/postmaster/postmaster.c:1478 [00:12:51.765] opt = [00:12:51.765] status = [00:12:51.765] userDoption = [00:12:51.765] listen_addr_saved = false [00:12:51.765] output_config_variable = [00:12:51.765] __func__ = "PostmasterMain" [00:12:51.765] #16 0x0000562b29ffe06b in main (argc=8, argv=0x562b2c6d4ea0) at ../src/backend/main/main.c:197 [00:12:51.765] do_check_root = [00:12:51.783] -e [00:12:51.783] [00:12:51.783] [00:12:52.327] dumping /tmp/cores/postgres-11-27221.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:12:52.631] [New LWP 27221] [00:12:53.783] [Thread debugging using libthread_db enabled] [00:12:53.783] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:12:55.225] Core was generated by `postgres: postgres regression [local] SELECT '. [00:12:55.225] Program terminated with signal SIGSEGV, Segmentation fault. [00:12:55.225] #0 0x000055c02251cec7 in equal (a=0x246d0b08, b=b@entry=0x55c0246cd908) at ../src/backend/nodes/equalfuncs.c:239 [00:12:55.225] 239 if (nodeTag(a) != nodeTag(b)) [00:12:55.340] [00:12:55.340] Thread 1 (Thread 0x7fc9e1dcaa40 (LWP 27221)): [00:12:55.340] #0 0x000055c02251cec7 in equal (a=0x246d0b08, b=b@entry=0x55c0246cd908) at ../src/backend/nodes/equalfuncs.c:239 [00:12:55.340] retval = [00:12:55.340] __func__ = "equal" [00:12:55.340] #1 0x000055c021e5e396 in list_member (list=0x55c0246d0b78, datum=datum@entry=0x55c0246cd908) at ../src/backend/nodes/list.c:670 [00:12:55.340] cell__state = {l = , i = } [00:12:55.340] cell = [00:12:55.340] #2 0x000055c021f81ab6 in add_new_column_to_pathtarget (target=target@entry=0x55c0246d0a98, expr=0x55c0246cd908) at ../src/backend/optimizer/util/tlist.c:743 [00:12:55.340] No locals. [00:12:55.340] #3 0x000055c021f81b51 in add_new_columns_to_pathtarget (target=target@entry=0x55c0246d0a98, exprs=exprs@entry=0x55c0246d0ca8) at ../src/backend/optimizer/util/tlist.c:760 [00:12:55.340] expr = [00:12:55.340] lc__state = {l = , i = } [00:12:55.340] lc = [00:12:55.340] #4 0x000055c021efa155 in make_group_input_target (root=root@entry=0x55c0246c5b18, final_target=final_target@entry=0x55c0246d0938) at ../src/backend/optimizer/plan/planner.c:5472 [00:12:55.340] parse = 0x55c02459dd18 [00:12:55.340] input_target = 0x55c0246d0a98 [00:12:55.340] non_group_cols = 0x55c0246d0c58 [00:12:55.340] non_group_vars = 0x55c0246d0ca8 [00:12:55.340] i = 6 [00:12:55.340] lc = 0x0 [00:12:55.340] #5 0x000055c021f0d517 in grouping_planner (root=root@entry=0x55c0246c5b18, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:12:55.340] sort_input_targets = 0x55c0246cd778 [00:12:55.340] sort_input_target_parallel_safe = true [00:12:55.340] grouping_target = 0x55c0246d0938 [00:12:55.340] scanjoin_target = [00:12:55.340] activeWindows = 0x0 [00:12:55.340] qp_extra = {activeWindows = 0x0, gset_data = 0x55c0246ced98} [00:12:55.340] sort_input_targets_contain_srfs = 0x55c021f4398d [00:12:55.340] have_grouping = [00:12:55.340] wflists = 0x0 [00:12:55.340] gset_data = 0x55c0246ced98 [00:12:55.340] sort_input_target = 0x55c0246d0938 [00:12:55.340] grouping_targets = 0x0 [00:12:55.340] grouping_target_parallel_safe = true [00:12:55.340] scanjoin_targets = 0x0 [00:12:55.340] scanjoin_target_parallel_safe = [00:12:55.340] grouping_targets_contain_srfs = 0x55c021e6bae2 [00:12:55.340] scanjoin_targets_contain_srfs = 0x55c0246c9fe8 [00:12:55.340] scanjoin_target_same_exprs = [00:12:55.340] parse = 0x55c02459dd18 [00:12:55.340] offset_est = 0 [00:12:55.340] count_est = 0 [00:12:55.340] limit_tuples = -1 [00:12:55.340] have_postponed_srfs = false [00:12:55.340] final_target = 0x55c0246d0938 [00:12:55.340] final_targets = 0x0 [00:12:55.340] final_targets_contain_srfs = 0x55c021f49c84 [00:12:55.340] final_target_parallel_safe = true [00:12:55.340] current_rel = 0x55c0246c5f28 [00:12:55.340] final_rel = [00:12:55.340] extra = {limit_needed = 24, limit_tuples = 1.9762625833649862e-323, count_est = 94283733162776, offset_est = 0} [00:12:55.340] lc = [00:12:55.340] __func__ = "grouping_planner" [00:12:55.340] #6 0x000055c021f103bb in subquery_planner (glob=glob@entry=0x55c02459df88, parse=parse@entry=0x55c02459dd18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:12:55.340] root = 0x55c0246c5b18 [00:12:55.340] newWithCheckOptions = [00:12:55.340] newHaving = 0x0 [00:12:55.340] hasOuterJoins = [00:12:55.340] hasResultRTEs = false [00:12:55.340] final_rel = [00:12:55.340] l = 0x0 [00:12:55.340] #7 0x000055c021f11010 in standard_planner (parse=0x55c02459dd18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [00:12:55.340] result = [00:12:55.340] glob = 0x55c02459df88 [00:12:55.340] tuple_fraction = 0 [00:12:55.340] root = [00:12:55.340] final_rel = [00:12:55.340] best_path = [00:12:55.340] top_plan = [00:12:55.340] lp = [00:12:55.340] lr = [00:12:55.340] #8 0x000055c021f120d4 in planner (parse=parse@entry=0x55c02459dd18, query_string=query_string@entry=0x55c02459c260 "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 [00:12:55.340] result = [00:12:55.340] #9 0x000055c0221806a7 in pg_plan_query (querytree=querytree@entry=0x55c02459dd18, query_string=query_string@entry=0x55c02459c260 "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 [00:12:55.340] plan = [00:12:55.340] #10 0x000055c022180a14 in pg_plan_queries (querytrees=0x55c0246ca388, query_string=query_string@entry=0x55c02459c260 "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 [00:12:55.340] query = 0x55c02459dd18 [00:12:55.340] stmt = [00:12:55.340] query_list__state = {l = , i = } [00:12:55.340] stmt_list = 0x0 [00:12:55.340] query_list = [00:12:55.340] #11 0x000055c022180dee in exec_simple_query (query_string=query_string@entry=0x55c02459c260 "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 [00:12:55.340] cmdtaglen = 6 [00:12:55.340] snapshot_set = true [00:12:55.340] per_parsetree_context = 0x0 [00:12:55.340] plantree_list = [00:12:55.340] parsetree = 0x55c02459db88 [00:12:55.340] commandTag = CMDTAG_SELECT [00:12:55.340] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94283731944032} [00:12:55.340] querytree_list = [00:12:55.340] portal = [00:12:55.340] receiver = [00:12:55.340] format = 0 [00:12:55.340] cmdtagname = [00:12:55.340] parsetree_item__state = {l = , i = } [00:12:55.340] dest = DestRemote [00:12:55.340] oldcontext = 0x55c0245c4b70 [00:12:55.340] parsetree_list = 0x55c02459dbb8 [00:12:55.340] parsetree_item = 0x55c02459dbd0 [00:12:55.340] save_log_statement_stats = false [00:12:55.340] was_logged = false [00:12:55.340] use_implicit_block = false [00:12:55.340] msec_str = "\000\000\000\000\000\000\000\000\246\355D\"\300U\000\000`ϼ\304\376\177\000\000[\000\000\000\000\000\000" [00:12:55.340] __func__ = "exec_simple_query" [00:12:55.340] #12 0x000055c022183cee in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [00:12:55.340] query_string = 0x55c02459c260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [00:12:55.340] firstchar = [00:12:55.340] input_message = {data = 0x55c02459c260 "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} [00:12:55.340] local_sigjmp_buf = {{__jmpbuf = {94283709344920, -2494972242196461333, 140732199129328, 0, 140732199129476, 1, -8566448410714208021, -2494974646060480277}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140505095081444, 94283731918576, 15616, 15680, 94283697140007, 94283709344928, 94283731943776, 94283709339032, 0, 140732199129476, 94283697144075, 1}}}} [00:12:55.340] send_ready_for_query = false [00:12:55.340] idle_in_transaction_timeout_enabled = false [00:12:55.340] idle_session_timeout_enabled = false [00:12:55.340] __func__ = "PostgresMain" [00:12:55.340] #13 0x000055c02202708d in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:12:55.340] No locals. [00:12:55.340] #14 0x000055c02202c8d2 in BackendStartup (client_sock=client_sock@entry=0x7ffec4bcd0f0) at ../src/backend/postmaster/postmaster.c:4117 [00:12:55.340] bn = 0x55c0245c5198 [00:12:55.340] pid = 0 [00:12:55.340] cac = CAC_OK [00:12:55.340] __func__ = "BackendStartup" [00:12:55.340] #15 0x000055c02202cceb in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:12:55.340] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000\210\313?\344\311\177\000\000 \003]\344\311\177\000\000\001\000\000\000\000\000\000\000\244\243\327\345\311\177\000\000-\000\000\000\000\000\000\000\020\316@\344\311\177\000\000 \231\020\345\311\177\000\000\310Ѽ\304\376\177\000\000\304Ѽ\304\376\177\000\000Py\\$\300U", '\000' , "\020\316@\344\311\177\000\000\340\357?\344\311\177\000", __ss_align = 140505096466410}, salen = 2}} [00:12:55.340] i = 0 [00:12:55.340] now = [00:12:55.340] last_lockfile_recheck_time = 1710547748 [00:12:55.340] last_touch_time = 1710547748 [00:12:55.340] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -994258288, events = 32766, fd = -463666400, user_data = 0x7ffec4bcd280}, {pos = 45, events = 0, fd = -438713984, user_data = 0xc4bcd250}, {pos = 0, events = 0, fd = -438713984, user_data = 0x59e7c8ee}, {pos = -451897464, events = 32713, fd = -463654934, user_data = 0x7ffec4bcd328}, {pos = -994258304, events = 32766, fd = -994258288, user_data = 0x7fc9e5d7ace1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -505608680, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fc9e5109420}, {pos = -994258352, events = 32766, fd = -505608680, user_data = 0x7fc9e5109420}, {pos = 580204704, events = 1, fd = -451897464, user_data = 0x0}, {pos = 610015728, events = 21952, fd = 610049064, user_data = 0xffffffff}, {pos = -438831581, events = 32713, fd = -465570792, user_data = 0x7fc9e5109920}, {pos = 610049032, events = 21952, fd = -465524232, user_data = 0x7ffec4bcd670}, {pos = -438802806, events = 32713, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = -463552264, user_data = 0x8}, {pos = 609869920, events = 21952, fd = 1, user_data = 0x1}, {pos = 609869872, events = 21952, fd = -438831581, user_data = 0x1}, {pos = 0, events = 0, fd = 610048856, user_data = 0x7fc9e43ff418}, {pos = -994257184, events = 32766, fd = -438802806, user_data = 0x0}, {pos = 0, events = 0, fd = -994257152, user_data = 0x55c023000a60 }, {pos = 2, events = 0, fd = 587205216, 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 = 610042776, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 609853328, user_data = 0x55c024599f90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294901760, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1734701663, events = 1936942450, fd = 828664365, user_data = 0x5931646a2d737365}, {pos = 168445519, events = 908075040, fd = 822763892, user_data = 0x30340a3834373734}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, 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 = 609853328, events = 21952, fd = -463707008, user_data = 0x124599f90}, {pos = 784, events = 0, fd = 577331660, user_data = 0x55c0245c73e0}, {pos = 20773888, events = 865353330, fd = 4, user_data = 0x55c0245c8360}, {pos = 610038752, events = 21952, fd = 610038952, 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 = 610038952, user_data = 0x400}, {pos = 0, events = 0, fd = 575138507, user_data = 0x55c02300ec50 }, {pos = 575072183, events = 21952, fd = 610038752, user_data = 0x55c02459c160}, {pos = 610038752, events = 21952, fd = 15, user_data = 0x4a}, {pos = 575140275, events = 21952, fd = 610038752, user_data = 0x55c02247f2f5 }, {pos = 609853328, events = 21952, fd = -465052677, user_data = 0x0}, {pos = 568624744, events = 21952, fd = 610027360, user_data = 0x124599f90}, {pos = -994257032, events = 32766, fd = 0, user_data = 0x55c0245c73e0}, {pos = -465067606, events = 32713, fd = 1024, user_data = 0x55c024599f90}, {pos = -465073936, events = 32713, fd = 0, user_data = 0x55c000000000}, {pos = 0, events = 0, fd = 609853328, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x5bd6}, {pos = -464770299, events = 32713, fd = 8, user_data = 0x33943e72013cfc00}, {pos = 1, events = 0, fd = 570575883, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x55c02247f1b3 }, {pos = 610027360, events = 21952, fd = 575140597, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55c021e4823b }, {pos = 0, events = 0, fd = 568647697, user_data = 0x55c02459c160}, {pos = 570603114, events = 21952, fd = 0, user_data = 0x0}} [00:12:55.340] nevents = 1 [00:12:55.340] __func__ = "ServerLoop" [00:12:55.340] #16 0x000055c02202e705 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55c024595e50) at ../src/backend/postmaster/postmaster.c:1478 [00:12:55.340] opt = [00:12:55.340] status = [00:12:55.340] userDoption = [00:12:55.340] listen_addr_saved = false [00:12:55.340] output_config_variable = [00:12:55.340] __func__ = "PostmasterMain" [00:12:55.340] #17 0x000055c021e5906b in main (argc=8, argv=0x55c024595e50) at ../src/backend/main/main.c:197 [00:12:55.340] do_check_root = [00:12:55.356] -e [00:12:55.356] [00:12:55.356] [00:12:55.906] dumping /tmp/cores/postgres-11-34445.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [00:12:56.215] [New LWP 34445] [00:12:57.354] [Thread debugging using libthread_db enabled] [00:12:57.354] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:12:58.782] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [00:12:58.782] Program terminated with signal SIGSEGV, Segmentation fault. [00:12:58.782] #0 0x00005557c311bec7 in equal (a=0xffffffffc4814090, b=b@entry=0x5557c4810d88) at ../src/backend/nodes/equalfuncs.c:239 [00:12:58.782] 239 if (nodeTag(a) != nodeTag(b)) [00:12:58.906] [00:12:58.906] Thread 1 (Thread 0x7f5a10c74a40 (LWP 34445)): [00:12:58.906] #0 0x00005557c311bec7 in equal (a=0xffffffffc4814090, b=b@entry=0x5557c4810d88) at ../src/backend/nodes/equalfuncs.c:239 [00:12:58.906] retval = [00:12:58.906] __func__ = "equal" [00:12:58.906] #1 0x00005557c2a5d396 in list_member (list=0x5557c4814100, datum=datum@entry=0x5557c4810d88) at ../src/backend/nodes/list.c:670 [00:12:58.906] cell__state = {l = , i = } [00:12:58.906] cell = [00:12:58.906] #2 0x00005557c2b80ab6 in add_new_column_to_pathtarget (target=target@entry=0x5557c4814020, expr=0x5557c4810d88) at ../src/backend/optimizer/util/tlist.c:743 [00:12:58.906] No locals. [00:12:58.906] #3 0x00005557c2b80b51 in add_new_columns_to_pathtarget (target=target@entry=0x5557c4814020, exprs=exprs@entry=0x5557c4814230) at ../src/backend/optimizer/util/tlist.c:760 [00:12:58.906] expr = [00:12:58.906] lc__state = {l = , i = } [00:12:58.906] lc = [00:12:58.906] #4 0x00005557c2af9155 in make_group_input_target (root=root@entry=0x5557c480e6b0, final_target=final_target@entry=0x5557c4813ec0) at ../src/backend/optimizer/plan/planner.c:5472 [00:12:58.906] parse = 0x5557c46edd48 [00:12:58.906] input_target = 0x5557c4814020 [00:12:58.906] non_group_cols = 0x5557c48141e0 [00:12:58.906] non_group_vars = 0x5557c4814230 [00:12:58.906] i = 6 [00:12:58.906] lc = 0x0 [00:12:58.906] #5 0x00005557c2b0c517 in grouping_planner (root=root@entry=0x5557c480e6b0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:12:58.906] sort_input_targets = 0x5557c4810bf8 [00:12:58.906] sort_input_target_parallel_safe = true [00:12:58.906] grouping_target = 0x5557c4813ec0 [00:12:58.906] scanjoin_target = [00:12:58.906] activeWindows = 0x0 [00:12:58.906] qp_extra = {activeWindows = 0x0, gset_data = 0x5557c4812258} [00:12:58.906] sort_input_targets_contain_srfs = 0x5557c2b4298d [00:12:58.906] have_grouping = [00:12:58.906] wflists = 0x0 [00:12:58.906] gset_data = 0x5557c4812258 [00:12:58.906] sort_input_target = 0x5557c4813ec0 [00:12:58.906] grouping_targets = 0x0 [00:12:58.906] grouping_target_parallel_safe = true [00:12:58.906] scanjoin_targets = 0x0 [00:12:58.906] scanjoin_target_parallel_safe = [00:12:58.906] grouping_targets_contain_srfs = 0x5557c2a6aae2 [00:12:58.906] scanjoin_targets_contain_srfs = 0x5557c480d098 [00:12:58.906] scanjoin_target_same_exprs = [00:12:58.906] parse = 0x5557c46edd48 [00:12:58.906] offset_est = 0 [00:12:58.906] count_est = 0 [00:12:58.906] limit_tuples = -1 [00:12:58.906] have_postponed_srfs = false [00:12:58.906] final_target = 0x5557c4813ec0 [00:12:58.906] final_targets = 0x0 [00:12:58.906] final_targets_contain_srfs = 0x5557c2b48c84 [00:12:58.906] final_target_parallel_safe = true [00:12:58.906] current_rel = 0x5557c47fe3d8 [00:12:58.906] final_rel = [00:12:58.906] extra = {limit_needed = 176, limit_tuples = 1.9762625833649862e-323, count_est = 93835447297712, offset_est = 0} [00:12:58.906] lc = [00:12:58.906] __func__ = "grouping_planner" [00:12:58.906] #6 0x00005557c2b0f3bb in subquery_planner (glob=glob@entry=0x5557c47b6538, parse=parse@entry=0x5557c46edd48, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:12:58.906] root = 0x5557c480e6b0 [00:12:58.906] newWithCheckOptions = [00:12:58.906] newHaving = 0x0 [00:12:58.906] hasOuterJoins = [00:12:58.906] hasResultRTEs = false [00:12:58.906] final_rel = [00:12:58.906] l = 0x0 [00:12:58.906] #7 0x00005557c2b10010 in standard_planner (parse=parse@entry=0x5557c46edd48, query_string=query_string@entry=0x5557c46ec290 "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 [00:12:58.906] result = [00:12:58.906] glob = 0x5557c47b6538 [00:12:58.906] tuple_fraction = 0 [00:12:58.906] root = [00:12:58.906] final_rel = [00:12:58.906] best_path = [00:12:58.906] top_plan = [00:12:58.906] lp = [00:12:58.906] lr = [00:12:58.906] #8 0x00007f5a10aa173e in pgss_planner (parse=0x5557c46edd48, query_string=0x5557c46ec290 "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 [00:12:58.906] _save_exception_stack = 0x7ffddddddc90 [00:12:58.906] _save_context_stack = 0x0 [00:12:58.906] _local_sigjmp_buf = {{__jmpbuf = {93835446115656, -6961345349214069108, 0, 2048, 0, 93835446108816, -3877486924704309620, -3783027260289114484}, __mask_was_saved = 0, __saved_mask = {__val = {70368744203450, 1, 93835412860493, 1, 93835418696692, 1, 93835447293064, 0, 0, 0, 93835422595511, 0, 93835416158609, 0, 93835446115656, 0}}}} [00:12:58.906] _do_rethrow = false [00:12:58.906] result = 0x7ffdddddda00 [00:12:58.906] #9 0x00005557c2b110ca in planner (parse=parse@entry=0x5557c46edd48, query_string=query_string@entry=0x5557c46ec290 "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 [00:12:58.906] result = [00:12:58.906] #10 0x00005557c2d7f6a7 in pg_plan_query (querytree=querytree@entry=0x5557c46edd48, query_string=query_string@entry=0x5557c46ec290 "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 [00:12:58.906] plan = [00:12:58.906] #11 0x00005557c2d7fa14 in pg_plan_queries (querytrees=0x5557c480d488, query_string=query_string@entry=0x5557c46ec290 "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 [00:12:58.906] query = 0x5557c46edd48 [00:12:58.906] stmt = [00:12:58.906] query_list__state = {l = , i = } [00:12:58.906] stmt_list = 0x0 [00:12:58.906] query_list = [00:12:58.906] #12 0x00005557c2d7fdee in exec_simple_query (query_string=query_string@entry=0x5557c46ec290 "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 [00:12:58.906] cmdtaglen = 6 [00:12:58.906] snapshot_set = true [00:12:58.906] per_parsetree_context = 0x0 [00:12:58.906] plantree_list = [00:12:58.906] parsetree = 0x5557c46edbb8 [00:12:58.906] commandTag = CMDTAG_SELECT [00:12:58.906] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 93835446108816} [00:12:58.906] querytree_list = [00:12:58.906] portal = [00:12:58.906] receiver = [00:12:58.906] format = 0 [00:12:58.906] cmdtagname = [00:12:58.906] parsetree_item__state = {l = , i = } [00:12:58.906] dest = DestRemote [00:12:58.906] oldcontext = 0x5557c4718880 [00:12:58.906] parsetree_list = 0x5557c46edbe8 [00:12:58.906] parsetree_item = 0x5557c46edc00 [00:12:58.906] save_log_statement_stats = false [00:12:58.906] was_logged = true [00:12:58.906] use_implicit_block = false [00:12:58.906] msec_str = "\000\000\000\000\000\000\000\000\246\335\004\303WU\000\000p\334\335\335\375\177\000\000[\000\000\000\000\000\000" [00:12:58.906] __func__ = "exec_simple_query" [00:12:58.906] #13 0x00005557c2d82cee in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [00:12:58.906] query_string = 0x5557c46ec290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [00:12:58.906] firstchar = [00:12:58.906] input_message = {data = 0x5557c46ec290 "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} [00:12:58.906] local_sigjmp_buf = {{__jmpbuf = {93835434712216, -6961340075197653364, 140728325758464, 0, 140728325758612, 1, -3877486924553314676, -6961342210558583156}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93835446083392, 16384, 8248, 93835422509010, 0, 0, 0, 93835434712224, 93835446108560, 93835434706328, 0, 140728325758612, 1, 93835422512060, 1}}}} [00:12:58.906] send_ready_for_query = false [00:12:58.906] idle_in_transaction_timeout_enabled = false [00:12:58.906] idle_session_timeout_enabled = false [00:12:58.906] __func__ = "PostgresMain" [00:12:58.906] #14 0x00005557c2c2608d in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:12:58.906] No locals. [00:12:58.906] #15 0x00005557c2c2b8d2 in BackendStartup (client_sock=client_sock@entry=0x7ffdddddde00) at ../src/backend/postmaster/postmaster.c:4117 [00:12:58.906] bn = 0x5557c4718ea8 [00:12:58.906] pid = 0 [00:12:58.906] cac = CAC_OK [00:12:58.906] __func__ = "BackendStartup" [00:12:58.906] #16 0x00005557c2c2bceb in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:12:58.906] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "G\023Z\177\000\000\001\000\000\000\000\000\000\000\244C\302\024Z\177\000\000-\000\000\000\000\000\000\000\020n+\023Z\177\000\000 9\373\023Z\177\000\000\310\336\335\335\375\177\000\000\304\336\335\335\375\177\000\000\204\336\335\335\375\177\000\000\340d\000\000\001\000\000\000\000\000\000\000WU\000\000\020n+\023Z\177\000\000\340\217*\023Z\177\000\000\352\317G\023Z\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [00:12:58.906] i = 0 [00:12:58.906] now = [00:12:58.906] last_lockfile_recheck_time = 1710547773 [00:12:58.906] last_touch_time = 1710547773 [00:12:58.906] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -572661888, events = 32765, fd = 46, user_data = 0x7ffddddddf40}, {pos = -572661936, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 335230856, user_data = 0x7f5a1347cfea}, {pos = -572661720, events = 32765, fd = -572661888, user_data = 0x7ffddddddf90}, {pos = 348277985, events = 32602, fd = 18, user_data = 0x7f5a10c7a618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 335229984, events = 32602, fd = -1, user_data = 0x7f5a10c7a618}, {pos = 335229984, events = 32602, fd = 1024, user_data = 0x7f5a13fb3788}, {pos = 0, events = 0, fd = 7, user_data = 0x7ffddddddf90}, {pos = -1, events = 0, fd = 322337978, user_data = 0x7f5a132a9418}, {pos = 335231264, events = 32602, fd = -999176888, user_data = 0x5557c471c3d8}, {pos = -999195808, events = 21847, fd = -999176856, user_data = 0x5557c471c091}, {pos = 348296739, events = 32602, fd = 1, user_data = 0x7f5a134960f8 <__libc_fork@got.plt>}, {pos = 4, events = 0, fd = -999371344, user_data = 0x1}, {pos = 1, events = 0, fd = -999366416, user_data = 0x7f5a14c29623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x5557c4717b60}, {pos = 321557528, events = 32602, fd = -572660752, user_data = 0x7f5a14c3068a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffddddde410}, {pos = -1010828704, events = 21847, fd = 2, user_data = 0x5557c3bffa60 }, {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 = -999155384, 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 = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x2020200a0a463873}, {pos = 842545462, events = 538982706, 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 = 322075643, user_data = 0x400}, {pos = -999383072, events = 21847, fd = 323421312, user_data = 0x1c46e9fe0}, {pos = 784, events = 0, fd = -1020702260, user_data = 0x5557c471c0b0}, {pos = 366501120, events = 1433271433, fd = 4, user_data = 0x5557c4721910}, {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 = 0x5557c471c0b0}, {pos = 1, events = 0, fd = -999177864, user_data = 0x400}, {pos = 0, events = 0, fd = -1022895413, user_data = 0x5557c3c0dc50 }, {pos = -1022961737, events = 21847, fd = -999178064, user_data = 0x5557c46ec190}, {pos = -999178064, events = 21847, fd = 15, user_data = 0x4a}, {pos = -1022893645, events = 21847, fd = -999178064, user_data = 0x5557c307e2f5 }, {pos = -999383072, events = 21847, fd = 322075950, user_data = 0x0}, {pos = -1029409176, events = 21847, fd = -999203904, user_data = 0x1c46e9fe0}, {pos = -572660600, events = 32765, fd = 0, user_data = 0x5557c471c0b0}, {pos = 322060714, events = 32602, fd = 1024, user_data = 0x5557c46e9fe0}, {pos = 322054384, events = 32602, fd = 0, user_data = 0x555700000000}, {pos = 0, events = 0, fd = -999383072, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x770f}, {pos = 322358021, events = 32602, fd = 4, user_data = 0x556dfc8915d85d00}, {pos = 1, events = 0, fd = -1027458037, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x5557c307e1b3 }, {pos = -999203904, events = 21847, fd = -1022893323, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5557c2a4723b }, {pos = 0, events = 0, fd = -1029386223, user_data = 0x5557c46ec190}, {pos = -1027430806, events = 21847, fd = 0, user_data = 0x0}} [00:12:58.906] nevents = 1 [00:12:58.906] __func__ = "ServerLoop" [00:12:58.906] #17 0x00005557c2c2d705 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5557c46e5e40) at ../src/backend/postmaster/postmaster.c:1478 [00:12:58.906] opt = [00:12:58.906] status = [00:12:58.906] userDoption = [00:12:58.906] listen_addr_saved = false [00:12:58.906] output_config_variable = [00:12:58.906] __func__ = "PostmasterMain" [00:12:58.906] #18 0x00005557c2a5806b in main (argc=4, argv=0x5557c46e5e40) at ../src/backend/main/main.c:197 [00:12:58.906] do_check_root = [00:12:58.924] -e [00:12:58.924] [00:12:58.924] [00:12:59.466] dumping /tmp/cores/postgres-11-37394.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [00:12:59.772] [New LWP 37394] [00:13:00.927] [Thread debugging using libthread_db enabled] [00:13:00.927] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [00:13:03.046] Downloading separate debug info for /lib/x86_64-linux-gnu/libnss_files.so.2... [00:13:03.538] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN '. [00:13:03.538] Program terminated with signal SIGSEGV, Segmentation fault. [00:13:03.538] #0 0x0000564faa978ec7 in equal (a=0xffffffffab56a268, b=b@entry=0x564fab6595b8) at ../src/backend/nodes/equalfuncs.c:239 [00:13:03.538] 239 if (nodeTag(a) != nodeTag(b)) [00:13:03.705] [00:13:03.705] Thread 1 (Thread 0x7f9d570bfa40 (LWP 37394)): [00:13:03.705] #0 0x0000564faa978ec7 in equal (a=0xffffffffab56a268, b=b@entry=0x564fab6595b8) at ../src/backend/nodes/equalfuncs.c:239 [00:13:03.705] retval = [00:13:03.705] __func__ = "equal" [00:13:03.705] #1 0x0000564faa2ba396 in list_member (list=0x564fab56a2d8, datum=datum@entry=0x564fab6595b8) at ../src/backend/nodes/list.c:670 [00:13:03.705] cell__state = {l = , i = } [00:13:03.705] cell = [00:13:03.705] #2 0x0000564faa3ddab6 in add_new_column_to_pathtarget (target=target@entry=0x564fab56a1f8, expr=0x564fab6595b8) at ../src/backend/optimizer/util/tlist.c:743 [00:13:03.705] No locals. [00:13:03.705] #3 0x0000564faa3ddb51 in add_new_columns_to_pathtarget (target=target@entry=0x564fab56a1f8, exprs=exprs@entry=0x564fab56a378) at ../src/backend/optimizer/util/tlist.c:760 [00:13:03.705] expr = [00:13:03.705] lc__state = {l = , i = } [00:13:03.705] lc = [00:13:03.705] #4 0x0000564faa356155 in make_group_input_target (root=root@entry=0x564fab658ec8, final_target=final_target@entry=0x564fab56a158) at ../src/backend/optimizer/plan/planner.c:5472 [00:13:03.705] parse = 0x564fab515920 [00:13:03.705] input_target = 0x564fab56a1f8 [00:13:03.705] non_group_cols = 0x564fab56a328 [00:13:03.705] non_group_vars = 0x564fab56a378 [00:13:03.705] i = 2 [00:13:03.705] lc = 0x0 [00:13:03.705] #5 0x0000564faa369517 in grouping_planner (root=root@entry=0x564fab658ec8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [00:13:03.705] sort_input_targets = 0x564fab6593e8 [00:13:03.705] sort_input_target_parallel_safe = true [00:13:03.705] grouping_target = 0x564fab56a158 [00:13:03.705] scanjoin_target = [00:13:03.705] activeWindows = 0x0 [00:13:03.705] qp_extra = {activeWindows = 0x0, gset_data = 0x564fab648758} [00:13:03.705] sort_input_targets_contain_srfs = 0x564fab6486b8 [00:13:03.705] have_grouping = [00:13:03.705] wflists = 0x0 [00:13:03.705] gset_data = 0x564fab648758 [00:13:03.705] sort_input_target = 0x564fab56a158 [00:13:03.705] grouping_targets = 0x564fab658ec8 [00:13:03.705] grouping_target_parallel_safe = true [00:13:03.705] scanjoin_targets = 0x1 [00:13:03.705] scanjoin_target_parallel_safe = [00:13:03.705] grouping_targets_contain_srfs = 0x564faa8dc9b7 [00:13:03.705] scanjoin_targets_contain_srfs = 0x564faa2b9191 [00:13:03.705] scanjoin_target_same_exprs = [00:13:03.705] parse = 0x564fab515920 [00:13:03.705] offset_est = 0 [00:13:03.705] count_est = 0 [00:13:03.705] limit_tuples = -1 [00:13:03.705] have_postponed_srfs = false [00:13:03.705] final_target = 0x564fab56a158 [00:13:03.705] final_targets = 0x564fab63cd58 [00:13:03.705] final_targets_contain_srfs = 0x564faa2bf11b [00:13:03.705] final_target_parallel_safe = true [00:13:03.705] current_rel = 0x564fab640b68 [00:13:03.705] final_rel = [00:13:03.705] extra = {limit_needed = false, limit_tuples = 4.6886907550086191e-310, count_est = 94900177897144, offset_est = 94900177897144} [00:13:03.705] lc = [00:13:03.705] __func__ = "grouping_planner" [00:13:03.705] #6 0x0000564faa36c3bb in subquery_planner (glob=glob@entry=0x564fab640a58, parse=parse@entry=0x564fab515920, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [00:13:03.705] root = 0x564fab658ec8 [00:13:03.705] newWithCheckOptions = [00:13:03.705] newHaving = 0x0 [00:13:03.705] hasOuterJoins = [00:13:03.705] hasResultRTEs = false [00:13:03.705] final_rel = [00:13:03.705] l = 0x0 [00:13:03.705] #7 0x0000564faa36d010 in standard_planner (parse=0x564fab515920, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [00:13:03.705] result = [00:13:03.705] glob = 0x564fab640a58 [00:13:03.705] tuple_fraction = 0 [00:13:03.705] root = [00:13:03.705] final_rel = [00:13:03.705] best_path = [00:13:03.705] top_plan = [00:13:03.705] lp = [00:13:03.705] lr = [00:13:03.705] #8 0x0000564faa36e0d4 in planner (parse=parse@entry=0x564fab515920, query_string=query_string@entry=0x564fab514270 "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 [00:13:03.705] result = [00:13:03.705] #9 0x0000564faa5dc6a7 in pg_plan_query (querytree=querytree@entry=0x564fab515920, query_string=query_string@entry=0x564fab514270 "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 [00:13:03.705] plan = [00:13:03.705] #10 0x0000564faa0cd822 in standard_ExplainOneQuery (query=0x564fab515920, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564fab666a18, queryString=0x564fab514270 "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:441 [00:13:03.705] plan = [00:13:03.705] planstart = {ticks = } [00:13:03.705] planduration = {ticks = 94900176640288} [00:13:03.705] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94900152767320, shared_blks_dirtied = 94900176640560, shared_blks_written = 70368744194107, local_blks_hit = 0, local_blks_read = 94900154089037, local_blks_dirtied = 94900176640560, local_blks_written = 94900159925236, temp_blks_read = 1, temp_blks_written = 2048, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94897302405120}, local_blk_read_time = {ticks = 94900176640016}, local_blk_write_time = {ticks = 94900163824055}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94900157387153}} [00:13:03.705] bufusage = {shared_blks_hit = 94900177865144, shared_blks_read = 1, shared_blks_dirtied = 0, shared_blks_written = 1, local_blks_hit = 0, local_blks_read = 94900160446193, local_blks_dirtied = 70622147264512, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 16443, shared_blk_read_time = {ticks = 140313593776104}, shared_blk_write_time = {ticks = 94900177865144}, local_blk_read_time = {ticks = 94900176640288}, local_blk_write_time = {ticks = 94900163341708}, temp_blk_read_time = {ticks = 140313593776104}, temp_blk_write_time = {ticks = 94900163341727}} [00:13:03.705] mem_counters = {nblocks = 0, freechunks = 1, totalspace = 0, freespace = 94900163565146} [00:13:03.705] planner_ctx = 0x0 [00:13:03.705] saved_ctx = 0x0 [00:13:03.705] #11 0x0000564faa0cdaba in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564fab666a18, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:397 [00:13:03.705] No locals. [00:13:03.705] #12 0x0000564faa0cf0b1 in ExplainQuery (pstate=pstate@entry=0x564fab666908, stmt=stmt@entry=0x564fab515760, params=params@entry=0x0, dest=dest@entry=0x564fab666878) at ../src/include/nodes/nodes.h:172 [00:13:03.705] l__state = {l = , i = } [00:13:03.705] l = 0x564fab640a20 [00:13:03.705] es = 0x564fab666a18 [00:13:03.705] tstate = [00:13:03.705] jstate = [00:13:03.705] query = [00:13:03.705] rewritten = 0x564fab640a08 [00:13:03.705] lc = 0x0 [00:13:03.705] timing_set = false [00:13:03.705] summary_set = false [00:13:03.705] __func__ = "ExplainQuery" [00:13:03.705] #13 0x0000564faa5e70b5 in standard_ProcessUtility (pstmt=0x564fab515810, queryString=0x564fab514270 "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=0x564fab666878, qc=0x7fff359a7740) at ../src/backend/tcop/utility.c:863 [00:13:03.705] parsetree = 0x564fab515760 [00:13:03.705] isTopLevel = true [00:13:03.705] isAtomicContext = false [00:13:03.705] pstate = 0x564fab666908 [00:13:03.705] readonly_flags = [00:13:03.705] __func__ = "standard_ProcessUtility" [00:13:03.705] #14 0x0000564faa5e77de in ProcessUtility (pstmt=pstmt@entry=0x564fab515810, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x564fab666878, qc=0x7fff359a7740) at ../src/backend/tcop/utility.c:523 [00:13:03.705] No locals. [00:13:03.705] #15 0x0000564faa5e2f3c in PortalRunUtility (portal=portal@entry=0x564fab590f90, pstmt=0x564fab515810, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x564fab666878, qc=qc@entry=0x7fff359a7740) at ../src/backend/tcop/pquery.c:1158 [00:13:03.705] No locals. [00:13:03.705] #16 0x0000564faa5e391f in FillPortalStore (portal=portal@entry=0x564fab590f90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [00:13:03.705] treceiver = 0x564fab666878 [00:13:03.705] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:13:03.705] __func__ = "FillPortalStore" [00:13:03.705] #17 0x0000564faa5e3fa1 in PortalRun (portal=portal@entry=0x564fab590f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x564fab63d118, altdest=altdest@entry=0x564fab63d118, qc=0x7fff359a7920) at ../src/backend/tcop/pquery.c:763 [00:13:03.705] _save_exception_stack = 0x7fff359a79d0 [00:13:03.705] _save_context_stack = 0x0 [00:13:03.705] _local_sigjmp_buf = {{__jmpbuf = {1, 3465960715463650032, 94900177850648, 94900176639960, 94900177145744, 94900176639888, -3465524463036306704, -7167825890961298704}, __mask_was_saved = 0, __saved_mask = {__val = {94900177157304, 94900166540830, 94900177153952, 94900166540830, 1, 140734092703919, 94900176639936, 94900176639888, 94900163565146, 94900166129875, 94900177145744, 94900166540830, 1, 1, 94900163824457, 153}}}} [00:13:03.705] _do_rethrow = [00:13:03.705] result = [00:13:03.705] nprocessed = [00:13:03.705] saveTopTransactionResourceOwner = 0x564fab54e620 [00:13:03.705] saveTopTransactionContext = 0x564fab53cb80 [00:13:03.705] saveActivePortal = 0x0 [00:13:03.705] saveResourceOwner = 0x564fab54e620 [00:13:03.705] savePortalContext = 0x0 [00:13:03.705] saveMemoryContext = 0x564fab53cb80 [00:13:03.705] __func__ = "PortalRun" [00:13:03.705] #18 0x0000564faa5dcf36 in exec_simple_query (query_string=query_string@entry=0x564fab514270 "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 [00:13:03.705] cmdtaglen = 7 [00:13:03.705] snapshot_set = [00:13:03.705] per_parsetree_context = 0x0 [00:13:03.705] plantree_list = 0x564fab63d0c8 [00:13:03.705] parsetree = 0x564fab515790 [00:13:03.705] commandTag = [00:13:03.705] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [00:13:03.705] querytree_list = [00:13:03.705] portal = 0x564fab590f90 [00:13:03.705] receiver = 0x564fab63d118 [00:13:03.705] format = 0 [00:13:03.705] cmdtagname = [00:13:03.705] parsetree_item__state = {l = , i = } [00:13:03.705] dest = DestRemote [00:13:03.705] oldcontext = 0x564fab53cb80 [00:13:03.705] parsetree_list = 0x564fab5157c0 [00:13:03.705] parsetree_item = 0x564fab5157d8 [00:13:03.705] save_log_statement_stats = false [00:13:03.705] was_logged = false [00:13:03.705] use_implicit_block = false [00:13:03.705] msec_str = "\000\000\000\000\000\000\000\000\246\255\212\252OV\000\000\260y\232\065\377\177\000\000q\000\000\000\000\000\000" [00:13:03.705] __func__ = "exec_simple_query" [00:13:03.705] #19 0x0000564faa5dfcee in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [00:13:03.705] query_string = 0x564fab514270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [00:13:03.705] firstchar = [00:13:03.705] input_message = {data = 0x564fab514270 "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} [00:13:03.705] local_sigjmp_buf = {{__jmpbuf = {94900175940760, -7167823619351155984, 140734092704576, 0, 140734092704724, 1, -3465524462948226320, -7167825893309191440}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140313787588068, 94900176609024, 15616, 15680, 94900163735847, 94900175940768, 94900176634224, 94900175934872, 0, 140734092704724, 94900163739915, 1}}}} [00:13:03.705] send_ready_for_query = false [00:13:03.705] idle_in_transaction_timeout_enabled = false [00:13:03.705] idle_session_timeout_enabled = false [00:13:03.705] __func__ = "PostgresMain" [00:13:03.705] #20 0x0000564faa48308d in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [00:13:03.705] No locals. [00:13:03.705] #21 0x0000564faa4888d2 in BackendStartup (client_sock=client_sock@entry=0x7fff359a7b40) at ../src/backend/postmaster/postmaster.c:4117 [00:13:03.705] bn = 0x564fab53cc58 [00:13:03.705] pid = 0 [00:13:03.705] cac = CAC_OK [00:13:03.705] __func__ = "BackendStartup" [00:13:03.705] #22 0x0000564faa488ceb in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [00:13:03.705] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\214Y\235\177\000\000\001\000\000\000\000\000\000\000\244\363\006[\235\177\000\000-\000\000\000\000\000\000\000\020\036pY\235\177\000\000 \351?Z\235\177\000\000\b|\232\065\377\177\000\000\004|\232\065\377\177\000\000\304{\232\065\377\177\000\000@\216\000\000\001\000\000\000\000\000\000\000OV\000\000\020\036pY\235\177\000\000\340?oY\235\177\000\000\352\177\214Y\235\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [00:13:03.705] i = 0 [00:13:03.705] now = [00:13:03.705] last_lockfile_recheck_time = 1710547795 [00:13:03.705] last_touch_time = 1710547795 [00:13:03.705] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 899316928, events = 32767, fd = 45, user_data = 0x7fff359a7c80}, {pos = 899316880, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 1514137480, user_data = 0x7f9d598c7fea}, {pos = 899317096, events = 32767, fd = 899316928, user_data = 0x7fff359a7cd0}, {pos = 1527184609, events = 32669, fd = 18, user_data = 0x7f9d570c5618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1514136608, events = 32669, fd = -1, user_data = 0x7f9d570c5618}, {pos = 1514136608, events = 32669, fd = 1024, user_data = 0x7f9d5a3fe788}, {pos = 0, events = 0, fd = 8, user_data = 0x7fff359a7cd0}, {pos = -1, events = 0, fd = 1501244602, user_data = 0x7f9d596f4418}, {pos = 1514137888, events = 32669, fd = -1420551144, user_data = 0x564fab53f718}, {pos = -1420584448, events = 22095, fd = -1420551112, user_data = 0x564fab541b71}, {pos = 1527203363, events = 32669, fd = 1, user_data = 0x7f9d598e10f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = -1420730256, user_data = 0x1}, {pos = 1, events = 0, fd = -1420730304, user_data = 0x7f9d5b074623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x564fab539a00}, {pos = 1500464152, events = 32669, fd = 899318064, user_data = 0x7f9d5b07b68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7fff359a8150}, {pos = -1421489568, events = 22095, fd = 2, user_data = 0x564fab45ca60 }, {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 = -1420557400, 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 = 672097, events = 0, fd = 0, user_data = 0xffffffffff000000}, {pos = -1, events = 4294967295, fd = 1735684975, user_data = 0x726765722f776466}, {pos = 1919509295, events = 762541426, fd = 1647143267, 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 = 1500982267, user_data = 0x400}, {pos = -1420746848, events = 22095, fd = 1502327936, user_data = 0x1ab511fa0}, {pos = 784, events = 0, fd = -1431363124, user_data = 0x564fab53f3f0}, {pos = -687218688, events = 1433582438, fd = 4, user_data = 0x564fab540370}, {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 = 0x564fab53f3f0}, {pos = 1, events = 0, fd = -1420561224, user_data = 0x400}, {pos = 0, events = 0, fd = -1433556277, user_data = 0x564fab46ac50 }, {pos = -1433622601, events = 22095, fd = -1420561424, user_data = 0x564fab514170}, {pos = -1420561424, events = 22095, fd = 15, user_data = 0x4a}, {pos = -1433554509, events = 22095, fd = -1420561424, user_data = 0x564faa8db2f5 }, {pos = -1420746848, events = 22095, fd = 1500982267, user_data = 0x0}, {pos = -1440070040, events = 22095, fd = -1420572816, user_data = 0x1ab511fa0}, {pos = 899318216, events = 32767, fd = 0, user_data = 0x564fab53f3f0}, {pos = 1500967338, events = 32669, fd = 1024, user_data = 0x564fab511fa0}, {pos = 1500961008, events = 32669, fd = 0, user_data = 0x564f00000000}, {pos = 0, events = 0, fd = -1420746848, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x9175}, {pos = 1501264645, events = 32669, fd = 8, user_data = 0x5572bb66d709e000}, {pos = 1, events = 0, fd = -1438118901, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x564faa8db1b3 }, {pos = -1420572816, events = 22095, fd = -1433554187, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x564faa2a423b }, {pos = 0, events = 0, fd = -1440047087, user_data = 0x564fab514170}, {pos = -1438091670, events = 22095, fd = 0, user_data = 0x0}} [00:13:03.705] nevents = 1 [00:13:03.705] __func__ = "ServerLoop" [00:13:03.705] #23 0x0000564faa48a705 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564fab50de60) at ../src/backend/postmaster/postmaster.c:1478 [00:13:03.705] opt = [00:13:03.705] status = [00:13:03.705] userDoption = [00:13:03.705] listen_addr_saved = false [00:13:03.705] output_config_variable = [00:13:03.705] __func__ = "PostmasterMain" [00:13:03.705] #24 0x0000564faa2b506b in main (argc=8, argv=0x564fab50de60) at ../src/backend/main/main.c:197 [00:13:03.705] do_check_root =