[22:42:05.127] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [22:42:05.432] dumping /tmp/cores/postgres.19680.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:42:05.575] [New LWP 101647] [22:42:05.681] Core was generated by `postgres: postgres regression_postgres_fdw [local] EXPLAIN'. [22:42:05.681] Program terminated with signal SIGABRT, Aborted. [22:42:05.681] Sent by thr_kill() from pid 19680 and user 1003. [22:42:05.681] #0 0x000000082b40241a in thr_kill () from /lib/libc.so.7 [22:42:05.746] [22:42:05.746] Thread 1 (LWP 101647): [22:42:05.746] #0 0x000000082b40241a in thr_kill () from /lib/libc.so.7 [22:42:05.746] No symbol table info available. [22:42:05.746] #1 0x000000082b37be64 in raise () from /lib/libc.so.7 [22:42:05.746] No symbol table info available. [22:42:05.746] #2 0x000000082b42c6f9 in abort () from /lib/libc.so.7 [22:42:05.746] No symbol table info available. [22:42:05.746] #3 0x0000000000ab1c15 in ExceptionalCondition (conditionName=0x30ad23 "plan->workmem == 0", fileName=, lineNumber=lineNumber@entry=188) at ../src/backend/utils/error/assert.c:66 [22:42:05.746] No locals. [22:42:05.746] #4 0x0000000000782d75 in assign_workmem_plan (plan=0x8377116e8) at ../src/backend/executor/execWorkmem.c:188 [22:42:05.746] No locals. [22:42:05.746] #5 0x0000000000782bbe in assign_workmem_plan (plan=0x83770cc10) at ../src/backend/executor/execWorkmem.c:198 [22:42:05.746] No locals. [22:42:05.746] #6 0x0000000000782bbe in assign_workmem_plan (plan=0x83770c3c0) at ../src/backend/executor/execWorkmem.c:198 [22:42:05.746] No locals. [22:42:05.746] #7 0x0000000000782bcc in assign_workmem_plan (plan=0x83770b1d0) at ../src/backend/executor/execWorkmem.c:201 [22:42:05.746] No locals. [22:42:05.746] #8 0x0000000000782bbe in assign_workmem_plan (plan=0x83770a4d0) at ../src/backend/executor/execWorkmem.c:198 [22:42:05.746] No locals. [22:42:05.746] #9 0x0000000000770146 in InitPlan (queryDesc=0x8377459f8, eflags=33) at ../src/backend/executor/execMain.c:1057 [22:42:05.746] operation = CMD_SELECT [22:42:05.746] plannedstmt = 0x83770a3c0 [22:42:05.746] cachedplan = [22:42:05.746] plan = 0x83770a4d0 [22:42:05.746] rangeTable = [22:42:05.746] estate = 0x83777b100 [22:42:05.746] l = [22:42:05.746] i = [22:42:05.746] planstate = [22:42:05.746] tupType = [22:42:05.746] l__state = [22:42:05.746] rc = [22:42:05.746] relid = [22:42:05.746] erm = [22:42:05.746] relation = [22:42:05.746] __error = [22:42:05.746] l__state = [22:42:05.746] subplan = [22:42:05.746] sp_eflags = [22:42:05.746] subplanstate = [22:42:05.746] junk_filter_needed = [22:42:05.746] tlist = [22:42:05.746] tlist__state = [22:42:05.746] tle = [22:42:05.746] slot = [22:42:05.746] j = [22:42:05.746] #10 standard_ExecutorStart (queryDesc=0x8377459f8, eflags=33) at ../src/backend/executor/execMain.c:268 [22:42:05.746] estate = [22:42:05.746] oldcontext = 0x834de1400 [22:42:05.746] #11 0x00000000006e67f8 in ExplainOnePlan (plannedstmt=plannedstmt@entry=0x83770a3c0, cplan=cplan@entry=0x0, plansource=plansource@entry=0x0, query_index=query_index@entry=-1, into=into@entry=0x0, es=es@entry=0x834de1c38, queryString=0x834dba100 "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=0x82105a398, bufusage=0x0, mem_counters=0x0) at ../src/backend/commands/explain.c:729 [22:42:05.746] 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}}} [22:42:05.746] totaltime = 0 [22:42:05.746] instrument_option = [22:42:05.746] starttime = {ticks = -177128890382} [22:42:05.746] dest = 0xba7fa0 [22:42:05.746] queryDesc = 0x8377459f8 [22:42:05.746] eflags = 1 [22:42:05.746] #12 0x00000000006e65d7 in standard_ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x834de1c38, queryString=0x834dba100 "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:526 [22:42:05.746] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 35290381512, shared_blks_dirtied = 35712812104, shared_blks_written = 11376777, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 35290381512, temp_blks_read = 1, temp_blks_written = 35290382040, shared_blk_read_time = {ticks = 34913755904}, shared_blk_write_time = {ticks = 5995514}, local_blk_read_time = {ticks = 70368744194155}, local_blk_write_time = {ticks = 35290382640}, temp_blk_read_time = {ticks = 34913756080}, temp_blk_write_time = {ticks = 9404591}} [22:42:05.746] bufusage = {shared_blks_hit = 177, shared_blks_read = 128890201, shared_blks_dirtied = 0, shared_blks_written = 35240555064, local_blks_hit = 34913756047, local_blks_read = 35217571984, local_blks_dirtied = 35240613504, local_blks_written = 35240544640, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 35290382640}, local_blk_read_time = {ticks = 35290381512}, local_blk_write_time = {ticks = 35290381512}, temp_blk_read_time = {ticks = 34913756048}, temp_blk_write_time = {ticks = 11414800}} [22:42:05.746] mem_counters = {nblocks = 34913755824, freechunks = 11376777, totalspace = 240, freespace = 35712812104} [22:42:05.746] planduration = {ticks = 4196823} [22:42:05.746] planner_ctx = [22:42:05.746] saved_ctx = [22:42:05.746] planstart = {ticks = -177124693378} [22:42:05.746] plan = 0x83770a3c0 [22:42:05.746] #13 0x00000000006e5e04 in ExplainOneQuery (query=0x18d0f, cursorOptions=2048, into=0x0, es=0x834de1c38, pstate=0x834de16b8, params=0x0) at ../src/backend/commands/explain.c:463 [22:42:05.746] No locals. [22:42:05.746] #14 ExplainQuery (pstate=pstate@entry=0x834de16b8, stmt=stmt@entry=0x837787c98, params=params@entry=0x0, dest=0x834de1628) at ../src/backend/commands/explain.c:361 [22:42:05.746] l__state = {l = , i = 0} [22:42:05.746] l = 0x834e0ccb0 [22:42:05.746] es = 0x834de1c38 [22:42:05.746] jstate = [22:42:05.746] timing_set = false [22:42:05.746] buffers_set = false [22:42:05.746] summary_set = false [22:42:05.746] lc = [22:42:05.746] query = [22:42:05.746] rewritten = 0x834e0cc98 [22:42:05.746] tstate = [22:42:05.746] #15 0x00000000009570f7 in standard_ProcessUtility (pstmt=0x83778c938, queryString=0x834dba100 "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=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x834de1628, qc=0x82105a578) at ../src/backend/tcop/utility.c:866 [22:42:05.746] isAtomicContext = false [22:42:05.746] parsetree = 0x837787c98 [22:42:05.746] readonly_flags = [22:42:05.746] pstate = 0x834de16b8 [22:42:05.746] isTopLevel = [22:42:05.746] #16 0x0000000000956dc8 in ProcessUtility (pstmt=0x18d0f, queryString=0x6 , readOnlyTree=, context=725623802, params=0x0, queryEnv=0x0, dest=0x834de1628, qc=0x82105a578) at ../src/backend/tcop/utility.c:523 [22:42:05.746] No locals. [22:42:05.746] #17 0x0000000000956873 in PortalRunUtility (portal=portal@entry=0x834e94100, pstmt=0x83778c938, isTopLevel=, setHoldSnapshot=, dest=dest@entry=0x834de1628, qc=qc@entry=0x82105a578) at ../src/backend/tcop/pquery.c:1184 [22:42:05.746] No locals. [22:42:05.746] #18 0x0000000000955a6d in FillPortalStore (portal=portal@entry=0x834e94100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1057 [22:42:05.746] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:42:05.746] treceiver = 0x834de1628 [22:42:05.746] #19 0x000000000095579a in PortalRun (portal=portal@entry=0x834e94100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x83778ca98, altdest=altdest@entry=0x83778ca98, qc=qc@entry=0x82105a6c0) at ../src/backend/tcop/pquery.c:791 [22:42:05.746] _local_sigjmp_buf = {{_sjb = {9787192, 35247440128, 34913756584, 34913756832, 34913756592, 12664088, 34913756864, 12593048, 34913715071, 34913756799, 35247448320, 34359738368}}} [22:42:05.746] _save_exception_stack = 0x82105a790 [22:42:05.746] _save_context_stack = 0x0 [22:42:05.746] _do_rethrow = false [22:42:05.746] saveTopTransactionResourceOwner = 0x834ea0418 [22:42:05.746] saveTopTransactionContext = 0x834e98000 [22:42:05.746] saveActivePortal = 0x0 [22:42:05.746] saveResourceOwner = 0x834ea0418 [22:42:05.746] savePortalContext = 0x0 [22:42:05.746] saveMemoryContext = 0x834e98000 [22:42:05.746] result = [22:42:05.746] nprocessed = [22:42:05.746] #20 0x0000000000954591 in exec_simple_query (query_string=query_string@entry=0x834dba100 "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 [22:42:05.746] cmdtaglen = 7 [22:42:05.746] snapshot_set = [22:42:05.746] per_parsetree_context = 0x0 [22:42:05.746] plantree_list = [22:42:05.746] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:42:05.746] format = 0 [22:42:05.746] parsetree = 0x834f79928 [22:42:05.746] commandTag = [22:42:05.746] cmdtagname = [22:42:05.746] querytree_list = [22:42:05.746] portal = 0x834e94100 [22:42:05.746] receiver = 0x83778ca98 [22:42:05.746] parsetree_item__state = {l = 0x834f7b1d0, i = 0} [22:42:05.746] msec_str = "\000\000\000\000\b", '\000' , "\177\364\274g\000\000\000\000\373s~\373\002\304\316h" [22:42:05.746] dest = DestRemote [22:42:05.746] was_logged = [22:42:05.746] oldcontext = 0x834e98000 [22:42:05.746] parsetree_list = 0x834f7b1d0 [22:42:05.746] use_implicit_block = false [22:42:05.746] parsetree_item = 0x834f7b1e8 [22:42:05.746] save_log_statement_stats = [22:42:05.746] #21 0x0000000000952203 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4689 [22:42:05.746] query_string = 0x834dba100 "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:42:05.746] input_message = {data = 0x834dba100 "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} [22:42:05.746] firstchar = [22:42:05.746] local_sigjmp_buf = {{_sjb = {9770662, 34913757072, 34913757032, 34913757616, 12672840, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [22:42:05.746] send_ready_for_query = false [22:42:05.746] idle_in_transaction_timeout_enabled = false [22:42:05.746] idle_session_timeout_enabled = false [22:42:05.746] #22 0x000000000094cb99 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [22:42:05.746] bsdata = [22:42:05.746] #23 0x00000000008a36b5 in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x82105b4c0, startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x82105b410) at ../src/backend/postmaster/launch_backend.c:274 [22:42:05.746] pid = [22:42:05.746] #24 0x00000000008a7a5b in BackendStartup (client_sock=0x82105b410) at ../src/backend/postmaster/postmaster.c:3519 [22:42:05.746] startup_data = {canAcceptConnections = CAC_OK} [22:42:05.746] bn = 0x834e62098 [22:42:05.746] cac = CAC_OK [22:42:05.746] pid = [22:42:05.746] __error = [22:42:05.746] save_errno = [22:42:05.746] __error = [22:42:05.746] __error = [22:42:05.746] #25 ServerLoop () at ../src/backend/postmaster/postmaster.c:1688 [22:42:05.746] 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' , "p\264\005!\b\000\000\000hu\360)\b\000\000\000\372\000\000\000\000\000\000\000^\377\360)\b", '\000' , "\260\264\005!\b\000\000\000D4\212\000\000\000\000\000\300\264\005!\b", '\000' }, salen = 16}} [22:42:05.746] i = 0 [22:42:05.746] now = [22:42:05.746] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 887207384, events = 8, fd = 554021456, user_data = 0x82105afb0}, {pos = 8192, events = 0, fd = 8192, user_data = 0x834e8e000}, {pos = 554020792, events = 8, fd = 0, user_data = 0x833218090}, {pos = 1, events = 0, fd = 554020592, user_data = 0x82b4719c9}, {pos = 724394888, events = 8, fd = 724487544, user_data = 0x82105af08}, {pos = 554020736, events = 8, fd = 554020784, user_data = 0x82105afa8}, {pos = 857833616, events = 8, fd = 880806272, user_data = 0x20}, {pos = 4096, events = 0, fd = 554021232, user_data = 0x82b46ca7c}, {pos = 554020776, events = 8, fd = 124691210, user_data = 0x82b2ce858}, {pos = 724487544, events = 8, fd = 554020728, user_data = 0x82105aff0}, {pos = 554020728, events = 8, fd = 724450572, user_data = 0x821753408}, {pos = 724450572, events = 8, fd = 554020832, user_data = 0x303c076e543a}, {pos = 857833664, events = 8, fd = 4096, user_data = 0x1001}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 880816696, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821758288}, {pos = 724363352, events = 8, fd = 561329160, user_data = 0x82105b078}, {pos = 554021432, events = 8, fd = 554020960, user_data = 0x303c076e9ca2}, {pos = 2724949, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 561352760, events = 8, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554021688, user_data = 0x21753408}, {pos = 554021504, events = 8, fd = 554021104, user_data = 0x1}, {pos = 554021432, events = 8, fd = 32, user_data = 0x82105b0e0}, {pos = 124689011, events = 12348, fd = 554021376, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821759038}, {pos = 1, events = 8, fd = 561329160, user_data = 0x82b2ce858}, {pos = 554021688, events = 8, fd = 554021504, user_data = 0x82105b0f0}, {pos = 0, events = 0, fd = 561299464, user_data = 0x20}, {pos = 554021488, events = 8, fd = 124664551, user_data = 0x82174c008}, {pos = 561300488, events = 8, fd = 561301512, user_data = 0x82174cc08}, {pos = 561315848, events = 8, fd = 561316872, user_data = 0x821750808}, {pos = 561318920, events = 8, fd = 561319944, user_data = 0x821751408}, {pos = 561321992, events = 8, fd = 561323016, user_data = 0x821752008}, {pos = 561325064, events = 8, fd = 561326088, user_data = 0x821752c08}, {pos = 561328136, events = 8, fd = 561329160, user_data = 0x821753808}, {pos = 561331208, events = 8, fd = 561332232, user_data = 0x821754408}, {pos = 561334280, events = 8, fd = 561335304, user_data = 0x821755008}, {pos = 561337352, events = 8, fd = 561338376, user_data = 0x821755c08}, {pos = 561344520, events = 8, fd = 561345544, user_data = 0x821757808}, {pos = 561347592, events = 8, fd = 561299464, user_data = 0x299455}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x821759038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554021688, events = 8, fd = 554021104, user_data = 0x2000000020}, {pos = 0, events = 0, fd = 561352760, user_data = 0x1}, {pos = 561299464, events = 8, fd = 298, user_data = 0x82105b320}, {pos = 124663279, events = 12348, fd = 2724949, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 561352760, user_data = 0x1}, {pos = 561329160, events = 8, fd = 886743040, user_data = 0x1}, {pos = 886743444, events = 8, fd = 0, user_data = 0x82105b2f0}, {pos = 703657324, events = 8, fd = 1, user_data = 0x834daa000}, {pos = 554021664, events = 8, fd = 703653634, user_data = 0x82b400170 }, {pos = 12555312, events = 0, fd = 725614960, user_data = 0x821753408}, {pos = 554021888, events = 8, fd = 124662750, user_data = 0x834dc8800}, {pos = 1, events = 8, fd = 124662366, user_data = 0x82174c008}, {pos = 554021672, events = 8, fd = 554021888, user_data = 0x1ab8}, {pos = 11, events = 0, fd = 124742032, user_data = 0x0}, {pos = 553976703, events = 8, fd = 8174647, user_data = 0x82105b3b0}, {pos = 703616016, events = 8, fd = 726278192, user_data = 0x82b4a4310}, {pos = 0, events = 0, fd = 8128, user_data = 0x82105b3e0}, {pos = 703658909, events = 8, fd = 886743040, user_data = 0x4cae}, {pos = 554021952, events = 8, fd = 703625466, user_data = 0x0}, {pos = 0, events = 0, fd = -60184903, user_data = 0x0}} [22:42:05.746] last_touch_time = 1740436605 [22:42:05.746] last_lockfile_recheck_time = 1740436605 [22:42:05.746] nevents = 1 [22:42:05.746] #26 0x00000000008a5e94 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82105ba30) at ../src/backend/postmaster/postmaster.c:1386 [22:42:05.747] userDoption = [22:42:05.747] listen_addr_saved = false [22:42:05.747] output_config_variable = [22:42:05.747] opt = [22:42:05.747] status = [22:42:05.747] #27 0x00000000007d8dd0 in main (argc=8, argv=0x82105ba30) at ../src/backend/main/main.c:230 [22:42:05.747] do_check_root = [22:42:05.747] dispatch_option = DISPATCH_POSTMASTER