[01:37:13.043] src/tools/ci/cores_backtrace.sh linux /tmp/cores [01:37:13.271] dumping /tmp/cores/postgres-6-54945.core for /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/postgres [01:37:13.572] [New LWP 54945] [01:37:13.575] [01:37:13.575] This GDB supports auto-downloading debuginfo from the following URLs: [01:37:13.575] [01:37:13.575] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:37:13.575] Debuginfod has been disabled. [01:37:13.575] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:37:13.830] [Thread debugging using libthread_db enabled] [01:37:13.830] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:37:13.830] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [01:37:13.830] Program terminated with signal SIGABRT, Aborted. [01:37:13.830] #0 0x00007f5c362abeec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:13.932] [01:37:13.932] Thread 1 (Thread 0x7f5c3601fac0 (LWP 54945)): [01:37:13.932] #0 0x00007f5c362abeec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:13.932] No symbol table info available. [01:37:13.932] #1 0x00007f5c3625cfb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:13.932] No symbol table info available. [01:37:13.932] #2 0x00007f5c36247472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:13.932] No symbol table info available. [01:37:13.932] #3 0x000055a9caa29815 in ExceptionalCondition (conditionName=conditionName@entry=0x55a9cad91ce0 "n >= 0 && n < list->length", fileName=fileName@entry=0x55a9cad91c40 "../../../../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at assert.c:66 [01:37:13.932] No locals. [01:37:13.932] #4 0x000055a9ca4c33c2 in list_nth_cell (list=, n=) at ../../../../src/include/nodes/pg_list.h:280 [01:37:13.932] No locals. [01:37:13.932] #5 0x000055a9ca4c33f7 in list_nth (list=, n=) at ../../../../src/include/nodes/pg_list.h:302 [01:37:13.932] No locals. [01:37:13.932] #6 0x000055a9ca4c9439 in var_is_nonnullable (root=0x62100005b538, var=var@entry=0x6250001548d8, use_rel_info=use_rel_info@entry=false) at clauses.c:4235 [01:37:13.932] rte = [01:37:13.932] notnullattnums = 0x0 [01:37:13.932] #7 0x000055a9ca4ce561 in eval_const_expressions_mutator (node=node@entry=0x625000154858, context=context@entry=0x7ffed4ddc660) at clauses.c:3556 [01:37:13.932] varg = 0x6250001548d8 [01:37:13.932] result = [01:37:13.932] ntest = 0x625000154858 [01:37:13.932] newntest = [01:37:13.932] arg = 0x6250001548d8 [01:37:13.932] __func__ = "eval_const_expressions_mutator" [01:37:13.932] #8 0x000055a9ca4cf83b in simplify_and_arguments (args=, context=context@entry=0x7ffed4ddc660, haveNull=haveNull@entry=0x7ffed4ddc4e0, forceFalse=forceFalse@entry=0x7ffed4ddc4f0) at clauses.c:3964 [01:37:13.932] arg = 0x625000154858 [01:37:13.932] newargs = 0x625000154a68 [01:37:13.932] unprocessed_args = 0x0 [01:37:13.932] #9 0x000055a9ca4cbf23 in eval_const_expressions_mutator (node=node@entry=0x625000154698, context=context@entry=0x7ffed4ddc660) at clauses.c:2877 [01:37:13.932] newargs = [01:37:13.932] haveNull = [01:37:13.932] forceFalse = [01:37:13.932] expr = 0x625000154698 [01:37:13.932] __func__ = "eval_const_expressions_mutator" [01:37:13.932] #10 0x000055a9ca4cf31d in eval_const_expressions (root=root@entry=0x62100005b538, node=node@entry=0x625000154698) at clauses.c:2272 [01:37:13.932] context = [01:37:13.932] #11 0x000055a9ca4a1da7 in convert_EXISTS_sublink_to_join (root=root@entry=0x62100005b538, sublink=sublink@entry=0x6250000091b0, under_not=under_not@entry=false, available_rels=available_rels@entry=0x62100005ba68) at subselect.c:1541 [01:37:13.932] je = [01:37:13.932] lc__state = [01:37:13.932] result = [01:37:13.932] parse = 0x6250000095d0 [01:37:13.932] subselect = 0x61d00005f568 [01:37:13.932] whereClause = 0x625000154698 [01:37:13.932] subroot = [01:37:13.932] rtoffset = [01:37:13.932] varno = [01:37:13.932] clause_varnos = [01:37:13.932] upper_varnos = [01:37:13.932] lc = [01:37:13.932] newWhere = 0x0 [01:37:13.932] all_clauses = 0x625000154648 [01:37:13.932] upper_reference_exists = false [01:37:13.932] #12 0x000055a9ca4ab843 in pull_up_sublinks_qual_recurse (root=root@entry=0x62100005b538, node=0x6250000091b0, jtlink1=jtlink1@entry=0x62100005b9d0, available_rels1=, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at prepjointree.c:912 [01:37:13.932] sublink = 0x6250000091b0 [01:37:13.932] j = [01:37:13.932] child_rels = [01:37:13.932] #13 0x000055a9ca4ac53a in pull_up_sublinks_jointree_recurse (root=root@entry=0x62100005b538, jtnode=0x625000009200, relids=relids@entry=0x7ffed4ddcd70) at prepjointree.c:776 [01:37:13.932] j = 0x62100005b9b8 [01:37:13.932] leftrelids = [01:37:13.932] rightrelids = [01:37:13.932] jtlink = [01:37:13.932] __func__ = "pull_up_sublinks_jointree_recurse" [01:37:13.932] #14 0x000055a9ca4ac6a7 in pull_up_sublinks_jointree_recurse (root=root@entry=0x62100005b538, jtnode=0x6290000d3258, relids=relids@entry=0x7ffed4ddce50) at prepjointree.c:706 [01:37:13.932] newchild = [01:37:13.932] childrelids = [01:37:13.932] l__state = [01:37:13.932] frelids = 0x0 [01:37:13.932] newf = [01:37:13.932] jtlink = [01:37:13.932] f = 0x6290000d3258 [01:37:13.932] newfromlist = 0x0 [01:37:13.932] l = [01:37:13.932] __func__ = "pull_up_sublinks_jointree_recurse" [01:37:13.932] #15 0x000055a9ca4b10d7 in pull_up_sublinks (root=root@entry=0x62100005b538) at prepjointree.c:653 [01:37:13.932] jtnode = [01:37:13.932] relids = [01:37:13.932] #16 0x000055a9ca488a5c in subquery_planner (glob=glob@entry=0x61900008c358, parse=parse@entry=0x6250000095d0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at planner.c:751 [01:37:13.932] root = 0x62100005b538 [01:37:13.932] newWithCheckOptions = [01:37:13.932] newHaving = [01:37:13.932] hasOuterJoins = [01:37:13.932] hasResultRTEs = [01:37:13.932] final_rel = [01:37:13.932] l = [01:37:13.932] #17 0x000055a9ca48b60b in standard_planner (parse=0x6250000095d0, query_string=, cursorOptions=2048, boundParams=) at planner.c:436 [01:37:13.932] result = [01:37:13.932] glob = 0x61900008c358 [01:37:13.932] tuple_fraction = 0 [01:37:13.932] root = [01:37:13.932] final_rel = [01:37:13.932] best_path = [01:37:13.932] top_plan = [01:37:13.932] lp = [01:37:13.932] lr = [01:37:13.932] #18 0x000055a9ca48cd23 in planner (parse=parse@entry=0x6250000095d0, query_string=query_string@entry=0x625000007a00 "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 planner.c:295 [01:37:13.932] result = [01:37:13.932] #19 0x000055a9ca70ec38 in pg_plan_query (querytree=querytree@entry=0x6250000095d0, query_string=query_string@entry=0x625000007a00 "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 postgres.c:900 [01:37:13.932] plan = [01:37:13.932] #20 0x000055a9ca089b61 in standard_ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x61900008c0b8, queryString=, params=, queryEnv=) at explain.c:353 [01:37:13.932] plan = [01:37:13.932] planstart = [01:37:13.932] planduration = [01:37:13.932] bufusage_start = [01:37:13.932] bufusage = [01:37:13.932] mem_counters = [01:37:13.932] planner_ctx = 0x0 [01:37:13.932] saved_ctx = 0x0 [01:37:13.932] #21 0x000055a9ca089fc8 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x61900008c0b8, pstate=pstate@entry=0x619000005338, params=params@entry=0x0) at explain.c:309 [01:37:13.932] No locals. [01:37:13.932] #22 0x000055a9ca08a313 in ExplainQuery (pstate=pstate@entry=0x619000005338, stmt=stmt@entry=0x625000009410, params=params@entry=0x0, dest=dest@entry=0x6190000052a8) at explain.c:223 [01:37:13.932] l__state = [01:37:13.932] l = 0x61d00005f530 [01:37:13.932] es = 0x61900008c0b8 [01:37:13.932] tstate = [01:37:13.932] jstate = [01:37:13.932] query = [01:37:13.932] rewritten = 0x61d00005f518 [01:37:13.932] #23 0x000055a9ca71c37a in standard_ProcessUtility (pstmt=0x6250000094c0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=, qc=) at utility.c:866 [01:37:13.932] parsetree = 0x625000009410 [01:37:13.932] isTopLevel = true [01:37:13.932] isAtomicContext = false [01:37:13.932] pstate = 0x619000005338 [01:37:13.932] readonly_flags = [01:37:13.932] __func__ = "standard_ProcessUtility" [01:37:13.932] #24 0x000055a9ca71ca43 in ProcessUtility (pstmt=pstmt@entry=0x6250000094c0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x6190000052a8, qc=0x7ffed4ddd540) at utility.c:523 [01:37:13.932] No locals. [01:37:13.932] #25 0x000055a9ca7179ab in PortalRunUtility (portal=portal@entry=0x625000032200, pstmt=0x6250000094c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x6190000052a8, qc=qc@entry=0x7ffed4ddd540) at pquery.c:1153 [01:37:13.932] No locals. [01:37:13.932] #26 0x000055a9ca7183e7 in FillPortalStore (portal=portal@entry=0x625000032200, isTopLevel=isTopLevel@entry=true) at pquery.c:1026 [01:37:13.932] treceiver = 0x6190000052a8 [01:37:13.932] qc = [01:37:13.932] __func__ = "FillPortalStore" [01:37:13.932] #27 0x000055a9ca718d2c in PortalRun (portal=portal@entry=0x625000032200, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x6290000d3538, altdest=altdest@entry=0x6290000d3538, qc=qc@entry=0x7ffed4ddd830) at pquery.c:760 [01:37:13.932] _save_exception_stack = 0x7ffed4ddd9b0 [01:37:13.932] _save_context_stack = 0x0 [01:37:13.932] _local_sigjmp_buf = [01:37:13.932] _do_rethrow = [01:37:13.932] result = [01:37:13.932] nprocessed = [01:37:13.932] saveTopTransactionResourceOwner = 0x629000024248 [01:37:13.932] saveTopTransactionContext = 0x625000039900 [01:37:13.932] saveActivePortal = 0x0 [01:37:13.932] saveResourceOwner = 0x629000024248 [01:37:13.932] savePortalContext = 0x0 [01:37:13.932] saveMemoryContext = 0x625000039900 [01:37:13.932] __func__ = "PortalRun" [01:37:13.932] #28 0x000055a9ca70fab8 in exec_simple_query (query_string=query_string@entry=0x625000007a00 "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 postgres.c:1274 [01:37:13.932] cmdtaglen = [01:37:13.932] snapshot_set = [01:37:13.932] per_parsetree_context = 0x0 [01:37:13.932] plantree_list = 0x6290000d34e8 [01:37:13.932] parsetree = 0x625000009440 [01:37:13.932] commandTag = [01:37:13.932] qc = [01:37:13.932] querytree_list = [01:37:13.932] portal = 0x625000032200 [01:37:13.932] receiver = 0x6290000d3538 [01:37:13.932] format = [01:37:13.932] cmdtagname = [01:37:13.932] parsetree_item__state = [01:37:13.932] dest = DestRemote [01:37:13.932] oldcontext = 0x625000039900 [01:37:13.932] parsetree_list = 0x625000009470 [01:37:13.932] parsetree_item = 0x625000009488 [01:37:13.932] save_log_statement_stats = false [01:37:13.932] was_logged = false [01:37:13.932] use_implicit_block = false [01:37:13.932] msec_str = [01:37:13.932] __func__ = "exec_simple_query" [01:37:13.932] #29 0x000055a9ca713d82 in PostgresMain (dbname=dbname@entry=0x6290000203a8 "regression", username=username@entry=0x629000020388 "postgres") at postgres.c:4767 [01:37:13.932] query_string = 0x625000007a00 "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"... [01:37:13.932] firstchar = [01:37:13.932] input_message = [01:37:13.932] local_sigjmp_buf = [01:37:13.932] send_ready_for_query = [01:37:13.932] idle_in_transaction_timeout_enabled = [01:37:13.932] idle_session_timeout_enabled = [01:37:13.932] __func__ = "PostgresMain" [01:37:13.932] #30 0x000055a9ca70599b in BackendMain (startup_data=, startup_data_len=) at backend_startup.c:124 [01:37:13.932] bsdata = [01:37:13.932] #31 0x000055a9ca54648f in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7ffed4dddb90, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffed4dddc40) at launch_backend.c:290 [01:37:13.932] pid = [01:37:13.932] #32 0x000055a9ca54c4ad in BackendStartup (client_sock=client_sock@entry=0x7ffed4dddc40) at postmaster.c:3587 [01:37:13.932] bn = 0x627000000258 [01:37:13.932] pid = [01:37:13.932] startup_data = [01:37:13.932] cac = [01:37:13.932] __func__ = "BackendStartup" [01:37:13.932] #33 0x000055a9ca54f538 in ServerLoop () at postmaster.c:1702 [01:37:13.932] s = [01:37:13.932] i = 0 [01:37:13.932] now = [01:37:13.932] last_lockfile_recheck_time = 1755221513 [01:37:13.932] last_touch_time = 1755221393 [01:37:13.932] events = [01:37:13.932] nevents = 1 [01:37:13.932] __func__ = "ServerLoop" [01:37:13.932] #34 0x000055a9ca551682 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x604000000690) at postmaster.c:1400 [01:37:13.932] opt = [01:37:13.932] status = [01:37:13.932] userDoption = [01:37:13.932] listen_addr_saved = false [01:37:13.932] output_config_variable = [01:37:13.932] __func__ = "PostmasterMain" [01:37:13.932] #35 0x000055a9ca2e0e56 in main (argc=4, argv=0x604000000690) at main.c:231 [01:37:13.932] do_check_root = [01:37:13.932] dispatch_option = [01:37:13.958] -e [01:37:13.958] [01:37:13.958] [01:37:14.066] dumping /tmp/cores/postgres-6-59547.core for /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/postgres [01:37:14.316] [New LWP 59547] [01:37:14.318] [01:37:14.318] This GDB supports auto-downloading debuginfo from the following URLs: [01:37:14.318] [01:37:14.318] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:37:14.318] Debuginfod has been disabled. [01:37:14.318] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:37:14.571] [Thread debugging using libthread_db enabled] [01:37:14.571] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:37:14.571] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [01:37:14.571] Program terminated with signal SIGABRT, Aborted. [01:37:14.571] #0 0x00007f85f1aabeec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:15.519] [01:37:15.519] Thread 1 (Thread 0x7f85f1820ac0 (LWP 59547)): [01:37:15.519] #0 0x00007f85f1aabeec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:15.519] No symbol table info available. [01:37:15.519] #1 0x00007f85f1a5cfb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:15.519] No symbol table info available. [01:37:15.519] #2 0x00007f85f1a47472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:15.519] No symbol table info available. [01:37:15.519] #3 0x000055a59a935815 in ExceptionalCondition (conditionName=conditionName@entry=0x55a59ac9dce0 "n >= 0 && n < list->length", fileName=fileName@entry=0x55a59ac9dc40 "../../../../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at assert.c:66 [01:37:15.519] No locals. [01:37:15.519] #4 0x000055a59a3cf3c2 in list_nth_cell (list=, n=) at ../../../../src/include/nodes/pg_list.h:280 [01:37:15.519] No locals. [01:37:15.519] #5 0x000055a59a3cf3f7 in list_nth (list=, n=) at ../../../../src/include/nodes/pg_list.h:302 [01:37:15.519] No locals. [01:37:15.519] #6 0x000055a59a3d5439 in var_is_nonnullable (root=0x62100005b998, var=var@entry=0x625000154d28, use_rel_info=use_rel_info@entry=false) at clauses.c:4235 [01:37:15.519] rte = [01:37:15.519] notnullattnums = 0x0 [01:37:15.519] #7 0x000055a59a3da561 in eval_const_expressions_mutator (node=node@entry=0x625000154ca8, context=context@entry=0x7fffdde3a270) at clauses.c:3556 [01:37:15.519] varg = 0x625000154d28 [01:37:15.519] result = [01:37:15.519] ntest = 0x625000154ca8 [01:37:15.519] newntest = [01:37:15.519] arg = 0x625000154d28 [01:37:15.519] __func__ = "eval_const_expressions_mutator" [01:37:15.519] #8 0x000055a59a3db83b in simplify_and_arguments (args=, context=context@entry=0x7fffdde3a270, haveNull=haveNull@entry=0x7fffdde3a0f0, forceFalse=forceFalse@entry=0x7fffdde3a100) at clauses.c:3964 [01:37:15.519] arg = 0x625000154ca8 [01:37:15.519] newargs = 0x625000154eb8 [01:37:15.519] unprocessed_args = 0x0 [01:37:15.519] #9 0x000055a59a3d7f23 in eval_const_expressions_mutator (node=node@entry=0x625000154ae8, context=context@entry=0x7fffdde3a270) at clauses.c:2877 [01:37:15.519] newargs = [01:37:15.519] haveNull = [01:37:15.519] forceFalse = [01:37:15.519] expr = 0x625000154ae8 [01:37:15.519] __func__ = "eval_const_expressions_mutator" [01:37:15.519] #10 0x000055a59a3db31d in eval_const_expressions (root=root@entry=0x62100005b998, node=node@entry=0x625000154ae8) at clauses.c:2272 [01:37:15.519] context = [01:37:15.519] #11 0x000055a59a3adda7 in convert_EXISTS_sublink_to_join (root=root@entry=0x62100005b998, sublink=sublink@entry=0x6250000091b0, under_not=under_not@entry=false, available_rels=available_rels@entry=0x62100005bec8) at subselect.c:1541 [01:37:15.519] je = [01:37:15.519] lc__state = [01:37:15.519] result = [01:37:15.519] parse = 0x6250000095d0 [01:37:15.519] subselect = 0x61900008c148 [01:37:15.519] whereClause = 0x625000154ae8 [01:37:15.519] subroot = [01:37:15.519] rtoffset = [01:37:15.519] varno = [01:37:15.519] clause_varnos = [01:37:15.519] upper_varnos = [01:37:15.519] lc = [01:37:15.519] newWhere = 0x0 [01:37:15.519] all_clauses = 0x625000154a98 [01:37:15.519] upper_reference_exists = false [01:37:15.519] #12 0x000055a59a3b7843 in pull_up_sublinks_qual_recurse (root=root@entry=0x62100005b998, node=0x6250000091b0, jtlink1=jtlink1@entry=0x62100005be30, available_rels1=, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at prepjointree.c:912 [01:37:15.519] sublink = 0x6250000091b0 [01:37:15.519] j = [01:37:15.519] child_rels = [01:37:15.519] #13 0x000055a59a3b853a in pull_up_sublinks_jointree_recurse (root=root@entry=0x62100005b998, jtnode=0x625000009200, relids=relids@entry=0x7fffdde3a980) at prepjointree.c:776 [01:37:15.519] j = 0x62100005be18 [01:37:15.519] leftrelids = [01:37:15.519] rightrelids = [01:37:15.519] jtlink = [01:37:15.519] __func__ = "pull_up_sublinks_jointree_recurse" [01:37:15.519] #14 0x000055a59a3b86a7 in pull_up_sublinks_jointree_recurse (root=root@entry=0x62100005b998, jtnode=0x6290000d3258, relids=relids@entry=0x7fffdde3aa60) at prepjointree.c:706 [01:37:15.519] newchild = [01:37:15.519] childrelids = [01:37:15.519] l__state = [01:37:15.519] frelids = 0x0 [01:37:15.519] newf = [01:37:15.519] jtlink = [01:37:15.519] f = 0x6290000d3258 [01:37:15.519] newfromlist = 0x0 [01:37:15.519] l = [01:37:15.519] __func__ = "pull_up_sublinks_jointree_recurse" [01:37:15.519] #15 0x000055a59a3bd0d7 in pull_up_sublinks (root=root@entry=0x62100005b998) at prepjointree.c:653 [01:37:15.519] jtnode = [01:37:15.519] relids = [01:37:15.519] #16 0x000055a59a394a5c in subquery_planner (glob=glob@entry=0x61d00005ed28, parse=parse@entry=0x6250000095d0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at planner.c:751 [01:37:15.519] root = 0x62100005b998 [01:37:15.519] newWithCheckOptions = [01:37:15.519] newHaving = [01:37:15.519] hasOuterJoins = [01:37:15.519] hasResultRTEs = [01:37:15.519] final_rel = [01:37:15.519] l = [01:37:15.519] #17 0x000055a59a39760b in standard_planner (parse=parse@entry=0x6250000095d0, query_string=query_string@entry=0x625000007a00 "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 planner.c:436 [01:37:15.519] result = [01:37:15.519] glob = 0x61d00005ed28 [01:37:15.519] tuple_fraction = 0 [01:37:15.519] root = [01:37:15.519] final_rel = [01:37:15.519] best_path = [01:37:15.519] top_plan = [01:37:15.519] lp = [01:37:15.519] lr = [01:37:15.519] #18 0x00007f85ee74a08f in pgss_planner (parse=, query_string=, cursorOptions=, boundParams=) at pg_stat_statements.c:983 [01:37:15.519] _save_exception_stack = 0x7fffdde3b800 [01:37:15.519] _save_context_stack = 0x0 [01:37:15.519] _local_sigjmp_buf = [01:37:15.519] _do_rethrow = false [01:37:15.519] result = 0x41b58ab3 [01:37:15.519] #19 0x000055a59a398cf4 in planner (parse=parse@entry=0x6250000095d0, query_string=query_string@entry=0x625000007a00 "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 planner.c:293 [01:37:15.519] result = [01:37:15.519] #20 0x000055a59a61ac38 in pg_plan_query (querytree=querytree@entry=0x6250000095d0, query_string=query_string@entry=0x625000007a00 "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 postgres.c:900 [01:37:15.519] plan = [01:37:15.519] #21 0x000055a599f95b61 in standard_ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x61900008c0b8, queryString=, params=, queryEnv=) at explain.c:353 [01:37:15.519] plan = [01:37:15.519] planstart = [01:37:15.519] planduration = [01:37:15.519] bufusage_start = [01:37:15.519] bufusage = [01:37:15.519] mem_counters = [01:37:15.519] planner_ctx = 0x0 [01:37:15.519] saved_ctx = 0x0 [01:37:15.519] #22 0x000055a599f95fc8 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x61900008c0b8, pstate=pstate@entry=0x619000005338, params=params@entry=0x0) at explain.c:309 [01:37:15.519] No locals. [01:37:15.519] #23 0x000055a599f96313 in ExplainQuery (pstate=pstate@entry=0x619000005338, stmt=stmt@entry=0x625000009410, params=params@entry=0x0, dest=dest@entry=0x6190000052a8) at explain.c:223 [01:37:15.519] l__state = [01:37:15.519] l = 0x62100005b960 [01:37:15.519] es = 0x61900008c0b8 [01:37:15.519] tstate = [01:37:15.519] jstate = [01:37:15.519] query = [01:37:15.519] rewritten = 0x62100005b948 [01:37:15.519] #24 0x000055a59a62837a in standard_ProcessUtility (pstmt=pstmt@entry=0x6250000094c0, queryString=queryString@entry=0x625000007a00 "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=, qc=) at utility.c:866 [01:37:15.519] parsetree = 0x625000009410 [01:37:15.519] isTopLevel = true [01:37:15.519] isAtomicContext = false [01:37:15.519] pstate = 0x619000005338 [01:37:15.519] readonly_flags = [01:37:15.519] __func__ = "standard_ProcessUtility" [01:37:15.519] #25 0x00007f85ee748790 in pgss_ProcessUtility (pstmt=, queryString=, readOnlyTree=, context=, params=, queryEnv=, dest=, qc=) at pg_stat_statements.c:1181 [01:37:15.519] _save_exception_stack = 0x7fffdde3bc10 [01:37:15.519] _save_context_stack = 0x0 [01:37:15.519] _local_sigjmp_buf = [01:37:15.519] _do_rethrow = false [01:37:15.519] duration = [01:37:15.519] bufusage = [01:37:15.519] walusage_start = [01:37:15.519] start = [01:37:15.519] rows = [01:37:15.519] bufusage_start = [01:37:15.519] walusage = [01:37:15.519] parsetree = [01:37:15.519] saved_queryId = 2174664879250974619 [01:37:15.519] saved_stmt_location = 0 [01:37:15.519] saved_stmt_len = 204 [01:37:15.519] enabled = true [01:37:15.519] #26 0x000055a59a6289a4 in ProcessUtility (pstmt=pstmt@entry=0x6250000094c0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x6190000052a8, qc=0x7fffdde3baf0) at utility.c:519 [01:37:15.519] No locals. [01:37:15.519] #27 0x000055a59a6239ab in PortalRunUtility (portal=portal@entry=0x625000032200, pstmt=0x6250000094c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x6190000052a8, qc=qc@entry=0x7fffdde3baf0) at pquery.c:1153 [01:37:15.519] No locals. [01:37:15.519] #28 0x000055a59a6243e7 in FillPortalStore (portal=portal@entry=0x625000032200, isTopLevel=isTopLevel@entry=true) at pquery.c:1026 [01:37:15.519] treceiver = 0x6190000052a8 [01:37:15.519] qc = [01:37:15.519] __func__ = "FillPortalStore" [01:37:15.519] #29 0x000055a59a624d2c in PortalRun (portal=portal@entry=0x625000032200, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x6290000d43d8, altdest=altdest@entry=0x6290000d43d8, qc=qc@entry=0x7fffdde3bde0) at pquery.c:760 [01:37:15.519] _save_exception_stack = 0x7fffdde3bf60 [01:37:15.519] _save_context_stack = 0x0 [01:37:15.519] _local_sigjmp_buf = [01:37:15.519] _do_rethrow = [01:37:15.519] result = [01:37:15.519] nprocessed = [01:37:15.519] saveTopTransactionResourceOwner = 0x62900002a248 [01:37:15.519] saveTopTransactionContext = 0x625000039900 [01:37:15.519] saveActivePortal = 0x0 [01:37:15.519] saveResourceOwner = 0x62900002a248 [01:37:15.519] savePortalContext = 0x0 [01:37:15.519] saveMemoryContext = 0x625000039900 [01:37:15.519] __func__ = "PortalRun" [01:37:15.519] #30 0x000055a59a61bab8 in exec_simple_query (query_string=query_string@entry=0x625000007a00 "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 postgres.c:1274 [01:37:15.519] cmdtaglen = [01:37:15.519] snapshot_set = [01:37:15.519] per_parsetree_context = 0x0 [01:37:15.519] plantree_list = 0x6290000d4388 [01:37:15.519] parsetree = 0x625000009440 [01:37:15.519] commandTag = [01:37:15.519] qc = [01:37:15.519] querytree_list = [01:37:15.519] portal = 0x625000032200 [01:37:15.519] receiver = 0x6290000d43d8 [01:37:15.519] format = [01:37:15.519] cmdtagname = [01:37:15.519] parsetree_item__state = [01:37:15.519] dest = DestRemote [01:37:15.519] oldcontext = 0x625000039900 [01:37:15.519] parsetree_list = 0x625000009470 [01:37:15.519] parsetree_item = 0x625000009488 [01:37:15.519] save_log_statement_stats = false [01:37:15.519] was_logged = true [01:37:15.520] use_implicit_block = false [01:37:15.520] msec_str = [01:37:15.520] __func__ = "exec_simple_query" [01:37:15.520] #31 0x000055a59a61fd82 in PostgresMain (dbname=dbname@entry=0x6290000254b8 "regression", username=username@entry=0x629000025498 "postgres") at postgres.c:4767 [01:37:15.520] query_string = 0x625000007a00 "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"... [01:37:15.520] firstchar = [01:37:15.520] input_message = [01:37:15.520] local_sigjmp_buf = [01:37:15.520] send_ready_for_query = [01:37:15.520] idle_in_transaction_timeout_enabled = [01:37:15.520] idle_session_timeout_enabled = [01:37:15.520] __func__ = "PostgresMain" [01:37:15.520] #32 0x000055a59a61199b in BackendMain (startup_data=, startup_data_len=) at backend_startup.c:124 [01:37:15.520] bsdata = [01:37:15.520] #33 0x000055a59a45248f in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x7fffdde3c140, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fffdde3c1f0) at launch_backend.c:290 [01:37:15.520] pid = [01:37:15.520] #34 0x000055a59a4584ad in BackendStartup (client_sock=client_sock@entry=0x7fffdde3c1f0) at postmaster.c:3587 [01:37:15.520] bn = 0x6290000193e8 [01:37:15.520] pid = [01:37:15.520] startup_data = [01:37:15.520] cac = [01:37:15.520] __func__ = "BackendStartup" [01:37:15.520] #35 0x000055a59a45b538 in ServerLoop () at postmaster.c:1702 [01:37:15.520] s = [01:37:15.520] i = 0 [01:37:15.520] now = [01:37:15.520] last_lockfile_recheck_time = 1755221552 [01:37:15.520] last_touch_time = 1755221492 [01:37:15.520] events = [01:37:15.520] nevents = 1 [01:37:15.520] __func__ = "ServerLoop" [01:37:15.520] #36 0x000055a59a45d682 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x604000000690) at postmaster.c:1400 [01:37:15.520] opt = [01:37:15.520] status = [01:37:15.520] userDoption = [01:37:15.520] listen_addr_saved = false [01:37:15.520] output_config_variable = [01:37:15.520] __func__ = "PostmasterMain" [01:37:15.520] #37 0x000055a59a1ece56 in main (argc=4, argv=0x604000000690) at main.c:231 [01:37:15.520] do_check_root = [01:37:15.520] dispatch_option = [01:37:15.560] -e [01:37:15.560] [01:37:15.560] [01:37:15.647] dumping /tmp/cores/postgres-6-32318.core for /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/postgres [01:37:15.917] [New LWP 32318] [01:37:15.919] [01:37:15.919] This GDB supports auto-downloading debuginfo from the following URLs: [01:37:15.919] [01:37:15.919] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:37:15.919] Debuginfod has been disabled. [01:37:15.919] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:37:16.175] [Thread debugging using libthread_db enabled] [01:37:16.175] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:37:16.175] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [01:37:16.175] Program terminated with signal SIGABRT, Aborted. [01:37:16.175] #0 0x00007f93868abeec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:16.242] [01:37:16.242] Thread 1 (Thread 0x7f9386223ac0 (LWP 32318)): [01:37:16.242] #0 0x00007f93868abeec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:16.242] No symbol table info available. [01:37:16.242] #1 0x00007f938685cfb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:16.242] No symbol table info available. [01:37:16.242] #2 0x00007f9386847472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:37:16.242] No symbol table info available. [01:37:16.242] #3 0x000055c8aaa1e815 in ExceptionalCondition (conditionName=conditionName@entry=0x55c8aad86ce0 "n >= 0 && n < list->length", fileName=fileName@entry=0x55c8aad86c40 "../../../../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at assert.c:66 [01:37:16.242] No locals. [01:37:16.242] #4 0x000055c8aa4b83c2 in list_nth_cell (list=, n=) at ../../../../src/include/nodes/pg_list.h:280 [01:37:16.242] No locals. [01:37:16.242] #5 0x000055c8aa4b83f7 in list_nth (list=, n=) at ../../../../src/include/nodes/pg_list.h:302 [01:37:16.242] No locals. [01:37:16.242] #6 0x000055c8aa4be439 in var_is_nonnullable (root=0x62100005b538, var=var@entry=0x6250001520d8, use_rel_info=use_rel_info@entry=false) at clauses.c:4235 [01:37:16.242] rte = [01:37:16.242] notnullattnums = 0x0 [01:37:16.242] #7 0x000055c8aa4c3561 in eval_const_expressions_mutator (node=node@entry=0x625000152058, context=context@entry=0x7fff8ff06d40) at clauses.c:3556 [01:37:16.242] varg = 0x6250001520d8 [01:37:16.242] result = [01:37:16.242] ntest = 0x625000152058 [01:37:16.242] newntest = [01:37:16.242] arg = 0x6250001520d8 [01:37:16.242] __func__ = "eval_const_expressions_mutator" [01:37:16.242] #8 0x000055c8aa4c483b in simplify_and_arguments (args=, context=context@entry=0x7fff8ff06d40, haveNull=haveNull@entry=0x7fff8ff06bc0, forceFalse=forceFalse@entry=0x7fff8ff06bd0) at clauses.c:3964 [01:37:16.242] arg = 0x625000152058 [01:37:16.242] newargs = 0x625000152268 [01:37:16.242] unprocessed_args = 0x0 [01:37:16.242] #9 0x000055c8aa4c0f23 in eval_const_expressions_mutator (node=node@entry=0x625000151e98, context=context@entry=0x7fff8ff06d40) at clauses.c:2877 [01:37:16.242] newargs = [01:37:16.242] haveNull = [01:37:16.242] forceFalse = [01:37:16.242] expr = 0x625000151e98 [01:37:16.242] __func__ = "eval_const_expressions_mutator" [01:37:16.242] #10 0x000055c8aa4c431d in eval_const_expressions (root=root@entry=0x62100005b538, node=node@entry=0x625000151e98) at clauses.c:2272 [01:37:16.242] context = [01:37:16.242] #11 0x000055c8aa496da7 in convert_EXISTS_sublink_to_join (root=root@entry=0x62100005b538, sublink=sublink@entry=0x6250000091b0, under_not=under_not@entry=false, available_rels=available_rels@entry=0x62100005ba68) at subselect.c:1541 [01:37:16.242] je = [01:37:16.242] lc__state = [01:37:16.242] result = [01:37:16.242] parse = 0x6250000095d0 [01:37:16.242] subselect = 0x61d00005f568 [01:37:16.242] whereClause = 0x625000151e98 [01:37:16.242] subroot = [01:37:16.242] rtoffset = [01:37:16.242] varno = [01:37:16.242] clause_varnos = [01:37:16.242] upper_varnos = [01:37:16.242] lc = [01:37:16.242] newWhere = 0x0 [01:37:16.242] all_clauses = 0x625000151e48 [01:37:16.242] upper_reference_exists = false [01:37:16.242] #12 0x000055c8aa4a0843 in pull_up_sublinks_qual_recurse (root=root@entry=0x62100005b538, node=0x6250000091b0, jtlink1=jtlink1@entry=0x62100005b9d0, available_rels1=, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at prepjointree.c:912 [01:37:16.242] sublink = 0x6250000091b0 [01:37:16.242] j = [01:37:16.242] child_rels = [01:37:16.242] #13 0x000055c8aa4a153a in pull_up_sublinks_jointree_recurse (root=root@entry=0x62100005b538, jtnode=0x625000009200, relids=relids@entry=0x7fff8ff07450) at prepjointree.c:776 [01:37:16.242] j = 0x62100005b9b8 [01:37:16.242] leftrelids = [01:37:16.242] rightrelids = [01:37:16.242] jtlink = [01:37:16.242] __func__ = "pull_up_sublinks_jointree_recurse" [01:37:16.242] #14 0x000055c8aa4a16a7 in pull_up_sublinks_jointree_recurse (root=root@entry=0x62100005b538, jtnode=0x6290000d3258, relids=relids@entry=0x7fff8ff07530) at prepjointree.c:706 [01:37:16.242] newchild = [01:37:16.242] childrelids = [01:37:16.242] l__state = [01:37:16.242] frelids = 0x0 [01:37:16.242] newf = [01:37:16.242] jtlink = [01:37:16.242] f = 0x6290000d3258 [01:37:16.242] newfromlist = 0x0 [01:37:16.242] l = [01:37:16.242] __func__ = "pull_up_sublinks_jointree_recurse" [01:37:16.242] #15 0x000055c8aa4a60d7 in pull_up_sublinks (root=root@entry=0x62100005b538) at prepjointree.c:653 [01:37:16.242] jtnode = [01:37:16.242] relids = [01:37:16.242] #16 0x000055c8aa47da5c in subquery_planner (glob=glob@entry=0x61900008c858, parse=parse@entry=0x6250000095d0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at planner.c:751 [01:37:16.242] root = 0x62100005b538 [01:37:16.242] newWithCheckOptions = [01:37:16.242] newHaving = [01:37:16.242] hasOuterJoins = [01:37:16.242] hasResultRTEs = [01:37:16.242] final_rel = [01:37:16.242] l = [01:37:16.242] #17 0x000055c8aa48060b in standard_planner (parse=0x6250000095d0, query_string=, cursorOptions=2048, boundParams=) at planner.c:436 [01:37:16.242] result = [01:37:16.242] glob = 0x61900008c858 [01:37:16.242] tuple_fraction = 0 [01:37:16.242] root = [01:37:16.242] final_rel = [01:37:16.242] best_path = [01:37:16.242] top_plan = [01:37:16.242] lp = [01:37:16.242] lr = [01:37:16.242] #18 0x000055c8aa481d23 in planner (parse=parse@entry=0x6250000095d0, query_string=query_string@entry=0x625000007a00 "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 planner.c:295 [01:37:16.242] result = [01:37:16.242] #19 0x000055c8aa703c38 in pg_plan_query (querytree=querytree@entry=0x6250000095d0, query_string=query_string@entry=0x625000007a00 "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 postgres.c:900 [01:37:16.242] plan = [01:37:16.242] #20 0x000055c8aa07eb61 in standard_ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x61900008c5b8, queryString=, params=, queryEnv=) at explain.c:353 [01:37:16.242] plan = [01:37:16.242] planstart = [01:37:16.242] planduration = [01:37:16.242] bufusage_start = [01:37:16.242] bufusage = [01:37:16.242] mem_counters = [01:37:16.242] planner_ctx = 0x0 [01:37:16.242] saved_ctx = 0x0 [01:37:16.242] #21 0x000055c8aa07efc8 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x61900008c5b8, pstate=pstate@entry=0x619000005838, params=params@entry=0x0) at explain.c:309 [01:37:16.242] No locals. [01:37:16.242] #22 0x000055c8aa07f313 in ExplainQuery (pstate=pstate@entry=0x619000005838, stmt=stmt@entry=0x625000009410, params=params@entry=0x0, dest=dest@entry=0x6190000057a8) at explain.c:223 [01:37:16.242] l__state = [01:37:16.242] l = 0x61d00005f530 [01:37:16.242] es = 0x61900008c5b8 [01:37:16.242] tstate = [01:37:16.242] jstate = [01:37:16.242] query = [01:37:16.242] rewritten = 0x61d00005f518 [01:37:16.242] #23 0x000055c8aa71137a in standard_ProcessUtility (pstmt=0x6250000094c0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=, qc=) at utility.c:866 [01:37:16.242] parsetree = 0x625000009410 [01:37:16.242] isTopLevel = true [01:37:16.242] isAtomicContext = false [01:37:16.242] pstate = 0x619000005838 [01:37:16.242] readonly_flags = [01:37:16.242] __func__ = "standard_ProcessUtility" [01:37:16.242] #24 0x000055c8aa711a43 in ProcessUtility (pstmt=pstmt@entry=0x6250000094c0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x6190000057a8, qc=0x7fff8ff07c20) at utility.c:523 [01:37:16.242] No locals. [01:37:16.242] #25 0x000055c8aa70c9ab in PortalRunUtility (portal=portal@entry=0x625000032200, pstmt=0x6250000094c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x6190000057a8, qc=qc@entry=0x7fff8ff07c20) at pquery.c:1153 [01:37:16.242] No locals. [01:37:16.242] #26 0x000055c8aa70d3e7 in FillPortalStore (portal=portal@entry=0x625000032200, isTopLevel=isTopLevel@entry=true) at pquery.c:1026 [01:37:16.242] treceiver = 0x6190000057a8 [01:37:16.242] qc = [01:37:16.242] __func__ = "FillPortalStore" [01:37:16.242] #27 0x000055c8aa70dd2c in PortalRun (portal=portal@entry=0x625000032200, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x6290000d3538, altdest=altdest@entry=0x6290000d3538, qc=qc@entry=0x7fff8ff07f10) at pquery.c:760 [01:37:16.242] _save_exception_stack = 0x7fff8ff08090 [01:37:16.242] _save_context_stack = 0x0 [01:37:16.242] _local_sigjmp_buf = [01:37:16.242] _do_rethrow = [01:37:16.242] result = [01:37:16.242] nprocessed = [01:37:16.242] saveTopTransactionResourceOwner = 0x629000025a58 [01:37:16.242] saveTopTransactionContext = 0x625000039900 [01:37:16.242] saveActivePortal = 0x0 [01:37:16.242] saveResourceOwner = 0x629000025a58 [01:37:16.242] savePortalContext = 0x0 [01:37:16.242] saveMemoryContext = 0x625000039900 [01:37:16.242] __func__ = "PortalRun" [01:37:16.242] #28 0x000055c8aa704ab8 in exec_simple_query (query_string=query_string@entry=0x625000007a00 "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 postgres.c:1274 [01:37:16.242] cmdtaglen = [01:37:16.242] snapshot_set = [01:37:16.242] per_parsetree_context = 0x0 [01:37:16.242] plantree_list = 0x6290000d34e8 [01:37:16.242] parsetree = 0x625000009440 [01:37:16.242] commandTag = [01:37:16.242] qc = [01:37:16.242] querytree_list = [01:37:16.242] portal = 0x625000032200 [01:37:16.242] receiver = 0x6290000d3538 [01:37:16.242] format = [01:37:16.242] cmdtagname = [01:37:16.242] parsetree_item__state = [01:37:16.242] dest = DestRemote [01:37:16.242] oldcontext = 0x625000039900 [01:37:16.242] parsetree_list = 0x625000009470 [01:37:16.242] parsetree_item = 0x625000009488 [01:37:16.242] save_log_statement_stats = false [01:37:16.242] was_logged = false [01:37:16.242] use_implicit_block = false [01:37:16.242] msec_str = [01:37:16.242] __func__ = "exec_simple_query" [01:37:16.242] #29 0x000055c8aa708d82 in PostgresMain (dbname=dbname@entry=0x6290000203a8 "regression", username=username@entry=0x629000020388 "postgres") at postgres.c:4767 [01:37:16.242] query_string = 0x625000007a00 "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"... [01:37:16.242] firstchar = [01:37:16.242] input_message = [01:37:16.242] local_sigjmp_buf = [01:37:16.242] send_ready_for_query = [01:37:16.242] idle_in_transaction_timeout_enabled = [01:37:16.242] idle_session_timeout_enabled = [01:37:16.242] __func__ = "PostgresMain" [01:37:16.242] #30 0x000055c8aa6fa99b in BackendMain (startup_data=, startup_data_len=) at backend_startup.c:124 [01:37:16.242] bsdata = [01:37:16.242] #31 0x000055c8aa53b48f in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x7fff8ff08270, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fff8ff08320) at launch_backend.c:290 [01:37:16.242] pid = [01:37:16.242] #32 0x000055c8aa5414ad in BackendStartup (client_sock=client_sock@entry=0x7fff8ff08320) at postmaster.c:3587 [01:37:16.242] bn = 0x627000000378 [01:37:16.242] pid = [01:37:16.242] startup_data = [01:37:16.242] cac = [01:37:16.242] __func__ = "BackendStartup" [01:37:16.242] #33 0x000055c8aa544538 in ServerLoop () at postmaster.c:1702 [01:37:16.242] s = [01:37:16.242] i = 0 [01:37:16.242] now = [01:37:16.242] last_lockfile_recheck_time = 1755221295 [01:37:16.242] last_touch_time = 1755221175 [01:37:16.242] events = [01:37:16.242] nevents = 1 [01:37:16.242] __func__ = "ServerLoop" [01:37:16.242] #34 0x000055c8aa546682 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x607000000480) at postmaster.c:1400 [01:37:16.242] opt = [01:37:16.242] status = [01:37:16.242] userDoption = [01:37:16.242] listen_addr_saved = false [01:37:16.242] output_config_variable = [01:37:16.242] __func__ = "PostmasterMain" [01:37:16.242] #35 0x000055c8aa2d5e56 in main (argc=8, argv=0x607000000480) at main.c:231 [01:37:16.242] do_check_root = [01:37:16.242] dispatch_option =