GNU gdb (GDB) 12.1 [GDB v12.1 for FreeBSD] Copyright (C) 2022 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "aarch64-portbld-freebsd14.0". Type "show configuration" for configuration details. For bug reporting instructions, please see: . Find the GDB manual and other documentation resources online at: . For help, type "help". Type "apropos word" to search for commands related to "word"... Reading symbols from ./tmp_install/usr/local/pgsql/bin/postgres... warning: exec file is newer than core file. [New LWP 100395] Core was generated by `postgres: parallel worker for PID 29046 '. #0 _poll () at _poll.S:4 4 _poll.S: No such file or directory. (gdb) bt #0 _poll () at _poll.S:4 #1 0x00000000891c1850 in __thr_poll (fds=0x4, nfds=2, timeout=-1) at /usr/src/lib/libthr/thread/thr_syscalls.c:338 #2 0x000000000076e930 in WaitEventSetWaitBlock (nevents=1, occurred_events=0x811edf18, cur_timeout=-1, set=0x90645eb0) at latch.c:1171 #3 WaitEventSetWait (set=0x90645eb0, timeout=timeout@entry=-1, occurred_events=occurred_events@entry=0x811edf18, nevents=nevents@entry=1, wait_event_info=wait_event_info@entry=134217738) at latch.c:1000 #4 0x000000000078c5b0 in ConditionVariableSleep (cv=cv@entry=0x9e85e308, wait_event_info=wait_event_info@entry=134217738) at condition_variable.c:157 #5 0x000000000076a778 in BarrierArriveAndWait (barrier=barrier@entry=0x9e85e2f0, wait_event_info=134217738) at barrier.c:191 #6 0x000000000064d910 in ExecHashJoinImpl (parallel=true, pstate=0x9070feb8) at nodeHashjoin.c:328 #7 ExecParallelHashJoin (pstate=0x9070feb8) at nodeHashjoin.c:600 #8 0x0000000000638824 in ExecProcNodeInstr (node=0x9070feb8) at execProcnode.c:462 #9 0x0000000000641708 in ExecProcNode (node=0x9070feb8) at ../../../src/include/executor/executor.h:248 #10 fetch_input_tuple (aggstate=aggstate@entry=0x9070fb70) at nodeAgg.c:407 #11 0x0000000000642ee8 in agg_retrieve_direct (aggstate=0x9070fb70) at nodeAgg.c:1746 #12 ExecAgg (pstate=0x9070fb70) at nodeAgg.c:1561 #13 0x0000000000638824 in ExecProcNodeInstr (node=0x9070fb70) at execProcnode.c:462 #14 0x00000000006313a4 in ExecProcNode (node=0x9070fb70) at ../../../src/include/executor/executor.h:248 #15 ExecutePlan (execute_once=, dest=0x90665a78, direction=, numberTuples=0, sendTuples=, operation=CMD_SELECT, use_parallel_mode=, planstate=0x9070fb70, estate=0x9070f118) at execMain.c:1712 #16 standard_ExecutorRun (queryDesc=0x90666e90, direction=, count=0, execute_once=) at execMain.c:353 #17 0x0000000000636434 in ParallelQueryMain (seg=0x90564fb8, toc=0x9e85e000) at execParallel.c:1402 #18 0x0000000000509c58 in ParallelWorkerMain (main_arg=) at parallel.c:1433 #19 0x0000000000705b88 in StartBackgroundWorker () at bgworker.c:911 #20 0x000000000071263c in do_start_bgworker (rw=0x90585780) at postmaster.c:5831 #21 maybe_start_bgworkers () at postmaster.c:6056 #22 0x0000000000712ef8 in sigusr1_handler (postgres_signal_arg=) at postmaster.c:5169 #23 0x00000000891bf37c in handle_signal (actp=actp@entry=0x811ee9c0, sig=sig@entry=30, info=info@entry=0x811eea30, ucp=ucp@entry=0x811eea80) at /usr/src/lib/libthr/thread/thr_sig.c:303 #24 0x00000000891beab8 in thr_sighandler (sig=30, info=0x811eea30, _ucp=0x811eea80) at /usr/src/lib/libthr/thread/thr_sig.c:246 #25 #26 _select () at _select.S:4 #27 0x00000000891c1b0c in __thr_select (numfds=4, readfds=0x811eefc0, writefds=0x0, exceptfds=0x0, timeout=0x811ef448) at /usr/src/lib/libthr/thread/thr_syscalls.c:495 #28 0x0000000000713720 in ServerLoop () at postmaster.c:1692 #29 0x00000000007150e8 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x811ef998) at postmaster.c:1401 #30 0x000000000047aaf8 in main (argc=8, argv=0x811ef998) at main.c:228