[23:18:37.674] src/tools/ci/cores_backtrace.sh linux /tmp/cores [23:18:38.396] dumping /tmp/cores/postgres-11-33788.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:18:40.091] [New LWP 33788] [23:18:40.091] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [23:18:40.872] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [23:18:41.654] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [23:18:42.911] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [23:18:45.288] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [23:18:46.055] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [23:18:47.289] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [23:18:48.896] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [23:18:50.296] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [23:18:51.202] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [23:18:52.729] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [23:18:54.120] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [23:18:54.591] [Thread debugging using libthread_db enabled] [23:18:54.591] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:18:55.656] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [23:18:57.042] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [23:18:58.101] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [23:18:58.715] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [23:18:59.477] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [23:19:01.757] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [23:19:02.670] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [23:19:03.430] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [23:19:04.338] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [23:19:05.247] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [23:19:06.835] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [23:19:07.893] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [23:19:08.682] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [23:19:10.087] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [23:19:10.704] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [23:19:12.230] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [23:19:12.994] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [23:19:14.875] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [23:19:16.519] Core was generated by `postgres: primary: postgres regression [local] SELECT '. [23:19:16.519] Program terminated with signal SIGSEGV, Segmentation fault. [23:19:16.519] #0 0x0000562d02ae7145 in equal (a=0x475a550, b=b@entry=0x562d04757248) at ../src/backend/nodes/equalfuncs.c:239 [23:19:16.519] 239 if (nodeTag(a) != nodeTag(b)) [23:19:16.659] [23:19:16.659] Thread 1 (Thread 0x7f186a4e7a40 (LWP 33788)): [23:19:16.659] #0 0x0000562d02ae7145 in equal (a=0x475a550, b=b@entry=0x562d04757248) at ../src/backend/nodes/equalfuncs.c:239 [23:19:16.659] retval = [23:19:16.659] __func__ = "equal" [23:19:16.659] #1 0x0000562d02428f93 in list_member (list=0x562d0475a5c0, datum=datum@entry=0x562d04757248) at ../src/backend/nodes/list.c:670 [23:19:16.659] cell__state = {l = , i = } [23:19:16.659] cell = [23:19:16.659] #2 0x0000562d0254c613 in add_new_column_to_pathtarget (target=target@entry=0x562d0475a4e0, expr=0x562d04757248) at ../src/backend/optimizer/util/tlist.c:743 [23:19:16.659] No locals. [23:19:16.659] #3 0x0000562d0254c6ae in add_new_columns_to_pathtarget (target=target@entry=0x562d0475a4e0, exprs=exprs@entry=0x562d0475a6f0) at ../src/backend/optimizer/util/tlist.c:760 [23:19:16.659] expr = [23:19:16.659] lc__state = {l = , i = } [23:19:16.659] lc = [23:19:16.659] #4 0x0000562d024c4d52 in make_group_input_target (root=root@entry=0x562d04754ae0, final_target=final_target@entry=0x562d0475a380) at ../src/backend/optimizer/plan/planner.c:5472 [23:19:16.659] parse = 0x562d04633d48 [23:19:16.659] input_target = 0x562d0475a4e0 [23:19:16.659] non_group_cols = 0x562d0475a6a0 [23:19:16.659] non_group_vars = 0x562d0475a6f0 [23:19:16.659] i = 6 [23:19:16.659] lc = 0x0 [23:19:16.659] #5 0x0000562d024d8074 in grouping_planner (root=root@entry=0x562d04754ae0, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:19:16.659] sort_input_targets = 0x562d047570b8 [23:19:16.659] sort_input_target_parallel_safe = true [23:19:16.659] grouping_target = 0x562d0475a380 [23:19:16.659] scanjoin_target = [23:19:16.659] activeWindows = 0x0 [23:19:16.659] qp_extra = {activeWindows = 0x0, gset_data = 0x562d04758718} [23:19:16.659] sort_input_targets_contain_srfs = 0x562d0250e4ea [23:19:16.659] have_grouping = [23:19:16.659] wflists = 0x0 [23:19:16.659] gset_data = 0x562d04758718 [23:19:16.659] sort_input_target = 0x562d0475a380 [23:19:16.659] grouping_targets = 0x0 [23:19:16.659] grouping_target_parallel_safe = true [23:19:16.659] scanjoin_targets = 0x0 [23:19:16.659] scanjoin_target_parallel_safe = [23:19:16.659] grouping_targets_contain_srfs = 0x562d024366df [23:19:16.659] scanjoin_targets_contain_srfs = 0x562d047534c8 [23:19:16.659] scanjoin_target_same_exprs = [23:19:16.659] parse = 0x562d04633d48 [23:19:16.659] offset_est = 0 [23:19:16.659] count_est = 0 [23:19:16.659] limit_tuples = -1 [23:19:16.659] have_postponed_srfs = false [23:19:16.659] final_target = 0x562d0475a380 [23:19:16.659] final_targets = 0x0 [23:19:16.659] final_targets_contain_srfs = 0x562d025147e1 [23:19:16.659] final_target_parallel_safe = true [23:19:16.659] current_rel = 0x562d04744898 [23:19:16.659] final_rel = [23:19:16.659] extra = {limit_needed = 224, limit_tuples = 1.9762625833649862e-323, count_est = 94751348312800, offset_est = 0} [23:19:16.659] lc = [23:19:16.659] __func__ = "grouping_planner" [23:19:16.659] #6 0x0000562d024daf18 in subquery_planner (glob=glob@entry=0x562d047132b8, parse=parse@entry=0x562d04633d48, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:19:16.659] root = 0x562d04754ae0 [23:19:16.659] newWithCheckOptions = [23:19:16.659] newHaving = 0x0 [23:19:16.659] hasOuterJoins = [23:19:16.659] hasResultRTEs = false [23:19:16.659] final_rel = [23:19:16.659] l = 0x0 [23:19:16.659] #7 0x0000562d024dbb6d in standard_planner (parse=parse@entry=0x562d04633d48, query_string=query_string@entry=0x562d04632290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [23:19:16.659] result = [23:19:16.659] glob = 0x562d047132b8 [23:19:16.659] tuple_fraction = 0 [23:19:16.659] root = [23:19:16.659] final_rel = [23:19:16.659] best_path = [23:19:16.659] top_plan = [23:19:16.659] lp = [23:19:16.659] lr = [23:19:16.659] #8 0x00007f186a31473e in pgss_planner (parse=0x562d04633d48, query_string=0x562d04632290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:972 [23:19:16.659] _save_exception_stack = 0x7ffff3f75ef0 [23:19:16.659] _save_context_stack = 0x0 [23:19:16.659] _local_sigjmp_buf = {{__jmpbuf = {94751347129672, 4283929217826492351, 0, 2048, 0, 94751347122832, 7554363713616547775, 7573170327680257983}, __mask_was_saved = 0, __saved_mask = {__val = {70368744203387, 1, 94751308131917, 1, 94751313966934, 1, 94751348308152, 0, 0, 0, 94751317863477, 0, 94751311429006, 0, 94751347129672, 0}}}} [23:19:16.659] _do_rethrow = false [23:19:16.659] result = 0x7ffff3f75c60 [23:19:16.659] #9 0x0000562d024dcc27 in planner (parse=parse@entry=0x562d04633d48, query_string=query_string@entry=0x562d04632290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [23:19:16.659] result = [23:19:16.659] #10 0x0000562d0274b093 in pg_plan_query (querytree=querytree@entry=0x562d04633d48, query_string=query_string@entry=0x562d04632290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [23:19:16.659] plan = [23:19:16.659] #11 0x0000562d0274b400 in pg_plan_queries (querytrees=0x562d047538b8, query_string=query_string@entry=0x562d04632290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [23:19:16.659] query = 0x562d04633d48 [23:19:16.659] stmt = [23:19:16.659] query_list__state = {l = , i = } [23:19:16.659] stmt_list = 0x0 [23:19:16.659] query_list = [23:19:16.659] #12 0x0000562d0274b7da in exec_simple_query (query_string=query_string@entry=0x562d04632290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [23:19:16.659] cmdtaglen = 6 [23:19:16.659] snapshot_set = true [23:19:16.659] per_parsetree_context = 0x0 [23:19:16.659] plantree_list = [23:19:16.659] parsetree = 0x562d04633bb8 [23:19:16.659] commandTag = CMDTAG_SELECT [23:19:16.659] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94751347122832} [23:19:16.659] querytree_list = [23:19:16.659] portal = [23:19:16.659] receiver = [23:19:16.659] format = 0 [23:19:16.659] cmdtagname = [23:19:16.659] parsetree_item__state = {l = , i = } [23:19:16.659] dest = DestRemote [23:19:16.659] oldcontext = 0x562d0465e880 [23:19:16.659] parsetree_list = 0x562d04633be8 [23:19:16.659] parsetree_item = 0x562d04633c00 [23:19:16.659] save_log_statement_stats = false [23:19:16.659] was_logged = true [23:19:16.659] use_implicit_block = false [23:19:16.659] msec_str = "\000\000\000\000\000\000\000\000$\220\241\002-V\000\000\320^\367\363\377\177\000\000[\000\000\000\000\000\000" [23:19:16.659] __func__ = "exec_simple_query" [23:19:16.659] #13 0x0000562d0274e6da in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4672 [23:19:16.659] query_string = 0x562d04632290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [23:19:16.659] firstchar = [23:19:16.659] input_message = {data = 0x562d04632290 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [23:19:16.659] local_sigjmp_buf = {{__jmpbuf = {94751329978392, 4283939814762811327, 140737286463584, 0, 140737286463732, 1, 7554363713767542719, 4283942230342832063}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94751347097408, 16384, 8248, 94751317776976, 0, 0, 0, 94751329978400, 94751347122576, 94751329972504, 0, 140737286463732, 1, 94751317780026, 1}}}} [23:19:16.659] send_ready_for_query = false [23:19:16.659] idle_in_transaction_timeout_enabled = false [23:19:16.659] idle_session_timeout_enabled = false [23:19:16.659] __func__ = "PostgresMain" [23:19:16.659] #14 0x0000562d025f1bef in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [23:19:16.659] No locals. [23:19:16.659] #15 0x0000562d025f7434 in BackendStartup (client_sock=client_sock@entry=0x7ffff3f76060) at ../src/backend/postmaster/postmaster.c:4117 [23:19:16.659] bn = 0x562d0465eb88 [23:19:16.659] pid = 0 [23:19:16.659] cac = CAC_OK [23:19:16.659] __func__ = "BackendStartup" [23:19:16.659] #16 0x0000562d025f784d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [23:19:16.659] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "In\030\177\000\000\356\310\347Y\000\000\000\000\001\000\000\000\000\000\000\000\210\233\261l\030\177\000\000 \323\316l\030\177\000\000\001\000\000\000\000\000\000\000\244sIn\030\177\000\000-\000\000\000\000\000\000\000\020\236\262l\030\177\000\000 i\202m\030\177\000\000Ha\367\363\377\177\000\000Da\367\363\377\177\000\000\000\000\000\000\000\000\000\000pc\367\363\377\177\000\000\000\000\000\000\000\000\000", __ss_align = 139742879587856}, salen = 2}} [23:19:16.659] i = 0 [23:19:16.659] now = [23:19:16.659] last_lockfile_recheck_time = 1710371774 [23:19:16.659] last_touch_time = 1710371774 [23:19:16.659] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -201891516, events = 32767, fd = 73778400, user_data = 0x7ffff3f76210}, {pos = 1825493792, events = 32536, fd = -201891328, user_data = 0x2e}, {pos = 1850446208, events = 32536, fd = 8, user_data = 0x0}, {pos = 1850446208, events = 32536, fd = 1508362478, user_data = 0x7f186d826788}, {pos = 1825505258, events = 32536, fd = -201891160, user_data = 0x7ffff3f76200}, {pos = -201891312, events = 32767, fd = 1850309857, user_data = 0x12}, {pos = 1783551512, events = 32536, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1837261856, user_data = 0x7ffff3f762ee}, {pos = 1783551512, events = 32536, fd = 1837261856, user_data = 0x102f1d8a0}, {pos = 1837262728, events = 32536, fd = 0, user_data = 0x562d0465db60}, {pos = 73803112, events = 22061, fd = -1, user_data = 0x7f186e49c623 <_dl_fixup+211>}, {pos = 1823589400, events = 32536, fd = 1837263136, user_data = 0x1000}, {pos = 1823635960, events = 32536, fd = -201890336, user_data = 0x7f186e4a368a <_dl_runtime_resolve_xsavec+122>}, {pos = 16, events = 0, fd = 16777343, user_data = 0x10}, {pos = 1825607928, events = 32536, fd = 4, user_data = 0x562d04632db0}, {pos = 1, events = 0, fd = 1, user_data = 0x562d046340f0}, {pos = 1850328611, events = 32536, fd = 1, user_data = 0x0}, {pos = 73613552, events = 22061, fd = 1823589400, user_data = 0x7ffff3f76650}, {pos = 1850357386, events = 32536, fd = 0, user_data = 0x0}, {pos = -201890192, events = 32767, fd = 56403424, user_data = 0x2}, {pos = 56403424, events = 22061, fd = 0, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 8096, events = 196607, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x0}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 73824584, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 73596896, user_data = 0x562d0462ffe0}, {pos = 0, events = 0, fd = 1824030165, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -65536, events = 4294967295, fd = -1, 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 = 1825453184, user_data = 0x10462ffe0}, {pos = 784, events = 0, fd = 46530668, user_data = 0x562d046620b0}, {pos = -1038201600, events = 3245140112, fd = 4, user_data = 0x562d04667910}, {pos = 73801904, events = 22061, fd = 73802104, user_data = 0x400}, {pos = 73802104, events = 22061, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 44338505, user_data = 0x562d035d87d0 }, {pos = 44272181, events = 22061, fd = 73801904, user_data = 0x562d04632190}, {pos = 73801904, events = 22061, fd = 15, user_data = 0x4a}, {pos = 44340273, events = 22061, fd = 73801904, user_data = 0x562d02a49573 }, {pos = 73596896, events = 22061, fd = 1824107822, user_data = 0x0}, {pos = 37827173, events = 22061, fd = 73776064, user_data = 0x10462ffe0}, {pos = -201890072, events = 32767, fd = 0, user_data = 0x562d046620b0}, {pos = 1824092586, events = 32536, fd = 1024, user_data = 0x562d0462ffe0}, {pos = 1824086256, events = 32536, fd = 0, user_data = 0x562d00000000}, {pos = 0, events = 0, fd = 73596896, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x7498}, {pos = 1824389893, events = 32536, fd = 4, user_data = 0xc16ce890c21e4d00}, {pos = 1, events = 0, fd = 39778157, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x562d02a49431 }, {pos = 73776064, events = 22061, fd = 44340595, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x562d02412e38 }, {pos = 0, events = 0, fd = 37850126, user_data = 0x562d04632190}, {pos = 39805388, events = 22061, fd = 0, user_data = 0x0}} [23:19:16.660] nevents = 1 [23:19:16.660] __func__ = "ServerLoop" [23:19:16.660] #17 0x0000562d025f9267 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x562d0462be40) at ../src/backend/postmaster/postmaster.c:1478 [23:19:16.660] opt = [23:19:16.660] status = [23:19:16.660] userDoption = [23:19:16.660] listen_addr_saved = false [23:19:16.660] output_config_variable = [23:19:16.660] __func__ = "PostmasterMain" [23:19:16.660] #18 0x0000562d02423c68 in main (argc=4, argv=0x562d0462be40) at ../src/backend/main/main.c:197 [23:19:16.660] do_check_root = [23:19:16.675] -e [23:19:16.675] [23:19:16.675] [23:19:17.068] dumping /tmp/cores/postgres-11-36196.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:19:17.378] [New LWP 36196] [23:19:20.368] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [23:19:20.368] Downloading separate debug info for /.cache/debuginfod_client/6bc1c815422672b74fde1b1c0803e4c9effae2a7/debuginfo... [23:19:21.578] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [23:19:23.154] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [23:19:23.876] [Thread debugging using libthread_db enabled] [23:19:23.876] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:19:25.957] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [23:19:26.721] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [23:19:27.791] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [23:19:29.027] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [23:19:29.642] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [23:19:30.618] Core was generated by `postgres: postgres regression_pg_stat_statements [local] SELECT '. [23:19:30.618] Program terminated with signal SIGSEGV, Segmentation fault. [23:19:30.618] #0 0x00005606f088569e in get_expr_width (root=root@entry=0x5606f2113038, expr=expr@entry=0xfffffffff2067078) at ../src/backend/optimizer/path/costsize.c:6328 [23:19:30.618] 6328 if (IsA(expr, Var)) [23:19:30.734] [23:19:30.734] Thread 1 (Thread 0x7f1c7ad56a40 (LWP 36196)): [23:19:30.734] #0 0x00005606f088569e in get_expr_width (root=root@entry=0x5606f2113038, expr=expr@entry=0xfffffffff2067078) at ../src/backend/optimizer/path/costsize.c:6328 [23:19:30.734] width = [23:19:30.734] #1 0x00005606f089633d in set_pathtarget_cost_width (root=root@entry=0x5606f2113038, target=target@entry=0x5606f2067008) at ../src/backend/optimizer/path/costsize.c:6299 [23:19:30.734] node = 0xfffffffff2067078 [23:19:30.734] lc__state = {l = , i = } [23:19:30.734] tuple_width = 0 [23:19:30.734] lc = [23:19:30.734] #2 0x00005606f08f0d6d in make_group_input_target (root=root@entry=0x5606f2113038, final_target=final_target@entry=0x5606f2066f48) at ../src/backend/optimizer/plan/planner.c:5479 [23:19:30.734] parse = 0x5606f211f228 [23:19:30.734] input_target = 0x5606f2067008 [23:19:30.734] non_group_cols = 0x0 [23:19:30.734] non_group_vars = 0x0 [23:19:30.734] i = 3 [23:19:30.734] lc = 0x0 [23:19:30.734] #3 0x00005606f0904074 in grouping_planner (root=root@entry=0x5606f2113038, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:19:30.734] sort_input_targets = 0x5606f21147c0 [23:19:30.734] sort_input_target_parallel_safe = true [23:19:30.734] grouping_target = 0x5606f2066f48 [23:19:30.734] scanjoin_target = [23:19:30.734] activeWindows = 0x0 [23:19:30.734] qp_extra = {activeWindows = 0x0, gset_data = 0x5606f2114d60} [23:19:30.734] sort_input_targets_contain_srfs = 0x5606f093a4ea [23:19:30.734] have_grouping = [23:19:30.734] wflists = 0x0 [23:19:30.734] gset_data = 0x5606f2114d60 [23:19:30.734] sort_input_target = 0x5606f2066f48 [23:19:30.734] grouping_targets = 0x0 [23:19:30.734] grouping_target_parallel_safe = true [23:19:30.734] scanjoin_targets = 0x0 [23:19:30.734] scanjoin_target_parallel_safe = [23:19:30.734] grouping_targets_contain_srfs = 0x5606f08626df [23:19:30.734] scanjoin_targets_contain_srfs = 0x5606f21210d0 [23:19:30.734] scanjoin_target_same_exprs = [23:19:30.734] parse = 0x5606f211f228 [23:19:30.734] offset_est = 0 [23:19:30.734] count_est = 0 [23:19:30.734] limit_tuples = -1 [23:19:30.734] have_postponed_srfs = false [23:19:30.734] final_target = 0x5606f2066f48 [23:19:30.734] final_targets = 0x0 [23:19:30.734] final_targets_contain_srfs = 0x5606f09407e1 [23:19:30.734] final_target_parallel_safe = true [23:19:30.734] current_rel = 0x5606f2065558 [23:19:30.734] final_rel = [23:19:30.734] extra = {limit_needed = 56, limit_tuples = 1.9762625833649862e-323, count_est = 94587831005240, offset_est = 0} [23:19:30.734] lc = [23:19:30.734] __func__ = "grouping_planner" [23:19:30.734] #4 0x00005606f0906f18 in subquery_planner (glob=glob@entry=0x5606f2013fd8, parse=parse@entry=0x5606f211f228, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:19:30.734] root = 0x5606f2113038 [23:19:30.734] newWithCheckOptions = [23:19:30.734] newHaving = 0x0 [23:19:30.734] hasOuterJoins = [23:19:30.734] hasResultRTEs = false [23:19:30.734] final_rel = [23:19:30.734] l = 0x0 [23:19:30.734] #5 0x00005606f0907b6d in standard_planner (parse=parse@entry=0x5606f211f228, query_string=query_string@entry=0x5606f20122c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:412 [23:19:30.734] result = [23:19:30.734] glob = 0x5606f2013fd8 [23:19:30.734] tuple_fraction = 0 [23:19:30.734] root = [23:19:30.734] final_rel = [23:19:30.734] best_path = [23:19:30.734] top_plan = [23:19:30.734] lp = [23:19:30.734] lr = [23:19:30.734] #6 0x00007f1c7ab8359c in pgss_planner (parse=0x5606f211f228, query_string=0x5606f20122c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:926 [23:19:30.734] _save_exception_stack = 0x7ffefd2a1c40 [23:19:30.734] _save_context_stack = 0x0 [23:19:30.734] _local_sigjmp_buf = {{__jmpbuf = {94587831054888, 4453134109483756628, 0, 2048, 0, 94587829953216, 7943412643471322196, 8068661157928528980}, __mask_was_saved = 0, __saved_mask = {__val = {140733145815519, 384, 94587829931600, 140733145815616, 1, 140733145815519, 140733146163029, 137, 6, 139760292574168, 94587810463688, 1710371796, 455036, 472, 94587811409312, 139760292574168}}}} [23:19:30.734] _do_rethrow = false [23:19:30.734] duration = {ticks = } [23:19:30.734] bufusage = {shared_blks_hit = 94587831004875, shared_blks_read = 94587831004873, shared_blks_dirtied = 0, shared_blks_written = 0, local_blks_hit = 94557999988736, local_blks_read = 8, local_blks_dirtied = 266, local_blks_written = 94587811740027, temp_blks_read = 0, temp_blks_written = 206158430232, shared_blk_read_time = {ticks = 140733145815472}, shared_blk_write_time = {ticks = 140733145815280}, local_blk_read_time = {ticks = 60}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 139760290395936}, temp_blk_write_time = {ticks = 2795348724}} [23:19:30.734] walusage_start = {wal_records = 1344, wal_fpi = 2, wal_bytes = 170221} [23:19:30.734] start = {ticks = } [23:19:30.734] bufusage_start = {shared_blks_hit = 6887, shared_blks_read = 4, shared_blks_dirtied = 18, shared_blks_written = 18, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [23:19:30.734] walusage = {wal_records = 0, wal_fpi = 94587811490869, wal_bytes = 94587806327013} [23:19:30.734] result = 0x7ffefd2a19b0 [23:19:30.734] #7 0x00005606f0908c27 in planner (parse=parse@entry=0x5606f211f228, query_string=query_string@entry=0x5606f20122c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:278 [23:19:30.734] result = [23:19:30.734] #8 0x00005606f0b77093 in pg_plan_query (querytree=querytree@entry=0x5606f211f228, query_string=query_string@entry=0x5606f20122c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [23:19:30.734] plan = [23:19:30.734] #9 0x00005606f0b77400 in pg_plan_queries (querytrees=0x5606f2112fe8, query_string=query_string@entry=0x5606f20122c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [23:19:30.734] query = 0x5606f211f228 [23:19:30.734] stmt = [23:19:30.734] query_list__state = {l = , i = } [23:19:30.734] stmt_list = 0x0 [23:19:30.734] query_list = [23:19:30.734] #10 0x00005606f0b777da in exec_simple_query (query_string=query_string@entry=0x5606f20122c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;") at ../src/backend/tcop/postgres.c:1192 [23:19:30.734] cmdtaglen = 6 [23:19:30.734] snapshot_set = true [23:19:30.734] per_parsetree_context = 0x0 [23:19:30.734] plantree_list = [23:19:30.734] parsetree = 0x5606f2013f58 [23:19:30.734] commandTag = CMDTAG_SELECT [23:19:30.734] qc = {commandTag = CMDTAG_DROP_ROLE, nprocessed = 94587829953216} [23:19:30.734] querytree_list = [23:19:30.734] portal = [23:19:30.734] receiver = [23:19:30.734] format = 0 [23:19:30.734] cmdtagname = [23:19:30.734] parsetree_item__state = {l = , i = } [23:19:30.734] dest = DestRemote [23:19:30.734] oldcontext = 0x5606f203dbe0 [23:19:30.734] parsetree_list = 0x5606f2013f88 [23:19:30.734] parsetree_item = 0x5606f2013fa0 [23:19:30.734] save_log_statement_stats = false [23:19:30.734] was_logged = false [23:19:30.734] use_implicit_block = false [23:19:30.734] msec_str = "\000\000\000\000\000\000\000\000$P\344\360\006V\000\000 \034*\375\376\177\000\000\205\000\000\000\000\000\000" [23:19:30.734] __func__ = "exec_simple_query" [23:19:30.734] #11 0x00005606f0b7a6da in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4672 [23:19:30.734] query_string = 0x5606f20122c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;" [23:19:30.734] firstchar = [23:19:30.734] input_message = {data = 0x5606f20122c0 "SELECT a, b, c\nFROM (VALUES (1, 2, 3), (4, NULL, 6), (7, 8, 9)) AS t (a, b, c)\nGROUP BY ROLLUP(a, b), rollup(a, c)\nORDER BY a, b, c;", len = 133, maxlen = 1024, cursor = 133} [23:19:30.734] local_sigjmp_buf = {{__jmpbuf = {94587823605784, 4453130541108325460, 140733145816496, 0, 140733145816644, 1, 7943412643119000660, 4453128253460343892}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 139760337210852, 94587829927760, 15616, 15680, 94587811402661, 94587823605792, 94587829952960, 94587823599896, 0, 140733145816644, 94587811406729, 1}}}} [23:19:30.734] send_ready_for_query = false [23:19:30.734] idle_in_transaction_timeout_enabled = false [23:19:30.734] idle_session_timeout_enabled = false [23:19:30.734] __func__ = "PostgresMain" [23:19:30.734] #12 0x00005606f0a1dbef in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [23:19:30.734] No locals. [23:19:30.734] #13 0x00005606f0a23434 in BackendStartup (client_sock=client_sock@entry=0x7ffefd2a1db0) at ../src/backend/postmaster/postmaster.c:4117 [23:19:30.734] bn = 0x5606f203de18 [23:19:30.734] pid = 0 [23:19:30.734] cac = CAC_OK [23:19:30.734] __func__ = "BackendStartup" [23:19:30.734] #14 0x00005606f0a2384d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [23:19:30.734] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\000\000\000\000\000\000\210\213\070}\034\177\000\000 \303U}\034\177\000\000\001\000\000\000\000\000\000\000\244c\320~\034\177\000\000-\000\000\000\000\000\000\000\020\216\071}\034\177\000\000 Y\t~\034\177\000\000\210\036*\375\376\177\000\000\204\036*\375\376\177\000\000\360\316\003\362\006V", '\000' , "\020\216\071}\034\177\000\000\340\257\070}\034\177\000", __ss_align = 139760338595818}, salen = 2}} [23:19:30.734] i = 0 [23:19:30.734] now = [23:19:30.734] last_lockfile_recheck_time = 1710371796 [23:19:30.734] last_touch_time = 1710371796 [23:19:30.734] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -47571120, events = 32766, fd = 2102772512, user_data = 0x7ffefd2a1f40}, {pos = 46, events = 0, fd = 2127724928, user_data = 0xfd2a1f10}, {pos = 0, events = 0, fd = 2127724928, user_data = 0x59e7c8ee}, {pos = 2114541448, events = 32540, fd = 2102783978, user_data = 0x7ffefd2a1fe8}, {pos = -47571136, events = 32766, fd = -47571120, user_data = 0x7f1c7ed06ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = 2060830232, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f1c7e095420}, {pos = -47571184, events = 32766, fd = 2060830232, user_data = 0x7f1c7e095420}, {pos = -248211296, events = 1, fd = 2114541448, user_data = 0x0}, {pos = -234631776, events = 22022, fd = -234617688, user_data = 0xffffffff}, {pos = 2127607331, events = 32540, fd = 2100868120, user_data = 0x7f1c7e095920}, {pos = -234617720, events = 22022, fd = 2100914680, user_data = 0x7ffefd2a2330}, {pos = 2127636106, events = 32540, fd = 16, user_data = 0x100007f}, {pos = 16, events = 0, fd = 2102886648, user_data = 0x8}, {pos = -234803712, events = 22022, fd = 1, user_data = 0x1}, {pos = -234803760, events = 22022, fd = 2127607331, user_data = 0x1}, {pos = 0, events = 0, fd = -234617896, user_data = 0x7f1c7d38b418}, {pos = -47570016, events = 32766, fd = 2127636106, user_data = 0x0}, {pos = 0, events = 0, fd = -47569984, user_data = 0x5606f19f65e0 }, {pos = 2, events = 0, fd = -241211936, 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 = -234636872, user_data = 0x3ff}, {pos = 4096, events = 0, fd = -234815504, user_data = 0x5606f200fff0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 171193136, events = 1886221359, fd = 1600614447, user_data = 0x6e4241572d737365}, {pos = 168454214, events = 908075040, fd = 822763892, user_data = 0x30340a3639373137}, {pos = 1635021663, events = 1701668212, fd = 796095598, user_data = 0x6975622d69632d73}, {pos = 1647273068, events = 1684826485, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x400}, {pos = -234815504, events = 22022, fd = 2102731904, user_data = 0x1f200fff0}, {pos = 784, events = 0, fd = -251084692, user_data = 0x5606f203c990}, {pos = 1615944704, events = 1840941182, fd = 4, user_data = 0x5606f203b980}, {pos = -234632816, events = 22022, fd = -234632616, 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 = -234632616, user_data = 0x400}, {pos = 0, events = 0, fd = -253276855, user_data = 0x5606f1a047d0 }, {pos = -253343179, events = 22022, fd = -234632816, user_data = 0x5606f20121c0}, {pos = -234632816, events = 22022, fd = 15, user_data = 0x4a}, {pos = -253275087, events = 22022, fd = -234632816, user_data = 0x5606f0e75573 }, {pos = -234815504, events = 22022, fd = 2101386235, user_data = 0x0}, {pos = -259788187, events = 22022, fd = -234641424, user_data = 0x1f200fff0}, {pos = -47569864, events = 32766, fd = 0, user_data = 0x5606f203c990}, {pos = 2101371306, events = 32540, fd = 1024, user_data = 0x5606f200fff0}, {pos = 2101364976, events = 32540, fd = 0, user_data = 0x560600000000}, {pos = 0, events = 0, fd = -234815504, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x8d46}, {pos = 2101668613, events = 32540, fd = 8, user_data = 0x6dba887e60515c00}, {pos = 1, events = 0, fd = -257837203, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x5606f0e75431 }, {pos = -234641424, events = 22022, fd = -253274765, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5606f083ee38 }, {pos = 0, events = 0, fd = -259765234, user_data = 0x5606f20121c0}, {pos = -257809972, events = 22022, fd = 0, user_data = 0x0}} [23:19:30.734] nevents = 1 [23:19:30.734] __func__ = "ServerLoop" [23:19:30.734] #15 0x00005606f0a25267 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5606f200bea0) at ../src/backend/postmaster/postmaster.c:1478 [23:19:30.734] opt = [23:19:30.734] status = [23:19:30.734] userDoption = [23:19:30.734] listen_addr_saved = false [23:19:30.734] output_config_variable = [23:19:30.734] __func__ = "PostmasterMain" [23:19:30.734] #16 0x00005606f084fc68 in main (argc=8, argv=0x5606f200bea0) at ../src/backend/main/main.c:197 [23:19:30.734] do_check_root = [23:19:30.752] -e [23:19:30.752] [23:19:30.752] [23:19:31.139] dumping /tmp/cores/postgres-11-29456.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:19:31.453] [New LWP 29456] [23:19:32.673] [Thread debugging using libthread_db enabled] [23:19:32.673] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:19:34.535] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [23:19:34.871] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [23:19:34.871] Program terminated with signal SIGSEGV, Segmentation fault. [23:19:34.871] #0 0x0000561bba3d9145 in equal (a=0xffffffffbc99c180, b=b@entry=0x561bbc9cd688) at ../src/backend/nodes/equalfuncs.c:239 [23:19:34.871] 239 if (nodeTag(a) != nodeTag(b)) [23:19:35.040] [23:19:35.040] Thread 1 (Thread 0x7f78447a1a40 (LWP 29456)): [23:19:35.040] #0 0x0000561bba3d9145 in equal (a=0xffffffffbc99c180, b=b@entry=0x561bbc9cd688) at ../src/backend/nodes/equalfuncs.c:239 [23:19:35.040] retval = [23:19:35.040] __func__ = "equal" [23:19:35.040] #1 0x0000561bb9d1af93 in list_member (list=0x561bbc99c1f0, datum=datum@entry=0x561bbc9cd688) at ../src/backend/nodes/list.c:670 [23:19:35.040] cell__state = {l = , i = } [23:19:35.040] cell = [23:19:35.040] #2 0x0000561bb9e3e613 in add_new_column_to_pathtarget (target=target@entry=0x561bbc99c110, expr=0x561bbc9cd688) at ../src/backend/optimizer/util/tlist.c:743 [23:19:35.040] No locals. [23:19:35.040] #3 0x0000561bb9e3e6ae in add_new_columns_to_pathtarget (target=target@entry=0x561bbc99c110, exprs=exprs@entry=0x561bbc99c2a8) at ../src/backend/optimizer/util/tlist.c:760 [23:19:35.040] expr = [23:19:35.040] lc__state = {l = , i = } [23:19:35.040] lc = [23:19:35.040] #4 0x0000561bb9db6d52 in make_group_input_target (root=root@entry=0x561bbc9ccf98, final_target=final_target@entry=0x561bbc99c028) at ../src/backend/optimizer/plan/planner.c:5472 [23:19:35.040] parse = 0x561bbc87c788 [23:19:35.040] input_target = 0x561bbc99c110 [23:19:35.040] non_group_cols = 0x561bbc99c258 [23:19:35.040] non_group_vars = 0x561bbc99c2a8 [23:19:35.040] i = 2 [23:19:35.040] lc = 0x0 [23:19:35.040] #5 0x0000561bb9dca074 in grouping_planner (root=root@entry=0x561bbc9ccf98, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:19:35.040] sort_input_targets = 0x561bbc9cd4b8 [23:19:35.040] sort_input_target_parallel_safe = true [23:19:35.040] grouping_target = 0x561bbc99c028 [23:19:35.040] scanjoin_target = [23:19:35.040] activeWindows = 0x0 [23:19:35.040] qp_extra = {activeWindows = 0x0, gset_data = 0x561bbc9d0768} [23:19:35.040] sort_input_targets_contain_srfs = 0x561bb9e004ea [23:19:35.040] have_grouping = [23:19:35.040] wflists = 0x0 [23:19:35.040] gset_data = 0x561bbc9d0768 [23:19:35.040] sort_input_target = 0x561bbc99c028 [23:19:35.040] grouping_targets = 0x0 [23:19:35.040] grouping_target_parallel_safe = true [23:19:35.040] scanjoin_targets = 0x0 [23:19:35.040] scanjoin_target_parallel_safe = [23:19:35.040] grouping_targets_contain_srfs = 0x561bb9d286df [23:19:35.040] scanjoin_targets_contain_srfs = 0x0 [23:19:35.040] scanjoin_target_same_exprs = [23:19:35.040] parse = 0x561bbc87c788 [23:19:35.040] offset_est = 0 [23:19:35.040] count_est = 0 [23:19:35.040] limit_tuples = -1 [23:19:35.040] have_postponed_srfs = false [23:19:35.040] final_target = 0x561bbc99c028 [23:19:35.040] final_targets = 0x561bbc95df68 [23:19:35.040] final_targets_contain_srfs = 0x561bb9e0051f [23:19:35.040] final_target_parallel_safe = true [23:19:35.040] current_rel = 0x561bbc9ccd48 [23:19:35.040] final_rel = [23:19:35.040] extra = {limit_needed = 152, limit_tuples = 4.9406564584124654e-324, count_est = 94677128499096, offset_est = 1} [23:19:35.040] lc = [23:19:35.040] __func__ = "grouping_planner" [23:19:35.040] #6 0x0000561bb9dccf18 in subquery_planner (glob=glob@entry=0x561bbc9ccc38, parse=parse@entry=0x561bbc87c788, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:19:35.040] root = 0x561bbc9ccf98 [23:19:35.040] newWithCheckOptions = [23:19:35.040] newHaving = 0x0 [23:19:35.040] hasOuterJoins = [23:19:35.040] hasResultRTEs = false [23:19:35.040] final_rel = [23:19:35.040] l = 0x0 [23:19:35.040] #7 0x0000561bb9dcdb6d in standard_planner (parse=0x561bbc87c788, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [23:19:35.040] result = [23:19:35.040] glob = 0x561bbc9ccc38 [23:19:35.040] tuple_fraction = 0 [23:19:35.040] root = [23:19:35.040] final_rel = [23:19:35.040] best_path = [23:19:35.040] top_plan = [23:19:35.040] lp = [23:19:35.040] lr = [23:19:35.040] #8 0x0000561bb9dcec31 in planner (parse=parse@entry=0x561bbc87c788, query_string=query_string@entry=0x561bbc87b260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [23:19:35.040] result = [23:19:35.040] #9 0x0000561bba03d093 in pg_plan_query (querytree=querytree@entry=0x561bbc87c788, query_string=query_string@entry=0x561bbc87b260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [23:19:35.040] plan = [23:19:35.040] #10 0x0000561bb9b2e2d6 in standard_ExplainOneQuery (query=0x561bbc87c788, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561bbc8a6318, queryString=0x561bbc87b260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:441 [23:19:35.040] plan = [23:19:35.040] planstart = {ticks = } [23:19:35.040] planduration = {ticks = 94677127120776} [23:19:35.040] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94677077009240, shared_blks_dirtied = 0, shared_blks_written = 70368744218533, local_blks_hit = 94677127121048, local_blks_read = 94677078330957, local_blks_dirtied = 140730672793486, local_blks_written = 94677084167907, temp_blks_read = 1, temp_blks_written = 140154368543504, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94673964105728}, local_blk_read_time = {ticks = 94677128042968}, local_blk_write_time = {ticks = 94677088062517}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94677081628046}} [23:19:35.040] bufusage = {shared_blks_hit = 140730672793485, shared_blks_read = 94677084252566, shared_blks_dirtied = 0, shared_blks_written = 4294967297, local_blks_hit = 0, local_blks_read = 94673964105738, local_blks_dirtied = 175531018436608, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 40869, shared_blk_read_time = {ticks = 140154368543504}, shared_blk_write_time = {ticks = 94677127121864}, local_blk_read_time = {ticks = 94677127120776}, local_blk_write_time = {ticks = 94677087580478}, temp_blk_read_time = {ticks = 140154368543504}, temp_blk_write_time = {ticks = 94677087580497}} [23:19:35.040] mem_counters = {nblocks = 94677127121048, freechunks = 140730672793496, totalspace = 140730672793488, freespace = 94677127120776} [23:19:35.040] planner_ctx = 0x0 [23:19:35.040] saved_ctx = 0x0 [23:19:35.040] #11 0x0000561bb9b2e56e in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561bbc8a6318, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:397 [23:19:35.040] No locals. [23:19:35.040] #12 0x0000561bb9b2fb65 in ExplainQuery (pstate=pstate@entry=0x561bbc8a6208, stmt=stmt@entry=0x561bbc87c5c8, params=params@entry=0x0, dest=dest@entry=0x561bbc8a6178) at ../src/include/nodes/nodes.h:172 [23:19:35.040] l__state = {l = , i = } [23:19:35.040] l = 0x561bbc9ccc00 [23:19:35.040] es = 0x561bbc8a6318 [23:19:35.040] tstate = [23:19:35.040] jstate = [23:19:35.040] query = [23:19:35.040] rewritten = 0x561bbc9ccbe8 [23:19:35.040] lc = 0x0 [23:19:35.040] timing_set = false [23:19:35.040] summary_set = false [23:19:35.040] __func__ = "ExplainQuery" [23:19:35.040] #13 0x0000561bba047aa1 in standard_ProcessUtility (pstmt=0x561bbc87c678, queryString=0x561bbc87b260 "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=0x561bbc8a6178, qc=0x7ffe69c2c980) at ../src/backend/tcop/utility.c:863 [23:19:35.040] parsetree = 0x561bbc87c5c8 [23:19:35.040] isTopLevel = true [23:19:35.040] isAtomicContext = false [23:19:35.040] pstate = 0x561bbc8a6208 [23:19:35.040] readonly_flags = [23:19:35.040] __func__ = "standard_ProcessUtility" [23:19:35.040] #14 0x0000561bba0481ca in ProcessUtility (pstmt=pstmt@entry=0x561bbc87c678, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x561bbc8a6178, qc=0x7ffe69c2c980) at ../src/backend/tcop/utility.c:523 [23:19:35.040] No locals. [23:19:35.040] #15 0x0000561bba043928 in PortalRunUtility (portal=portal@entry=0x561bbc8fbf90, pstmt=0x561bbc87c678, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x561bbc8a6178, qc=qc@entry=0x7ffe69c2c980) at ../src/backend/tcop/pquery.c:1158 [23:19:35.040] No locals. [23:19:35.040] #16 0x0000561bba04430b in FillPortalStore (portal=portal@entry=0x561bbc8fbf90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [23:19:35.040] treceiver = 0x561bbc8a6178 [23:19:35.040] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:19:35.040] __func__ = "FillPortalStore" [23:19:35.040] #17 0x0000561bba04498d in PortalRun (portal=portal@entry=0x561bbc8fbf90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x561bbc95e328, altdest=altdest@entry=0x561bbc95e328, qc=0x7ffe69c2cb60) at ../src/backend/tcop/pquery.c:763 [23:19:35.040] _save_exception_stack = 0x7ffe69c2cc10 [23:19:35.040] _save_context_stack = 0x0 [23:19:35.040] _local_sigjmp_buf = {{__jmpbuf = {1, -7122010899574422416, 94677128045352, 94677127120448, 94677127643024, 94677127120376, 7121698818047345776, 3539544373342241904}, __mask_was_saved = 0, __saved_mask = {__val = {140730672794351, 94677090778302, 94677127651232, 94677090778302, 1, 140730672794351, 94677127120424, 94677127120376, 94677087803787, 94677090367347, 94677127643024, 94677090778302, 1, 1, 94677088062919, 153}}}} [23:19:35.040] _do_rethrow = [23:19:35.040] result = [23:19:35.040] nprocessed = [23:19:35.040] saveTopTransactionResourceOwner = 0x561bbc8bace8 [23:19:35.040] saveTopTransactionContext = 0x561bbc965520 [23:19:35.040] saveActivePortal = 0x0 [23:19:35.040] saveResourceOwner = 0x561bbc8bace8 [23:19:35.040] savePortalContext = 0x0 [23:19:35.040] saveMemoryContext = 0x561bbc965520 [23:19:35.040] __func__ = "PortalRun" [23:19:35.040] #18 0x0000561bba03d922 in exec_simple_query (query_string=query_string@entry=0x561bbc87b260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;") at ../src/backend/tcop/postgres.c:1273 [23:19:35.040] cmdtaglen = 7 [23:19:35.040] snapshot_set = [23:19:35.040] per_parsetree_context = 0x0 [23:19:35.040] plantree_list = 0x561bbc95e2d8 [23:19:35.040] parsetree = 0x561bbc87c5f8 [23:19:35.040] commandTag = [23:19:35.040] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:19:35.040] querytree_list = [23:19:35.040] portal = 0x561bbc8fbf90 [23:19:35.040] receiver = 0x561bbc95e328 [23:19:35.040] format = 0 [23:19:35.040] cmdtagname = [23:19:35.040] parsetree_item__state = {l = , i = } [23:19:35.040] dest = DestRemote [23:19:35.040] oldcontext = 0x561bbc965520 [23:19:35.040] parsetree_list = 0x561bbc87c628 [23:19:35.040] parsetree_item = 0x561bbc87c640 [23:19:35.040] save_log_statement_stats = false [23:19:35.040] was_logged = false [23:19:35.040] use_implicit_block = false [23:19:35.040] msec_str = "\000\000\000\000\000\000\000\000$\260\060\272\033V\000\000\360\313\302i\376\177\000\000U\000\000\000\000\000\000" [23:19:35.040] __func__ = "exec_simple_query" [23:19:35.040] #19 0x0000561bba0406da in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4672 [23:19:35.040] query_string = 0x561bbc87b260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;" [23:19:35.040] firstchar = [23:19:35.040] input_message = {data = 0x561bbc87b260 "EXPLAIN (COSTS OFF)\nSELECT c, sum(a) FROM pagg_tab GROUP BY rollup(c) ORDER BY 1, 2;", len = 85, maxlen = 1024, cursor = 85} [23:19:35.040] local_sigjmp_buf = {{__jmpbuf = {94677100177432, 3539544582795035760, 140730672795008, 0, 140730672795156, 1, 7121698817992819824, 3539544352606782576}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140154562248164, 94677127089904, 15616, 15680, 94677087974309, 94677100177440, 94677127115104, 94677100171544, 0, 140730672795156, 94677087978377, 1}}}} [23:19:35.040] send_ready_for_query = false [23:19:35.040] idle_in_transaction_timeout_enabled = false [23:19:35.040] idle_session_timeout_enabled = false [23:19:35.040] __func__ = "PostgresMain" [23:19:35.040] #20 0x0000561bb9ee3bef in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [23:19:35.040] No locals. [23:19:35.040] #21 0x0000561bb9ee9434 in BackendStartup (client_sock=client_sock@entry=0x7ffe69c2cd80) at ../src/backend/postmaster/postmaster.c:4117 [23:19:35.040] bn = 0x561bbc8a4148 [23:19:35.040] pid = 0 [23:19:35.040] cac = CAC_OK [23:19:35.040] __func__ = "BackendStartup" [23:19:35.040] #22 0x0000561bb9ee984d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [23:19:35.040] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\372Fx\177\000\000\001\000\000\000\000\000\000\000\244\023uHx\177\000\000-\000\000\000\000\000\000\000\020>\336Fx\177\000\000 \t\256Gx\177\000\000H\316\302i\376\177\000\000D\316\302i\376\177\000\000\004\316\302i\376\177\000\000@\256\000\000\001\000\000\000\000\000\000\000\033V\000\000\020>\336Fx\177\000\000\340_\335Fx\177\000\000\352\237\372Fx\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [23:19:35.040] i = 0 [23:19:35.040] now = [23:19:35.040] last_lockfile_recheck_time = 1710371746 [23:19:35.040] last_touch_time = 1710371746 [23:19:35.040] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1774374656, events = 32766, fd = 45, user_data = 0x7ffe69c2cec0}, {pos = 1774374608, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 1202587528, user_data = 0x7f7846fa9fea}, {pos = 1774374824, events = 32766, fd = 1774374656, user_data = 0x7ffe69c2cf10}, {pos = 1215634657, events = 32632, fd = 18, user_data = 0x7f78447a7618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1202586656, events = 32632, fd = -1, user_data = 0x7f78447a7618}, {pos = 1202586656, events = 32632, fd = 1024, user_data = 0x7f7847ae0788}, {pos = 0, events = 0, fd = 8, user_data = 0x7ffe69c2cf10}, {pos = -1, events = 0, fd = 1189694650, user_data = 0x7f7846dd6418}, {pos = 1202587936, events = 32632, fd = -1131770872, user_data = 0x561bbc8a6708}, {pos = -1131804176, events = 22043, fd = -1131770840, user_data = 0x561bbc8a8b61}, {pos = 1215653411, events = 32632, fd = 1, user_data = 0x7f7846fc30f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = -1131949984, user_data = 0x1}, {pos = 1, events = 0, fd = -1131950032, user_data = 0x7f7848756623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x561bbc8a09f0}, {pos = 1188914200, events = 32632, fd = 1774375792, user_data = 0x7f784875d68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffe69c2d390}, {pos = -1158953504, events = 22043, fd = 2, user_data = 0x561bbaebc5e0 }, {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 = -1131777128, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1734701663, user_data = 0xa7032356b34452d}, {pos = 762540901, events = 896218181, fd = 168456242, user_data = 0x33303137310a6174}, {pos = 876032311, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = 1189432315, user_data = 0x400}, {pos = -1131966576, events = 22043, fd = 1190777984, user_data = 0x1bc878f90}, {pos = 784, events = 0, fd = -1168826260, user_data = 0x561bbc8a63e0}, {pos = -1402195456, events = 1492877008, fd = 4, user_data = 0x561bbc8a7360}, {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 = 0x561bbc8a63e0}, {pos = 1, events = 0, fd = -1131780952, user_data = 0x400}, {pos = 0, events = 0, fd = -1171018423, user_data = 0x561bbaeca7d0 }, {pos = -1171084747, events = 22043, fd = -1131781152, user_data = 0x561bbc87b160}, {pos = -1131781152, events = 22043, fd = 15, user_data = 0x4a}, {pos = -1171016655, events = 22043, fd = -1131781152, user_data = 0x561bba33b573 }, {pos = -1131966576, events = 22043, fd = 1189432315, user_data = 0x0}, {pos = -1177529755, events = 22043, fd = -1131792544, user_data = 0x1bc878f90}, {pos = 1774375944, events = 32766, fd = 0, user_data = 0x561bbc8a63e0}, {pos = 1189417386, events = 32632, fd = 1024, user_data = 0x561bbc878f90}, {pos = 1189411056, events = 32632, fd = 0, user_data = 0x561b00000000}, {pos = 0, events = 0, fd = -1131966576, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x58ac}, {pos = 1189714693, events = 32632, fd = 8, user_data = 0x58fb7ed0ac6c3200}, {pos = 1, events = 0, fd = -1175578771, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x561bba33b431 }, {pos = -1131792544, events = 22043, fd = -1171016333, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x561bb9d04e38 }, {pos = 0, events = 0, fd = -1177506802, user_data = 0x561bbc87b160}, {pos = -1175551540, events = 22043, fd = 0, user_data = 0x0}} [23:19:35.040] nevents = 1 [23:19:35.040] __func__ = "ServerLoop" [23:19:35.040] #23 0x0000561bb9eeb267 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x561bbc874e50) at ../src/backend/postmaster/postmaster.c:1478 [23:19:35.040] opt = [23:19:35.040] status = [23:19:35.040] userDoption = [23:19:35.040] listen_addr_saved = false [23:19:35.040] output_config_variable = [23:19:35.040] __func__ = "PostmasterMain" [23:19:35.040] #24 0x0000561bb9d15c68 in main (argc=8, argv=0x561bbc874e50) at ../src/backend/main/main.c:197 [23:19:35.040] do_check_root = [23:19:35.059] -e [23:19:35.059] [23:19:35.059] [23:19:35.452] dumping /tmp/cores/postgres-11-26394.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:19:35.761] [New LWP 26394] [23:19:36.987] [Thread debugging using libthread_db enabled] [23:19:36.987] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:19:38.705] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [23:19:39.217] Core was generated by `postgres: postgres regression [local] SELECT '. [23:19:39.217] Program terminated with signal SIGSEGV, Segmentation fault. [23:19:39.217] #0 0x0000561bba3d9145 in equal (a=0xffffffffbc9afc68, b=b@entry=0x561bbc9aca68) at ../src/backend/nodes/equalfuncs.c:239 [23:19:39.217] 239 if (nodeTag(a) != nodeTag(b)) [23:19:39.325] [23:19:39.325] Thread 1 (Thread 0x7f78447a1a40 (LWP 26394)): [23:19:39.325] #0 0x0000561bba3d9145 in equal (a=0xffffffffbc9afc68, b=b@entry=0x561bbc9aca68) at ../src/backend/nodes/equalfuncs.c:239 [23:19:39.325] retval = [23:19:39.325] __func__ = "equal" [23:19:39.325] #1 0x0000561bb9d1af93 in list_member (list=0x561bbc9afcd8, datum=datum@entry=0x561bbc9aca68) at ../src/backend/nodes/list.c:670 [23:19:39.325] cell__state = {l = , i = } [23:19:39.325] cell = [23:19:39.325] #2 0x0000561bb9e3e613 in add_new_column_to_pathtarget (target=target@entry=0x561bbc9afbf8, expr=0x561bbc9aca68) at ../src/backend/optimizer/util/tlist.c:743 [23:19:39.325] No locals. [23:19:39.325] #3 0x0000561bb9e3e6ae in add_new_columns_to_pathtarget (target=target@entry=0x561bbc9afbf8, exprs=exprs@entry=0x561bbc9afe08) at ../src/backend/optimizer/util/tlist.c:760 [23:19:39.325] expr = [23:19:39.325] lc__state = {l = , i = } [23:19:39.325] lc = [23:19:39.325] #4 0x0000561bb9db6d52 in make_group_input_target (root=root@entry=0x561bbc9a4b18, final_target=final_target@entry=0x561bbc9afa98) at ../src/backend/optimizer/plan/planner.c:5472 [23:19:39.325] parse = 0x561bbc87cd18 [23:19:39.325] input_target = 0x561bbc9afbf8 [23:19:39.325] non_group_cols = 0x561bbc9afdb8 [23:19:39.325] non_group_vars = 0x561bbc9afe08 [23:19:39.325] i = 6 [23:19:39.325] lc = 0x0 [23:19:39.325] #5 0x0000561bb9dca074 in grouping_planner (root=root@entry=0x561bbc9a4b18, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:19:39.325] sort_input_targets = 0x561bbc9ac8d8 [23:19:39.325] sort_input_target_parallel_safe = true [23:19:39.325] grouping_target = 0x561bbc9afa98 [23:19:39.325] scanjoin_target = [23:19:39.325] activeWindows = 0x0 [23:19:39.325] qp_extra = {activeWindows = 0x0, gset_data = 0x561bbc9adf28} [23:19:39.325] sort_input_targets_contain_srfs = 0x561bb9e004ea [23:19:39.325] have_grouping = [23:19:39.325] wflists = 0x0 [23:19:39.325] gset_data = 0x561bbc9adf28 [23:19:39.325] sort_input_target = 0x561bbc9afa98 [23:19:39.325] grouping_targets = 0x0 [23:19:39.325] grouping_target_parallel_safe = true [23:19:39.325] scanjoin_targets = 0x0 [23:19:39.325] scanjoin_target_parallel_safe = [23:19:39.325] grouping_targets_contain_srfs = 0x561bb9d286df [23:19:39.325] scanjoin_targets_contain_srfs = 0x561bbc9a9148 [23:19:39.325] scanjoin_target_same_exprs = [23:19:39.325] parse = 0x561bbc87cd18 [23:19:39.325] offset_est = 0 [23:19:39.325] count_est = 0 [23:19:39.325] limit_tuples = -1 [23:19:39.325] have_postponed_srfs = false [23:19:39.325] final_target = 0x561bbc9afa98 [23:19:39.325] final_targets = 0x0 [23:19:39.325] final_targets_contain_srfs = 0x561bb9e067e1 [23:19:39.325] final_target_parallel_safe = true [23:19:39.325] current_rel = 0x561bbc9a4f28 [23:19:39.325] final_rel = [23:19:39.325] extra = {limit_needed = 24, limit_tuples = 1.9762625833649862e-323, count_est = 94677128334104, offset_est = 0} [23:19:39.325] lc = [23:19:39.325] __func__ = "grouping_planner" [23:19:39.325] #6 0x0000561bb9dccf18 in subquery_planner (glob=glob@entry=0x561bbc9a5138, parse=parse@entry=0x561bbc87cd18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:19:39.325] root = 0x561bbc9a4b18 [23:19:39.325] newWithCheckOptions = [23:19:39.325] newHaving = 0x0 [23:19:39.325] hasOuterJoins = [23:19:39.325] hasResultRTEs = false [23:19:39.325] final_rel = [23:19:39.325] l = 0x0 [23:19:39.325] #7 0x0000561bb9dcdb6d in standard_planner (parse=0x561bbc87cd18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [23:19:39.325] result = [23:19:39.325] glob = 0x561bbc9a5138 [23:19:39.325] tuple_fraction = 0 [23:19:39.325] root = [23:19:39.325] final_rel = [23:19:39.325] best_path = [23:19:39.325] top_plan = [23:19:39.325] lp = [23:19:39.325] lr = [23:19:39.325] #8 0x0000561bb9dcec31 in planner (parse=parse@entry=0x561bbc87cd18, query_string=query_string@entry=0x561bbc87b260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [23:19:39.325] result = [23:19:39.325] #9 0x0000561bba03d093 in pg_plan_query (querytree=querytree@entry=0x561bbc87cd18, query_string=query_string@entry=0x561bbc87b260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [23:19:39.325] plan = [23:19:39.325] #10 0x0000561bba03d400 in pg_plan_queries (querytrees=0x561bbc9a94e8, query_string=query_string@entry=0x561bbc87b260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [23:19:39.325] query = 0x561bbc87cd18 [23:19:39.325] stmt = [23:19:39.325] query_list__state = {l = , i = } [23:19:39.325] stmt_list = 0x0 [23:19:39.325] query_list = [23:19:39.325] #11 0x0000561bba03d7da in exec_simple_query (query_string=query_string@entry=0x561bbc87b260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [23:19:39.325] cmdtaglen = 6 [23:19:39.325] snapshot_set = true [23:19:39.325] per_parsetree_context = 0x0 [23:19:39.325] plantree_list = [23:19:39.325] parsetree = 0x561bbc87cb88 [23:19:39.325] commandTag = CMDTAG_SELECT [23:19:39.325] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94677127115360} [23:19:39.325] querytree_list = [23:19:39.325] portal = [23:19:39.325] receiver = [23:19:39.325] format = 0 [23:19:39.325] cmdtagname = [23:19:39.325] parsetree_item__state = {l = , i = } [23:19:39.325] dest = DestRemote [23:19:39.325] oldcontext = 0x561bbc8a3b70 [23:19:39.325] parsetree_list = 0x561bbc87cbb8 [23:19:39.325] parsetree_item = 0x561bbc87cbd0 [23:19:39.325] save_log_statement_stats = false [23:19:39.325] was_logged = false [23:19:39.325] use_implicit_block = false [23:19:39.325] msec_str = "\000\000\000\000\000\000\000\000$\260\060\272\033V\000\000\360\313\302i\376\177\000\000[\000\000\000\000\000\000" [23:19:39.325] __func__ = "exec_simple_query" [23:19:39.325] #12 0x0000561bba0406da in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4672 [23:19:39.325] query_string = 0x561bbc87b260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [23:19:39.325] firstchar = [23:19:39.325] input_message = {data = 0x561bbc87b260 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [23:19:39.325] local_sigjmp_buf = {{__jmpbuf = {94677100177432, 3539544582795035760, 140730672795008, 0, 140730672795156, 1, 7121698817992819824, 3539544352606782576}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140154562248164, 94677127089904, 15616, 15680, 94677087974309, 94677100177440, 94677127115104, 94677100171544, 0, 140730672795156, 94677087978377, 1}}}} [23:19:39.325] send_ready_for_query = false [23:19:39.325] idle_in_transaction_timeout_enabled = false [23:19:39.325] idle_session_timeout_enabled = false [23:19:39.325] __func__ = "PostgresMain" [23:19:39.325] #13 0x0000561bb9ee3bef in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [23:19:39.325] No locals. [23:19:39.325] #14 0x0000561bb9ee9434 in BackendStartup (client_sock=client_sock@entry=0x7ffe69c2cd80) at ../src/backend/postmaster/postmaster.c:4117 [23:19:39.325] bn = 0x561bbc8a4058 [23:19:39.325] pid = 0 [23:19:39.325] cac = CAC_OK [23:19:39.325] __func__ = "BackendStartup" [23:19:39.325] #15 0x0000561bb9ee984d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [23:19:39.325] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\372Fx\177\000\000\001\000\000\000\000\000\000\000\244\023uHx\177\000\000-\000\000\000\000\000\000\000\020>\336Fx\177\000\000 \t\256Gx\177\000\000H\316\302i\376\177\000\000D\316\302i\376\177\000\000\004\316\302i\376\177\000\000@\256\000\000\001\000\000\000\000\000\000\000\033V\000\000\020>\336Fx\177\000\000\340_\335Fx\177\000\000\352\237\372Fx\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [23:19:39.325] i = 0 [23:19:39.325] now = [23:19:39.325] last_lockfile_recheck_time = 1710371746 [23:19:39.325] last_touch_time = 1710371746 [23:19:39.325] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1774374656, events = 32766, fd = 45, user_data = 0x7ffe69c2cec0}, {pos = 1774374608, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 1202587528, user_data = 0x7f7846fa9fea}, {pos = 1774374824, events = 32766, fd = 1774374656, user_data = 0x7ffe69c2cf10}, {pos = 1215634657, events = 32632, fd = 18, user_data = 0x7f78447a7618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1202586656, events = 32632, fd = -1, user_data = 0x7f78447a7618}, {pos = 1202586656, events = 32632, fd = 1024, user_data = 0x7f7847ae0788}, {pos = 0, events = 0, fd = 8, user_data = 0x7ffe69c2cf10}, {pos = -1, events = 0, fd = 1189694650, user_data = 0x7f7846dd6418}, {pos = 1202587936, events = 32632, fd = -1131770872, user_data = 0x561bbc8a6708}, {pos = -1131804176, events = 22043, fd = -1131770840, user_data = 0x561bbc8a8b61}, {pos = 1215653411, events = 32632, fd = 1, user_data = 0x7f7846fc30f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = -1131949984, user_data = 0x1}, {pos = 1, events = 0, fd = -1131950032, user_data = 0x7f7848756623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x561bbc8a09f0}, {pos = 1188914200, events = 32632, fd = 1774375792, user_data = 0x7f784875d68a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffe69c2d390}, {pos = -1158953504, events = 22043, fd = 2, user_data = 0x561bbaebc5e0 }, {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 = -1131777128, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1734701663, user_data = 0xa7032356b34452d}, {pos = 762540901, events = 896218181, fd = 168456242, user_data = 0x33303137310a6174}, {pos = 876032311, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = 1189432315, user_data = 0x400}, {pos = -1131966576, events = 22043, fd = 1190777984, user_data = 0x1bc878f90}, {pos = 784, events = 0, fd = -1168826260, user_data = 0x561bbc8a63e0}, {pos = -1402195456, events = 1492877008, fd = 4, user_data = 0x561bbc8a7360}, {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 = 0x561bbc8a63e0}, {pos = 1, events = 0, fd = -1131780952, user_data = 0x400}, {pos = 0, events = 0, fd = -1171018423, user_data = 0x561bbaeca7d0 }, {pos = -1171084747, events = 22043, fd = -1131781152, user_data = 0x561bbc87b160}, {pos = -1131781152, events = 22043, fd = 15, user_data = 0x4a}, {pos = -1171016655, events = 22043, fd = -1131781152, user_data = 0x561bba33b573 }, {pos = -1131966576, events = 22043, fd = 1189432315, user_data = 0x0}, {pos = -1177529755, events = 22043, fd = -1131792544, user_data = 0x1bc878f90}, {pos = 1774375944, events = 32766, fd = 0, user_data = 0x561bbc8a63e0}, {pos = 1189417386, events = 32632, fd = 1024, user_data = 0x561bbc878f90}, {pos = 1189411056, events = 32632, fd = 0, user_data = 0x561b00000000}, {pos = 0, events = 0, fd = -1131966576, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x58ac}, {pos = 1189714693, events = 32632, fd = 8, user_data = 0x58fb7ed0ac6c3200}, {pos = 1, events = 0, fd = -1175578771, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x561bba33b431 }, {pos = -1131792544, events = 22043, fd = -1171016333, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x561bb9d04e38 }, {pos = 0, events = 0, fd = -1177506802, user_data = 0x561bbc87b160}, {pos = -1175551540, events = 22043, fd = 0, user_data = 0x0}} [23:19:39.325] nevents = 1 [23:19:39.325] __func__ = "ServerLoop" [23:19:39.325] #16 0x0000561bb9eeb267 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x561bbc874e50) at ../src/backend/postmaster/postmaster.c:1478 [23:19:39.325] opt = [23:19:39.325] status = [23:19:39.325] userDoption = [23:19:39.325] listen_addr_saved = false [23:19:39.325] output_config_variable = [23:19:39.325] __func__ = "PostmasterMain" [23:19:39.325] #17 0x0000561bb9d15c68 in main (argc=8, argv=0x561bbc874e50) at ../src/backend/main/main.c:197 [23:19:39.325] do_check_root = [23:19:39.342] -e [23:19:39.342] [23:19:39.342] [23:19:39.878] dumping /tmp/cores/postgres-11-27277.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [23:19:40.185] [New LWP 27277] [23:19:41.812] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [23:19:42.835] [Thread debugging using libthread_db enabled] [23:19:42.835] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:19:44.268] Core was generated by `postgres: old_node: postgres regression [local] SELECT '. [23:19:44.268] Program terminated with signal SIGSEGV, Segmentation fault. [23:19:44.268] #0 0x00005631b9de9145 in equal (a=0xffffffffbc10dc58, b=b@entry=0x5631bc10aa58) at ../src/backend/nodes/equalfuncs.c:239 [23:19:44.268] 239 if (nodeTag(a) != nodeTag(b)) [23:19:44.386] [23:19:44.386] Thread 1 (Thread 0x7f536cce6a40 (LWP 27277)): [23:19:44.386] #0 0x00005631b9de9145 in equal (a=0xffffffffbc10dc58, b=b@entry=0x5631bc10aa58) at ../src/backend/nodes/equalfuncs.c:239 [23:19:44.386] retval = [23:19:44.386] __func__ = "equal" [23:19:44.386] #1 0x00005631b972af93 in list_member (list=0x5631bc10dcc8, datum=datum@entry=0x5631bc10aa58) at ../src/backend/nodes/list.c:670 [23:19:44.386] cell__state = {l = , i = } [23:19:44.386] cell = [23:19:44.386] #2 0x00005631b984e613 in add_new_column_to_pathtarget (target=target@entry=0x5631bc10dbe8, expr=0x5631bc10aa58) at ../src/backend/optimizer/util/tlist.c:743 [23:19:44.386] No locals. [23:19:44.386] #3 0x00005631b984e6ae in add_new_columns_to_pathtarget (target=target@entry=0x5631bc10dbe8, exprs=exprs@entry=0x5631bc10ddf8) at ../src/backend/optimizer/util/tlist.c:760 [23:19:44.386] expr = [23:19:44.386] lc__state = {l = , i = } [23:19:44.386] lc = [23:19:44.386] #4 0x00005631b97c6d52 in make_group_input_target (root=root@entry=0x5631bc102c68, final_target=final_target@entry=0x5631bc10da88) at ../src/backend/optimizer/plan/planner.c:5472 [23:19:44.386] parse = 0x5631bbfdcd08 [23:19:44.386] input_target = 0x5631bc10dbe8 [23:19:44.386] non_group_cols = 0x5631bc10dda8 [23:19:44.386] non_group_vars = 0x5631bc10ddf8 [23:19:44.386] i = 6 [23:19:44.386] lc = 0x0 [23:19:44.386] #5 0x00005631b97da074 in grouping_planner (root=root@entry=0x5631bc102c68, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:19:44.386] sort_input_targets = 0x5631bc10a8c8 [23:19:44.386] sort_input_target_parallel_safe = true [23:19:44.386] grouping_target = 0x5631bc10da88 [23:19:44.386] scanjoin_target = [23:19:44.386] activeWindows = 0x0 [23:19:44.386] qp_extra = {activeWindows = 0x0, gset_data = 0x5631bc10bee8} [23:19:44.386] sort_input_targets_contain_srfs = 0x5631b98104ea [23:19:44.386] have_grouping = [23:19:44.386] wflists = 0x0 [23:19:44.386] gset_data = 0x5631bc10bee8 [23:19:44.386] sort_input_target = 0x5631bc10da88 [23:19:44.386] grouping_targets = 0x0 [23:19:44.386] grouping_target_parallel_safe = true [23:19:44.386] scanjoin_targets = 0x0 [23:19:44.386] scanjoin_target_parallel_safe = [23:19:44.386] grouping_targets_contain_srfs = 0x5631b97386df [23:19:44.386] scanjoin_targets_contain_srfs = 0x5631bc107138 [23:19:44.386] scanjoin_target_same_exprs = [23:19:44.386] parse = 0x5631bbfdcd08 [23:19:44.386] offset_est = 0 [23:19:44.386] count_est = 0 [23:19:44.386] limit_tuples = -1 [23:19:44.386] have_postponed_srfs = false [23:19:44.386] final_target = 0x5631bc10da88 [23:19:44.386] final_targets = 0x0 [23:19:44.386] final_targets_contain_srfs = 0x5631b98167e1 [23:19:44.386] final_target_parallel_safe = true [23:19:44.386] current_rel = 0x5631bc103078 [23:19:44.386] final_rel = [23:19:44.386] extra = {limit_needed = 104, limit_tuples = 1.9762625833649862e-323, count_est = 94771608562792, offset_est = 0} [23:19:44.386] lc = [23:19:44.386] __func__ = "grouping_planner" [23:19:44.386] #6 0x00005631b97dcf18 in subquery_planner (glob=glob@entry=0x5631bbfdcf78, parse=parse@entry=0x5631bbfdcd08, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:19:44.386] root = 0x5631bc102c68 [23:19:44.386] newWithCheckOptions = [23:19:44.386] newHaving = 0x0 [23:19:44.386] hasOuterJoins = [23:19:44.386] hasResultRTEs = false [23:19:44.386] final_rel = [23:19:44.386] l = 0x0 [23:19:44.386] #7 0x00005631b97ddb6d in standard_planner (parse=0x5631bbfdcd08, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [23:19:44.386] result = [23:19:44.386] glob = 0x5631bbfdcf78 [23:19:44.386] tuple_fraction = 0 [23:19:44.386] root = [23:19:44.386] final_rel = [23:19:44.386] best_path = [23:19:44.386] top_plan = [23:19:44.386] lp = [23:19:44.386] lr = [23:19:44.386] #8 0x00005631b97dec31 in planner (parse=parse@entry=0x5631bbfdcd08, query_string=query_string@entry=0x5631bbfdb250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [23:19:44.386] result = [23:19:44.386] #9 0x00005631b9a4d093 in pg_plan_query (querytree=querytree@entry=0x5631bbfdcd08, query_string=query_string@entry=0x5631bbfdb250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [23:19:44.386] plan = [23:19:44.386] #10 0x00005631b9a4d400 in pg_plan_queries (querytrees=0x5631bc1074d8, query_string=query_string@entry=0x5631bbfdb250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:995 [23:19:44.386] query = 0x5631bbfdcd08 [23:19:44.386] stmt = [23:19:44.386] query_list__state = {l = , i = } [23:19:44.386] stmt_list = 0x0 [23:19:44.386] query_list = [23:19:44.386] #11 0x00005631b9a4d7da in exec_simple_query (query_string=query_string@entry=0x5631bbfdb250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);") at ../src/backend/tcop/postgres.c:1192 [23:19:44.386] cmdtaglen = 6 [23:19:44.386] snapshot_set = true [23:19:44.386] per_parsetree_context = 0x0 [23:19:44.386] plantree_list = [23:19:44.386] parsetree = 0x5631bbfdcb78 [23:19:44.386] commandTag = CMDTAG_SELECT [23:19:44.386] qc = {commandTag = CMDTAG_CREATE_TEXT_SEARCH_CONFIGURATION, nprocessed = 94771607351888} [23:19:44.386] querytree_list = [23:19:44.386] portal = [23:19:44.386] receiver = [23:19:44.386] format = 0 [23:19:44.386] cmdtagname = [23:19:44.386] parsetree_item__state = {l = , i = } [23:19:44.386] dest = DestRemote [23:19:44.386] oldcontext = 0x5631bc00e410 [23:19:44.386] parsetree_list = 0x5631bbfdcba8 [23:19:44.386] parsetree_item = 0x5631bbfdcbc0 [23:19:44.386] save_log_statement_stats = false [23:19:44.386] was_logged = true [23:19:44.386] use_implicit_block = false [23:19:44.386] msec_str = "\000\000\000\000\000\000\000\000$\260ΡΉ1V\000\000\300\201c\353\374\177\000\000[\000\000\000\000\000\000" [23:19:44.386] __func__ = "exec_simple_query" [23:19:44.386] #12 0x00005631b9a506da in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4672 [23:19:44.386] query_string = 0x5631bbfdb250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);" [23:19:44.386] firstchar = [23:19:44.386] input_message = {data = 0x5631bbfdb250 "select a, b, grouping(a,b), sum(v), count(*), max(v)\n from gstest1 group by rollup (a,b);", len = 91, maxlen = 1024, cursor = 91} [23:19:44.386] local_sigjmp_buf = {{__jmpbuf = {94771583232024, -1911885998945446337, 140724257653584, 0, 140724257653732, 1, -5265484167682959809, -1911888530219051457}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 139996325072356, 94771607326464, 14336, 14400, 94771571028901, 94771583232032, 94771607351632, 94771583226136, 0, 140724257653732, 94771571032969, 1}}}} [23:19:44.386] send_ready_for_query = false [23:19:44.386] idle_in_transaction_timeout_enabled = false [23:19:44.386] idle_session_timeout_enabled = false [23:19:44.386] __func__ = "PostgresMain" [23:19:44.386] #13 0x00005631b98f3bef in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [23:19:44.386] No locals. [23:19:44.386] #14 0x00005631b98f9434 in BackendStartup (client_sock=client_sock@entry=0x7ffceb638350) at ../src/backend/postmaster/postmaster.c:4117 [23:19:44.386] bn = 0x5631bc0105e8 [23:19:44.386] pid = 0 [23:19:44.386] cac = CAC_OK [23:19:44.386] __func__ = "BackendStartup" [23:19:44.386] #15 0x00005631b98f984d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [23:19:44.386] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "c\353\374\177\000\000\020\216\062oS\177\000\000\234_\311pS\177\000\000\356\310\347Y\000\000\000\000\001\000\000\000\000\000\000\000\210\213\061oS\177\000\000 \303NoS\177\000\000\001\000\000\000\000\000\000\000\244c\311pS\177\000\000-\000\000\000\000\000\000\000\020\216\062oS\177\000\000 Y\002pS\177\000\000H\204c\353\374\177\000\000D\204c\353\374\177\000\000\000\000\000\000\000\000\000", __ss_align = 94771607343008}, salen = 2}} [23:19:44.386] i = 0 [23:19:44.386] now = [23:19:44.386] last_lockfile_recheck_time = 1710371748 [23:19:44.386] last_touch_time = 1710371748 [23:19:44.386] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1508362478, events = 0, fd = 23568163, user_data = 0x7ffceb638444}, {pos = 1825701440, events = 32595, fd = -345799408, user_data = 0x7f536f4ec320}, {pos = -345799424, events = 32764, fd = 45, user_data = 0x7f5370cb8180}, {pos = 64, events = 0, fd = 0, user_data = 0x7f5370cb8180}, {pos = 1508362478, events = 0, fd = 1879201672, user_data = 0x7f536f4eefea}, {pos = -345799256, events = 32764, fd = -345799424, user_data = 0x7ffceb638510}, {pos = 1892248801, events = 32595, fd = 18, user_data = 0x7f536ccec618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1879200800, events = 32595, fd = 7, user_data = 0x7f536ccec618}, {pos = 1879200800, events = 32595, fd = -1172178784, user_data = 0x7f5370025788}, {pos = 0, events = 0, fd = -1140839808, user_data = 0x5631bc004418}, {pos = -1, events = 0, fd = 1892267555, user_data = 0x7f536f31b418}, {pos = 1879202080, events = 32595, fd = 8, user_data = 0x7f536f3269f8}, {pos = -345798448, events = 32764, fd = 1892296330, user_data = 0x10}, {pos = 16777343, events = 0, fd = 16, user_data = 0x7f536f5080f8 <__libc_fork@got.plt>}, {pos = 4, events = 0, fd = -1140994032, user_data = 0x1}, {pos = 1, events = 0, fd = -1140994064, user_data = 0x7f5370c9b623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x5631bc00e410}, {pos = 1865528344, events = 32595, fd = -345798336, user_data = 0x7f5370ca268a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffceb638960}, {pos = -1165179424, events = 22065, fd = 2, user_data = 0x5631ba8cc5e0 }, {pos = 0, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x2ffff00001fa0}, {pos = 8, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -1140833368, user_data = 0x3ff}, {pos = 4096, events = 0, fd = -1141010528, user_data = 0x5631bbfd8fa0}, {pos = 0, events = 0, fd = 1865969109, user_data = 0x801}, {pos = 678096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 784, events = 0, fd = -1175052180, user_data = 0x5631bc003f60}, {pos = 2089206528, events = 3037395092, fd = 4, user_data = 0x5631bc004370}, {pos = -1140834464, events = 22065, fd = -1140834264, user_data = 0x400}, {pos = -1140834264, events = 22065, fd = 0, user_data = 0x5631b9d3a78e }, {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 = 0x5631ba8da7d0 }, {pos = -1177310667, events = 22065, fd = -1140834464, user_data = 0x5631bbfdb150}, {pos = -1140834464, events = 22065, fd = 15, user_data = 0x4a}, {pos = -1177242575, events = 22065, fd = -1140834464, user_data = 0x5631b9d4b573 }, {pos = -1141010528, events = 22065, fd = 1866046766, user_data = 0x0}, {pos = -1183755675, events = 22065, fd = -1140839616, user_data = 0x1bbfd8fa0}, {pos = -345798184, events = 32764, fd = 0, user_data = 0x5631bc003f60}, {pos = 1866031530, events = 32595, fd = 1024, user_data = 0x5631bbfd8fa0}, {pos = 1866025200, events = 32595, fd = 0, user_data = 0x563100000000}, {pos = 0, events = 0, fd = -1141010528, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x5b2c}, {pos = 1866328837, events = 32595, fd = 4, user_data = 0xb50af8947c86c300}, {pos = 1, events = 0, fd = -1181804691, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x5631b9d4b431 }, {pos = -1140839616, events = 22065, fd = -1177242253, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x5631b9714e38 }, {pos = 0, events = 0, fd = -1183732722, user_data = 0x5631bbfdb150}, {pos = -1181777460, events = 22065, fd = 0, user_data = 0x0}} [23:19:44.386] nevents = 1 [23:19:44.386] __func__ = "ServerLoop" [23:19:44.386] #16 0x00005631b98fb267 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5631bbfd4e10) at ../src/backend/postmaster/postmaster.c:1478 [23:19:44.386] opt = [23:19:44.386] status = [23:19:44.386] userDoption = [23:19:44.386] listen_addr_saved = false [23:19:44.386] output_config_variable = [23:19:44.386] __func__ = "PostmasterMain" [23:19:44.386] #17 0x00005631b9725c68 in main (argc=4, argv=0x5631bbfd4e10) at ../src/backend/main/main.c:197 [23:19:44.386] do_check_root = [23:19:44.403] -e [23:19:44.403] [23:19:44.403] [23:19:44.938] dumping /tmp/cores/postgres-11-36383.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [23:19:45.250] [New LWP 36383] [23:19:46.394] [Thread debugging using libthread_db enabled] [23:19:46.394] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [23:19:48.518] Downloading separate debug info for /lib/x86_64-linux-gnu/libnss_files.so.2... [23:19:49.007] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN '. [23:19:49.007] Program terminated with signal SIGSEGV, Segmentation fault. [23:19:49.007] #0 0x00005637a7203145 in equal (a=0xffffffffa92ef268, b=b@entry=0x5637a93de5b8) at ../src/backend/nodes/equalfuncs.c:239 [23:19:49.007] 239 if (nodeTag(a) != nodeTag(b)) [23:19:49.174] [23:19:49.174] Thread 1 (Thread 0x7f981cfeda40 (LWP 36383)): [23:19:49.174] #0 0x00005637a7203145 in equal (a=0xffffffffa92ef268, b=b@entry=0x5637a93de5b8) at ../src/backend/nodes/equalfuncs.c:239 [23:19:49.174] retval = [23:19:49.174] __func__ = "equal" [23:19:49.174] #1 0x00005637a6b44f93 in list_member (list=0x5637a92ef2d8, datum=datum@entry=0x5637a93de5b8) at ../src/backend/nodes/list.c:670 [23:19:49.174] cell__state = {l = , i = } [23:19:49.174] cell = [23:19:49.174] #2 0x00005637a6c68613 in add_new_column_to_pathtarget (target=target@entry=0x5637a92ef1f8, expr=0x5637a93de5b8) at ../src/backend/optimizer/util/tlist.c:743 [23:19:49.174] No locals. [23:19:49.174] #3 0x00005637a6c686ae in add_new_columns_to_pathtarget (target=target@entry=0x5637a92ef1f8, exprs=exprs@entry=0x5637a92ef378) at ../src/backend/optimizer/util/tlist.c:760 [23:19:49.174] expr = [23:19:49.174] lc__state = {l = , i = } [23:19:49.174] lc = [23:19:49.174] #4 0x00005637a6be0d52 in make_group_input_target (root=root@entry=0x5637a93ddec8, final_target=final_target@entry=0x5637a92ef158) at ../src/backend/optimizer/plan/planner.c:5472 [23:19:49.174] parse = 0x5637a929a920 [23:19:49.174] input_target = 0x5637a92ef1f8 [23:19:49.174] non_group_cols = 0x5637a92ef328 [23:19:49.174] non_group_vars = 0x5637a92ef378 [23:19:49.174] i = 2 [23:19:49.174] lc = 0x0 [23:19:49.174] #5 0x00005637a6bf4074 in grouping_planner (root=root@entry=0x5637a93ddec8, tuple_fraction=, tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1577 [23:19:49.174] sort_input_targets = 0x5637a93de3e8 [23:19:49.174] sort_input_target_parallel_safe = true [23:19:49.174] grouping_target = 0x5637a92ef158 [23:19:49.174] scanjoin_target = [23:19:49.174] activeWindows = 0x0 [23:19:49.174] qp_extra = {activeWindows = 0x0, gset_data = 0x5637a93cd758} [23:19:49.174] sort_input_targets_contain_srfs = 0x5637a93cd6b8 [23:19:49.174] have_grouping = [23:19:49.174] wflists = 0x0 [23:19:49.174] gset_data = 0x5637a93cd758 [23:19:49.174] sort_input_target = 0x5637a92ef158 [23:19:49.174] grouping_targets = 0x5637a93ddec8 [23:19:49.174] grouping_target_parallel_safe = true [23:19:49.174] scanjoin_targets = 0x1 [23:19:49.174] scanjoin_target_parallel_safe = [23:19:49.174] grouping_targets_contain_srfs = 0x5637a7166c35 [23:19:49.174] scanjoin_targets_contain_srfs = 0x5637a6b43d8e [23:19:49.174] scanjoin_target_same_exprs = [23:19:49.174] parse = 0x5637a929a920 [23:19:49.174] offset_est = 0 [23:19:49.174] count_est = 0 [23:19:49.174] limit_tuples = -1 [23:19:49.174] have_postponed_srfs = false [23:19:49.174] final_target = 0x5637a92ef158 [23:19:49.174] final_targets = 0x5637a93c1d58 [23:19:49.174] final_targets_contain_srfs = 0x5637a6b49d18 [23:19:49.174] final_target_parallel_safe = true [23:19:49.174] current_rel = 0x5637a93c5b68 [23:19:49.174] final_rel = [23:19:49.174] extra = {limit_needed = false, limit_tuples = 4.6835950920227726e-310, count_est = 94797062526648, offset_est = 94797062526648} [23:19:49.174] lc = [23:19:49.174] __func__ = "grouping_planner" [23:19:49.174] #6 0x00005637a6bf6f18 in subquery_planner (glob=glob@entry=0x5637a93c5a58, parse=parse@entry=0x5637a929a920, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0) at ../src/backend/optimizer/plan/planner.c:1084 [23:19:49.174] root = 0x5637a93ddec8 [23:19:49.174] newWithCheckOptions = [23:19:49.174] newHaving = 0x0 [23:19:49.174] hasOuterJoins = [23:19:49.174] hasResultRTEs = false [23:19:49.174] final_rel = [23:19:49.174] l = 0x0 [23:19:49.174] #7 0x00005637a6bf7b6d in standard_planner (parse=0x5637a929a920, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:412 [23:19:49.174] result = [23:19:49.174] glob = 0x5637a93c5a58 [23:19:49.174] tuple_fraction = 0 [23:19:49.174] root = [23:19:49.174] final_rel = [23:19:49.174] best_path = [23:19:49.174] top_plan = [23:19:49.174] lp = [23:19:49.174] lr = [23:19:49.174] #8 0x00005637a6bf8c31 in planner (parse=parse@entry=0x5637a929a920, query_string=query_string@entry=0x5637a9299270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:280 [23:19:49.174] result = [23:19:49.174] #9 0x00005637a6e67093 in pg_plan_query (querytree=querytree@entry=0x5637a929a920, query_string=query_string@entry=0x5637a9299270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:903 [23:19:49.174] plan = [23:19:49.174] #10 0x00005637a69582d6 in standard_ExplainOneQuery (query=0x5637a929a920, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5637a93eba18, queryString=0x5637a9299270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:441 [23:19:49.174] plan = [23:19:49.174] planstart = {ticks = } [23:19:49.174] planduration = {ticks = 94797061269792} [23:19:49.174] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 94797015401304, shared_blks_dirtied = 94797061270064, shared_blks_written = 70368744194107, local_blks_hit = 0, local_blks_read = 94797016723021, local_blks_dirtied = 94797061270064, local_blks_written = 94797022558038, temp_blks_read = 1, temp_blks_written = 2048, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94794223190016}, local_blk_read_time = {ticks = 94797061269520}, local_blk_write_time = {ticks = 94797026454581}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94797020020110}} [23:19:49.174] bufusage = {shared_blks_hit = 94797062494648, shared_blks_read = 1, shared_blks_dirtied = 0, shared_blks_written = 1, local_blks_hit = 0, local_blks_read = 94797023078762, local_blks_dirtied = 70622147264512, local_blks_written = 72057594037927936, temp_blks_read = 1, temp_blks_written = 16443, shared_blk_read_time = {ticks = 140291145000936}, shared_blk_write_time = {ticks = 94797062494648}, local_blk_read_time = {ticks = 94797061269792}, local_blk_write_time = {ticks = 94797025972542}, temp_blk_read_time = {ticks = 140291145000936}, temp_blk_write_time = {ticks = 94797025972561}} [23:19:49.174] mem_counters = {nblocks = 0, freechunks = 1, totalspace = 0, freespace = 94797026195851} [23:19:49.174] planner_ctx = 0x0 [23:19:49.174] saved_ctx = 0x0 [23:19:49.174] #11 0x00005637a695856e in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5637a93eba18, queryString=, params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:397 [23:19:49.174] No locals. [23:19:49.174] #12 0x00005637a6959b65 in ExplainQuery (pstate=pstate@entry=0x5637a93eb908, stmt=stmt@entry=0x5637a929a760, params=params@entry=0x0, dest=dest@entry=0x5637a93eb878) at ../src/include/nodes/nodes.h:172 [23:19:49.174] l__state = {l = , i = } [23:19:49.174] l = 0x5637a93c5a20 [23:19:49.174] es = 0x5637a93eba18 [23:19:49.174] tstate = [23:19:49.174] jstate = [23:19:49.174] query = [23:19:49.174] rewritten = 0x5637a93c5a08 [23:19:49.174] lc = 0x0 [23:19:49.174] timing_set = false [23:19:49.174] summary_set = false [23:19:49.174] __func__ = "ExplainQuery" [23:19:49.174] #13 0x00005637a6e71aa1 in standard_ProcessUtility (pstmt=0x5637a929a810, queryString=0x5637a9299270 "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=0x5637a93eb878, qc=0x7ffd165c5e80) at ../src/backend/tcop/utility.c:863 [23:19:49.174] parsetree = 0x5637a929a760 [23:19:49.174] isTopLevel = true [23:19:49.174] isAtomicContext = false [23:19:49.174] pstate = 0x5637a93eb908 [23:19:49.174] readonly_flags = [23:19:49.174] __func__ = "standard_ProcessUtility" [23:19:49.174] #14 0x00005637a6e721ca in ProcessUtility (pstmt=pstmt@entry=0x5637a929a810, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5637a93eb878, qc=0x7ffd165c5e80) at ../src/backend/tcop/utility.c:523 [23:19:49.174] No locals. [23:19:49.174] #15 0x00005637a6e6d928 in PortalRunUtility (portal=portal@entry=0x5637a9315f90, pstmt=0x5637a929a810, isTopLevel=, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5637a93eb878, qc=qc@entry=0x7ffd165c5e80) at ../src/backend/tcop/pquery.c:1158 [23:19:49.174] No locals. [23:19:49.174] #16 0x00005637a6e6e30b in FillPortalStore (portal=portal@entry=0x5637a9315f90, isTopLevel=isTopLevel@entry=true) at ../src/include/nodes/nodes.h:172 [23:19:49.174] treceiver = 0x5637a93eb878 [23:19:49.174] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:19:49.174] __func__ = "FillPortalStore" [23:19:49.174] #17 0x00005637a6e6e98d in PortalRun (portal=portal@entry=0x5637a9315f90, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5637a93c2118, altdest=altdest@entry=0x5637a93c2118, qc=0x7ffd165c6060) at ../src/backend/tcop/pquery.c:763 [23:19:49.174] _save_exception_stack = 0x7ffd165c6110 [23:19:49.174] _save_context_stack = 0x0 [23:19:49.174] _local_sigjmp_buf = {{__jmpbuf = {1, 3348403749186469264, 94797062480152, 94797061269464, 94797061775248, 94797061269392, -3346799317939094128, -9072318149101322864}, __mask_was_saved = 0, __saved_mask = {__val = {140724978606063, 94797029170366, 94797061783456, 94797029170366, 1, 140724978606063, 94797061269440, 94797061269392, 94797026195851, 94797028759411, 94797061775248, 94797029170366, 1, 1, 94797026454983, 153}}}} [23:19:49.174] _do_rethrow = [23:19:49.174] result = [23:19:49.174] nprocessed = [23:19:49.174] saveTopTransactionResourceOwner = 0x5637a92d3620 [23:19:49.174] saveTopTransactionContext = 0x5637a92c1b80 [23:19:49.174] saveActivePortal = 0x0 [23:19:49.174] saveResourceOwner = 0x5637a92d3620 [23:19:49.174] savePortalContext = 0x0 [23:19:49.174] saveMemoryContext = 0x5637a92c1b80 [23:19:49.174] __func__ = "PortalRun" [23:19:49.174] #18 0x00005637a6e67922 in exec_simple_query (query_string=query_string@entry=0x5637a9299270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;") at ../src/backend/tcop/postgres.c:1273 [23:19:49.174] cmdtaglen = 7 [23:19:49.174] snapshot_set = [23:19:49.174] per_parsetree_context = 0x0 [23:19:49.174] plantree_list = 0x5637a93c20c8 [23:19:49.174] parsetree = 0x5637a929a790 [23:19:49.174] commandTag = [23:19:49.174] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [23:19:49.174] querytree_list = [23:19:49.174] portal = 0x5637a9315f90 [23:19:49.174] receiver = 0x5637a93c2118 [23:19:49.174] format = 0 [23:19:49.174] cmdtagname = [23:19:49.174] parsetree_item__state = {l = , i = } [23:19:49.174] dest = DestRemote [23:19:49.174] oldcontext = 0x5637a92c1b80 [23:19:49.174] parsetree_list = 0x5637a929a7c0 [23:19:49.174] parsetree_item = 0x5637a929a7d8 [23:19:49.174] save_log_statement_stats = false [23:19:49.174] was_logged = false [23:19:49.174] use_implicit_block = false [23:19:49.174] msec_str = "\000\000\000\000\000\000\000\000$P\023\247\067V\000\000\360`\\\026\375\177\000\000q\000\000\000\000\000\000" [23:19:49.174] __func__ = "exec_simple_query" [23:19:49.174] #19 0x00005637a6e6a6da in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4672 [23:19:49.174] query_string = 0x5637a9299270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;" [23:19:49.174] firstchar = [23:19:49.174] input_message = {data = 0x5637a9299270 "explain (verbose, costs off)\nselect c2, sum(c1) from ft1 where c2 < 3 group by rollup(c2) order by 1 nulls last;", len = 113, maxlen = 1024, cursor = 113} [23:19:49.174] local_sigjmp_buf = {{__jmpbuf = {94797038569496, -9072320138592092784, 140724978606720, 0, 140724978606868, 1, -3346799316802437744, -9072318152524792432}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140291338812900, 94797061238528, 15616, 15680, 94797026366373, 94797038569504, 94797061263728, 94797038563608, 0, 140724978606868, 94797026370441, 1}}}} [23:19:49.174] send_ready_for_query = false [23:19:49.174] idle_in_transaction_timeout_enabled = false [23:19:49.174] idle_session_timeout_enabled = false [23:19:49.174] __func__ = "PostgresMain" [23:19:49.174] #20 0x00005637a6d0dbef in BackendRun () at ../src/backend/postmaster/postmaster.c:4452 [23:19:49.174] No locals. [23:19:49.174] #21 0x00005637a6d13434 in BackendStartup (client_sock=client_sock@entry=0x7ffd165c6280) at ../src/backend/postmaster/postmaster.c:4117 [23:19:49.174] bn = 0x5637a92c1c58 [23:19:49.174] pid = 0 [23:19:49.174] cac = CAC_OK [23:19:49.174] __func__ = "BackendStartup" [23:19:49.174] #22 0x00005637a6d1384d in ServerLoop () at ../src/backend/postmaster/postmaster.c:1780 [23:19:49.174] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\177\037\230\177\000\000\001\000\000\000\000\000\000\000\244\323\371 \230\177\000\000-\000\000\000\000\000\000\000\020\376b\037\230\177\000\000 \311\062 \230\177\000\000Hc\\\026\375\177\000\000Dc\\\026\375\177\000\000\004c\\\026\375\177\000\000@n\000\000\001\000\000\000\000\000\000\000\067V\000\000\020\376b\037\230\177\000\000\340\037b\037\230\177\000\000\352_\177\037\230\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [23:19:49.174] i = 0 [23:19:49.174] now = [23:19:49.174] last_lockfile_recheck_time = 1710371796 [23:19:49.174] last_touch_time = 1710371796 [23:19:49.174] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 375153664, events = 32765, fd = 45, user_data = 0x7ffd165c63c0}, {pos = 375153616, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = 540198792, user_data = 0x7f981f7f5fea}, {pos = 375153832, events = 32765, fd = 375153664, user_data = 0x7ffd165c6410}, {pos = 553245921, events = 32664, fd = 18, user_data = 0x7f981cff3618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 540197920, events = 32664, fd = -1, user_data = 0x7f981cff3618}, {pos = 540197920, events = 32664, fd = 1024, user_data = 0x7f982032c788}, {pos = 0, events = 0, fd = 8, user_data = 0x7ffd165c6410}, {pos = -1, events = 0, fd = 527305914, user_data = 0x7f981f622418}, {pos = 540199200, events = 32664, fd = -1456706536, user_data = 0x5637a92c4718}, {pos = -1456739840, events = 22071, fd = -1456706504, user_data = 0x5637a92c6b71}, {pos = 553264675, events = 32664, fd = 1, user_data = 0x7f981f80f0f8 <__libc_fork@got.plt>}, {pos = 8, events = 0, fd = -1456885648, user_data = 0x1}, {pos = 1, events = 0, fd = -1456885696, user_data = 0x7f9820fa2623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x5637a92bea00}, {pos = 526525464, events = 32664, fd = 375154800, user_data = 0x7f9820fa968a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffd165c6890}, {pos = -1479645728, events = 22071, fd = 2, user_data = 0x5637a7ce65e0 }, {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 = -1456712792, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffff000000}, {pos = -1, events = 4294967295, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1735684975, user_data = 0x726765722f776466}, {pos = 1919509295, events = 762541426, fd = 1647143267, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = 527043579, user_data = 0x400}, {pos = -1456902240, events = 22071, fd = 528389248, user_data = 0x1a9296fa0}, {pos = 784, events = 0, fd = -1489518484, user_data = 0x5637a92c43f0}, {pos = 674063104, events = 2762789110, fd = 4, user_data = 0x5637a92c5370}, {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 = 0x5637a92c43f0}, {pos = 1, events = 0, fd = -1456716616, user_data = 0x400}, {pos = 0, events = 0, fd = -1491710647, user_data = 0x5637a7cf47d0 }, {pos = -1491776971, events = 22071, fd = -1456716816, user_data = 0x5637a9299170}, {pos = -1456716816, events = 22071, fd = 15, user_data = 0x4a}, {pos = -1491708879, events = 22071, fd = -1456716816, user_data = 0x5637a7165573 }, {pos = -1456902240, events = 22071, fd = 527043579, user_data = 0x0}, {pos = -1498221979, events = 22071, fd = -1456728208, user_data = 0x1a9296fa0}, {pos = 375154952, events = 32765, fd = 0, user_data = 0x5637a92c43f0}, {pos = 527028650, events = 32664, fd = 1024, user_data = 0x5637a9296fa0}, {pos = 527022320, events = 32664, fd = 0, user_data = 0x563700000000}, {pos = 0, events = 0, fd = -1456902240, user_data = 0xb}, {pos = 0, events = 0, fd = 0, user_data = 0x8dc8}, {pos = 527325957, events = 32664, fd = 8, user_data = 0xa4acd0f6282d6300}, {pos = 1, events = 0, fd = -1496270995, user_data = 0x400000}, {pos = 1, events = 0, fd = 0, user_data = 0x5637a7165431 }, {pos = -1456728208, events = 22071, fd = -1491708557, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x5637a6b2ee38 }, {pos = 0, events = 0, fd = -1498199026, user_data = 0x5637a9299170}, {pos = -1496243764, events = 22071, fd = 0, user_data = 0x0}} [23:19:49.175] nevents = 1 [23:19:49.175] __func__ = "ServerLoop" [23:19:49.175] #23 0x00005637a6d15267 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5637a9292e60) at ../src/backend/postmaster/postmaster.c:1478 [23:19:49.175] opt = [23:19:49.175] status = [23:19:49.175] userDoption = [23:19:49.175] listen_addr_saved = false [23:19:49.175] output_config_variable = [23:19:49.175] __func__ = "PostmasterMain" [23:19:49.175] #24 0x00005637a6b3fc68 in main (argc=8, argv=0x5637a9292e60) at ../src/backend/main/main.c:197 [23:19:49.175] do_check_root =