Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZZJi-00035P-AD for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Apr 2021 13:24:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZZJh-00076Y-9b for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Apr 2021 13:24:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZZJh-00076Q-3X for pgsql-bugs@lists.postgresql.org; Thu, 22 Apr 2021 13:24:25 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZZJd-00041C-To for pgsql-bugs@lists.postgresql.org; Thu, 22 Apr 2021 13:24:23 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 13MDOJ0G946735; Thu, 22 Apr 2021 09:24:19 -0400 From: Tom Lane To: Michael Paquier cc: Herwig Goemans , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16976: server crash when deleting via a trigger on a foreign table In-reply-to: References: <16976-abe0cb88252bc02e@postgresql.org> <756273.1619012414@sss.pgh.pa.us> <813ebc08-8f81-4efe-a5f2-caac938b7741@gmail.com> Comments: In-reply-to Michael Paquier message dated "Thu, 22 Apr 2021 19:52:21 +0900" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <946733.1619097859.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 22 Apr 2021 09:24:19 -0400 Message-ID: <946734.1619097859@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Michael Paquier writes: > On Thu, Apr 22, 2021 at 12:09:44PM +0200, Herwig Goemans wrote: >> I am having trouble collection a trace file because when I attach gdb t= o the >> process: >> 0x00007f99b46f7a07 in epoll_wait (epfd=3D5, events=3D0x561321b40630, >> maxevents=3Dmaxevents@entry=3D1, timeout=3Dtimeout@entry=3D-1) at >> ../sysdeps/unix/sysv/linux/epoll_wait.c:30 >> 30=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ../sysdeps/unix/sysv/linux/epoll_wait.= c: No such file or directory. > What does a simple "bt" print? Yeah, bt should work anyway, though you won't get details about functions for which the corresponding "debug symbols" package isn't installed. The above is showing that you lack debug symbols for glibc, but it's unlikely that that is going to be of interest here. What *is* of interest is Postgres proper and the relevant FDW, so make sure that those symbols are installed. (At least on Red Hat-based systems, gdb will tell you which debug symbol packages you're missing when you first attach to a process or core file.) regards, tom lane