[22:58:38.421] src/tools/ci/cores_backtrace.sh linux /tmp/cores [22:58:39.149] dumping /tmp/cores/postgres-11-28343.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:58:40.809] [New LWP 28343] [22:58:40.809] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [22:58:41.568] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [22:58:42.329] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [22:58:43.542] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [22:58:45.903] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [22:58:45.903] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [22:58:47.780] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [22:58:49.001] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [22:58:50.570] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [22:58:51.629] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [22:58:52.391] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [22:58:53.611] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [22:58:55.218] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [22:58:56.624] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [22:58:57.534] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [22:58:59.064] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [22:59:00.451] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [22:59:00.922] [Thread debugging using libthread_db enabled] [22:59:00.922] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:59:01.985] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [22:59:03.374] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [22:59:04.433] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [22:59:05.049] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [22:59:05.811] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [22:59:08.081] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [22:59:09.013] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [22:59:09.776] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [22:59:10.686] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [22:59:11.601] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [22:59:13.185] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [22:59:14.242] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [22:59:15.009] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [22:59:16.391] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [22:59:17.005] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [22:59:18.531] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [22:59:19.292] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [22:59:20.515] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [22:59:21.282] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [22:59:22.341] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [22:59:23.259] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [22:59:24.474] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [22:59:25.087] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [22:59:26.000] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [22:59:26.763] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [22:59:27.255] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [22:59:27.255] Program terminated with signal SIGSEGV, Segmentation fault. [22:59:27.255] #0 0x000055ebd3347926 in equal (a=0xffffffffd47e4bd8, b=b@entry=0x55ebd47e19d8) at ../src/backend/nodes/equalfuncs.c:239 [22:59:27.255] 239 if (nodeTag(a) != nodeTag(b)) [22:59:27.392] [22:59:27.392] Thread 1 (Thread 0x7f3f2b9bfa40 (LWP 28343)): [22:59:27.392] #0 0x000055ebd3347926 in equal (a=0xffffffffd47e4bd8, b=b@entry=0x55ebd47e19d8) at ../src/backend/nodes/equalfuncs.c:239 [22:59:27.392] retval = [22:59:27.392] __func__ = "equal" [22:59:27.392] #1 0x000055ebd2c86404 in list_member (list=0x55ebd47e4c48, datum=datum@entry=0x55ebd47e19d8) at ../src/backend/nodes/list.c:670 [22:59:27.392] cell__state = {l = , i = } [22:59:27.392] cell = [22:59:27.392] #2 0x000055ebd2da9e0a in add_new_column_to_pathtarget (target=target@entry=0x55ebd47e4b68, expr=0x55ebd47e19d8) at ../src/backend/optimizer/util/tlist.c:743 [22:59:27.392] No locals. [22:59:27.392] #3 0x000055ebd2da9ea5 in add_new_columns_to_pathtarget (target=target@entry=0x55ebd47e4b68, exprs=exprs@entry=0x55ebd47e4d78) at ../src/backend/optimizer/util/tlist.c:760 [22:59:27.392] expr = [22:59:27.392] lc__state = {l = , i = } [22:59:27.392] lc = [22:59:27.392] #4 0x000055ebd2d222fd in make_group_input_target (root=root@entry=0x55ebd47d9be8, final_target=final_target@entry=0x55ebd47e4a08) at ../src/backend/optimizer/plan/planner.c:5472 [22:59:27.392] parse = 0x55ebd46b7d08 [22:59:27.392] input_target = 0x55ebd47e4b68 [22:59:27.392] non_group_cols = 0x55ebd47e4d28 [22:59:27.392] non_group_vars = 0x55ebd47e4d78 [22:59:27.392] i = 6 [22:59:27.392] lc = 0x0 [22:59:27.392] #5 0x000055ebd2d356bf in grouping_planner (root=root@entry=0x55ebd47d9be8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:59:27.392] sort_input_targets = 0x55ebd47e1848 [22:59:27.392] sort_input_target_parallel_safe = true [22:59:27.392] grouping_target = 0x55ebd47e4a08 [22:59:27.392] scanjoin_target = [22:59:27.392] activeWindows = 0x0 [22:59:27.392] qp_extra = {activeWindows = 0x0, gset_data = 0x55ebd47e2e68} [22:59:27.392] sort_input_targets_contain_srfs = 0x55ebd2d6b8bd [22:59:27.392] have_grouping = [22:59:27.392] wflists = 0x0 [22:59:27.392] gset_data = 0x55ebd47e2e68 [22:59:27.392] sort_input_target = 0x55ebd47e4a08 [22:59:27.392] grouping_targets = 0x0 [22:59:27.392] grouping_target_parallel_safe = true [22:59:27.392] scanjoin_targets = 0x0 [22:59:27.392] scanjoin_target_parallel_safe = [22:59:27.392] grouping_targets_contain_srfs = 0x55ebd2c93bd4 [22:59:27.392] scanjoin_targets_contain_srfs = 0x55ebd47de0b8 [22:59:27.392] scanjoin_target_same_exprs = [22:59:27.392] parse = 0x55ebd46b7d08 [22:59:27.392] offset_est = 0 [22:59:27.392] count_est = 0 [22:59:27.392] limit_tuples = -1 [22:59:27.392] have_postponed_srfs = false [22:59:27.392] final_target = 0x55ebd47e4a08 [22:59:27.392] final_targets = 0x0 [22:59:27.392] final_targets_contain_srfs = 0x55ebd2d71bb4 [22:59:27.392] final_target_parallel_safe = true [22:59:27.392] current_rel = 0x55ebd47d9ff8 [22:59:27.392] final_rel = [22:59:27.392] extra = {limit_needed = 232, limit_tuples = 1.9762625833649862e-323, count_est = 94471370677224, offset_est = 0} [22:59:27.392] lc = [22:59:27.392] __func__ = "grouping_planner" [22:59:27.392] #6 0x000055ebd2d38563 in subquery_planner (glob=glob@entry=0x55ebd46b7f78, parse=parse@entry=0x55ebd46b7d08, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:59:27.392] root = 0x55ebd47d9be8 [22:59:27.392] newWithCheckOptions = [22:59:27.392] newHaving = 0x0 [22:59:27.392] hasOuterJoins = [22:59:27.392] hasResultRTEs = false [22:59:27.392] final_rel = [22:59:27.392] l = 0x0 [22:59:27.392] #7 0x000055ebd2d391b8 in standard_planner (parse=0x55ebd46b7d08, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [22:59:27.392] result = [22:59:27.392] glob = 0x55ebd46b7f78 [22:59:27.392] tuple_fraction = 0 [22:59:27.392] root = [22:59:27.392] final_rel = [22:59:27.392] best_path = [22:59:27.392] top_plan = [22:59:27.392] lp = [22:59:27.392] lr = [22:59:27.392] #8 0x000055ebd2d3a27c in planner (parse=parse@entry=0x55ebd46b7d08, query_string=query_string@entry=0x55ebd46b6250 "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 [22:59:27.392] result = [22:59:27.392] #9 0x000055ebd2fa8eda in pg_plan_query (querytree=querytree@entry=0x55ebd46b7d08, query_string=query_string@entry=0x55ebd46b6250 "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 [22:59:27.392] plan = [22:59:27.392] #10 0x000055ebd2fa9247 in pg_plan_queries (querytrees=0x55ebd47de458, query_string=query_string@entry=0x55ebd46b6250 "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 [22:59:27.392] query = 0x55ebd46b7d08 [22:59:27.392] stmt = [22:59:27.392] query_list__state = {l = , i = } [22:59:27.392] stmt_list = 0x0 [22:59:27.392] query_list = [22:59:27.392] #11 0x000055ebd2fa9621 in exec_simple_query (query_string=query_string@entry=0x55ebd46b6250 "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 [22:59:27.392] cmdtaglen = 6 [22:59:27.392] snapshot_set = true [22:59:27.392] per_parsetree_context = 0x0 [22:59:27.392] plantree_list = [22:59:27.392] parsetree = 0x55ebd46b7b78 [22:59:27.392] commandTag = CMDTAG_SELECT [22:59:27.392] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94471369482832} [22:59:27.392] querytree_list = [22:59:27.392] portal = [22:59:27.392] receiver = [22:59:27.392] format = 0 [22:59:27.392] cmdtagname = [22:59:27.392] parsetree_item__state = {l = , i = } [22:59:27.392] dest = DestRemote [22:59:27.392] oldcontext = 0x55ebd4790350 [22:59:27.392] parsetree_list = 0x55ebd46b7ba8 [22:59:27.392] parsetree_item = 0x55ebd46b7bc0 [22:59:27.392] save_log_statement_stats = false [22:59:27.392] was_logged = true [22:59:27.392] use_implicit_block = false [22:59:27.392] msec_str = "\300\377\336\352\374\177\000\000e\215'\323\353U\000\000\360\375\336\352\374\177\000\000[\000\000\000\000\000\000" [22:59:27.392] __func__ = "exec_simple_query" [22:59:27.392] #12 0x000055ebd2fac521 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [22:59:27.392] query_string = 0x55ebd46b6250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [22:59:27.392] firstchar = [22:59:27.392] input_message = {data = 0x55ebd46b6250 "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} [22:59:27.392] local_sigjmp_buf = {{__jmpbuf = {94471360646584, -3813030752785939092, 4, 140724248969152, 140724248969300, 1, -6972954517882157716, -3813028775578712724}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 139909331901924, 94471369457408, 14336, 14400, 94471348375782, 94471360646592, 94471369457408, 94471360640664, 140724248969152, 140724248969300, 94471348379850, 140724248968928}}}} [22:59:27.392] send_ready_for_query = false [22:59:27.392] idle_in_transaction_timeout_enabled = false [22:59:27.392] idle_session_timeout_enabled = false [22:59:27.392] __func__ = "PostgresMain" [22:59:27.392] #13 0x000055ebd2fa2cd8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:59:27.392] bsdata = [22:59:27.392] #14 0x000055ebd2e4d53c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffceadeff6c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffceadeffc0) at ../src/backend/postmaster/launch_backend.c:267 [22:59:27.392] pid = [22:59:27.392] #15 0x000055ebd2e536bc in BackendStartup (client_sock=client_sock@entry=0x7ffceadeffc0) at ../src/backend/postmaster/postmaster.c:3593 [22:59:27.392] bn = 0x55ebd46ec4d8 [22:59:27.392] pid = [22:59:27.392] startup_data = {canAcceptConnections = CAC_OK} [22:59:27.392] __func__ = "BackendStartup" [22:59:27.392] #16 0x000055ebd2e53c6a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:59:27.392] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\034.?\177\000\000\001\000\000\000\000\000\000\000\244S\227/?\177\000\000-\000\000\000\000\000\000\000\020\036\000.?\177\000\000 \351\317.?\177\000\000\210\000\337\352\374\177\000\000\204\000\337\352\374\177\000\000D\000\337\352\374\177\000\000@\216\000\000\001\000\000\000\000\000\000\000\353U\000\000\020\036\000.?\177\000\000\340?\377-?\177\000\000\352\177\034.?\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [22:59:27.392] i = 0 [22:59:27.392] now = [22:59:27.392] last_lockfile_recheck_time = 1710888956 [22:59:27.392] last_touch_time = 1710888956 [22:59:27.392] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -354483904, events = 32764, fd = 45, user_data = 0x7ffceadf0100}, {pos = -354483952, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 785377160, user_data = 0x7f3f2e1c7fea}, {pos = -354483736, events = 32764, fd = -354483904, user_data = 0x7ffceadf0150}, {pos = 798448865, events = 32575, fd = 18, user_data = 0x7f3f2b9c5618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 785376288, events = 32575, fd = -1, user_data = 0x7f3f2b9c5618}, {pos = 785376288, events = 32575, fd = 1024, user_data = 0x7f3f2ecfe788}, {pos = 0, events = 0, fd = 7, user_data = 0x7ffceadf0150}, {pos = -1, events = 0, fd = 772484282, user_data = 0x7f3f2dff4418}, {pos = 785377568, events = 32575, fd = -730991624, user_data = 0x55ebd46df288}, {pos = -730984304, events = 21995, fd = -730991592, user_data = 0x55ebd46e0371}, {pos = 798467619, events = 32575, fd = 1, user_data = 0x7f3f2e1e10f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -731152400, user_data = 0x7f3f2f97a623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x55ebd46e1090}, {pos = 771703832, events = 32575, fd = -354482800, user_data = 0x7f3f2f98168a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffceadf05b0}, {pos = -740054144, events = 21995, fd = 2, user_data = 0x55ebd3e3ab80 }, {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 = -730991704, 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 = 908075040, events = 875901751, fd = 538976266, user_data = 0x0}, {pos = 0, events = 0, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x3437333736202020}, {pos = 538976305, 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 = 772222254, user_data = 0x400}, {pos = -731168864, events = 21995, fd = 773567616, user_data = 0x1d46b3fa0}, {pos = 784, events = 0, fd = -749989108, user_data = 0x55ebd46def60}, {pos = 1845304320, events = 208815174, fd = 4, user_data = 0x55ebd46df370}, {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 = 0x55ebd46def60}, {pos = 1, events = 0, fd = -730992600, user_data = 0x400}, {pos = 0, events = 0, fd = -752186742, user_data = 0x55ebd3e48d70 }, {pos = -752253066, events = 21995, fd = -730992800, user_data = 0x55ebd46b6150}, {pos = -730992800, events = 21995, fd = 15, user_data = 0x4a}, {pos = -752184974, events = 21995, fd = -730992800, user_data = 0x55ebd32a92b4 }, {pos = -731168864, events = 21995, fd = 772222254, user_data = 0x0}, {pos = -758708522, events = 21995, fd = -730997952, user_data = 0x7f3f2e06f1aa}, {pos = -354482616, events = 1, fd = 0, user_data = 0x7f3f2e06d8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 24278, user_data = 0x7f3f2e0b7b05 }, {pos = 0, events = 0, fd = 1845304320, user_data = 0x0}, {pos = -756755925, events = 21995, fd = 4194304, user_data = 0x55ebd329860a }, {pos = -730997952, events = 21995, fd = -731160240, user_data = 0x55ebd46ddb40}, {pos = 1, events = 0, fd = 0, user_data = 0x55ebd32a9172 }, {pos = -730997952, events = 21995, fd = -752184652, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55ebd2c702a9 }, {pos = 0, events = 0, fd = -758685569, user_data = 0xb}, {pos = -756734450, events = 21995, fd = 0, user_data = 0x0}} [22:59:27.392] nevents = 1 [22:59:27.392] __func__ = "ServerLoop" [22:59:27.392] #17 0x000055ebd2e5568c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55ebd46afe10) at ../src/backend/postmaster/postmaster.c:1372 [22:59:27.392] opt = [22:59:27.392] status = [22:59:27.392] userDoption = [22:59:27.392] listen_addr_saved = false [22:59:27.392] output_config_variable = [22:59:27.392] __func__ = "PostmasterMain" [22:59:27.392] #18 0x000055ebd2c810d9 in main (argc=4, argv=0x55ebd46afe10) at ../src/backend/main/main.c:197 [22:59:27.392] do_check_root = [22:59:27.410] -e [22:59:27.410] [22:59:27.410] [22:59:27.942] dumping /tmp/cores/postgres-11-29248.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:59:28.243] [New LWP 29248] [22:59:29.350] [Thread debugging using libthread_db enabled] [22:59:29.350] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:59:30.759] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [22:59:30.759] Program terminated with signal SIGSEGV, Segmentation fault. [22:59:30.759] #0 0x00005593e3fde926 in equal (a=0xffffffffe4c69180, b=b@entry=0x5593e4c9a688) at ../src/backend/nodes/equalfuncs.c:239 [22:59:30.759] 239 if (nodeTag(a) != nodeTag(b)) [22:59:30.940] [22:59:30.940] Thread 1 (Thread 0x7f52a21e4a40 (LWP 29248)): [22:59:30.940] #0 0x00005593e3fde926 in equal (a=0xffffffffe4c69180, b=b@entry=0x5593e4c9a688) at ../src/backend/nodes/equalfuncs.c:239 [22:59:30.940] retval = [22:59:30.940] __func__ = "equal" [22:59:30.940] #1 0x00005593e391d404 in list_member (list=0x5593e4c691f0, datum=datum@entry=0x5593e4c9a688) at ../src/backend/nodes/list.c:670 [22:59:30.940] cell__state = {l = , i = } [22:59:30.940] cell = [22:59:30.940] #2 0x00005593e3a40e0a in add_new_column_to_pathtarget (target=target@entry=0x5593e4c69110, expr=0x5593e4c9a688) at ../src/backend/optimizer/util/tlist.c:743 [22:59:30.940] No locals. [22:59:30.940] #3 0x00005593e3a40ea5 in add_new_columns_to_pathtarget (target=target@entry=0x5593e4c69110, exprs=exprs@entry=0x5593e4c692a8) at ../src/backend/optimizer/util/tlist.c:760 [22:59:30.940] expr = [22:59:30.940] lc__state = {l = , i = } [22:59:30.940] lc = [22:59:30.940] #4 0x00005593e39b92fd in make_group_input_target (root=root@entry=0x5593e4c99f98, final_target=final_target@entry=0x5593e4c69028) at ../src/backend/optimizer/plan/planner.c:5472 [22:59:30.940] parse = 0x5593e4b49788 [22:59:30.940] input_target = 0x5593e4c69110 [22:59:30.940] non_group_cols = 0x5593e4c69258 [22:59:30.940] non_group_vars = 0x5593e4c692a8 [22:59:30.940] i = 2 [22:59:30.940] lc = 0x0 [22:59:30.940] #5 0x00005593e39cc6bf in grouping_planner (root=root@entry=0x5593e4c99f98, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:59:30.940] sort_input_targets = 0x5593e4c9a4b8 [22:59:30.940] sort_input_target_parallel_safe = true [22:59:30.940] grouping_target = 0x5593e4c69028 [22:59:30.940] scanjoin_target = [22:59:30.940] activeWindows = 0x0 [22:59:30.940] qp_extra = {activeWindows = 0x0, gset_data = 0x5593e4c9d768} [22:59:30.940] sort_input_targets_contain_srfs = 0x5593e3a028bd [22:59:30.940] have_grouping = [22:59:30.940] wflists = 0x0 [22:59:30.940] gset_data = 0x5593e4c9d768 [22:59:30.940] sort_input_target = 0x5593e4c69028 [22:59:30.940] grouping_targets = 0x0 [22:59:30.940] grouping_target_parallel_safe = true [22:59:30.940] scanjoin_targets = 0x0 [22:59:30.940] scanjoin_target_parallel_safe = [22:59:30.940] grouping_targets_contain_srfs = 0x5593e392abd4 [22:59:30.940] scanjoin_targets_contain_srfs = 0x0 [22:59:30.940] scanjoin_target_same_exprs = [22:59:30.940] parse = 0x5593e4b49788 [22:59:30.940] offset_est = 0 [22:59:30.940] count_est = 0 [22:59:30.940] limit_tuples = -1 [22:59:30.940] have_postponed_srfs = false [22:59:30.940] final_target = 0x5593e4c69028 [22:59:30.940] final_targets = 0x5593e4c2b448 [22:59:30.940] final_targets_contain_srfs = 0x5593e3a028f2 [22:59:30.940] final_target_parallel_safe = true [22:59:30.940] current_rel = 0x5593e4c99d48 [22:59:30.940] final_rel = [22:59:30.940] extra = {limit_needed = 152, limit_tuples = 4.9406564584124654e-324, count_est = 94093686972312, offset_est = 1} [22:59:30.940] lc = [22:59:30.940] __func__ = "grouping_planner" [22:59:30.940] #6 0x00005593e39cf563 in subquery_planner (glob=glob@entry=0x5593e4c99c38, parse=parse@entry=0x5593e4b49788, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:59:30.940] root = 0x5593e4c99f98 [22:59:30.940] newWithCheckOptions = [22:59:30.940] newHaving = 0x0 [22:59:30.940] hasOuterJoins = [22:59:30.940] hasResultRTEs = false [22:59:30.940] final_rel = [22:59:30.940] l = 0x0 [22:59:30.940] #7 0x00005593e39d01b8 in standard_planner (parse=0x5593e4b49788, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [22:59:30.940] result = [22:59:30.940] glob = 0x5593e4c99c38 [22:59:30.940] tuple_fraction = 0 [22:59:30.940] root = [22:59:30.940] final_rel = [22:59:30.940] best_path = [22:59:30.940] top_plan = [22:59:30.940] lp = [22:59:30.940] lr = [22:59:30.940] #8 0x00005593e39d127c in planner (parse=parse@entry=0x5593e4b49788, query_string=query_string@entry=0x5593e4b48260 "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 [22:59:30.940] result = [22:59:30.940] #9 0x00005593e3c3feda in pg_plan_query (querytree=querytree@entry=0x5593e4b49788, query_string=query_string@entry=0x5593e4b48260 "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 [22:59:30.940] plan = [22:59:30.940] #10 0x00005593e372fd74 in standard_ExplainOneQuery (query=0x5593e4b49788, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5593e4b73318, queryString=0x5593e4b48260 "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 [22:59:30.940] plan = [22:59:30.940] planstart = {ticks = } [22:59:30.940] planduration = {ticks = 94093685593992} [22:59:30.940] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94093661909848, shared_blks_dirtied = 0, shared_blks_written = 70368744214751, local_blks_hit = 94093685594264, local_blks_read = 94093663232529, local_blks_dirtied = 140720718930686, local_blks_written = 94093669069873, temp_blks_read = 1, temp_blks_written = 139992730827280, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94089848553472}, local_blk_read_time = {ticks = 94093686516472}, local_blk_write_time = {ticks = 94093672978806}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94093666533887}} [22:59:30.940] bufusage = {shared_blks_hit = 94093686971288, shared_blks_read = 4294967297, shared_blks_dirtied = 0, shared_blks_written = 10, local_blks_hit = 0, local_blks_read = 94093669589117, local_blks_dirtied = 159287452123136, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 37087, shared_blk_read_time = {ticks = 139992730827280}, shared_blk_write_time = {ticks = 94093685595080}, local_blk_read_time = {ticks = 94093685593992}, local_blk_write_time = {ticks = 94093672496459}, temp_blk_read_time = {ticks = 139992730827280}, temp_blk_write_time = {ticks = 94093672496478}} [22:59:30.940] mem_counters = {nblocks = 140720718930688, freechunks = 94093685593992, totalspace = 140720718930685, freespace = 94093669154535} [22:59:30.940] planner_ctx = 0x0 [22:59:30.940] saved_ctx = 0x0 [22:59:30.940] #11 0x00005593e373000c in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5593e4b73318, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:396 [22:59:30.940] No locals. [22:59:30.940] #12 0x00005593e3731603 in ExplainQuery (pstate=pstate@entry=0x5593e4b73208, stmt=stmt@entry=0x5593e4b495c8, params=params@entry=0x0, dest=dest@entry=0x5593e4b73178) at ../src/include/nodes/nodes.h:172 [22:59:30.940] l__state = {l = , i = } [22:59:30.940] l = 0x5593e4c99c00 [22:59:30.940] es = 0x5593e4b73318 [22:59:30.940] tstate = [22:59:30.940] jstate = [22:59:30.940] query = [22:59:30.940] rewritten = 0x5593e4c99be8 [22:59:30.940] lc = 0x0 [22:59:30.940] timing_set = false [22:59:30.940] summary_set = false [22:59:30.940] __func__ = "ExplainQuery" [22:59:30.940] #13 0x00005593e3c4a8e8 in standard_ProcessUtility (pstmt=0x5593e4b49678, queryString=0x5593e4b48260 "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=0x5593e4b73178, qc=0x7ffc1876e4f0) at ../src/backend/tcop/utility.c:863 [22:59:30.940] parsetree = 0x5593e4b495c8 [22:59:30.940] isTopLevel = true [22:59:30.940] isAtomicContext = false [22:59:30.940] pstate = 0x5593e4b73208 [22:59:30.940] readonly_flags = [22:59:30.940] __func__ = "standard_ProcessUtility" [22:59:30.940] #14 0x00005593e3c4b011 in ProcessUtility (pstmt=pstmt@entry=0x5593e4b49678, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5593e4b73178, qc=0x7ffc1876e4f0) at ../src/backend/tcop/utility.c:523 [22:59:30.940] No locals. [22:59:30.940] #15 0x00005593e3c4676f in PortalRunUtility (portal=portal@entry=0x5593e4bc8f90, pstmt=0x5593e4b49678, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5593e4b73178, qc=qc@entry=0x7ffc1876e4f0) at ../src/backend/tcop/pquery.c:1158 [22:59:30.940] No locals. [22:59:30.940] #16 0x00005593e3c47152 in FillPortalStore (portal=portal@entry=0x5593e4bc8f90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [22:59:30.940] treceiver = 0x5593e4b73178 [22:59:30.940] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:59:30.940] __func__ = "FillPortalStore" [22:59:30.940] #17 0x00005593e3c477d4 in PortalRun (portal=portal@entry=0x5593e4bc8f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5593e4c2ab88, altdest=altdest@entry=0x5593e4c2ab88, qc=0x7ffc1876e6d0) at ../src/backend/tcop/pquery.c:763 [22:59:30.940] _save_exception_stack = 0x7ffc1876e780 [22:59:30.940] _save_context_stack = 0x0 [22:59:30.940] _local_sigjmp_buf = {{__jmpbuf = {1, 5915034008024658657, 94093686516616, 94093685593664, 94093686116240, 94093685593592, -5913687029313817887, -490422181887986975}, __mask_was_saved = 0, __saved_mask = {__val = {94093686127800, 94093675701278, 94093686124448, 94093675701278, 1, 140720718931551, 94093685593640, 94093685593592, 94093672719897, 94093675289513, 94093686116240, 94093675701278, 1, 1, 94093672979208, 153}}}} [22:59:30.940] _do_rethrow = [22:59:30.940] result = [22:59:30.940] nprocessed = [22:59:30.940] saveTopTransactionResourceOwner = 0x5593e4b865c0 [22:59:30.940] saveTopTransactionContext = 0x5593e4c32520 [22:59:30.940] saveActivePortal = 0x0 [22:59:30.940] saveResourceOwner = 0x5593e4b865c0 [22:59:30.940] savePortalContext = 0x0 [22:59:30.940] saveMemoryContext = 0x5593e4c32520 [22:59:30.940] __func__ = "PortalRun" [22:59:30.940] #18 0x00005593e3c40769 in exec_simple_query (query_string=query_string@entry=0x5593e4b48260 "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 [22:59:30.940] cmdtaglen = 7 [22:59:30.940] snapshot_set = [22:59:30.940] per_parsetree_context = 0x0 [22:59:30.940] plantree_list = 0x5593e4c2b6a8 [22:59:30.940] parsetree = 0x5593e4b495f8 [22:59:30.940] commandTag = [22:59:30.940] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:59:30.940] querytree_list = [22:59:30.940] portal = 0x5593e4bc8f90 [22:59:30.940] receiver = 0x5593e4c2ab88 [22:59:30.940] format = 0 [22:59:30.940] cmdtagname = [22:59:30.940] parsetree_item__state = {l = , i = } [22:59:30.940] dest = DestRemote [22:59:30.940] oldcontext = 0x5593e4c32520 [22:59:30.940] parsetree_list = 0x5593e4b49628 [22:59:30.940] parsetree_item = 0x5593e4b49640 [22:59:30.940] save_log_statement_stats = false [22:59:30.940] was_logged = false [22:59:30.940] use_implicit_block = false [22:59:30.940] msec_str = "0\351v\030\374\177\000\000e\375\360\343\223U\000\000`\347v\030\374\177\000\000U\000\000\000\000\000\000" [22:59:30.940] __func__ = "exec_simple_query" [22:59:30.940] #19 0x00005593e3c43521 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [22:59:30.940] query_string = 0x5593e4b48260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [22:59:30.940] firstchar = [22:59:30.940] input_message = {data = 0x5593e4b48260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [22:59:30.940] local_sigjmp_buf = {{__jmpbuf = {94093685161400, -490429135732460831, 4, 140720718932272, 140720718932420, 1, -5913687029259291935, -490422184768032031}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 139992924532196, 94093685563120, 15616, 15680, 94093672890598, 94093685161408, 94093685563120, 94093685155480, 140720718932272, 140720718932420, 94093672894666, 140720718932048}}}} [22:59:30.940] send_ready_for_query = false [22:59:30.940] idle_in_transaction_timeout_enabled = false [22:59:30.940] idle_session_timeout_enabled = false [22:59:30.940] __func__ = "PostgresMain" [22:59:30.940] #20 0x00005593e3c39cd8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:59:30.940] bsdata = [22:59:30.940] #21 0x00005593e3ae453c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc1876e8dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc1876e930) at ../src/backend/postmaster/launch_backend.c:267 [22:59:30.940] pid = [22:59:30.940] #22 0x00005593e3aea6bc in BackendStartup (client_sock=client_sock@entry=0x7ffc1876e930) at ../src/backend/postmaster/postmaster.c:3593 [22:59:30.940] bn = 0x5593e4b72b28 [22:59:30.940] pid = [22:59:30.940] startup_data = {canAcceptConnections = CAC_OK} [22:59:30.940] __func__ = "BackendStartup" [22:59:30.940] #23 0x00005593e3aeac6a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:59:30.940] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000\210k\201\244R\177\000\000 \243\236\244R\177\000\000\001\000\000\000\000\000\000\000\244C\031\246R\177\000\000-\000\000\000\000\000\000\000\020n\202\244R\177\000\000 9R\245R\177\000\000\b\352v\030\374\177\000\000\004\352v\030\374\177\000\000P9\267\344\223U", '\000' , "\020n\202\244R\177\000\000\340\217\201\244R\177\000", __ss_align = 139992925917162}, salen = 2}} [22:59:30.940] i = 0 [22:59:30.940] now = [22:59:30.940] last_lockfile_recheck_time = 1710888954 [22:59:30.940] last_touch_time = 1710888954 [22:59:30.940] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 410446544, events = 32764, fd = -1533107424, user_data = 0x7ffc1876eac0}, {pos = 45, events = 0, fd = -1508155008, user_data = 0x1876ea90}, {pos = 0, events = 0, fd = -1508155008, user_data = 0x59e7c8ee}, {pos = -1521338488, events = 32594, fd = -1533095958, user_data = 0x7ffc1876eb68}, {pos = 410446528, events = 32764, fd = 410446544, user_data = 0x7f52a6194ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -1575049704, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f52a5523420}, {pos = 410446480, events = 32764, fd = -1575049704, user_data = 0x7f52a5523420}, {pos = -465426272, events = 1, fd = -1521338488, user_data = 0x0}, {pos = -457778704, events = 21907, fd = -457745368, user_data = 0xffffffff}, {pos = -1508272605, events = 32594, fd = -1535011816, user_data = 0x7f52a5523920}, {pos = -457745400, events = 21907, fd = -1534965256, user_data = 0x7ffc1876eeb0}, {pos = -1508243830, events = 32594, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = -1532993288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = -457924560, events = 21907, fd = -1508272605, user_data = 0x1}, {pos = 0, events = 0, fd = -457745576, user_data = 0x7f52a4819418}, {pos = 410447616, events = 32764, fd = -1508243830, user_data = 0x0}, {pos = 0, events = 0, fd = 410447648, user_data = 0x5593e4ad1b80 }, {pos = 2, events = 0, fd = -458417280, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 8096, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x2020206c6c612020}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -457751656, user_data = 0x3ff}, {pos = 4096, events = 0, fd = -457941104, user_data = 0x5593e4b45f90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294901760, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1734701663, events = 1936942450, fd = 2018527277, user_data = 0x667850482d737365}, {pos = 168458094, events = 908075040, fd = 822763892, user_data = 0x30340a3435393838}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x400}, {pos = -457941104, events = 21907, fd = -1533148032, user_data = 0x1e4b45f90}, {pos = 784, events = 0, fd = -468352244, user_data = 0x5593e4b733e0}, {pos = -661005056, events = 3968714731, fd = 4, user_data = 0x5593e4b74360}, {pos = -457755680, events = 21907, fd = -457755480, 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 = -457755480, user_data = 0x400}, {pos = 0, events = 0, fd = -470549878, user_data = 0x5593e4adfd70 }, {pos = -470616202, events = 21907, fd = -457755680, user_data = 0x5593e4b48160}, {pos = -457755680, events = 21907, fd = 15, user_data = 0x4a}, {pos = -470548110, events = 21907, fd = -457755680, user_data = 0x5593e3f402b4 }, {pos = -457941104, events = 21907, fd = -1534493701, user_data = 0x0}, {pos = -477071658, events = 21907, fd = -457767072, user_data = 0x7f52a48941aa}, {pos = 410447800, events = 1, fd = 0, user_data = 0x7f52a48928f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 23625, user_data = 0x7f52a48dcb05 }, {pos = 0, events = 0, fd = -661005056, user_data = 0x0}, {pos = -475119061, events = 21907, fd = 4194304, user_data = 0x5593e3f2f60a }, {pos = -457767072, events = 21907, fd = -457932448, user_data = 0x5593e4b70760}, {pos = 1, events = 0, fd = 0, user_data = 0x5593e3f40172 }, {pos = -457767072, events = 21907, fd = -470547788, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5593e39072a9 }, {pos = 0, events = 0, fd = -477048705, user_data = 0xb}, {pos = -475097586, events = 21907, fd = 0, user_data = 0x0}} [22:59:30.940] nevents = 1 [22:59:30.940] __func__ = "ServerLoop" [22:59:30.940] #24 0x00005593e3aec68c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5593e4b41e50) at ../src/backend/postmaster/postmaster.c:1372 [22:59:30.940] opt = [22:59:30.940] status = [22:59:30.940] userDoption = [22:59:30.940] listen_addr_saved = false [22:59:30.940] output_config_variable = [22:59:30.940] __func__ = "PostmasterMain" [22:59:30.940] #25 0x00005593e39180d9 in main (argc=8, argv=0x5593e4b41e50) at ../src/backend/main/main.c:197 [22:59:30.940] do_check_root = [22:59:30.958] -e [22:59:30.958] [22:59:30.958] [22:59:31.492] dumping /tmp/cores/postgres-11-37161.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:59:31.783] [New LWP 37161] [22:59:32.888] [Thread debugging using libthread_db enabled] [22:59:32.888] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:59:34.278] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT '. [22:59:34.278] Program terminated with signal SIGSEGV, Segmentation fault. [22:59:34.278] #0 0x000055e662c88bd0 in get_expr_width (root=root@entry=0x55e6652cd038, expr=expr@entry=0x65221078) at ../src/backend/optimizer/path/costsize.c:6328 [22:59:34.278] 6328 if (IsA(expr, Var)) [22:59:34.399] [22:59:34.399] Thread 1 (Thread 0x7f821cd4ea40 (LWP 37161)): [22:59:34.399] #0 0x000055e662c88bd0 in get_expr_width (root=root@entry=0x55e6652cd038, expr=expr@entry=0x65221078) at ../src/backend/optimizer/path/costsize.c:6328 [22:59:34.399] width = [22:59:34.399] #1 0x000055e662c9986f in set_pathtarget_cost_width (root=root@entry=0x55e6652cd038, target=target@entry=0x55e665221008) at ../src/backend/optimizer/path/costsize.c:6299 [22:59:34.399] node = 0x65221078 [22:59:34.399] lc__state = {l = , i = } [22:59:34.399] tuple_width = 0 [22:59:34.399] lc = [22:59:34.399] #2 0x000055e662cf4318 in make_group_input_target (root=root@entry=0x55e6652cd038, final_target=final_target@entry=0x55e665220f48) at ../src/backend/optimizer/plan/planner.c:5479 [22:59:34.399] parse = 0x55e6652d9228 [22:59:34.399] input_target = 0x55e665221008 [22:59:34.399] non_group_cols = 0x0 [22:59:34.399] non_group_vars = 0x0 [22:59:34.399] i = 3 [22:59:34.399] lc = 0x0 [22:59:34.399] #3 0x000055e662d076bf in grouping_planner (root=root@entry=0x55e6652cd038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:59:34.399] sort_input_targets = 0x55e6652ce7c0 [22:59:34.399] sort_input_target_parallel_safe = true [22:59:34.399] grouping_target = 0x55e665220f48 [22:59:34.399] scanjoin_target = [22:59:34.399] activeWindows = 0x0 [22:59:34.399] qp_extra = {activeWindows = 0x0, gset_data = 0x55e6652ced60} [22:59:34.399] sort_input_targets_contain_srfs = 0x55e662d3d8bd [22:59:34.399] have_grouping = [22:59:34.399] wflists = 0x0 [22:59:34.399] gset_data = 0x55e6652ced60 [22:59:34.399] sort_input_target = 0x55e665220f48 [22:59:34.399] grouping_targets = 0x0 [22:59:34.399] grouping_target_parallel_safe = true [22:59:34.399] scanjoin_targets = 0x0 [22:59:34.399] scanjoin_target_parallel_safe = [22:59:34.399] grouping_targets_contain_srfs = 0x55e662c65bd4 [22:59:34.399] scanjoin_targets_contain_srfs = 0x55e6652db0d0 [22:59:34.399] scanjoin_target_same_exprs = [22:59:34.399] parse = 0x55e6652d9228 [22:59:34.399] offset_est = 0 [22:59:34.399] count_est = 0 [22:59:34.399] limit_tuples = -1 [22:59:34.399] have_postponed_srfs = false [22:59:34.399] final_target = 0x55e665220f48 [22:59:34.399] final_targets = 0x0 [22:59:34.399] final_targets_contain_srfs = 0x55e662d43bb4 [22:59:34.399] final_target_parallel_safe = true [22:59:34.399] current_rel = 0x55e66521f558 [22:59:34.399] final_rel = [22:59:34.399] extra = {limit_needed = 56, limit_tuples = 1.9762625833649862e-323, count_est = 94448028274744, offset_est = 0} [22:59:34.399] lc = [22:59:34.399] __func__ = "grouping_planner" [22:59:34.399] #4 0x000055e662d0a563 in subquery_planner (glob=glob@entry=0x55e6651cdfd8, parse=parse@entry=0x55e6652d9228, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:59:34.399] root = 0x55e6652cd038 [22:59:34.399] newWithCheckOptions = [22:59:34.399] newHaving = 0x0 [22:59:34.399] hasOuterJoins = [22:59:34.399] hasResultRTEs = false [22:59:34.399] final_rel = [22:59:34.399] l = 0x0 [22:59:34.399] #5 0x000055e662d0b1b8 in standard_planner (parse=parse@entry=0x55e6652d9228, query_string=query_string@entry=0x55e6651cc2c0 "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 [22:59:34.399] result = [22:59:34.399] glob = 0x55e6651cdfd8 [22:59:34.399] tuple_fraction = 0 [22:59:34.399] root = [22:59:34.399] final_rel = [22:59:34.399] best_path = [22:59:34.399] top_plan = [22:59:34.399] lp = [22:59:34.399] lr = [22:59:34.399] #6 0x00007f821cb7b59c in pgss_planner (parse=0x55e6652d9228, query_string=0x55e6651cc2c0 "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 [22:59:34.399] _save_exception_stack = 0x7ffd760e8120 [22:59:34.399] _save_context_stack = 0x0 [22:59:34.399] _local_sigjmp_buf = {{__jmpbuf = {94448028324392, -3922033942176069955, 0, 2048, 0, 94448027222720, -7087534632059402563, -7108138447336634691}, __mask_was_saved = 0, __saved_mask = {__val = {140196800009400, 384, 94448027201104, 140726584114976, 1, 140726584114879, 140726584756053, 137, 6, 140196802145592, 94447993362403, 1710888999, 54587, 472, 94447994309345, 140196802145592}}}} [22:59:34.399] _do_rethrow = false [22:59:34.399] duration = {ticks = } [22:59:34.399] bufusage = {shared_blks_hit = 94448028274379, shared_blks_read = 94448028274377, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 93458488360960, local_blks_read = 8, local_blks_dirtied = 266, local_blks_written = 94447994640554, temp_blks_read = 0, temp_blks_written = 206158430232, shared_blk_read_time = {ticks = 140726584114832}, shared_blk_write_time = {ticks = 140726584114640}, local_blk_read_time = {ticks = 60}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 2231203495}, temp_blk_write_time = {ticks = 94448027201104}} [22:59:34.399] walusage_start = {wal_records = 1344, wal_fpi = 2, wal_bytes = 170221} [22:59:34.399] start = {ticks = } [22:59:34.399] bufusage_start = {shared_blks_hit = 6881, shared_blks_read = 4, shared_blks_dirtied = 18, shared_blks_written = 18, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [22:59:34.399] walusage = {wal_records = 0, wal_fpi = 94447994390902, wal_bytes = 94447989217520} [22:59:34.399] result = 0x7ffd760e7e90 [22:59:34.399] #7 0x000055e662d0c272 in planner (parse=parse@entry=0x55e6652d9228, query_string=query_string@entry=0x55e6651cc2c0 "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 [22:59:34.399] result = [22:59:34.399] #8 0x000055e662f7aeda in pg_plan_query (querytree=querytree@entry=0x55e6652d9228, query_string=query_string@entry=0x55e6651cc2c0 "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 [22:59:34.399] plan = [22:59:34.399] #9 0x000055e662f7b247 in pg_plan_queries (querytrees=0x55e6652ccfe8, query_string=query_string@entry=0x55e6651cc2c0 "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 [22:59:34.399] query = 0x55e6652d9228 [22:59:34.399] stmt = [22:59:34.399] query_list__state = {l = , i = } [22:59:34.399] stmt_list = 0x0 [22:59:34.399] query_list = [22:59:34.399] #10 0x000055e662f7b621 in exec_simple_query (query_string=query_string@entry=0x55e6651cc2c0 "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 [22:59:34.399] cmdtaglen = 6 [22:59:34.399] snapshot_set = true [22:59:34.399] per_parsetree_context = 0x0 [22:59:34.399] plantree_list = [22:59:34.399] parsetree = 0x55e6651cdf58 [22:59:34.399] commandTag = CMDTAG_SELECT [22:59:34.399] qc = {commandTag = CMDTAG_DROP_ROLE, nprocessed = 94448027222720} [22:59:34.399] querytree_list = [22:59:34.399] portal = [22:59:34.399] receiver = [22:59:34.399] format = 0 [22:59:34.399] cmdtagname = [22:59:34.399] parsetree_item__state = {l = , i = } [22:59:34.399] dest = DestRemote [22:59:34.399] oldcontext = 0x55e6651f7be0 [22:59:34.399] parsetree_list = 0x55e6651cdf88 [22:59:34.399] parsetree_item = 0x55e6651cdfa0 [22:59:34.399] save_log_statement_stats = false [22:59:34.399] was_logged = false [22:59:34.399] use_implicit_block = false [22:59:34.399] msec_str = "Ђ\016v\375\177\000\000e\255$c\346U\000\000\000\201\016v\375\177\000\000\205\000\000\000\000\000\000" [22:59:34.399] __func__ = "exec_simple_query" [22:59:34.399] #11 0x000055e662f7e521 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [22:59:34.399] query_string = 0x55e6651cc2c0 "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;" [22:59:34.399] firstchar = [22:59:34.399] input_message = {data = 0x55e6651cc2c0 "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} [22:59:34.399] local_sigjmp_buf = {{__jmpbuf = {94448006573496, -3922020570835581251, 4, 140726584115920, 140726584116068, 1, -7087534638082423107, -3922022577042225475}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140196846783972, 94448027197264, 15616, 15680, 94447994302694, 94448006573504, 94448027197264, 94448006567576, 140726584115920, 140726584116068, 94447994306762, 140726584115696}}}} [22:59:34.399] send_ready_for_query = false [22:59:34.399] idle_in_transaction_timeout_enabled = false [22:59:34.399] idle_session_timeout_enabled = false [22:59:34.399] __func__ = "PostgresMain" [22:59:34.399] #12 0x000055e662f74cd8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:59:34.399] bsdata = [22:59:34.399] #13 0x000055e662e1f53c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffd760e827c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd760e82d0) at ../src/backend/postmaster/launch_backend.c:267 [22:59:34.399] pid = [22:59:34.399] #14 0x000055e662e256bc in BackendStartup (client_sock=client_sock@entry=0x7ffd760e82d0) at ../src/backend/postmaster/postmaster.c:3593 [22:59:34.399] bn = 0x55e6651f7e18 [22:59:34.399] pid = [22:59:34.399] startup_data = {canAcceptConnections = CAC_OK} [22:59:34.399] __func__ = "BackendStartup" [22:59:34.399] #15 0x000055e662e25c6a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:59:34.399] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\317 \202\177\000\000-\000\000\000\000\000\000\000\020\016\071\037\202\177\000\000 \331\b \202\177\000\000\210\203\016v\375\177\000\000\204\203\016v\375\177\000\000D\203\016v\375\177\000\000PM\037e\346U\000\000\000\000\000\000\375\177\000\000\020\016\071\037\202\177\000\000\340/8\037\202\177\000\000\352oU\037\202\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\204\203\016v\375\177\000", __ss_align = 94448027389264}, salen = 2}} [22:59:34.399] i = 0 [22:59:34.399] now = [22:59:34.399] last_lockfile_recheck_time = 1710888998 [22:59:34.399] last_touch_time = 1710888998 [22:59:34.399] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1980662784, events = 32765, fd = 1980662800, user_data = 0x0}, {pos = 18, events = 0, fd = 1508362478, user_data = 0x7f822008d788}, {pos = 525692906, events = 32642, fd = 1980663016, user_data = 0x7ffd760e8440}, {pos = 1980662864, events = 32765, fd = 550497505, user_data = 0x12}, {pos = 483739160, events = 32642, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 537449504, user_data = 0xffffffff}, {pos = 483739160, events = 32642, fd = 537449504, user_data = 0x12008d920}, {pos = 537450376, events = 32642, fd = 0, user_data = 0x7ffd760e855e}, {pos = 1980663120, events = 32765, fd = -1, user_data = 0x7ffd760e8460}, {pos = 523777048, events = 32642, fd = 537450784, user_data = 0x55e6651fa488}, {pos = 1696558264, events = 21990, fd = 1696558496, user_data = 0x55e6651fa4a8}, {pos = 1696572385, events = 21990, fd = 550516259, user_data = 0x1}, {pos = 525795576, events = 32642, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x55e6651ccdd0}, {pos = 550516259, events = 32642, fd = 1, user_data = 0x0}, {pos = 1696558496, events = 21990, fd = 523777048, user_data = 0x7ffd760e88a0}, {pos = 550545034, events = 32642, fd = 0, user_data = 0x0}, {pos = 1980664000, events = 32765, fd = 1675676544, user_data = 0x2}, {pos = 1675676544, events = 21990, fd = 0, user_data = 0x7f821f54dbe0}, {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 = 1696553400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x706d742f0a343330}, {pos = 1600614447, events = 1919378802, fd = 762540901, user_data = 0x362020200a0a4f77}, {pos = 822763892, events = 942682423, fd = 960051256, user_data = 0x656d65746174735f}, {pos = 796095598, events = 1919378802, fd = 1768107379, user_data = 0x646c6975622f646c}, {pos = 943272503, events = 538976312, fd = 859189536, 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 = 525637760, user_data = 0x7f821f3fc51a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = 524295163, user_data = 0x400}, {pos = 1696374768, events = 21990, fd = 525640832, user_data = 0x1651c9ff0}, {pos = 784, events = 0, fd = 1665741580, user_data = 0x55e6651f6990}, {pos = 1472380160, events = 2138368669, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1696557456, events = 21990, fd = 1696557456, user_data = 0x55e6651f6990}, {pos = 1, events = 0, fd = 1696557656, user_data = 0x400}, {pos = 0, events = 0, fd = 1663543946, user_data = 0x55e663e1ad70 }, {pos = 1663477622, events = 21990, fd = 1696557456, user_data = 0x55e6651cc1c0}, {pos = 1696557456, events = 21990, fd = 15, user_data = 0x4a}, {pos = 1663545714, events = 21990, fd = 1696557456, user_data = 0x55e66327b2b4 }, {pos = 1696374768, events = 21990, fd = 524295163, user_data = 0x0}, {pos = 1657022166, events = 21990, fd = 1696548848, user_data = 0x7f821f3fe1aa}, {pos = 1980664152, events = 1, fd = 0, user_data = 0x7f821f3fc8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 37106, user_data = 0x7f821f446b05 }, {pos = 0, events = 0, fd = 1472380160, user_data = 0x0}, {pos = 1658974763, events = 21990, fd = 4194304, user_data = 0x55e66326a60a }, {pos = 1696548848, events = 21990, fd = 1696383424, user_data = 0x55e6651f47f0}, {pos = 1, events = 0, fd = 0, user_data = 0x55e66327b172 }, {pos = 1696548848, events = 21990, fd = 1663546036, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55e662c422a9 }, {pos = 0, events = 0, fd = 1657045119, user_data = 0xb}, {pos = 1658996238, events = 21990, fd = 0, user_data = 0x0}} [22:59:34.400] nevents = 1 [22:59:34.400] __func__ = "ServerLoop" [22:59:34.400] #16 0x000055e662e2768c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55e6651c5ea0) at ../src/backend/postmaster/postmaster.c:1372 [22:59:34.400] opt = [22:59:34.400] status = [22:59:34.400] userDoption = [22:59:34.400] listen_addr_saved = false [22:59:34.400] output_config_variable = [22:59:34.400] __func__ = "PostmasterMain" [22:59:34.400] #17 0x000055e662c530d9 in main (argc=8, argv=0x55e6651c5ea0) at ../src/backend/main/main.c:197 [22:59:34.400] do_check_root = [22:59:34.416] -e [22:59:34.416] [22:59:34.416] [22:59:34.958] dumping /tmp/cores/postgres-11-37437.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:59:35.250] [New LWP 37437] [22:59:36.370] [Thread debugging using libthread_db enabled] [22:59:36.370] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:59:38.431] Downloading separate debug info for /lib/x86_64-linux-gnu/libnss_files.so.2... [22:59:38.931] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN '. [22:59:38.931] Program terminated with signal SIGSEGV, Segmentation fault. [22:59:38.931] #0 0x00005600a6aa2926 in equal (a=0xffffffffa8020268, b=b@entry=0x5600a810f5b8) at ../src/backend/nodes/equalfuncs.c:239 [22:59:38.931] 239 if (nodeTag(a) != nodeTag(b)) [22:59:39.085] [22:59:39.085] Thread 1 (Thread 0x7fe8f4eb3a40 (LWP 37437)): [22:59:39.085] #0 0x00005600a6aa2926 in equal (a=0xffffffffa8020268, b=b@entry=0x5600a810f5b8) at ../src/backend/nodes/equalfuncs.c:239 [22:59:39.085] retval = [22:59:39.085] __func__ = "equal" [22:59:39.085] #1 0x00005600a63e1404 in list_member (list=0x5600a80202d8, datum=datum@entry=0x5600a810f5b8) at ../src/backend/nodes/list.c:670 [22:59:39.085] cell__state = {l = , i = } [22:59:39.085] cell = [22:59:39.085] #2 0x00005600a6504e0a in add_new_column_to_pathtarget (target=target@entry=0x5600a80201f8, expr=0x5600a810f5b8) at ../src/backend/optimizer/util/tlist.c:743 [22:59:39.085] No locals. [22:59:39.085] #3 0x00005600a6504ea5 in add_new_columns_to_pathtarget (target=target@entry=0x5600a80201f8, exprs=exprs@entry=0x5600a8020378) at ../src/backend/optimizer/util/tlist.c:760 [22:59:39.085] expr = [22:59:39.085] lc__state = {l = , i = } [22:59:39.085] lc = [22:59:39.085] #4 0x00005600a647d2fd in make_group_input_target (root=root@entry=0x5600a810eec8, final_target=final_target@entry=0x5600a8020158) at ../src/backend/optimizer/plan/planner.c:5472 [22:59:39.085] parse = 0x5600a7fcb920 [22:59:39.085] input_target = 0x5600a80201f8 [22:59:39.085] non_group_cols = 0x5600a8020328 [22:59:39.085] non_group_vars = 0x5600a8020378 [22:59:39.085] i = 2 [22:59:39.085] lc = 0x0 [22:59:39.085] #5 0x00005600a64906bf in grouping_planner (root=root@entry=0x5600a810eec8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:59:39.085] sort_input_targets = 0x5600a810f3e8 [22:59:39.085] sort_input_target_parallel_safe = true [22:59:39.085] grouping_target = 0x5600a8020158 [22:59:39.085] scanjoin_target = [22:59:39.085] activeWindows = 0x0 [22:59:39.085] qp_extra = {activeWindows = 0x0, gset_data = 0x5600a80fe758} [22:59:39.085] sort_input_targets_contain_srfs = 0x5600a80fe6b8 [22:59:39.085] have_grouping = [22:59:39.085] wflists = 0x0 [22:59:39.085] gset_data = 0x5600a80fe758 [22:59:39.085] sort_input_target = 0x5600a8020158 [22:59:39.085] grouping_targets = 0x5600a810eec8 [22:59:39.085] grouping_target_parallel_safe = true [22:59:39.085] scanjoin_targets = 0x1 [22:59:39.085] scanjoin_target_parallel_safe = [22:59:39.085] grouping_targets_contain_srfs = 0x5600a6a05976 [22:59:39.085] scanjoin_targets_contain_srfs = 0x5600a63e01ff [22:59:39.085] scanjoin_target_same_exprs = [22:59:39.085] parse = 0x5600a7fcb920 [22:59:39.085] offset_est = 0 [22:59:39.085] count_est = 0 [22:59:39.085] limit_tuples = -1 [22:59:39.085] have_postponed_srfs = false [22:59:39.085] final_target = 0x5600a8020158 [22:59:39.085] final_targets = 0x5600a80f2d58 [22:59:39.085] final_targets_contain_srfs = 0x5600a63e6189 [22:59:39.085] final_target_parallel_safe = true [22:59:39.085] current_rel = 0x5600a80f6b68 [22:59:39.085] final_rel = [22:59:39.085] extra = {limit_needed = false, limit_tuples = 4.6719237323459449e-310, count_est = 94560819603128, offset_est = 94560819603128} [22:59:39.085] lc = [22:59:39.085] __func__ = "grouping_planner" [22:59:39.085] #6 0x00005600a6493563 in subquery_planner (glob=glob@entry=0x5600a80f6a58, parse=parse@entry=0x5600a7fcb920, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:59:39.085] root = 0x5600a810eec8 [22:59:39.085] newWithCheckOptions = [22:59:39.085] newHaving = 0x0 [22:59:39.085] hasOuterJoins = [22:59:39.085] hasResultRTEs = false [22:59:39.085] final_rel = [22:59:39.085] l = 0x0 [22:59:39.085] #7 0x00005600a64941b8 in standard_planner (parse=0x5600a7fcb920, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [22:59:39.085] result = [22:59:39.085] glob = 0x5600a80f6a58 [22:59:39.085] tuple_fraction = 0 [22:59:39.085] root = [22:59:39.085] final_rel = [22:59:39.085] best_path = [22:59:39.085] top_plan = [22:59:39.085] lp = [22:59:39.085] lr = [22:59:39.085] #8 0x00005600a649527c in planner (parse=parse@entry=0x5600a7fcb920, query_string=query_string@entry=0x5600a7fca270 "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 [22:59:39.085] result = [22:59:39.085] #9 0x00005600a6703eda in pg_plan_query (querytree=querytree@entry=0x5600a7fcb920, query_string=query_string@entry=0x5600a7fca270 "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 [22:59:39.085] plan = [22:59:39.085] #10 0x00005600a61f3d74 in standard_ExplainOneQuery (query=0x5600a7fcb920, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5600a811ca18, queryString=0x5600a7fca270 "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 [22:59:39.085] plan = [22:59:39.085] planstart = {ticks = } [22:59:39.085] planduration = {ticks = 94560818346272} [22:59:39.085] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94560784446296, shared_blks_dirtied = 94560818346544, shared_blks_written = 70368744194107, local_blks_hit = 0, local_blks_read = 94560785768977, local_blks_dirtied = 94560818346544, local_blks_written = 94560791604388, temp_blks_read = 1, temp_blks_written = 2048, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94557999988736}, local_blk_read_time = {ticks = 94560818346000}, local_blk_write_time = {ticks = 94560795515254}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94560789070335}} [22:59:39.085] bufusage = {shared_blks_hit = 94560819571128, shared_blks_read = 1, shared_blks_dirtied = 0, shared_blks_written = 1, local_blks_hit = 0, local_blks_read = 94560792125565, local_blks_dirtied = 70622147264512, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 16443, shared_blk_read_time = {ticks = 140638364977128}, shared_blk_write_time = {ticks = 94560819571128}, local_blk_read_time = {ticks = 94560818346272}, local_blk_write_time = {ticks = 94560795032907}, temp_blk_read_time = {ticks = 140638364977128}, temp_blk_write_time = {ticks = 94560795032926}} [22:59:39.085] mem_counters = {nblocks = 0, freechunks = 1, totalspace = 0, freespace = 94560795256345} [22:59:39.085] planner_ctx = 0x0 [22:59:39.085] saved_ctx = 0x0 [22:59:39.085] #11 0x00005600a61f400c in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5600a811ca18, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:396 [22:59:39.085] No locals. [22:59:39.085] #12 0x00005600a61f5603 in ExplainQuery (pstate=pstate@entry=0x5600a811c908, stmt=stmt@entry=0x5600a7fcb760, params=params@entry=0x0, dest=dest@entry=0x5600a811c878) at ../src/include/nodes/nodes.h:172 [22:59:39.085] l__state = {l = , i = } [22:59:39.085] l = 0x5600a80f6a20 [22:59:39.085] es = 0x5600a811ca18 [22:59:39.085] tstate = [22:59:39.085] jstate = [22:59:39.085] query = [22:59:39.085] rewritten = 0x5600a80f6a08 [22:59:39.085] lc = 0x0 [22:59:39.085] timing_set = false [22:59:39.085] summary_set = false [22:59:39.085] __func__ = "ExplainQuery" [22:59:39.085] #13 0x00005600a670e8e8 in standard_ProcessUtility (pstmt=0x5600a7fcb810, queryString=0x5600a7fca270 "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=0x5600a811c878, qc=0x7fffc66990e0) at ../src/backend/tcop/utility.c:863 [22:59:39.085] parsetree = 0x5600a7fcb760 [22:59:39.085] isTopLevel = true [22:59:39.085] isAtomicContext = false [22:59:39.085] pstate = 0x5600a811c908 [22:59:39.085] readonly_flags = [22:59:39.085] __func__ = "standard_ProcessUtility" [22:59:39.085] #14 0x00005600a670f011 in ProcessUtility (pstmt=pstmt@entry=0x5600a7fcb810, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5600a811c878, qc=0x7fffc66990e0) at ../src/backend/tcop/utility.c:523 [22:59:39.085] No locals. [22:59:39.085] #15 0x00005600a670a76f in PortalRunUtility (portal=portal@entry=0x5600a8046f90, pstmt=0x5600a7fcb810, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5600a811c878, qc=qc@entry=0x7fffc66990e0) at ../src/backend/tcop/pquery.c:1158 [22:59:39.085] No locals. [22:59:39.085] #16 0x00005600a670b152 in FillPortalStore (portal=portal@entry=0x5600a8046f90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [22:59:39.085] treceiver = 0x5600a811c878 [22:59:39.085] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:59:39.085] __func__ = "FillPortalStore" [22:59:39.085] #17 0x00005600a670b7d4 in PortalRun (portal=portal@entry=0x5600a8046f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5600a80f3118, altdest=altdest@entry=0x5600a80f3118, qc=0x7fffc66992c0) at ../src/backend/tcop/pquery.c:763 [22:59:39.085] _save_exception_stack = 0x7fffc6699370 [22:59:39.085] _save_context_stack = 0x0 [22:59:39.085] _local_sigjmp_buf = {{__jmpbuf = {1, -3145554432972955818, 94560819556632, 94560818345944, 94560818851728, 94560818345872, 3145538096324271958, 8672228681450512214}, __mask_was_saved = 0, __saved_mask = {__val = {94560818863288, 94560798237726, 94560818859936, 94560798237726, 1, 140736522195535, 94560818345920, 94560818345872, 94560795256345, 94560797825961, 94560818851728, 94560798237726, 1, 1, 94560795515656, 153}}}} [22:59:39.085] _do_rethrow = [22:59:39.085] result = [22:59:39.085] nprocessed = [22:59:39.085] saveTopTransactionResourceOwner = 0x5600a8005c58 [22:59:39.085] saveTopTransactionContext = 0x5600a7ff2b80 [22:59:39.085] saveActivePortal = 0x0 [22:59:39.085] saveResourceOwner = 0x5600a8005c58 [22:59:39.085] savePortalContext = 0x0 [22:59:39.085] saveMemoryContext = 0x5600a7ff2b80 [22:59:39.085] __func__ = "PortalRun" [22:59:39.085] #18 0x00005600a6704769 in exec_simple_query (query_string=query_string@entry=0x5600a7fca270 "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 [22:59:39.085] cmdtaglen = 7 [22:59:39.085] snapshot_set = [22:59:39.085] per_parsetree_context = 0x0 [22:59:39.085] plantree_list = 0x5600a80f30c8 [22:59:39.085] parsetree = 0x5600a7fcb790 [22:59:39.085] commandTag = [22:59:39.085] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:59:39.085] querytree_list = [22:59:39.085] portal = 0x5600a8046f90 [22:59:39.085] receiver = 0x5600a80f3118 [22:59:39.085] format = 0 [22:59:39.085] cmdtagname = [22:59:39.085] parsetree_item__state = {l = , i = } [22:59:39.085] dest = DestRemote [22:59:39.085] oldcontext = 0x5600a7ff2b80 [22:59:39.085] parsetree_list = 0x5600a7fcb7c0 [22:59:39.085] parsetree_item = 0x5600a7fcb7d8 [22:59:39.085] save_log_statement_stats = false [22:59:39.085] was_logged = false [22:59:39.085] use_implicit_block = false [22:59:39.085] msec_str = " \225i\306\377\177\000\000e=\235\246\000V\000\000P\223i\306\377\177\000\000q\000\000\000\000\000\000" [22:59:39.085] __func__ = "exec_simple_query" [22:59:39.085] #19 0x00005600a6707521 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [22:59:39.085] query_string = 0x5600a7fca270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [22:59:39.085] firstchar = [22:59:39.085] input_message = {data = 0x5600a7fca270 "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} [22:59:39.085] local_sigjmp_buf = {{__jmpbuf = {94560807697848, 8672226838686064470, 4, 140736522196256, 140736522196404, 1, 3145538096387186518, 8672228675342163798}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140638558789092, 94560818315008, 15616, 15680, 94560795427046, 94560807697856, 94560818315008, 94560807691928, 140736522196256, 140736522196404, 94560795431114, 140736522196032}}}} [22:59:39.085] send_ready_for_query = false [22:59:39.085] idle_in_transaction_timeout_enabled = false [22:59:39.085] idle_session_timeout_enabled = false [22:59:39.085] __func__ = "PostgresMain" [22:59:39.085] #20 0x00005600a66fdcd8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:59:39.085] bsdata = [22:59:39.085] #21 0x00005600a65a853c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffc66994cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffc6699520) at ../src/backend/postmaster/launch_backend.c:267 [22:59:39.085] pid = [22:59:39.085] #22 0x00005600a65ae6bc in BackendStartup (client_sock=client_sock@entry=0x7fffc6699520) at ../src/backend/postmaster/postmaster.c:3593 [22:59:39.085] bn = 0x5600a7ff2c58 [22:59:39.085] pid = [22:59:39.085] startup_data = {canAcceptConnections = CAC_OK} [22:59:39.085] __func__ = "BackendStartup" [22:59:39.085] #23 0x00005600a65aec6a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:59:39.085] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "O\367\350\177\000\000 )\037\370\350\177\000\000ȕi\306\377\177\000\000ĕi\306\377\177\000\000\000\000\000\000\377\177\000\000@\316\356\364\350\177\000\000\000\000\000\000\377\177\000\000\020^O\367\350\177\000\000\340\177N\367\350\177\000\000\352\277k\367\350\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000ĕi\306\377\177\000\000@\316\356\364\350\177\000\000\220\226i\306\377\177\000", __ss_align = 140638560162592}, salen = 2}} [22:59:39.085] i = 0 [22:59:39.085] now = [22:59:39.085] last_lockfile_recheck_time = 1710888999 [22:59:39.085] last_touch_time = 1710888999 [22:59:39.085] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = -132175992, events = 32744, fd = -143933462, user_data = 0x7fffc6699728}, {pos = -966158720, events = 32767, fd = -966158704, user_data = 0x7fe8f8e63ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -185887208, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fe8f81f2420}, {pos = -1, events = 0, fd = -185887208, user_data = 0x7fe8f81f2420}, {pos = -132175584, events = 1, fd = -132175992, user_data = 0x0}, {pos = -966158720, events = 32767, fd = 1024, user_data = 0xffffffff}, {pos = -966158432, events = 32767, fd = -145849320, user_data = 0x7fe8f81f2920}, {pos = -1476428776, events = 22016, fd = -1476438248, user_data = 0x5600a7fefa00}, {pos = -1476428744, events = 22016, fd = -1476428943, user_data = 0x7fe8f8e68623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = -143830792, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = -1476607936, events = 22016, fd = -119110109, user_data = 0x1}, {pos = 0, events = 0, fd = -1476462080, user_data = 0x7fe8f74e8418}, {pos = -966157584, events = 32767, fd = -119081334, user_data = 0x0}, {pos = 0, events = 0, fd = -966157552, user_data = 0x5600a7595b80 }, {pos = 2, events = 0, fd = -1487316096, user_data = 0x0}, {pos = -145322586, events = 32744, fd = -1476404256, user_data = 0x7fe8f76b2be0}, {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 = 0xffff0000ffffff00}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -16777216, events = 4294967295, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1735684975, events = 1601398130, fd = 796353638, user_data = 0x2d7375727269632f}, {pos = 1647143267, events = 1684826485, fd = 1179350105, user_data = 0x2031313033383620}, {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 = 0x5600a7fc7fa0}, {pos = -1476624480, events = 22016, fd = -143988608, user_data = 0x7fe8f756151a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -145331205, user_data = 0x400}, {pos = -1476624480, events = 22016, fd = -143985536, user_data = 0x1a7fc7fa0}, {pos = 784, events = 0, fd = -1497251060, 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 = 0x5600a69f34cf }, {pos = -1476439056, events = 22016, fd = -1476439056, user_data = 0x5600a7ff53f0}, {pos = 1, events = 0, fd = -1476438856, user_data = 0x400}, {pos = 0, events = 0, fd = -1499448694, user_data = 0x5600a75a3d70 }, {pos = -1499515018, events = 22016, fd = -1476439056, user_data = 0x5600a7fca170}, {pos = -1476439056, events = 22016, fd = 15, user_data = 0x4a}, {pos = -1499446926, events = 22016, fd = -1476439056, user_data = 0x5600a6a042b4 }, {pos = -1476624480, events = 22016, fd = -145331205, user_data = 0x0}, {pos = -1505970474, events = 22016, fd = -1476450448, user_data = 0x7fe8f75631aa}, {pos = -966157400, events = 1, fd = 0, user_data = 0x7fe8f75618f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 37310, user_data = 0x7fe8f75abb05 }, {pos = 0, events = 0, fd = -1743110912, user_data = 0x0}, {pos = -1504017877, events = 22016, fd = 4194304, user_data = 0x5600a69f360a }, {pos = -1476450448, events = 22016, fd = -1476615824, user_data = 0x5600a7ff2770}, {pos = 1, events = 0, fd = 0, user_data = 0x5600a6a04172 }, {pos = -1476450448, events = 22016, fd = -1499446604, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5600a63cb2a9 }, {pos = 0, events = 0, fd = -1505947521, user_data = 0xb}, {pos = -1503996402, events = 22016, fd = 0, user_data = 0x0}} [22:59:39.086] nevents = 1 [22:59:39.086] __func__ = "ServerLoop" [22:59:39.086] #24 0x00005600a65b068c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5600a7fc3e60) at ../src/backend/postmaster/postmaster.c:1372 [22:59:39.086] opt = [22:59:39.086] status = [22:59:39.086] userDoption = [22:59:39.086] listen_addr_saved = false [22:59:39.086] output_config_variable = [22:59:39.086] __func__ = "PostmasterMain" [22:59:39.086] #25 0x00005600a63dc0d9 in main (argc=8, argv=0x5600a7fc3e60) at ../src/backend/main/main.c:197 [22:59:39.086] do_check_root = [22:59:39.102] -e [22:59:39.102] [22:59:39.102] [22:59:39.638] dumping /tmp/cores/postgres-11-27327.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:59:39.939] [New LWP 27327] [22:59:41.057] [Thread debugging using libthread_db enabled] [22:59:41.057] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:59:42.454] Core was generated by `postgres: postgres regression [local] SELECT '. [22:59:42.454] Program terminated with signal SIGSEGV, Segmentation fault. [22:59:42.454] #0 0x00005593e3fde926 in equal (a=0xffffffffe4c7cb08, b=b@entry=0x5593e4c79908) at ../src/backend/nodes/equalfuncs.c:239 [22:59:42.454] 239 if (nodeTag(a) != nodeTag(b)) [22:59:42.563] [22:59:42.563] Thread 1 (Thread 0x7f52a21e4a40 (LWP 27327)): [22:59:42.563] #0 0x00005593e3fde926 in equal (a=0xffffffffe4c7cb08, b=b@entry=0x5593e4c79908) at ../src/backend/nodes/equalfuncs.c:239 [22:59:42.563] retval = [22:59:42.563] __func__ = "equal" [22:59:42.563] #1 0x00005593e391d404 in list_member (list=0x5593e4c7cb78, datum=datum@entry=0x5593e4c79908) at ../src/backend/nodes/list.c:670 [22:59:42.563] cell__state = {l = , i = } [22:59:42.563] cell = [22:59:42.563] #2 0x00005593e3a40e0a in add_new_column_to_pathtarget (target=target@entry=0x5593e4c7ca98, expr=0x5593e4c79908) at ../src/backend/optimizer/util/tlist.c:743 [22:59:42.563] No locals. [22:59:42.563] #3 0x00005593e3a40ea5 in add_new_columns_to_pathtarget (target=target@entry=0x5593e4c7ca98, exprs=exprs@entry=0x5593e4c7cca8) at ../src/backend/optimizer/util/tlist.c:760 [22:59:42.563] expr = [22:59:42.563] lc__state = {l = , i = } [22:59:42.563] lc = [22:59:42.563] #4 0x00005593e39b92fd in make_group_input_target (root=root@entry=0x5593e4c71b18, final_target=final_target@entry=0x5593e4c7c938) at ../src/backend/optimizer/plan/planner.c:5472 [22:59:42.563] parse = 0x5593e4b49d18 [22:59:42.563] input_target = 0x5593e4c7ca98 [22:59:42.563] non_group_cols = 0x5593e4c7cc58 [22:59:42.563] non_group_vars = 0x5593e4c7cca8 [22:59:42.563] i = 6 [22:59:42.563] lc = 0x0 [22:59:42.563] #5 0x00005593e39cc6bf in grouping_planner (root=root@entry=0x5593e4c71b18, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:59:42.563] sort_input_targets = 0x5593e4c79778 [22:59:42.563] sort_input_target_parallel_safe = true [22:59:42.563] grouping_target = 0x5593e4c7c938 [22:59:42.563] scanjoin_target = [22:59:42.563] activeWindows = 0x0 [22:59:42.563] qp_extra = {activeWindows = 0x0, gset_data = 0x5593e4c7ad98} [22:59:42.563] sort_input_targets_contain_srfs = 0x5593e3a028bd [22:59:42.563] have_grouping = [22:59:42.563] wflists = 0x0 [22:59:42.563] gset_data = 0x5593e4c7ad98 [22:59:42.563] sort_input_target = 0x5593e4c7c938 [22:59:42.563] grouping_targets = 0x0 [22:59:42.563] grouping_target_parallel_safe = true [22:59:42.563] scanjoin_targets = 0x0 [22:59:42.563] scanjoin_target_parallel_safe = [22:59:42.563] grouping_targets_contain_srfs = 0x5593e392abd4 [22:59:42.563] scanjoin_targets_contain_srfs = 0x5593e4c75fe8 [22:59:42.563] scanjoin_target_same_exprs = [22:59:42.563] parse = 0x5593e4b49d18 [22:59:42.563] offset_est = 0 [22:59:42.563] count_est = 0 [22:59:42.563] limit_tuples = -1 [22:59:42.563] have_postponed_srfs = false [22:59:42.563] final_target = 0x5593e4c7c938 [22:59:42.563] final_targets = 0x0 [22:59:42.563] final_targets_contain_srfs = 0x5593e3a08bb4 [22:59:42.563] final_target_parallel_safe = true [22:59:42.563] current_rel = 0x5593e4c71f28 [22:59:42.563] final_rel = [22:59:42.563] extra = {limit_needed = 24, limit_tuples = 1.9762625833649862e-323, count_est = 94093686807320, offset_est = 0} [22:59:42.563] lc = [22:59:42.563] __func__ = "grouping_planner" [22:59:42.563] #6 0x00005593e39cf563 in subquery_planner (glob=glob@entry=0x5593e4b49f88, parse=parse@entry=0x5593e4b49d18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:59:42.563] root = 0x5593e4c71b18 [22:59:42.563] newWithCheckOptions = [22:59:42.563] newHaving = 0x0 [22:59:42.563] hasOuterJoins = [22:59:42.563] hasResultRTEs = false [22:59:42.563] final_rel = [22:59:42.563] l = 0x0 [22:59:42.563] #7 0x00005593e39d01b8 in standard_planner (parse=0x5593e4b49d18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [22:59:42.563] result = [22:59:42.563] glob = 0x5593e4b49f88 [22:59:42.563] tuple_fraction = 0 [22:59:42.563] root = [22:59:42.563] final_rel = [22:59:42.563] best_path = [22:59:42.563] top_plan = [22:59:42.563] lp = [22:59:42.563] lr = [22:59:42.563] #8 0x00005593e39d127c in planner (parse=parse@entry=0x5593e4b49d18, query_string=query_string@entry=0x5593e4b48260 "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 [22:59:42.563] result = [22:59:42.563] #9 0x00005593e3c3feda in pg_plan_query (querytree=querytree@entry=0x5593e4b49d18, query_string=query_string@entry=0x5593e4b48260 "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 [22:59:42.563] plan = [22:59:42.563] #10 0x00005593e3c40247 in pg_plan_queries (querytrees=0x5593e4c76388, query_string=query_string@entry=0x5593e4b48260 "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 [22:59:42.563] query = 0x5593e4b49d18 [22:59:42.563] stmt = [22:59:42.563] query_list__state = {l = , i = } [22:59:42.563] stmt_list = 0x0 [22:59:42.563] query_list = [22:59:42.563] #11 0x00005593e3c40621 in exec_simple_query (query_string=query_string@entry=0x5593e4b48260 "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 [22:59:42.563] cmdtaglen = 6 [22:59:42.563] snapshot_set = true [22:59:42.563] per_parsetree_context = 0x0 [22:59:42.563] plantree_list = [22:59:42.563] parsetree = 0x5593e4b49b88 [22:59:42.563] commandTag = CMDTAG_SELECT [22:59:42.563] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94093685588576} [22:59:42.563] querytree_list = [22:59:42.563] portal = [22:59:42.563] receiver = [22:59:42.563] format = 0 [22:59:42.563] cmdtagname = [22:59:42.563] parsetree_item__state = {l = , i = } [22:59:42.563] dest = DestRemote [22:59:42.563] oldcontext = 0x5593e4b70b70 [22:59:42.563] parsetree_list = 0x5593e4b49bb8 [22:59:42.563] parsetree_item = 0x5593e4b49bd0 [22:59:42.563] save_log_statement_stats = false [22:59:42.563] was_logged = false [22:59:42.563] use_implicit_block = false [22:59:42.563] msec_str = "0\351v\030\374\177\000\000e\375\360\343\223U\000\000`\347v\030\374\177\000\000[\000\000\000\000\000\000" [22:59:42.563] __func__ = "exec_simple_query" [22:59:42.563] #12 0x00005593e3c43521 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [22:59:42.563] query_string = 0x5593e4b48260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [22:59:42.563] firstchar = [22:59:42.563] input_message = {data = 0x5593e4b48260 "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} [22:59:42.563] local_sigjmp_buf = {{__jmpbuf = {94093685161400, -490429135732460831, 4, 140720718932272, 140720718932420, 1, -5913687029259291935, -490422184768032031}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 139992924532196, 94093685563120, 15616, 15680, 94093672890598, 94093685161408, 94093685563120, 94093685155480, 140720718932272, 140720718932420, 94093672894666, 140720718932048}}}} [22:59:42.563] send_ready_for_query = false [22:59:42.563] idle_in_transaction_timeout_enabled = false [22:59:42.563] idle_session_timeout_enabled = false [22:59:42.563] __func__ = "PostgresMain" [22:59:42.563] #13 0x00005593e3c39cd8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:59:42.563] bsdata = [22:59:42.563] #14 0x00005593e3ae453c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc1876e8dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc1876e930) at ../src/backend/postmaster/launch_backend.c:267 [22:59:42.563] pid = [22:59:42.563] #15 0x00005593e3aea6bc in BackendStartup (client_sock=client_sock@entry=0x7ffc1876e930) at ../src/backend/postmaster/postmaster.c:3593 [22:59:42.563] bn = 0x5593e4b70dd8 [22:59:42.563] pid = [22:59:42.563] startup_data = {canAcceptConnections = CAC_OK} [22:59:42.563] __func__ = "BackendStartup" [22:59:42.563] #16 0x00005593e3aeac6a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:59:42.563] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000\210k\201\244R\177\000\000 \243\236\244R\177\000\000\001\000\000\000\000\000\000\000\244C\031\246R\177\000\000-\000\000\000\000\000\000\000\020n\202\244R\177\000\000 9R\245R\177\000\000\b\352v\030\374\177\000\000\004\352v\030\374\177\000\000P9\267\344\223U", '\000' , "\020n\202\244R\177\000\000\340\217\201\244R\177\000", __ss_align = 139992925917162}, salen = 2}} [22:59:42.563] i = 0 [22:59:42.563] now = [22:59:42.563] last_lockfile_recheck_time = 1710888954 [22:59:42.563] last_touch_time = 1710888954 [22:59:42.563] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 410446544, events = 32764, fd = -1533107424, user_data = 0x7ffc1876eac0}, {pos = 45, events = 0, fd = -1508155008, user_data = 0x1876ea90}, {pos = 0, events = 0, fd = -1508155008, user_data = 0x59e7c8ee}, {pos = -1521338488, events = 32594, fd = -1533095958, user_data = 0x7ffc1876eb68}, {pos = 410446528, events = 32764, fd = 410446544, user_data = 0x7f52a6194ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -1575049704, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f52a5523420}, {pos = 410446480, events = 32764, fd = -1575049704, user_data = 0x7f52a5523420}, {pos = -465426272, events = 1, fd = -1521338488, user_data = 0x0}, {pos = -457778704, events = 21907, fd = -457745368, user_data = 0xffffffff}, {pos = -1508272605, events = 32594, fd = -1535011816, user_data = 0x7f52a5523920}, {pos = -457745400, events = 21907, fd = -1534965256, user_data = 0x7ffc1876eeb0}, {pos = -1508243830, events = 32594, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = -1532993288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = -457924560, events = 21907, fd = -1508272605, user_data = 0x1}, {pos = 0, events = 0, fd = -457745576, user_data = 0x7f52a4819418}, {pos = 410447616, events = 32764, fd = -1508243830, user_data = 0x0}, {pos = 0, events = 0, fd = 410447648, user_data = 0x5593e4ad1b80 }, {pos = 2, events = 0, fd = -458417280, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 8096, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x2020206c6c612020}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -457751656, user_data = 0x3ff}, {pos = 4096, events = 0, fd = -457941104, user_data = 0x5593e4b45f90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294901760, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1734701663, events = 1936942450, fd = 2018527277, user_data = 0x667850482d737365}, {pos = 168458094, events = 908075040, fd = 822763892, user_data = 0x30340a3435393838}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x400}, {pos = -457941104, events = 21907, fd = -1533148032, user_data = 0x1e4b45f90}, {pos = 784, events = 0, fd = -468352244, user_data = 0x5593e4b733e0}, {pos = -661005056, events = 3968714731, fd = 4, user_data = 0x5593e4b74360}, {pos = -457755680, events = 21907, fd = -457755480, 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 = -457755480, user_data = 0x400}, {pos = 0, events = 0, fd = -470549878, user_data = 0x5593e4adfd70 }, {pos = -470616202, events = 21907, fd = -457755680, user_data = 0x5593e4b48160}, {pos = -457755680, events = 21907, fd = 15, user_data = 0x4a}, {pos = -470548110, events = 21907, fd = -457755680, user_data = 0x5593e3f402b4 }, {pos = -457941104, events = 21907, fd = -1534493701, user_data = 0x0}, {pos = -477071658, events = 21907, fd = -457767072, user_data = 0x7f52a48941aa}, {pos = 410447800, events = 1, fd = 0, user_data = 0x7f52a48928f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 23625, user_data = 0x7f52a48dcb05 }, {pos = 0, events = 0, fd = -661005056, user_data = 0x0}, {pos = -475119061, events = 21907, fd = 4194304, user_data = 0x5593e3f2f60a }, {pos = -457767072, events = 21907, fd = -457932448, user_data = 0x5593e4b70760}, {pos = 1, events = 0, fd = 0, user_data = 0x5593e3f40172 }, {pos = -457767072, events = 21907, fd = -470547788, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5593e39072a9 }, {pos = 0, events = 0, fd = -477048705, user_data = 0xb}, {pos = -475097586, events = 21907, fd = 0, user_data = 0x0}} [22:59:42.563] nevents = 1 [22:59:42.563] __func__ = "ServerLoop" [22:59:42.563] #17 0x00005593e3aec68c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5593e4b41e50) at ../src/backend/postmaster/postmaster.c:1372 [22:59:42.563] opt = [22:59:42.563] status = [22:59:42.563] userDoption = [22:59:42.563] listen_addr_saved = false [22:59:42.563] output_config_variable = [22:59:42.563] __func__ = "PostmasterMain" [22:59:42.563] #18 0x00005593e39180d9 in main (argc=8, argv=0x5593e4b41e50) at ../src/backend/main/main.c:197 [22:59:42.563] do_check_root = [22:59:42.579] -e [22:59:42.579] [22:59:42.579] [22:59:43.109] dumping /tmp/cores/postgres-11-34100.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:59:43.398] [New LWP 34100] [22:59:44.500] [Thread debugging using libthread_db enabled] [22:59:44.500] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:59:45.905] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [22:59:45.905] Program terminated with signal SIGSEGV, Segmentation fault. [22:59:45.905] #0 0x000055a66e789926 in equal (a=0x6fe5f2d0, b=b@entry=0x55a66fe5bfc8) at ../src/backend/nodes/equalfuncs.c:239 [22:59:45.905] 239 if (nodeTag(a) != nodeTag(b)) [22:59:46.040] [22:59:46.040] Thread 1 (Thread 0x7fbed1df0a40 (LWP 34100)): [22:59:46.040] #0 0x000055a66e789926 in equal (a=0x6fe5f2d0, b=b@entry=0x55a66fe5bfc8) at ../src/backend/nodes/equalfuncs.c:239 [22:59:46.040] retval = [22:59:46.040] __func__ = "equal" [22:59:46.040] #1 0x000055a66e0c8404 in list_member (list=0x55a66fe5f340, datum=datum@entry=0x55a66fe5bfc8) at ../src/backend/nodes/list.c:670 [22:59:46.040] cell__state = {l = , i = } [22:59:46.040] cell = [22:59:46.040] #2 0x000055a66e1ebe0a in add_new_column_to_pathtarget (target=target@entry=0x55a66fe5f260, expr=0x55a66fe5bfc8) at ../src/backend/optimizer/util/tlist.c:743 [22:59:46.040] No locals. [22:59:46.040] #3 0x000055a66e1ebea5 in add_new_columns_to_pathtarget (target=target@entry=0x55a66fe5f260, exprs=exprs@entry=0x55a66fe5f470) at ../src/backend/optimizer/util/tlist.c:760 [22:59:46.040] expr = [22:59:46.040] lc__state = {l = , i = } [22:59:46.040] lc = [22:59:46.040] #4 0x000055a66e1642fd in make_group_input_target (root=root@entry=0x55a66fe59860, final_target=final_target@entry=0x55a66fe5f100) at ../src/backend/optimizer/plan/planner.c:5472 [22:59:46.040] parse = 0x55a66fd3ad48 [22:59:46.040] input_target = 0x55a66fe5f260 [22:59:46.040] non_group_cols = 0x55a66fe5f420 [22:59:46.040] non_group_vars = 0x55a66fe5f470 [22:59:46.040] i = 6 [22:59:46.040] lc = 0x0 [22:59:46.040] #5 0x000055a66e1776bf in grouping_planner (root=root@entry=0x55a66fe59860, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [22:59:46.040] sort_input_targets = 0x55a66fe5be38 [22:59:46.040] sort_input_target_parallel_safe = true [22:59:46.040] grouping_target = 0x55a66fe5f100 [22:59:46.040] scanjoin_target = [22:59:46.040] activeWindows = 0x0 [22:59:46.040] qp_extra = {activeWindows = 0x0, gset_data = 0x55a66fe5d498} [22:59:46.040] sort_input_targets_contain_srfs = 0x55a66e1ad8bd [22:59:46.040] have_grouping = [22:59:46.040] wflists = 0x0 [22:59:46.040] gset_data = 0x55a66fe5d498 [22:59:46.040] sort_input_target = 0x55a66fe5f100 [22:59:46.040] grouping_targets = 0x0 [22:59:46.040] grouping_target_parallel_safe = true [22:59:46.040] scanjoin_targets = 0x0 [22:59:46.040] scanjoin_target_parallel_safe = [22:59:46.040] grouping_targets_contain_srfs = 0x55a66e0d5bd4 [22:59:46.040] scanjoin_targets_contain_srfs = 0x55a66fe58248 [22:59:46.040] scanjoin_target_same_exprs = [22:59:46.040] parse = 0x55a66fd3ad48 [22:59:46.040] offset_est = 0 [22:59:46.040] count_est = 0 [22:59:46.040] limit_tuples = -1 [22:59:46.040] have_postponed_srfs = false [22:59:46.040] final_target = 0x55a66fe5f100 [22:59:46.040] final_targets = 0x0 [22:59:46.040] final_targets_contain_srfs = 0x55a66e1b3bb4 [22:59:46.040] final_target_parallel_safe = true [22:59:46.040] current_rel = 0x55a66fe54188 [22:59:46.040] final_rel = [22:59:46.040] extra = {limit_needed = 96, limit_tuples = 1.9762625833649862e-323, count_est = 94173330249824, offset_est = 0} [22:59:46.040] lc = [22:59:46.040] __func__ = "grouping_planner" [22:59:46.040] #6 0x000055a66e17a563 in subquery_planner (glob=glob@entry=0x55a66fe4a9b8, parse=parse@entry=0x55a66fd3ad48, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [22:59:46.040] root = 0x55a66fe59860 [22:59:46.040] newWithCheckOptions = [22:59:46.040] newHaving = 0x0 [22:59:46.040] hasOuterJoins = [22:59:46.040] hasResultRTEs = false [22:59:46.040] final_rel = [22:59:46.040] l = 0x0 [22:59:46.040] #7 0x000055a66e17b1b8 in standard_planner (parse=parse@entry=0x55a66fd3ad48, query_string=query_string@entry=0x55a66fd39290 "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 [22:59:46.040] result = [22:59:46.040] glob = 0x55a66fe4a9b8 [22:59:46.040] tuple_fraction = 0 [22:59:46.040] root = [22:59:46.040] final_rel = [22:59:46.040] best_path = [22:59:46.040] top_plan = [22:59:46.040] lp = [22:59:46.040] lr = [22:59:46.040] #8 0x00007fbed1c1d73e in pgss_planner (parse=0x55a66fd3ad48, query_string=0x55a66fd39290 "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 [22:59:46.040] _save_exception_stack = 0x7ffc7856f9e0 [22:59:46.040] _save_context_stack = 0x0 [22:59:46.040] _local_sigjmp_buf = {{__jmpbuf = {94173329075528, 3866908988965541315, 0, 2048, 0, 94173329068688, 6998077282756482499, 7033348388557968835}, __mask_was_saved = 0, __saved_mask = {__val = {70368744203428, 1, 94173295940113, 1, 94173301775524, 1, 94173330245176, 0, 0, 0, 94173305686390, 0, 94173299241471, 0, 94173329075528, 0}}}} [22:59:46.040] _do_rethrow = false [22:59:46.040] result = 0x7ffc7856f750 [22:59:46.040] #9 0x000055a66e17c272 in planner (parse=parse@entry=0x55a66fd3ad48, query_string=query_string@entry=0x55a66fd39290 "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 [22:59:46.040] result = [22:59:46.040] #10 0x000055a66e3eaeda in pg_plan_query (querytree=querytree@entry=0x55a66fd3ad48, query_string=query_string@entry=0x55a66fd39290 "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 [22:59:46.040] plan = [22:59:46.040] #11 0x000055a66e3eb247 in pg_plan_queries (querytrees=0x55a66fe58638, query_string=query_string@entry=0x55a66fd39290 "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 [22:59:46.040] query = 0x55a66fd3ad48 [22:59:46.040] stmt = [22:59:46.040] query_list__state = {l = , i = } [22:59:46.040] stmt_list = 0x0 [22:59:46.040] query_list = [22:59:46.040] #12 0x000055a66e3eb621 in exec_simple_query (query_string=query_string@entry=0x55a66fd39290 "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 [22:59:46.040] cmdtaglen = 6 [22:59:46.040] snapshot_set = true [22:59:46.040] per_parsetree_context = 0x0 [22:59:46.040] plantree_list = [22:59:46.040] parsetree = 0x55a66fd3abb8 [22:59:46.040] commandTag = CMDTAG_SELECT [22:59:46.040] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94173329068688} [22:59:46.040] querytree_list = [22:59:46.040] portal = [22:59:46.040] receiver = [22:59:46.040] format = 0 [22:59:46.040] cmdtagname = [22:59:46.040] parsetree_item__state = {l = , i = } [22:59:46.040] dest = DestRemote [22:59:46.040] oldcontext = 0x55a66fd65880 [22:59:46.040] parsetree_list = 0x55a66fd3abe8 [22:59:46.040] parsetree_item = 0x55a66fd3ac00 [22:59:46.040] save_log_statement_stats = false [22:59:46.040] was_logged = true [22:59:46.040] use_implicit_block = false [22:59:46.040] msec_str = "\220\373Vx\374\177\000\000e\255kn\246U\000\000\300\371Vx\374\177\000\000[\000\000\000\000\000\000" [22:59:46.040] __func__ = "exec_simple_query" [22:59:46.040] #13 0x000055a66e3ee521 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [22:59:46.040] query_string = 0x55a66fd39290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [22:59:46.040] firstchar = [22:59:46.040] input_message = {data = 0x55a66fd39290 "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} [22:59:46.040] local_sigjmp_buf = {{__jmpbuf = {94173317868984, 3866908498443785667, 4, 140722327452560, 140722327452708, 1, 6998077282605487555, 3866910816094279107}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94173329043264, 16384, 8248, 94173305599889, 0, 0, 0, 94173317868992, 94173329043264, 94173317863064, 140722327452560, 140722327452708, 1, 94173305602939, 140722327452336}}}} [22:59:46.040] send_ready_for_query = false [22:59:46.040] idle_in_transaction_timeout_enabled = false [22:59:46.040] idle_session_timeout_enabled = false [22:59:46.040] __func__ = "PostgresMain" [22:59:46.040] #14 0x000055a66e3e4cd8 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:101 [22:59:46.040] bsdata = [22:59:46.040] #15 0x000055a66e28f53c in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc7856fb3c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc7856fb90) at ../src/backend/postmaster/launch_backend.c:267 [22:59:46.040] pid = [22:59:46.040] #16 0x000055a66e2956bc in BackendStartup (client_sock=client_sock@entry=0x7ffc7856fb90) at ../src/backend/postmaster/postmaster.c:3593 [22:59:46.040] bn = 0x55a66fd65e08 [22:59:46.040] pid = [22:59:46.040] startup_data = {canAcceptConnections = CAC_OK} [22:59:46.040] __func__ = "BackendStartup" [22:59:46.040] #17 0x000055a66e295c6a in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [22:59:46.040] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\332վ\177\000\000-\000\000\000\000\000\000\000\020.CԾ\177\000\000 \371\022վ\177\000\000H\374Vx\374\177\000\000D\374Vx\374\177\000\000\004\374Vx\374\177\000\000\340\064\326o\246U\000\000\000\000\000\000\374\177\000\000\020.CԾ\177\000\000\340OBԾ\177\000\000\352\217_Ծ\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000D\374Vx\374\177\000", __ss_align = 94173329241312}, salen = 2}} [22:59:46.040] i = 0 [22:59:46.040] now = [22:59:46.040] last_lockfile_recheck_time = 1710888978 [22:59:46.040] last_touch_time = 1710888978 [22:59:46.040] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 2018966720, events = 32764, fd = 2018966736, user_data = 0x0}, {pos = 18, events = 0, fd = 1508362478, user_data = 0x7fbed512f788}, {pos = -731934742, events = 32702, fd = 2018966952, user_data = 0x7ffc7856fd00}, {pos = 2018966800, events = 32764, fd = -707130143, user_data = 0x12}, {pos = -773888488, events = 32702, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -720178144, user_data = 0xffffffff}, {pos = -773888488, events = 32702, fd = -720178144, user_data = 0x1d512f920}, {pos = -720177272, events = 32702, fd = 0, user_data = 0x7ffc7856fe1e}, {pos = 2018967056, events = 32764, fd = -1, user_data = 0x7ffc7856fd20}, {pos = -733850600, events = 32702, fd = -720176864, user_data = 0x55a66fd69548}, {pos = 1876333528, events = 21926, fd = 1876314976, user_data = 0x55a66fd69568}, {pos = 1876332689, events = 21926, fd = -707111389, user_data = 0x1}, {pos = -731832072, events = 32702, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x55a66fd3b0f0}, {pos = -707111389, events = 32702, fd = 1, user_data = 0x0}, {pos = 1876314976, events = 21926, fd = -733850600, user_data = 0x7ffc78570160}, {pos = -707082614, events = 32702, fd = 0, user_data = 0x0}, {pos = 2018967936, events = 32764, fd = 1864878976, user_data = 0x2}, {pos = 1864878976, events = 21926, fd = 0, user_data = 0x7fbed45efbe0}, {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 = 1876355400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -731989888, user_data = 0x7fbed449e51a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -733332485, user_data = 0x400}, {pos = 1876127712, events = 21926, fd = -731986816, user_data = 0x16fd36fe0}, {pos = 784, events = 0, fd = 1854944012, user_data = 0x55a66fd690b0}, {pos = -880548864, events = 1145942807, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1876332720, events = 21926, fd = 1876332720, user_data = 0x55a66fd690b0}, {pos = 1, events = 0, fd = 1876332920, user_data = 0x400}, {pos = 0, events = 0, fd = 1852746378, user_data = 0x55a66f28ad70 }, {pos = 1852680054, events = 21926, fd = 1876332720, user_data = 0x55a66fd39190}, {pos = 1876332720, events = 21926, fd = 15, user_data = 0x4a}, {pos = 1852748146, events = 21926, fd = 1876332720, user_data = 0x55a66e6eb2b4 }, {pos = 1876127712, events = 21926, fd = -733332178, user_data = 0x0}, {pos = 1846224598, events = 21926, fd = 1876306880, user_data = 0x7fbed44a01aa}, {pos = 2018968088, events = 1, fd = 0, user_data = 0x7fbed449e8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 30485, user_data = 0x7fbed44e8b05 }, {pos = 0, events = 0, fd = -880548864, user_data = 0x0}, {pos = 1848177195, events = 21926, fd = 4194304, user_data = 0x55a66e6da60a }, {pos = 1876306880, events = 21926, fd = 1876136336, user_data = 0x55a66fd62bc0}, {pos = 1, events = 0, fd = 0, user_data = 0x55a66e6eb172 }, {pos = 1876306880, events = 21926, fd = 1852748468, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55a66e0b22a9 }, {pos = 0, events = 0, fd = 1846247551, user_data = 0xb}, {pos = 1848198670, events = 21926, fd = 0, user_data = 0x0}} [22:59:46.040] nevents = 1 [22:59:46.040] __func__ = "ServerLoop" [22:59:46.040] #18 0x000055a66e29768c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a66fd32e40) at ../src/backend/postmaster/postmaster.c:1372 [22:59:46.040] opt = [22:59:46.040] status = [22:59:46.040] userDoption = [22:59:46.040] listen_addr_saved = false [22:59:46.040] output_config_variable = [22:59:46.040] __func__ = "PostmasterMain" [22:59:46.040] #19 0x000055a66e0c30d9 in main (argc=4, argv=0x55a66fd32e40) at ../src/backend/main/main.c:197 [22:59:46.040] do_check_root =