Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ih4xU-0001PN-L3 for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Dec 2019 04:59:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ih4xS-0006gE-Dj for pgsql-bugs@arkaria.postgresql.org; Tue, 17 Dec 2019 04:59:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ih4xS-0006g7-1V for pgsql-bugs@lists.postgresql.org; Tue, 17 Dec 2019 04:59:42 +0000 Received: from [66.111.4.26] (helo=out2-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ih4xL-0000wG-Dc for pgsql-bugs@lists.postgresql.org; Tue, 17 Dec 2019 04:59:40 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 7DF1022195; Mon, 16 Dec 2019 23:59:24 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 16 Dec 2019 23:59:24 -0500 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=fm3; bh=nV5jgqExAkRE/4wFJOnF2QRFl7P qc8YT4gufZyHglgo=; b=SUfmJHXfwILtF9nF2tsMy0KM+7udqIrha65tTZ7yAkz GTrU+gDdly5kDnb4dbYuOL1r5sNBKPZP5TLc2h0P67vzJTuy5LRA69oMMkWm55fH j1tUIcunfT1lpIQO2SoRXFpkkWipzaPLSSbK9JE0+TaS5Dv/UthcMAzPn3uNrL3Z +0vahiAsxgDNTQsPfkeN3oPCg4jtaem6v4OQrQLXqU0yoDYAOWvk46WaTkdN2kTb D3VbI0mVac8yq6aBrFjtD+6bL+kI8q5FIr8WvA/LxTPz58KexkKm95xPmakz0o4d 8zSyocIuS4JMESy5HhOPV9kfSEE/206E5ygCpC3KK6g== 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=fm1; bh=nV5jgq ExAkRE/4wFJOnF2QRFl7Pqc8YT4gufZyHglgo=; b=xiysRKwPmTc+yDmoSw6AbU mtuc6No9lKqF4QVXar9nVgFyIVMotFEzLhQEfxgUXXvD5zSdBsh0uaptQqtIz5H1 xh7g70mvM/+qKeHdBzIDRGTyHaaByrGYKY7+713Fvk0xsx1pQuqRZ902x9VB4Yxv smwwTTXpV2b7fzr4JoWlaooAOulxdGU0EnOPs9UJLwRgQqOl1rY5wFgHauH5jsJB GK5szaTEJ9w7ulrs72kbjbb3yuLXU/ZZURwZdVUhnwYDDnRJ5CvH8sJchsQizKar 8fjJC+JNL1ZFXQ5owPyTzAM9BP34yUDVIWZ4wekUciXq6h7B/T5K15jnN3R6WDeQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrvddtiedgjeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt jeenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt 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 BDE408005B; Mon, 16 Dec 2019 23:59:22 -0500 (EST) Date: Tue, 17 Dec 2019 13:59:20 +0900 From: Michael Paquier To: Kamil =?utf-8?B?Sm/FhGNh?= Cc: Tom Lane , pgsql-bugs@lists.postgresql.org Subject: Re: Random crashes - segmentation fault Message-ID: <20191217045920.GJ2344@paquier.xyz> References: <871rucdwkt.fsf@alfa.kjonca> <20191113125832.GZ1549@paquier.xyz> <87tv77digm.fsf@alfa.kjonca> <6161.1573657623@sss.pgh.pa.us> <87r218z2o1.fsf@alfa.kjonca> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="aYrjF+tKt+ApYAdb" Content-Disposition: inline In-Reply-To: <87r218z2o1.fsf@alfa.kjonca> X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.26 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --aYrjF+tKt+ApYAdb Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Dec 13, 2019 at 04:05:34PM +0100, Kamil Jo=C5=84ca wrote: > Today server crashed again. > --8<---------------cut here---------------start------------->8--- > 2019-12-13 15:41:38 CET DEBUG: starting background worker process > "parallel worker for PID 364516"=20 > TRAP: FailedAssertion("!(result->tdrefcount =3D=3D -1)", File: > /build/postgresql-12-123lrX/postgresql-12-12.1/build/../src/backend/utils= /cache/typcache.c", > Line: 2621)=20 > --8<---------------cut here---------------end--------------->8--- >=20 > I have core dump. Could it be possible to see a full backtrace then? Using gdb that would mean to use "bt" to print the full stack. What kind of function is get_free_numbers() actually and what does it do? -- Michael --aYrjF+tKt+ApYAdb Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl34YKgACgkQnvQgOdby QH0w5Q//c7S+NMSs0QvoL2Pas4QaxlFvrUqk3cLT13TtV0y/J4WT4e4dEBeIf9LD DjXsdVNxx2Xe/oWlg8SGEP84T/vIsCOGoN2rNMCu/KYnnAbuA6nxTUPT8j7Xmld+ npoHJQgfR1yQ3jzoK2NqZ/TNd7QZaia+qHQYiKXkllh4/ittIVZYajlefXyaK3cD jaQ5bZ8WtKsf58+BsNx80zMnYgMieLQD5VOqNFoqeGoWr+z8A8elEA2XaXhwB3h/ un8PdDxnbIprFBK7C78SBCPpUMFQOjI3y6eLo3Y4lZPat4be0k5raZ6xwE2W5XTG PDYqav3vDhltk3BndsaomcK0HWkAAjpIJNLa4JFyI+PcVAAXOdpyBn/vJydXKrKG 1COaqb8Bc9/rEEdJfe0T3bXsdZScluKrhsckcYA3HblR5oGevhE90RMUDje483A5 /i5waI1/PwKey14paUx4tuxuWzmTfmJRlIydpF95HllVFW4WeOIUTFqCnvPuWpQi PEoJ0shQcf+F1e9kKTnQfsEOp1SOpinMKsB3lCj4PWZaRAiEpNWx4LEW7S5ul5QI IjsDrAFFn/rQaIA5IbHPH6GZ8Ih31H95q0x7sVpJRqVlebJ6MHFW+NL5Ee1aOayb nlKGgTLoKt/DkUi9aM6VRXU7VXHXngaYQtHy74NPPZB6L21xS3k= =xOFS -----END PGP SIGNATURE----- --aYrjF+tKt+ApYAdb--