[08:01:10.848] src/tools/ci/cores_backtrace.sh linux /tmp/cores [08:01:11.076] dumping /tmp/cores/postgres-6-36527.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:01:11.351] [New LWP 36527] [08:01:11.351] [08:01:11.351] This GDB supports auto-downloading debuginfo from the following URLs: [08:01:11.351] [08:01:11.351] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:01:11.351] Debuginfod has been disabled. [08:01:11.351] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:01:11.619] [Thread debugging using libthread_db enabled] [08:01:11.619] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:01:11.619] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [08:01:11.619] Program terminated with signal SIGABRT, Aborted. [08:01:11.619] #0 0x00007fdac66a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:12.673] [08:01:12.673] Thread 1 (Thread 0x7fdac65d6a80 (LWP 36527)): [08:01:12.673] #0 0x00007fdac66a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:12.673] No symbol table info available. [08:01:12.673] #1 0x00007fdac665afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:12.673] No symbol table info available. [08:01:12.673] #2 0x00007fdac6645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:12.673] No symbol table info available. [08:01:12.673] #3 0x000055f124e695b9 in ExceptionalCondition (conditionName=conditionName@entry=0x55f12509ce49 "n >= 0 && n < list->length", fileName=fileName@entry=0x55f125097d60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:01:12.673] No locals. [08:01:12.673] #4 0x000055f12497b6ea in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:01:12.673] No locals. [08:01:12.673] #5 0x000055f12497b71f in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:01:12.673] No locals. [08:01:12.673] #6 0x000055f124980e51 in var_is_nonnullable (root=0x55f157d2e968, var=var@entry=0x55f157e092d8, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:01:12.673] rte = [08:01:12.673] notnullattnums = 0x0 [08:01:12.673] #7 0x000055f124984d1e in eval_const_expressions_mutator (node=node@entry=0x55f157e09258, context=context@entry=0x7ffe4012b0a0) at ../src/backend/optimizer/util/clauses.c:3556 [08:01:12.673] varg = 0x55f157e092d8 [08:01:12.673] result = [08:01:12.673] ntest = 0x55f157e09258 [08:01:12.673] newntest = [08:01:12.673] arg = 0x55f157e092d8 [08:01:12.673] __func__ = "eval_const_expressions_mutator" [08:01:12.673] #8 0x000055f124985dac in simplify_and_arguments (args=, context=context@entry=0x7ffe4012b0a0, haveNull=haveNull@entry=0x7ffe4012b04c, forceFalse=forceFalse@entry=0x7ffe4012b050) at ../src/backend/optimizer/util/clauses.c:3964 [08:01:12.673] arg = 0x55f157e09258 [08:01:12.673] newargs = 0x55f157e09468 [08:01:12.673] unprocessed_args = 0x0 [08:01:12.673] #9 0x000055f124982da6 in eval_const_expressions_mutator (node=0x55f157e09098, context=context@entry=0x7ffe4012b0a0) at ../src/backend/optimizer/util/clauses.c:2877 [08:01:12.673] newargs = [08:01:12.673] haveNull = false [08:01:12.673] forceFalse = false [08:01:12.673] expr = 0x55f157e09098 [08:01:12.673] __func__ = "eval_const_expressions_mutator" [08:01:12.673] #10 0x000055f1249858e2 in eval_const_expressions (root=root@entry=0x55f157d2e968, node=node@entry=0x55f157e09098) at ../src/backend/optimizer/util/clauses.c:2272 [08:01:12.673] context = {boundParams = 0x0, root = 0x55f157d2e968, active_fns = 0x0, case_val = 0x0, estimate = false} [08:01:12.673] #11 0x000055f12495ed85 in convert_EXISTS_sublink_to_join (root=0x55f157d2e968, sublink=sublink@entry=0x55f157d05e70, under_not=under_not@entry=false, available_rels=available_rels@entry=0x55f157d2ee98) at ../src/backend/optimizer/plan/subselect.c:1541 [08:01:12.673] je = [08:01:12.673] lc__state = [08:01:12.673] result = [08:01:12.673] parse = 0x55f157d06290 [08:01:12.673] subselect = 0x55f157f3c278 [08:01:12.673] whereClause = 0x55f157e09098 [08:01:12.673] subroot = {type = 613929440, parse = 0x7ffe4012b5d0, glob = 0x1, query_level = 613054688, parent_root = 0x55f157dfa948, plan_params = 0x55f1248a684d , outer_params = 0x55f157d40498, simple_rel_array = 0x55f157d05c90, simple_rel_array_size = 0, simple_rte_array = 0x7ffe4012b5d0, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x55f12497d2fa , join_rel_list = 0x74a6, join_rel_hash = 0x55f157dfa998, join_rel_level = 0x55f12497d1e0 , join_cur_level = 1074968016, init_plans = 0x1, cte_plan_ids = 0x55f1248a7f3e , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 216, canon_pathkeys = 0x55f12497d1e0 , left_join_clauses = 0x7ffe4012b5d0, right_join_clauses = 0x7ffe4012b5d0, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = 613052193, all_result_relids = 0x7ffe4012b340, leaf_result_relids = 0x55f157df9ad0, append_rel_list = 0x55f12497d1e0 , row_identity_vars = 0x55f157e02ad8, rowMarks = 0x0, placeholder_list = 0x7ffe4012b5d0, placeholder_array = 0x7ffe4012b5d0, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x55f12497d2fa , group_pathkeys = 0x55f12497d1e0 , num_groupby_pathkeys = 1474308872, window_pathkeys = 0x55f12497d1e0 , distinct_pathkeys = 0x55f157dfa340, sort_pathkeys = 0x55f12497d1e0 , setop_pathkeys = 0x7ffe4012b5d0, part_schemes = 0x0, initial_rels = 0x55f1248a892d , upper_rels = {0x55f157d66cc8, 0x55f157df9938, 0x3, 0x3, 0x0, 0x55f124ead1c9 , 0x55f157dfca70, 0x400}, upper_targets = {0x7, 0x55f124eae30a , 0x24012b5d0, 0x7, 0x0, 0x400, 0x55f157dfcc00, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x55f124ec3526 , grouping_map = 0x20, minmax_aggs = 0x55f157dfcc00, planner_cxt = 0x0, total_table_pages = 4.6686335405925019e-310, tuple_fraction = 4.6686757200094328e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 10, placeholdersFrozen = 227, hasRecursion = 234, group_rtindex = 22001, agginfos = 0x57dfcb70, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x55f157d2ee00, isUsedSubplan = 0x0, join_search_private = 0x55f124ec3a02 , partColsUpdated = 184, partPruneInfos = 0x0} [08:01:12.673] rtoffset = [08:01:12.673] varno = [08:01:12.673] clause_varnos = [08:01:12.673] upper_varnos = [08:01:12.673] lc = [08:01:12.673] newWhere = 0x0 [08:01:12.673] all_clauses = 0x55f157e09048 [08:01:12.673] upper_reference_exists = false [08:01:12.673] #12 0x000055f124969ba5 in pull_up_sublinks_qual_recurse (root=root@entry=0x55f157d2e968, node=0x55f157d05e70, jtlink1=jtlink1@entry=0x55f157d2ee00, available_rels1=0x55f157d2ee98, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:01:12.673] sublink = 0x55f157d05e70 [08:01:12.673] j = [08:01:12.673] child_rels = 0x55f157d05ec0 [08:01:12.673] #13 0x000055f124969679 in pull_up_sublinks_jointree_recurse (root=root@entry=0x55f157d2e968, jtnode=, relids=relids@entry=0x7ffe4012b518) at ../src/backend/optimizer/prep/prepjointree.c:776 [08:01:12.673] j = 0x55f157d2ede8 [08:01:12.673] leftrelids = 0x55f157d2ee78 [08:01:12.673] rightrelids = 0x55f157d2ee98 [08:01:12.673] jtlink = 0x55f157d2ede8 [08:01:12.673] __func__ = "pull_up_sublinks_jointree_recurse" [08:01:12.673] #14 0x000055f1249697ad in pull_up_sublinks_jointree_recurse (root=root@entry=0x55f157d2e968, jtnode=0x55f157e03af8, relids=relids@entry=0x7ffe4012b568) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:01:12.673] newchild = [08:01:12.673] childrelids = 0x40030000a9db [08:01:12.673] l__state = [08:01:12.673] frelids = 0x0 [08:01:12.673] newf = [08:01:12.673] jtlink = 0x40030000a9db [08:01:12.673] f = 0x55f157e03af8 [08:01:12.673] newfromlist = 0x0 [08:01:12.673] l = [08:01:12.673] __func__ = "pull_up_sublinks_jointree_recurse" [08:01:12.673] #15 0x000055f12496b793 in pull_up_sublinks (root=root@entry=0x55f157d2e968) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:01:12.673] jtnode = [08:01:12.673] relids = 0x55f157d06290 [08:01:12.673] #16 0x000055f124949b8e in subquery_planner (glob=glob@entry=0x55f157d40738, parse=parse@entry=0x55f157d06290, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [08:01:12.673] root = 0x55f157d2e968 [08:01:12.673] newWithCheckOptions = [08:01:12.673] newHaving = [08:01:12.673] hasOuterJoins = [08:01:12.673] hasResultRTEs = [08:01:12.673] final_rel = [08:01:12.673] l = [08:01:12.673] #17 0x000055f12494bd78 in standard_planner (parse=0x55f157d06290, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:442 [08:01:12.673] result = [08:01:12.673] glob = 0x55f157d40738 [08:01:12.673] tuple_fraction = 0 [08:01:12.673] root = [08:01:12.673] final_rel = [08:01:12.673] best_path = [08:01:12.673] top_plan = [08:01:12.673] lp = [08:01:12.673] lr = [08:01:12.673] #18 0x000055f12494ce8e in planner (parse=parse@entry=0x55f157d06290, query_string=query_string@entry=0x55f157d046c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:301 [08:01:12.673] result = [08:01:12.673] #19 0x000055f124bcc278 in pg_plan_query (querytree=querytree@entry=0x55f157d06290, query_string=query_string@entry=0x55f157d046c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [08:01:12.673] plan = [08:01:12.673] #20 0x000055f1246a1759 in standard_ExplainOneQuery (query=0x55f157d06290, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55f157d40498, queryString=0x55f157d046c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [08:01:12.673] plan = [08:01:12.673] planstart = [08:01:12.673] planduration = {ticks = 94494188478473} [08:01:12.673] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94494194852618, shared_blks_dirtied = 1074968510, shared_blks_written = 3, local_blks_hit = 4294967440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94495048753808, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94494194940009}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94494188475854}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94495048753808}} [08:01:12.673] bufusage = {shared_blks_hit = 1, shared_blks_read = 94494191587010, shared_blks_dirtied = 186758062948355, shared_blks_written = 72057594037927936, local_blks_hit = 140577409684576, local_blks_read = 94495049747528, local_blks_dirtied = 94495048753808, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 94494194464322, shared_blk_read_time = {ticks = 140577409684576}, shared_blk_write_time = {ticks = 94494194464341}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94494194848201}, temp_blk_read_time = {ticks = 94495048569104}, temp_blk_write_time = {ticks = 64}} [08:01:12.673] mem_counters = {nblocks = 94495051071960, freechunks = 8589934593, totalspace = 140729973389120, freespace = 10} [08:01:12.673] planner_ctx = 0x0 [08:01:12.673] saved_ctx = 0x0 [08:01:12.673] #21 0x000055f1246a1a3f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55f157d40498, pstate=pstate@entry=0x55f157cd93c8, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [08:01:12.673] No locals. [08:01:12.673] #22 0x000055f1246a1ce7 in ExplainQuery (pstate=pstate@entry=0x55f157cd93c8, stmt=stmt@entry=0x55f157d060d0, params=params@entry=0x0, dest=dest@entry=0x55f157cd9338) at ../src/backend/commands/explain.c:223 [08:01:12.673] l__state = [08:01:12.673] l = 0x55f157f3c240 [08:01:12.673] es = 0x55f157d40498 [08:01:12.673] tstate = [08:01:12.673] jstate = [08:01:12.673] query = [08:01:12.673] rewritten = 0x55f157f3c228 [08:01:12.673] #23 0x000055f124bd71cb in standard_ProcessUtility (pstmt=0x55f157d06180, queryString=0x55f157d046c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55f157cd9338, qc=0x7ffe4012b9b0) at ../src/backend/tcop/utility.c:866 [08:01:12.673] parsetree = 0x55f157d060d0 [08:01:12.673] isTopLevel = true [08:01:12.673] isAtomicContext = false [08:01:12.673] pstate = 0x55f157cd93c8 [08:01:12.673] readonly_flags = [08:01:12.673] __func__ = "standard_ProcessUtility" [08:01:12.673] #24 0x000055f124bd7866 in ProcessUtility (pstmt=pstmt@entry=0x55f157d06180, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55f157cd9338, qc=0x7ffe4012b9b0) at ../src/backend/tcop/utility.c:523 [08:01:12.673] No locals. [08:01:12.673] #25 0x000055f124bd32b8 in PortalRunUtility (portal=portal@entry=0x55f157d893f0, pstmt=0x55f157d06180, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55f157cd9338, qc=qc@entry=0x7ffe4012b9b0) at ../src/backend/tcop/pquery.c:1153 [08:01:12.673] No locals. [08:01:12.673] #26 0x000055f124bd3b13 in FillPortalStore (portal=portal@entry=0x55f157d893f0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [08:01:12.673] treceiver = 0x55f157cd9338 [08:01:12.673] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:12.673] __func__ = "FillPortalStore" [08:01:12.673] #27 0x000055f124bd402e in PortalRun (portal=portal@entry=0x55f157d893f0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55f157e03dd8, altdest=altdest@entry=0x55f157e03dd8, qc=qc@entry=0x7ffe4012bb70) at ../src/backend/tcop/pquery.c:760 [08:01:12.673] _save_exception_stack = 0x7ffe4012bc20 [08:01:12.673] _save_context_stack = 0x0 [08:01:12.673] _local_sigjmp_buf = {{__jmpbuf = {0, -6295201701752338709, 94495049290736, 94495048753480, 94495048753456, 94495048753408, -235070626104211733, -6295445286489422101}, __mask_was_saved = 0, __saved_mask = {__val = {94494194852618, 1074969343, 4, 94495048753408, 112, 153, 94495049290736, 94495048753480, 94495048753456, 94495048753408, 94494194940418, 1, 2, 153, 94494183956037, 0}}}} [08:01:12.673] _do_rethrow = [08:01:12.673] result = [08:01:12.673] nprocessed = [08:01:12.673] saveTopTransactionResourceOwner = 0x55f157d45ea8 [08:01:12.673] saveTopTransactionContext = 0x55f157d9d890 [08:01:12.673] saveActivePortal = 0x0 [08:01:12.673] saveResourceOwner = 0x55f157d45ea8 [08:01:12.673] savePortalContext = 0x0 [08:01:12.673] saveMemoryContext = 0x55f157d9d890 [08:01:12.673] __func__ = "PortalRun" [08:01:12.673] #28 0x000055f124bccd66 in exec_simple_query (query_string=query_string@entry=0x55f157d046c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [08:01:12.673] cmdtaglen = 7 [08:01:12.673] snapshot_set = [08:01:12.673] per_parsetree_context = 0x0 [08:01:12.673] plantree_list = 0x55f157e03d88 [08:01:12.673] parsetree = 0x55f157d06100 [08:01:12.673] commandTag = [08:01:12.673] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:12.673] querytree_list = [08:01:12.673] portal = 0x55f157d893f0 [08:01:12.673] receiver = 0x55f157e03dd8 [08:01:12.673] format = 0 [08:01:12.673] cmdtagname = [08:01:12.673] parsetree_item__state = [08:01:12.673] dest = DestRemote [08:01:12.673] oldcontext = 0x55f157d9d890 [08:01:12.673] parsetree_list = 0x55f157d06130 [08:01:12.673] parsetree_item = 0x55f157d06148 [08:01:12.673] save_log_statement_stats = false [08:01:12.673] was_logged = false [08:01:12.673] use_implicit_block = false [08:01:12.673] msec_str = "\340у%\361U\000\000\326\371\350$\361U\000\000\000\274\022@\376\177\000\000\316\000\000\000\000\000\000" [08:01:12.673] __func__ = "exec_simple_query" [08:01:12.673] #29 0x000055f124bcffaf in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [08:01:12.673] query_string = 0x55f157d046c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [08:01:12.673] firstchar = [08:01:12.673] input_message = {data = 0x55f157d046c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [08:01:12.673] local_sigjmp_buf = {{__jmpbuf = {94494207935992, -6295443204197185813, 4, 94494204875232, 24, 19, -235070626037102869, -6295445284665162005}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94495048476832, 16128, 94494207930016, 94495049010784, 24, 94494194852166, 0, 9, 2, 94494207936000, 94495048476832, 94494207930016, 94494204875232, 24, 19}}}} [08:01:12.673] send_ready_for_query = false [08:01:12.673] idle_in_transaction_timeout_enabled = false [08:01:12.673] idle_session_timeout_enabled = false [08:01:12.673] __func__ = "PostgresMain" [08:01:12.673] #30 0x000055f124bc58b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:01:12.673] bsdata = [08:01:12.673] #31 0x000055f124a619fa in postmaster_child_launch (child_type=B_BACKEND, child_slot=19, startup_data=startup_data@entry=0x7ffe4012bd80, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffe4012bdf0) at ../src/backend/postmaster/launch_backend.c:290 [08:01:12.673] pid = [08:01:12.673] #32 0x000055f124a66fbe in BackendStartup (client_sock=client_sock@entry=0x7ffe4012bdf0) at ../src/backend/postmaster/postmaster.c:3590 [08:01:12.673] bn = 0x55f157d2ccb8 [08:01:12.673] pid = [08:01:12.673] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809250837222532, fork_started = 809250837222536} [08:01:12.673] cac = [08:01:12.673] __func__ = "BackendStartup" [08:01:12.673] #33 0x000055f124a694ea in ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:01:12.673] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\3006\271#\361U\000\000\030\375\264#\361U\000\000@\277\022@\376\177\000\0008\277\022@\376\177\000\000\225[\362\001\000\000\000\000p\252H\307\332\177\000\000-", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000hv\000\310\332\177\000\000\020\254H\307\332\177\000\000\340r\000\310\332\177\000\000\316)fR\000\000\000", __ss_align = 1074970496}, salen = 2}} [08:01:12.673] i = 0 [08:01:12.673] now = [08:01:12.673] last_lockfile_recheck_time = 1755935619 [08:01:12.673] last_touch_time = 1755935559 [08:01:12.673] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = 138, user_data = 0x0}, {pos = 1074970560, events = 32766, fd = -939668920, user_data = 0x11}, {pos = -951538672, events = 32730, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -939494688, user_data = 0x7ffe4012bf38}, {pos = 1074970432, events = 32766, fd = -939493784, user_data = 0x0}, {pos = 1473267416, events = 22001, fd = -966034758, user_data = 0x55f157d046d8}, {pos = 1, events = 22001, fd = 32768, user_data = 0xffffffff}, {pos = -966598624, events = 32730, fd = -944502256, user_data = 0x55f157cc7738}, {pos = 1473017368, events = 22001, fd = 1473453089, user_data = 0x7fdac7fe2ebe}, {pos = 1, events = 0, fd = -939494688, user_data = 0x1b4}, {pos = 625167776, events = 22001, fd = 0, user_data = 0x0}, {pos = 229, events = 0, fd = -939643202, user_data = 0x1}, {pos = 0, events = 0, fd = -966598624, user_data = 0x7fdac66f2e80 }, {pos = 16, events = 0, fd = 1074971552, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fdac7fe52ba}, {pos = 0, events = 0, fd = -966070828, user_data = 0x0}, {pos = 632352928, events = 22001, fd = 2, user_data = 0x0}, {pos = 1472985200, events = 22001, fd = 615888378, user_data = 0x55f157d36e00}, {pos = 615892178, events = 22001, fd = 1473474139, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -966564664, user_data = 0x7fdac669c880 }, {pos = -966956752, events = 32730, fd = 1074971760, user_data = 0x100007f00000002}, {pos = -966037347, events = 32730, fd = 2, user_data = 0x55f157d36e00}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -964748192, events = 32730, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, 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 = 21760, 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 = 1473448992, events = 22001, fd = 1080, user_data = 0x55f157cc7410}, {pos = 619371081, events = 22001, fd = 1024, user_data = 0x7fdac66b58ee}, {pos = -964765216, events = 32730, fd = -966127250, user_data = 0x100000400}, {pos = 7, events = 0, fd = 1473453120, user_data = 0x4974463184c7fc00}, {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 = 0x55f157cc7410}, {pos = 3, events = 0, fd = 0, user_data = 0x66db}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x106}, {pos = -965791597, events = 32730, fd = 1473016848, user_data = 0x1}, {pos = 1473017048, events = 22001, fd = 1024, user_data = 0x7ffe4012c478}, {pos = 619452250, events = 22001, fd = 632456624, user_data = 0x55f124eb01fa }, {pos = 1473016848, events = 22001, fd = 1473267136, user_data = 0x55f157cc7410}, {pos = -966043410, events = 32730, fd = 0, user_data = 0x55f124ec2028 }, {pos = 1473016848, events = 1, fd = 619454833, user_data = 0x55f157d045c0}, {pos = -966120783, events = 32730, fd = -966126352, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -2067268608, events = 1232356913, fd = 1472985200, user_data = 0x4974463184c7fc00}, {pos = 13, events = 0, fd = -2067268608, user_data = 0x0}, {pos = -966413767, events = 32730, fd = 0, user_data = 0x55f124a616e0 }, {pos = 4194304, events = 0, fd = 1473100832, user_data = 0x1}, {pos = 0, events = 0, fd = 1472985200, user_data = 0x55f124eb008e }, {pos = 1473100832, events = 22001, fd = 1473267136, user_data = 0x55f157cdbc20}, {pos = 1, events = 0, fd = 0, user_data = 0x55f124e6e061 }, {pos = 13, events = 0, fd = 1473444456, user_data = 0x55f157d2fa48}, {pos = 632354360, events = 22001, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 614865050, user_data = 0x55f157d045c0}, {pos = 614881958, events = 22001, fd = 628654608, user_data = 0x55f157d04f68}} [08:01:12.673] nevents = 1 [08:01:12.673] __func__ = "ServerLoop" [08:01:12.673] #34 0x000055f124a6adc4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55f157cc27b0) at ../src/backend/postmaster/postmaster.c:1403 [08:01:12.673] opt = [08:01:12.673] status = [08:01:12.673] userDoption = [08:01:12.673] listen_addr_saved = false [08:01:12.673] output_config_variable = [08:01:12.673] __func__ = "PostmasterMain" [08:01:12.673] #35 0x000055f124895711 in main (argc=4, argv=0x55f157cc27b0) at ../src/backend/main/main.c:231 [08:01:12.673] do_check_root = [08:01:12.673] dispatch_option = [08:01:12.713] -e [08:01:12.713] [08:01:12.713] [08:01:12.814] dumping /tmp/cores/postgres-6-36006.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:01:13.095] [New LWP 36006] [08:01:13.095] [08:01:13.095] This GDB supports auto-downloading debuginfo from the following URLs: [08:01:13.095] [08:01:13.095] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:01:13.095] Debuginfod has been disabled. [08:01:13.095] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:01:13.339] [Thread debugging using libthread_db enabled] [08:01:13.339] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:01:13.339] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [08:01:13.339] Program terminated with signal SIGABRT, Aborted. [08:01:13.339] #0 0x00007f0967ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.365] [08:01:14.365] Thread 1 (Thread 0x7f0965e1ea80 (LWP 36006)): [08:01:14.365] #0 0x00007f0967ea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.365] No symbol table info available. [08:01:14.365] #1 0x00007f0967e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.365] No symbol table info available. [08:01:14.365] #2 0x00007f0967e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.365] No symbol table info available. [08:01:14.365] #3 0x000055c7f3f455b9 in ExceptionalCondition (conditionName=conditionName@entry=0x55c7f4178e49 "n >= 0 && n < list->length", fileName=fileName@entry=0x55c7f4173d60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:01:14.365] No locals. [08:01:14.365] #4 0x000055c7f3a576ea in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:01:14.365] No locals. [08:01:14.365] #5 0x000055c7f3a5771f in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:01:14.365] No locals. [08:01:14.365] #6 0x000055c7f3a5ce51 in var_is_nonnullable (root=0x55c8210e0c98, var=var@entry=0x55c8211c6498, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:01:14.365] rte = [08:01:14.365] notnullattnums = 0x0 [08:01:14.365] #7 0x000055c7f3a60d1e in eval_const_expressions_mutator (node=node@entry=0x55c8211c6418, context=context@entry=0x7ffcb848c5e0) at ../src/backend/optimizer/util/clauses.c:3556 [08:01:14.365] varg = 0x55c8211c6498 [08:01:14.365] result = [08:01:14.365] ntest = 0x55c8211c6418 [08:01:14.365] newntest = [08:01:14.365] arg = 0x55c8211c6498 [08:01:14.365] __func__ = "eval_const_expressions_mutator" [08:01:14.365] #8 0x000055c7f3a61dac in simplify_and_arguments (args=, context=context@entry=0x7ffcb848c5e0, haveNull=haveNull@entry=0x7ffcb848c58c, forceFalse=forceFalse@entry=0x7ffcb848c590) at ../src/backend/optimizer/util/clauses.c:3964 [08:01:14.365] arg = 0x55c8211c6418 [08:01:14.365] newargs = 0x55c8211c6628 [08:01:14.365] unprocessed_args = 0x0 [08:01:14.365] #9 0x000055c7f3a5eda6 in eval_const_expressions_mutator (node=0x55c8211c6258, context=context@entry=0x7ffcb848c5e0) at ../src/backend/optimizer/util/clauses.c:2877 [08:01:14.365] newargs = [08:01:14.365] haveNull = false [08:01:14.365] forceFalse = false [08:01:14.365] expr = 0x55c8211c6258 [08:01:14.365] __func__ = "eval_const_expressions_mutator" [08:01:14.365] #10 0x000055c7f3a618e2 in eval_const_expressions (root=root@entry=0x55c8210e0c98, node=node@entry=0x55c8211c6258) at ../src/backend/optimizer/util/clauses.c:2272 [08:01:14.365] context = {boundParams = 0x0, root = 0x55c8210e0c98, active_fns = 0x0, case_val = 0x0, estimate = false} [08:01:14.365] #11 0x000055c7f3a3ad85 in convert_EXISTS_sublink_to_join (root=0x55c8210e0c98, sublink=sublink@entry=0x55c8210b7ec0, under_not=under_not@entry=false, available_rels=available_rels@entry=0x55c8210e11c8) at ../src/backend/optimizer/plan/subselect.c:1541 [08:01:14.365] je = [08:01:14.365] lc__state = [08:01:14.365] result = [08:01:14.365] parse = 0x55c8210b82e0 [08:01:14.365] subselect = 0x55c8210e3c28 [08:01:14.365] whereClause = 0x55c8211c6258 [08:01:14.365] subroot = {type = 4087714272, parse = 0x7ffcb848cb10, glob = 0x1, query_level = 4086839520, parent_root = 0x55c8211b6008, plan_params = 0x55c7f398284d , outer_params = 0x55c8211be198, simple_rel_array = 0x55c8210b7ce0, simple_rel_array_size = 0, simple_rte_array = 0x7ffcb848cb10, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x55c7f3a592fa , join_rel_list = 0x74a6, join_rel_hash = 0x55c8211b6058, join_rel_level = 0x55c7f3a591e0 , join_cur_level = -1203188976, init_plans = 0x1, cte_plan_ids = 0x55c7f3983f3e , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 152, canon_pathkeys = 0x55c7f3a591e0 , left_join_clauses = 0x7ffcb848cb10, right_join_clauses = 0x7ffcb848cb10, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = -208130271, all_result_relids = 0x7ffcb848c880, leaf_result_relids = 0x55c8211b5190, append_rel_list = 0x55c7f3a591e0 , row_identity_vars = 0x55c8211bfc98, rowMarks = 0x0, placeholder_list = 0x7ffcb848cb10, placeholder_array = 0x7ffcb848cb10, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x55c7f3a592fa , group_pathkeys = 0x55c7f3a591e0 , num_groupby_pathkeys = 555482312, window_pathkeys = 0x55c7f3a591e0 , distinct_pathkeys = 0x55c8211b5a00, sort_pathkeys = 0x55c7f3a591e0 , setop_pathkeys = 0x7ffcb848cb10, part_schemes = 0x0, initial_rels = 0x55c7f398492d , upper_rels = {0x55c8211194f8, 0x55c8211b4ff8, 0x3, 0x3, 0x0, 0x55c7f3f891c9 , 0x55c8211b8130, 0x400}, upper_targets = {0x7, 0x55c7f3f8a30a , 0x2b848cb10, 0x7, 0x0, 0x400, 0x55c8211b82c0, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x55c7f3f9f526 , grouping_map = 0x20, minmax_aggs = 0x55c8211b82c0, planner_cxt = 0x0, total_table_pages = 4.6598927860451013e-310, tuple_fraction = 4.6599301389584531e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 10, placeholdersFrozen = 163, hasRecursion = 248, group_rtindex = 21959, agginfos = 0x211b8230, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x55c8210e1130, isUsedSubplan = 0x0, join_search_private = 0x55c7f3f9fa02 , partColsUpdated = 37, partPruneInfos = 0x0} [08:01:14.365] rtoffset = [08:01:14.365] varno = [08:01:14.365] clause_varnos = [08:01:14.365] upper_varnos = [08:01:14.365] lc = [08:01:14.365] newWhere = 0x0 [08:01:14.365] all_clauses = 0x55c8211c6208 [08:01:14.365] upper_reference_exists = false [08:01:14.365] #12 0x000055c7f3a45ba5 in pull_up_sublinks_qual_recurse (root=root@entry=0x55c8210e0c98, node=0x55c8210b7ec0, jtlink1=jtlink1@entry=0x55c8210e1130, available_rels1=0x55c8210e11c8, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:01:14.365] sublink = 0x55c8210b7ec0 [08:01:14.365] j = [08:01:14.365] child_rels = 0x55c8210b7f10 [08:01:14.365] #13 0x000055c7f3a45679 in pull_up_sublinks_jointree_recurse (root=root@entry=0x55c8210e0c98, jtnode=, relids=relids@entry=0x7ffcb848ca58) at ../src/backend/optimizer/prep/prepjointree.c:776 [08:01:14.365] j = 0x55c8210e1118 [08:01:14.365] leftrelids = 0x55c8210e11a8 [08:01:14.365] rightrelids = 0x55c8210e11c8 [08:01:14.365] jtlink = 0x55c8210e1118 [08:01:14.365] __func__ = "pull_up_sublinks_jointree_recurse" [08:01:14.365] #14 0x000055c7f3a457ad in pull_up_sublinks_jointree_recurse (root=root@entry=0x55c8210e0c98, jtnode=0x55c8211c0cb8, relids=relids@entry=0x7ffcb848caa8) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:01:14.365] newchild = [08:01:14.365] childrelids = 0x40000000a9c4 [08:01:14.365] l__state = [08:01:14.365] frelids = 0x0 [08:01:14.365] newf = [08:01:14.365] jtlink = 0x40000000a9c4 [08:01:14.365] f = 0x55c8211c0cb8 [08:01:14.365] newfromlist = 0x0 [08:01:14.365] l = [08:01:14.365] __func__ = "pull_up_sublinks_jointree_recurse" [08:01:14.365] #15 0x000055c7f3a47793 in pull_up_sublinks (root=root@entry=0x55c8210e0c98) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:01:14.365] jtnode = [08:01:14.365] relids = 0x55c8210b82e0 [08:01:14.365] #16 0x000055c7f3a25b8e in subquery_planner (glob=glob@entry=0x55c8211be438, parse=parse@entry=0x55c8210b82e0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [08:01:14.365] root = 0x55c8210e0c98 [08:01:14.365] newWithCheckOptions = [08:01:14.365] newHaving = [08:01:14.365] hasOuterJoins = [08:01:14.365] hasResultRTEs = [08:01:14.365] final_rel = [08:01:14.365] l = [08:01:14.365] #17 0x000055c7f3a27d78 in standard_planner (parse=0x55c8210b82e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:442 [08:01:14.365] result = [08:01:14.365] glob = 0x55c8211be438 [08:01:14.365] tuple_fraction = 0 [08:01:14.365] root = [08:01:14.365] final_rel = [08:01:14.365] best_path = [08:01:14.365] top_plan = [08:01:14.365] lp = [08:01:14.365] lr = [08:01:14.365] #18 0x000055c7f3a28e8e in planner (parse=parse@entry=0x55c8210b82e0, query_string=query_string@entry=0x55c8210b6710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:301 [08:01:14.365] result = [08:01:14.365] #19 0x000055c7f3ca8278 in pg_plan_query (querytree=querytree@entry=0x55c8210b82e0, query_string=query_string@entry=0x55c8210b6710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [08:01:14.365] plan = [08:01:14.365] #20 0x000055c7f377d759 in standard_ExplainOneQuery (query=0x55c8210b82e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55c8211be198, queryString=0x55c8210b6710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [08:01:14.365] plan = [08:01:14.365] planstart = [08:01:14.365] planduration = {ticks = 94317273636873} [08:01:14.365] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94317280011018, shared_blks_dirtied = 3091778814, shared_blks_written = 3, local_blks_hit = 4294967440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94318036222688, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94317280098409}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94317273634254}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94318036222688}} [08:01:14.365] bufusage = {shared_blks_hit = 1, shared_blks_read = 94317276745410, shared_blks_dirtied = 186659278700544, shared_blks_written = 72057594037927936, local_blks_hit = 139678171952224, local_blks_read = 94318037254920, local_blks_dirtied = 94318036222688, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 94317279622722, shared_blk_read_time = {ticks = 139678171952224}, shared_blk_write_time = {ticks = 94317279622741}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94317280006601}, temp_blk_read_time = {ticks = 94318036037984}, temp_blk_write_time = {ticks = 64}} [08:01:14.365] mem_counters = {nblocks = 94318036401032, freechunks = 8589934593, totalspace = 140723400264832, freespace = 10} [08:01:14.365] planner_ctx = 0x0 [08:01:14.365] saved_ctx = 0x0 [08:01:14.365] #21 0x000055c7f377da3f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55c8211be198, pstate=pstate@entry=0x55c82108b418, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [08:01:14.365] No locals. [08:01:14.365] #22 0x000055c7f377dce7 in ExplainQuery (pstate=pstate@entry=0x55c82108b418, stmt=stmt@entry=0x55c8210b8120, params=params@entry=0x0, dest=dest@entry=0x55c82108b388) at ../src/backend/commands/explain.c:223 [08:01:14.365] l__state = [08:01:14.365] l = 0x55c8210e3bf0 [08:01:14.365] es = 0x55c8211be198 [08:01:14.365] tstate = [08:01:14.365] jstate = [08:01:14.365] query = [08:01:14.365] rewritten = 0x55c8210e3bd8 [08:01:14.365] #23 0x000055c7f3cb31cb in standard_ProcessUtility (pstmt=0x55c8210b81d0, queryString=0x55c8210b6710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55c82108b388, qc=0x7ffcb848cef0) at ../src/backend/tcop/utility.c:866 [08:01:14.365] parsetree = 0x55c8210b8120 [08:01:14.365] isTopLevel = true [08:01:14.365] isAtomicContext = false [08:01:14.365] pstate = 0x55c82108b418 [08:01:14.365] readonly_flags = [08:01:14.365] __func__ = "standard_ProcessUtility" [08:01:14.365] #24 0x000055c7f3cb3866 in ProcessUtility (pstmt=pstmt@entry=0x55c8210b81d0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55c82108b388, qc=0x7ffcb848cef0) at ../src/backend/tcop/utility.c:523 [08:01:14.365] No locals. [08:01:14.365] #25 0x000055c7f3caf2b8 in PortalRunUtility (portal=portal@entry=0x55c82113bc20, pstmt=0x55c8210b81d0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55c82108b388, qc=qc@entry=0x7ffcb848cef0) at ../src/backend/tcop/pquery.c:1153 [08:01:14.365] No locals. [08:01:14.365] #26 0x000055c7f3cafb13 in FillPortalStore (portal=portal@entry=0x55c82113bc20, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [08:01:14.365] treceiver = 0x55c82108b388 [08:01:14.365] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:14.365] __func__ = "FillPortalStore" [08:01:14.365] #27 0x000055c7f3cb002e in PortalRun (portal=portal@entry=0x55c82113bc20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55c8211c0f98, altdest=altdest@entry=0x55c8211c0f98, qc=qc@entry=0x7ffcb848d0b0) at ../src/backend/tcop/pquery.c:760 [08:01:14.365] _save_exception_stack = 0x7ffcb848d160 [08:01:14.365] _save_context_stack = 0x0 [08:01:14.365] _local_sigjmp_buf = {{__jmpbuf = {0, -612435627658206709, 94318036761632, 94318036222360, 94318036222336, 94318036222288, -6635768576855530997, -603600377994436085}, __mask_was_saved = 0, __saved_mask = {__val = {94317280011018, 3091779647, 4, 94318036222288, 112, 153, 94318036761632, 94318036222360, 94318036222336, 94318036222288, 94317280098818, 1, 2, 153, 94317269114437, 0}}}} [08:01:14.365] _do_rethrow = [08:01:14.365] result = [08:01:14.365] nprocessed = [08:01:14.365] saveTopTransactionResourceOwner = 0x55c8210f99e8 [08:01:14.365] saveTopTransactionContext = 0x55c8211504c0 [08:01:14.365] saveActivePortal = 0x0 [08:01:14.365] saveResourceOwner = 0x55c8210f99e8 [08:01:14.365] savePortalContext = 0x0 [08:01:14.365] saveMemoryContext = 0x55c8211504c0 [08:01:14.365] __func__ = "PortalRun" [08:01:14.365] #28 0x000055c7f3ca8d66 in exec_simple_query (query_string=query_string@entry=0x55c8210b6710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [08:01:14.365] cmdtaglen = 7 [08:01:14.365] snapshot_set = [08:01:14.365] per_parsetree_context = 0x0 [08:01:14.365] plantree_list = 0x55c8211c0f48 [08:01:14.365] parsetree = 0x55c8210b8150 [08:01:14.365] commandTag = [08:01:14.365] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:14.365] querytree_list = [08:01:14.365] portal = 0x55c82113bc20 [08:01:14.365] receiver = 0x55c8211c0f98 [08:01:14.365] format = 0 [08:01:14.365] cmdtagname = [08:01:14.365] parsetree_item__state = [08:01:14.365] dest = DestRemote [08:01:14.365] oldcontext = 0x55c8211504c0 [08:01:14.365] parsetree_list = 0x55c8210b8180 [08:01:14.365] parsetree_item = 0x55c8210b8198 [08:01:14.365] save_log_statement_stats = false [08:01:14.365] was_logged = false [08:01:14.365] use_implicit_block = false [08:01:14.365] msec_str = "\340\221\221\364\307U\000\000ֹ\366\363\307U\000\000@\321H\270\374\177\000\000\316\000\000\000\000\000\000" [08:01:14.365] __func__ = "exec_simple_query" [08:01:14.365] #29 0x000055c7f3cabfaf in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [08:01:14.365] query_string = 0x55c8210b6710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [08:01:14.365] firstchar = [08:01:14.365] input_message = {data = 0x55c8210b6710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [08:01:14.365] local_sigjmp_buf = {{__jmpbuf = {94317293094392, -603593735504944629, 4, 94317290033632, 24, 18, -6635768576788422133, -603600376169651701}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94318035945680, 17408, 94317293088416, 94318036480400, 24, 94317280010566, 0, 10, 2, 94317293094400, 94318035945680, 94317293088416, 94317290033632, 24, 18}}}} [08:01:14.365] send_ready_for_query = false [08:01:14.365] idle_in_transaction_timeout_enabled = false [08:01:14.365] idle_session_timeout_enabled = false [08:01:14.365] __func__ = "PostgresMain" [08:01:14.365] #30 0x000055c7f3ca18b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:01:14.365] bsdata = [08:01:14.365] #31 0x000055c7f3b3d9fa in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x7ffcb848d2c0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffcb848d330) at ../src/backend/postmaster/launch_backend.c:290 [08:01:14.365] pid = [08:01:14.365] #32 0x000055c7f3b42fbe in BackendStartup (client_sock=client_sock@entry=0x7ffcb848d330) at ../src/backend/postmaster/postmaster.c:3590 [08:01:14.365] bn = 0x55c8210defb8 [08:01:14.365] pid = [08:01:14.365] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809250833745847, fork_started = 809250833745850} [08:01:14.365] cac = [08:01:14.365] __func__ = "BackendStartup" [08:01:14.365] #33 0x000055c7f3b454ea in ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:01:14.365] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\300\366\306\362\307U\000\000\030\275\302\362\307U\000\000\200\324H\270\374\177\000\000x\324H\270\374\177\000\000\225[\362\001\000\000\000\000p\252\310h\t\177\000\000-", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\326yi\t\177\000\000\020\254\310h\t\177\000\000\340\322yi\t\177\000\000\316)fR\000\000\000", __ss_align = 3091780800}, salen = 2}} [08:01:14.365] i = 0 [08:01:14.365] now = [08:01:14.365] last_lockfile_recheck_time = 1755935618 [08:01:14.365] last_touch_time = 1755935558 [08:01:14.365] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 1769591520, user_data = 0x0}, {pos = -1203186432, events = 32764, fd = 1769417288, user_data = 0x11}, {pos = 1757981712, events = 32521, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1769591520, user_data = 0x7ffcb848d478}, {pos = -1203186560, events = 32764, fd = 1769592424, user_data = 0x0}, {pos = 554395600, events = 21960, fd = 1743485626, user_data = 0x55c8210b67d0}, {pos = 1, events = 21959, fd = 32768, user_data = 0xffffffff}, {pos = 1742921760, events = 32521, fd = 1765276176, user_data = 0x55c821079768}, {pos = 554145352, events = 21960, fd = 554582801, user_data = 0x7f0969778ebe}, {pos = 1, events = 0, fd = 1769591520, user_data = 0x1b4}, {pos = -196014688, events = 21959, fd = 0, user_data = 0x0}, {pos = 249, events = 0, fd = 1769443006, user_data = 0x1}, {pos = 0, events = 0, fd = 1742921760, user_data = 0x7f0967ef2e80 }, {pos = 16, events = 0, fd = -1203185440, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f096977b2ba}, {pos = 0, events = 0, fd = 1743449556, user_data = 0x0}, {pos = -188829536, events = 21959, fd = 2, user_data = 0x0}, {pos = 554113136, events = 21960, fd = -205294086, user_data = 0x55c8210e9130}, {pos = -205290286, events = 21959, fd = 554602891, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 1742955720, user_data = 0x7f0967e9c880 }, {pos = 1709304112, events = 32521, fd = -1203185232, user_data = 0x100007f00000002}, {pos = 1743483037, events = 32521, fd = 2, user_data = 0x55c8210e9130}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = 1744772192, events = 32521, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1380540976, fd = 168454450, user_data = 0x39353537310a6174}, {pos = 892679475, events = 808716856, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, 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 = 554578704, events = 21960, fd = 1080, user_data = 0x55c821079440}, {pos = -201811383, events = 21959, fd = 1024, user_data = 0x7f0967eb58ee}, {pos = 1744755168, events = 32521, fd = 1743393134, user_data = 0x100000400}, {pos = 7, events = 0, fd = 554582832, user_data = 0x7e1ba42bdabd9200}, {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 = 0x55c821079440}, {pos = 3, events = 0, fd = 0, user_data = 0x66a4}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = 1743728787, events = 32521, fd = 554144832, user_data = 0x1}, {pos = 554145032, events = 21960, fd = 1024, user_data = 0x7ffcb848d9b8}, {pos = -201730214, events = 21959, fd = -188725840, user_data = 0x55c7f3f8c1fa }, {pos = 554144832, events = 21960, fd = 554395152, user_data = 0x55c821079440}, {pos = 1743476974, events = 32521, fd = 0, user_data = 0x55c7f3f9e028 }, {pos = 554144832, events = 1, fd = -201727631, user_data = 0x55c8210b6610}, {pos = 1743399601, events = 32521, fd = 1743394032, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -625110528, events = 2115740715, fd = 554113136, user_data = 0x7e1ba42bdabd9200}, {pos = 13, events = 0, fd = -625110528, user_data = 0x0}, {pos = 1743106617, events = 32521, fd = 0, user_data = 0x55c7f3b3d6e0 }, {pos = 4194304, events = 0, fd = 554228848, user_data = 0x1}, {pos = 0, events = 0, fd = 554113136, user_data = 0x55c7f3f8c08e }, {pos = 554228848, events = 21960, fd = 554395152, user_data = 0x55c82108dc70}, {pos = 1, events = 0, fd = 0, user_data = 0x55c7f3f4a061 }, {pos = 13, events = 0, fd = 554574168, user_data = 0x55c8210e2138}, {pos = -188828104, events = 21959, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -206317414, user_data = 0x55c8210b6610}, {pos = -206300506, events = 21959, fd = -192527856, user_data = 0x55c8210b6fe8}} [08:01:14.365] nevents = 1 [08:01:14.365] __func__ = "ServerLoop" [08:01:14.365] #34 0x000055c7f3b46dc4 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55c821074830) at ../src/backend/postmaster/postmaster.c:1403 [08:01:14.365] opt = [08:01:14.365] status = [08:01:14.365] userDoption = [08:01:14.365] listen_addr_saved = false [08:01:14.365] output_config_variable = [08:01:14.365] __func__ = "PostmasterMain" [08:01:14.365] #35 0x000055c7f3971711 in main (argc=8, argv=0x55c821074830) at ../src/backend/main/main.c:231 [08:01:14.365] do_check_root = [08:01:14.365] dispatch_option = [08:01:14.404] -e [08:01:14.404] [08:01:14.404] [08:01:14.471] dumping /tmp/cores/postgres-3-53539.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:01:14.733] [New LWP 53539] [08:01:14.733] [08:01:14.733] This GDB supports auto-downloading debuginfo from the following URLs: [08:01:14.733] [08:01:14.733] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:01:14.733] Debuginfod has been disabled. [08:01:14.733] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:01:14.837] [New LWP 53456] [08:01:14.837] [Thread debugging using libthread_db enabled] [08:01:14.837] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:01:14.837] Core was generated by `postgres: primary: archiver archiving 000000010000000000000003.00000028.backup'. [08:01:14.837] Program terminated with signal SIGQUIT, Quit. [08:01:14.837] #0 0x00007f4ac40aedd4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.843] [Current thread is 1 (LWP 53539)] [08:01:14.846] [08:01:14.846] Thread 2 (Thread 0x7f4ac3fd2a80 (LWP 53456)): [08:01:14.846] warning: Couldn't find general-purpose registers in core file. [08:01:14.846] #0 in ?? () [08:01:14.846] PC unavailable, cannot determine locals. [08:01:14.846] Backtrace stopped: not enough registers or memory available to unwind further [08:01:14.846] [08:01:14.846] Thread 1 (LWP 53539): [08:01:14.846] #0 0x00007f4ac40aedd4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.846] No symbol table info available. [08:01:14.846] #1 0x00007f4ac405b239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.846] No symbol table info available. [08:01:14.846] #2 0x00007f4ac4116244 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.846] No symbol table info available. [08:01:14.846] #3 0x00007f4ac412889c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:14.846] No symbol table info available. [08:01:14.864] -e [08:01:14.864] [08:01:14.864] [08:01:14.957] dumping /tmp/cores/postgres-6-47304.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:01:15.219] [New LWP 47304] [08:01:15.219] [08:01:15.219] This GDB supports auto-downloading debuginfo from the following URLs: [08:01:15.219] [08:01:15.219] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:01:15.219] Debuginfod has been disabled. [08:01:15.219] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:01:15.465] [Thread debugging using libthread_db enabled] [08:01:15.465] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:01:15.465] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [08:01:15.465] Program terminated with signal SIGABRT, Aborted. [08:01:15.465] #0 0x00007fcabb8a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:16.465] [08:01:16.465] Thread 1 (Thread 0x7fcabc033a80 (LWP 47304)): [08:01:16.465] #0 0x00007fcabb8a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:16.465] No symbol table info available. [08:01:16.465] #1 0x00007fcabb85afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:16.465] No symbol table info available. [08:01:16.465] #2 0x00007fcabb845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:01:16.465] No symbol table info available. [08:01:16.465] #3 0x000055726cfa85b9 in ExceptionalCondition (conditionName=conditionName@entry=0x55726d1dbe49 "n >= 0 && n < list->length", fileName=fileName@entry=0x55726d1d6d60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:01:16.465] No locals. [08:01:16.465] #4 0x000055726caba6ea in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:01:16.465] No locals. [08:01:16.465] #5 0x000055726caba71f in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:01:16.465] No locals. [08:01:16.465] #6 0x000055726cabfe51 in var_is_nonnullable (root=0x55728159a988, var=var@entry=0x557281658b38, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:01:16.465] rte = [08:01:16.465] notnullattnums = 0x0 [08:01:16.465] #7 0x000055726cac3d1e in eval_const_expressions_mutator (node=node@entry=0x557281658ab8, context=context@entry=0x7fffe604bfa0) at ../src/backend/optimizer/util/clauses.c:3556 [08:01:16.465] varg = 0x557281658b38 [08:01:16.465] result = [08:01:16.465] ntest = 0x557281658ab8 [08:01:16.465] newntest = [08:01:16.465] arg = 0x557281658b38 [08:01:16.465] __func__ = "eval_const_expressions_mutator" [08:01:16.465] #8 0x000055726cac4dac in simplify_and_arguments (args=, context=context@entry=0x7fffe604bfa0, haveNull=haveNull@entry=0x7fffe604bf4c, forceFalse=forceFalse@entry=0x7fffe604bf50) at ../src/backend/optimizer/util/clauses.c:3964 [08:01:16.465] arg = 0x557281658ab8 [08:01:16.465] newargs = 0x557281658cc8 [08:01:16.465] unprocessed_args = 0x0 [08:01:16.465] #9 0x000055726cac1da6 in eval_const_expressions_mutator (node=0x5572816588f8, context=context@entry=0x7fffe604bfa0) at ../src/backend/optimizer/util/clauses.c:2877 [08:01:16.465] newargs = [08:01:16.465] haveNull = false [08:01:16.465] forceFalse = false [08:01:16.465] expr = 0x5572816588f8 [08:01:16.465] __func__ = "eval_const_expressions_mutator" [08:01:16.465] #10 0x000055726cac48e2 in eval_const_expressions (root=root@entry=0x55728159a988, node=node@entry=0x5572816588f8) at ../src/backend/optimizer/util/clauses.c:2272 [08:01:16.465] context = {boundParams = 0x0, root = 0x55728159a988, active_fns = 0x0, case_val = 0x0, estimate = false} [08:01:16.465] #11 0x000055726ca9dd85 in convert_EXISTS_sublink_to_join (root=0x55728159a988, sublink=sublink@entry=0x557281564e90, under_not=under_not@entry=false, available_rels=available_rels@entry=0x55728159aeb8) at ../src/backend/optimizer/plan/subselect.c:1541 [08:01:16.465] je = [08:01:16.465] lc__state = [08:01:16.465] result = [08:01:16.465] parse = 0x5572815652b0 [08:01:16.465] subselect = 0x557281600428 [08:01:16.465] whereClause = 0x5572816588f8 [08:01:16.465] subroot = {type = 1823195616, parse = 0x7fffe604c4d0, glob = 0x1, query_level = 1822320864, parent_root = 0x55728168d188, plan_params = 0x55726c9e584d , outer_params = 0x55726d2abedf, simple_rel_array = 0x557281564cb0, simple_rel_array_size = 0, simple_rte_array = 0x7fffe604c4d0, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x55726cabc2fa , join_rel_list = 0x7fffe604c550, join_rel_hash = 0x55728168d1d8, join_rel_level = 0x55726cabc1e0 , join_cur_level = -435895088, init_plans = 0x1, cte_plan_ids = 0x55726c9e6f3e , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 40, canon_pathkeys = 0x55726cabc1e0 , left_join_clauses = 0x7fffe604c4d0, right_join_clauses = 0x7fffe604c4d0, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = 1822318369, all_result_relids = 0x55726d2abedf, leaf_result_relids = 0x55728168c310, append_rel_list = 0x55726cabc1e0 , row_identity_vars = 0x557281669128, rowMarks = 0x0, placeholder_list = 0x7fffe604c4d0, placeholder_array = 0x7fffe604c4d0, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x55726cabc2fa , group_pathkeys = 0x55726cabc1e0 , num_groupby_pathkeys = -2123984552, window_pathkeys = 0x55726cabc1e0 , distinct_pathkeys = 0x55728168cb80, sort_pathkeys = 0x55726cabc1e0 , setop_pathkeys = 0x7fffe604c4d0, part_schemes = 0x0, initial_rels = 0x55726c9e792d , upper_rels = {0x557281538130, 0x55728168c178, 0x3, 0x3, 0x0, 0x55726cfec1c9 , 0x5572816607b0, 0x400}, upper_targets = {0x7, 0x55726cfed30a , 0x2e604c4d0, 0x7, 0x0, 0x400, 0x557281660940, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x55726d002526 , grouping_map = 0x20, minmax_aggs = 0x557281660940, planner_cxt = 0x0, total_table_pages = 4.6417439397346669e-310, tuple_fraction = 4.6417607922319799e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 10, placeholdersFrozen = 211, hasRecursion = 254, group_rtindex = 21874, agginfos = 0x816608b0, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x55728159ae20, isUsedSubplan = 0x0, join_search_private = 0x55726d002a02 , partColsUpdated = 10, partPruneInfos = 0x0} [08:01:16.465] rtoffset = [08:01:16.465] varno = [08:01:16.465] clause_varnos = [08:01:16.465] upper_varnos = [08:01:16.465] lc = [08:01:16.465] newWhere = 0x0 [08:01:16.465] all_clauses = 0x5572816588a8 [08:01:16.465] upper_reference_exists = false [08:01:16.465] #12 0x000055726caa8ba5 in pull_up_sublinks_qual_recurse (root=root@entry=0x55728159a988, node=0x557281564e90, jtlink1=jtlink1@entry=0x55728159ae20, available_rels1=0x55728159aeb8, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:01:16.465] sublink = 0x557281564e90 [08:01:16.465] j = [08:01:16.465] child_rels = 0x557281564ee0 [08:01:16.465] #13 0x000055726caa8679 in pull_up_sublinks_jointree_recurse (root=root@entry=0x55728159a988, jtnode=, relids=relids@entry=0x7fffe604c418) at ../src/backend/optimizer/prep/prepjointree.c:776 [08:01:16.465] j = 0x55728159ae08 [08:01:16.465] leftrelids = 0x55728159ae98 [08:01:16.465] rightrelids = 0x55728159aeb8 [08:01:16.465] jtlink = 0x55728159ae08 [08:01:16.465] __func__ = "pull_up_sublinks_jointree_recurse" [08:01:16.465] #14 0x000055726caa87ad in pull_up_sublinks_jointree_recurse (root=root@entry=0x55728159a988, jtnode=0x55728166a148, relids=relids@entry=0x7fffe604c468) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:01:16.465] newchild = [08:01:16.465] childrelids = 0x40000000a98f [08:01:16.465] l__state = [08:01:16.465] frelids = 0x0 [08:01:16.465] newf = [08:01:16.465] jtlink = 0x40000000a98f [08:01:16.465] f = 0x55728166a148 [08:01:16.465] newfromlist = 0x0 [08:01:16.465] l = [08:01:16.465] __func__ = "pull_up_sublinks_jointree_recurse" [08:01:16.465] #15 0x000055726caaa793 in pull_up_sublinks (root=root@entry=0x55728159a988) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:01:16.465] jtnode = [08:01:16.465] relids = 0x5572815652b0 [08:01:16.465] #16 0x000055726ca88b8e in subquery_planner (glob=glob@entry=0x557281593cf8, parse=parse@entry=0x5572815652b0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [08:01:16.465] root = 0x55728159a988 [08:01:16.465] newWithCheckOptions = [08:01:16.465] newHaving = [08:01:16.465] hasOuterJoins = [08:01:16.465] hasResultRTEs = [08:01:16.465] final_rel = [08:01:16.465] l = [08:01:16.465] #17 0x000055726ca8ad78 in standard_planner (parse=parse@entry=0x5572815652b0, query_string=query_string@entry=0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:442 [08:01:16.465] result = [08:01:16.465] glob = 0x557281593cf8 [08:01:16.465] tuple_fraction = 0 [08:01:16.465] root = [08:01:16.465] final_rel = [08:01:16.465] best_path = [08:01:16.465] top_plan = [08:01:16.465] lp = [08:01:16.465] lr = [08:01:16.465] #18 0x00007fcab962b82d in pgss_planner (parse=0x5572815652b0, query_string=0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:983 [08:01:16.465] _save_exception_stack = 0x7fffe604cd40 [08:01:16.465] _save_context_stack = 0x0 [08:01:16.465] _local_sigjmp_buf = {{__jmpbuf = {93950284550832, -918300621588513623, 0, 2048, 93950284550832, 2048, -6459493551094743895, -6471116199163577175}, __mask_was_saved = 0, __saved_mask = {__val = {140508630758640, 93950285032248, 93950285029248, 1850504060, 93949942743532, 43407, 0, 0, 536435018256, 43407, 0, 140508630758704, 140508630758640, 0, 0, 140737052694956}}}} [08:01:16.465] _do_rethrow = false [08:01:16.465] result = 0x1e604c5d8 [08:01:16.465] #19 0x000055726ca8be5c in planner (parse=parse@entry=0x5572815652b0, query_string=query_string@entry=0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:299 [08:01:16.465] result = [08:01:16.465] #20 0x000055726cd0b278 in pg_plan_query (querytree=querytree@entry=0x5572815652b0, query_string=query_string@entry=0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [08:01:16.465] plan = [08:01:16.465] #21 0x000055726c7e0759 in standard_ExplainOneQuery (query=0x5572815652b0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x557281600398, queryString=0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [08:01:16.465] plan = [08:01:16.465] planstart = [08:01:16.465] planduration = {ticks = 93949936898057} [08:01:16.465] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93949943272202, shared_blks_dirtied = 3859073534, shared_blks_written = 3, local_blks_hit = 6465075864, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93950284550832, shared_blk_read_time = {ticks = -5159148872915149421}, shared_blk_write_time = {ticks = 93949943359593}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949936895438}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93950284550832}} [08:01:16.465] bufusage = {shared_blks_hit = 1, shared_blks_read = 93949940006594, shared_blks_dirtied = 186431645433856, shared_blks_written = 72057594037927936, local_blks_hit = 140508630721632, local_blks_read = 93950285755528, local_blks_dirtied = 93950284550832, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 93949942883906, shared_blk_read_time = {ticks = 140508630721632}, shared_blk_write_time = {ticks = 93949942883925}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949943267785}, temp_blk_read_time = {ticks = 93950284366128}, temp_blk_write_time = {ticks = 64}} [08:01:16.465] mem_counters = {nblocks = 93950284742152, freechunks = 8589934593, totalspace = 140737052461440, freespace = 10} [08:01:16.465] planner_ctx = 0x0 [08:01:16.465] saved_ctx = 0x0 [08:01:16.465] #22 0x000055726c7e0a3f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x557281600398, pstate=pstate@entry=0x5572815383e8, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [08:01:16.465] No locals. [08:01:16.465] #23 0x000055726c7e0ce7 in ExplainQuery (pstate=pstate@entry=0x5572815383e8, stmt=stmt@entry=0x5572815650f0, params=params@entry=0x0, dest=dest@entry=0x557281538358) at ../src/backend/commands/explain.c:223 [08:01:16.465] l__state = [08:01:16.465] l = 0x55728159a950 [08:01:16.465] es = 0x557281600398 [08:01:16.465] tstate = [08:01:16.465] jstate = [08:01:16.465] query = [08:01:16.465] rewritten = 0x55728159a938 [08:01:16.465] #24 0x000055726cd161cb in standard_ProcessUtility (pstmt=pstmt@entry=0x5572815651a0, queryString=queryString@entry=0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=readOnlyTree@entry=false, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x557281538358, qc=0x7fffe604cf80) at ../src/backend/tcop/utility.c:866 [08:01:16.465] parsetree = 0x5572815650f0 [08:01:16.465] isTopLevel = true [08:01:16.465] isAtomicContext = false [08:01:16.465] pstate = 0x5572815383e8 [08:01:16.465] readonly_flags = [08:01:16.465] __func__ = "standard_ProcessUtility" [08:01:16.465] #25 0x00007fcab962afa9 in pgss_ProcessUtility (pstmt=0x5572815651a0, queryString=0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x557281538358, qc=0x7fffe604cf80) at ../contrib/pg_stat_statements/pg_stat_statements.c:1181 [08:01:16.465] _save_exception_stack = 0x7fffe604d020 [08:01:16.465] _save_context_stack = 0x0 [08:01:16.465] _local_sigjmp_buf = {{__jmpbuf = {0, 6459438258407488681, 93950284550560, 93950284366680, 140737052462976, 1, -6459493551132492631, -6471116199863632727}, __mask_was_saved = 0, __saved_mask = {__val = {93949943143693, 93950284543456, 93949938582594, 2, 140737052462728, 93950285622122, 93950285622122, 93950285621224, 93949944709999, 446, 0, 93950285623576, 0, 93950285620104, 140508706599069, 1}}}} [08:01:16.465] _do_rethrow = false [08:01:16.465] duration = [08:01:16.465] bufusage = {shared_blks_hit = 0, shared_blks_read = 93949944163299, shared_blks_dirtied = 1, shared_blks_written = 93950284549296, local_blks_hit = 93950285620104, local_blks_read = 490, local_blks_dirtied = 1, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93949943267785, shared_blk_read_time = {ticks = 93950284543456}, shared_blk_write_time = {ticks = 93949943267785}, local_blk_read_time = {ticks = 93950284543456}, local_blk_write_time = {ticks = 3}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93949943272202}} [08:01:16.465] walusage_start = {wal_records = 60, wal_fpi = 0, wal_bytes = 6333, wal_buffers_full = 0} [08:01:16.465] start = [08:01:16.465] rows = [08:01:16.465] bufusage_start = {shared_blks_hit = 490, shared_blks_read = 63, shared_blks_dirtied = 12, shared_blks_written = 14, 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}} [08:01:16.465] walusage = {wal_records = 140737052462416, wal_fpi = 93949942747146, wal_bytes = 140737052462416, wal_buffers_full = 93949942942575} [08:01:16.465] parsetree = [08:01:16.465] saved_queryId = 3938666771540382425 [08:01:16.465] saved_stmt_location = 0 [08:01:16.465] saved_stmt_len = 204 [08:01:16.465] enabled = true [08:01:16.465] #26 0x000055726cd167b1 in ProcessUtility (pstmt=pstmt@entry=0x5572815651a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x557281538358, qc=0x7fffe604cf80) at ../src/backend/tcop/utility.c:519 [08:01:16.465] No locals. [08:01:16.465] #27 0x000055726cd122b8 in PortalRunUtility (portal=portal@entry=0x5572815e3f70, pstmt=0x5572815651a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x557281538358, qc=qc@entry=0x7fffe604cf80) at ../src/backend/tcop/pquery.c:1153 [08:01:16.465] No locals. [08:01:16.465] #28 0x000055726cd12b13 in FillPortalStore (portal=portal@entry=0x5572815e3f70, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [08:01:16.465] treceiver = 0x557281538358 [08:01:16.465] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:16.465] __func__ = "FillPortalStore" [08:01:16.465] #29 0x000055726cd1302e in PortalRun (portal=portal@entry=0x5572815e3f70, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55728166b2c8, altdest=altdest@entry=0x55728166b2c8, qc=qc@entry=0x7fffe604d140) at ../src/backend/tcop/pquery.c:760 [08:01:16.465] _save_exception_stack = 0x7fffe604d1f0 [08:01:16.465] _save_context_stack = 0x0 [08:01:16.465] _local_sigjmp_buf = {{__jmpbuf = {0, -918301038062977879, 93950285070192, 93950284550504, 93950284550480, 93950284550432, -6459493551270904663, -918644726650356567}, __mask_was_saved = 0, __saved_mask = {__val = {93949943272202, 3859075279, 4, 93950284550432, 112, 153, 93950285070192, 93950284550504, 93950284550480, 93950284550432, 93949943360002, 1, 2, 153, 93949932375621, 0}}}} [08:01:16.465] _do_rethrow = [08:01:16.465] result = [08:01:16.465] nprocessed = [08:01:16.465] saveTopTransactionResourceOwner = 0x5572815a7988 [08:01:16.465] saveTopTransactionContext = 0x5572815fa450 [08:01:16.465] saveActivePortal = 0x0 [08:01:16.465] saveResourceOwner = 0x5572815a7988 [08:01:16.465] savePortalContext = 0x0 [08:01:16.465] saveMemoryContext = 0x5572815fa450 [08:01:16.465] __func__ = "PortalRun" [08:01:16.465] #30 0x000055726cd0bd66 in exec_simple_query (query_string=query_string@entry=0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [08:01:16.465] cmdtaglen = 7 [08:01:16.465] snapshot_set = [08:01:16.465] per_parsetree_context = 0x0 [08:01:16.465] plantree_list = 0x55728166b278 [08:01:16.465] parsetree = 0x557281565120 [08:01:16.465] commandTag = [08:01:16.465] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:01:16.465] querytree_list = [08:01:16.465] portal = 0x5572815e3f70 [08:01:16.465] receiver = 0x55728166b2c8 [08:01:16.465] format = 0 [08:01:16.465] cmdtagname = [08:01:16.465] parsetree_item__state = [08:01:16.465] dest = DestRemote [08:01:16.465] oldcontext = 0x5572815fa450 [08:01:16.465] parsetree_list = 0x557281565150 [08:01:16.465] parsetree_item = 0x557281565168 [08:01:16.465] save_log_statement_stats = false [08:01:16.465] was_logged = true [08:01:16.465] use_implicit_block = false [08:01:16.465] msec_str = "\340\301\227mrU\000\000\326\351\374lrU\000\000\320\321\004\346\377\177\000\000\316\000\000\000\000\000\000" [08:01:16.465] __func__ = "exec_simple_query" [08:01:16.465] #31 0x000055726cd0efaf in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [08:01:16.465] query_string = 0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [08:01:16.465] firstchar = [08:01:16.465] input_message = {data = 0x5572815636e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [08:01:16.465] local_sigjmp_buf = {{__jmpbuf = {93949956355576, -918642705000416087, 4, 93949953294816, 24, 19, -6459493550398489431, -918644719918236503}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 93950284798256, 0, 168, 93949943272304, 0, 10, 2, 93949956355584, 93950284273888, 93949956349600, 93949953294816, 24, 19}}}} [08:01:16.465] send_ready_for_query = false [08:01:16.465] idle_in_transaction_timeout_enabled = false [08:01:16.465] idle_session_timeout_enabled = false [08:01:16.465] __func__ = "PostgresMain" [08:01:16.465] #32 0x000055726cd048b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:01:16.465] bsdata = [08:01:16.465] #33 0x000055726cba09fa in postmaster_child_launch (child_type=B_BACKEND, child_slot=19, startup_data=startup_data@entry=0x7fffe604d350, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fffe604d3c0) at ../src/backend/postmaster/launch_backend.c:290 [08:01:16.465] pid = [08:01:16.465] #34 0x000055726cba5fbe in BackendStartup (client_sock=client_sock@entry=0x7fffe604d3c0) at ../src/backend/postmaster/postmaster.c:3590 [08:01:16.465] bn = 0x55728158ef28 [08:01:16.465] pid = [08:01:16.465] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809250919396397, fork_started = 809250919396399} [08:01:16.465] cac = [08:01:16.465] __func__ = "BackendStartup" [08:01:16.465] #35 0x000055726cba84ea in ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:01:16.465] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = "\315krU\000\000\030\355\310krU\000\000\000\325\004\346\377\177\000\000\370\324\004\346\377\177\000\000\225[\362\001\000\000\000\000\300\340X\201rU\000\000.", '\000' , " \324\004\346\377\177\000\000\000\004\000\000\000\000\000\0008\325\004\346\377\177\000\000\000\003\270\203/\353gtp\350Q\201", '\000' , __ss_align = 67}, salen = 2}} [08:01:16.465] i = 0 [08:01:16.465] now = [08:01:16.465] last_lockfile_recheck_time = 1755935701 [08:01:16.465] last_touch_time = 1755935641 [08:01:16.465] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = -435890816, user_data = 0x0}, {pos = 17, events = 0, fd = -1140564976, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fcabd0d12e0}, {pos = -435890952, events = 32767, fd = -435890944, user_data = 0x7fcabd0d1668}, {pos = 0, events = 0, fd = 1, user_data = 0x1}, {pos = -2124870696, events = 21874, fd = 1, user_data = 0x557281590bd8}, {pos = -1, events = 0, fd = -1149050848, user_data = 0x7fcabcd38a10}, {pos = -2125053440, events = 21874, fd = -1148260955, user_data = 0x7fffe604da53}, {pos = 61, events = 0, fd = -435890880, user_data = 0x7fcabd0d12e0}, {pos = 436, events = 0, fd = 1834433952, user_data = 0x0}, {pos = 0, events = 0, fd = 86, user_data = 0x7fcabd0acebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fcabb82e020}, {pos = -1148244352, events = 32714, fd = 557854811, user_data = 0x7fffe604d970}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1123355974, events = 32714, fd = 0, user_data = 0x7fcabb8aedd4 }, {pos = 0, events = 0, fd = 1841619104, user_data = 0x2}, {pos = 0, events = 0, fd = -2125338512, user_data = 0x7fcabb8eeedd }, {pos = -2125048336, events = 21874, fd = 1825154554, user_data = 0x557281597fb0}, {pos = 8096, events = 196607, fd = -2124840949, user_data = 0x55726cc9f2f2 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x169}, {pos = 1834433352, events = 21874, fd = 4, user_data = 0x1}, {pos = -2124870696, events = 21874, fd = -1123365186, user_data = 0x1}, {pos = -1148489929, events = 32714, fd = -1149016888, user_data = 0x1010}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = -1134003584, events = 32714, fd = -1134002240, 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 = -2124830768, user_data = 0x55726cfec1c9 }, {pos = -2124832816, events = 21874, fd = 1080, user_data = 0x557281526450}, {pos = 1828637257, events = 21874, fd = 1024, user_data = 0x7fcabb8b58ee}, {pos = -1147217440, events = 32714, fd = -1148579474, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -435889592, events = 32767, fd = -1148485809, user_data = 0x557281526450}, {pos = 3, events = 0, fd = 0, user_data = 0x9103}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x77}, {pos = -1148243821, events = 32714, fd = -2125306800, user_data = 0x1}, {pos = -2125306600, events = 21874, fd = 1024, user_data = 0x7fffe604da48}, {pos = 1828718426, events = 21874, fd = 1841722800, user_data = 0x55726cfef1fa }, {pos = -2125306800, events = 21874, fd = -2125056544, user_data = 0x557281526450}, {pos = -1148495973, events = 32714, fd = 0, user_data = 0x55726d001028 }, {pos = -2125306800, events = 1, fd = 1828721009, user_data = 0x5572815635e0}, {pos = -1148573007, events = 32714, fd = -1148578576, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -2085092608, events = 1952967471, fd = -2125338512, user_data = 0x7467eb2f83b80300}, {pos = 13, events = 0, fd = -2085092608, user_data = 0x0}, {pos = -1148865991, events = 32714, fd = 0, user_data = 0x55726cba06e0 }, {pos = 4194304, events = 0, fd = -2125222848, user_data = 0x1}, {pos = 0, events = 0, fd = -2125338512, user_data = 0x55726cfef08e }, {pos = -2125222848, events = 21874, fd = -2125056544, user_data = 0x55728153ac40}, {pos = 1, events = 0, fd = 0, user_data = 0x55726cfad061 }, {pos = 13, events = 0, fd = -2124873208, user_data = 0x5572815901e8}, {pos = 1841620536, events = 21874, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 1824131226, user_data = 0x5572815635e0}, {pos = 1824148134, events = 21874, fd = 1837920784, user_data = 0x557281563f98}} [08:01:16.465] nevents = 1 [08:01:16.465] __func__ = "ServerLoop" [08:01:16.465] #36 0x000055726cba9dc4 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5572815217e0) at ../src/backend/postmaster/postmaster.c:1403 [08:01:16.465] opt = [08:01:16.465] status = [08:01:16.465] userDoption = [08:01:16.465] listen_addr_saved = false [08:01:16.465] output_config_variable = [08:01:16.465] __func__ = "PostmasterMain" [08:01:16.465] #37 0x000055726c9d4711 in main (argc=4, argv=0x5572815217e0) at ../src/backend/main/main.c:231 [08:01:16.465] do_check_root = [08:01:16.465] dispatch_option =