[18:18:19.556] src/tools/ci/cores_backtrace.sh linux /tmp/cores [18:18:20.276] dumping /tmp/cores/postgres-11-37256.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:18:21.946] [New LWP 37256] [18:18:21.946] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [18:18:22.707] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [18:18:23.473] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [18:18:24.696] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [18:18:27.073] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [18:18:27.073] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [18:18:28.963] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [18:18:30.179] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [18:18:31.771] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [18:18:32.855] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [18:18:33.636] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [18:18:34.881] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [18:18:36.500] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [18:18:37.922] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [18:18:38.849] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [18:18:40.424] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [18:18:41.831] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [18:18:42.307] [Thread debugging using libthread_db enabled] [18:18:42.307] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:18:43.381] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [18:18:44.775] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [18:18:45.844] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [18:18:46.462] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [18:18:47.228] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [18:18:49.509] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [18:18:50.548] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [18:18:51.319] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [18:18:52.238] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [18:18:53.170] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [18:18:54.814] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [18:18:55.891] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [18:18:56.675] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [18:18:58.131] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [18:18:58.776] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [18:19:00.357] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [18:19:01.151] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [18:19:02.451] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [18:19:03.256] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [18:19:04.381] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [18:19:05.345] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [18:19:06.616] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [18:19:07.260] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [18:19:08.214] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [18:19:09.011] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [18:19:10.278] Downloading separate debug info for /lib/x86_64-linux-gnu/libnss_files.so.2... [18:19:10.827] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN '. [18:19:10.827] Program terminated with signal SIGSEGV, Segmentation fault. [18:19:10.827] #0 0x00005595c8d6ba3f in equal (a=0xffffffffcb5ec658, b=b@entry=0x5595cb4d9568) at ../src/backend/nodes/equalfuncs.c:239 [18:19:10.827] 239 if (nodeTag(a) != nodeTag(b)) [18:19:11.161] [18:19:11.161] Thread 1 (Thread 0x7f95e48dba40 (LWP 37256)): [18:19:11.161] #0 0x00005595c8d6ba3f in equal (a=0xffffffffcb5ec658, b=b@entry=0x5595cb4d9568) at ../src/backend/nodes/equalfuncs.c:239 [18:19:11.161] retval = [18:19:11.161] __func__ = "equal" [18:19:11.161] #1 0x00005595c86adb57 in list_member (list=0x5595cb5ec6c8, datum=datum@entry=0x5595cb4d9568) at ../src/backend/nodes/list.c:670 [18:19:11.161] cell__state = {l = , i = } [18:19:11.161] cell = [18:19:11.161] #2 0x00005595c87d11be in add_new_column_to_pathtarget (target=target@entry=0x5595cb5ec5e8, expr=0x5595cb4d9568) at ../src/backend/optimizer/util/tlist.c:743 [18:19:11.161] No locals. [18:19:11.161] #3 0x00005595c87d1259 in add_new_columns_to_pathtarget (target=target@entry=0x5595cb5ec5e8, exprs=exprs@entry=0x5595cb5ec768) at ../src/backend/optimizer/util/tlist.c:760 [18:19:11.161] expr = [18:19:11.161] lc__state = {l = , i = } [18:19:11.161] lc = [18:19:11.161] #4 0x00005595c8749916 in make_group_input_target (root=root@entry=0x5595cb4d8e78, final_target=final_target@entry=0x5595cb5ec548) at ../src/backend/optimizer/plan/planner.c:5472 [18:19:11.161] parse = 0x5595cb481920 [18:19:11.161] input_target = 0x5595cb5ec5e8 [18:19:11.161] non_group_cols = 0x5595cb5ec718 [18:19:11.161] non_group_vars = 0x5595cb5ec768 [18:19:11.161] i = 2 [18:19:11.161] lc = 0x0 [18:19:11.161] #5 0x00005595c875cc38 in grouping_planner (root=root@entry=0x5595cb4d8e78, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:19:11.161] sort_input_targets = 0x5595cb4d9398 [18:19:11.161] sort_input_target_parallel_safe = true [18:19:11.161] grouping_target = 0x5595cb5ec548 [18:19:11.161] scanjoin_target = [18:19:11.161] activeWindows = 0x0 [18:19:11.161] qp_extra = {activeWindows = 0x0, gset_data = 0x5595cb594d78} [18:19:11.161] sort_input_targets_contain_srfs = 0x5595cb594cd8 [18:19:11.161] have_grouping = [18:19:11.161] wflists = 0x0 [18:19:11.161] gset_data = 0x5595cb594d78 [18:19:11.161] sort_input_target = 0x5595cb5ec548 [18:19:11.161] grouping_targets = 0x5595cb4d8e78 [18:19:11.161] grouping_target_parallel_safe = true [18:19:11.161] scanjoin_targets = 0x1 [18:19:11.161] scanjoin_target_parallel_safe = [18:19:11.161] grouping_targets_contain_srfs = 0x5595c8ccf7ba [18:19:11.161] scanjoin_targets_contain_srfs = 0x5595c86ac952 [18:19:11.161] scanjoin_target_same_exprs = [18:19:11.161] parse = 0x5595cb481920 [18:19:11.161] offset_est = 0 [18:19:11.161] count_est = 0 [18:19:11.161] limit_tuples = -1 [18:19:11.161] have_postponed_srfs = false [18:19:11.161] final_target = 0x5595cb5ec548 [18:19:11.161] final_targets = 0x5595cb5a97a8 [18:19:11.161] final_targets_contain_srfs = 0x5595c86b28dc [18:19:11.161] final_target_parallel_safe = true [18:19:11.161] current_rel = 0x5595cb5bb2b8 [18:19:11.161] final_rel = [18:19:11.161] extra = {limit_needed = false, limit_tuples = 4.6492467051282632e-310, count_est = 94101850115288, offset_est = 94101850115288} [18:19:11.161] lc = [18:19:11.161] __func__ = "grouping_planner" [18:19:11.161] #6 0x00005595c875fadc in subquery_planner (glob=glob@entry=0x5595cb5bb1a8, parse=parse@entry=0x5595cb481920, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:19:11.161] root = 0x5595cb4d8e78 [18:19:11.161] newWithCheckOptions = [18:19:11.161] newHaving = 0x0 [18:19:11.161] hasOuterJoins = [18:19:11.161] hasResultRTEs = false [18:19:11.161] final_rel = [18:19:11.161] l = 0x0 [18:19:11.161] #7 0x00005595c8760731 in standard_planner (parse=0x5595cb481920, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [18:19:11.161] result = [18:19:11.161] glob = 0x5595cb5bb1a8 [18:19:11.161] tuple_fraction = 0 [18:19:11.161] root = [18:19:11.161] final_rel = [18:19:11.161] best_path = [18:19:11.161] top_plan = [18:19:11.161] lp = [18:19:11.161] lr = [18:19:11.161] #8 0x00005595c87617f5 in planner (parse=parse@entry=0x5595cb481920, query_string=query_string@entry=0x5595cb480270 "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 [18:19:11.161] result = [18:19:11.161] #9 0x00005595c89cfcf7 in pg_plan_query (querytree=querytree@entry=0x5595cb481920, query_string=query_string@entry=0x5595cb480270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:19:11.161] plan = [18:19:11.161] #10 0x00005595c84c0f5d in standard_ExplainOneQuery (query=0x5595cb481920, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5595cb5f1158, queryString=0x5595cb480270 "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 [18:19:11.161] plan = [18:19:11.161] planstart = {ticks = } [18:19:11.161] planduration = {ticks = 94101848987936} [18:19:11.161] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94101796311896, shared_blks_dirtied = 94101848988208, shared_blks_written = 70368744194107, local_blks_hit = 0, local_blks_read = 94101797633132, local_blks_dirtied = 94101848988208, local_blks_written = 94101803467706, temp_blks_read = 1, temp_blks_written = 2048, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94098438488064}, local_blk_read_time = {ticks = 94101848987664}, local_blk_write_time = {ticks = 94101807364026}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94101800929618}} [18:19:11.161] bufusage = {shared_blks_hit = 94101850272008, shared_blks_read = 1, shared_blks_dirtied = 0, shared_blks_written = 1, local_blks_hit = 0, local_blks_read = 94101803988430, local_blks_dirtied = 70622147264512, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 16443, shared_blk_read_time = {ticks = 140281608128488}, shared_blk_write_time = {ticks = 94101850272008}, local_blk_read_time = {ticks = 94101848987936}, local_blk_write_time = {ticks = 94101806881934}, temp_blk_read_time = {ticks = 140281608128488}, temp_blk_write_time = {ticks = 94101806881953}} [18:19:11.161] mem_counters = {nblocks = 0, freechunks = 1, totalspace = 0, freespace = 94101807105243} [18:19:11.161] planner_ctx = 0x0 [18:19:11.161] saved_ctx = 0x0 [18:19:11.161] #11 0x00005595c84c11f5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5595cb5f1158, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:397 [18:19:11.161] No locals. [18:19:11.161] #12 0x00005595c84c27ec in ExplainQuery (pstate=pstate@entry=0x5595cb5f1048, stmt=stmt@entry=0x5595cb481760, params=params@entry=0x0, dest=dest@entry=0x5595cb5f0fb8) at ../src/include/nodes/nodes.h:172 [18:19:11.161] l__state = {l = , i = } [18:19:11.161] l = 0x5595cb5bb170 [18:19:11.161] es = 0x5595cb5f1158 [18:19:11.161] tstate = [18:19:11.161] jstate = [18:19:11.161] query = [18:19:11.161] rewritten = 0x5595cb5bb158 [18:19:11.161] lc = 0x0 [18:19:11.161] timing_set = false [18:19:11.161] summary_set = false [18:19:11.161] __func__ = "ExplainQuery" [18:19:11.161] #13 0x00005595c89da705 in standard_ProcessUtility (pstmt=0x5595cb481810, queryString=0x5595cb480270 "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=0x5595cb5f0fb8, qc=0x7ffc81bd2e50) at ../src/backend/tcop/utility.c:863 [18:19:11.161] parsetree = 0x5595cb481760 [18:19:11.161] isTopLevel = true [18:19:11.161] isAtomicContext = false [18:19:11.161] pstate = 0x5595cb5f1048 [18:19:11.161] readonly_flags = [18:19:11.161] __func__ = "standard_ProcessUtility" [18:19:11.161] #14 0x00005595c89dae2e in ProcessUtility (pstmt=pstmt@entry=0x5595cb481810, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5595cb5f0fb8, qc=0x7ffc81bd2e50) at ../src/backend/tcop/utility.c:523 [18:19:11.161] No locals. [18:19:11.161] #15 0x00005595c89d658c in PortalRunUtility (portal=portal@entry=0x5595cb4fcf90, pstmt=0x5595cb481810, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5595cb5f0fb8, qc=qc@entry=0x7ffc81bd2e50) at ../src/backend/tcop/pquery.c:1158 [18:19:11.161] No locals. [18:19:11.161] #16 0x00005595c89d6f6f in FillPortalStore (portal=portal@entry=0x5595cb4fcf90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [18:19:11.161] treceiver = 0x5595cb5f0fb8 [18:19:11.161] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:19:11.161] __func__ = "FillPortalStore" [18:19:11.161] #17 0x00005595c89d75f1 in PortalRun (portal=portal@entry=0x5595cb4fcf90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5595cb5a9b68, altdest=altdest@entry=0x5595cb5a9b68, qc=0x7ffc81bd3030) at ../src/backend/tcop/pquery.c:763 [18:19:11.161] _save_exception_stack = 0x7ffc81bd30e0 [18:19:11.161] _save_context_stack = 0x0 [18:19:11.161] _local_sigjmp_buf = {{__jmpbuf = {1, -8401499282215809399, 94101850200936, 94101848987608, 94101849493392, 94101848987536, 8403404163070021257, 2327360248072883849}, __mask_was_saved = 0, __saved_mask = {__val = {140722485145535, 94101810080862, 94101849501600, 94101810080862, 1, 140722485145535, 94101848987584, 94101848987536, 94101807105243, 94101809669811, 94101849493392, 94101810080862, 1, 1, 94101807364428, 153}}}} [18:19:11.161] _do_rethrow = [18:19:11.161] result = [18:19:11.161] nprocessed = [18:19:11.161] saveTopTransactionResourceOwner = 0x5595cb4c8a98 [18:19:11.161] saveTopTransactionContext = 0x5595cb4a8b80 [18:19:11.161] saveActivePortal = 0x0 [18:19:11.161] saveResourceOwner = 0x5595cb4c8a98 [18:19:11.161] savePortalContext = 0x0 [18:19:11.161] saveMemoryContext = 0x5595cb4a8b80 [18:19:11.161] __func__ = "PortalRun" [18:19:11.161] #18 0x00005595c89d0586 in exec_simple_query (query_string=query_string@entry=0x5595cb480270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;") at ../src/backend/tcop/postgres.c:1273 [18:19:11.161] cmdtaglen = 7 [18:19:11.161] snapshot_set = [18:19:11.161] per_parsetree_context = 0x0 [18:19:11.161] plantree_list = 0x5595cb5a9b18 [18:19:11.161] parsetree = 0x5595cb481790 [18:19:11.161] commandTag = [18:19:11.161] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:19:11.161] querytree_list = [18:19:11.161] portal = 0x5595cb4fcf90 [18:19:11.161] receiver = 0x5595cb5a9b68 [18:19:11.161] format = 0 [18:19:11.161] cmdtagname = [18:19:11.161] parsetree_item__state = {l = , i = } [18:19:11.161] dest = DestRemote [18:19:11.161] oldcontext = 0x5595cb4a8b80 [18:19:11.161] parsetree_list = 0x5595cb4817c0 [18:19:11.161] parsetree_item = 0x5595cb4817d8 [18:19:11.161] save_log_statement_stats = false [18:19:11.161] was_logged = false [18:19:11.161] use_implicit_block = false [18:19:11.161] msec_str = "\004\000\000\000\000\000\000\000t\333\311ȕU\000\000\300\060\275\201\374\177\000\000q\000\000\000\000\000\000" [18:19:11.161] __func__ = "exec_simple_query" [18:19:11.161] #19 0x00005595c89d333e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [18:19:11.161] query_string = 0x5595cb480270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [18:19:11.161] firstchar = [18:19:11.161] input_message = {data = 0x5595cb480270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", len = 113, maxlen = 1024, cursor = 113} [18:19:11.161] local_sigjmp_buf = {{__jmpbuf = {94101819479224, 2327362521395351177, 0, 4, 140722485146196, 1, 8403404162730282633, 2327360246393982601}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140281801940452, 94101848956672, 15616, 15680, 94101807275818, 94101819479232, 94101848981872, 94101819473336, 4, 140722485146196, 94101807279886, 1}}}} [18:19:11.161] send_ready_for_query = false [18:19:11.161] idle_in_transaction_timeout_enabled = false [18:19:11.161] idle_session_timeout_enabled = false [18:19:11.161] __func__ = "PostgresMain" [18:19:11.161] #20 0x00005595c8876778 in BackendRun (port=port@entry=0x5595cb4accd0) at ../src/backend/postmaster/postmaster.c:4475 [18:19:11.161] No locals. [18:19:11.161] #21 0x00005595c887c060 in BackendStartup (port=port@entry=0x5595cb4accd0) at ../src/backend/postmaster/postmaster.c:4151 [18:19:11.161] bn = 0x5595cb4a8ca8 [18:19:11.161] pid = 0 [18:19:11.161] __func__ = "BackendStartup" [18:19:11.161] #22 0x00005595c887c3dd in ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:19:11.161] port = 0x5595cb4accd0 [18:19:11.161] i = 0 [18:19:11.161] now = [18:19:11.161] last_lockfile_recheck_time = 1710180967 [18:19:11.161] last_touch_time = 1710180967 [18:19:11.161] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -2118307008, events = 32764, fd = 45, user_data = 0x7ffc81bd3300}, {pos = -2118307056, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = -406739064, user_data = 0x7f95e70e3fea}, {pos = -2118306840, events = 32764, fd = -2118307008, user_data = 0x7ffc81bd3350}, {pos = -393691935, events = 32661, fd = 18, user_data = 0x7f95e48e1618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -406739936, events = 32661, fd = -1, user_data = 0x7f95e48e1618}, {pos = -406739936, events = 32661, fd = 1024, user_data = 0x7f95e7c1a788}, {pos = 0, events = 0, fd = 8, user_data = 0x7ffc81bd3350}, {pos = -1, events = 0, fd = -419631942, user_data = 0x7f95e6f10418}, {pos = -406738656, events = 32661, fd = -884286440, user_data = 0x5595cb4ab718}, {pos = -884319744, events = 21909, fd = -884286408, user_data = 0x5595cb4adb71}, {pos = -393673181, events = 32661, fd = 1, user_data = 0x7f95e70fd0f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = -884465552, user_data = 0x1}, {pos = 1, events = 0, fd = -884465600, user_data = 0x7f95e8890623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x5595cb4a5a00}, {pos = -420412392, events = 32661, fd = -2118305872, user_data = 0x7f95e889768a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffc81bd37d0}, {pos = -914034048, events = 21909, fd = 2, user_data = 0x5595c984f280 }, {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 = -884292696, 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 = 680777, 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 = -419894277, user_data = 0x400}, {pos = -884482144, events = 21909, fd = -418548608, user_data = 0x1cb47dfa0}, {pos = 784, events = 0, fd = -923906196, user_data = 0x5595cb4ab3f0}, {pos = 1928356864, events = 2244594544, fd = 4, user_data = 0x5595cb4ac370}, {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 = 0x5595cb4ab3f0}, {pos = 1, events = 0, fd = -884296520, user_data = 0x400}, {pos = 0, events = 0, fd = -926099250, user_data = 0x5595c985d470 }, {pos = -926165574, events = 21909, fd = -884296720, user_data = 0x5595cb480170}, {pos = -884296720, events = 21909, fd = 15, user_data = 0x4a}, {pos = -926097482, events = 21909, fd = -884296720, user_data = 0x5595c8cce0f8 }, {pos = -884482144, events = 21909, fd = -419894277, user_data = 0x0}, {pos = -932610465, events = 21909, fd = -884308112, user_data = 0x1cb47dfa0}, {pos = -2118305720, events = 32764, fd = 0, user_data = 0x5595cb4ab3f0}, {pos = -419909206, events = 32661, fd = 1024, user_data = 0x5595cb47dfa0}, {pos = -419915536, events = 32661, fd = 0, user_data = 0x559500000000}, {pos = 0, events = 0, fd = -884482144, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x911f}, {pos = -419611899, events = 32661, fd = 8, user_data = 0x85c9cb7072f06400}, {pos = 1, events = 0, fd = -930659567, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x5595c8ccdfb6 }, {pos = -884308112, events = 21909, fd = -926097160, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5595c8697a32 }, {pos = 0, events = 0, fd = -932587512, user_data = 0x5595cb480170}, {pos = -930632274, events = 21909, fd = 0, user_data = 0x0}} [18:19:11.162] nevents = 1 [18:19:11.162] __func__ = "ServerLoop" [18:19:11.162] #23 0x00005595c887de6f in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5595cb479e60) at ../src/backend/postmaster/postmaster.c:1468 [18:19:11.162] opt = [18:19:11.162] status = [18:19:11.162] userDoption = [18:19:11.162] listen_addr_saved = false [18:19:11.162] output_config_variable = [18:19:11.162] __func__ = "PostmasterMain" [18:19:11.162] #24 0x00005595c86a882c in main (argc=8, argv=0x5595cb479e60) at ../src/backend/main/main.c:197 [18:19:11.162] do_check_root = [18:19:11.189] -e [18:19:11.189] [18:19:11.189] [18:19:11.785] dumping /tmp/cores/postgres-11-28384.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:19:12.148] [New LWP 28384] [18:19:13.463] [Thread debugging using libthread_db enabled] [18:19:13.463] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:19:14.993] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [18:19:14.993] Program terminated with signal SIGSEGV, Segmentation fault. [18:19:14.993] #0 0x00005571f7cffa3f in equal (a=0xfffffffff97d49a8, b=b@entry=0x5571f97d17a8) at ../src/backend/nodes/equalfuncs.c:239 [18:19:14.993] 239 if (nodeTag(a) != nodeTag(b)) [18:19:15.114] [18:19:15.114] Thread 1 (Thread 0x7f84b005ca40 (LWP 28384)): [18:19:15.114] #0 0x00005571f7cffa3f in equal (a=0xfffffffff97d49a8, b=b@entry=0x5571f97d17a8) at ../src/backend/nodes/equalfuncs.c:239 [18:19:15.114] retval = [18:19:15.114] __func__ = "equal" [18:19:15.114] #1 0x00005571f7641b57 in list_member (list=0x5571f97d4a18, datum=datum@entry=0x5571f97d17a8) at ../src/backend/nodes/list.c:670 [18:19:15.114] cell__state = {l = , i = } [18:19:15.114] cell = [18:19:15.114] #2 0x00005571f77651be in add_new_column_to_pathtarget (target=target@entry=0x5571f97d4938, expr=0x5571f97d17a8) at ../src/backend/optimizer/util/tlist.c:743 [18:19:15.114] No locals. [18:19:15.114] #3 0x00005571f7765259 in add_new_columns_to_pathtarget (target=target@entry=0x5571f97d4938, exprs=exprs@entry=0x5571f97d4b48) at ../src/backend/optimizer/util/tlist.c:760 [18:19:15.114] expr = [18:19:15.114] lc__state = {l = , i = } [18:19:15.114] lc = [18:19:15.114] #4 0x00005571f76dd916 in make_group_input_target (root=root@entry=0x5571f97c99b8, final_target=final_target@entry=0x5571f97d47d8) at ../src/backend/optimizer/plan/planner.c:5472 [18:19:15.114] parse = 0x5571f96a2d08 [18:19:15.114] input_target = 0x5571f97d4938 [18:19:15.114] non_group_cols = 0x5571f97d4af8 [18:19:15.114] non_group_vars = 0x5571f97d4b48 [18:19:15.114] i = 6 [18:19:15.114] lc = 0x0 [18:19:15.114] #5 0x00005571f76f0c38 in grouping_planner (root=root@entry=0x5571f97c99b8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:19:15.114] sort_input_targets = 0x5571f97d1618 [18:19:15.114] sort_input_target_parallel_safe = true [18:19:15.114] grouping_target = 0x5571f97d47d8 [18:19:15.114] scanjoin_target = [18:19:15.114] activeWindows = 0x0 [18:19:15.114] qp_extra = {activeWindows = 0x0, gset_data = 0x5571f97d2c38} [18:19:15.114] sort_input_targets_contain_srfs = 0x5571f77270ae [18:19:15.114] have_grouping = [18:19:15.114] wflists = 0x0 [18:19:15.114] gset_data = 0x5571f97d2c38 [18:19:15.114] sort_input_target = 0x5571f97d47d8 [18:19:15.114] grouping_targets = 0x0 [18:19:15.114] grouping_target_parallel_safe = true [18:19:15.114] scanjoin_targets = 0x0 [18:19:15.114] scanjoin_target_parallel_safe = [18:19:15.114] grouping_targets_contain_srfs = 0x5571f764f2a3 [18:19:15.114] scanjoin_targets_contain_srfs = 0x5571f97cde88 [18:19:15.114] scanjoin_target_same_exprs = [18:19:15.114] parse = 0x5571f96a2d08 [18:19:15.114] offset_est = 0 [18:19:15.114] count_est = 0 [18:19:15.114] limit_tuples = -1 [18:19:15.114] have_postponed_srfs = false [18:19:15.114] final_target = 0x5571f97d47d8 [18:19:15.114] final_targets = 0x0 [18:19:15.114] final_targets_contain_srfs = 0x5571f772d3a5 [18:19:15.114] final_target_parallel_safe = true [18:19:15.114] current_rel = 0x5571f97c9dc8 [18:19:15.114] final_rel = [18:19:15.114] extra = {limit_needed = 184, limit_tuples = 1.9762625833649862e-323, count_est = 93948005358008, offset_est = 0} [18:19:15.114] lc = [18:19:15.114] __func__ = "grouping_planner" [18:19:15.114] #6 0x00005571f76f3adc in subquery_planner (glob=glob@entry=0x5571f96a2f78, parse=parse@entry=0x5571f96a2d08, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:19:15.114] root = 0x5571f97c99b8 [18:19:15.114] newWithCheckOptions = [18:19:15.114] newHaving = 0x0 [18:19:15.114] hasOuterJoins = [18:19:15.114] hasResultRTEs = false [18:19:15.114] final_rel = [18:19:15.114] l = 0x0 [18:19:15.114] #7 0x00005571f76f4731 in standard_planner (parse=0x5571f96a2d08, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [18:19:15.114] result = [18:19:15.114] glob = 0x5571f96a2f78 [18:19:15.114] tuple_fraction = 0 [18:19:15.114] root = [18:19:15.114] final_rel = [18:19:15.114] best_path = [18:19:15.114] top_plan = [18:19:15.114] lp = [18:19:15.114] lr = [18:19:15.114] #8 0x00005571f76f57f5 in planner (parse=parse@entry=0x5571f96a2d08, query_string=query_string@entry=0x5571f96a1250 "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 [18:19:15.114] result = [18:19:15.114] #9 0x00005571f7963cf7 in pg_plan_query (querytree=querytree@entry=0x5571f96a2d08, query_string=query_string@entry=0x5571f96a1250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:19:15.114] plan = [18:19:15.114] #10 0x00005571f7964064 in pg_plan_queries (querytrees=0x5571f97ce228, query_string=query_string@entry=0x5571f96a1250 "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:995 [18:19:15.114] query = 0x5571f96a2d08 [18:19:15.114] stmt = [18:19:15.114] query_list__state = {l = , i = } [18:19:15.114] stmt_list = 0x0 [18:19:15.114] query_list = [18:19:15.114] #11 0x00005571f796443e in exec_simple_query (query_string=query_string@entry=0x5571f96a1250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [18:19:15.114] cmdtaglen = 6 [18:19:15.114] snapshot_set = true [18:19:15.114] per_parsetree_context = 0x0 [18:19:15.114] plantree_list = [18:19:15.114] parsetree = 0x5571f96a2b78 [18:19:15.114] commandTag = CMDTAG_SELECT [18:19:15.114] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 93948004143696} [18:19:15.114] querytree_list = [18:19:15.114] portal = [18:19:15.114] receiver = [18:19:15.114] format = 0 [18:19:15.114] cmdtagname = [18:19:15.114] parsetree_item__state = {l = , i = } [18:19:15.114] dest = DestRemote [18:19:15.114] oldcontext = 0x5571f96d4410 [18:19:15.114] parsetree_list = 0x5571f96a2ba8 [18:19:15.114] parsetree_item = 0x5571f96a2bc0 [18:19:15.114] save_log_statement_stats = false [18:19:15.114] was_logged = true [18:19:15.114] use_implicit_block = false [18:19:15.114] msec_str = "\004\000\000\000\000\000\000\000t\033\303\367qU\000\000 \207\346\215\377\177\000\000[\000\000\000\000\000\000" [18:19:15.114] __func__ = "exec_simple_query" [18:19:15.114] #12 0x00005571f796733e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [18:19:15.114] query_string = 0x5571f96a1250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [18:19:15.114] firstchar = [18:19:15.114] input_message = {data = 0x5571f96a1250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [18:19:15.114] local_sigjmp_buf = {{__jmpbuf = {93947988743352, -1603829880639833094, 0, 4, 140735574083764, 1, -4854064510416307206, -1603823619359622150}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 140207906172388, 93948004118272, 14336, 14400, 93947976539946, 93947988743360, 93948004143440, 93947988737464, 4, 140735574083764, 93947976544014, 1}}}} [18:19:15.114] send_ready_for_query = false [18:19:15.114] idle_in_transaction_timeout_enabled = false [18:19:15.114] idle_session_timeout_enabled = false [18:19:15.114] __func__ = "PostgresMain" [18:19:15.114] #13 0x00005571f780a778 in BackendRun (port=port@entry=0x5571f96cc610) at ../src/backend/postmaster/postmaster.c:4475 [18:19:15.114] No locals. [18:19:15.114] #14 0x00005571f7810060 in BackendStartup (port=port@entry=0x5571f96cc610) at ../src/backend/postmaster/postmaster.c:4151 [18:19:15.114] bn = 0x5571f96d6778 [18:19:15.114] pid = 0 [18:19:15.114] __func__ = "BackendStartup" [18:19:15.114] #15 0x00005571f78103dd in ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:19:15.114] port = 0x5571f96cc610 [18:19:15.114] i = 0 [18:19:15.114] now = [18:19:15.114] last_lockfile_recheck_time = 1710180918 [18:19:15.114] last_touch_time = 1710180918 [18:19:15.114] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1914271484, events = 32767, fd = -1341563328, user_data = 0x7fff8de689d0}, {pos = -1299832032, events = 32644, fd = -1914271296, user_data = 0x2d}, {pos = -1274879616, events = 32644, fd = 8, user_data = 0x0}, {pos = -1274879616, events = 32644, fd = 1508362478, user_data = 0x7f84b339b788}, {pos = -1299820566, events = 32644, fd = -1914271128, user_data = 0x7fff8de689c0}, {pos = -1914271280, events = 32767, fd = -1275015967, user_data = 0x12}, {pos = -1341774312, events = 32644, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1288063968, user_data = 0x7fff8de68aae}, {pos = -1341774312, events = 32644, fd = -1288063968, user_data = 0x1f81368a0}, {pos = -1288063096, events = 32644, fd = 0, user_data = 0x5571f96c8a80}, {pos = -110320616, events = 21873, fd = -1, user_data = 0x7f84b4011623 <_dl_fixup+211>}, {pos = -1301736424, events = 32644, fd = -1288062688, user_data = 0x1000}, {pos = -1301689864, events = 32644, fd = -1914270304, user_data = 0x7f84b401868a <_dl_runtime_resolve_xsavec+122>}, {pos = 16, events = 0, fd = 16777343, user_data = 0x10}, {pos = -1299717896, events = 32644, fd = 4, user_data = 0x5571f96a3010}, {pos = 1, events = 0, fd = 1, user_data = 0x5571f96a2ff0}, {pos = -1274997213, events = 32644, fd = 1, user_data = 0x0}, {pos = -110481424, events = 21873, fd = -1301736424, user_data = 0x7fff8de68e10}, {pos = -1274968438, events = 32644, fd = 0, user_data = 0x0}, {pos = -1914270160, events = 32767, fd = -125947264, user_data = 0x2}, {pos = -125947264, events = 21873, fd = 0, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 8096, events = 196607, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0xffff0000ffffff00}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -110320728, user_data = 0x3ff}, {pos = 4096, events = 0, fd = -110497888, user_data = 0x5571f969efa0}, {pos = 0, events = 0, fd = -1301295659, 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 = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {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 = 0, events = 0, fd = -1299872640, user_data = 0x1f969efa0}, {pos = 784, events = 0, fd = -135819412, user_data = 0x5571f96c9f60}, {pos = -1793851648, events = 1008243073, fd = 4, user_data = 0x5571f96ca370}, {pos = -110321824, events = 21873, fd = -110321624, user_data = 0x400}, {pos = -110321624, events = 21873, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -138012466, user_data = 0x5571f87f1470 }, {pos = -138078790, events = 21873, fd = -110321824, user_data = 0x5571f96a1150}, {pos = -110321824, events = 21873, fd = 15, user_data = 0x4a}, {pos = -138010698, events = 21873, fd = -110321824, user_data = 0x5571f7c620f8 }, {pos = -110497888, events = 21873, fd = -1301218002, user_data = 0x0}, {pos = -144523681, events = 21873, fd = -110326976, user_data = 0x1f969efa0}, {pos = -1914270040, events = 32767, fd = 0, user_data = 0x5571f96c9f60}, {pos = -1301233238, events = 32644, fd = 1024, user_data = 0x5571f969efa0}, {pos = -1301239568, events = 32644, fd = 0, user_data = 0x557100000000}, {pos = 0, events = 0, fd = -110497888, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x5dd2}, {pos = -1300935931, events = 32644, fd = 4, user_data = 0x3c1891819513ff00}, {pos = 1, events = 0, fd = -142572783, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x5571f7c61fb6 }, {pos = -110326976, events = 21873, fd = -138010376, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5571f762ba32 }, {pos = 0, events = 0, fd = -144500728, user_data = 0x5571f96a1150}, {pos = -142545490, events = 21873, fd = 0, user_data = 0x0}} [18:19:15.114] nevents = 1 [18:19:15.114] __func__ = "ServerLoop" [18:19:15.114] #16 0x00005571f7811e6f in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5571f969ae10) at ../src/backend/postmaster/postmaster.c:1468 [18:19:15.114] opt = [18:19:15.114] status = [18:19:15.114] userDoption = [18:19:15.114] listen_addr_saved = false [18:19:15.114] output_config_variable = [18:19:15.114] __func__ = "PostmasterMain" [18:19:15.114] #17 0x00005571f763c82c in main (argc=4, argv=0x5571f969ae10) at ../src/backend/main/main.c:197 [18:19:15.114] do_check_root = [18:19:15.138] -e [18:19:15.138] [18:19:15.138] [18:19:15.698] dumping /tmp/cores/postgres-11-29097.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:19:16.078] [New LWP 29097] [18:19:17.463] [Thread debugging using libthread_db enabled] [18:19:17.463] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:19:19.071] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [18:19:19.071] Program terminated with signal SIGSEGV, Segmentation fault. [18:19:19.071] #0 0x0000561db89a6a3f in equal (a=0xffffffffbb01ddb0, b=b@entry=0x561dbb04f2b8) at ../src/backend/nodes/equalfuncs.c:239 [18:19:19.071] 239 if (nodeTag(a) != nodeTag(b)) [18:19:19.267] [18:19:19.267] Thread 1 (Thread 0x7f4a7ba81a40 (LWP 29097)): [18:19:19.267] #0 0x0000561db89a6a3f in equal (a=0xffffffffbb01ddb0, b=b@entry=0x561dbb04f2b8) at ../src/backend/nodes/equalfuncs.c:239 [18:19:19.267] retval = [18:19:19.267] __func__ = "equal" [18:19:19.267] #1 0x0000561db82e8b57 in list_member (list=0x561dbb01de20, datum=datum@entry=0x561dbb04f2b8) at ../src/backend/nodes/list.c:670 [18:19:19.267] cell__state = {l = , i = } [18:19:19.267] cell = [18:19:19.267] #2 0x0000561db840c1be in add_new_column_to_pathtarget (target=target@entry=0x561dbb01dd40, expr=0x561dbb04f2b8) at ../src/backend/optimizer/util/tlist.c:743 [18:19:19.267] No locals. [18:19:19.267] #3 0x0000561db840c259 in add_new_columns_to_pathtarget (target=target@entry=0x561dbb01dd40, exprs=exprs@entry=0x561dbb01ded8) at ../src/backend/optimizer/util/tlist.c:760 [18:19:19.267] expr = [18:19:19.267] lc__state = {l = , i = } [18:19:19.267] lc = [18:19:19.267] #4 0x0000561db8384916 in make_group_input_target (root=root@entry=0x561dbb04ebc8, final_target=final_target@entry=0x561dbb01dc58) at ../src/backend/optimizer/plan/planner.c:5472 [18:19:19.267] parse = 0x561dbaefd788 [18:19:19.267] input_target = 0x561dbb01dd40 [18:19:19.267] non_group_cols = 0x561dbb01de88 [18:19:19.267] non_group_vars = 0x561dbb01ded8 [18:19:19.267] i = 2 [18:19:19.267] lc = 0x0 [18:19:19.267] #5 0x0000561db8397c38 in grouping_planner (root=root@entry=0x561dbb04ebc8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:19:19.267] sort_input_targets = 0x561dbb04f0e8 [18:19:19.267] sort_input_target_parallel_safe = true [18:19:19.267] grouping_target = 0x561dbb01dc58 [18:19:19.267] scanjoin_target = [18:19:19.267] activeWindows = 0x0 [18:19:19.267] qp_extra = {activeWindows = 0x0, gset_data = 0x561dbb052398} [18:19:19.267] sort_input_targets_contain_srfs = 0x561db83ce0ae [18:19:19.267] have_grouping = [18:19:19.267] wflists = 0x0 [18:19:19.267] gset_data = 0x561dbb052398 [18:19:19.267] sort_input_target = 0x561dbb01dc58 [18:19:19.267] grouping_targets = 0x0 [18:19:19.267] grouping_target_parallel_safe = true [18:19:19.267] scanjoin_targets = 0x0 [18:19:19.267] scanjoin_target_parallel_safe = [18:19:19.267] grouping_targets_contain_srfs = 0x561db82f62a3 [18:19:19.267] scanjoin_targets_contain_srfs = 0x0 [18:19:19.267] scanjoin_target_same_exprs = [18:19:19.267] parse = 0x561dbaefd788 [18:19:19.267] offset_est = 0 [18:19:19.267] count_est = 0 [18:19:19.267] limit_tuples = -1 [18:19:19.267] have_postponed_srfs = false [18:19:19.267] final_target = 0x561dbb01dc58 [18:19:19.267] final_targets = 0x561dbaf332f8 [18:19:19.267] final_targets_contain_srfs = 0x561db83ce0e3 [18:19:19.267] final_target_parallel_safe = true [18:19:19.267] current_rel = 0x561dbb04e978 [18:19:19.267] final_rel = [18:19:19.267] extra = {limit_needed = 200, limit_tuples = 4.9406564584124654e-324, count_est = 94685691702216, offset_est = 1} [18:19:19.267] lc = [18:19:19.267] __func__ = "grouping_planner" [18:19:19.267] #6 0x0000561db839aadc in subquery_planner (glob=glob@entry=0x561dbb04e868, parse=parse@entry=0x561dbaefd788, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:19:19.267] root = 0x561dbb04ebc8 [18:19:19.267] newWithCheckOptions = [18:19:19.267] newHaving = 0x0 [18:19:19.267] hasOuterJoins = [18:19:19.267] hasResultRTEs = false [18:19:19.267] final_rel = [18:19:19.267] l = 0x0 [18:19:19.267] #7 0x0000561db839b731 in standard_planner (parse=0x561dbaefd788, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [18:19:19.267] result = [18:19:19.267] glob = 0x561dbb04e868 [18:19:19.267] tuple_fraction = 0 [18:19:19.267] root = [18:19:19.267] final_rel = [18:19:19.267] best_path = [18:19:19.267] top_plan = [18:19:19.267] lp = [18:19:19.267] lr = [18:19:19.267] #8 0x0000561db839c7f5 in planner (parse=parse@entry=0x561dbaefd788, query_string=query_string@entry=0x561dbaefc260 "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 [18:19:19.267] result = [18:19:19.267] #9 0x0000561db860acf7 in pg_plan_query (querytree=querytree@entry=0x561dbaefd788, query_string=query_string@entry=0x561dbaefc260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:19:19.267] plan = [18:19:19.267] #10 0x0000561db80fbf5d in standard_ExplainOneQuery (query=0x561dbaefd788, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561dbaf27318, queryString=0x561dbaefc260 "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 [18:19:19.267] plan = [18:19:19.267] planstart = {ticks = } [18:19:19.267] planduration = {ticks = 94685690320776} [18:19:19.267] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94685639476056, shared_blks_dirtied = 0, shared_blks_written = 70368744214813, local_blks_hit = 94685690321048, local_blks_read = 94685640797292, local_blks_dirtied = 140736980951390, local_blks_written = 94685646633799, temp_blks_read = 1, temp_blks_written = 139957725809168, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94682554040320}, local_blk_read_time = {ticks = 94685690539368}, local_blk_write_time = {ticks = 94685650528186}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94685644093778}} [18:19:19.267] bufusage = {shared_blks_hit = 140736980951389, shared_blks_read = 94685646718458, shared_blks_dirtied = 0, shared_blks_written = 4294967297, local_blks_hit = 0, local_blks_read = 94682554040330, local_blks_dirtied = 159553740095488, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 37149, shared_blk_read_time = {ticks = 139957725809168}, shared_blk_write_time = {ticks = 94685690321864}, local_blk_read_time = {ticks = 94685690320776}, local_blk_write_time = {ticks = 94685650046094}, temp_blk_read_time = {ticks = 139957725809168}, temp_blk_write_time = {ticks = 94685650046113}} [18:19:19.267] mem_counters = {nblocks = 94685690321048, freechunks = 140736980951400, totalspace = 140736980951392, freespace = 94685690320776} [18:19:19.267] planner_ctx = 0x0 [18:19:19.267] saved_ctx = 0x0 [18:19:19.267] #11 0x0000561db80fc1f5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561dbaf27318, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:397 [18:19:19.267] No locals. [18:19:19.267] #12 0x0000561db80fd7ec in ExplainQuery (pstate=pstate@entry=0x561dbaf27208, stmt=stmt@entry=0x561dbaefd5c8, params=params@entry=0x0, dest=dest@entry=0x561dbaf27178) at ../src/include/nodes/nodes.h:172 [18:19:19.267] l__state = {l = , i = } [18:19:19.267] l = 0x561dbb04e830 [18:19:19.267] es = 0x561dbaf27318 [18:19:19.267] tstate = [18:19:19.267] jstate = [18:19:19.267] query = [18:19:19.267] rewritten = 0x561dbb04e818 [18:19:19.267] lc = 0x0 [18:19:19.267] timing_set = false [18:19:19.267] summary_set = false [18:19:19.267] __func__ = "ExplainQuery" [18:19:19.267] #13 0x0000561db8615705 in standard_ProcessUtility (pstmt=0x561dbaefd678, queryString=0x561dbaefc260 "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=0x561dbaf27178, qc=0x7fffe1c1a350) at ../src/backend/tcop/utility.c:863 [18:19:19.267] parsetree = 0x561dbaefd5c8 [18:19:19.267] isTopLevel = true [18:19:19.267] isAtomicContext = false [18:19:19.267] pstate = 0x561dbaf27208 [18:19:19.267] readonly_flags = [18:19:19.267] __func__ = "standard_ProcessUtility" [18:19:19.267] #14 0x0000561db8615e2e in ProcessUtility (pstmt=pstmt@entry=0x561dbaefd678, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x561dbaf27178, qc=0x7fffe1c1a350) at ../src/backend/tcop/utility.c:523 [18:19:19.267] No locals. [18:19:19.267] #15 0x0000561db861158c in PortalRunUtility (portal=portal@entry=0x561dbaf7cf90, pstmt=0x561dbaefd678, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x561dbaf27178, qc=qc@entry=0x7fffe1c1a350) at ../src/backend/tcop/pquery.c:1158 [18:19:19.267] No locals. [18:19:19.267] #16 0x0000561db8611f6f in FillPortalStore (portal=portal@entry=0x561dbaf7cf90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [18:19:19.267] treceiver = 0x561dbaf27178 [18:19:19.267] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:19:19.267] __func__ = "FillPortalStore" [18:19:19.267] #17 0x0000561db86125f1 in PortalRun (portal=portal@entry=0x561dbaf7cf90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x561dbaf336b8, altdest=altdest@entry=0x561dbaf336b8, qc=0x7fffe1c1a530) at ../src/backend/tcop/pquery.c:763 [18:19:19.267] _save_exception_stack = 0x7fffe1c1a5e0 [18:19:19.267] _save_context_stack = 0x0 [18:19:19.267] _local_sigjmp_buf = {{__jmpbuf = {1, -6383611770297334706, 94685690541752, 94685690320448, 94685690843024, 94685690320376, 6383598939482670158, 816183050202301518}, __mask_was_saved = 0, __saved_mask = {__val = {140736980952255, 94685653245022, 94685690851232, 94685653245022, 1, 140736980952255, 94685690320424, 94685690320376, 94685650269403, 94685652833971, 94685690843024, 94685653245022, 1, 1, 94685650528588, 153}}}} [18:19:19.267] _do_rethrow = [18:19:19.267] result = [18:19:19.267] nprocessed = [18:19:19.267] saveTopTransactionResourceOwner = 0x561dbaf3bc58 [18:19:19.267] saveTopTransactionContext = 0x561dbafe7150 [18:19:19.267] saveActivePortal = 0x0 [18:19:19.267] saveResourceOwner = 0x561dbaf3bc58 [18:19:19.267] savePortalContext = 0x0 [18:19:19.267] saveMemoryContext = 0x561dbafe7150 [18:19:19.267] __func__ = "PortalRun" [18:19:19.267] #18 0x0000561db860b586 in exec_simple_query (query_string=query_string@entry=0x561dbaefc260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1273 [18:19:19.267] cmdtaglen = 7 [18:19:19.267] snapshot_set = [18:19:19.267] per_parsetree_context = 0x0 [18:19:19.267] plantree_list = 0x561dbaf33668 [18:19:19.267] parsetree = 0x561dbaefd5f8 [18:19:19.267] commandTag = [18:19:19.267] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:19:19.267] querytree_list = [18:19:19.267] portal = 0x561dbaf7cf90 [18:19:19.267] receiver = 0x561dbaf336b8 [18:19:19.267] format = 0 [18:19:19.267] cmdtagname = [18:19:19.267] parsetree_item__state = {l = , i = } [18:19:19.267] dest = DestRemote [18:19:19.267] oldcontext = 0x561dbafe7150 [18:19:19.267] parsetree_list = 0x561dbaefd628 [18:19:19.267] parsetree_item = 0x561dbaefd640 [18:19:19.267] save_log_statement_stats = false [18:19:19.267] was_logged = false [18:19:19.267] use_implicit_block = false [18:19:19.267] msec_str = "\004\000\000\000\000\000\000\000t\213\215\270\035V\000\000\300\245\301\341\377\177\000\000U\000\000\000\000\000\000" [18:19:19.267] __func__ = "exec_simple_query" [18:19:19.267] #19 0x0000561db860e33e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [18:19:19.267] query_string = 0x561dbaefc260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [18:19:19.267] firstchar = [18:19:19.267] input_message = {data = 0x561dbaefc260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [18:19:19.267] local_sigjmp_buf = {{__jmpbuf = {94685662643384, 816181197929235534, 0, 4, 140736980952916, 1, 6383598939411366990, 816183059531613262}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 139957919514084, 94685690289904, 15616, 15680, 94685650439978, 94685662643392, 94685690315104, 94685662637496, 4, 140736980952916, 94685650444046, 1}}}} [18:19:19.267] send_ready_for_query = false [18:19:19.267] idle_in_transaction_timeout_enabled = false [18:19:19.267] idle_session_timeout_enabled = false [18:19:19.267] __func__ = "PostgresMain" [18:19:19.267] #20 0x0000561db84b1778 in BackendRun (port=port@entry=0x561dbaf290d0) at ../src/backend/postmaster/postmaster.c:4475 [18:19:19.267] No locals. [18:19:19.267] #21 0x0000561db84b7060 in BackendStartup (port=port@entry=0x561dbaf290d0) at ../src/backend/postmaster/postmaster.c:4151 [18:19:19.267] bn = 0x561dbaf25008 [18:19:19.267] pid = 0 [18:19:19.267] __func__ = "BackendStartup" [18:19:19.267] #22 0x0000561db84b73dd in ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:19:19.267] port = 0x561dbaf290d0 [18:19:19.267] i = 0 [18:19:19.267] now = [18:19:19.267] last_lockfile_recheck_time = 1710180916 [18:19:19.267] last_touch_time = 1710180916 [18:19:19.267] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -507402176, events = 32767, fd = 45, user_data = 0x7fffe1c1a800}, {pos = -507402224, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 2128349064, user_data = 0x7f4a7e289fea}, {pos = -507402008, events = 32767, fd = -507402176, user_data = 0x7fffe1c1a850}, {pos = 2141396193, events = 32586, fd = 18, user_data = 0x7f4a7ba87618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 2128348192, events = 32586, fd = -1, user_data = 0x7f4a7ba87618}, {pos = 2128348192, events = 32586, fd = 1024, user_data = 0x7f4a7edc0788}, {pos = 0, events = 0, fd = 8, user_data = 0x7fffe1c1a850}, {pos = -1, events = 0, fd = 2115456186, user_data = 0x7f4a7e0b6418}, {pos = 2128349472, events = 32586, fd = -1158505464, user_data = 0x561dbaf27708}, {pos = -1158538768, events = 22045, fd = -1158505432, user_data = 0x561dbaf29b61}, {pos = 2141414947, events = 32586, fd = 1, user_data = 0x7f4a7e2a30f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = -1158684576, user_data = 0x1}, {pos = 1, events = 0, fd = -1158684624, user_data = 0x7f4a7fa36623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x561dbaf219f0}, {pos = 2114675736, events = 32586, fd = -507401040, user_data = 0x7f4a7fa3d68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7fffe1c1acd0}, {pos = -1186422144, events = 22045, fd = 2, user_data = 0x561db948a280 }, {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 = -1158511720, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1734701663, user_data = 0xa3838313271412d}, {pos = 762540901, events = 825389377, fd = 168441912, user_data = 0x31303137310a6174}, {pos = 825831480, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = 2115193851, user_data = 0x400}, {pos = -1158701168, events = 22045, fd = 2116539520, user_data = 0x1baef9f90}, {pos = 784, events = 0, fd = -1196294292, user_data = 0x561dbaf273e0}, {pos = -698330624, events = 2819844879, fd = 4, user_data = 0x561dbaf28360}, {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 = 0x561dbaf273e0}, {pos = 1, events = 0, fd = -1158515544, user_data = 0x400}, {pos = 0, events = 0, fd = -1198487346, user_data = 0x561db9498470 }, {pos = -1198553670, events = 22045, fd = -1158515744, user_data = 0x561dbaefc160}, {pos = -1158515744, events = 22045, fd = 15, user_data = 0x4a}, {pos = -1198485578, events = 22045, fd = -1158515744, user_data = 0x561db89090f8 }, {pos = -1158701168, events = 22045, fd = 2115193851, user_data = 0x0}, {pos = -1204998561, events = 22045, fd = -1158527136, user_data = 0x1baef9f90}, {pos = -507400888, events = 32767, fd = 0, user_data = 0x561dbaf273e0}, {pos = 2115178922, events = 32586, fd = 1024, user_data = 0x561dbaef9f90}, {pos = 2115172592, events = 32586, fd = 0, user_data = 0x561d00000000}, {pos = 0, events = 0, fd = -1158701168, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x5bb1}, {pos = 2115476229, events = 32586, fd = 8, user_data = 0xa8136b0fd6605200}, {pos = 1, events = 0, fd = -1203047663, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x561db8908fb6 }, {pos = -1158527136, events = 22045, fd = -1198485256, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x561db82d2a32 }, {pos = 0, events = 0, fd = -1204975608, user_data = 0x561dbaefc160}, {pos = -1203020370, events = 22045, fd = 0, user_data = 0x0}} [18:19:19.267] nevents = 1 [18:19:19.267] __func__ = "ServerLoop" [18:19:19.267] #23 0x0000561db84b8e6f in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x561dbaef5e50) at ../src/backend/postmaster/postmaster.c:1468 [18:19:19.267] opt = [18:19:19.267] status = [18:19:19.267] userDoption = [18:19:19.267] listen_addr_saved = false [18:19:19.267] output_config_variable = [18:19:19.267] __func__ = "PostmasterMain" [18:19:19.267] #24 0x0000561db82e382c in main (argc=8, argv=0x561dbaef5e50) at ../src/backend/main/main.c:197 [18:19:19.267] do_check_root = [18:19:19.286] -e [18:19:19.286] [18:19:19.286] [18:19:19.866] dumping /tmp/cores/postgres-11-34900.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:19:20.193] [New LWP 34900] [18:19:21.396] [Thread debugging using libthread_db enabled] [18:19:21.396] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:19:22.840] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [18:19:22.840] Program terminated with signal SIGSEGV, Segmentation fault. [18:19:22.840] #0 0x0000563d88a31a3f in equal (a=0xffffffff8ab33920, b=b@entry=0x563d8ab30618) at ../src/backend/nodes/equalfuncs.c:239 [18:19:22.840] 239 if (nodeTag(a) != nodeTag(b)) [18:19:22.970] [18:19:22.970] Thread 1 (Thread 0x7f4931e81a40 (LWP 34900)): [18:19:22.970] #0 0x0000563d88a31a3f in equal (a=0xffffffff8ab33920, b=b@entry=0x563d8ab30618) at ../src/backend/nodes/equalfuncs.c:239 [18:19:22.970] retval = [18:19:22.970] __func__ = "equal" [18:19:22.970] #1 0x0000563d88373b57 in list_member (list=0x563d8ab33990, datum=datum@entry=0x563d8ab30618) at ../src/backend/nodes/list.c:670 [18:19:22.970] cell__state = {l = , i = } [18:19:22.970] cell = [18:19:22.970] #2 0x0000563d884971be in add_new_column_to_pathtarget (target=target@entry=0x563d8ab338b0, expr=0x563d8ab30618) at ../src/backend/optimizer/util/tlist.c:743 [18:19:22.970] No locals. [18:19:22.970] #3 0x0000563d88497259 in add_new_columns_to_pathtarget (target=target@entry=0x563d8ab338b0, exprs=exprs@entry=0x563d8ab33ac0) at ../src/backend/optimizer/util/tlist.c:760 [18:19:22.970] expr = [18:19:22.970] lc__state = {l = , i = } [18:19:22.970] lc = [18:19:22.970] #4 0x0000563d8840f916 in make_group_input_target (root=root@entry=0x563d8ab2deb0, final_target=final_target@entry=0x563d8ab33750) at ../src/backend/optimizer/plan/planner.c:5472 [18:19:22.970] parse = 0x563d8aa0cd48 [18:19:22.970] input_target = 0x563d8ab338b0 [18:19:22.970] non_group_cols = 0x563d8ab33a70 [18:19:22.970] non_group_vars = 0x563d8ab33ac0 [18:19:22.970] i = 6 [18:19:22.970] lc = 0x0 [18:19:22.970] #5 0x0000563d88422c38 in grouping_planner (root=root@entry=0x563d8ab2deb0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:19:22.970] sort_input_targets = 0x563d8ab30488 [18:19:22.970] sort_input_target_parallel_safe = true [18:19:22.970] grouping_target = 0x563d8ab33750 [18:19:22.970] scanjoin_target = [18:19:22.970] activeWindows = 0x0 [18:19:22.970] qp_extra = {activeWindows = 0x0, gset_data = 0x563d8ab31ae8} [18:19:22.970] sort_input_targets_contain_srfs = 0x563d884590ae [18:19:22.970] have_grouping = [18:19:22.970] wflists = 0x0 [18:19:22.970] gset_data = 0x563d8ab31ae8 [18:19:22.970] sort_input_target = 0x563d8ab33750 [18:19:22.970] grouping_targets = 0x0 [18:19:22.970] grouping_target_parallel_safe = true [18:19:22.970] scanjoin_targets = 0x0 [18:19:22.970] scanjoin_target_parallel_safe = [18:19:22.970] grouping_targets_contain_srfs = 0x563d883812a3 [18:19:22.970] scanjoin_targets_contain_srfs = 0x563d8ab2c898 [18:19:22.970] scanjoin_target_same_exprs = [18:19:22.970] parse = 0x563d8aa0cd48 [18:19:22.970] offset_est = 0 [18:19:22.970] count_est = 0 [18:19:22.970] limit_tuples = -1 [18:19:22.970] have_postponed_srfs = false [18:19:22.970] final_target = 0x563d8ab33750 [18:19:22.970] final_targets = 0x0 [18:19:22.970] final_targets_contain_srfs = 0x563d8845f3a5 [18:19:22.970] final_target_parallel_safe = true [18:19:22.970] current_rel = 0x563d8ab1dc68 [18:19:22.970] final_rel = [18:19:22.970] extra = {limit_needed = 176, limit_tuples = 1.9762625833649862e-323, count_est = 94822319972016, offset_est = 0} [18:19:22.970] lc = [18:19:22.970] __func__ = "grouping_planner" [18:19:22.970] #6 0x0000563d88425adc in subquery_planner (glob=glob@entry=0x563d8aad4d88, parse=parse@entry=0x563d8aa0cd48, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:19:22.970] root = 0x563d8ab2deb0 [18:19:22.970] newWithCheckOptions = [18:19:22.970] newHaving = 0x0 [18:19:22.970] hasOuterJoins = [18:19:22.970] hasResultRTEs = false [18:19:22.970] final_rel = [18:19:22.970] l = 0x0 [18:19:22.970] #7 0x0000563d88426731 in standard_planner (parse=parse@entry=0x563d8aa0cd48, query_string=query_string@entry=0x563d8aa0b290 "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 [18:19:22.970] result = [18:19:22.970] glob = 0x563d8aad4d88 [18:19:22.970] tuple_fraction = 0 [18:19:22.970] root = [18:19:22.970] final_rel = [18:19:22.970] best_path = [18:19:22.970] top_plan = [18:19:22.970] lp = [18:19:22.970] lr = [18:19:22.970] #8 0x00007f4931cae73e in pgss_planner (parse=0x563d8aa0cd48, query_string=0x563d8aa0b290 "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 [18:19:22.970] _save_exception_stack = 0x7ffe133c5610 [18:19:22.970] _save_context_stack = 0x0 [18:19:22.970] _local_sigjmp_buf = {{__jmpbuf = {94822318787912, 2855529518260238968, 0, 2048, 0, 94822318781072, 8369891316121418360, 8451451253175958136}, __mask_was_saved = 0, __saved_mask = {__val = {70368744203407, 1, 94822275013740, 1, 94822280848314, 1, 94822319967368, 0, 0, 0, 94822284744634, 0, 94822278310226, 0, 94822318787912, 0}}}} [18:19:22.970] _do_rethrow = false [18:19:22.970] result = 0x7ffe133c5380 [18:19:22.970] #9 0x0000563d884277eb in planner (parse=parse@entry=0x563d8aa0cd48, query_string=query_string@entry=0x563d8aa0b290 "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 [18:19:22.970] result = [18:19:22.970] #10 0x0000563d88695cf7 in pg_plan_query (querytree=querytree@entry=0x563d8aa0cd48, query_string=query_string@entry=0x563d8aa0b290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:19:22.970] plan = [18:19:22.970] #11 0x0000563d88696064 in pg_plan_queries (querytrees=0x563d8ab2cc88, query_string=query_string@entry=0x563d8aa0b290 "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:995 [18:19:22.970] query = 0x563d8aa0cd48 [18:19:22.970] stmt = [18:19:22.970] query_list__state = {l = , i = } [18:19:22.970] stmt_list = 0x0 [18:19:22.970] query_list = [18:19:22.970] #12 0x0000563d8869643e in exec_simple_query (query_string=query_string@entry=0x563d8aa0b290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [18:19:22.970] cmdtaglen = 6 [18:19:22.970] snapshot_set = true [18:19:22.970] per_parsetree_context = 0x0 [18:19:22.970] plantree_list = [18:19:22.970] parsetree = 0x563d8aa0cbb8 [18:19:22.970] commandTag = CMDTAG_SELECT [18:19:22.970] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94822318781072} [18:19:22.970] querytree_list = [18:19:22.970] portal = [18:19:22.970] receiver = [18:19:22.970] format = 0 [18:19:22.970] cmdtagname = [18:19:22.970] parsetree_item__state = {l = , i = } [18:19:22.970] dest = DestRemote [18:19:22.970] oldcontext = 0x563d8aa37880 [18:19:22.970] parsetree_list = 0x563d8aa0cbe8 [18:19:22.970] parsetree_item = 0x563d8aa0cc00 [18:19:22.970] save_log_statement_stats = false [18:19:22.970] was_logged = true [18:19:22.970] use_implicit_block = false [18:19:22.970] msec_str = "\004\000\000\000\000\000\000\000t;\226\210=V\000\000\360U<\023\376\177\000\000[\000\000\000\000\000\000" [18:19:22.970] __func__ = "exec_simple_query" [18:19:22.970] #13 0x0000563d8869933e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [18:19:22.970] query_string = 0x563d8aa0b290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [18:19:22.970] firstchar = [18:19:22.970] input_message = {data = 0x563d8aa0b290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [18:19:22.970] local_sigjmp_buf = {{__jmpbuf = {94822296859832, 2855536231354940024, 0, 4, 140729221142404, 1, 8369891316272413304, 2855534389076769400}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94822318755648, 16384, 8248, 94822284658133, 0, 0, 0, 94822296859840, 94822318780816, 94822296853944, 4, 140729221142404, 1, 94822284661183, 1}}}} [18:19:22.970] send_ready_for_query = false [18:19:22.970] idle_in_transaction_timeout_enabled = false [18:19:22.970] idle_session_timeout_enabled = false [18:19:22.970] __func__ = "PostgresMain" [18:19:22.970] #14 0x0000563d8853c778 in BackendRun (port=port@entry=0x563d8aa3a1f0) at ../src/backend/postmaster/postmaster.c:4475 [18:19:22.970] No locals. [18:19:22.970] #15 0x0000563d88542060 in BackendStartup (port=port@entry=0x563d8aa3a1f0) at ../src/backend/postmaster/postmaster.c:4151 [18:19:22.970] bn = 0x563d8aa37d68 [18:19:22.970] pid = 0 [18:19:22.970] __func__ = "BackendStartup" [18:19:22.970] #16 0x0000563d885423dd in ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:19:22.970] port = 0x563d8aa3a1f0 [18:19:22.970] i = 0 [18:19:22.970] now = [18:19:22.970] last_lockfile_recheck_time = 1710180944 [18:19:22.970] last_touch_time = 1710180944 [18:19:22.970] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 322721936, events = 32766, fd = 879260448, user_data = 0x7ffe133c5880}, {pos = 46, events = 0, fd = 904212864, user_data = 0x133c5850}, {pos = 0, events = 0, fd = 904212864, user_data = 0x59e7c8ee}, {pos = 891029384, events = 32585, fd = 879271914, user_data = 0x7ffe133c5928}, {pos = 322721920, events = 32766, fd = 322721936, user_data = 0x7f4935e31ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = 837318168, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f49351c0420}, {pos = 322721872, events = 32766, fd = 837318168, user_data = 0x7f49351c0420}, {pos = -1998157664, events = 1, fd = 891029384, user_data = 0x0}, {pos = -1969001632, events = 22077, fd = -1968982680, user_data = 0xffffffff}, {pos = 904095267, events = 32585, fd = 877356056, user_data = 0x7f49351c0920}, {pos = -1968982712, events = 22077, fd = 877402616, user_data = 0x7ffe133c5c70}, {pos = 904124042, events = 32585, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = 879374584, user_data = 0x4}, {pos = -1969177168, events = 22077, fd = 1, user_data = 0x1}, {pos = -1969172240, events = 22077, fd = 904095267, user_data = 0x1}, {pos = 0, events = 0, fd = -1968983928, user_data = 0x7f49344b6418}, {pos = 322723040, events = 32766, fd = 904124042, user_data = 0x0}, {pos = 0, events = 0, fd = 322723072, user_data = 0x563d89515280 }, {pos = 2, events = 0, fd = -1991159168, 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 = -1968961208, user_data = 0x3ff}, {pos = 4096, events = 0, fd = -1969188896, user_data = 0x563d8aa08fe0}, {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 = -1, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 908075040, user_data = 0xa}, {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 = -1969188896, events = 22077, fd = 879219840, user_data = 0x18aa08fe0}, {pos = 784, events = 0, fd = -2001031316, user_data = 0x563d8aa3b0b0}, {pos = -1182991360, events = 1791894931, fd = 4, user_data = 0x563d8aa40910}, {pos = -1968983888, events = 22077, fd = -1968983688, 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 = -1968983688, user_data = 0x400}, {pos = 0, events = 0, fd = -2003224370, user_data = 0x563d89523470 }, {pos = -2003290694, events = 22077, fd = -1968983888, user_data = 0x563d8aa0b190}, {pos = -1968983888, events = 22077, fd = 15, user_data = 0x4a}, {pos = -2003222602, events = 22077, fd = -1968983888, user_data = 0x563d889940f8 }, {pos = -1969188896, events = 22077, fd = 877874478, user_data = 0x0}, {pos = -2009735585, events = 22077, fd = -1969009728, user_data = 0x18aa08fe0}, {pos = 322723192, events = 32766, fd = 0, user_data = 0x563d8aa3b0b0}, {pos = 877859242, events = 32585, fd = 1024, user_data = 0x563d8aa08fe0}, {pos = 877852912, events = 32585, fd = 0, user_data = 0x563d00000000}, {pos = 0, events = 0, fd = -1969188896, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x77b8}, {pos = 878156549, events = 32585, fd = 4, user_data = 0x6ace2593b97cfc00}, {pos = 1, events = 0, fd = -2007784687, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x563d88993fb6 }, {pos = -1969009728, events = 22077, fd = -2003222280, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x563d8835da32 }, {pos = 0, events = 0, fd = -2009712632, user_data = 0x563d8aa0b190}, {pos = -2007757394, events = 22077, fd = 0, user_data = 0x0}} [18:19:22.971] nevents = 1 [18:19:22.971] __func__ = "ServerLoop" [18:19:22.971] #17 0x0000563d88543e6f in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x563d8aa04e40) at ../src/backend/postmaster/postmaster.c:1468 [18:19:22.971] opt = [18:19:22.971] status = [18:19:22.971] userDoption = [18:19:22.971] listen_addr_saved = false [18:19:22.971] output_config_variable = [18:19:22.971] __func__ = "PostmasterMain" [18:19:22.971] #18 0x0000563d8836e82c in main (argc=4, argv=0x563d8aa04e40) at ../src/backend/main/main.c:197 [18:19:22.971] do_check_root = [18:19:22.989] -e [18:19:22.989] [18:19:22.989] [18:19:23.533] dumping /tmp/cores/postgres-3-36327.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:19:23.860] [New LWP 36327] [18:19:23.860] [New LWP 34479] [18:19:25.028] [Thread debugging using libthread_db enabled] [18:19:25.028] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:19:26.496] Core was generated by `postgres: standby2: startup waiting for 000000010000000000000006 '. [18:19:26.496] Program terminated with signal SIGQUIT, Quit. [18:19:26.496] #0 0x00007f2d69c7afc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.502] [Current thread is 1 (LWP 36327)] [18:19:26.601] [18:19:26.601] Thread 2 (Thread 0x7f2d67611a40 (LWP 34479)): [18:19:26.601] #0 0x00007f2d69d3da61 in clone () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.601] No symbol table info available. [18:19:26.601] #1 0x00007f2d69d2be5e in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.601] No symbol table info available. [18:19:26.601] #2 0x00007f2d69d2c497 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.601] No symbol table info available. [18:19:26.601] #3 0x00007f2d69d2bcdb in posix_spawn () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.601] No symbol table info available. [18:19:26.601] #4 0x00007f2d69c87a69 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.601] No symbol table info available. [18:19:26.601] #5 0x000055c527eba9ff in RestoreArchivedFile (path=path@entry=0x7ffc5485d200 "pg_wal/00000", xlogfname=xlogfname@entry=0x7ffc5485d650 "00000001", '0' , "6", recovername=recovername@entry=0x55c52898f5fc "RECOVERYXLOG", expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [18:19:26.601] xlogpath = "pg_wal/RECOVERYXLOG", '\000' , "\066", '\000' , "\b\000\000\000\000\000\000\000ܽ\230(\305U\000\000(хT\374\177\000\000н\230(\305U\000\000*Z\177(\305U\000\000PօT\374\177\000\000\267\365\230(\305U\000\000(хT\374\177\000\000\265\365\230(\305U\000\000\030\031ag-\177\000\000\206d\177(\305U", '\000' , "\b", '\000' , "\060", '\000' , "\002", '\000' ... [18:19:26.601] xlogRestoreCmd = 0x55c529d08698 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/040_standby_failover_slots_sync/data/t_040_standby_failover_slots_sync_publisher_data/archives/00000001", '0' , "6\" \"pg_wal/RECOVERYXLOG\"" [18:19:26.601] lastRestartPointFname = "00000001", '0' , "5\000d\177(\305U", '\000' , "\001\000\000\036\215\000\000\300&\341i-\177\000\000`'\341i-\177\000\000\036\215\000\000\002", '\000' , "\020}\310i-\177\000\000\360ɅT\374\177", '\000' , "Wq\335i-\177\000\000Oq\335i-\177\000\000\230\206\320)\305U", '\000' , "@", '\000' ... [18:19:26.601] rc = [18:19:26.601] stat_buf = {st_dev = 94305276341262, st_ino = 335544320, st_nlink = 139833024949600, st_mode = 0, st_uid = 0, st_gid = 0, __pad0 = 0, st_rdev = 8127867277590188544, st_size = 0, st_blksize = 94305298450072, st_blocks = 140721726540784, st_atim = {tv_sec = 140721726540368, tv_nsec = 140721726540496}, st_mtim = {tv_sec = 0, tv_nsec = 94305298450072}, st_ctim = {tv_sec = 139833025676439, tv_nsec = 0}, __glibc_reserved = {94305276353066, 140721726543456, 94305278016809}} [18:19:26.601] restartSegNo = [18:19:26.601] restartRedoPtr = 83886120 [18:19:26.601] restartTli = 1 [18:19:26.601] __func__ = "RestoreArchivedFile" [18:19:26.601] #6 0x000055c527ec968f in XLogFileRead (segno=140721726543360, segno@entry=6, emode=emode@entry=13, tli=tli@entry=1, source=source@entry=XLOG_FROM_ARCHIVE, notfoundOk=notfoundOk@entry=true) at ../src/backend/access/transam/xlogrecovery.c:4209 [18:19:26.601] xlogfname = "00000001", '0' , "6\000\000\000\t", '\000' , "\336\001\000\000\000\000\000\000\320څT\374\177\000\000#f\\k-\177\000" [18:19:26.601] activitymsg = "waiting for 00000001", '0' , "6\000\177\000\000*Z\177(\305U\000\000\360 \244(\305U\000\000\355 \244(\305U\000\000hمT\374\177\000\000\353 \244(\305U\000" [18:19:26.601] path = "pg_wal/00000\000\000\000\000", '\060' , "\066\000pg_wal/RECOVERYHISTORY\000\000\b\000\000\000\000\000\000\066\000\000\000\000\000\000\000\000\376^\177(\000\000\000\062\000\000\000\000\000\000\000\000\b\000\000\000\000\000\000\000ܽ\230(\305U\000\000\b\000\000\000\000\000\000\000Yc\230(\305U\000\000\210ՅT\374\177\000\000Uc\230(\305U\000\000*Z\177(\305U\000\000ac\230(\305U\000\000Yc\230(\305U\000\000\210ՅT\374\177\000\000Uc\230(\305U\000\000\030\031ag-\177\000\000\310c\177(\305U", '\000' ... [18:19:26.601] fd = [18:19:26.601] __func__ = "XLogFileRead" [18:19:26.601] #7 0x000055c527ec987f in XLogFileReadAnyTLI (segno=6, emode=emode@entry=13, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4337 [18:19:26.601] hent = [18:19:26.601] tli = 1 [18:19:26.601] cell__state = {l = , i = } [18:19:26.601] path = "\320څT\374\177\000\000\200څT\374\177\000\000\001\000\000\000\000\000\000\000\004\000\000\t", '\000' , "Bc4)\305U\000\000\300c4)\305U\000\000T؅T\374\177\000\000\030 \244(\305U\000\000\240\037\000\000\377\377\002\000\300c4)\305U\000\000t؅T\374\177\000\000' \244(\305U\000\000\300c4)\305U\000\000\002\000\000\000\000\000\000\000't\177(\305U\000\000v؅T\374\177\000\000t؅T\374\177", '\000' , "\377\000\030\000\000\000\060\000\000\000P؅T\374\177\000\000\000u\177(\305U\000\000\360ŅT\000\000\000\000\030\000\000\000\060\000\000\000"... [18:19:26.601] cell = [18:19:26.601] fd = [18:19:26.601] tles = 0x55c529d1ae48 [18:19:26.601] __func__ = "XLogFileReadAnyTLI" [18:19:26.601] #8 0x000055c527ecaa7b in WaitForWALToBecomeAvailable (RecPtr=RecPtr@entry=100683560, randAccess=false, fetching_ckpt=false, tliRecPtr=tliRecPtr@entry=100683536, replayTLI=1, replayLSN=100683536, nonblocking=false) at ../src/backend/access/transam/xlogrecovery.c:3770 [18:19:26.601] oldSource = [18:19:26.601] startWalReceiver = false [18:19:26.601] last_fail_time = 763496164018612 [18:19:26.601] now = [18:19:26.601] streaming_reply_sent = true [18:19:26.601] __func__ = "WaitForWALToBecomeAvailable" [18:19:26.601] #9 0x000055c527ecb5b0 in XLogPageRead (xlogreader=0x55c529cb5fc0, targetPagePtr=100679680, reqLen=3880, targetRecPtr=100683536, readBuf=0x55c529d04e68 "\024\321\006") at ../src/backend/access/transam/xlogrecovery.c:3351 [18:19:26.601] private = 0x55c529cb5fa0 [18:19:26.601] emode = 15 [18:19:26.601] targetPageOff = 16384 [18:19:26.601] targetSegNo = 6 [18:19:26.601] r = [18:19:26.601] __func__ = "XLogPageRead" [18:19:26.601] #10 0x000055c527ed3a0b in ReadPageInternal (state=state@entry=0x55c529cb5fc0, pageptr=pageptr@entry=100679680, reqLen=reqLen@entry=3880) at ../src/backend/access/transam/xlogreader.c:1060 [18:19:26.601] readLen = [18:19:26.601] targetPageOff = 16384 [18:19:26.601] targetSegNo = 6 [18:19:26.601] hdr = [18:19:26.601] #11 0x000055c527ed5666 in XLogDecodeNextRecord (state=state@entry=0x55c529cb5fc0, nonblocking=nonblocking@entry=false) at ../src/backend/access/transam/xlogreader.c:597 [18:19:26.601] RecPtr = 100683536 [18:19:26.601] record = [18:19:26.601] targetPagePtr = 100679680 [18:19:26.601] randAccess = false [18:19:26.601] len = [18:19:26.601] total_len = [18:19:26.601] targetRecOff = 3856 [18:19:26.601] pageHeaderSize = [18:19:26.601] assembled = false [18:19:26.601] gotheader = [18:19:26.601] readOff = [18:19:26.601] decoded = 0x0 [18:19:26.601] errormsg = 0x55c528a305a7 "LOG" [18:19:26.601] #12 0x000055c527ed6208 in XLogReadAhead (state=0x55c529cb5fc0, nonblocking=nonblocking@entry=false) at ../src/backend/access/transam/xlogreader.c:973 [18:19:26.601] result = [18:19:26.601] #13 0x000055c527ec0b4a in XLogPrefetcherNextBlock (pgsr_private=94305298116080, lsn=0x55c529d1a7e8) at ../src/backend/access/transam/xlogprefetcher.c:492 [18:19:26.601] nonblocking = [18:19:26.601] record = [18:19:26.601] prefetcher = 0x55c529cb6df0 [18:19:26.601] reader = 0x55c529cb5fc0 [18:19:26.601] replaying_lsn = 100683488 [18:19:26.601] __func__ = "XLogPrefetcherNextBlock" [18:19:26.601] #14 0x000055c527ec4f13 in lrq_prefetch (lrq=) at ../src/backend/access/transam/xlogprefetcher.c:252 [18:19:26.601] No locals. [18:19:26.601] #15 lrq_complete_lsn (lsn=0, lrq=0x55c529d1a718) at ../src/backend/access/transam/xlogprefetcher.c:290 [18:19:26.601] No locals. [18:19:26.601] #16 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x55c529cb6df0, errmsg=errmsg@entry=0x7ffc54861de8) at ../src/backend/access/transam/xlogprefetcher.c:1037 [18:19:26.601] record = [18:19:26.601] replayed_up_to = 0 [18:19:26.601] #17 0x000055c527ecbddd in ReadRecord (xlogprefetcher=0x55c529cb6df0, emode=emode@entry=15, fetching_ckpt=fetching_ckpt@entry=false, replayTLI=1) at ../src/backend/access/transam/xlogrecovery.c:3151 [18:19:26.601] errormsg = 0x55c529cb67d0 "" [18:19:26.601] record = [18:19:26.601] xlogreader = 0x55c529cb5fc0 [18:19:26.601] private = [18:19:26.601] __func__ = "ReadRecord" [18:19:26.601] #18 0x000055c527ecef74 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1832 [18:19:26.601] xtime = [18:19:26.618] ru0 = {tv = {tv_sec = 1710180959, tv_usec = 426204}, ru = {ru_utime = {tv_sec = 0, tv_usec = 1526}, ru_stime = {tv_sec = 0, tv_usec = 0}, {ru_maxrss = 16008, __ru_maxrss_word = 16008}, {ru_ixrss = 0, __ru_ixrss_word = 0}, {ru_idrss = 0, __ru_idrss_word = 0}, {ru_isrss = 0, __ru_isrss_word = 0}, {ru_minflt = 399, __ru_minflt_word = 399}, {ru_majflt = 5, __ru_majflt_word = 5}, {ru_nswap = 0, __ru_nswap_word = 0}, {ru_inblock = 0, __ru_inblock_word = 0}, {ru_oublock = 0, __ru_oublock_word = 0}, {ru_msgsnd = 0, __ru_msgsnd_word = 0}, {ru_msgrcv = 0, __ru_msgrcv_word = 0}, {ru_nsignals = 0, __ru_nsignals_word = 0}, {ru_nvcsw = 4, __ru_nvcsw_word = 4}, {ru_nivcsw = 3, __ru_nivcsw_word = 3}}} [18:19:26.618] record = 0x7f2d66ecbf70 [18:19:26.618] reachedRecoveryTarget = false [18:19:26.618] replayTLI = 1 [18:19:26.618] __func__ = "PerformWalRecovery" [18:19:26.618] #19 0x000055c527eb8c21 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5723 [18:19:26.618] Insert = [18:19:26.618] checkPoint = {redo = 83886120, ThisTimeLineID = 1, PrevTimeLineID = 1, fullPageWrites = true, nextXid = {value = 749}, nextOid = 24576, nextMulti = 1, nextMultiOffset = 0, oldestXid = 730, oldestXidDB = 1, oldestMulti = 1, oldestMultiDB = 1, time = 1710180958, oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 749} [18:19:26.618] wasShutdown = false [18:19:26.618] didCrash = [18:19:26.618] haveTblspcMap = false [18:19:26.618] haveBackupLabel = true [18:19:26.618] EndOfLog = [18:19:26.618] EndOfLogTLI = [18:19:26.618] newTLI = [18:19:26.618] performedWalRecovery = [18:19:26.618] endOfRecoveryInfo = [18:19:26.618] abortedRecPtr = [18:19:26.618] missingContrecPtr = [18:19:26.618] oldestActiveXID = [18:19:26.618] promoted = false [18:19:26.618] __func__ = "StartupXLOG" [18:19:26.618] #20 0x000055c528369526 in StartupProcessMain () at ../src/backend/postmaster/startup.c:252 [18:19:26.618] No locals. [18:19:26.618] #21 0x000055c5283599db in AuxiliaryProcessMain (auxtype=auxtype@entry=B_STARTUP) at ../src/backend/postmaster/auxprocess.c:91 [18:19:26.618] __func__ = "AuxiliaryProcessMain" [18:19:26.618] #22 0x000055c5283647ba in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:5351 [18:19:26.618] pid = [18:19:26.618] __func__ = "StartChildProcess" [18:19:26.618] #23 0x000055c528368c66 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55c529cb4e80) at ../src/backend/postmaster/postmaster.c:1460 [18:19:26.618] opt = [18:19:26.618] status = [18:19:26.618] userDoption = [18:19:26.618] listen_addr_saved = false [18:19:26.618] output_config_variable = [18:19:26.618] __func__ = "PostmasterMain" [18:19:26.618] #24 0x000055c52819382c in main (argc=4, argv=0x55c529cb4e80) at ../src/backend/main/main.c:197 [18:19:26.618] do_check_root = [18:19:26.618] [18:19:26.618] Thread 1 (LWP 36327): [18:19:26.618] #0 0x00007f2d69c7afc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.618] No symbol table info available. [18:19:26.618] #1 0x00007f2d69d2c13a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.618] No symbol table info available. [18:19:26.618] #2 0x00007f2d69d3da6f in clone () from /lib/x86_64-linux-gnu/libc.so.6 [18:19:26.618] No symbol table info available. [18:19:26.637] -e [18:19:26.637] [18:19:26.637] [18:19:27.200] dumping /tmp/cores/postgres-11-27052.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:19:27.513] [New LWP 27052] [18:19:28.709] [Thread debugging using libthread_db enabled] [18:19:28.709] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:19:30.184] Core was generated by `postgres: postgres regression [local] SELECT '. [18:19:30.184] Program terminated with signal SIGSEGV, Segmentation fault. [18:19:30.184] #0 0x0000561db89a6a3f in equal (a=0xffffffffbb031b18, b=b@entry=0x561dbb02e918) at ../src/backend/nodes/equalfuncs.c:239 [18:19:30.184] 239 if (nodeTag(a) != nodeTag(b)) [18:19:30.294] [18:19:30.294] Thread 1 (Thread 0x7f4a7ba81a40 (LWP 27052)): [18:19:30.294] #0 0x0000561db89a6a3f in equal (a=0xffffffffbb031b18, b=b@entry=0x561dbb02e918) at ../src/backend/nodes/equalfuncs.c:239 [18:19:30.294] retval = [18:19:30.294] __func__ = "equal" [18:19:30.294] #1 0x0000561db82e8b57 in list_member (list=0x561dbb031b88, datum=datum@entry=0x561dbb02e918) at ../src/backend/nodes/list.c:670 [18:19:30.294] cell__state = {l = , i = } [18:19:30.294] cell = [18:19:30.294] #2 0x0000561db840c1be in add_new_column_to_pathtarget (target=target@entry=0x561dbb031aa8, expr=0x561dbb02e918) at ../src/backend/optimizer/util/tlist.c:743 [18:19:30.294] No locals. [18:19:30.294] #3 0x0000561db840c259 in add_new_columns_to_pathtarget (target=target@entry=0x561dbb031aa8, exprs=exprs@entry=0x561dbb031cb8) at ../src/backend/optimizer/util/tlist.c:760 [18:19:30.294] expr = [18:19:30.294] lc__state = {l = , i = } [18:19:30.294] lc = [18:19:30.294] #4 0x0000561db8384916 in make_group_input_target (root=root@entry=0x561dbb026b28, final_target=final_target@entry=0x561dbb031948) at ../src/backend/optimizer/plan/planner.c:5472 [18:19:30.294] parse = 0x561dbaefdd18 [18:19:30.294] input_target = 0x561dbb031aa8 [18:19:30.294] non_group_cols = 0x561dbb031c68 [18:19:30.294] non_group_vars = 0x561dbb031cb8 [18:19:30.294] i = 6 [18:19:30.294] lc = 0x0 [18:19:30.294] #5 0x0000561db8397c38 in grouping_planner (root=root@entry=0x561dbb026b28, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:19:30.294] sort_input_targets = 0x561dbb02e788 [18:19:30.294] sort_input_target_parallel_safe = true [18:19:30.294] grouping_target = 0x561dbb031948 [18:19:30.294] scanjoin_target = [18:19:30.294] activeWindows = 0x0 [18:19:30.294] qp_extra = {activeWindows = 0x0, gset_data = 0x561dbb02fda8} [18:19:30.294] sort_input_targets_contain_srfs = 0x561db83ce0ae [18:19:30.294] have_grouping = [18:19:30.294] wflists = 0x0 [18:19:30.294] gset_data = 0x561dbb02fda8 [18:19:30.294] sort_input_target = 0x561dbb031948 [18:19:30.294] grouping_targets = 0x0 [18:19:30.294] grouping_target_parallel_safe = true [18:19:30.294] scanjoin_targets = 0x0 [18:19:30.294] scanjoin_target_parallel_safe = [18:19:30.294] grouping_targets_contain_srfs = 0x561db82f62a3 [18:19:30.294] scanjoin_targets_contain_srfs = 0x561dbb02aff8 [18:19:30.294] scanjoin_target_same_exprs = [18:19:30.294] parse = 0x561dbaefdd18 [18:19:30.294] offset_est = 0 [18:19:30.294] count_est = 0 [18:19:30.294] limit_tuples = -1 [18:19:30.294] have_postponed_srfs = false [18:19:30.294] final_target = 0x561dbb031948 [18:19:30.294] final_targets = 0x0 [18:19:30.294] final_targets_contain_srfs = 0x561db83d43a5 [18:19:30.294] final_target_parallel_safe = true [18:19:30.294] current_rel = 0x561dbb026f38 [18:19:30.294] final_rel = [18:19:30.294] extra = {limit_needed = 40, limit_tuples = 1.9762625833649862e-323, count_est = 94685691538216, offset_est = 0} [18:19:30.294] lc = [18:19:30.294] __func__ = "grouping_planner" [18:19:30.294] #6 0x0000561db839aadc in subquery_planner (glob=glob@entry=0x561dbaefdf88, parse=parse@entry=0x561dbaefdd18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:19:30.294] root = 0x561dbb026b28 [18:19:30.294] newWithCheckOptions = [18:19:30.294] newHaving = 0x0 [18:19:30.294] hasOuterJoins = [18:19:30.294] hasResultRTEs = false [18:19:30.294] final_rel = [18:19:30.294] l = 0x0 [18:19:30.294] #7 0x0000561db839b731 in standard_planner (parse=0x561dbaefdd18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [18:19:30.294] result = [18:19:30.294] glob = 0x561dbaefdf88 [18:19:30.294] tuple_fraction = 0 [18:19:30.294] root = [18:19:30.294] final_rel = [18:19:30.294] best_path = [18:19:30.294] top_plan = [18:19:30.294] lp = [18:19:30.294] lr = [18:19:30.294] #8 0x0000561db839c7f5 in planner (parse=parse@entry=0x561dbaefdd18, query_string=query_string@entry=0x561dbaefc260 "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 [18:19:30.294] result = [18:19:30.294] #9 0x0000561db860acf7 in pg_plan_query (querytree=querytree@entry=0x561dbaefdd18, query_string=query_string@entry=0x561dbaefc260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:19:30.294] plan = [18:19:30.294] #10 0x0000561db860b064 in pg_plan_queries (querytrees=0x561dbb02b398, query_string=query_string@entry=0x561dbaefc260 "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:995 [18:19:30.294] query = 0x561dbaefdd18 [18:19:30.294] stmt = [18:19:30.294] query_list__state = {l = , i = } [18:19:30.294] stmt_list = 0x0 [18:19:30.294] query_list = [18:19:30.294] #11 0x0000561db860b43e in exec_simple_query (query_string=query_string@entry=0x561dbaefc260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [18:19:30.294] cmdtaglen = 6 [18:19:30.294] snapshot_set = true [18:19:30.294] per_parsetree_context = 0x0 [18:19:30.294] plantree_list = [18:19:30.294] parsetree = 0x561dbaefdb88 [18:19:30.294] commandTag = CMDTAG_SELECT [18:19:30.294] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94685690315360} [18:19:30.294] querytree_list = [18:19:30.294] portal = [18:19:30.294] receiver = [18:19:30.294] format = 0 [18:19:30.294] cmdtagname = [18:19:30.294] parsetree_item__state = {l = , i = } [18:19:30.294] dest = DestRemote [18:19:30.294] oldcontext = 0x561dbaf24b70 [18:19:30.294] parsetree_list = 0x561dbaefdbb8 [18:19:30.294] parsetree_item = 0x561dbaefdbd0 [18:19:30.294] save_log_statement_stats = false [18:19:30.294] was_logged = false [18:19:30.294] use_implicit_block = false [18:19:30.294] msec_str = "\004\000\000\000\000\000\000\000t\213\215\270\035V\000\000\300\245\301\341\377\177\000\000[\000\000\000\000\000\000" [18:19:30.294] __func__ = "exec_simple_query" [18:19:30.294] #12 0x0000561db860e33e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [18:19:30.294] query_string = 0x561dbaefc260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [18:19:30.294] firstchar = [18:19:30.294] input_message = {data = 0x561dbaefc260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [18:19:30.294] local_sigjmp_buf = {{__jmpbuf = {94685662643384, 816181197929235534, 0, 4, 140736980952916, 1, 6383598939411366990, 816183059531613262}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 139957919514084, 94685690289904, 15616, 15680, 94685650439978, 94685662643392, 94685690315104, 94685662637496, 4, 140736980952916, 94685650444046, 1}}}} [18:19:30.294] send_ready_for_query = false [18:19:30.294] idle_in_transaction_timeout_enabled = false [18:19:30.294] idle_session_timeout_enabled = false [18:19:30.294] __func__ = "PostgresMain" [18:19:30.294] #13 0x0000561db84b1778 in BackendRun (port=port@entry=0x561dbaf28cc0) at ../src/backend/postmaster/postmaster.c:4475 [18:19:30.294] No locals. [18:19:30.294] #14 0x0000561db84b7060 in BackendStartup (port=port@entry=0x561dbaf28cc0) at ../src/backend/postmaster/postmaster.c:4151 [18:19:30.294] bn = 0x561dbaf24d38 [18:19:30.294] pid = 0 [18:19:30.294] __func__ = "BackendStartup" [18:19:30.294] #15 0x0000561db84b73dd in ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:19:30.294] port = 0x561dbaf28cc0 [18:19:30.294] i = 0 [18:19:30.294] now = [18:19:30.294] last_lockfile_recheck_time = 1710180916 [18:19:30.294] last_touch_time = 1710180916 [18:19:30.294] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -507402176, events = 32767, fd = 45, user_data = 0x7fffe1c1a800}, {pos = -507402224, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 2128349064, user_data = 0x7f4a7e289fea}, {pos = -507402008, events = 32767, fd = -507402176, user_data = 0x7fffe1c1a850}, {pos = 2141396193, events = 32586, fd = 18, user_data = 0x7f4a7ba87618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 2128348192, events = 32586, fd = -1, user_data = 0x7f4a7ba87618}, {pos = 2128348192, events = 32586, fd = 1024, user_data = 0x7f4a7edc0788}, {pos = 0, events = 0, fd = 8, user_data = 0x7fffe1c1a850}, {pos = -1, events = 0, fd = 2115456186, user_data = 0x7f4a7e0b6418}, {pos = 2128349472, events = 32586, fd = -1158505464, user_data = 0x561dbaf27708}, {pos = -1158538768, events = 22045, fd = -1158505432, user_data = 0x561dbaf29b61}, {pos = 2141414947, events = 32586, fd = 1, user_data = 0x7f4a7e2a30f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = -1158684576, user_data = 0x1}, {pos = 1, events = 0, fd = -1158684624, user_data = 0x7f4a7fa36623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x561dbaf219f0}, {pos = 2114675736, events = 32586, fd = -507401040, user_data = 0x7f4a7fa3d68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7fffe1c1acd0}, {pos = -1186422144, events = 22045, fd = 2, user_data = 0x561db948a280 }, {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 = -1158511720, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1734701663, user_data = 0xa3838313271412d}, {pos = 762540901, events = 825389377, fd = 168441912, user_data = 0x31303137310a6174}, {pos = 825831480, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = 2115193851, user_data = 0x400}, {pos = -1158701168, events = 22045, fd = 2116539520, user_data = 0x1baef9f90}, {pos = 784, events = 0, fd = -1196294292, user_data = 0x561dbaf273e0}, {pos = -698330624, events = 2819844879, fd = 4, user_data = 0x561dbaf28360}, {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 = 0x561dbaf273e0}, {pos = 1, events = 0, fd = -1158515544, user_data = 0x400}, {pos = 0, events = 0, fd = -1198487346, user_data = 0x561db9498470 }, {pos = -1198553670, events = 22045, fd = -1158515744, user_data = 0x561dbaefc160}, {pos = -1158515744, events = 22045, fd = 15, user_data = 0x4a}, {pos = -1198485578, events = 22045, fd = -1158515744, user_data = 0x561db89090f8 }, {pos = -1158701168, events = 22045, fd = 2115193851, user_data = 0x0}, {pos = -1204998561, events = 22045, fd = -1158527136, user_data = 0x1baef9f90}, {pos = -507400888, events = 32767, fd = 0, user_data = 0x561dbaf273e0}, {pos = 2115178922, events = 32586, fd = 1024, user_data = 0x561dbaef9f90}, {pos = 2115172592, events = 32586, fd = 0, user_data = 0x561d00000000}, {pos = 0, events = 0, fd = -1158701168, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x5bb1}, {pos = 2115476229, events = 32586, fd = 8, user_data = 0xa8136b0fd6605200}, {pos = 1, events = 0, fd = -1203047663, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x561db8908fb6 }, {pos = -1158527136, events = 22045, fd = -1198485256, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x561db82d2a32 }, {pos = 0, events = 0, fd = -1204975608, user_data = 0x561dbaefc160}, {pos = -1203020370, events = 22045, fd = 0, user_data = 0x0}} [18:19:30.294] nevents = 1 [18:19:30.294] __func__ = "ServerLoop" [18:19:30.294] #16 0x0000561db84b8e6f in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x561dbaef5e50) at ../src/backend/postmaster/postmaster.c:1468 [18:19:30.294] opt = [18:19:30.294] status = [18:19:30.294] userDoption = [18:19:30.294] listen_addr_saved = false [18:19:30.294] output_config_variable = [18:19:30.294] __func__ = "PostmasterMain" [18:19:30.294] #17 0x0000561db82e382c in main (argc=8, argv=0x561dbaef5e50) at ../src/backend/main/main.c:197 [18:19:30.294] do_check_root = [18:19:30.313] -e [18:19:30.313] [18:19:30.313] [18:19:30.865] dumping /tmp/cores/postgres-11-36916.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:19:31.191] [New LWP 36916] [18:19:32.363] [Thread debugging using libthread_db enabled] [18:19:32.363] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:19:33.829] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT '. [18:19:33.829] Program terminated with signal SIGSEGV, Segmentation fault. [18:19:33.829] #0 0x0000562fb27fb262 in get_expr_width (root=root@entry=0x562fb5983448, expr=expr@entry=0xffffffffb58d7078) at ../src/backend/optimizer/path/costsize.c:6328 [18:19:33.829] 6328 if (IsA(expr, Var)) [18:19:33.972] [18:19:33.972] Thread 1 (Thread 0x7fe25dc13a40 (LWP 36916)): [18:19:33.972] #0 0x0000562fb27fb262 in get_expr_width (root=root@entry=0x562fb5983448, expr=expr@entry=0xffffffffb58d7078) at ../src/backend/optimizer/path/costsize.c:6328 [18:19:33.972] width = [18:19:33.972] #1 0x0000562fb280bf01 in set_pathtarget_cost_width (root=root@entry=0x562fb5983448, target=target@entry=0x562fb58d7008) at ../src/backend/optimizer/path/costsize.c:6299 [18:19:33.972] node = 0xffffffffb58d7078 [18:19:33.972] lc__state = {l = , i = } [18:19:33.972] tuple_width = 0 [18:19:33.972] lc = [18:19:33.972] #2 0x0000562fb2866931 in make_group_input_target (root=root@entry=0x562fb5983448, final_target=final_target@entry=0x562fb58d6f48) at ../src/backend/optimizer/plan/planner.c:5479 [18:19:33.972] parse = 0x562fb598f638 [18:19:33.972] input_target = 0x562fb58d7008 [18:19:33.972] non_group_cols = 0x0 [18:19:33.972] non_group_vars = 0x0 [18:19:33.972] i = 3 [18:19:33.972] lc = 0x0 [18:19:33.972] #3 0x0000562fb2879c38 in grouping_planner (root=root@entry=0x562fb5983448, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [18:19:33.972] sort_input_targets = 0x562fb5984bd0 [18:19:33.972] sort_input_target_parallel_safe = true [18:19:33.972] grouping_target = 0x562fb58d6f48 [18:19:33.972] scanjoin_target = [18:19:33.972] activeWindows = 0x0 [18:19:33.972] qp_extra = {activeWindows = 0x0, gset_data = 0x562fb5985170} [18:19:33.972] sort_input_targets_contain_srfs = 0x562fb28b00ae [18:19:33.972] have_grouping = [18:19:33.972] wflists = 0x0 [18:19:33.972] gset_data = 0x562fb5985170 [18:19:33.972] sort_input_target = 0x562fb58d6f48 [18:19:33.972] grouping_targets = 0x0 [18:19:33.972] grouping_target_parallel_safe = true [18:19:33.972] scanjoin_targets = 0x0 [18:19:33.972] scanjoin_target_parallel_safe = [18:19:33.972] grouping_targets_contain_srfs = 0x562fb27d82a3 [18:19:33.972] scanjoin_targets_contain_srfs = 0x562fb59914e0 [18:19:33.972] scanjoin_target_same_exprs = [18:19:33.972] parse = 0x562fb598f638 [18:19:33.972] offset_est = 0 [18:19:33.972] count_est = 0 [18:19:33.972] limit_tuples = -1 [18:19:33.972] have_postponed_srfs = false [18:19:33.972] final_target = 0x562fb58d6f48 [18:19:33.972] final_targets = 0x0 [18:19:33.972] final_targets_contain_srfs = 0x562fb28b63a5 [18:19:33.972] final_target_parallel_safe = true [18:19:33.972] current_rel = 0x562fb58d5558 [18:19:33.972] final_rel = [18:19:33.972] extra = {limit_needed = 72, limit_tuples = 1.9762625833649862e-323, count_est = 94762910102600, offset_est = 0} [18:19:33.972] lc = [18:19:33.972] __func__ = "grouping_planner" [18:19:33.972] #4 0x0000562fb287cadc in subquery_planner (glob=glob@entry=0x562fb5883fd8, parse=parse@entry=0x562fb598f638, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [18:19:33.972] root = 0x562fb5983448 [18:19:33.972] newWithCheckOptions = [18:19:33.972] newHaving = 0x0 [18:19:33.972] hasOuterJoins = [18:19:33.972] hasResultRTEs = false [18:19:33.972] final_rel = [18:19:33.972] l = 0x0 [18:19:33.972] #5 0x0000562fb287d731 in standard_planner (parse=parse@entry=0x562fb598f638, query_string=query_string@entry=0x562fb58822c0 "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 [18:19:33.972] result = [18:19:33.972] glob = 0x562fb5883fd8 [18:19:33.972] tuple_fraction = 0 [18:19:33.972] root = [18:19:33.972] final_rel = [18:19:33.972] best_path = [18:19:33.972] top_plan = [18:19:33.972] lp = [18:19:33.972] lr = [18:19:33.972] #6 0x00007fe25da4059c in pgss_planner (parse=0x562fb598f638, query_string=0x562fb58822c0 "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 [18:19:33.972] _save_exception_stack = 0x7ffc5bfa8ea0 [18:19:33.972] _save_context_stack = 0x0 [18:19:33.972] _local_sigjmp_buf = {{__jmpbuf = {94762910152248, 6102446745123047089, 0, 2048, 0, 94762909049536, 511125704722368177, 516768969473541809}, __mask_was_saved = 0, __saved_mask = {__val = {140721851632703, 384, 94762909027920, 140721851632800, 1, 140721851632703, 140721851774805, 137, 6, 140610208236504, 94762863368984, 1710180966, 754766, 472, 94762864314661, 140610208236504}}}} [18:19:33.972] _do_rethrow = false [18:19:33.972] duration = {ticks = } [18:19:33.972] bufusage = {shared_blks_hit = 94762910102235, shared_blks_read = 94762910102233, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 94557999988736, local_blks_read = 8, local_blks_dirtied = 266, local_blks_written = 94762864645376, temp_blks_read = 0, temp_blks_written = 206158430232, shared_blk_read_time = {ticks = 140721851632656}, shared_blk_write_time = {ticks = 140721851632464}, local_blk_read_time = {ticks = 60}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 140610206058272}, temp_blk_write_time = {ticks = 2795348724}} [18:19:33.972] walusage_start = {wal_records = 1344, wal_fpi = 2, wal_bytes = 170221} [18:19:33.972] start = {ticks = } [18:19:33.972] bufusage_start = {shared_blks_hit = 6881, shared_blks_read = 4, shared_blks_dirtied = 18, shared_blks_written = 18, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [18:19:33.972] walusage = {wal_records = 0, wal_fpi = 94762864396218, wal_bytes = 94762859232400} [18:19:33.972] result = 0x7ffc5bfa8c10 [18:19:33.972] #7 0x0000562fb287e7eb in planner (parse=parse@entry=0x562fb598f638, query_string=query_string@entry=0x562fb58822c0 "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 [18:19:33.972] result = [18:19:33.972] #8 0x0000562fb2aeccf7 in pg_plan_query (querytree=querytree@entry=0x562fb598f638, query_string=query_string@entry=0x562fb58822c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [18:19:33.972] plan = [18:19:33.972] #9 0x0000562fb2aed064 in pg_plan_queries (querytrees=0x562fb59833f8, query_string=query_string@entry=0x562fb58822c0 "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:995 [18:19:33.972] query = 0x562fb598f638 [18:19:33.972] stmt = [18:19:33.972] query_list__state = {l = , i = } [18:19:33.972] stmt_list = 0x0 [18:19:33.972] query_list = [18:19:33.972] #10 0x0000562fb2aed43e in exec_simple_query (query_string=query_string@entry=0x562fb58822c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;") at ../src/backend/tcop/postgres.c:1192 [18:19:33.972] cmdtaglen = 6 [18:19:33.972] snapshot_set = true [18:19:33.972] per_parsetree_context = 0x0 [18:19:33.972] plantree_list = [18:19:33.972] parsetree = 0x562fb5883f58 [18:19:33.972] commandTag = CMDTAG_SELECT [18:19:33.972] qc = {commandTag = CMDTAG_DROP_ROLE, nprocessed = 94762909049536} [18:19:33.972] querytree_list = [18:19:33.972] portal = [18:19:33.972] receiver = [18:19:33.972] format = 0 [18:19:33.972] cmdtagname = [18:19:33.972] parsetree_item__state = {l = , i = } [18:19:33.972] dest = DestRemote [18:19:33.972] oldcontext = 0x562fb58adbe0 [18:19:33.972] parsetree_list = 0x562fb5883f88 [18:19:33.972] parsetree_item = 0x562fb5883fa0 [18:19:33.972] save_log_statement_stats = false [18:19:33.972] was_logged = false [18:19:33.972] use_implicit_block = false [18:19:33.972] msec_str = "\004\000\000\000\000\000\000\000t\253۲/V\000\000\200\216\372[\374\177\000\000\205\000\000\000\000\000\000" [18:19:33.972] __func__ = "exec_simple_query" [18:19:33.972] #11 0x0000562fb2af033e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4675 [18:19:33.972] query_string = 0x562fb58822c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;" [18:19:33.972] firstchar = [18:19:33.972] input_message = {data = 0x562fb58822c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", len = 133, maxlen = 1024, cursor = 133} [18:19:33.972] local_sigjmp_buf = {{__jmpbuf = {94762876511416, 6102433314827421361, 0, 4, 140721851633684, 1, 511125704940471985, 6102431054305576625}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140610252873188, 94762909024080, 15616, 15680, 94762864308010, 94762876511424, 94762909049280, 94762876505528, 4, 140721851633684, 94762864312078, 1}}}} [18:19:33.972] send_ready_for_query = false [18:19:33.972] idle_in_transaction_timeout_enabled = false [18:19:33.972] idle_session_timeout_enabled = false [18:19:33.972] __func__ = "PostgresMain" [18:19:33.972] #12 0x0000562fb2993778 in BackendRun (port=port@entry=0x562fb58abd40) at ../src/backend/postmaster/postmaster.c:4475 [18:19:33.972] No locals. [18:19:33.972] #13 0x0000562fb2999060 in BackendStartup (port=port@entry=0x562fb58abd40) at ../src/backend/postmaster/postmaster.c:4151 [18:19:33.972] bn = 0x562fb58ade18 [18:19:33.972] pid = 0 [18:19:33.972] __func__ = "BackendStartup" [18:19:33.972] #14 0x0000562fb29993dd in ServerLoop () at ../src/backend/postmaster/postmaster.c:1769 [18:19:33.972] port = 0x562fb58abd40 [18:19:33.972] i = 0 [18:19:33.972] now = [18:19:33.972] last_lockfile_recheck_time = 1710180966 [18:19:33.972] last_touch_time = 1710180966 [18:19:33.972] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1543147776, events = 32764, fd = 46, user_data = 0x7ffc5bfa90c0}, {pos = 1543147728, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 1626679176, user_data = 0x7fe26041bfea}, {pos = 1543147944, events = 32764, fd = 1543147776, user_data = 0x7ffc5bfa9110}, {pos = 1639726305, events = 32738, fd = 18, user_data = 0x7fe25dc19618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1626678304, events = 32738, fd = -1, user_data = 0x7fe25dc19618}, {pos = 1626678304, events = 32738, fd = 1024, user_data = 0x7fe260f52788}, {pos = 0, events = 0, fd = 8, user_data = 0x7ffc5bfa9110}, {pos = -1, events = 0, fd = 1613786298, user_data = 0x7fe260248418}, {pos = 1626679584, events = 32738, fd = -1249180536, user_data = 0x562fb58accb8}, {pos = -1249194592, events = 22063, fd = -1249180504, user_data = 0x562fb58b03e1}, {pos = 1639745059, events = 32738, fd = 1, user_data = 0x7fe2604350f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = -1249366528, user_data = 0x1}, {pos = 1, events = 0, fd = -1249366576, user_data = 0x7fe261bc8623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x562fb58acda0}, {pos = 1613005848, events = 32738, fd = 1543148912, user_data = 0x7fe261bcf68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffc5bfa9590}, {pos = -1281965440, events = 22063, fd = 2, user_data = 0x562fb396c280 }, {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 = -1249199688, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -256, events = 4294967295, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1635021663, user_data = 0x726765722f73746e}, {pos = 1768107379, events = 1769300525, fd = 1647273068, 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 = 1613523963, user_data = 0x400}, {pos = -1249378320, events = 22063, fd = 1614869632, user_data = 0x1b587fff0}, {pos = 784, events = 0, fd = -1291837588, user_data = 0x562fb58ac990}, {pos = -621830144, events = 427608765, fd = 4, user_data = 0x562fb58ab980}, {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 = 0x562fb58ac990}, {pos = 1, events = 0, fd = -1249195432, user_data = 0x400}, {pos = 0, events = 0, fd = -1294030642, user_data = 0x562fb397a470 }, {pos = -1294096966, events = 22063, fd = -1249195632, user_data = 0x562fb58821c0}, {pos = -1249195632, events = 22063, fd = 15, user_data = 0x4a}, {pos = -1294028874, events = 22063, fd = -1249195632, user_data = 0x562fb2deb0f8 }, {pos = -1249378320, events = 22063, fd = 1613523963, user_data = 0x0}, {pos = -1300541857, events = 22063, fd = -1249204240, user_data = 0x1b587fff0}, {pos = 1543149064, events = 32764, fd = 0, user_data = 0x562fb58ac990}, {pos = 1613509034, events = 32738, fd = 1024, user_data = 0x562fb587fff0}, {pos = 1613502704, events = 32738, fd = 0, user_data = 0x562f00000000}, {pos = 0, events = 0, fd = -1249378320, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x900e}, {pos = 1613806341, events = 32738, fd = 8, user_data = 0x197ccabddaefa000}, {pos = 1, events = 0, fd = -1298590959, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x562fb2deafb6 }, {pos = -1249204240, events = 22063, fd = -1294028552, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x562fb27b4a32 }, {pos = 0, events = 0, fd = -1300518904, user_data = 0x562fb58821c0}, {pos = -1298563666, events = 22063, fd = 0, user_data = 0x0}} [18:19:33.972] nevents = 1 [18:19:33.972] __func__ = "ServerLoop" [18:19:33.972] #15 0x0000562fb299ae6f in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x562fb587bea0) at ../src/backend/postmaster/postmaster.c:1468 [18:19:33.972] opt = [18:19:33.972] status = [18:19:33.972] userDoption = [18:19:33.972] listen_addr_saved = false [18:19:33.972] output_config_variable = [18:19:33.972] __func__ = "PostmasterMain" [18:19:33.972] #16 0x0000562fb27c582c in main (argc=8, argv=0x562fb587bea0) at ../src/backend/main/main.c:197 [18:19:33.972] do_check_root =