[08:11:53.003] src/tools/ci/cores_backtrace.sh linux /tmp/cores [08:11:53.188] dumping /tmp/cores/sh-3-42635.core for /bin/sh [08:11:53.238] [08:11:53.238] This GDB supports auto-downloading debuginfo from the following URLs: [08:11:53.238] [08:11:53.238] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:11:53.238] Debuginfod has been disabled. [08:11:53.238] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:11:53.242] [New LWP 42635] [08:11:53.244] [Thread debugging using libthread_db enabled] [08:11:53.244] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:11:53.244] Core was generated by `sh -c cp "pg_wal/000000010000000000000003" "/tmp/cirrus-ci-build/build/testrun/'. [08:11:53.244] Program terminated with signal SIGQUIT, Quit. [08:11:53.244] #0 0x00007fb8a684cbd3 in wait4 () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:53.251] [08:11:53.251] Thread 1 (Thread 0x7fb8a6776740 (LWP 42635)): [08:11:53.251] #0 0x00007fb8a684cbd3 in wait4 () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:53.251] No symbol table info available. [08:11:53.251] #1 0x0000564ff245acc0 in ?? () [08:11:53.251] No symbol table info available. [08:11:53.251] #2 0x0000564ff245aefa in ?? () [08:11:53.251] No symbol table info available. [08:11:53.251] #3 0x0000564ff245c630 in ?? () [08:11:53.251] No symbol table info available. [08:11:53.251] #4 0x0000564ff2456371 in ?? () [08:11:53.251] No symbol table info available. [08:11:53.251] #5 0x0000564ff245520f in ?? () [08:11:53.251] No symbol table info available. [08:11:53.251] #6 0x0000564ff2455c3b in ?? () [08:11:53.251] No symbol table info available. [08:11:53.251] #7 0x0000564ff245366f in ?? () [08:11:53.251] No symbol table info available. [08:11:53.251] #8 0x00007fb8a67a024a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:53.251] No symbol table info available. [08:11:53.251] #9 0x00007fb8a67a0305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:53.251] No symbol table info available. [08:11:53.251] #10 0x0000564ff2453781 in ?? () [08:11:53.251] No symbol table info available. [08:11:53.259] -e [08:11:53.259] [08:11:53.259] [08:11:53.352] dumping /tmp/cores/postgres-6-24934.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:11:53.614] [New LWP 24934] [08:11:53.614] [08:11:53.614] This GDB supports auto-downloading debuginfo from the following URLs: [08:11:53.614] [08:11:53.614] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:11:53.614] Debuginfod has been disabled. [08:11:53.614] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:11:53.870] [Thread debugging using libthread_db enabled] [08:11:53.870] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:11:53.870] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [08:11:53.870] Program terminated with signal SIGABRT, Aborted. [08:11:53.870] #0 0x00007f8bd18a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:54.851] [08:11:54.851] Thread 1 (Thread 0x7f8bd17d2a80 (LWP 24934)): [08:11:54.851] #0 0x00007f8bd18a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:54.851] No symbol table info available. [08:11:54.851] #1 0x00007f8bd185afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:54.851] No symbol table info available. [08:11:54.851] #2 0x00007f8bd1845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:54.851] No symbol table info available. [08:11:54.851] #3 0x0000564cbe821a34 in ExceptionalCondition (conditionName=conditionName@entry=0x564cbea54ea9 "n >= 0 && n < list->length", fileName=fileName@entry=0x564cbea4fd60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:11:54.851] No locals. [08:11:54.851] #4 0x0000564cbe333b5b in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:11:54.851] No locals. [08:11:54.851] #5 0x0000564cbe333b90 in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:11:54.851] No locals. [08:11:54.851] #6 0x0000564cbe3392c2 in var_is_nonnullable (root=0x564cd37f9c98, var=var@entry=0x564cd38df498, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:11:54.851] rte = [08:11:54.851] notnullattnums = 0x0 [08:11:54.851] #7 0x0000564cbe33d18f in eval_const_expressions_mutator (node=node@entry=0x564cd38df418, context=context@entry=0x7ffe92e0e450) at ../src/backend/optimizer/util/clauses.c:3556 [08:11:54.851] varg = 0x564cd38df498 [08:11:54.851] result = [08:11:54.851] ntest = 0x564cd38df418 [08:11:54.851] newntest = [08:11:54.851] arg = 0x564cd38df498 [08:11:54.851] __func__ = "eval_const_expressions_mutator" [08:11:54.851] #8 0x0000564cbe33e21d in simplify_and_arguments (args=, context=context@entry=0x7ffe92e0e450, haveNull=haveNull@entry=0x7ffe92e0e3fc, forceFalse=forceFalse@entry=0x7ffe92e0e400) at ../src/backend/optimizer/util/clauses.c:3964 [08:11:54.851] arg = 0x564cd38df418 [08:11:54.851] newargs = 0x564cd38df628 [08:11:54.851] unprocessed_args = 0x0 [08:11:54.851] #9 0x0000564cbe33b217 in eval_const_expressions_mutator (node=0x564cd38df258, context=context@entry=0x7ffe92e0e450) at ../src/backend/optimizer/util/clauses.c:2877 [08:11:54.851] newargs = [08:11:54.851] haveNull = false [08:11:54.851] forceFalse = false [08:11:54.851] expr = 0x564cd38df258 [08:11:54.851] __func__ = "eval_const_expressions_mutator" [08:11:54.851] #10 0x0000564cbe33dd53 in eval_const_expressions (root=root@entry=0x564cd37f9c98, node=node@entry=0x564cd38df258) at ../src/backend/optimizer/util/clauses.c:2272 [08:11:54.851] context = {boundParams = 0x0, root = 0x564cd37f9c98, active_fns = 0x0, case_val = 0x0, estimate = false} [08:11:54.851] #11 0x0000564cbe3171f6 in convert_EXISTS_sublink_to_join (root=0x564cd37f9c98, sublink=sublink@entry=0x564cd37d0ec0, under_not=under_not@entry=false, available_rels=available_rels@entry=0x564cd37fa1c8) at ../src/backend/optimizer/plan/subselect.c:1541 [08:11:54.851] je = [08:11:54.851] lc__state = [08:11:54.851] result = [08:11:54.851] parse = 0x564cd37d12e0 [08:11:54.851] subselect = 0x564cd37fcc28 [08:11:54.851] whereClause = 0x564cd38df258 [08:11:54.851] subroot = {type = 3191035473, parse = 0x7ffe92e0e980, glob = 0x1, query_level = 3190160311, parent_root = 0x564cd38cf008, plan_params = 0x564cbe25eb24 , outer_params = 0x564cd38d7198, simple_rel_array = 0x564cd37d0ce0, simple_rel_array_size = 0, simple_rte_array = 0x7ffe92e0e980, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x564cbe33576b , join_rel_list = 0x74a6, join_rel_hash = 0x564cd38cf058, join_rel_level = 0x564cbe335651 , join_cur_level = -1830753920, init_plans = 0x1, cte_plan_ids = 0x564cbe260215 , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 152, canon_pathkeys = 0x564cbe335651 , left_join_clauses = 0x7ffe92e0e980, right_join_clauses = 0x7ffe92e0e980, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = -1104809480, all_result_relids = 0x7ffe92e0e6f0, leaf_result_relids = 0x564cd38ce190, append_rel_list = 0x564cbe335651 , row_identity_vars = 0x564cd38d8c98, rowMarks = 0x0, placeholder_list = 0x7ffe92e0e980, placeholder_array = 0x7ffe92e0e980, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x564cbe33576b , group_pathkeys = 0x564cbe335651 , num_groupby_pathkeys = -745698104, window_pathkeys = 0x564cbe335651 , distinct_pathkeys = 0x564cd38cea00, sort_pathkeys = 0x564cbe335651 , setop_pathkeys = 0x7ffe92e0e980, part_schemes = 0x0, initial_rels = 0x564cbe260c04 , upper_rels = {0x564cd38324a0, 0x564cd38cdff8, 0x3, 0x3, 0x0, 0x564cbe865644 , 0x564cd38d1130, 0x400}, upper_targets = {0x7, 0x564cbe866785 , 0x292e0e980, 0x7, 0x0, 0x400, 0x564cd38d12c0, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x564cbe87b9a1 , grouping_map = 0x20, minmax_aggs = 0x564cd38d12c0, planner_cxt = 0x0, total_table_pages = 4.6880710282464395e-310, tuple_fraction = 4.6880883961240326e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 133, placeholdersFrozen = 103, hasRecursion = 134, group_rtindex = 22092, agginfos = 0xd38d1230, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x564cd37fa130, isUsedSubplan = 0x0, join_search_private = 0x564cbe87be7d , partColsUpdated = 118, partPruneInfos = 0x0} [08:11:54.851] rtoffset = [08:11:54.851] varno = [08:11:54.851] clause_varnos = [08:11:54.851] upper_varnos = [08:11:54.851] lc = [08:11:54.851] newWhere = 0x0 [08:11:54.851] all_clauses = 0x564cd38df208 [08:11:54.851] upper_reference_exists = false [08:11:54.851] #12 0x0000564cbe322016 in pull_up_sublinks_qual_recurse (root=root@entry=0x564cd37f9c98, node=0x564cd37d0ec0, jtlink1=jtlink1@entry=0x564cd37fa130, available_rels1=0x564cd37fa1c8, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:11:54.851] sublink = 0x564cd37d0ec0 [08:11:54.851] j = [08:11:54.851] child_rels = 0x564cd37d0f10 [08:11:54.851] #13 0x0000564cbe321aea in pull_up_sublinks_jointree_recurse (root=root@entry=0x564cd37f9c98, jtnode=, relids=relids@entry=0x7ffe92e0e8c8) at ../src/backend/optimizer/prep/prepjointree.c:776 [08:11:54.851] j = 0x564cd37fa118 [08:11:54.851] leftrelids = 0x564cd37fa1a8 [08:11:54.851] rightrelids = 0x564cd37fa1c8 [08:11:54.851] jtlink = 0x564cd37fa118 [08:11:54.851] __func__ = "pull_up_sublinks_jointree_recurse" [08:11:54.851] #14 0x0000564cbe321c1e in pull_up_sublinks_jointree_recurse (root=root@entry=0x564cd37f9c98, jtnode=0x564cd38d9cb8, relids=relids@entry=0x7ffe92e0e918) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:11:54.851] newchild = [08:11:54.851] childrelids = 0x40000000a9de [08:11:54.851] l__state = [08:11:54.851] frelids = 0x0 [08:11:54.851] newf = [08:11:54.851] jtlink = 0x40000000a9de [08:11:54.851] f = 0x564cd38d9cb8 [08:11:54.851] newfromlist = 0x0 [08:11:54.851] l = [08:11:54.851] __func__ = "pull_up_sublinks_jointree_recurse" [08:11:54.851] #15 0x0000564cbe323c04 in pull_up_sublinks (root=root@entry=0x564cd37f9c98) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:11:54.851] jtnode = [08:11:54.851] relids = 0x564cd37d12e0 [08:11:54.851] #16 0x0000564cbe301f0f in subquery_planner (glob=glob@entry=0x564cd38d7438, parse=parse@entry=0x564cd37d12e0, 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:11:54.851] root = 0x564cd37f9c98 [08:11:54.851] newWithCheckOptions = [08:11:54.851] newHaving = [08:11:54.851] hasOuterJoins = [08:11:54.851] hasResultRTEs = [08:11:54.851] final_rel = [08:11:54.851] l = [08:11:54.851] #17 0x0000564cbe3040f9 in standard_planner (parse=0x564cd37d12e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:442 [08:11:54.851] result = [08:11:54.851] glob = 0x564cd38d7438 [08:11:54.851] tuple_fraction = 0 [08:11:54.851] root = [08:11:54.851] final_rel = [08:11:54.851] best_path = [08:11:54.851] top_plan = [08:11:54.851] lp = [08:11:54.851] lr = [08:11:54.851] #18 0x0000564cbe30520f in planner (parse=parse@entry=0x564cd37d12e0, query_string=query_string@entry=0x564cd37cf710 "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:11:54.851] result = [08:11:54.851] #19 0x0000564cbe5846f3 in pg_plan_query (querytree=querytree@entry=0x564cd37d12e0, query_string=query_string@entry=0x564cd37cf710 "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:11:54.851] plan = [08:11:54.851] #20 0x0000564cbe059a30 in standard_ExplainOneQuery (query=0x564cd37d12e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564cd38d7198, queryString=0x564cd37cf710 "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:11:54.851] plan = [08:11:54.851] planstart = [08:11:54.851] planduration = {ticks = 94887607608032} [08:11:54.851] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94887613982597, shared_blks_dirtied = 2464213870, 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 = 94887965692640, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94887614069988}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94887607605413}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94887965692640}} [08:11:54.851] bufusage = {shared_blks_hit = 1, shared_blks_read = 94887610716989, shared_blks_dirtied = 186770947850240, shared_blks_written = 72057594037927936, local_blks_hit = 140238289810528, local_blks_read = 94887966724872, local_blks_dirtied = 94887965692640, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 94887613594301, shared_blk_read_time = {ticks = 140238289810528}, shared_blk_write_time = {ticks = 94887613594320}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94887613978180}, temp_blk_read_time = {ticks = 94887965507936}, temp_blk_write_time = {ticks = 64}} [08:11:54.851] mem_counters = {nblocks = 94887965870984, freechunks = 8589934593, totalspace = 140731362634480, freespace = 10} [08:11:54.851] planner_ctx = 0x0 [08:11:54.851] saved_ctx = 0x0 [08:11:54.851] #21 0x0000564cbe059d16 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564cd38d7198, pstate=pstate@entry=0x564cd37a4418, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [08:11:54.851] No locals. [08:11:54.851] #22 0x0000564cbe059fbe in ExplainQuery (pstate=pstate@entry=0x564cd37a4418, stmt=stmt@entry=0x564cd37d1120, params=params@entry=0x0, dest=dest@entry=0x564cd37a4388) at ../src/backend/commands/explain.c:223 [08:11:54.851] l__state = [08:11:54.851] l = 0x564cd37fcbf0 [08:11:54.851] es = 0x564cd38d7198 [08:11:54.851] tstate = [08:11:54.851] jstate = [08:11:54.851] query = [08:11:54.851] rewritten = 0x564cd37fcbd8 [08:11:54.851] #23 0x0000564cbe58f646 in standard_ProcessUtility (pstmt=0x564cd37d11d0, queryString=0x564cd37cf710 "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=0x564cd37a4388, qc=0x7ffe92e0ed60) at ../src/backend/tcop/utility.c:866 [08:11:54.851] parsetree = 0x564cd37d1120 [08:11:54.851] isTopLevel = true [08:11:54.851] isAtomicContext = false [08:11:54.851] pstate = 0x564cd37a4418 [08:11:54.851] readonly_flags = [08:11:54.851] __func__ = "standard_ProcessUtility" [08:11:54.851] #24 0x0000564cbe58fce1 in ProcessUtility (pstmt=pstmt@entry=0x564cd37d11d0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x564cd37a4388, qc=0x7ffe92e0ed60) at ../src/backend/tcop/utility.c:523 [08:11:54.851] No locals. [08:11:54.851] #25 0x0000564cbe58b733 in PortalRunUtility (portal=portal@entry=0x564cd3854c20, pstmt=0x564cd37d11d0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x564cd37a4388, qc=qc@entry=0x7ffe92e0ed60) at ../src/backend/tcop/pquery.c:1153 [08:11:54.851] No locals. [08:11:54.851] #26 0x0000564cbe58bf8e in FillPortalStore (portal=portal@entry=0x564cd3854c20, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [08:11:54.851] treceiver = 0x564cd37a4388 [08:11:54.851] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:54.851] __func__ = "FillPortalStore" [08:11:54.851] #27 0x0000564cbe58c4a9 in PortalRun (portal=portal@entry=0x564cd3854c20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x564cd38d9f98, altdest=altdest@entry=0x564cd38d9f98, qc=qc@entry=0x7ffe92e0ef20) at ../src/backend/tcop/pquery.c:760 [08:11:54.851] _save_exception_stack = 0x7ffe92e0efd0 [08:11:54.851] _save_context_stack = 0x0 [08:11:54.851] _local_sigjmp_buf = {{__jmpbuf = {0, 4934481379778947889, 94887966231584, 94887965692312, 94887965692288, 94887965692240, 1665855160025410353, 4934281636904758065}, __mask_was_saved = 0, __saved_mask = {__val = {94887613982597, 2464214703, 4, 94887965692240, 112, 153, 94887966231584, 94887965692312, 94887965692288, 94887965692240, 94887614070397, 1, 2, 153, 94887603084869, 0}}}} [08:11:54.851] _do_rethrow = [08:11:54.851] result = [08:11:54.851] nprocessed = [08:11:54.851] saveTopTransactionResourceOwner = 0x564cd38129e8 [08:11:54.851] saveTopTransactionContext = 0x564cd38694c0 [08:11:54.851] saveActivePortal = 0x0 [08:11:54.851] saveResourceOwner = 0x564cd38129e8 [08:11:54.851] savePortalContext = 0x0 [08:11:54.851] saveMemoryContext = 0x564cd38694c0 [08:11:54.851] __func__ = "PortalRun" [08:11:54.851] #28 0x0000564cbe5851e1 in exec_simple_query (query_string=query_string@entry=0x564cd37cf710 "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:11:54.851] cmdtaglen = 7 [08:11:54.851] snapshot_set = [08:11:54.851] per_parsetree_context = 0x0 [08:11:54.851] plantree_list = 0x564cd38d9f48 [08:11:54.851] parsetree = 0x564cd37d1150 [08:11:54.851] commandTag = [08:11:54.851] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:54.851] querytree_list = [08:11:54.851] portal = 0x564cd3854c20 [08:11:54.851] receiver = 0x564cd38d9f98 [08:11:54.851] format = 0 [08:11:54.851] cmdtagname = [08:11:54.851] parsetree_item__state = [08:11:54.851] dest = DestRemote [08:11:54.851] oldcontext = 0x564cd38694c0 [08:11:54.851] parsetree_list = 0x564cd37d1180 [08:11:54.851] parsetree_item = 0x564cd37d1198 [08:11:54.851] save_log_statement_stats = false [08:11:54.851] was_logged = false [08:11:54.851] use_implicit_block = false [08:11:54.851] msec_str = "\000U\037\277LV\000\000Q~\204\276LV\000\000\260\357\340\222\376\177\000\000\316\000\000\000\000\000\000" [08:11:54.851] __func__ = "exec_simple_query" [08:11:54.851] #29 0x0000564cbe58842a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [08:11:54.851] query_string = 0x564cd37cf710 "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:11:54.851] firstchar = [08:11:54.851] input_message = {data = 0x564cd37cf710 "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:11:54.851] local_sigjmp_buf = {{__jmpbuf = {94887627065624, 4934279624452533041, 4, 94887624004864, 24, 13, 1665855159958301489, 4934281630710033201}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94887965415632, 17408, 94887627059648, 94887965950352, 24, 94887613982145, 0, 10, 2, 94887627065632, 94887965415632, 94887627059648, 94887624004864, 24, 13}}}} [08:11:54.851] send_ready_for_query = false [08:11:54.851] idle_in_transaction_timeout_enabled = false [08:11:54.851] idle_session_timeout_enabled = false [08:11:54.851] __func__ = "PostgresMain" [08:11:54.851] #30 0x0000564cbe57dd34 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:11:54.851] bsdata = [08:11:54.851] #31 0x0000564cbe419e6b in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x7ffe92e0f130, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffe92e0f1a0) at ../src/backend/postmaster/launch_backend.c:290 [08:11:54.851] pid = [08:11:54.851] #32 0x0000564cbe41f42f in BackendStartup (client_sock=client_sock@entry=0x7ffe92e0f1a0) at ../src/backend/postmaster/postmaster.c:3590 [08:11:54.851] bn = 0x564cd37f7ec8 [08:11:54.851] pid = [08:11:54.851] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809597090475593, fork_started = 809597090475595} [08:11:54.851] cac = [08:11:54.851] __func__ = "BackendStartup" [08:11:54.851] #33 0x0000564cbe42195b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:11:54.851] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = "\340\222\376\177\000\0004\362\340\222\376\177", '\000' , "\300\266T\275LV\000\000\030}P\275LV\000\000\000\363\340\222\376\177\000\000\370\362\340\222\376\177\000\000\225[\362\001\000\000\000\000p\272\003ҋ\177\000\000-", '\000' , "εT\275LV\000\000h\026\032Ӌ\177\000\000\020\274\003ҋ\177\000", __ss_align = 140238518883040}, salen = 2}} [08:11:54.851] i = 0 [08:11:54.851] now = [08:11:54.851] last_lockfile_recheck_time = 1756281884 [08:11:54.851] last_touch_time = 1756281824 [08:11:54.851] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = -753265048, user_data = 0x0}, {pos = -753265952, events = 32651, fd = 2090263927, user_data = 0x7ffe92e0f380}, {pos = -753440184, events = 32651, fd = 17, user_data = 0x7f8bd203bc10}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -753265952, events = 32651, fd = -1830751496, user_data = 0x7ffe92e0f300}, {pos = -753265048, events = 32651, fd = 0, user_data = 0x564cd37cf7d0}, {pos = -1098162170, events = 22092, fd = 32768, user_data = 0x1}, {pos = -746777600, events = 22092, fd = -1, user_data = 0x7f8bd182e020}, {pos = -757581296, events = 32651, fd = -747034776, user_data = 0x564cd3792648}, {pos = -746597615, events = 22092, fd = -753414466, user_data = 0x1}, {pos = -753265952, events = 32651, fd = 436, user_data = 0x564cbedecda0 }, {pos = 0, events = 0, fd = 0, user_data = 0xf9}, {pos = -753414466, events = 32651, fd = 1, user_data = 0x0}, {pos = -779952096, events = 32651, fd = -779145600, user_data = 0x10}, {pos = -1830750384, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -753405254, user_data = 0x0}, {pos = -779424300, events = 32651, fd = 0, user_data = 0x564cbf4c73c0 }, {pos = 2, events = 0, fd = 0, user_data = 0x564cd378a870}, {pos = -1101969075, events = 22092, fd = -746577525, user_data = 0x564cbe51876d }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x564cd37cf7d0}, {pos = -753414466, events = 32651, fd = 1, user_data = 0x0}, {pos = -779918136, events = 32651, fd = -779499392, user_data = 0x451}, {pos = -779390819, events = 32651, fd = 2, user_data = 0x564cd3802130}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -778101664, events = 32651, fd = 255, user_data = 0xfffffffffffffee8}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x447135632d737365}, {pos = 168455221, events = 874520608, fd = 822763892, user_data = 0x30340a3432383138}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x564cd3792440}, {pos = -1098490172, events = 22092, fd = 1024, user_data = 0x7f8bd18b58ee}, {pos = -778118688, events = 32651, fd = -779480722, user_data = 0x100000400}, {pos = 7, events = 0, fd = -746597584, user_data = 0x398876a6acae7e00}, {pos = -778115616, events = 32651, fd = -336, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x3cd2}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = -779145069, events = 32651, fd = -747035584, user_data = 0x1}, {pos = -747035384, events = 22092, fd = 1024, user_data = 0x7ffe92e0f828}, {pos = -1098409003, events = 22092, fd = -1085404976, user_data = 0x564cbe868675 }, {pos = -747035584, events = 22092, fd = -746785264, user_data = 0x564cd3792440}, {pos = -779396882, events = 32651, fd = 0, user_data = 0x564cbe87a4a3 }, {pos = -747035584, events = 1, fd = -1098406420, user_data = 0x564cd37cf610}, {pos = -779474255, events = 32651, fd = -779479824, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1397850624, events = 965244582, fd = -747067280, user_data = 0x398876a6acae7e00}, {pos = 13, events = 0, fd = -1397850624, user_data = 0x0}, {pos = -779767239, events = 32651, fd = 0, user_data = 0x564cbe419b51 }, {pos = 4194304, events = 0, fd = -746951568, user_data = 0x1}, {pos = 0, events = 0, fd = -747067280, user_data = 0x564cbe868509 }, {pos = -746951568, events = 22092, fd = -746785264, user_data = 0x564cd37a6c70}, {pos = 1, events = 0, fd = 0, user_data = 0x564cbe8264dc }, {pos = 13, events = 0, fd = -746606248, user_data = 0x564cd37fb138}, {pos = -1085507240, events = 22092, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -1102996213, user_data = 0x564cd37cf610}, {pos = -1102979305, events = 22092, fd = -1089206992, user_data = 0x564cd37cffe8}} [08:11:54.852] nevents = 1 [08:11:54.852] __func__ = "ServerLoop" [08:11:54.852] #34 0x0000564cbe423235 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564cd378d830) at ../src/backend/postmaster/postmaster.c:1403 [08:11:54.852] opt = [08:11:54.852] status = [08:11:54.852] userDoption = [08:11:54.852] listen_addr_saved = false [08:11:54.852] output_config_variable = [08:11:54.852] __func__ = "PostmasterMain" [08:11:54.852] #35 0x0000564cbe24d9e8 in main (argc=8, argv=0x564cd378d830) at ../src/backend/main/main.c:231 [08:11:54.852] do_check_root = [08:11:54.852] dispatch_option = [08:11:54.888] -e [08:11:54.888] [08:11:54.888] [08:11:54.945] dumping /tmp/cores/cp-3-42636.core for /usr/bin/cp [08:11:54.991] [08:11:54.991] This GDB supports auto-downloading debuginfo from the following URLs: [08:11:54.991] [08:11:54.991] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:11:54.991] Debuginfod has been disabled. [08:11:54.991] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:11:54.994] [New LWP 42636] [08:11:55.000] [Thread debugging using libthread_db enabled] [08:11:55.000] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:11:55.000] Core was generated by `cp pg_wal/000000010000000000000003 /tmp/cirrus-ci-build/build/testrun/pg_combin'. [08:11:55.000] Program terminated with signal SIGQUIT, Quit. [08:11:55.000] #0 0x00007fa9d3cb57f3 in copy_file_range () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:55.001] [08:11:55.001] Thread 1 (Thread 0x7fa9d3b1e580 (LWP 42636)): [08:11:55.001] #0 0x00007fa9d3cb57f3 in copy_file_range () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:55.001] No symbol table info available. [08:11:55.001] #1 0x000055f8a2c13291 in ?? () [08:11:55.001] No symbol table info available. [08:11:55.001] #2 0x000055f8a2c17671 in ?? () [08:11:55.001] No symbol table info available. [08:11:55.001] #3 0x000055f8a2c18577 in ?? () [08:11:55.001] No symbol table info available. [08:11:55.001] #4 0x000055f8a2c125bc in ?? () [08:11:55.001] No symbol table info available. [08:11:55.001] #5 0x000055f8a2c10eda in ?? () [08:11:55.001] No symbol table info available. [08:11:55.001] #6 0x00007fa9d3be024a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:55.001] No symbol table info available. [08:11:55.001] #7 0x00007fa9d3be0305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:55.001] No symbol table info available. [08:11:55.001] #8 0x000055f8a2c11171 in ?? () [08:11:55.001] No symbol table info available. [08:11:55.008] -e [08:11:55.008] [08:11:55.008] [08:11:55.088] dumping /tmp/cores/postgres-6-36049.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:11:55.338] [New LWP 36049] [08:11:55.338] [08:11:55.338] This GDB supports auto-downloading debuginfo from the following URLs: [08:11:55.338] [08:11:55.338] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:11:55.338] Debuginfod has been disabled. [08:11:55.338] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:11:55.571] [Thread debugging using libthread_db enabled] [08:11:55.571] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:11:55.571] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [08:11:55.571] Program terminated with signal SIGABRT, Aborted. [08:11:55.571] #0 0x00007fc6a9ca9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:56.527] [08:11:56.527] Thread 1 (Thread 0x7fc6a9bd2a80 (LWP 36049)): [08:11:56.527] #0 0x00007fc6a9ca9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:56.527] No symbol table info available. [08:11:56.527] #1 0x00007fc6a9c5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:56.527] No symbol table info available. [08:11:56.527] #2 0x00007fc6a9c45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:56.527] No symbol table info available. [08:11:56.527] #3 0x000055a167b33a34 in ExceptionalCondition (conditionName=conditionName@entry=0x55a167d66ea9 "n >= 0 && n < list->length", fileName=fileName@entry=0x55a167d61d60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:11:56.527] No locals. [08:11:56.527] #4 0x000055a167645b5b in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:11:56.527] No locals. [08:11:56.527] #5 0x000055a167645b90 in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:11:56.527] No locals. [08:11:56.527] #6 0x000055a16764b2c2 in var_is_nonnullable (root=0x55a197f50f98, var=var@entry=0x55a197e80568, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:11:56.527] rte = [08:11:56.527] notnullattnums = 0x0 [08:11:56.527] #7 0x000055a16764f18f in eval_const_expressions_mutator (node=node@entry=0x55a197e804e8, context=context@entry=0x7ffdc37a9290) at ../src/backend/optimizer/util/clauses.c:3556 [08:11:56.527] varg = 0x55a197e80568 [08:11:56.527] result = [08:11:56.527] ntest = 0x55a197e804e8 [08:11:56.527] newntest = [08:11:56.527] arg = 0x55a197e80568 [08:11:56.527] __func__ = "eval_const_expressions_mutator" [08:11:56.527] #8 0x000055a16765021d in simplify_and_arguments (args=, context=context@entry=0x7ffdc37a9290, haveNull=haveNull@entry=0x7ffdc37a923c, forceFalse=forceFalse@entry=0x7ffdc37a9240) at ../src/backend/optimizer/util/clauses.c:3964 [08:11:56.527] arg = 0x55a197e804e8 [08:11:56.527] newargs = 0x55a197e806f8 [08:11:56.527] unprocessed_args = 0x0 [08:11:56.527] #9 0x000055a16764d217 in eval_const_expressions_mutator (node=0x55a197e80328, context=context@entry=0x7ffdc37a9290) at ../src/backend/optimizer/util/clauses.c:2877 [08:11:56.527] newargs = [08:11:56.527] haveNull = false [08:11:56.527] forceFalse = false [08:11:56.527] expr = 0x55a197e80328 [08:11:56.527] __func__ = "eval_const_expressions_mutator" [08:11:56.527] #10 0x000055a16764fd53 in eval_const_expressions (root=root@entry=0x55a197f50f98, node=node@entry=0x55a197e80328) at ../src/backend/optimizer/util/clauses.c:2272 [08:11:56.527] context = {boundParams = 0x0, root = 0x55a197f50f98, active_fns = 0x0, case_val = 0x0, estimate = false} [08:11:56.527] #11 0x000055a1676291f6 in convert_EXISTS_sublink_to_join (root=0x55a197f50f98, sublink=sublink@entry=0x55a197e45e90, under_not=under_not@entry=false, available_rels=available_rels@entry=0x55a197f514c8) at ../src/backend/optimizer/plan/subselect.c:1541 [08:11:56.527] je = [08:11:56.527] lc__state = [08:11:56.527] result = [08:11:56.527] parse = 0x55a197e462b0 [08:11:56.527] subselect = 0x55a197e74718 [08:11:56.527] whereClause = 0x55a197e80328 [08:11:56.527] subroot = {type = 1734637137, parse = 0x7ffdc37a97c0, glob = 0x1, query_level = 1733761975, parent_root = 0x55a197f6eb38, plan_params = 0x55a167570b24 , outer_params = 0x55a167e36edf, simple_rel_array = 0x55a197e45cb0, simple_rel_array_size = 0, simple_rte_array = 0x7ffdc37a97c0, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x55a16764776b , join_rel_list = 0x7ffdc37a9840, join_rel_hash = 0x55a197f6eb88, join_rel_level = 0x55a167647651 , join_cur_level = -1015375936, init_plans = 0x1, cte_plan_ids = 0x55a167572215 , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 24, canon_pathkeys = 0x55a167647651 , left_join_clauses = 0x7ffdc37a97c0, right_join_clauses = 0x7ffdc37a97c0, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = 1733759480, all_result_relids = 0x55a167e36edf, leaf_result_relids = 0x55a197f6dcc0, append_rel_list = 0x55a167647651 , row_identity_vars = 0x55a197f60c18, rowMarks = 0x0, placeholder_list = 0x7ffdc37a97c0, placeholder_array = 0x7ffdc37a97c0, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x55a16764776b , group_pathkeys = 0x55a167647651 , num_groupby_pathkeys = -1745482680, window_pathkeys = 0x55a167647651 , distinct_pathkeys = 0x55a197f6e530, sort_pathkeys = 0x55a167647651 , setop_pathkeys = 0x7ffdc37a97c0, part_schemes = 0x0, initial_rels = 0x55a167572c04 , upper_rels = {0x55a197e19130, 0x55a197f6db28, 0x3, 0x3, 0x0, 0x55a167b77644 , 0x55a197f42a60, 0x400}, upper_targets = {0x7, 0x55a167b78785 , 0x2c37a97c0, 0x7, 0x0, 0x400, 0x55a197f42bf0, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x55a167b8d9a1 , grouping_map = 0x20, minmax_aggs = 0x55a197f42bf0, planner_cxt = 0x0, total_table_pages = 4.6517129445824855e-310, tuple_fraction = 4.6517528683362381e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 133, placeholdersFrozen = 135, hasRecursion = 183, group_rtindex = 21921, agginfos = 0x97f42b60, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x55a197f51430, isUsedSubplan = 0x0, join_search_private = 0x55a167b8de7d , partColsUpdated = 33, partPruneInfos = 0x0} [08:11:56.527] rtoffset = [08:11:56.527] varno = [08:11:56.527] clause_varnos = [08:11:56.527] upper_varnos = [08:11:56.527] lc = [08:11:56.527] newWhere = 0x0 [08:11:56.527] all_clauses = 0x55a197e802d8 [08:11:56.527] upper_reference_exists = false [08:11:56.527] #12 0x000055a167634016 in pull_up_sublinks_qual_recurse (root=root@entry=0x55a197f50f98, node=0x55a197e45e90, jtlink1=jtlink1@entry=0x55a197f51430, available_rels1=0x55a197f514c8, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:11:56.527] sublink = 0x55a197e45e90 [08:11:56.527] j = [08:11:56.527] child_rels = 0x55a197e45ee0 [08:11:56.527] #13 0x000055a167633aea in pull_up_sublinks_jointree_recurse (root=root@entry=0x55a197f50f98, jtnode=, relids=relids@entry=0x7ffdc37a9708) at ../src/backend/optimizer/prep/prepjointree.c:776 [08:11:56.527] j = 0x55a197f51418 [08:11:56.527] leftrelids = 0x55a197f514a8 [08:11:56.527] rightrelids = 0x55a197f514c8 [08:11:56.527] jtlink = 0x55a197f51418 [08:11:56.527] __func__ = "pull_up_sublinks_jointree_recurse" [08:11:56.527] #14 0x000055a167633c1e in pull_up_sublinks_jointree_recurse (root=root@entry=0x55a197f50f98, jtnode=0x55a197f61c38, relids=relids@entry=0x7ffdc37a9758) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:11:56.527] newchild = [08:11:56.527] childrelids = 0x40000000a995 [08:11:56.527] l__state = [08:11:56.527] frelids = 0x0 [08:11:56.527] newf = [08:11:56.527] jtlink = 0x40000000a995 [08:11:56.527] f = 0x55a197f61c38 [08:11:56.527] newfromlist = 0x0 [08:11:56.527] l = [08:11:56.527] __func__ = "pull_up_sublinks_jointree_recurse" [08:11:56.527] #15 0x000055a167635c04 in pull_up_sublinks (root=root@entry=0x55a197f50f98) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:11:56.527] jtnode = [08:11:56.527] relids = 0x55a197e462b0 [08:11:56.527] #16 0x000055a167613f0f in subquery_planner (glob=glob@entry=0x55a197e7bb98, parse=parse@entry=0x55a197e462b0, 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:11:56.527] root = 0x55a197f50f98 [08:11:56.527] newWithCheckOptions = [08:11:56.527] newHaving = [08:11:56.527] hasOuterJoins = [08:11:56.527] hasResultRTEs = [08:11:56.527] final_rel = [08:11:56.527] l = [08:11:56.527] #17 0x000055a1676160f9 in standard_planner (parse=parse@entry=0x55a197e462b0, query_string=query_string@entry=0x55a197e446e0 "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:11:56.527] result = [08:11:56.527] glob = 0x55a197e7bb98 [08:11:56.527] tuple_fraction = 0 [08:11:56.527] root = [08:11:56.527] final_rel = [08:11:56.527] best_path = [08:11:56.527] top_plan = [08:11:56.527] lp = [08:11:56.527] lr = [08:11:56.527] #18 0x00007fc6a7c2b82d in pgss_planner (parse=0x55a197e462b0, query_string=0x55a197e446e0 "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:11:56.527] _save_exception_stack = 0x7ffdc37aa030 [08:11:56.527] _save_context_stack = 0x0 [08:11:56.527] _local_sigjmp_buf = {{__jmpbuf = {94152526422704, 4209610257415666794, 0, 2048, 94152526422704, 2048, 7985765066376608874, 7973036499832667242}, __mask_was_saved = 0, __saved_mask = {__val = {140491154191600, 94152526903640, 94152526901120, 2269295582, 94151717647975, 43413, 0, 0, 407006518528, 43413, 0, 140491154191664, 140491154191600, 0, 0, 140727883205036}}}} [08:11:56.527] _do_rethrow = false [08:11:56.527] result = 0x1c37a98c8 [08:11:56.527] #19 0x000055a1676171dd in planner (parse=parse@entry=0x55a197e462b0, query_string=query_string@entry=0x55a197e446e0 "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:11:56.527] result = [08:11:56.527] #20 0x000055a1678966f3 in pg_plan_query (querytree=querytree@entry=0x55a197e462b0, query_string=query_string@entry=0x55a197e446e0 "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:11:56.527] plan = [08:11:56.527] #21 0x000055a16736ba30 in standard_ExplainOneQuery (query=0x55a197e462b0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55a197e74688, queryString=0x55a197e446e0 "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:11:56.527] plan = [08:11:56.527] planstart = [08:11:56.527] planduration = {ticks = 94151711802080} [08:11:56.527] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94151718176645, shared_blks_dirtied = 3279592686, shared_blks_written = 3, local_blks_hit = 6843513144, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94152526422704, shared_blk_read_time = {ticks = -5159148872915149421}, shared_blk_write_time = {ticks = 94151718264036}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94151711799461}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94152526422704}} [08:11:56.527] bufusage = {shared_blks_hit = 1, shared_blks_read = 94151714911037, shared_blks_dirtied = 186457415237632, shared_blks_written = 72057594037927936, local_blks_hit = 140491154154592, local_blks_read = 94152527629880, local_blks_dirtied = 94152526422704, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 94151717788349, shared_blk_read_time = {ticks = 140491154154592}, shared_blk_write_time = {ticks = 94151717788368}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94151718172228}, temp_blk_read_time = {ticks = 94152526238000}, temp_blk_write_time = {ticks = 64}} [08:11:56.527] mem_counters = {nblocks = 94152526642344, freechunks = 8589934593, totalspace = 140727883046000, freespace = 10} [08:11:56.527] planner_ctx = 0x0 [08:11:56.527] saved_ctx = 0x0 [08:11:56.527] #22 0x000055a16736bd16 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55a197e74688, pstate=pstate@entry=0x55a197e193e8, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [08:11:56.527] No locals. [08:11:56.527] #23 0x000055a16736bfbe in ExplainQuery (pstate=pstate@entry=0x55a197e193e8, stmt=stmt@entry=0x55a197e460f0, params=params@entry=0x0, dest=dest@entry=0x55a197e19358) at ../src/backend/commands/explain.c:223 [08:11:56.527] l__state = [08:11:56.527] l = 0x55a197f50f60 [08:11:56.527] es = 0x55a197e74688 [08:11:56.527] tstate = [08:11:56.527] jstate = [08:11:56.527] query = [08:11:56.527] rewritten = 0x55a197f50f48 [08:11:56.527] #24 0x000055a1678a1646 in standard_ProcessUtility (pstmt=pstmt@entry=0x55a197e461a0, queryString=queryString@entry=0x55a197e446e0 "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=0x55a197e19358, qc=0x7ffdc37aa270) at ../src/backend/tcop/utility.c:866 [08:11:56.527] parsetree = 0x55a197e460f0 [08:11:56.527] isTopLevel = true [08:11:56.527] isAtomicContext = false [08:11:56.527] pstate = 0x55a197e193e8 [08:11:56.527] readonly_flags = [08:11:56.527] __func__ = "standard_ProcessUtility" [08:11:56.527] #25 0x00007fc6a7c2afa9 in pgss_ProcessUtility (pstmt=0x55a197e461a0, queryString=0x55a197e446e0 "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=0x55a197e19358, qc=0x7ffdc37aa270) at ../contrib/pg_stat_statements/pg_stat_statements.c:1181 [08:11:56.527] _save_exception_stack = 0x7ffdc37aa310 [08:11:56.527] _save_context_stack = 0x0 [08:11:56.527] _local_sigjmp_buf = {{__jmpbuf = {0, -7986951483396850582, 94152526422432, 94152526238552, 140727883047536, 1, 7985765066305305706, 7973036499668171882}, __mask_was_saved = 0, __saved_mask = {__val = {94151718048136, 94152526415328, 94151713487027, 2, 140727883047288, 94152527586906, 94152527586906, 94152527586008, 94151719614442, 446, 0, 94152527588360, 0, 94152527584888, 140491228934301, 1}}}} [08:11:56.527] _do_rethrow = false [08:11:56.527] duration = [08:11:56.527] bufusage = {shared_blks_hit = 0, shared_blks_read = 94151719067742, shared_blks_dirtied = 1, shared_blks_written = 94152526421168, local_blks_hit = 94152527584888, local_blks_read = 490, local_blks_dirtied = 1, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94151718172228, shared_blk_read_time = {ticks = 94152526415328}, shared_blk_write_time = {ticks = 94151718172228}, local_blk_read_time = {ticks = 94152526415328}, local_blk_write_time = {ticks = 3}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94151718176645}} [08:11:56.527] walusage_start = {wal_records = 60, wal_fpi = 0, wal_bytes = 6333, wal_buffers_full = 0} [08:11:56.527] start = [08:11:56.527] rows = [08:11:56.527] bufusage_start = {shared_blks_hit = 506, shared_blks_read = 47, shared_blks_dirtied = 15, shared_blks_written = 9, 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:11:56.527] walusage = {wal_records = 140727883046976, wal_fpi = 94151717651589, wal_bytes = 140727883046976, wal_buffers_full = 94151717847018} [08:11:56.527] parsetree = [08:11:56.527] saved_queryId = 3938666771540382425 [08:11:56.527] saved_stmt_location = 0 [08:11:56.527] saved_stmt_len = 204 [08:11:56.527] enabled = true [08:11:56.527] #26 0x000055a1678a1c2c in ProcessUtility (pstmt=pstmt@entry=0x55a197e461a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55a197e19358, qc=0x7ffdc37aa270) at ../src/backend/tcop/utility.c:519 [08:11:56.527] No locals. [08:11:56.527] #27 0x000055a16789d733 in PortalRunUtility (portal=portal@entry=0x55a197ec4f70, pstmt=0x55a197e461a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55a197e19358, qc=qc@entry=0x7ffdc37aa270) at ../src/backend/tcop/pquery.c:1153 [08:11:56.527] No locals. [08:11:56.527] #28 0x000055a16789df8e in FillPortalStore (portal=portal@entry=0x55a197ec4f70, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [08:11:56.527] treceiver = 0x55a197e19358 [08:11:56.527] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:56.527] __func__ = "FillPortalStore" [08:11:56.527] #29 0x000055a16789e4a9 in PortalRun (portal=portal@entry=0x55a197ec4f70, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55a197f62db8, altdest=altdest@entry=0x55a197f62db8, qc=qc@entry=0x7ffdc37aa430) at ../src/backend/tcop/pquery.c:760 [08:11:56.527] _save_exception_stack = 0x7ffdc37aa4e0 [08:11:56.527] _save_context_stack = 0x0 [08:11:56.527] _local_sigjmp_buf = {{__jmpbuf = {0, 4209610134179675242, 94152526942064, 94152526422376, 94152526422352, 94152526422304, 7985765064556280938, 4209294322960039018}, __mask_was_saved = 0, __saved_mask = {__val = {94151718176645, 3279594431, 4, 94152526422304, 112, 153, 94152526942064, 94152526422376, 94152526422352, 94152526422304, 94151718264445, 1, 2, 153, 94151707278917, 0}}}} [08:11:56.527] _do_rethrow = [08:11:56.527] result = [08:11:56.527] nprocessed = [08:11:56.527] saveTopTransactionResourceOwner = 0x55a197e88988 [08:11:56.527] saveTopTransactionContext = 0x55a197edb450 [08:11:56.527] saveActivePortal = 0x0 [08:11:56.527] saveResourceOwner = 0x55a197e88988 [08:11:56.527] savePortalContext = 0x0 [08:11:56.527] saveMemoryContext = 0x55a197edb450 [08:11:56.527] __func__ = "PortalRun" [08:11:56.527] #30 0x000055a1678971e1 in exec_simple_query (query_string=query_string@entry=0x55a197e446e0 "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:11:56.527] cmdtaglen = 7 [08:11:56.527] snapshot_set = [08:11:56.527] per_parsetree_context = 0x0 [08:11:56.527] plantree_list = 0x55a197f62d68 [08:11:56.527] parsetree = 0x55a197e46120 [08:11:56.527] commandTag = [08:11:56.527] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:56.527] querytree_list = [08:11:56.527] portal = 0x55a197ec4f70 [08:11:56.527] receiver = 0x55a197f62db8 [08:11:56.527] format = 0 [08:11:56.527] cmdtagname = [08:11:56.527] parsetree_item__state = [08:11:56.527] dest = DestRemote [08:11:56.527] oldcontext = 0x55a197edb450 [08:11:56.527] parsetree_list = 0x55a197e46150 [08:11:56.527] parsetree_item = 0x55a197e46168 [08:11:56.527] save_log_statement_stats = false [08:11:56.527] was_logged = true [08:11:56.527] use_implicit_block = false [08:11:56.527] msec_str = "\000uPh\241U\000\000Q\236\265g\241U\000\000\300\244z\303\375\177\000\000\316\000\000\000\000\000\000" [08:11:56.527] __func__ = "exec_simple_query" [08:11:56.527] #31 0x000055a16789a42a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [08:11:56.527] query_string = 0x55a197e446e0 "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:11:56.527] firstchar = [08:11:56.527] input_message = {data = 0x55a197e446e0 "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:11:56.527] local_sigjmp_buf = {{__jmpbuf = {94151731259672, 4209305509479185514, 4, 94151728198912, 24, 1, 7985765064354954346, 4209294322679282794}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94152526670128, 0, 168, 94151718176747, 0, 10, 2, 94151731259680, 94152526145760, 94151731253696, 94151728198912, 24, 1}}}} [08:11:56.527] send_ready_for_query = false [08:11:56.527] idle_in_transaction_timeout_enabled = false [08:11:56.527] idle_session_timeout_enabled = false [08:11:56.527] __func__ = "PostgresMain" [08:11:56.527] #32 0x000055a16788fd34 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:11:56.527] bsdata = [08:11:56.527] #33 0x000055a16772be6b in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffdc37aa640, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffdc37aa6b0) at ../src/backend/postmaster/launch_backend.c:290 [08:11:56.527] pid = [08:11:56.527] #34 0x000055a16773142f in BackendStartup (client_sock=client_sock@entry=0x7ffdc37aa6b0) at ../src/backend/postmaster/postmaster.c:3590 [08:11:56.527] bn = 0x55a197e6fbc8 [08:11:56.527] pid = [08:11:56.527] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809597165625954, fork_started = 809597165625960} [08:11:56.527] cac = [08:11:56.527] __func__ = "BackendStartup" [08:11:56.527] #35 0x000055a16773395b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:11:56.527] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\300օf\241U\000\000\030\235\201f\241U\000\000\000\250z\303\375\177\000\000\370\247z\303\375\177\000\000\225[\362\001\000\000\000\000\300\360旡U\000\000.", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\326]\253\306\177\000\000\020\254\250\252\306\177\000\000\340\322]\253\306\177\000\000\316)fR\000\000\000", __ss_align = 3279595584}, salen = 2}} [08:11:56.527] i = 0 [08:11:56.527] now = [08:11:56.527] last_lockfile_recheck_time = 1756281958 [08:11:56.527] last_touch_time = 1756281898 [08:11:56.527] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = -1419914528, user_data = 0x0}, {pos = -1015371648, events = 32765, fd = -1420088760, user_data = 0x11}, {pos = -1431786480, events = 32710, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1419914528, user_data = 0x7ffdc37aa7f8}, {pos = -1015371776, events = 32765, fd = -1419913624, user_data = 0x0}, {pos = -1746461736, events = 21921, fd = -1446282566, user_data = 0x55a197e71bd8}, {pos = 1, events = 21921, fd = 32768, user_data = 0xffffffff}, {pos = -1446846432, events = 32710, fd = -1424229872, user_data = 0x55a197e07778}, {pos = -1746897320, events = 21921, fd = -1746450895, user_data = 0x7fc6ab5b8ebe}, {pos = 1, events = 0, fd = -1419914528, user_data = 0x1b4}, {pos = 1745874336, events = 21921, fd = 0, user_data = 0x0}, {pos = 86, events = 0, fd = -1420063042, user_data = 0x1}, {pos = 0, events = 0, fd = -1446846432, user_data = 0x7fc6a9cf2e80 }, {pos = 16, events = 0, fd = -1015370656, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fc6ab5bb2ba}, {pos = 0, events = 0, fd = -1446318636, user_data = 0x0}, {pos = 1753060288, events = 21921, fd = 2, user_data = 0x0}, {pos = -1746929552, events = 21921, fd = 1736596085, user_data = 0x55a197e78fb0}, {pos = 1736599885, events = 21921, fd = -1746431989, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1446812472, user_data = 0x7fc6a9c9c880 }, {pos = -1447220944, events = 32710, fd = -1015370448, user_data = 0x100007f00000002}, {pos = -1446285513, events = 32710, fd = 2, user_data = 0x1010}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1444996000, events = 32710, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 171057184, events = 926429999, fd = 1634293514, user_data = 0x0}, {pos = 0, events = 0, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7fc6aaa8ba80}, {pos = -1431781440, events = 32710, 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 = -1746423856, events = 21921, fd = 1080, user_data = 0x55a197e07450}, {pos = 1740078788, events = 21921, fd = 1024, user_data = 0x7fc6a9cb58ee}, {pos = -1445013024, events = 32710, fd = -1446375058, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1746432080, user_data = 0x62ed35601c15e800}, {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 = 0x55a197e07450}, {pos = 3, events = 0, fd = 0, user_data = 0x66ac}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x77}, {pos = -1446039405, events = 32710, fd = -1746897840, user_data = 0x1}, {pos = -1746897640, events = 21921, fd = 1024, user_data = 0x7ffdc37aad38}, {pos = 1740159957, events = 21921, fd = 1753163984, user_data = 0x55a167b7a675 }, {pos = -1746897840, events = 21921, fd = -1746647584, user_data = 0x55a197e07450}, {pos = -1446291557, events = 32710, fd = 0, user_data = 0x55a167b8c4a3 }, {pos = -1746897840, events = 1, fd = 1740162540, user_data = 0x55a197e445e0}, {pos = -1446368591, events = 32710, fd = -1446374160, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 471197696, events = 1659712864, fd = -1746929552, user_data = 0x62ed35601c15e800}, {pos = 13, events = 0, fd = 471197696, user_data = 0x0}, {pos = -1446661575, events = 32710, fd = 0, user_data = 0x55a16772bb51 }, {pos = 4194304, events = 0, fd = -1746813888, user_data = 0x1}, {pos = 0, events = 0, fd = -1746929552, user_data = 0x55a167b7a509 }, {pos = -1746813888, events = 21921, fd = -1746647584, user_data = 0x55a197e1bc40}, {pos = 1, events = 0, fd = 0, user_data = 0x55a167b384dc }, {pos = 13, events = 0, fd = -1746464248, user_data = 0x55a197e711e8}, {pos = 1753061720, events = 21921, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 1735572747, user_data = 0x55a197e445e0}, {pos = 1735589655, events = 21921, fd = 1749361968, user_data = 0x55a197e44f98}} [08:11:56.527] nevents = 1 [08:11:56.527] __func__ = "ServerLoop" [08:11:56.527] #36 0x000055a167735235 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a197e027e0) at ../src/backend/postmaster/postmaster.c:1403 [08:11:56.527] opt = [08:11:56.527] status = [08:11:56.527] userDoption = [08:11:56.527] listen_addr_saved = false [08:11:56.527] output_config_variable = [08:11:56.527] __func__ = "PostmasterMain" [08:11:56.527] #37 0x000055a16755f9e8 in main (argc=4, argv=0x55a197e027e0) at ../src/backend/main/main.c:231 [08:11:56.527] do_check_root = [08:11:56.527] dispatch_option = [08:11:56.566] -e [08:11:56.566] [08:11:56.566] [08:11:56.661] dumping /tmp/cores/postgres-6-25496.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:11:56.926] [New LWP 25496] [08:11:56.926] [08:11:56.926] This GDB supports auto-downloading debuginfo from the following URLs: [08:11:56.926] [08:11:56.926] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [08:11:56.926] Debuginfod has been disabled. [08:11:56.926] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [08:11:57.172] [Thread debugging using libthread_db enabled] [08:11:57.172] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [08:11:57.172] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [08:11:57.172] Program terminated with signal SIGABRT, Aborted. [08:11:57.172] #0 0x00007f0cbdea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:58.142] [08:11:58.142] Thread 1 (Thread 0x7f0cbddd9a80 (LWP 25496)): [08:11:58.142] #0 0x00007f0cbdea9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:58.142] No symbol table info available. [08:11:58.142] #1 0x00007f0cbde5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:58.142] No symbol table info available. [08:11:58.142] #2 0x00007f0cbde45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [08:11:58.142] No symbol table info available. [08:11:58.142] #3 0x000056468b1d7a34 in ExceptionalCondition (conditionName=conditionName@entry=0x56468b40aea9 "n >= 0 && n < list->length", fileName=fileName@entry=0x56468b405d60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:11:58.142] No locals. [08:11:58.142] #4 0x000056468ace9b5b in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:11:58.142] No locals. [08:11:58.142] #5 0x000056468ace9b90 in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:11:58.142] No locals. [08:11:58.142] #6 0x000056468acef2c2 in var_is_nonnullable (root=0x5646ac91e968, var=var@entry=0x5646ac9f92d8, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:11:58.142] rte = [08:11:58.142] notnullattnums = 0x0 [08:11:58.142] #7 0x000056468acf318f in eval_const_expressions_mutator (node=node@entry=0x5646ac9f9258, context=context@entry=0x7fffca060ad0) at ../src/backend/optimizer/util/clauses.c:3556 [08:11:58.142] varg = 0x5646ac9f92d8 [08:11:58.142] result = [08:11:58.142] ntest = 0x5646ac9f9258 [08:11:58.142] newntest = [08:11:58.142] arg = 0x5646ac9f92d8 [08:11:58.142] __func__ = "eval_const_expressions_mutator" [08:11:58.142] #8 0x000056468acf421d in simplify_and_arguments (args=, context=context@entry=0x7fffca060ad0, haveNull=haveNull@entry=0x7fffca060a7c, forceFalse=forceFalse@entry=0x7fffca060a80) at ../src/backend/optimizer/util/clauses.c:3964 [08:11:58.142] arg = 0x5646ac9f9258 [08:11:58.142] newargs = 0x5646ac9f9468 [08:11:58.142] unprocessed_args = 0x0 [08:11:58.142] #9 0x000056468acf1217 in eval_const_expressions_mutator (node=0x5646ac9f9098, context=context@entry=0x7fffca060ad0) at ../src/backend/optimizer/util/clauses.c:2877 [08:11:58.142] newargs = [08:11:58.142] haveNull = false [08:11:58.142] forceFalse = false [08:11:58.142] expr = 0x5646ac9f9098 [08:11:58.142] __func__ = "eval_const_expressions_mutator" [08:11:58.142] #10 0x000056468acf3d53 in eval_const_expressions (root=root@entry=0x5646ac91e968, node=node@entry=0x5646ac9f9098) at ../src/backend/optimizer/util/clauses.c:2272 [08:11:58.142] context = {boundParams = 0x0, root = 0x5646ac91e968, active_fns = 0x0, case_val = 0x0, estimate = false} [08:11:58.142] #11 0x000056468accd1f6 in convert_EXISTS_sublink_to_join (root=0x5646ac91e968, sublink=sublink@entry=0x5646ac8f5e70, under_not=under_not@entry=false, available_rels=available_rels@entry=0x5646ac91ee98) at ../src/backend/optimizer/plan/subselect.c:1541 [08:11:58.142] je = [08:11:58.142] lc__state = [08:11:58.142] result = [08:11:58.142] parse = 0x5646ac8f6290 [08:11:58.142] subselect = 0x5646acb2c278 [08:11:58.142] whereClause = 0x5646ac9f9098 [08:11:58.142] subroot = {type = 2328802897, parse = 0x7fffca061000, glob = 0x1, query_level = 2327927735, parent_root = 0x5646ac9ea948, plan_params = 0x56468ac14b24 , outer_params = 0x5646ac930498, simple_rel_array = 0x5646ac8f5c90, simple_rel_array_size = 0, simple_rte_array = 0x7fffca061000, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x56468aceb76b , join_rel_list = 0x74a6, join_rel_hash = 0x5646ac9ea998, join_rel_level = 0x56468aceb651 , join_cur_level = -905572352, init_plans = 0x1, cte_plan_ids = 0x56468ac16215 , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 216, canon_pathkeys = 0x56468aceb651 , left_join_clauses = 0x7fffca061000, right_join_clauses = 0x7fffca061000, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = -1967042056, all_result_relids = 0x7fffca060d70, leaf_result_relids = 0x5646ac9e9ad0, append_rel_list = 0x56468aceb651 , row_identity_vars = 0x5646ac9f2ad8, rowMarks = 0x0, placeholder_list = 0x7fffca061000, placeholder_array = 0x7fffca061000, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x56468aceb76b , group_pathkeys = 0x56468aceb651 , num_groupby_pathkeys = -1398854904, window_pathkeys = 0x56468aceb651 , distinct_pathkeys = 0x5646ac9ea340, sort_pathkeys = 0x56468aceb651 , setop_pathkeys = 0x7fffca061000, part_schemes = 0x0, initial_rels = 0x56468ac16c04 , upper_rels = {0x5646ac956cc8, 0x5646ac9e9938, 0x3, 0x3, 0x0, 0x56468b21b644 , 0x5646ac9eca70, 0x400}, upper_targets = {0x7, 0x56468b21c785 , 0x2ca061000, 0x7, 0x0, 0x400, 0x5646ac9ecc00, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x56468b2319a1 , grouping_map = 0x20, minmax_aggs = 0x5646ac9ecc00, planner_cxt = 0x0, total_table_pages = 4.6867552308224077e-310, tuple_fraction = 4.6867829306600744e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 133, placeholdersFrozen = 199, hasRecursion = 33, group_rtindex = 22086, agginfos = 0xac9ecb70, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x5646ac91ee00, isUsedSubplan = 0x0, join_search_private = 0x56468b231e7d , partColsUpdated = 197, partPruneInfos = 0x0} [08:11:58.142] rtoffset = [08:11:58.142] varno = [08:11:58.142] clause_varnos = [08:11:58.142] upper_varnos = [08:11:58.142] lc = [08:11:58.142] newWhere = 0x0 [08:11:58.142] all_clauses = 0x5646ac9f9048 [08:11:58.142] upper_reference_exists = false [08:11:58.142] #12 0x000056468acd8016 in pull_up_sublinks_qual_recurse (root=root@entry=0x5646ac91e968, node=0x5646ac8f5e70, jtlink1=jtlink1@entry=0x5646ac91ee00, available_rels1=0x5646ac91ee98, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:11:58.142] sublink = 0x5646ac8f5e70 [08:11:58.142] j = [08:11:58.142] child_rels = 0x5646ac8f5ec0 [08:11:58.142] #13 0x000056468acd7aea in pull_up_sublinks_jointree_recurse (root=root@entry=0x5646ac91e968, jtnode=, relids=relids@entry=0x7fffca060f48) at ../src/backend/optimizer/prep/prepjointree.c:776 [08:11:58.142] j = 0x5646ac91ede8 [08:11:58.142] leftrelids = 0x5646ac91ee78 [08:11:58.142] rightrelids = 0x5646ac91ee98 [08:11:58.142] jtlink = 0x5646ac91ede8 [08:11:58.142] __func__ = "pull_up_sublinks_jointree_recurse" [08:11:58.142] #14 0x000056468acd7c1e in pull_up_sublinks_jointree_recurse (root=root@entry=0x5646ac91e968, jtnode=0x5646ac9f3af8, relids=relids@entry=0x7fffca060f98) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:11:58.142] newchild = [08:11:58.142] childrelids = 0x40030000a9c2 [08:11:58.142] l__state = [08:11:58.142] frelids = 0x0 [08:11:58.142] newf = [08:11:58.142] jtlink = 0x40030000a9c2 [08:11:58.142] f = 0x5646ac9f3af8 [08:11:58.142] newfromlist = 0x0 [08:11:58.142] l = [08:11:58.142] __func__ = "pull_up_sublinks_jointree_recurse" [08:11:58.142] #15 0x000056468acd9c04 in pull_up_sublinks (root=root@entry=0x5646ac91e968) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:11:58.142] jtnode = [08:11:58.142] relids = 0x5646ac8f6290 [08:11:58.142] #16 0x000056468acb7f0f in subquery_planner (glob=glob@entry=0x5646ac930738, parse=parse@entry=0x5646ac8f6290, 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:11:58.142] root = 0x5646ac91e968 [08:11:58.142] newWithCheckOptions = [08:11:58.142] newHaving = [08:11:58.142] hasOuterJoins = [08:11:58.142] hasResultRTEs = [08:11:58.142] final_rel = [08:11:58.142] l = [08:11:58.142] #17 0x000056468acba0f9 in standard_planner (parse=0x5646ac8f6290, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:442 [08:11:58.142] result = [08:11:58.142] glob = 0x5646ac930738 [08:11:58.142] tuple_fraction = 0 [08:11:58.142] root = [08:11:58.142] final_rel = [08:11:58.142] best_path = [08:11:58.142] top_plan = [08:11:58.142] lp = [08:11:58.142] lr = [08:11:58.142] #18 0x000056468acbb20f in planner (parse=parse@entry=0x5646ac8f6290, query_string=query_string@entry=0x5646ac8f46c0 "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:11:58.142] result = [08:11:58.142] #19 0x000056468af3a6f3 in pg_plan_query (querytree=querytree@entry=0x5646ac8f6290, query_string=query_string@entry=0x5646ac8f46c0 "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:11:58.142] plan = [08:11:58.142] #20 0x000056468aa0fa30 in standard_ExplainOneQuery (query=0x5646ac8f6290, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5646ac930498, queryString=0x5646ac8f46c0 "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:11:58.142] plan = [08:11:58.142] planstart = [08:11:58.142] planduration = {ticks = 94860975571680} [08:11:58.142] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94860981946245, shared_blks_dirtied = 3389395438, 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 = 94861542777488, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94860982033636}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94860975569061}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94861542777488}} [08:11:58.142] bufusage = {shared_blks_hit = 1, shared_blks_read = 94860978680637, shared_blks_dirtied = 186650688765955, shared_blks_written = 72057594037927936, local_blks_hit = 139692503872608, local_blks_read = 94861543771208, local_blks_dirtied = 94861542777488, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 94860981557949, shared_blk_read_time = {ticks = 139692503872608}, shared_blk_write_time = {ticks = 94860981557968}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94860981941828}, temp_blk_read_time = {ticks = 94861542592784}, temp_blk_write_time = {ticks = 64}} [08:11:58.142] mem_counters = {nblocks = 94861545095640, freechunks = 8589934593, totalspace = 140736582783344, freespace = 10} [08:11:58.142] planner_ctx = 0x0 [08:11:58.142] saved_ctx = 0x0 [08:11:58.142] #21 0x000056468aa0fd16 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5646ac930498, pstate=pstate@entry=0x5646ac8c93c8, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [08:11:58.142] No locals. [08:11:58.142] #22 0x000056468aa0ffbe in ExplainQuery (pstate=pstate@entry=0x5646ac8c93c8, stmt=stmt@entry=0x5646ac8f60d0, params=params@entry=0x0, dest=dest@entry=0x5646ac8c9338) at ../src/backend/commands/explain.c:223 [08:11:58.142] l__state = [08:11:58.142] l = 0x5646acb2c240 [08:11:58.142] es = 0x5646ac930498 [08:11:58.142] tstate = [08:11:58.142] jstate = [08:11:58.142] query = [08:11:58.142] rewritten = 0x5646acb2c228 [08:11:58.142] #23 0x000056468af45646 in standard_ProcessUtility (pstmt=0x5646ac8f6180, queryString=0x5646ac8f46c0 "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=0x5646ac8c9338, qc=0x7fffca0613e0) at ../src/backend/tcop/utility.c:866 [08:11:58.142] parsetree = 0x5646ac8f60d0 [08:11:58.142] isTopLevel = true [08:11:58.142] isAtomicContext = false [08:11:58.142] pstate = 0x5646ac8c93c8 [08:11:58.142] readonly_flags = [08:11:58.142] __func__ = "standard_ProcessUtility" [08:11:58.142] #24 0x000056468af45ce1 in ProcessUtility (pstmt=pstmt@entry=0x5646ac8f6180, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5646ac8c9338, qc=0x7fffca0613e0) at ../src/backend/tcop/utility.c:523 [08:11:58.142] No locals. [08:11:58.142] #25 0x000056468af41733 in PortalRunUtility (portal=portal@entry=0x5646ac9793f0, pstmt=0x5646ac8f6180, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5646ac8c9338, qc=qc@entry=0x7fffca0613e0) at ../src/backend/tcop/pquery.c:1153 [08:11:58.142] No locals. [08:11:58.142] #26 0x000056468af41f8e in FillPortalStore (portal=portal@entry=0x5646ac9793f0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [08:11:58.142] treceiver = 0x5646ac8c9338 [08:11:58.142] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:58.142] __func__ = "FillPortalStore" [08:11:58.142] #27 0x000056468af424a9 in PortalRun (portal=portal@entry=0x5646ac9793f0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5646ac9f3dd8, altdest=altdest@entry=0x5646ac9f3dd8, qc=qc@entry=0x7fffca0615a0) at ../src/backend/tcop/pquery.c:760 [08:11:58.142] _save_exception_stack = 0x7fffca061650 [08:11:58.142] _save_context_stack = 0x0 [08:11:58.142] _local_sigjmp_buf = {{__jmpbuf = {0, -8939064669870346133, 94861543314416, 94861542777160, 94861542777136, 94861542777088, -3422492479588257685, -8938980204084055957}, __mask_was_saved = 0, __saved_mask = {__val = {94860981946245, 3389396271, 4, 94861542777088, 112, 153, 94861543314416, 94861542777160, 94861542777136, 94861542777088, 94860982034045, 1, 2, 153, 94860971048517, 0}}}} [08:11:58.142] _do_rethrow = [08:11:58.142] result = [08:11:58.142] nprocessed = [08:11:58.142] saveTopTransactionResourceOwner = 0x5646ac935ea8 [08:11:58.142] saveTopTransactionContext = 0x5646ac98d890 [08:11:58.142] saveActivePortal = 0x0 [08:11:58.142] saveResourceOwner = 0x5646ac935ea8 [08:11:58.142] savePortalContext = 0x0 [08:11:58.142] saveMemoryContext = 0x5646ac98d890 [08:11:58.142] __func__ = "PortalRun" [08:11:58.142] #28 0x000056468af3b1e1 in exec_simple_query (query_string=query_string@entry=0x5646ac8f46c0 "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:11:58.142] cmdtaglen = 7 [08:11:58.142] snapshot_set = [08:11:58.142] per_parsetree_context = 0x0 [08:11:58.142] plantree_list = 0x5646ac9f3d88 [08:11:58.142] parsetree = 0x5646ac8f6100 [08:11:58.142] commandTag = [08:11:58.142] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:58.142] querytree_list = [08:11:58.142] portal = 0x5646ac9793f0 [08:11:58.142] receiver = 0x5646ac9f3dd8 [08:11:58.142] format = 0 [08:11:58.142] cmdtagname = [08:11:58.142] parsetree_item__state = [08:11:58.142] dest = DestRemote [08:11:58.142] oldcontext = 0x5646ac98d890 [08:11:58.142] parsetree_list = 0x5646ac8f6130 [08:11:58.142] parsetree_item = 0x5646ac8f6148 [08:11:58.142] save_log_statement_stats = false [08:11:58.142] was_logged = false [08:11:58.142] use_implicit_block = false [08:11:58.142] msec_str = "\000\265\272\213FV\000\000Q\336\037\213FV\000\0000\026\006\312\377\177\000\000\316\000\000\000\000\000\000" [08:11:58.142] __func__ = "exec_simple_query" [08:11:58.142] #29 0x000056468af3e42a in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [08:11:58.142] query_string = 0x5646ac8f46c0 "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:11:58.142] firstchar = [08:11:58.142] input_message = {data = 0x5646ac8f46c0 "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:11:58.142] local_sigjmp_buf = {{__jmpbuf = {94860995029272, -8938977960223690645, 4, 94860991968512, 24, 20, -3422492479521148821, -8938980251080970133}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94861542500512, 16128, 94860995023296, 94861543034464, 24, 94860981945793, 0, 9, 2, 94860995029280, 94861542500512, 94860995023296, 94860991968512, 24, 20}}}} [08:11:58.142] send_ready_for_query = false [08:11:58.142] idle_in_transaction_timeout_enabled = false [08:11:58.142] idle_session_timeout_enabled = false [08:11:58.142] __func__ = "PostgresMain" [08:11:58.142] #30 0x000056468af33d34 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:11:58.142] bsdata = [08:11:58.142] #31 0x000056468adcfe6b in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x7fffca0617b0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fffca061820) at ../src/backend/postmaster/launch_backend.c:290 [08:11:58.142] pid = [08:11:58.142] #32 0x000056468add542f in BackendStartup (client_sock=client_sock@entry=0x7fffca061820) at ../src/backend/postmaster/postmaster.c:3590 [08:11:58.142] bn = 0x5646ac91cce8 [08:11:58.142] pid = [08:11:58.142] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809597094079272, fork_started = 809597094079275} [08:11:58.142] cac = [08:11:58.142] __func__ = "BackendStartup" [08:11:58.142] #33 0x000056468add795b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:11:58.142] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = "\006\312\377\177\000\000\264\030\006\312\377\177", '\000' , "\300\026\360\211FV\000\000\030\335\353\211FV\000\000\200\031\006\312\377\177\000\000x\031\006\312\377\177\000\000\225[\362\001\000\000\000\000p\272c\276\f\177\000\000-", '\000' , "\316\025\360\211FV\000\000hV\201\277\f\177\000\000\020\274c\276\f\177\000", __ss_align = 139692729258720}, salen = 2}} [08:11:58.142] i = 0 [08:11:58.142] now = [08:11:58.142] last_lockfile_recheck_time = 1756281885 [08:11:58.142] last_touch_time = 1756281825 [08:11:58.142] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = -1082042776, user_data = 0x0}, {pos = -1082043680, events = 32524, fd = 2090263927, user_data = 0x7fffca061a00}, {pos = -1082217912, events = 32524, fd = 17, user_data = 0x7f0cbe63bc10}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1082043680, events = 32524, fd = -905569928, user_data = 0x7fffca061980}, {pos = -1082042776, events = 32524, fd = 0, user_data = 0x5646ac8f46d8}, {pos = -1960394746, events = 22086, fd = 32768, user_data = 0x1}, {pos = -1399889040, events = 22086, fd = -1, user_data = 0x7f0cbde2e020}, {pos = -1087051248, events = 32524, fd = -1400146120, user_data = 0x5646ac8b7618}, {pos = -1399710687, events = 22086, fd = -1082192194, user_data = 0x1}, {pos = -1082043680, events = 32524, fd = 436, user_data = 0x56468b7a2da0 }, {pos = 0, events = 0, fd = 0, user_data = 0xe5}, {pos = -1082192194, events = 32524, fd = 1, user_data = 0x0}, {pos = -1109204960, events = 32524, fd = -1108398464, user_data = 0x10}, {pos = -905568816, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1082182982, user_data = 0x0}, {pos = -1108677164, events = 32524, fd = 0, user_data = 0x56468be7d3c0 }, {pos = 2, events = 0, fd = 0, user_data = 0x5646ac8af870}, {pos = -1964201651, events = 22086, fd = -1399689637, user_data = 0x56468aece76d }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5646ac8f46d8}, {pos = -1082192194, events = 32524, fd = 1, user_data = 0x0}, {pos = -1109171000, events = 32524, fd = -1108752256, user_data = 0x451}, {pos = -1108643683, events = 32524, fd = 2, user_data = 0x5646ac926e00}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -1107354528, events = 32524, fd = 255, user_data = 0xfffffffffffffee8}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, 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 = 0x5646ac8b7410}, {pos = -1960722748, events = 22086, fd = 1024, user_data = 0x7f0cbdeb58ee}, {pos = -1107371552, events = 32524, fd = -1108733586, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1399710656, user_data = 0x53e61fe47238300}, {pos = -1107368480, events = 32524, fd = -336, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x3d0b}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x106}, {pos = -1108397933, events = 32524, fd = -1400146928, user_data = 0x1}, {pos = -1400146728, events = 22086, fd = 1024, user_data = 0x7fffca061ea8}, {pos = -1960641579, events = 22086, fd = -1947637552, user_data = 0x56468b21e675 }, {pos = -1400146928, events = 22086, fd = -1399896640, user_data = 0x5646ac8b7410}, {pos = -1108649746, events = 32524, fd = 0, user_data = 0x56468b2304a3 }, {pos = -1400146928, events = 1, fd = -1960638996, user_data = 0x5646ac8f45c0}, {pos = -1108727119, events = 32524, fd = -1108732688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1193509632, events = 87974398, fd = -1400178576, user_data = 0x53e61fe47238300}, {pos = 13, events = 0, fd = 1193509632, user_data = 0x0}, {pos = -1109020103, events = 32524, fd = 0, user_data = 0x56468adcfb51 }, {pos = 4194304, events = 0, fd = -1400062944, user_data = 0x1}, {pos = 0, events = 0, fd = -1400178576, user_data = 0x56468b21e509 }, {pos = -1400062944, events = 22086, fd = -1399896640, user_data = 0x5646ac8cbc20}, {pos = 1, events = 0, fd = 0, user_data = 0x56468b1dc4dc }, {pos = 13, events = 0, fd = -1399719320, user_data = 0x5646ac91fa48}, {pos = -1947739816, events = 22086, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -1965228789, user_data = 0x5646ac8f45c0}, {pos = -1965211881, events = 22086, fd = -1951439568, user_data = 0x5646ac8f4f68}} [08:11:58.142] nevents = 1 [08:11:58.142] __func__ = "ServerLoop" [08:11:58.142] #34 0x000056468add9235 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5646ac8b27b0) at ../src/backend/postmaster/postmaster.c:1403 [08:11:58.142] opt = [08:11:58.142] status = [08:11:58.142] userDoption = [08:11:58.142] listen_addr_saved = false [08:11:58.142] output_config_variable = [08:11:58.142] __func__ = "PostmasterMain" [08:11:58.142] #35 0x000056468ac039e8 in main (argc=4, argv=0x5646ac8b27b0) at ../src/backend/main/main.c:231 [08:11:58.142] do_check_root = [08:11:58.142] dispatch_option =