[22:48:30.391] src/tools/ci/cores_backtrace.sh linux /tmp/cores [22:48:30.611] dumping /tmp/cores/postgres-6-42972.core for /tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/postgres [22:48:30.865] [New LWP 42972] [22:48:30.867] [22:48:30.867] This GDB supports auto-downloading debuginfo from the following URLs: [22:48:30.867] [22:48:30.867] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [22:48:30.867] Debuginfod has been disabled. [22:48:30.867] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [22:48:30.982] [Thread debugging using libthread_db enabled] [22:48:30.982] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [22:48:30.982] Core was generated by `postgres: postgres contrib_regression [local] EXPLAIN '. [22:48:30.982] Program terminated with signal SIGABRT, Aborted. [22:48:30.982] #0 0x00007fb0b86abebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:48:31.056] [22:48:31.056] Thread 1 (Thread 0x7fb0b8432240 (LWP 42972)): [22:48:31.056] #0 0x00007fb0b86abebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [22:48:31.056] No symbol table info available. [22:48:31.056] #1 0x00007fb0b865cfb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [22:48:31.056] No symbol table info available. [22:48:31.056] #2 0x00007fb0b8647472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [22:48:31.056] No symbol table info available. [22:48:31.056] #3 0x0000564fb02817ce in ExceptionalCondition (conditionName=conditionName@entry=0x564fb056ae00 "plan->workmem == 0", fileName=fileName@entry=0x564fb056ad80 "execWorkmem.c", lineNumber=lineNumber@entry=188) at assert.c:66 [22:48:31.056] No locals. [22:48:31.056] #4 0x0000564fafa70f20 in assign_workmem_plan (plan=0x62500098ad88) at execWorkmem.c:188 [22:48:31.056] No locals. [22:48:31.056] #5 0x0000564fafa70d90 in assign_workmem_plan (plan=0x62500098fea0) at execWorkmem.c:198 [22:48:31.056] No locals. [22:48:31.056] #6 0x0000564fafa70d90 in assign_workmem_plan (plan=0x6250009900c0) at execWorkmem.c:198 [22:48:31.056] No locals. [22:48:31.056] #7 0x0000564fafa70db6 in assign_workmem_plan (plan=0x6250009901b0) at execWorkmem.c:201 [22:48:31.056] No locals. [22:48:31.056] #8 0x0000564fafa70d90 in assign_workmem_plan (plan=0x625000990850) at execWorkmem.c:198 [22:48:31.056] No locals. [22:48:31.056] #9 0x0000564fafa714e2 in standard_ExecAssignWorkMem (plannedstmt=0x625000992ac8) at execWorkmem.c:121 [22:48:31.056] No locals. [22:48:31.056] #10 0x0000564fafa7153d in ExecAssignWorkMem (plannedstmt=plannedstmt@entry=0x625000992ac8) at execWorkmem.c:106 [22:48:31.056] No locals. [22:48:31.056] #11 0x0000564fafa43c3a in InitPlan (queryDesc=queryDesc@entry=0x625000998d08, eflags=eflags@entry=33) at execMain.c:1057 [22:48:31.056] operation = CMD_SELECT [22:48:31.056] plannedstmt = 0x625000992ac8 [22:48:31.056] cachedplan = [22:48:31.056] plan = 0x625000990850 [22:48:31.056] rangeTable = [22:48:31.056] estate = 0x625000606a00 [22:48:31.056] planstate = [22:48:31.056] tupType = [22:48:31.056] l = [22:48:31.056] i = [22:48:31.056] __func__ = "InitPlan" [22:48:31.056] #12 0x0000564fafa44474 in standard_ExecutorStart (queryDesc=queryDesc@entry=0x625000998d08, eflags=33, eflags@entry=1) at execMain.c:268 [22:48:31.056] estate = 0x625000606a00 [22:48:31.056] oldcontext = 0x6190000ebf80 [22:48:31.056] __func__ = "standard_ExecutorStart" [22:48:31.056] #13 0x0000564fafa4484c in ExecutorStart (queryDesc=queryDesc@entry=0x625000998d08, eflags=eflags@entry=1) at execMain.c:142 [22:48:31.056] plan_valid = [22:48:31.056] #14 0x0000564faf90411a in ExplainOnePlan (plannedstmt=plannedstmt@entry=0x625000992ac8, cplan=cplan@entry=0x0, plansource=plansource@entry=0x0, query_index=query_index@entry=-1, into=into@entry=0x0, es=es@entry=0x6190000f64b8, queryString=, params=, queryEnv=, planduration=, bufusage=, mem_counters=) at explain.c:729 [22:48:31.056] dest = 0x564fb092f240 [22:48:31.056] queryDesc = 0x625000998d08 [22:48:31.056] starttime = [22:48:31.056] totaltime = 0 [22:48:31.056] eflags = 1 [22:48:31.056] instrument_option = [22:48:31.056] serializeMetrics = [22:48:31.056] __func__ = "ExplainOnePlan" [22:48:31.056] #15 0x0000564faf9047db in standard_ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x6190000f64b8, queryString=0x625000007a00 "EXPLAIN (VERBOSE, COSTS OFF)\nSELECT * FROM local_tbl LEFT JOIN (SELECT ft1.*, COALESCE(ft1.c3 || ft2.c3, 'foobar') FROM ft1 INNER JOIN ft2 ON (ft1.c1 = ft2.c1 AND ft1.c1 < 100)) ss ON (local_tbl.c1 = "..., params=, queryEnv=) at explain.c:526 [22:48:31.056] plan = 0x625000992ac8 [22:48:31.056] planstart = {ticks = 445574634201} [22:48:31.056] planduration = [22:48:31.056] bufusage_start = [22:48:31.056] bufusage = [22:48:31.056] mem_counters = [22:48:31.056] planner_ctx = 0x0 [22:48:31.056] saved_ctx = 0x0 [22:48:31.056] #16 0x0000564faf904af6 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x6190000f64b8, pstate=pstate@entry=0x6190000ec238, params=params@entry=0x0) at explain.c:463 [22:48:31.056] No locals. [22:48:31.056] #17 0x0000564faf905b4b in ExplainQuery (pstate=pstate@entry=0x6190000ec238, stmt=stmt@entry=0x625000965550, params=params@entry=0x0, dest=dest@entry=0x6190000ec1a8) at explain.c:361 [22:48:31.056] l__state = [22:48:31.056] l = 0x61d000257130 [22:48:31.056] es = 0x6190000f64b8 [22:48:31.056] tstate = [22:48:31.056] jstate = [22:48:31.056] query = [22:48:31.056] rewritten = 0x61d000257118 [22:48:31.056] lc = [22:48:31.056] timing_set = false [22:48:31.056] buffers_set = [22:48:31.056] summary_set = false [22:48:31.056] __func__ = "ExplainQuery" [22:48:31.056] #18 0x0000564faff6fbe0 in standard_ProcessUtility (pstmt=0x625000965600, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=, qc=) at utility.c:866 [22:48:31.056] parsetree = 0x625000965550 [22:48:31.056] isTopLevel = true [22:48:31.056] isAtomicContext = false [22:48:31.056] pstate = 0x6190000ec238 [22:48:31.056] readonly_flags = [22:48:31.056] __func__ = "standard_ProcessUtility" [22:48:31.056] #19 0x0000564faff7033c in ProcessUtility (pstmt=pstmt@entry=0x625000965600, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x6190000ec1a8, qc=0x7ffe2e6f3310) at utility.c:523 [22:48:31.056] No locals. [22:48:31.056] #20 0x0000564faff6b12a in PortalRunUtility (portal=portal@entry=0x62500002fa00, pstmt=0x625000965600, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x6190000ec1a8, qc=qc@entry=0x7ffe2e6f3310) at pquery.c:1184 [22:48:31.056] No locals. [22:48:31.056] #21 0x0000564faff6bc2c in FillPortalStore (portal=portal@entry=0x62500002fa00, isTopLevel=isTopLevel@entry=true) at pquery.c:1057 [22:48:31.056] treceiver = 0x6190000ec1a8 [22:48:31.056] qc = [22:48:31.056] __func__ = "FillPortalStore" [22:48:31.056] #22 0x0000564faff6c586 in PortalRun (portal=portal@entry=0x62500002fa00, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x62d0002d1158, altdest=altdest@entry=0x62d0002d1158, qc=qc@entry=0x7ffe2e6f3600) at pquery.c:791 [22:48:31.056] _save_exception_stack = 0x7ffe2e6f3780 [22:48:31.056] _save_context_stack = 0x0 [22:48:31.056] _local_sigjmp_buf = [22:48:31.056] _do_rethrow = [22:48:31.056] result = [22:48:31.056] nprocessed = [22:48:31.056] saveTopTransactionResourceOwner = 0x629000020a58 [22:48:31.056] saveTopTransactionContext = 0x625000037100 [22:48:31.056] saveActivePortal = 0x0 [22:48:31.056] saveResourceOwner = 0x629000020a58 [22:48:31.056] savePortalContext = 0x0 [22:48:31.056] saveMemoryContext = 0x625000037100 [22:48:31.056] __func__ = "PortalRun" [22:48:31.056] #23 0x0000564faff63552 in exec_simple_query (query_string=query_string@entry=0x625000007a00 "EXPLAIN (VERBOSE, COSTS OFF)\nSELECT * FROM local_tbl LEFT JOIN (SELECT ft1.*, COALESCE(ft1.c3 || ft2.c3, 'foobar') FROM ft1 INNER JOIN ft2 ON (ft1.c1 = ft2.c1 AND ft1.c1 < 100)) ss ON (local_tbl.c1 = "...) at postgres.c:1272 [22:48:31.056] cmdtaglen = [22:48:31.056] snapshot_set = [22:48:31.056] per_parsetree_context = 0x0 [22:48:31.056] plantree_list = 0x62d0002d1108 [22:48:31.056] parsetree = 0x625000965580 [22:48:31.056] commandTag = [22:48:31.056] qc = [22:48:31.056] querytree_list = [22:48:31.056] portal = 0x62500002fa00 [22:48:31.056] receiver = 0x62d0002d1158 [22:48:31.056] format = [22:48:31.056] cmdtagname = [22:48:31.056] parsetree_item__state = [22:48:31.056] dest = DestRemote [22:48:31.056] oldcontext = 0x625000037100 [22:48:31.056] parsetree_list = 0x6250009655b0 [22:48:31.056] parsetree_item = 0x6250009655c8 [22:48:31.056] save_log_statement_stats = false [22:48:31.056] was_logged = false [22:48:31.056] use_implicit_block = false [22:48:31.056] msec_str = [22:48:31.056] __func__ = "exec_simple_query" [22:48:31.056] #24 0x0000564faff67368 in PostgresMain (dbname=dbname@entry=0x62900001b3a8 "contrib_regression", username=username@entry=0x62900001b388 "postgres") at postgres.c:4693 [22:48:31.056] query_string = 0x625000007a00 "EXPLAIN (VERBOSE, COSTS OFF)\nSELECT * FROM local_tbl LEFT JOIN (SELECT ft1.*, COALESCE(ft1.c3 || ft2.c3, 'foobar') FROM ft1 INNER JOIN ft2 ON (ft1.c1 = ft2.c1 AND ft1.c1 < 100)) ss ON (local_tbl.c1 = "... [22:48:31.056] firstchar = [22:48:31.056] input_message = [22:48:31.056] local_sigjmp_buf = [22:48:31.056] send_ready_for_query = [22:48:31.057] idle_in_transaction_timeout_enabled = [22:48:31.057] idle_session_timeout_enabled = [22:48:31.057] __func__ = "PostgresMain" [22:48:31.057] #25 0x0000564faff59842 in BackendMain (startup_data=startup_data@entry=0x7ffe2e6f3950, startup_data_len=startup_data_len@entry=4) at backend_startup.c:107 [22:48:31.057] bsdata = 0x7ffe2e6f3950 [22:48:31.057] #26 0x0000564fafdb5387 in postmaster_child_launch (child_type=, child_slot=4, startup_data=startup_data@entry=0x7ffe2e6f3950, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe2e6f39e0) at launch_backend.c:274 [22:48:31.057] pid = [22:48:31.057] #27 0x0000564fafdbb1e8 in BackendStartup (client_sock=client_sock@entry=0x7ffe2e6f39e0) at postmaster.c:3519 [22:48:31.057] bn = 0x6270000001c8 [22:48:31.057] pid = [22:48:31.057] startup_data = [22:48:31.057] cac = [22:48:31.057] __func__ = "BackendStartup" [22:48:31.057] #28 0x0000564fafdbde74 in ServerLoop () at postmaster.c:1688 [22:48:31.057] s = [22:48:31.057] i = 0 [22:48:31.057] now = [22:48:31.057] last_lockfile_recheck_time = 1740436872 [22:48:31.057] last_touch_time = 1740436872 [22:48:31.057] events = [22:48:31.057] nevents = 1 [22:48:31.057] __func__ = "ServerLoop" [22:48:31.057] #29 0x0000564fafdbffb9 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x6070000003a0) at postmaster.c:1386 [22:48:31.057] opt = [22:48:31.057] status = [22:48:31.057] userDoption = [22:48:31.057] listen_addr_saved = false [22:48:31.057] output_config_variable = [22:48:31.057] __func__ = "PostmasterMain" [22:48:31.057] #30 0x0000564fafb51207 in main (argc=8, argv=0x6070000003a0) at main.c:230 [22:48:31.057] do_check_root = [22:48:31.057] dispatch_option =