[21:43:59.995] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores
[21:44:00.323] dumping /tmp/cores/postgres.22107.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
[21:44:00.474] [New LWP 101915]
[21:44:00.595] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN'.
[21:44:00.595] Program terminated with signal SIGABRT, Aborted.
[21:44:00.595] Sent by thr_kill() from pid 22107 and user 1003.
[21:44:00.595] #0  0x000000082ceb041a in thr_kill () from /lib/libc.so.7
[21:44:00.658] 
[21:44:00.658] Thread 1 (LWP 101915):
[21:44:00.658] #0  0x000000082ceb041a in thr_kill () from /lib/libc.so.7
[21:44:00.658] No symbol table info available.
[21:44:00.658] #1  0x000000082ce29e64 in raise () from /lib/libc.so.7
[21:44:00.658] No symbol table info available.
[21:44:00.658] #2  0x000000082ceda6f9 in abort () from /lib/libc.so.7
[21:44:00.658] No symbol table info available.
[21:44:00.658] #3  0x0000000000ab1f15 in ExceptionalCondition (conditionName=0x30acbb "plan->workmem == 0", fileName=<optimized out>, lineNumber=lineNumber@entry=184) at ../src/backend/utils/error/assert.c:66
[21:44:00.658] No locals.
[21:44:00.658] #4  0x0000000000782df5 in assign_workmem_plan (plan=0x8363996d8) at ../src/backend/executor/execWorkmem.c:184
[21:44:00.658] No locals.
[21:44:00.658] #5  0x0000000000782c3e in assign_workmem_plan (plan=0x836394bf8) at ../src/backend/executor/execWorkmem.c:194
[21:44:00.658] No locals.
[21:44:00.658] #6  0x0000000000782c3e in assign_workmem_plan (plan=0x8363943a8) at ../src/backend/executor/execWorkmem.c:194
[21:44:00.658] No locals.
[21:44:00.658] #7  0x0000000000782c4c in assign_workmem_plan (plan=0x8363931b8) at ../src/backend/executor/execWorkmem.c:197
[21:44:00.658] No locals.
[21:44:00.658] #8  0x0000000000782c3e in assign_workmem_plan (plan=0x8363924b0) at ../src/backend/executor/execWorkmem.c:194
[21:44:00.658] No locals.
[21:44:00.658] #9  0x00000000007702f6 in InitPlan (queryDesc=0x8363cd9d8, eflags=33) at ../src/backend/executor/execMain.c:1057
[21:44:00.658]         operation = CMD_SELECT
[21:44:00.658]         plannedstmt = 0x8363923a0
[21:44:00.658]         cachedplan = <optimized out>
[21:44:00.658]         plan = 0x8363924b0
[21:44:00.658]         rangeTable = <optimized out>
[21:44:00.658]         estate = 0x836403100
[21:44:00.658]         l = <optimized out>
[21:44:00.658]         i = <optimized out>
[21:44:00.658]         planstate = <optimized out>
[21:44:00.658]         tupType = <optimized out>
[21:44:00.658]         l__state = <optimized out>
[21:44:00.658]         rc = <optimized out>
[21:44:00.658]         relid = <optimized out>
[21:44:00.658]         erm = <optimized out>
[21:44:00.658]         relation = <optimized out>
[21:44:00.658]         __error = <optimized out>
[21:44:00.658]         l__state = <optimized out>
[21:44:00.658]         subplan = <optimized out>
[21:44:00.658]         sp_eflags = <optimized out>
[21:44:00.658]         subplanstate = <optimized out>
[21:44:00.658]         junk_filter_needed = <optimized out>
[21:44:00.658]         tlist = <optimized out>
[21:44:00.658]         tlist__state = <optimized out>
[21:44:00.658]         tle = <optimized out>
[21:44:00.658]         slot = <optimized out>
[21:44:00.658]         j = <optimized out>
[21:44:00.658] #10 standard_ExecutorStart (queryDesc=0x8363cd9d8, eflags=33) at ../src/backend/executor/execMain.c:268
[21:44:00.658]         estate = <optimized out>
[21:44:00.658]         oldcontext = 0x834e1b400
[21:44:00.658] #11 0x00000000006e6888 in ExplainOnePlan (plannedstmt=plannedstmt@entry=0x8363923a0, cplan=cplan@entry=0x0, plansource=plansource@entry=0x0, query_index=query_index@entry=-1, into=into@entry=0x0, es=es@entry=0x834e1bc38, queryString=0x834df4100 "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=0x0, queryEnv=0x0, planduration=0x8214e8728, bufusage=0x0, mem_counters=0x0) at ../src/backend/commands/explain.c:732
[21:44:00.658]         serializeMetrics = {bytesSent = 0, timeSpent = {ticks = 0}, bufferUsage = {shared_blks_hit = 0, shared_blks_read = 0, shared_blks_dirtied = 0, shared_blks_written = 0, 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}}}
[21:44:00.658]         totaltime = 0
[21:44:00.658]         instrument_option = <optimized out>
[21:44:00.658]         starttime = {ticks = -257732994002}
[21:44:00.658]         dest = 0xba8310 <donothingDR>
[21:44:00.658]         queryDesc = 0x8363cd9d8
[21:44:00.658]         eflags = 1
[21:44:00.658] #12 0x00000000006e6667 in standard_ExplainOneQuery (query=<optimized out>, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x834e1bc38, queryString=0x834df4100 "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=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:529
[21:44:00.658]         bufusage_start = {shared_blks_hit = 0, shared_blks_read = 35713423816, shared_blks_dirtied = 35713423816, shared_blks_written = 11377545, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 35713423816, temp_blks_read = 1, temp_blks_written = 35269965848, shared_blk_read_time = {ticks = 34918532752}, shared_blk_write_time = {ticks = 5995402}, local_blk_read_time = {ticks = 70368744194155}, local_blk_write_time = {ticks = 35269966448}, temp_blk_read_time = {ticks = 34918532928}, temp_blk_write_time = {ticks = 9405194}}
[21:44:00.658]         bufusage = {shared_blks_hit = 257, shared_blks_read = 732993842, shared_blks_dirtied = 0, shared_blks_written = 35242652216, local_blks_hit = 34918532895, local_blks_read = 35230261392, local_blks_dirtied = 35242710656, local_blks_written = 35242641792, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 35113777211}, local_blk_read_time = {ticks = 35269965320}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34918532896}, temp_blk_write_time = {ticks = 11415568}}
[21:44:00.658]         mem_counters = {nblocks = 34918532672, freechunks = 11377545, totalspace = 240, freespace = 35713423816}
[21:44:00.658]         planduration = {ticks = 4703807}
[21:44:00.658]         planner_ctx = <optimized out>
[21:44:00.658]         saved_ctx = <optimized out>
[21:44:00.658]         planstart = {ticks = -257728290035}
[21:44:00.658]         plan = 0x8363923a0
[21:44:00.658] #13 0x00000000006e5e94 in ExplainOneQuery (query=0x18e1b, cursorOptions=2048, into=0x0, es=0x834e1bc38, pstate=0x834e1b6b8, params=0x0) at ../src/backend/commands/explain.c:466
[21:44:00.658] No locals.
[21:44:00.658] #14 ExplainQuery (pstate=pstate@entry=0x834e1b6b8, stmt=stmt@entry=0x83640f5d8, params=params@entry=0x0, dest=0x834e1b628) at ../src/backend/commands/explain.c:364
[21:44:00.658]         l__state = {l = <optimized out>, i = 0}
[21:44:00.658]         l = 0x834e46cb0
[21:44:00.658]         es = 0x834e1bc38
[21:44:00.658]         jstate = <optimized out>
[21:44:00.658]         timing_set = false
[21:44:00.658]         buffers_set = false
[21:44:00.658]         summary_set = false
[21:44:00.658]         lc = <optimized out>
[21:44:00.658]         query = <optimized out>
[21:44:00.658]         rewritten = 0x834e46c98
[21:44:00.658]         tstate = <optimized out>
[21:44:00.658] #15 0x00000000009573f7 in standard_ProcessUtility (pstmt=0x836414278, queryString=0x834df4100 "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 = "..., readOnlyTree=<optimized out>, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834e1b628, qc=0x8214e8908) at ../src/backend/tcop/utility.c:866
[21:44:00.658]         isAtomicContext = false
[21:44:00.658]         parsetree = 0x83640f5d8
[21:44:00.658]         readonly_flags = <optimized out>
[21:44:00.658]         pstate = 0x834e1b6b8
[21:44:00.658]         isTopLevel = <optimized out>
[21:44:00.658] #16 0x00000000009570c8 in ProcessUtility (pstmt=0x18e1b, queryString=0x6 <error: Cannot access memory at address 0x6>, readOnlyTree=<optimized out>, context=753599482, params=0x0, queryEnv=0x0, dest=0x834e1b628, qc=0x8214e8908) at ../src/backend/tcop/utility.c:523
[21:44:00.658] No locals.
[21:44:00.658] #17 0x0000000000956b73 in PortalRunUtility (portal=portal@entry=0x834ece100, pstmt=0x836414278, isTopLevel=<optimized out>, setHoldSnapshot=<optimized out>, dest=dest@entry=0x834e1b628, qc=qc@entry=0x8214e8908) at ../src/backend/tcop/pquery.c:1184
[21:44:00.658] No locals.
[21:44:00.658] #18 0x0000000000955d6d in FillPortalStore (portal=portal@entry=0x834ece100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1057
[21:44:00.658]         qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0}
[21:44:00.658]         treceiver = 0x834e1b628
[21:44:00.658] #19 0x0000000000955a9a in PortalRun (portal=portal@entry=0x834ece100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x8364143d8, altdest=altdest@entry=0x8364143d8, qc=qc@entry=0x8214e8a50) at ../src/backend/tcop/pquery.c:791
[21:44:00.658]         _local_sigjmp_buf = {{_sjb = {9787960, 35247677696, 34918533432, 34918533680, 34918533440, 12665112, 34918533712, 12594072, 34918499199, 34918533647, 35247685888, 34359738368}}}
[21:44:00.658]         _save_exception_stack = 0x8214e8b20
[21:44:00.658]         _save_context_stack = 0x0
[21:44:00.658]         _do_rethrow = false
[21:44:00.658]         saveTopTransactionResourceOwner = 0x834eda498
[21:44:00.658]         saveTopTransactionContext = 0x834ed2000
[21:44:00.658]         saveActivePortal = 0x0
[21:44:00.658]         saveResourceOwner = 0x834eda498
[21:44:00.658]         savePortalContext = 0x0
[21:44:00.658]         saveMemoryContext = 0x834ed2000
[21:44:00.658]         result = <optimized out>
[21:44:00.658]         nprocessed = <optimized out>
[21:44:00.658] #20 0x0000000000954891 in exec_simple_query (query_string=query_string@entry=0x834df4100 "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 ../src/backend/tcop/postgres.c:1272
[21:44:00.658]         cmdtaglen = 7
[21:44:00.658]         snapshot_set = <optimized out>
[21:44:00.658]         per_parsetree_context = 0x0
[21:44:00.658]         plantree_list = <optimized out>
[21:44:00.658]         qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0}
[21:44:00.658]         format = 0
[21:44:00.658]         parsetree = 0x834fb3968
[21:44:00.658]         commandTag = <optimized out>
[21:44:00.658]         cmdtagname = <optimized out>
[21:44:00.658]         querytree_list = <optimized out>
[21:44:00.658]         portal = 0x834ece100
[21:44:00.658]         receiver = 0x8364143d8
[21:44:00.658]         parsetree_item__state = {l = 0x834fb5210, i = 0}
[21:44:00.658]         msec_str = "\000\000\000\000\b", '\000' <repeats 11 times>, "퉿g\000\000\000\000bϣ2nj\257Y"
[21:44:00.658]         dest = DestRemote
[21:44:00.658]         was_logged = <optimized out>
[21:44:00.658]         oldcontext = 0x834ed2000
[21:44:00.658]         parsetree_list = 0x834fb5210
[21:44:00.658]         use_implicit_block = false
[21:44:00.658]         parsetree_item = 0x834fb5228
[21:44:00.658]         save_log_statement_stats = <optimized out>
[21:44:00.658] #21 0x0000000000952503 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at ../src/backend/tcop/postgres.c:4689
[21:44:00.658]         query_string = 0x834df4100 "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 = "...
[21:44:00.658]         input_message = {data = 0x834df4100 "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 = "..., len = 254, maxlen = 1024, cursor = 254}
[21:44:00.658]         firstchar = <optimized out>
[21:44:00.658]         local_sigjmp_buf = {{_sjb = {9771430, 34918533920, 34918533880, 34918534464, 12673864, 1, 8192, 8388608, 895, 0, 0, 34359738369}}}
[21:44:00.658]         send_ready_for_query = false
[21:44:00.658]         idle_in_transaction_timeout_enabled = false
[21:44:00.658]         idle_session_timeout_enabled = false
[21:44:00.658] #22 0x000000000094ce99 in BackendMain (startup_data=<optimized out>, startup_data_len=<optimized out>) at ../src/backend/tcop/backend_startup.c:107
[21:44:00.658]         bsdata = <optimized out>
[21:44:00.658] #23 0x00000000008a3865 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x8214e9850, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x8214e97a0) at ../src/backend/postmaster/launch_backend.c:274
[21:44:00.658]         pid = <optimized out>
[21:44:00.658] #24 0x00000000008a7c0b in BackendStartup (client_sock=0x8214e97a0) at ../src/backend/postmaster/postmaster.c:3519
[21:44:00.658]         startup_data = {canAcceptConnections = CAC_OK}
[21:44:00.658]         bn = 0x834e9c038
[21:44:00.658]         cac = CAC_OK
[21:44:00.658]         pid = <optimized out>
[21:44:00.658]         __error = <optimized out>
[21:44:00.658]         save_errno = <optimized out>
[21:44:00.658]         __error = <optimized out>
[21:44:00.658]         __error = <optimized out>
[21:44:00.658] #25 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688
[21:44:00.658]         s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\f", '\000' <repeats 24 times>, "\230N!\b\000\000\000h\225\223-\b\000\000\000\372\000\000\000\000\000\000\000^\037\224-\b", '\000' <repeats 19 times>, "@\230N!\b\000\000\000\3645\212\000\000\000\000\000P\230N!\b", '\000' <repeats 18 times>}, salen = 16}}
[21:44:00.658]         i = 0
[21:44:00.658]         now = <optimized out>
[21:44:00.658]         events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 887444952, events = 8, fd = 558798304, user_data = 0x8214e9340}, {pos = 8192, events = 0, fd = 8192, user_data = 0x834ec8000}, {pos = 558797640, events = 8, fd = 0, user_data = 0x833e32090}, {pos = 1, events = 0, fd = 558797440, user_data = 0x82cf1f9c9}, {pos = 752370568, events = 8, fd = 752463224, user_data = 0x8214e9298}, {pos = 558797584, events = 8, fd = 558797632, user_data = 0x8214e9338}, {pos = 870523024, events = 8, fd = 882903424, user_data = 0x20}, {pos = 4096, events = 0, fd = 558798080, user_data = 0x82cf1aa7c}, {pos = 558797624, events = 8, fd = 1165562634, user_data = 0x82cd7c858}, {pos = 752463224, events = 8, fd = 558797576, user_data = 0x8214e9380}, {pos = 558797576, events = 8, fd = 752426252, user_data = 0x821ea1408}, {pos = 752426252, events = 8, fd = 558797680, user_data = 0x58f4578c43a}, {pos = 870523072, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 882913848, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821ea6288}, {pos = 752339032, events = 8, fd = 568988680, user_data = 0x8214e9408}, {pos = 558798280, events = 8, fd = 558797808, user_data = 0x58f45790ca2}, {pos = 2725061, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 569012280, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 558798536, user_data = 0x21ea1408}, {pos = 558798352, events = 8, fd = 558797952, user_data = 0x1}, {pos = 558798280, events = 8, fd = 32, user_data = 0x8214e9470}, {pos = 1165560435, events = 1423, fd = 558798224, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821ea7038}, {pos = 1, events = 8, fd = 568988680, user_data = 0x82cd7c858}, {pos = 558798536, events = 8, fd = 558798352, user_data = 0x8214e9480}, {pos = 0, events = 0, fd = 568958984, user_data = 0x20}, {pos = 558798336, events = 8, fd = 1165535975, user_data = 0x821e9a008}, {pos = 568960008, events = 8, fd = 568961032, user_data = 0x821e9ac08}, {pos = 568975368, events = 8, fd = 568976392, user_data = 0x821e9e808}, {pos = 568978440, events = 8, fd = 568979464, user_data = 0x821e9f408}, {pos = 568981512, events = 8, fd = 568982536, user_data = 0x821ea0008}, {pos = 568984584, events = 8, fd = 568985608, user_data = 0x821ea0c08}, {pos = 568987656, events = 8, fd = 568988680, user_data = 0x821ea1808}, {pos = 568990728, events = 8, fd = 568991752, user_data = 0x821ea2408}, {pos = 568993800, events = 8, fd = 568994824, user_data = 0x821ea3008}, {pos = 568996872, events = 8, fd = 568997896, user_data = 0x821ea3c08}, {pos = 569004040, events = 8, fd = 569005064, user_data = 0x821ea5808}, {pos = 569007112, events = 8, fd = 568958984, user_data = 0x2994c5}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821ea7038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 558798536, events = 8, fd = 558797952, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 569012280, user_data = 0x1}, {pos = 568958984, events = 8, fd = 298, user_data = 0x8214e96b0}, {pos = 1165534703, events = 1423, fd = 2725061, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 569012280, user_data = 0x1}, {pos = 568988680, events = 8, fd = 886980608, user_data = 0x1}, {pos = 886981012, events = 8, fd = 0, user_data = 0x8214e9680}, {pos = 764679532, events = 8, fd = 1, user_data = 0x834de4000}, {pos = 558798512, events = 8, fd = 764675842, user_data = 0x82ceae170 <fork>}, {pos = 12556336, events = 0, fd = 753590640, user_data = 0x821ea1408}, {pos = 558798736, events = 8, fd = 1165534174, user_data = 0x834e02800}, {pos = 1, events = 8, fd = 1165533790, user_data = 0x821e9a008}, {pos = 558798520, events = 8, fd = 558798736, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 1165613456, user_data = 0x0}, {pos = 558760831, events = 8, fd = 8174759, user_data = 0x8214e9740}, {pos = 764638224, events = 8, fd = 754253872, user_data = 0x82cf52310}, {pos = 0, events = 0, fd = 8128, user_data = 0x8214e9770}, {pos = 764681117, events = 8, fd = 886980608, user_data = 0x561c}, {pos = 558798800, events = 8, fd = 764647674, user_data = 0x0}, {pos = 0, events = 0, fd = -423562128, user_data = 0x0}}
[21:44:00.658]         last_touch_time = 1740605931
[21:44:00.658]         last_lockfile_recheck_time = 1740605931
[21:44:00.658]         nevents = 1
[21:44:00.658] #26 0x00000000008a6044 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x8214e9dc0) at ../src/backend/postmaster/postmaster.c:1386
[21:44:00.659]         userDoption = <optimized out>
[21:44:00.659]         listen_addr_saved = false
[21:44:00.659]         output_config_variable = <optimized out>
[21:44:00.659]         opt = <optimized out>
[21:44:00.659]         status = <optimized out>
[21:44:00.659] #27 0x00000000007d8e40 in main (argc=8, argv=0x8214e9dc0) at ../src/backend/main/main.c:230
[21:44:00.659]         do_check_root = <optimized out>
[21:44:00.659]         dispatch_option = DISPATCH_POSTMASTER