[20:29:09.884] src/tools/ci/cores_backtrace.sh linux /tmp/cores [20:29:10.585] dumping /tmp/cores/postgres-11-34962.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:29:12.280] [New LWP 34962] [20:29:12.280] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [20:29:13.042] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [20:29:13.809] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [20:29:15.050] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [20:29:17.410] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [20:29:17.410] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [20:29:19.290] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [20:29:20.527] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [20:29:22.139] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [20:29:23.229] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [20:29:24.006] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [20:29:25.255] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [20:29:26.871] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [20:29:28.303] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [20:29:29.236] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [20:29:30.816] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [20:29:32.213] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [20:29:32.685] [Thread debugging using libthread_db enabled] [20:29:32.685] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:29:33.756] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [20:29:35.165] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [20:29:36.253] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [20:29:36.884] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [20:29:37.669] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [20:29:39.978] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [20:29:40.905] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [20:29:41.679] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [20:29:42.593] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [20:29:43.512] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [20:29:45.125] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [20:29:46.215] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [20:29:47.000] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [20:29:48.405] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [20:29:49.033] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [20:29:50.606] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [20:29:51.388] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [20:29:52.645] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [20:29:53.574] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [20:29:54.659] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [20:29:55.609] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [20:29:56.849] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [20:29:57.477] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [20:29:58.405] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [20:29:59.166] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [20:29:59.660] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [20:29:59.660] Program terminated with signal SIGSEGV, Segmentation fault. [20:29:59.660] #0 0x000055de07c3801d in equal (a=0xa195f50, b=b@entry=0x55de0a192c48) at ../src/backend/nodes/equalfuncs.c:239 [20:29:59.660] 239 if (nodeTag(a) != nodeTag(b)) [20:29:59.822] [20:29:59.822] Thread 1 (Thread 0x7f10b75afa40 (LWP 34962)): [20:29:59.822] #0 0x000055de07c3801d in equal (a=0xa195f50, b=b@entry=0x55de0a192c48) at ../src/backend/nodes/equalfuncs.c:239 [20:29:59.822] retval = [20:29:59.822] __func__ = "equal" [20:29:59.822] #1 0x000055de0756fab7 in list_member (list=0x55de0a195fc0, datum=datum@entry=0x55de0a192c48) at ../src/backend/nodes/list.c:670 [20:29:59.822] cell__state = {l = , i = } [20:29:59.822] cell = [20:29:59.822] #2 0x000055de07693e91 in add_new_column_to_pathtarget (target=target@entry=0x55de0a195ee0, expr=0x55de0a192c48) at ../src/backend/optimizer/util/tlist.c:743 [20:29:59.822] No locals. [20:29:59.822] #3 0x000055de07693f2c in add_new_columns_to_pathtarget (target=target@entry=0x55de0a195ee0, exprs=exprs@entry=0x55de0a1960f0) at ../src/backend/optimizer/util/tlist.c:760 [20:29:59.822] expr = [20:29:59.822] lc__state = {l = , i = } [20:29:59.822] lc = [20:29:59.822] #4 0x000055de0760c24e in make_group_input_target (root=root@entry=0x55de0a1904e0, final_target=final_target@entry=0x55de0a195d80) at ../src/backend/optimizer/plan/planner.c:5472 [20:29:59.822] parse = 0x55de0a06ad48 [20:29:59.822] input_target = 0x55de0a195ee0 [20:29:59.822] non_group_cols = 0x55de0a1960a0 [20:29:59.822] non_group_vars = 0x55de0a1960f0 [20:29:59.822] i = 6 [20:29:59.822] lc = 0x0 [20:29:59.822] #5 0x000055de0761f610 in grouping_planner (root=root@entry=0x55de0a1904e0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [20:29:59.822] sort_input_targets = 0x55de0a192ab8 [20:29:59.822] sort_input_target_parallel_safe = true [20:29:59.822] grouping_target = 0x55de0a195d80 [20:29:59.822] scanjoin_target = [20:29:59.822] activeWindows = 0x0 [20:29:59.822] qp_extra = {activeWindows = 0x0, gset_data = 0x55de0a194118} [20:29:59.822] sort_input_targets_contain_srfs = 0x55de07655990 [20:29:59.822] have_grouping = [20:29:59.822] wflists = 0x0 [20:29:59.822] gset_data = 0x55de0a194118 [20:29:59.822] sort_input_target = 0x55de0a195d80 [20:29:59.822] grouping_targets = 0x0 [20:29:59.822] grouping_target_parallel_safe = true [20:29:59.822] scanjoin_targets = 0x0 [20:29:59.822] scanjoin_target_parallel_safe = [20:29:59.822] grouping_targets_contain_srfs = 0x55de0757d7ab [20:29:59.822] scanjoin_targets_contain_srfs = 0x55de0a18eec8 [20:29:59.822] scanjoin_target_same_exprs = [20:29:59.822] parse = 0x55de0a06ad48 [20:29:59.822] offset_est = 0 [20:29:59.822] count_est = 0 [20:29:59.822] limit_tuples = -1 [20:29:59.822] have_postponed_srfs = false [20:29:59.822] final_target = 0x55de0a195d80 [20:29:59.822] final_targets = 0x0 [20:29:59.822] final_targets_contain_srfs = 0x55de0765bc87 [20:29:59.822] final_target_parallel_safe = true [20:29:59.822] current_rel = 0x55de0a18ae08 [20:29:59.822] final_rel = [20:29:59.822] extra = {limit_needed = 224, limit_tuples = 1.9762625833649862e-323, count_est = 94412140512480, offset_est = 0} [20:29:59.822] lc = [20:29:59.822] __func__ = "grouping_planner" [20:29:59.822] #6 0x000055de076224c9 in subquery_planner (glob=glob@entry=0x55de0a132568, parse=parse@entry=0x55de0a06ad48, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [20:29:59.822] root = 0x55de0a1904e0 [20:29:59.822] newWithCheckOptions = [20:29:59.822] newHaving = 0x0 [20:29:59.822] hasOuterJoins = [20:29:59.822] hasResultRTEs = false [20:29:59.822] final_rel = [20:29:59.822] l = 0x0 [20:29:59.822] #7 0x000055de0762311e in standard_planner (parse=parse@entry=0x55de0a06ad48, query_string=query_string@entry=0x55de0a069290 "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 [20:29:59.822] result = [20:29:59.822] glob = 0x55de0a132568 [20:29:59.822] tuple_fraction = 0 [20:29:59.822] root = [20:29:59.822] final_rel = [20:29:59.822] best_path = [20:29:59.822] top_plan = [20:29:59.822] lp = [20:29:59.822] lr = [20:29:59.822] #8 0x00007f10b73dc73e in pgss_planner (parse=0x55de0a06ad48, query_string=0x55de0a069290 "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 [20:29:59.822] _save_exception_stack = 0x7fffade33ab0 [20:29:59.822] _save_context_stack = 0x0 [20:29:59.822] _local_sigjmp_buf = {{__jmpbuf = {94412139310408, -1740594867361737062, 0, 2048, 0, 94412139303568, -5504693986527734118, -5600982299675519334}, __mask_was_saved = 0, __saved_mask = {__val = {70368744203529, 1, 94412090923741, 1, 94412096779003, 1, 94412140507832, 0, 0, 0, 94412100705599, 0, 94412094236850, 0, 94412139310408, 0}}}} [20:29:59.822] _do_rethrow = false [20:29:59.822] result = 0x7fffade33820 [20:29:59.822] #9 0x000055de076241d8 in planner (parse=parse@entry=0x55de0a06ad48, query_string=query_string@entry=0x55de0a069290 "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 [20:29:59.822] result = [20:29:59.822] #10 0x000055de078943f3 in pg_plan_query (querytree=querytree@entry=0x55de0a06ad48, query_string=query_string@entry=0x55de0a069290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [20:29:59.822] plan = [20:29:59.822] #11 0x000055de07894760 in pg_plan_queries (querytrees=0x55de0a18f2b8, query_string=query_string@entry=0x55de0a069290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [20:29:59.822] query = 0x55de0a06ad48 [20:29:59.822] stmt = [20:29:59.822] query_list__state = {l = , i = } [20:29:59.822] stmt_list = 0x0 [20:29:59.822] query_list = [20:29:59.822] #12 0x000055de07894b3a in exec_simple_query (query_string=query_string@entry=0x55de0a069290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [20:29:59.822] cmdtaglen = 6 [20:29:59.822] snapshot_set = true [20:29:59.822] per_parsetree_context = 0x0 [20:29:59.822] plantree_list = [20:29:59.822] parsetree = 0x55de0a06abb8 [20:29:59.822] commandTag = CMDTAG_SELECT [20:29:59.822] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94412139303568} [20:29:59.822] querytree_list = [20:29:59.822] portal = [20:29:59.822] receiver = [20:29:59.822] format = 0 [20:29:59.822] cmdtagname = [20:29:59.822] parsetree_item__state = {l = , i = } [20:29:59.822] dest = DestRemote [20:29:59.822] oldcontext = 0x55de0a095880 [20:29:59.822] parsetree_list = 0x55de0a06abe8 [20:29:59.822] parsetree_item = 0x55de0a06ac00 [20:29:59.822] save_log_statement_stats = false [20:29:59.822] was_logged = true [20:29:59.822] use_implicit_block = false [20:29:59.822] msec_str = "`<\343\255\377\177\000\000.\201\266\a\336U\000\000\220:\343\255\377\177\000\000[\000\000\000\000\000\000" [20:29:59.822] __func__ = "exec_simple_query" [20:29:59.822] #13 0x000055de07897a3a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [20:29:59.822] query_string = 0x55de0a069290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [20:29:59.822] firstchar = [20:29:59.822] input_message = {data = 0x55de0a069290 "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} [20:29:59.822] local_sigjmp_buf = {{__jmpbuf = {94412112995096, -1740589751495747942, 4, 140736110738528, 140736110738676, 1, -5504693987047827814, -1740587176126638438}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94412139278144, 16384, 8248, 94412100619098, 0, 0, 0, 94412112995104, 94412139278144, 94412112989176, 140736110738528, 140736110738676, 1, 94412100622148, 140736110738304}}}} [20:29:59.822] send_ready_for_query = false [20:29:59.822] idle_in_transaction_timeout_enabled = false [20:29:59.822] idle_session_timeout_enabled = false [20:29:59.822] __func__ = "PostgresMain" [20:29:59.822] #14 0x000055de0788e1f1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [20:29:59.822] bsdata = [20:29:59.822] #15 0x000055de07738a5e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffade33c0c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffade33c60) at ../src/backend/postmaster/launch_backend.c:265 [20:29:59.822] pid = [20:29:59.822] #16 0x000055de0773ebde in BackendStartup (client_sock=client_sock@entry=0x7fffade33c60) at ../src/backend/postmaster/postmaster.c:3593 [20:29:59.822] bn = 0x55de0a0959f8 [20:29:59.822] pid = [20:29:59.822] startup_data = {canAcceptConnections = CAC_OK} [20:29:59.822] __func__ = "BackendStartup" [20:29:59.822] #17 0x000055de0773f18c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [20:29:59.822] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\277\271\020\177\000\000 鎺\020\177\000\000\b=\343\255\377\177\000\000\004=\343\255\377\177\000\000\000\000\000\000\377\177\000\000\340\064\t\n\336U\000\000\000\000\000\000\377\177\000\000\020\036\277\271\020\177\000\000\340?\276\271\020\177\000\000\352\177۹\020\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\004=\343\255\377\177\000\000\340\064\t\n\336U\000\000\320=\343\255\377\177\000", __ss_align = 139709814362912}, salen = 2}} [20:29:59.822] i = 0 [20:29:59.822] now = [20:29:59.822] last_lockfile_recheck_time = 1711225608 [20:29:59.822] last_touch_time = 1711225608 [20:29:59.822] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = -1165039736, events = 32528, fd = -1176797206, user_data = 0x7fffade33e68}, {pos = -1377616448, events = 32767, fd = -1377616432, user_data = 0x7f10bb55fce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -1218750952, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f10ba8ee420}, {pos = -1, events = 0, fd = -1218750952, user_data = 0x7f10ba8ee420}, {pos = -1165039328, events = 1, fd = -1165039736, user_data = 0x0}, {pos = -1377616448, events = 32767, fd = 1024, user_data = 0xffffffff}, {pos = -1377616160, events = 32767, fd = -1178713064, user_data = 0x7f10ba8ee920}, {pos = 168400200, events = 21982, fd = 168399832, user_data = 0x55de0a094b60}, {pos = 168400232, events = 21982, fd = 168398993, user_data = 0x7f10bb564623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = -1176694536, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = 168210672, events = 21982, fd = -1151973853, user_data = 0x1}, {pos = 0, events = 0, fd = 168381280, user_data = 0x7f10b9be4418}, {pos = -1377615312, events = 32767, fd = -1151945078, user_data = 0x0}, {pos = 0, events = 0, fd = -1377615280, user_data = 0x55de087440e0 }, {pos = 2, events = 0, fd = 141836512, user_data = 0x0}, {pos = -1178186164, events = 32528, fd = 168421648, user_data = 0x7f10b9daebe0}, {pos = 255, events = 0, fd = 8096, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x0}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {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 = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55de0a066fe0}, {pos = 168194016, events = 21982, fd = -1176852352, user_data = 0x7f10b9c5d51a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -1178194949, user_data = 0x400}, {pos = 168194016, events = 21982, fd = -1176849280, user_data = 0x10a066fe0}, {pos = 784, events = 0, fd = 131820524, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55de07b87898 }, {pos = 168399024, events = 21982, fd = 168399024, user_data = 0x55de0a0990b0}, {pos = 1, events = 0, fd = 168399224, user_data = 0x400}, {pos = 0, events = 0, fd = 129597011, user_data = 0x55de087522d0 }, {pos = 129530687, events = 21982, fd = 168399024, user_data = 0x55de0a069190}, {pos = 168399024, events = 21982, fd = 15, user_data = 0x4a}, {pos = 129598779, events = 21982, fd = 168399024, user_data = 0x55de07b9867d }, {pos = 168194016, events = 21982, fd = -1178194642, user_data = 0x0}, {pos = 123051401, events = 21982, fd = 168373184, user_data = 0x7f10b9c5f1aa}, {pos = -1377615128, events = 1, fd = 0, user_data = 0x7f10b9c5d8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 31046, user_data = 0x7f10b9ca7b05 }, {pos = 0, events = 0, fd = -188891392, user_data = 0x0}, {pos = 125011844, events = 21982, fd = 4194304, user_data = 0x55de07b879d3 }, {pos = 168373184, events = 21982, fd = 168202640, user_data = 0x55de0a092bc0}, {pos = 1, events = 0, fd = 0, user_data = 0x55de07b9853b }, {pos = 168373184, events = 21982, fd = 129599101, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55de0755995c }, {pos = 0, events = 0, fd = 123074354, user_data = 0xb}, {pos = 125033264, events = 21982, fd = 0, user_data = 0x0}} [20:29:59.822] nevents = 1 [20:29:59.822] __func__ = "ServerLoop" [20:29:59.822] #18 0x000055de07740bae in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55de0a062e40) at ../src/backend/postmaster/postmaster.c:1372 [20:29:59.822] opt = [20:29:59.822] status = [20:29:59.822] userDoption = [20:29:59.822] listen_addr_saved = false [20:29:59.822] output_config_variable = [20:29:59.822] __func__ = "PostmasterMain" [20:29:59.822] #19 0x000055de0756a78c in main (argc=4, argv=0x55de0a062e40) at ../src/backend/main/main.c:197 [20:29:59.822] do_check_root = [20:29:59.839] -e [20:29:59.839] [20:29:59.839] [20:30:00.384] dumping /tmp/cores/postgres-11-37752.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:30:00.690] [New LWP 37752] [20:30:01.833] [Thread debugging using libthread_db enabled] [20:30:01.833] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:30:03.947] Downloading separate debug info for /lib/x86_64-linux-gnu/libnss_files.so.2... [20:30:04.437] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN '. [20:30:04.437] Program terminated with signal SIGSEGV, Segmentation fault. [20:30:04.437] #0 0x0000564b40e9401d in equal (a=0x42ea8268, b=b@entry=0x564b42f975b8) at ../src/backend/nodes/equalfuncs.c:239 [20:30:04.437] 239 if (nodeTag(a) != nodeTag(b)) [20:30:04.606] [20:30:04.606] Thread 1 (Thread 0x7f7b8e178a40 (LWP 37752)): [20:30:04.606] #0 0x0000564b40e9401d in equal (a=0x42ea8268, b=b@entry=0x564b42f975b8) at ../src/backend/nodes/equalfuncs.c:239 [20:30:04.606] retval = [20:30:04.606] __func__ = "equal" [20:30:04.606] #1 0x0000564b407cbab7 in list_member (list=0x564b42ea82d8, datum=datum@entry=0x564b42f975b8) at ../src/backend/nodes/list.c:670 [20:30:04.606] cell__state = {l = , i = } [20:30:04.606] cell = [20:30:04.606] #2 0x0000564b408efe91 in add_new_column_to_pathtarget (target=target@entry=0x564b42ea81f8, expr=0x564b42f975b8) at ../src/backend/optimizer/util/tlist.c:743 [20:30:04.606] No locals. [20:30:04.606] #3 0x0000564b408eff2c in add_new_columns_to_pathtarget (target=target@entry=0x564b42ea81f8, exprs=exprs@entry=0x564b42ea8378) at ../src/backend/optimizer/util/tlist.c:760 [20:30:04.606] expr = [20:30:04.606] lc__state = {l = , i = } [20:30:04.606] lc = [20:30:04.606] #4 0x0000564b4086824e in make_group_input_target (root=root@entry=0x564b42f96ec8, final_target=final_target@entry=0x564b42ea8158) at ../src/backend/optimizer/plan/planner.c:5472 [20:30:04.606] parse = 0x564b42e53920 [20:30:04.606] input_target = 0x564b42ea81f8 [20:30:04.606] non_group_cols = 0x564b42ea8328 [20:30:04.606] non_group_vars = 0x564b42ea8378 [20:30:04.606] i = 2 [20:30:04.606] lc = 0x0 [20:30:04.606] #5 0x0000564b4087b610 in grouping_planner (root=root@entry=0x564b42f96ec8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [20:30:04.606] sort_input_targets = 0x564b42f973e8 [20:30:04.606] sort_input_target_parallel_safe = true [20:30:04.606] grouping_target = 0x564b42ea8158 [20:30:04.606] scanjoin_target = [20:30:04.606] activeWindows = 0x0 [20:30:04.606] qp_extra = {activeWindows = 0x0, gset_data = 0x564b42f86758} [20:30:04.606] sort_input_targets_contain_srfs = 0x564b42f866b8 [20:30:04.606] have_grouping = [20:30:04.606] wflists = 0x0 [20:30:04.606] gset_data = 0x564b42f86758 [20:30:04.606] sort_input_target = 0x564b42ea8158 [20:30:04.606] grouping_targets = 0x564b42f96ec8 [20:30:04.606] grouping_target_parallel_safe = true [20:30:04.606] scanjoin_targets = 0x1 [20:30:04.606] scanjoin_target_parallel_safe = [20:30:04.606] grouping_targets_contain_srfs = 0x564b40df5d3f [20:30:04.606] scanjoin_targets_contain_srfs = 0x564b407ca8b2 [20:30:04.606] scanjoin_target_same_exprs = [20:30:04.606] parse = 0x564b42e53920 [20:30:04.606] offset_est = 0 [20:30:04.606] count_est = 0 [20:30:04.606] limit_tuples = -1 [20:30:04.606] have_postponed_srfs = false [20:30:04.606] final_target = 0x564b42ea8158 [20:30:04.606] final_targets = 0x564b42f7ad58 [20:30:04.606] final_targets_contain_srfs = 0x564b407d083c [20:30:04.606] final_target_parallel_safe = true [20:30:04.606] current_rel = 0x564b42f7eb68 [20:30:04.606] final_rel = [20:30:04.606] extra = {limit_needed = false, limit_tuples = 4.6877543553671476e-310, count_est = 94881246111416, offset_est = 94881246111416} [20:30:04.606] lc = [20:30:04.606] __func__ = "grouping_planner" [20:30:04.606] #6 0x0000564b4087e4c9 in subquery_planner (glob=glob@entry=0x564b42f7ea58, parse=parse@entry=0x564b42e53920, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [20:30:04.606] root = 0x564b42f96ec8 [20:30:04.606] newWithCheckOptions = [20:30:04.606] newHaving = 0x0 [20:30:04.606] hasOuterJoins = [20:30:04.606] hasResultRTEs = false [20:30:04.606] final_rel = [20:30:04.606] l = 0x0 [20:30:04.606] #7 0x0000564b4087f11e in standard_planner (parse=0x564b42e53920, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [20:30:04.606] result = [20:30:04.606] glob = 0x564b42f7ea58 [20:30:04.606] tuple_fraction = 0 [20:30:04.606] root = [20:30:04.606] final_rel = [20:30:04.606] best_path = [20:30:04.606] top_plan = [20:30:04.606] lp = [20:30:04.606] lr = [20:30:04.606] #8 0x0000564b408801e2 in planner (parse=parse@entry=0x564b42e53920, query_string=query_string@entry=0x564b42e52270 "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 [20:30:04.606] result = [20:30:04.606] #9 0x0000564b40af03f3 in pg_plan_query (querytree=querytree@entry=0x564b42e53920, query_string=query_string@entry=0x564b42e52270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [20:30:04.606] plan = [20:30:04.606] #10 0x0000564b405db7b3 in standard_ExplainOneQuery (query=0x564b42e53920, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564b42fa4a18, queryString=0x564b42e52270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:440 [20:30:04.606] plan = [20:30:04.606] planstart = {ticks = } [20:30:04.606] planduration = {ticks = 94881244854560} [20:30:04.606] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94881199768408, shared_blks_dirtied = 94881244854832, shared_blks_written = 70368744194107, local_blks_hit = 0, local_blks_read = 94881201134301, local_blks_dirtied = 94881244854832, local_blks_written = 94881206989563, temp_blks_read = 1, temp_blks_written = 2048, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94880122535936}, local_blk_read_time = {ticks = 94881244854288}, local_blk_write_time = {ticks = 94881210916159}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94881204447410}} [20:30:04.606] bufusage = {shared_blks_hit = 94881246079416, shared_blks_read = 1, shared_blks_dirtied = 0, shared_blks_written = 1, local_blks_hit = 0, local_blks_read = 94881207510485, local_blks_dirtied = 70622147264512, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 16443, shared_blk_read_time = {ticks = 140168488392680}, shared_blk_write_time = {ticks = 94881246079416}, local_blk_read_time = {ticks = 94881244854560}, local_blk_write_time = {ticks = 94881210432229}, temp_blk_read_time = {ticks = 140168488392680}, temp_blk_write_time = {ticks = 94881210432248}} [20:30:04.606] mem_counters = {nblocks = 0, freechunks = 1, totalspace = 0, freespace = 94881210655893} [20:30:04.606] planner_ctx = 0x0 [20:30:04.606] saved_ctx = 0x0 [20:30:04.606] #11 0x0000564b405dba4b in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564b42fa4a18, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:396 [20:30:04.606] No locals. [20:30:04.606] #12 0x0000564b405dd042 in ExplainQuery (pstate=pstate@entry=0x564b42fa4908, stmt=stmt@entry=0x564b42e53760, params=params@entry=0x0, dest=dest@entry=0x564b42fa4878) at ../src/include/nodes/nodes.h:172 [20:30:04.606] l__state = {l = , i = } [20:30:04.606] l = 0x564b42f7ea20 [20:30:04.606] es = 0x564b42fa4a18 [20:30:04.606] tstate = [20:30:04.606] jstate = [20:30:04.606] query = [20:30:04.606] rewritten = 0x564b42f7ea08 [20:30:04.606] lc = 0x0 [20:30:04.606] timing_set = false [20:30:04.606] summary_set = false [20:30:04.606] __func__ = "ExplainQuery" [20:30:04.606] #13 0x0000564b40afae01 in standard_ProcessUtility (pstmt=0x564b42e53810, queryString=0x564b42e52270 "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=0x564b42fa4878, qc=0x7fff7c96fc50) at ../src/backend/tcop/utility.c:863 [20:30:04.606] parsetree = 0x564b42e53760 [20:30:04.606] isTopLevel = true [20:30:04.606] isAtomicContext = false [20:30:04.606] pstate = 0x564b42fa4908 [20:30:04.606] readonly_flags = [20:30:04.606] __func__ = "standard_ProcessUtility" [20:30:04.606] #14 0x0000564b40afb52a in ProcessUtility (pstmt=pstmt@entry=0x564b42e53810, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x564b42fa4878, qc=0x7fff7c96fc50) at ../src/backend/tcop/utility.c:523 [20:30:04.606] No locals. [20:30:04.606] #15 0x0000564b40af6c88 in PortalRunUtility (portal=portal@entry=0x564b42ecef90, pstmt=0x564b42e53810, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x564b42fa4878, qc=qc@entry=0x7fff7c96fc50) at ../src/backend/tcop/pquery.c:1158 [20:30:04.606] No locals. [20:30:04.606] #16 0x0000564b40af766b in FillPortalStore (portal=portal@entry=0x564b42ecef90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [20:30:04.606] treceiver = 0x564b42fa4878 [20:30:04.606] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:30:04.606] __func__ = "FillPortalStore" [20:30:04.606] #17 0x0000564b40af7ced in PortalRun (portal=portal@entry=0x564b42ecef90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x564b42f7b118, altdest=altdest@entry=0x564b42f7b118, qc=0x7fff7c96fe30) at ../src/backend/tcop/pquery.c:763 [20:30:04.606] _save_exception_stack = 0x7fff7c96fee0 [20:30:04.606] _save_context_stack = 0x0 [20:30:04.606] _local_sigjmp_buf = {{__jmpbuf = {1, -6095731518809095081, 94881246064920, 94881244854232, 94881245360016, 94881244854160, 6096014995332219991, 572270668601574487}, __mask_was_saved = 0, __saved_mask = {__val = {94881245371576, 94881213667486, 94881245368224, 94881213667486, 1, 140735283658175, 94881244854208, 94881244854160, 94881210655893, 94881213253929, 94881245360016, 94881213667486, 1, 1, 94881210916561, 153}}}} [20:30:04.606] _do_rethrow = [20:30:04.606] result = [20:30:04.606] nprocessed = [20:30:04.606] saveTopTransactionResourceOwner = 0x564b42e8dc58 [20:30:04.606] saveTopTransactionContext = 0x564b42e7ab80 [20:30:04.606] saveActivePortal = 0x0 [20:30:04.606] saveResourceOwner = 0x564b42e8dc58 [20:30:04.606] savePortalContext = 0x0 [20:30:04.606] saveMemoryContext = 0x564b42e7ab80 [20:30:04.606] __func__ = "PortalRun" [20:30:04.606] #18 0x0000564b40af0c82 in exec_simple_query (query_string=query_string@entry=0x564b42e52270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;") at ../src/backend/tcop/postgres.c:1274 [20:30:04.606] cmdtaglen = 7 [20:30:04.606] snapshot_set = [20:30:04.606] per_parsetree_context = 0x0 [20:30:04.606] plantree_list = 0x564b42f7b0c8 [20:30:04.606] parsetree = 0x564b42e53790 [20:30:04.606] commandTag = [20:30:04.606] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:30:04.606] querytree_list = [20:30:04.606] portal = 0x564b42ecef90 [20:30:04.606] receiver = 0x564b42f7b118 [20:30:04.606] format = 0 [20:30:04.606] cmdtagname = [20:30:04.606] parsetree_item__state = {l = , i = } [20:30:04.606] dest = DestRemote [20:30:04.606] oldcontext = 0x564b42e7ab80 [20:30:04.606] parsetree_list = 0x564b42e537c0 [20:30:04.606] parsetree_item = 0x564b42e537d8 [20:30:04.606] save_log_statement_stats = false [20:30:04.606] was_logged = false [20:30:04.606] use_implicit_block = false [20:30:04.606] msec_str = "\220\000\227|\377\177\000\000.A\334@KV\000\000\300\376\226|\377\177\000\000q\000\000\000\000\000\000" [20:30:04.606] __func__ = "exec_simple_query" [20:30:04.606] #19 0x0000564b40af3a3a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [20:30:04.606] query_string = 0x564b42e52270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [20:30:04.606] firstchar = [20:30:04.606] input_message = {data = 0x564b42e52270 "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} [20:30:04.606] local_sigjmp_buf = {{__jmpbuf = {94881223205656, 572273052511585367, 4, 140735283658896, 140735283659044, 1, 6096014995269305431, 572270670412334167}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140168682204644, 94881244823296, 15616, 15680, 94881210827951, 94881223205664, 94881244823296, 94881223199736, 140735283658896, 140735283659044, 94881210832019, 140735283658672}}}} [20:30:04.606] send_ready_for_query = false [20:30:04.606] idle_in_transaction_timeout_enabled = false [20:30:04.606] idle_session_timeout_enabled = false [20:30:04.606] __func__ = "PostgresMain" [20:30:04.606] #20 0x0000564b40aea1f1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [20:30:04.606] bsdata = [20:30:04.606] #21 0x0000564b40994a5e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff7c97003c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff7c970090) at ../src/backend/postmaster/launch_backend.c:265 [20:30:04.606] pid = [20:30:04.606] #22 0x0000564b4099abde in BackendStartup (client_sock=client_sock@entry=0x7fff7c970090) at ../src/backend/postmaster/postmaster.c:3593 [20:30:04.606] bn = 0x564b42e7ac58 [20:30:04.606] pid = [20:30:04.606] startup_data = {canAcceptConnections = CAC_OK} [20:30:04.606] __func__ = "BackendStartup" [20:30:04.606] #23 0x0000564b4099b18c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [20:30:04.606] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\022\222{\177\000\000-\000\000\000\000\000\000\000\020\256{\220{\177\000\000 yK\221{\177\000\000H\001\227|\377\177\000\000D\001\227|\377\177\000\000\004\001\227|\377\177\000\000@\036\033\216{\177\000\000\000\000\000\000\377\177\000\000\020\256{\220{\177\000\000\340\317z\220{\177\000\000\352\017\230\220{\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000D\001\227|\377\177\000", __ss_align = 140168641846848}, salen = 2}} [20:30:04.606] i = 0 [20:30:04.606] now = [20:30:04.606] last_lockfile_recheck_time = 1711225630 [20:30:04.606] last_touch_time = 1711225630 [20:30:04.606] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 2090271168, events = 32767, fd = 2090271184, user_data = 0x0}, {pos = 18, events = 0, fd = 1508362478, user_data = 0x7f7b914b7788}, {pos = -1869082646, events = 32635, fd = 2090271400, user_data = 0x7fff7c970200}, {pos = 2090271248, events = 32767, fd = -1844278047, user_data = 0x12}, {pos = -1911036392, events = 32635, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1857326048, user_data = 0xffffffff}, {pos = -1911036392, events = 32635, fd = -1857326048, user_data = 0x1914b7920}, {pos = -1857325176, events = 32635, fd = 0, user_data = 0x7fff7c97031e}, {pos = 2090271504, events = 32767, fd = -1, user_data = 0x7fff7c970220}, {pos = -1870998504, events = 32635, fd = -1857324768, user_data = 0x564b42e7fc18}, {pos = 1122490136, events = 22091, fd = 1122466304, user_data = 0x564b42e7fc38}, {pos = 1122499441, events = 22091, fd = -1844259293, user_data = 0x1}, {pos = -1868979976, events = 32635, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x564b42e54040}, {pos = -1844259293, events = 32635, fd = 1, user_data = 0x0}, {pos = 1122466304, events = 22091, fd = -1870998504, user_data = 0x7fff7c970660}, {pos = -1844230518, events = 32635, fd = 0, user_data = 0x0}, {pos = 2090272384, events = 32767, fd = 1100611808, user_data = 0x2}, {pos = 1100611808, events = 22091, fd = 0, user_data = 0x7f7b90977be0}, {pos = 255, events = 0, fd = 7, user_data = 0x0}, {pos = 8096, events = 196607, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 1122493352, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0x65725f67702f706d}, {pos = 1936028263, events = 1868639603, fd = 762540901, user_data = 0x372020200a0a4146}, {pos = 822763892, events = 842084663, fd = 859190578, user_data = 0x5f7365726774736f}, {pos = 796353638, events = 1919378802, fd = 1919509295, user_data = 0x646c6975622d6963}, {pos = 824188960, events = 926430006, fd = 2613, 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 = -1869137792, user_data = 0x7f7b9082651a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -1870480389, user_data = 0x400}, {pos = 1122303904, events = 22091, fd = -1869134720, user_data = 0x142e4ffa0}, {pos = 784, events = 0, fd = 1090595820, user_data = 0x564b42e7d3f0}, {pos = 1662552832, events = 57009289, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1122489328, events = 22091, fd = 1122489328, user_data = 0x564b42e7d3f0}, {pos = 1, events = 0, fd = 1122489528, user_data = 0x400}, {pos = 0, events = 0, fd = 1088372307, user_data = 0x564b419ae2d0 }, {pos = 1088305983, events = 22091, fd = 1122489328, user_data = 0x564b42e52170}, {pos = 1122489328, events = 22091, fd = 15, user_data = 0x4a}, {pos = 1088374075, events = 22091, fd = 1122489328, user_data = 0x564b40df467d }, {pos = 1122303904, events = 22091, fd = -1870480389, user_data = 0x0}, {pos = 1081826697, events = 22091, fd = 1122477936, user_data = 0x7f7b908281aa}, {pos = 2090272536, events = 1, fd = 0, user_data = 0x7f7b908268f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 37638, user_data = 0x7f7b90870b05 }, {pos = 0, events = 0, fd = 1662552832, user_data = 0x0}, {pos = 1083787140, events = 22091, fd = 4194304, user_data = 0x564b40de39d3 }, {pos = 1122477936, events = 22091, fd = 1122312560, user_data = 0x564b42e7a770}, {pos = 1, events = 0, fd = 0, user_data = 0x564b40df453b }, {pos = 1122477936, events = 22091, fd = 1088374397, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x564b407b595c }, {pos = 0, events = 0, fd = 1081849650, user_data = 0xb}, {pos = 1083808560, events = 22091, fd = 0, user_data = 0x0}} [20:30:04.606] nevents = 1 [20:30:04.606] __func__ = "ServerLoop" [20:30:04.606] #24 0x0000564b4099cbae in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564b42e4be60) at ../src/backend/postmaster/postmaster.c:1372 [20:30:04.606] opt = [20:30:04.606] status = [20:30:04.606] userDoption = [20:30:04.606] listen_addr_saved = false [20:30:04.606] output_config_variable = [20:30:04.606] __func__ = "PostmasterMain" [20:30:04.606] #25 0x0000564b407c678c in main (argc=8, argv=0x564b42e4be60) at ../src/backend/main/main.c:197 [20:30:04.606] do_check_root = [20:30:04.625] -e [20:30:04.625] [20:30:04.625] [20:30:05.163] dumping /tmp/cores/postgres-11-27664.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:30:05.478] [New LWP 27664] [20:30:06.627] [Thread debugging using libthread_db enabled] [20:30:06.627] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:30:08.064] Core was generated by `postgres: postgres regression [local] SELECT '. [20:30:08.064] Program terminated with signal SIGSEGV, Segmentation fault. [20:30:08.064] #0 0x000055d7990cf01d in equal (a=0xffffffff9a8c0af8, b=b@entry=0x55d79a8bd8f8) at ../src/backend/nodes/equalfuncs.c:239 [20:30:08.064] 239 if (nodeTag(a) != nodeTag(b)) [20:30:08.178] [20:30:08.178] Thread 1 (Thread 0x7f92206b7a40 (LWP 27664)): [20:30:08.178] #0 0x000055d7990cf01d in equal (a=0xffffffff9a8c0af8, b=b@entry=0x55d79a8bd8f8) at ../src/backend/nodes/equalfuncs.c:239 [20:30:08.178] retval = [20:30:08.178] __func__ = "equal" [20:30:08.178] #1 0x000055d798a06ab7 in list_member (list=0x55d79a8c0b68, datum=datum@entry=0x55d79a8bd8f8) at ../src/backend/nodes/list.c:670 [20:30:08.178] cell__state = {l = , i = } [20:30:08.178] cell = [20:30:08.178] #2 0x000055d798b2ae91 in add_new_column_to_pathtarget (target=target@entry=0x55d79a8c0a88, expr=0x55d79a8bd8f8) at ../src/backend/optimizer/util/tlist.c:743 [20:30:08.178] No locals. [20:30:08.178] #3 0x000055d798b2af2c in add_new_columns_to_pathtarget (target=target@entry=0x55d79a8c0a88, exprs=exprs@entry=0x55d79a8c0c98) at ../src/backend/optimizer/util/tlist.c:760 [20:30:08.178] expr = [20:30:08.178] lc__state = {l = , i = } [20:30:08.178] lc = [20:30:08.178] #4 0x000055d798aa324e in make_group_input_target (root=root@entry=0x55d79a8b5b08, final_target=final_target@entry=0x55d79a8c0928) at ../src/backend/optimizer/plan/planner.c:5472 [20:30:08.178] parse = 0x55d79a78dd18 [20:30:08.178] input_target = 0x55d79a8c0a88 [20:30:08.178] non_group_cols = 0x55d79a8c0c48 [20:30:08.178] non_group_vars = 0x55d79a8c0c98 [20:30:08.178] i = 6 [20:30:08.178] lc = 0x0 [20:30:08.178] #5 0x000055d798ab6610 in grouping_planner (root=root@entry=0x55d79a8b5b08, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [20:30:08.178] sort_input_targets = 0x55d79a8bd768 [20:30:08.178] sort_input_target_parallel_safe = true [20:30:08.178] grouping_target = 0x55d79a8c0928 [20:30:08.178] scanjoin_target = [20:30:08.178] activeWindows = 0x0 [20:30:08.178] qp_extra = {activeWindows = 0x0, gset_data = 0x55d79a8bed88} [20:30:08.178] sort_input_targets_contain_srfs = 0x55d798aec990 [20:30:08.178] have_grouping = [20:30:08.178] wflists = 0x0 [20:30:08.178] gset_data = 0x55d79a8bed88 [20:30:08.178] sort_input_target = 0x55d79a8c0928 [20:30:08.178] grouping_targets = 0x0 [20:30:08.178] grouping_target_parallel_safe = true [20:30:08.178] scanjoin_targets = 0x0 [20:30:08.178] scanjoin_target_parallel_safe = [20:30:08.178] grouping_targets_contain_srfs = 0x55d798a147ab [20:30:08.178] scanjoin_targets_contain_srfs = 0x55d79a8b9fd8 [20:30:08.178] scanjoin_target_same_exprs = [20:30:08.178] parse = 0x55d79a78dd18 [20:30:08.178] offset_est = 0 [20:30:08.178] count_est = 0 [20:30:08.178] limit_tuples = -1 [20:30:08.178] have_postponed_srfs = false [20:30:08.178] final_target = 0x55d79a8c0928 [20:30:08.178] final_targets = 0x0 [20:30:08.178] final_targets_contain_srfs = 0x55d798af2c87 [20:30:08.178] final_target_parallel_safe = true [20:30:08.178] current_rel = 0x55d79a8b5f18 [20:30:08.178] final_rel = [20:30:08.178] extra = {limit_needed = 8, limit_tuples = 1.9762625833649862e-323, count_est = 94384499153672, offset_est = 0} [20:30:08.178] lc = [20:30:08.178] __func__ = "grouping_planner" [20:30:08.178] #6 0x000055d798ab94c9 in subquery_planner (glob=glob@entry=0x55d79a78df88, parse=parse@entry=0x55d79a78dd18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [20:30:08.178] root = 0x55d79a8b5b08 [20:30:08.178] newWithCheckOptions = [20:30:08.178] newHaving = 0x0 [20:30:08.178] hasOuterJoins = [20:30:08.178] hasResultRTEs = false [20:30:08.178] final_rel = [20:30:08.178] l = 0x0 [20:30:08.178] #7 0x000055d798aba11e in standard_planner (parse=0x55d79a78dd18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [20:30:08.178] result = [20:30:08.178] glob = 0x55d79a78df88 [20:30:08.178] tuple_fraction = 0 [20:30:08.178] root = [20:30:08.178] final_rel = [20:30:08.178] best_path = [20:30:08.178] top_plan = [20:30:08.178] lp = [20:30:08.178] lr = [20:30:08.178] #8 0x000055d798abb1e2 in planner (parse=parse@entry=0x55d79a78dd18, query_string=query_string@entry=0x55d79a78c260 "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 [20:30:08.178] result = [20:30:08.178] #9 0x000055d798d2b3f3 in pg_plan_query (querytree=querytree@entry=0x55d79a78dd18, query_string=query_string@entry=0x55d79a78c260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [20:30:08.178] plan = [20:30:08.178] #10 0x000055d798d2b760 in pg_plan_queries (querytrees=0x55d79a8ba378, query_string=query_string@entry=0x55d79a78c260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [20:30:08.178] query = 0x55d79a78dd18 [20:30:08.178] stmt = [20:30:08.178] query_list__state = {l = , i = } [20:30:08.178] stmt_list = 0x0 [20:30:08.178] query_list = [20:30:08.178] #11 0x000055d798d2bb3a in exec_simple_query (query_string=query_string@entry=0x55d79a78c260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [20:30:08.178] cmdtaglen = 6 [20:30:08.178] snapshot_set = true [20:30:08.178] per_parsetree_context = 0x0 [20:30:08.178] plantree_list = [20:30:08.178] parsetree = 0x55d79a78db88 [20:30:08.178] commandTag = CMDTAG_SELECT [20:30:08.178] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94384497934944} [20:30:08.178] querytree_list = [20:30:08.178] portal = [20:30:08.178] receiver = [20:30:08.178] format = 0 [20:30:08.178] cmdtagname = [20:30:08.178] parsetree_item__state = {l = , i = } [20:30:08.178] dest = DestRemote [20:30:08.178] oldcontext = 0x55d79a7b4b70 [20:30:08.178] parsetree_list = 0x55d79a78dbb8 [20:30:08.178] parsetree_item = 0x55d79a78dbd0 [20:30:08.178] save_log_statement_stats = false [20:30:08.178] was_logged = false [20:30:08.178] use_implicit_block = false [20:30:08.178] msec_str = "\000\364\067\030\377\177\000\000.\361\377\230\327U\000\000\060\362\067\030\377\177\000\000[\000\000\000\000\000\000" [20:30:08.178] __func__ = "exec_simple_query" [20:30:08.178] #12 0x000055d798d2ea3a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [20:30:08.178] query_string = 0x55d79a78c260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [20:30:08.178] firstchar = [20:30:08.178] input_message = {data = 0x55d79a78c260 "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} [20:30:08.178] local_sigjmp_buf = {{__jmpbuf = {94384485733144, -102965562160795201, 4, 140733599708160, 140733599708308, 1, -6142010151362711105, -102963195094191681}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140265626459620, 94384497909488, 15616, 15680, 94384473355439, 94384485733152, 94384497909488, 94384485727224, 140733599708160, 140733599708308, 94384473359507, 140733599707936}}}} [20:30:08.178] send_ready_for_query = false [20:30:08.178] idle_in_transaction_timeout_enabled = false [20:30:08.178] idle_session_timeout_enabled = false [20:30:08.178] __func__ = "PostgresMain" [20:30:08.178] #13 0x000055d798d251f1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [20:30:08.178] bsdata = [20:30:08.178] #14 0x000055d798bcfa5e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff1837f3ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff1837f400) at ../src/backend/postmaster/launch_backend.c:265 [20:30:08.178] pid = [20:30:08.178] #15 0x000055d798bd5bde in BackendStartup (client_sock=client_sock@entry=0x7fff1837f400) at ../src/backend/postmaster/postmaster.c:3593 [20:30:08.178] bn = 0x55d79a7b4d38 [20:30:08.178] pid = [20:30:08.178] startup_data = {canAcceptConnections = CAC_OK} [20:30:08.178] __func__ = "BackendStartup" [20:30:08.178] #16 0x000055d798bd618c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [20:30:08.178] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\353\"\222\177\000\000\001\000\000\000\000\000\000\000\244sf$\222\177\000\000-\000\000\000\000\000\000\000\020\236\317\"\222\177\000\000 i\237#\222\177\000\000\310\364\067\030\377\177\000\000\304\364\067\030\377\177\000\000\204\364\067\030\377\177\000\000@\016\000\000\001\000\000\000\000\000\000\000\327U\000\000\020\236\317\"\222\177\000\000\340\277\316\"\222\177\000\000\352\377\353\"\222\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [20:30:08.178] i = 0 [20:30:08.178] now = [20:30:08.178] last_lockfile_recheck_time = 1711225583 [20:30:08.178] last_touch_time = 1711225583 [20:30:08.178] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 406320512, events = 32767, fd = 45, user_data = 0x7fff1837f540}, {pos = 406320464, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 597649288, user_data = 0x7f9222ebffea}, {pos = 406320680, events = 32767, fd = 406320512, user_data = 0x7fff1837f590}, {pos = 610696417, events = 32658, fd = 18, user_data = 0x7f92206bd618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 597648416, events = 32658, fd = -1, user_data = 0x7f92206bd618}, {pos = 597648416, events = 32658, fd = 1024, user_data = 0x7f92239f6788}, {pos = 0, events = 0, fd = 8, user_data = 0x7fff1837f590}, {pos = -1, events = 0, fd = 584756410, user_data = 0x7f9222cec418}, {pos = 597649696, events = 32658, fd = -1703175160, user_data = 0x55d79a7b7708}, {pos = -1703208464, events = 21975, fd = -1703175128, user_data = 0x55d79a7b9b61}, {pos = 610715171, events = 32658, fd = 1, user_data = 0x7f9222ed90f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -1703354320, user_data = 0x7f922466c623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x55d79a7b19f0}, {pos = 583975960, events = 32658, fd = 406321616, user_data = 0x7f922467368a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7fff1837f9f0}, {pos = -1715621664, events = 21975, fd = 2, user_data = 0x55d799bdb0e0 }, {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 = -1703181416, 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 = 0xa626c754970582d}, {pos = 762540901, events = 1967747160, fd = 168452716, user_data = 0x32313137310a6174}, {pos = 943011122, events = 808716851, 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 = 584494075, user_data = 0x400}, {pos = -1703370864, events = 21975, fd = 585839744, user_data = 0x19a789f90}, {pos = 784, events = 0, fd = -1725637652, user_data = 0x55d79a7b73e0}, {pos = 1710577664, events = 3838128432, fd = 4, user_data = 0x55d79a7b8360}, {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 = 0x55d79a7b73e0}, {pos = 1, events = 0, fd = -1703185240, user_data = 0x400}, {pos = 0, events = 0, fd = -1727861165, user_data = 0x55d799be92d0 }, {pos = -1727927489, events = 21975, fd = -1703185440, user_data = 0x55d79a78c160}, {pos = -1703185440, events = 21975, fd = 15, user_data = 0x4a}, {pos = -1727859397, events = 21975, fd = -1703185440, user_data = 0x55d79902f67d }, {pos = -1703370864, events = 21975, fd = 584494075, user_data = 0x0}, {pos = -1734406775, events = 21975, fd = -1703196832, user_data = 0x7f9222d671aa}, {pos = 406321800, events = 1, fd = 0, user_data = 0x7f9222d658f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 23941, user_data = 0x7f9222dafb05 }, {pos = 0, events = 0, fd = 1710577664, user_data = 0x0}, {pos = -1732446332, events = 21975, fd = 4194304, user_data = 0x55d79901e9d3 }, {pos = -1703196832, events = 21975, fd = -1703362208, user_data = 0x55d79a7b4760}, {pos = 1, events = 0, fd = 0, user_data = 0x55d79902f53b }, {pos = -1703196832, events = 21975, fd = -1727859075, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55d7989f095c }, {pos = 0, events = 0, fd = -1734383822, user_data = 0xb}, {pos = -1732424912, events = 21975, fd = 0, user_data = 0x0}} [20:30:08.178] nevents = 1 [20:30:08.178] __func__ = "ServerLoop" [20:30:08.178] #17 0x000055d798bd7bae in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55d79a785e50) at ../src/backend/postmaster/postmaster.c:1372 [20:30:08.178] opt = [20:30:08.178] status = [20:30:08.178] userDoption = [20:30:08.178] listen_addr_saved = false [20:30:08.178] output_config_variable = [20:30:08.178] __func__ = "PostmasterMain" [20:30:08.178] #18 0x000055d798a0178c in main (argc=8, argv=0x55d79a785e50) at ../src/backend/main/main.c:197 [20:30:08.178] do_check_root = [20:30:08.196] -e [20:30:08.196] [20:30:08.196] [20:30:08.743] dumping /tmp/cores/postgres-11-37440.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:30:09.050] [New LWP 37440] [20:30:10.202] [Thread debugging using libthread_db enabled] [20:30:10.202] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:30:11.733] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT '. [20:30:11.733] Program terminated with signal SIGSEGV, Segmentation fault. [20:30:11.733] #0 0x0000560f24d17b5b in get_expr_width (root=root@entry=0x560f2615aea8, expr=expr@entry=0x26213c78) at ../src/backend/optimizer/path/costsize.c:6329 [20:30:11.733] 6329 if (IsA(expr, Var)) [20:30:11.849] [20:30:11.849] Thread 1 (Thread 0x7f715a26ea40 (LWP 37440)): [20:30:11.849] #0 0x0000560f24d17b5b in get_expr_width (root=root@entry=0x560f2615aea8, expr=expr@entry=0x26213c78) at ../src/backend/optimizer/path/costsize.c:6329 [20:30:11.849] width = [20:30:11.849] #1 0x0000560f24d28781 in set_pathtarget_cost_width (root=root@entry=0x560f2615aea8, target=target@entry=0x560f26213c08) at ../src/backend/optimizer/path/costsize.c:6300 [20:30:11.849] node = 0x26213c78 [20:30:11.849] lc__state = {l = , i = } [20:30:11.849] tuple_width = 0 [20:30:11.849] lc = [20:30:11.849] #2 0x0000560f24d83269 in make_group_input_target (root=root@entry=0x560f2615aea8, final_target=final_target@entry=0x560f26213b48) at ../src/backend/optimizer/plan/planner.c:5479 [20:30:11.849] parse = 0x560f26206c58 [20:30:11.849] input_target = 0x560f26213c08 [20:30:11.849] non_group_cols = 0x0 [20:30:11.849] non_group_vars = 0x0 [20:30:11.849] i = 3 [20:30:11.849] lc = 0x0 [20:30:11.849] #3 0x0000560f24d96610 in grouping_planner (root=root@entry=0x560f2615aea8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [20:30:11.849] sort_input_targets = 0x560f2615c630 [20:30:11.849] sort_input_target_parallel_safe = true [20:30:11.849] grouping_target = 0x560f26213b48 [20:30:11.849] scanjoin_target = [20:30:11.849] activeWindows = 0x0 [20:30:11.849] qp_extra = {activeWindows = 0x0, gset_data = 0x560f2615cbd0} [20:30:11.849] sort_input_targets_contain_srfs = 0x560f24dcc990 [20:30:11.849] have_grouping = [20:30:11.849] wflists = 0x0 [20:30:11.849] gset_data = 0x560f2615cbd0 [20:30:11.849] sort_input_target = 0x560f26213b48 [20:30:11.849] grouping_targets = 0x0 [20:30:11.849] grouping_target_parallel_safe = true [20:30:11.849] scanjoin_targets = 0x0 [20:30:11.849] scanjoin_target_parallel_safe = [20:30:11.849] grouping_targets_contain_srfs = 0x560f24cf47ab [20:30:11.849] scanjoin_targets_contain_srfs = 0x560f26208b00 [20:30:11.849] scanjoin_target_same_exprs = [20:30:11.849] parse = 0x560f26206c58 [20:30:11.849] offset_est = 0 [20:30:11.849] count_est = 0 [20:30:11.849] limit_tuples = -1 [20:30:11.849] have_postponed_srfs = false [20:30:11.849] final_target = 0x560f26213b48 [20:30:11.849] final_targets = 0x0 [20:30:11.849] final_targets_contain_srfs = 0x560f24dd2c87 [20:30:11.849] final_target_parallel_safe = true [20:30:11.849] current_rel = 0x560f26212158 [20:30:11.849] final_rel = [20:30:11.849] extra = {limit_needed = 168, limit_tuples = 1.9762625833649862e-323, count_est = 94623063453352, offset_est = 0} [20:30:11.849] lc = [20:30:11.849] __func__ = "grouping_planner" [20:30:11.849] #4 0x0000560f24d994c9 in subquery_planner (glob=glob@entry=0x560f26108fd8, parse=parse@entry=0x560f26206c58, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [20:30:11.849] root = 0x560f2615aea8 [20:30:11.849] newWithCheckOptions = [20:30:11.849] newHaving = 0x0 [20:30:11.849] hasOuterJoins = [20:30:11.849] hasResultRTEs = false [20:30:11.849] final_rel = [20:30:11.849] l = 0x0 [20:30:11.849] #5 0x0000560f24d9a11e in standard_planner (parse=parse@entry=0x560f26206c58, query_string=query_string@entry=0x560f261072c0 "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 [20:30:11.849] result = [20:30:11.849] glob = 0x560f26108fd8 [20:30:11.849] tuple_fraction = 0 [20:30:11.849] root = [20:30:11.849] final_rel = [20:30:11.849] best_path = [20:30:11.849] top_plan = [20:30:11.849] lp = [20:30:11.849] lr = [20:30:11.849] #6 0x00007f715a09b59c in pgss_planner (parse=0x560f26206c58, query_string=0x560f261072c0 "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 [20:30:11.849] _save_exception_stack = 0x7ffe3dbc5690 [20:30:11.849] _save_context_stack = 0x0 [20:30:11.849] _local_sigjmp_buf = {{__jmpbuf = {94623064157272, -6107642360379815447, 0, 2048, 0, 94623063110336, -513554418234373655, -449881050097071639}, __mask_was_saved = 0, __saved_mask = {__val = {140124814323776, 384, 94623063088720, 140729934173328, 1, 140729934173231, 140729934288725, 137, 6, 140124816484840, 94623047435337, 1711225629, 596768, 472, 94623048388266, 140124816484840}}}} [20:30:11.849] _do_rethrow = false [20:30:11.849] duration = {ticks = } [20:30:11.849] bufusage = {shared_blks_hit = 94623063452987, shared_blks_read = 94623063452985, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 94557999988736, local_blks_read = 8, local_blks_dirtied = 266, local_blks_written = 94623048719475, temp_blks_read = 0, temp_blks_written = 206158430232, shared_blk_read_time = {ticks = 140729934173184}, shared_blk_write_time = {ticks = 140729934172992}, local_blk_read_time = {ticks = 60}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 3956476440}, temp_blk_write_time = {ticks = 94623063088720}} [20:30:11.849] walusage_start = {wal_records = 1341, wal_fpi = 2, wal_bytes = 169915} [20:30:11.849] start = {ticks = } [20:30:11.849] bufusage_start = {shared_blks_hit = 6861, shared_blks_read = 4, shared_blks_dirtied = 19, shared_blks_written = 19, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [20:30:11.849] walusage = {wal_records = 0, wal_fpi = 94623048469823, wal_bytes = 94623043275199} [20:30:11.849] result = 0x7ffe3dbc5400 [20:30:11.849] #7 0x0000560f24d9b1d8 in planner (parse=parse@entry=0x560f26206c58, query_string=query_string@entry=0x560f261072c0 "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 [20:30:11.849] result = [20:30:11.849] #8 0x0000560f2500b3f3 in pg_plan_query (querytree=querytree@entry=0x560f26206c58, query_string=query_string@entry=0x560f261072c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [20:30:11.849] plan = [20:30:11.849] #9 0x0000560f2500b760 in pg_plan_queries (querytrees=0x560f2615ae58, query_string=query_string@entry=0x560f261072c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [20:30:11.849] query = 0x560f26206c58 [20:30:11.849] stmt = [20:30:11.849] query_list__state = {l = , i = } [20:30:11.849] stmt_list = 0x0 [20:30:11.849] query_list = [20:30:11.849] #10 0x0000560f2500bb3a in exec_simple_query (query_string=query_string@entry=0x560f261072c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;") at ../src/backend/tcop/postgres.c:1193 [20:30:11.849] cmdtaglen = 6 [20:30:11.849] snapshot_set = true [20:30:11.849] per_parsetree_context = 0x0 [20:30:11.849] plantree_list = [20:30:11.849] parsetree = 0x560f26108f58 [20:30:11.849] commandTag = CMDTAG_SELECT [20:30:11.849] qc = {commandTag = CMDTAG_DROP_ROLE, nprocessed = 94623063110336} [20:30:11.849] querytree_list = [20:30:11.849] portal = [20:30:11.849] receiver = [20:30:11.849] format = 0 [20:30:11.849] cmdtagname = [20:30:11.849] parsetree_item__state = {l = , i = } [20:30:11.849] dest = DestRemote [20:30:11.849] oldcontext = 0x560f26132be0 [20:30:11.849] parsetree_list = 0x560f26108f88 [20:30:11.849] parsetree_item = 0x560f26108fa0 [20:30:11.849] save_log_statement_stats = false [20:30:11.849] was_logged = false [20:30:11.849] use_implicit_block = false [20:30:11.849] msec_str = "@X\274=\376\177\000\000.\361-%\017V\000\000pV\274=\376\177\000\000\205\000\000\000\000\000\000" [20:30:11.849] __func__ = "exec_simple_query" [20:30:11.849] #11 0x0000560f2500ea3a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [20:30:11.849] query_string = 0x560f261072c0 "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;" [20:30:11.849] firstchar = [20:30:11.849] input_message = {data = 0x560f261072c0 "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} [20:30:11.849] local_sigjmp_buf = {{__jmpbuf = {94623060759320, -6107641562602223127, 4, 140729934174272, 140729934174420, 1, -513554417982715415, -6107640293977699863}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140124861124068, 94623063084880, 15616, 15680, 94623048381615, 94623060759328, 94623063084880, 94623060753400, 140729934174272, 140729934174420, 94623048385683, 140729934174048}}}} [20:30:11.849] send_ready_for_query = false [20:30:11.849] idle_in_transaction_timeout_enabled = false [20:30:11.849] idle_session_timeout_enabled = false [20:30:11.849] __func__ = "PostgresMain" [20:30:11.849] #12 0x0000560f250051f1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [20:30:11.849] bsdata = [20:30:11.849] #13 0x0000560f24eafa5e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffe3dbc57ec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe3dbc5840) at ../src/backend/postmaster/launch_backend.c:265 [20:30:11.849] pid = [20:30:11.849] #14 0x0000560f24eb5bde in BackendStartup (client_sock=client_sock@entry=0x7ffe3dbc5840) at ../src/backend/postmaster/postmaster.c:3593 [20:30:11.849] bn = 0x560f26132e18 [20:30:11.849] pid = [20:30:11.849] startup_data = {canAcceptConnections = CAC_OK} [20:30:11.849] __func__ = "BackendStartup" [20:30:11.849] #15 0x0000560f24eb618c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [20:30:11.849] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\247\\q\177\000\000\001\000\000\000\000\000\000\000\244\343!^q\177\000\000-\000\000\000\000\000\000\000\020\016\213\\q\177\000\000 \331Z]q\177\000\000\bY\274=\376\177\000\000\004Y\274=\376\177\000\000\304X\274=\376\177\000\000P\375\000\000\001\000\000\000\000\000\000\000\017V\000\000\020\016\213\\q\177\000\000\340/\212\\q\177\000\000\352o\247\\q\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [20:30:11.849] i = 0 [20:30:11.849] now = [20:30:11.849] last_lockfile_recheck_time = 1711225629 [20:30:11.849] last_touch_time = 1711225629 [20:30:11.849] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1035753920, events = 32766, fd = 46, user_data = 0x7ffe3dbc5980}, {pos = 1035753872, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 1566234504, user_data = 0x7f715ca76fea}, {pos = 1035754088, events = 32766, fd = 1035753920, user_data = 0x7ffe3dbc59d0}, {pos = 1579281633, events = 32625, fd = 18, user_data = 0x7f715a274618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1566233632, events = 32625, fd = -1, user_data = 0x7f715a274618}, {pos = 1566233632, events = 32625, fd = 1024, user_data = 0x7f715d5ad788}, {pos = 0, events = 0, fd = 8, user_data = 0x7ffe3dbc59d0}, {pos = -1, events = 0, fd = 1553341626, user_data = 0x7f715c8a3418}, {pos = 1566234912, events = 32625, fd = 638801032, user_data = 0x560f26131cb8}, {pos = 638786976, events = 22031, fd = 638801064, user_data = 0x560f261353e1}, {pos = 1579300387, events = 32625, fd = 1, user_data = 0x7f715ca900f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = 638614992, user_data = 0x7f715e223623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x560f26131da0}, {pos = 1552561176, events = 32625, fd = 1035755024, user_data = 0x7f715e22a68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffe3dbc5e30}, {pos = 636203232, events = 22031, fd = 2, user_data = 0x560f25ebb0e0 }, {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 = 638781880, 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 = 761361253, events = 1265396067, fd = 10, user_data = 0x0}, {pos = -256, 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 = 1553079291, user_data = 0x400}, {pos = 638603248, events = 22031, fd = 1554424960, user_data = 0x126104ff0}, {pos = 784, events = 0, fd = 626187244, user_data = 0x560f26131990}, {pos = -384911104, events = 1853786788, fd = 4, user_data = 0x560f26130980}, {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 = 0x560f26131990}, {pos = 1, events = 0, fd = 638786136, user_data = 0x400}, {pos = 0, events = 0, fd = 623963731, user_data = 0x560f25ec92d0 }, {pos = 623897407, events = 22031, fd = 638785936, user_data = 0x560f261071c0}, {pos = 638785936, events = 22031, fd = 15, user_data = 0x4a}, {pos = 623965499, events = 22031, fd = 638785936, user_data = 0x560f2530f67d }, {pos = 638603248, events = 22031, fd = 1553079291, user_data = 0x0}, {pos = 617418121, events = 22031, fd = 638777328, user_data = 0x7f715c91e1aa}, {pos = 1035755208, events = 1, fd = 0, user_data = 0x7f715c91c8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 37389, user_data = 0x7f715c966b05 }, {pos = 0, events = 0, fd = -384911104, user_data = 0x0}, {pos = 619378564, events = 22031, fd = 4194304, user_data = 0x560f252fe9d3 }, {pos = 638777328, events = 22031, fd = 638611904, user_data = 0x560f2612f7f0}, {pos = 1, events = 0, fd = 0, user_data = 0x560f2530f53b }, {pos = 638777328, events = 22031, fd = 623965821, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x560f24cd095c }, {pos = 0, events = 0, fd = 617441074, user_data = 0xb}, {pos = 619399984, events = 22031, fd = 0, user_data = 0x0}} [20:30:11.849] nevents = 1 [20:30:11.849] __func__ = "ServerLoop" [20:30:11.849] #16 0x0000560f24eb7bae in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x560f26100ea0) at ../src/backend/postmaster/postmaster.c:1372 [20:30:11.849] opt = [20:30:11.849] status = [20:30:11.849] userDoption = [20:30:11.849] listen_addr_saved = false [20:30:11.849] output_config_variable = [20:30:11.849] __func__ = "PostmasterMain" [20:30:11.849] #17 0x0000560f24ce178c in main (argc=8, argv=0x560f26100ea0) at ../src/backend/main/main.c:197 [20:30:11.849] do_check_root = [20:30:11.867] -e [20:30:11.867] [20:30:11.867] [20:30:12.420] dumping /tmp/cores/postgres-11-30371.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [20:30:12.730] [New LWP 30371] [20:30:13.876] [Thread debugging using libthread_db enabled] [20:30:13.876] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:30:15.305] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [20:30:15.305] Program terminated with signal SIGSEGV, Segmentation fault. [20:30:15.305] #0 0x000055d7990cf01d in equal (a=0xffffffff9a8ad180, b=b@entry=0x55d79a8de688) at ../src/backend/nodes/equalfuncs.c:239 [20:30:15.305] 239 if (nodeTag(a) != nodeTag(b)) [20:30:15.472] [20:30:15.472] Thread 1 (Thread 0x7f92206b7a40 (LWP 30371)): [20:30:15.472] #0 0x000055d7990cf01d in equal (a=0xffffffff9a8ad180, b=b@entry=0x55d79a8de688) at ../src/backend/nodes/equalfuncs.c:239 [20:30:15.472] retval = [20:30:15.472] __func__ = "equal" [20:30:15.472] #1 0x000055d798a06ab7 in list_member (list=0x55d79a8ad1f0, datum=datum@entry=0x55d79a8de688) at ../src/backend/nodes/list.c:670 [20:30:15.472] cell__state = {l = , i = } [20:30:15.472] cell = [20:30:15.472] #2 0x000055d798b2ae91 in add_new_column_to_pathtarget (target=target@entry=0x55d79a8ad110, expr=0x55d79a8de688) at ../src/backend/optimizer/util/tlist.c:743 [20:30:15.472] No locals. [20:30:15.472] #3 0x000055d798b2af2c in add_new_columns_to_pathtarget (target=target@entry=0x55d79a8ad110, exprs=exprs@entry=0x55d79a8ad2a8) at ../src/backend/optimizer/util/tlist.c:760 [20:30:15.472] expr = [20:30:15.472] lc__state = {l = , i = } [20:30:15.472] lc = [20:30:15.472] #4 0x000055d798aa324e in make_group_input_target (root=root@entry=0x55d79a8ddf98, final_target=final_target@entry=0x55d79a8ad028) at ../src/backend/optimizer/plan/planner.c:5472 [20:30:15.472] parse = 0x55d79a78d788 [20:30:15.472] input_target = 0x55d79a8ad110 [20:30:15.472] non_group_cols = 0x55d79a8ad258 [20:30:15.472] non_group_vars = 0x55d79a8ad2a8 [20:30:15.472] i = 2 [20:30:15.472] lc = 0x0 [20:30:15.472] #5 0x000055d798ab6610 in grouping_planner (root=root@entry=0x55d79a8ddf98, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [20:30:15.472] sort_input_targets = 0x55d79a8de4b8 [20:30:15.472] sort_input_target_parallel_safe = true [20:30:15.472] grouping_target = 0x55d79a8ad028 [20:30:15.472] scanjoin_target = [20:30:15.472] activeWindows = 0x0 [20:30:15.472] qp_extra = {activeWindows = 0x0, gset_data = 0x55d79a8e1768} [20:30:15.472] sort_input_targets_contain_srfs = 0x55d798aec990 [20:30:15.472] have_grouping = [20:30:15.472] wflists = 0x0 [20:30:15.472] gset_data = 0x55d79a8e1768 [20:30:15.472] sort_input_target = 0x55d79a8ad028 [20:30:15.472] grouping_targets = 0x0 [20:30:15.472] grouping_target_parallel_safe = true [20:30:15.472] scanjoin_targets = 0x0 [20:30:15.472] scanjoin_target_parallel_safe = [20:30:15.472] grouping_targets_contain_srfs = 0x55d798a147ab [20:30:15.472] scanjoin_targets_contain_srfs = 0x0 [20:30:15.472] scanjoin_target_same_exprs = [20:30:15.472] parse = 0x55d79a78d788 [20:30:15.472] offset_est = 0 [20:30:15.472] count_est = 0 [20:30:15.472] limit_tuples = -1 [20:30:15.472] have_postponed_srfs = false [20:30:15.472] final_target = 0x55d79a8ad028 [20:30:15.472] final_targets = 0x55d79a86ef68 [20:30:15.472] final_targets_contain_srfs = 0x55d798aec9c5 [20:30:15.472] final_target_parallel_safe = true [20:30:15.472] current_rel = 0x55d79a8ddd48 [20:30:15.472] final_rel = [20:30:15.472] extra = {limit_needed = 152, limit_tuples = 4.9406564584124654e-324, count_est = 94384499318680, offset_est = 1} [20:30:15.472] lc = [20:30:15.472] __func__ = "grouping_planner" [20:30:15.472] #6 0x000055d798ab94c9 in subquery_planner (glob=glob@entry=0x55d79a8ddc38, parse=parse@entry=0x55d79a78d788, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [20:30:15.472] root = 0x55d79a8ddf98 [20:30:15.472] newWithCheckOptions = [20:30:15.472] newHaving = 0x0 [20:30:15.472] hasOuterJoins = [20:30:15.472] hasResultRTEs = false [20:30:15.472] final_rel = [20:30:15.472] l = 0x0 [20:30:15.472] #7 0x000055d798aba11e in standard_planner (parse=0x55d79a78d788, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [20:30:15.472] result = [20:30:15.472] glob = 0x55d79a8ddc38 [20:30:15.472] tuple_fraction = 0 [20:30:15.472] root = [20:30:15.472] final_rel = [20:30:15.472] best_path = [20:30:15.472] top_plan = [20:30:15.472] lp = [20:30:15.472] lr = [20:30:15.472] #8 0x000055d798abb1e2 in planner (parse=parse@entry=0x55d79a78d788, query_string=query_string@entry=0x55d79a78c260 "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 [20:30:15.472] result = [20:30:15.472] #9 0x000055d798d2b3f3 in pg_plan_query (querytree=querytree@entry=0x55d79a78d788, query_string=query_string@entry=0x55d79a78c260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [20:30:15.472] plan = [20:30:15.472] #10 0x000055d7988167b3 in standard_ExplainOneQuery (query=0x55d79a78d788, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55d79a7b7318, queryString=0x55d79a78c260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:440 [20:30:15.472] plan = [20:30:15.472] planstart = {ticks = } [20:30:15.472] planduration = {ticks = 94384497940360} [20:30:15.472] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94384462295896, shared_blks_dirtied = 0, shared_blks_written = 70368744218078, local_blks_hit = 94384497940632, local_blks_read = 94384463661789, local_blks_dirtied = 140733599706574, local_blks_written = 94384469518984, temp_blks_read = 1, temp_blks_written = 140265432755504, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94381906329600}, local_blk_read_time = {ticks = 94384498862552}, local_blk_write_time = {ticks = 94384473443647}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94384466974898}} [20:30:15.472] bufusage = {shared_blks_hit = 94384499317656, shared_blks_read = 4294967297, shared_blks_dirtied = 0, shared_blks_written = 10, local_blks_hit = 0, local_blks_read = 94384470037973, local_blks_dirtied = 173576808316928, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 40414, shared_blk_read_time = {ticks = 140265432755504}, shared_blk_write_time = {ticks = 94384497941448}, local_blk_read_time = {ticks = 94384497940360}, local_blk_write_time = {ticks = 94384472959717}, temp_blk_read_time = {ticks = 140265432755504}, temp_blk_write_time = {ticks = 94384472959736}} [20:30:15.472] mem_counters = {nblocks = 140733599706576, freechunks = 94384497940360, totalspace = 140733599706573, freespace = 94384469603391} [20:30:15.472] planner_ctx = 0x0 [20:30:15.472] saved_ctx = 0x0 [20:30:15.472] #11 0x000055d798816a4b in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55d79a7b7318, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:396 [20:30:15.472] No locals. [20:30:15.472] #12 0x000055d798818042 in ExplainQuery (pstate=pstate@entry=0x55d79a7b7208, stmt=stmt@entry=0x55d79a78d5c8, params=params@entry=0x0, dest=dest@entry=0x55d79a7b7178) at ../src/include/nodes/nodes.h:172 [20:30:15.472] l__state = {l = , i = } [20:30:15.472] l = 0x55d79a8ddc00 [20:30:15.472] es = 0x55d79a7b7318 [20:30:15.472] tstate = [20:30:15.472] jstate = [20:30:15.472] query = [20:30:15.472] rewritten = 0x55d79a8ddbe8 [20:30:15.472] lc = 0x0 [20:30:15.472] timing_set = false [20:30:15.472] summary_set = false [20:30:15.472] __func__ = "ExplainQuery" [20:30:15.472] #13 0x000055d798d35e01 in standard_ProcessUtility (pstmt=0x55d79a78d678, queryString=0x55d79a78c260 "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=0x55d79a7b7178, qc=0x7fff1837efc0) at ../src/backend/tcop/utility.c:863 [20:30:15.472] parsetree = 0x55d79a78d5c8 [20:30:15.472] isTopLevel = true [20:30:15.472] isAtomicContext = false [20:30:15.472] pstate = 0x55d79a7b7208 [20:30:15.472] readonly_flags = [20:30:15.472] __func__ = "standard_ProcessUtility" [20:30:15.472] #14 0x000055d798d3652a in ProcessUtility (pstmt=pstmt@entry=0x55d79a78d678, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55d79a7b7178, qc=0x7fff1837efc0) at ../src/backend/tcop/utility.c:523 [20:30:15.472] No locals. [20:30:15.472] #15 0x000055d798d31c88 in PortalRunUtility (portal=portal@entry=0x55d79a80cf90, pstmt=0x55d79a78d678, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55d79a7b7178, qc=qc@entry=0x7fff1837efc0) at ../src/backend/tcop/pquery.c:1158 [20:30:15.472] No locals. [20:30:15.472] #16 0x000055d798d3266b in FillPortalStore (portal=portal@entry=0x55d79a80cf90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [20:30:15.472] treceiver = 0x55d79a7b7178 [20:30:15.472] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:30:15.472] __func__ = "FillPortalStore" [20:30:15.472] #17 0x000055d798d32ced in PortalRun (portal=portal@entry=0x55d79a80cf90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d79a86f328, altdest=altdest@entry=0x55d79a86f328, qc=0x7fff1837f1a0) at ../src/backend/tcop/pquery.c:763 [20:30:15.472] _save_exception_stack = 0x7fff1837f250 [20:30:15.472] _save_context_stack = 0x0 [20:30:15.472] _local_sigjmp_buf = {{__jmpbuf = {1, 6142067806571508159, 94384498864936, 94384497940032, 94384498462608, 94384497939960, -6142010151467568705, -102963188317113921}, __mask_was_saved = 0, __saved_mask = {__val = {94384498474168, 94384476194974, 94384498470816, 94384476194974, 1, 140733599707439, 94384497940008, 94384497939960, 94384473183381, 94384475781417, 94384498462608, 94384476194974, 1, 1, 94384473444049, 153}}}} [20:30:15.472] _do_rethrow = [20:30:15.472] result = [20:30:15.472] nprocessed = [20:30:15.472] saveTopTransactionResourceOwner = 0x55d79a7ca5c0 [20:30:15.472] saveTopTransactionContext = 0x55d79a876520 [20:30:15.472] saveActivePortal = 0x0 [20:30:15.472] saveResourceOwner = 0x55d79a7ca5c0 [20:30:15.472] savePortalContext = 0x0 [20:30:15.472] saveMemoryContext = 0x55d79a876520 [20:30:15.472] __func__ = "PortalRun" [20:30:15.472] #18 0x000055d798d2bc82 in exec_simple_query (query_string=query_string@entry=0x55d79a78c260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1274 [20:30:15.472] cmdtaglen = 7 [20:30:15.472] snapshot_set = [20:30:15.472] per_parsetree_context = 0x0 [20:30:15.472] plantree_list = 0x55d79a86f2d8 [20:30:15.472] parsetree = 0x55d79a78d5f8 [20:30:15.472] commandTag = [20:30:15.472] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [20:30:15.472] querytree_list = [20:30:15.472] portal = 0x55d79a80cf90 [20:30:15.472] receiver = 0x55d79a86f328 [20:30:15.472] format = 0 [20:30:15.472] cmdtagname = [20:30:15.472] parsetree_item__state = {l = , i = } [20:30:15.472] dest = DestRemote [20:30:15.472] oldcontext = 0x55d79a876520 [20:30:15.472] parsetree_list = 0x55d79a78d628 [20:30:15.472] parsetree_item = 0x55d79a78d640 [20:30:15.472] save_log_statement_stats = false [20:30:15.472] was_logged = false [20:30:15.472] use_implicit_block = false [20:30:15.472] msec_str = "\000\364\067\030\377\177\000\000.\361\377\230\327U\000\000\060\362\067\030\377\177\000\000U\000\000\000\000\000\000" [20:30:15.472] __func__ = "exec_simple_query" [20:30:15.472] #19 0x000055d798d2ea3a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [20:30:15.472] query_string = 0x55d79a78c260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [20:30:15.472] firstchar = [20:30:15.472] input_message = {data = 0x55d79a78c260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [20:30:15.472] local_sigjmp_buf = {{__jmpbuf = {94384485733144, -102965562160795201, 4, 140733599708160, 140733599708308, 1, -6142010151362711105, -102963195094191681}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140265626459620, 94384497909488, 15616, 15680, 94384473355439, 94384485733152, 94384497909488, 94384485727224, 140733599708160, 140733599708308, 94384473359507, 140733599707936}}}} [20:30:15.472] send_ready_for_query = false [20:30:15.472] idle_in_transaction_timeout_enabled = false [20:30:15.472] idle_session_timeout_enabled = false [20:30:15.472] __func__ = "PostgresMain" [20:30:15.472] #20 0x000055d798d251f1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [20:30:15.472] bsdata = [20:30:15.472] #21 0x000055d798bcfa5e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff1837f3ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff1837f400) at ../src/backend/postmaster/launch_backend.c:265 [20:30:15.472] pid = [20:30:15.472] #22 0x000055d798bd5bde in BackendStartup (client_sock=client_sock@entry=0x7fff1837f400) at ../src/backend/postmaster/postmaster.c:3593 [20:30:15.472] bn = 0x55d79a7b4ce8 [20:30:15.472] pid = [20:30:15.472] startup_data = {canAcceptConnections = CAC_OK} [20:30:15.472] __func__ = "BackendStartup" [20:30:15.472] #23 0x000055d798bd618c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [20:30:15.472] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\353\"\222\177\000\000\001\000\000\000\000\000\000\000\244sf$\222\177\000\000-\000\000\000\000\000\000\000\020\236\317\"\222\177\000\000 i\237#\222\177\000\000\310\364\067\030\377\177\000\000\304\364\067\030\377\177\000\000\204\364\067\030\377\177\000\000@\016\000\000\001\000\000\000\000\000\000\000\327U\000\000\020\236\317\"\222\177\000\000\340\277\316\"\222\177\000\000\352\377\353\"\222\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [20:30:15.472] i = 0 [20:30:15.472] now = [20:30:15.472] last_lockfile_recheck_time = 1711225583 [20:30:15.472] last_touch_time = 1711225583 [20:30:15.472] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 406320512, events = 32767, fd = 45, user_data = 0x7fff1837f540}, {pos = 406320464, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 597649288, user_data = 0x7f9222ebffea}, {pos = 406320680, events = 32767, fd = 406320512, user_data = 0x7fff1837f590}, {pos = 610696417, events = 32658, fd = 18, user_data = 0x7f92206bd618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 597648416, events = 32658, fd = -1, user_data = 0x7f92206bd618}, {pos = 597648416, events = 32658, fd = 1024, user_data = 0x7f92239f6788}, {pos = 0, events = 0, fd = 8, user_data = 0x7fff1837f590}, {pos = -1, events = 0, fd = 584756410, user_data = 0x7f9222cec418}, {pos = 597649696, events = 32658, fd = -1703175160, user_data = 0x55d79a7b7708}, {pos = -1703208464, events = 21975, fd = -1703175128, user_data = 0x55d79a7b9b61}, {pos = 610715171, events = 32658, fd = 1, user_data = 0x7f9222ed90f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -1703354320, user_data = 0x7f922466c623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x55d79a7b19f0}, {pos = 583975960, events = 32658, fd = 406321616, user_data = 0x7f922467368a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7fff1837f9f0}, {pos = -1715621664, events = 21975, fd = 2, user_data = 0x55d799bdb0e0 }, {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 = -1703181416, 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 = 0xa626c754970582d}, {pos = 762540901, events = 1967747160, fd = 168452716, user_data = 0x32313137310a6174}, {pos = 943011122, events = 808716851, 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 = 584494075, user_data = 0x400}, {pos = -1703370864, events = 21975, fd = 585839744, user_data = 0x19a789f90}, {pos = 784, events = 0, fd = -1725637652, user_data = 0x55d79a7b73e0}, {pos = 1710577664, events = 3838128432, fd = 4, user_data = 0x55d79a7b8360}, {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 = 0x55d79a7b73e0}, {pos = 1, events = 0, fd = -1703185240, user_data = 0x400}, {pos = 0, events = 0, fd = -1727861165, user_data = 0x55d799be92d0 }, {pos = -1727927489, events = 21975, fd = -1703185440, user_data = 0x55d79a78c160}, {pos = -1703185440, events = 21975, fd = 15, user_data = 0x4a}, {pos = -1727859397, events = 21975, fd = -1703185440, user_data = 0x55d79902f67d }, {pos = -1703370864, events = 21975, fd = 584494075, user_data = 0x0}, {pos = -1734406775, events = 21975, fd = -1703196832, user_data = 0x7f9222d671aa}, {pos = 406321800, events = 1, fd = 0, user_data = 0x7f9222d658f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 23941, user_data = 0x7f9222dafb05 }, {pos = 0, events = 0, fd = 1710577664, user_data = 0x0}, {pos = -1732446332, events = 21975, fd = 4194304, user_data = 0x55d79901e9d3 }, {pos = -1703196832, events = 21975, fd = -1703362208, user_data = 0x55d79a7b4760}, {pos = 1, events = 0, fd = 0, user_data = 0x55d79902f53b }, {pos = -1703196832, events = 21975, fd = -1727859075, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55d7989f095c }, {pos = 0, events = 0, fd = -1734383822, user_data = 0xb}, {pos = -1732424912, events = 21975, fd = 0, user_data = 0x0}} [20:30:15.472] nevents = 1 [20:30:15.472] __func__ = "ServerLoop" [20:30:15.472] #24 0x000055d798bd7bae in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55d79a785e50) at ../src/backend/postmaster/postmaster.c:1372 [20:30:15.472] opt = [20:30:15.472] status = [20:30:15.472] userDoption = [20:30:15.472] listen_addr_saved = false [20:30:15.472] output_config_variable = [20:30:15.472] __func__ = "PostmasterMain" [20:30:15.472] #25 0x000055d798a0178c in main (argc=8, argv=0x55d79a785e50) at ../src/backend/main/main.c:197 [20:30:15.472] do_check_root = [20:30:15.489] -e [20:30:15.489] [20:30:15.489] [20:30:16.032] dumping /tmp/cores/postgres-11-28571.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [20:30:16.335] [New LWP 28571] [20:30:17.499] [Thread debugging using libthread_db enabled] [20:30:17.499] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [20:30:18.941] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [20:30:18.941] Program terminated with signal SIGSEGV, Segmentation fault. [20:30:18.941] #0 0x0000558a49a7c01d in equal (a=0x4b663bc8, b=b@entry=0x558a4b6609c8) at ../src/backend/nodes/equalfuncs.c:239 [20:30:18.941] 239 if (nodeTag(a) != nodeTag(b)) [20:30:19.054] [20:30:19.054] Thread 1 (Thread 0x7f230fd9ea40 (LWP 28571)): [20:30:19.054] #0 0x0000558a49a7c01d in equal (a=0x4b663bc8, b=b@entry=0x558a4b6609c8) at ../src/backend/nodes/equalfuncs.c:239 [20:30:19.054] retval = [20:30:19.054] __func__ = "equal" [20:30:19.054] #1 0x0000558a493b3ab7 in list_member (list=0x558a4b663c38, datum=datum@entry=0x558a4b6609c8) at ../src/backend/nodes/list.c:670 [20:30:19.054] cell__state = {l = , i = } [20:30:19.054] cell = [20:30:19.054] #2 0x0000558a494d7e91 in add_new_column_to_pathtarget (target=target@entry=0x558a4b663b58, expr=0x558a4b6609c8) at ../src/backend/optimizer/util/tlist.c:743 [20:30:19.054] No locals. [20:30:19.054] #3 0x0000558a494d7f2c in add_new_columns_to_pathtarget (target=target@entry=0x558a4b663b58, exprs=exprs@entry=0x558a4b663d68) at ../src/backend/optimizer/util/tlist.c:760 [20:30:19.054] expr = [20:30:19.054] lc__state = {l = , i = } [20:30:19.054] lc = [20:30:19.054] #4 0x0000558a4945024e in make_group_input_target (root=root@entry=0x558a4b658bd8, final_target=final_target@entry=0x558a4b6639f8) at ../src/backend/optimizer/plan/planner.c:5472 [20:30:19.054] parse = 0x558a4b536d08 [20:30:19.054] input_target = 0x558a4b663b58 [20:30:19.054] non_group_cols = 0x558a4b663d18 [20:30:19.054] non_group_vars = 0x558a4b663d68 [20:30:19.054] i = 6 [20:30:19.054] lc = 0x0 [20:30:19.054] #5 0x0000558a49463610 in grouping_planner (root=root@entry=0x558a4b658bd8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [20:30:19.054] sort_input_targets = 0x558a4b660838 [20:30:19.054] sort_input_target_parallel_safe = true [20:30:19.054] grouping_target = 0x558a4b6639f8 [20:30:19.054] scanjoin_target = [20:30:19.054] activeWindows = 0x0 [20:30:19.054] qp_extra = {activeWindows = 0x0, gset_data = 0x558a4b661e58} [20:30:19.054] sort_input_targets_contain_srfs = 0x558a49499990 [20:30:19.054] have_grouping = [20:30:19.054] wflists = 0x0 [20:30:19.054] gset_data = 0x558a4b661e58 [20:30:19.054] sort_input_target = 0x558a4b6639f8 [20:30:19.054] grouping_targets = 0x0 [20:30:19.054] grouping_target_parallel_safe = true [20:30:19.054] scanjoin_targets = 0x0 [20:30:19.054] scanjoin_target_parallel_safe = [20:30:19.054] grouping_targets_contain_srfs = 0x558a493c17ab [20:30:19.054] scanjoin_targets_contain_srfs = 0x558a4b65d0a8 [20:30:19.054] scanjoin_target_same_exprs = [20:30:19.054] parse = 0x558a4b536d08 [20:30:19.054] offset_est = 0 [20:30:19.054] count_est = 0 [20:30:19.054] limit_tuples = -1 [20:30:19.054] have_postponed_srfs = false [20:30:19.054] final_target = 0x558a4b6639f8 [20:30:19.054] final_targets = 0x0 [20:30:19.054] final_targets_contain_srfs = 0x558a4949fc87 [20:30:19.054] final_target_parallel_safe = true [20:30:19.054] current_rel = 0x558a4b658fe8 [20:30:19.054] final_rel = [20:30:19.054] extra = {limit_needed = 216, limit_tuples = 1.9762625833649862e-323, count_est = 94052458793944, offset_est = 0} [20:30:19.054] lc = [20:30:19.054] __func__ = "grouping_planner" [20:30:19.054] #6 0x0000558a494664c9 in subquery_planner (glob=glob@entry=0x558a4b536f78, parse=parse@entry=0x558a4b536d08, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [20:30:19.054] root = 0x558a4b658bd8 [20:30:19.054] newWithCheckOptions = [20:30:19.054] newHaving = 0x0 [20:30:19.054] hasOuterJoins = [20:30:19.054] hasResultRTEs = false [20:30:19.054] final_rel = [20:30:19.054] l = 0x0 [20:30:19.054] #7 0x0000558a4946711e in standard_planner (parse=0x558a4b536d08, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [20:30:19.054] result = [20:30:19.054] glob = 0x558a4b536f78 [20:30:19.054] tuple_fraction = 0 [20:30:19.054] root = [20:30:19.054] final_rel = [20:30:19.054] best_path = [20:30:19.054] top_plan = [20:30:19.054] lp = [20:30:19.054] lr = [20:30:19.054] #8 0x0000558a494681e2 in planner (parse=parse@entry=0x558a4b536d08, query_string=query_string@entry=0x558a4b535250 "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 [20:30:19.054] result = [20:30:19.054] #9 0x0000558a496d83f3 in pg_plan_query (querytree=querytree@entry=0x558a4b536d08, query_string=query_string@entry=0x558a4b535250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:904 [20:30:19.054] plan = [20:30:19.054] #10 0x0000558a496d8760 in pg_plan_queries (querytrees=0x558a4b65d448, query_string=query_string@entry=0x558a4b535250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:996 [20:30:19.054] query = 0x558a4b536d08 [20:30:19.054] stmt = [20:30:19.054] query_list__state = {l = , i = } [20:30:19.054] stmt_list = 0x0 [20:30:19.054] query_list = [20:30:19.054] #11 0x0000558a496d8b3a in exec_simple_query (query_string=query_string@entry=0x558a4b535250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1193 [20:30:19.054] cmdtaglen = 6 [20:30:19.054] snapshot_set = true [20:30:19.054] per_parsetree_context = 0x0 [20:30:19.054] plantree_list = [20:30:19.054] parsetree = 0x558a4b536b78 [20:30:19.054] commandTag = CMDTAG_SELECT [20:30:19.054] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94052457599568} [20:30:19.054] querytree_list = [20:30:19.054] portal = [20:30:19.054] receiver = [20:30:19.054] format = 0 [20:30:19.054] cmdtagname = [20:30:19.054] parsetree_item__state = {l = , i = } [20:30:19.054] dest = DestRemote [20:30:19.054] oldcontext = 0x558a4b60f350 [20:30:19.054] parsetree_list = 0x558a4b536ba8 [20:30:19.054] parsetree_item = 0x558a4b536bc0 [20:30:19.054] save_log_statement_stats = false [20:30:19.054] was_logged = true [20:30:19.054] use_implicit_block = false [20:30:19.054] msec_str = "\000\355,\270\374\177\000\000.\301\232I\212U\000\000\060\353,\270\374\177\000\000[\000\000\000\000\000\000" [20:30:19.054] __func__ = "exec_simple_query" [20:30:19.054] #12 0x0000558a496dba3a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [20:30:19.054] query_string = 0x558a4b535250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [20:30:19.054] firstchar = [20:30:19.054] input_message = {data = 0x558a4b535250 "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} [20:30:19.054] local_sigjmp_buf = {{__jmpbuf = {94052441219864, -6530631976319217714, 4, 140723398438144, 140723398438292, 1, -1030360891548266546, -6530625485014462514}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 139788607114724, 94052457574144, 14336, 14400, 94052428842159, 94052441219872, 94052457574144, 94052441213944, 140723398438144, 140723398438292, 94052428846227, 140723398437920}}}} [20:30:19.054] send_ready_for_query = false [20:30:19.054] idle_in_transaction_timeout_enabled = false [20:30:19.054] idle_session_timeout_enabled = false [20:30:19.054] __func__ = "PostgresMain" [20:30:19.054] #13 0x0000558a496d21f1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [20:30:19.054] bsdata = [20:30:19.054] #14 0x0000558a4957ca5e in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffcb82cecac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcb82ced00) at ../src/backend/postmaster/launch_backend.c:265 [20:30:19.054] pid = [20:30:19.054] #15 0x0000558a49582bde in BackendStartup (client_sock=client_sock@entry=0x7ffcb82ced00) at ../src/backend/postmaster/postmaster.c:3593 [20:30:19.054] bn = 0x558a4b56b578 [20:30:19.054] pid = [20:30:19.054] startup_data = {canAcceptConnections = CAC_OK} [20:30:19.054] __func__ = "BackendStartup" [20:30:19.054] #16 0x0000558a4958318c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [20:30:19.054] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "Z\022#\177\000\000\001\000\000\000\000\000\000\000\244\343\324\023#\177\000\000-\000\000\000\000\000\000\000\020\016>\022#\177\000\000 \331\r\023#\177\000\000\310\355,\270\374\177\000\000\304\355,\270\374\177\000\000\204\355,\270\374\177\000\000@~\000\000\001\000\000\000\000\000\000\000\212U\000\000\020\016>\022#\177\000\000\340/=\022#\177\000\000\352oZ\022#\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [20:30:19.054] i = 0 [20:30:19.054] now = [20:30:19.054] last_lockfile_recheck_time = 1711225585 [20:30:19.054] last_touch_time = 1711225585 [20:30:19.054] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1205014912, events = 32764, fd = 45, user_data = 0x7ffcb82cee40}, {pos = -1205014960, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 319674248, user_data = 0x7f23125a6fea}, {pos = -1205014744, events = 32764, fd = -1205014912, user_data = 0x7ffcb82cee90}, {pos = 332721377, events = 32547, fd = 18, user_data = 0x7f230fda4618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 319673376, events = 32547, fd = -1, user_data = 0x7f230fda4618}, {pos = 319673376, events = 32547, fd = 1024, user_data = 0x7f23130dd788}, {pos = 0, events = 0, fd = 7, user_data = 0x7ffcb82cee90}, {pos = -1, events = 0, fd = 306781370, user_data = 0x7f23123d3418}, {pos = 319674656, events = 32547, fd = 1263920120, user_data = 0x558a4b55e288}, {pos = 1263927440, events = 21898, fd = 1263920152, user_data = 0x558a4b55f371}, {pos = 332740131, events = 32547, fd = 1, user_data = 0x7f23125c00f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = 1263759344, user_data = 0x7f2313d53623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x558a4b560090}, {pos = 306000920, events = 32547, fd = -1205013808, user_data = 0x7f2313d5a68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffcb82cf2f0}, {pos = 1247314144, events = 21898, fd = 2, user_data = 0x558a4a5880e0 }, {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 = 1263920040, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x3934333736202020}, {pos = 538976304, events = 538976288, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = 306519342, user_data = 0x400}, {pos = 1263742880, events = 21898, fd = 307864704, user_data = 0x14b532fa0}, {pos = 784, events = 0, fd = 1237298156, user_data = 0x558a4b55df60}, {pos = 1399542272, events = 263562998, fd = 4, user_data = 0x558a4b55e370}, {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 = 0x558a4b55df60}, {pos = 1, events = 0, fd = 1263919144, user_data = 0x400}, {pos = 0, events = 0, fd = 1235074643, user_data = 0x558a4a5962d0 }, {pos = 1235008319, events = 21898, fd = 1263918944, user_data = 0x558a4b535150}, {pos = 1263918944, events = 21898, fd = 15, user_data = 0x4a}, {pos = 1235076411, events = 21898, fd = 1263918944, user_data = 0x558a499dc67d }, {pos = 1263742880, events = 21898, fd = 306519342, user_data = 0x0}, {pos = 1228529033, events = 21898, fd = 1263913792, user_data = 0x7f231244e1aa}, {pos = -1205013624, events = 1, fd = 0, user_data = 0x7f231244c8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 24627, user_data = 0x7f2312496b05 }, {pos = 0, events = 0, fd = 1399542272, user_data = 0x0}, {pos = 1230489476, events = 21898, fd = 4194304, user_data = 0x558a499cb9d3 }, {pos = 1263913792, events = 21898, fd = 1263751504, user_data = 0x558a4b55cb40}, {pos = 1, events = 0, fd = 0, user_data = 0x558a499dc53b }, {pos = 1263913792, events = 21898, fd = 1235076733, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x558a4939d95c }, {pos = 0, events = 0, fd = 1228551986, user_data = 0xb}, {pos = 1230510896, events = 21898, fd = 0, user_data = 0x0}} [20:30:19.054] nevents = 1 [20:30:19.054] __func__ = "ServerLoop" [20:30:19.054] #17 0x0000558a49584bae in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x558a4b52ee10) at ../src/backend/postmaster/postmaster.c:1372 [20:30:19.054] opt = [20:30:19.054] status = [20:30:19.054] userDoption = [20:30:19.054] listen_addr_saved = false [20:30:19.054] output_config_variable = [20:30:19.054] __func__ = "PostmasterMain" [20:30:19.054] #18 0x0000558a493ae78c in main (argc=4, argv=0x558a4b52ee10) at ../src/backend/main/main.c:197 [20:30:19.054] do_check_root =