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 1lZWwh-0005wy-Pk for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Apr 2021 10:52:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lZWwg-0003xt-Nu for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Apr 2021 10:52:30 +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 1lZWwg-0003xm-Hs for pgsql-bugs@lists.postgresql.org; Thu, 22 Apr 2021 10:52:30 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lZWwe-0002p7-0h for pgsql-bugs@lists.postgresql.org; Thu, 22 Apr 2021 10:52:29 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id B6BF75C00E2; Thu, 22 Apr 2021 06:52:25 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Thu, 22 Apr 2021 06:52:25 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=l8NRGNJOQ4+0Zt3gUMa+uDFpBYM p38wosCx0/VaSDdQ=; b=BhdD05YRscGVoknlYWNO4cVX+YXwz3If/j83f8Dx6It eh5Xn9rfFXbkKHJg7EpCyNA+5XXGwCieVXLLr+UkfrFiP7iB40b9bJBZ1XmQ9pok WTJkNlFd+SOVQDBaiu1DK17ISPKe+kLGhuCWBZXFzghmgMYDtqkXeLtoewzYApGk k3DJ0sk79Tv3+Vj2QaFz61tr0fFLHlMZYioBuOc827TfNi6/lbuvzIybh8tTvPt9 hzIJWEayF86x/1dRrw8ZB/i9x3Mgti52kGelIOMggBr8SOX41eEiXS6r8uc1Y/8/ DuUsuvAlTZG46MnV6+zzGROuGaYjj42mClVrAHjml4g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=l8NRGN JOQ4+0Zt3gUMa+uDFpBYMp38wosCx0/VaSDdQ=; b=dTvHO3e1vtr0dNjY6vmBJI F8PLVDWZd0hxt6wfjYIQyqmDfxDIL3wvmyu5yyTbXpY5IYOABwoKvJoE+dkBGwGH DFwWcjJCNQ43n5Ruceh56ogW+nNRBkXSYZP8WjXQfw8ghp3eyrd/Yxj/MaWL1a/D CWk0GKUchfFFty6eCTzxzq+xM7q2ClnjGTXQJoZM2f90fWhDHH8CzMEC8SwTtTpJ KDOMMIrmMqDcVIAJIZ6+bSl0+yhbzXFGzGybOdN7wmVFgmvc2gQLLAJSrUxmIuwx Y1Pqel0MdERfHj/8pHx9VMrGNCFebmoCXFqvPO0pw430RvIKmiPP5men0CCbdV6A == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvddutddgfeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtroertddt udenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeekuefggedugfffffelgeeuheff jefhgffffeeffeefiefhuedttedtieeuvdelueenucfkphepudduuddruddtvddrudektd drudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id D43331080057; Thu, 22 Apr 2021 06:52:23 -0400 (EDT) Date: Thu, 22 Apr 2021 19:52:21 +0900 From: Michael Paquier To: Herwig Goemans Cc: Tom Lane , pgsql-bugs@lists.postgresql.org, PG Bug reporting form Subject: Re: BUG #16976: server crash when deleting via a trigger on a foreign table Message-ID: References: <16976-abe0cb88252bc02e@postgresql.org> <756273.1619012414@sss.pgh.pa.us> <813ebc08-8f81-4efe-a5f2-caac938b7741@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="/mzuITJAcev5lO6A" Content-Disposition: inline In-Reply-To: <813ebc08-8f81-4efe-a5f2-caac938b7741@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --/mzuITJAcev5lO6A Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Apr 22, 2021 at 12:09:44PM +0200, Herwig Goemans wrote: > Anyway, with the trigger in place we encounter PG server crashes. >=20 > I am having trouble collection a trace file because when I attach gdb to = the > process: >=20 > 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=A0=A0=A0=A0=A0 ../sysdeps/unix/sysv/linux/epoll_wait.c: No such file o= r directory. > (gdb) quit What does a simple "bt" print? -- Michael --/mzuITJAcev5lO6A Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmCBVWUACgkQnvQgOdby QH1/bA/+PzEw5v63C3Y+WwoEJ5xa7dvAftoHATJAdsCLtcstKHssqCm7KGi71xsP 4y3ncsyX1728RGAxbimHy2UYjCqf0aIEshRZo6AqZ8G6ZFx29SPOT9bCLLlVuOTt 0PNjqOZzMqTLCHpsMXgk2ZCDbFASZpXta0suJa6qYxbDMPpNf+d/4TFUGXzNIqF2 yrM8lcx4NaG8WwdqcgWE4VK7RSFV6hczJbbhEgT0ie2aUBzVHP0EYaHnamVcM2BQ Q9O4/QvijivYVarQJjFFMR1HNfiGgl6CxffZE8c/ovmORwz4lkqlR/LNYKgzAdBk bXrZziWWL8vYAFSQ/e4JCOKu77lM8e00eAk+tWnEjqCKQyI7z63yIb2CWawS5YuO iXzt/UZ7D1jtvVeu4rTFjwUCYivZMeOoZoyJ3S3Mf0GULnvpICF9IncAW6d5s/DV PoUobCkNSPQHY5NREIFjOaMLrEUH7jV+F/3OIlweHicQ58u9d/LZzgwT9AihF90T b3SnLeuo0z4UNzB7IoU/GUEixBbrPDGXkpG3fzikcHye9gXKTcUnArXtqHGtPYNm Fgz7iR4jwWAQ7lKAHmcyJezuqXkIPO/7fiQciwp4imloB2bw2rMh5A8Q1ifGw4dC m3VXfv4ekUrNAkssdTEyaoKhuucadR9s4uz13ORvSoU6q9H1eMg= =MFOh -----END PGP SIGNATURE----- --/mzuITJAcev5lO6A--