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 1iftOK-000535-PJ for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Dec 2019 22:26:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iftOI-0008CU-Qw for pgsql-bugs@arkaria.postgresql.org; Fri, 13 Dec 2019 22:26:30 +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 1ifmVi-0007DB-U2 for pgsql-bugs@lists.postgresql.org; Fri, 13 Dec 2019 15:05:44 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ifmVf-0005C6-K4 for pgsql-bugs@lists.postgresql.org; Fri, 13 Dec 2019 15:05:41 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 2B622224EC; Fri, 13 Dec 2019 10:05:38 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 13 Dec 2019 10:05:38 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fastmail.com; h= from:to:cc:subject:references:date:in-reply-to:message-id :mime-version:content-type; s=fm1; bh=zAnIMGQR/9DKoP6IvEgmGXkHim ns+o2joTHBcYgQk5k=; b=tmXRDExzm0YG6YG9mkCqaic9Tm0uevj/GYojmmk3oK WL5lM+IJh7cxJDkyoQcveHYoM2IvX+Wv2+uJ5YmEM61zOR0jnLZOimmFDrAJeC3S 8R5F75uP28xqJjVH0InDbbS+I22n7csNLqiNOoJvVU339EKaT89mAhsbTAeLdjIX MwVni1RFqdt1TazCQhvjwWR51y97r1CbcC+SL10hepHHMzcrwbkyr1AV6Ck0d338 obf6gHu6fCJ6npE2+1ma2PU3hXxgTTw5cyeOnNdirY7t6N19BeY19C7MYI2TS4my 80iQjA9s6RRuxS4z/oeatVsuWGWma0EXv4YujhZ8cfGQ== 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=zAnIMG QR/9DKoP6IvEgmGXkHimns+o2joTHBcYgQk5k=; b=AiXcLfmLidFGXaMs54L5G7 yEWhyqiiPOxX8Mk/2hC7xXvaTQIJ3JdpvlyEuk+F3t2cYwEbwVIZ80lyBN4uX33K tQHTuSTDCl/VASxtS0eg7azTASNnk30Zzzo+d+AMyLT7FeZIQbZT7uaMdIxfL0kq m5NtJBTohcpfDJ5XJUdPsro5OeSEBhJvkS4Iqd/TO4eUh2zA4S2l4KtNuOaZwuRo 9TnOPKwk+QeHG0MH+4cYH6zUhKN77wHfOMG/YrRhCyeP/KAhDO20GMRNo6xn/xYo aSo9IeJVF4lWJvNYuuMaAcbTB5DS4o9SCTQVMv3hl62bJt6axgs02UCEJYJL9Dmw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudelledgjedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdludegmdenucfjughrpefhvffufhffjgfkfgggtgesthdttddttder shenucfhrhhomhepkhhjohhntggrsehfrghsthhmrghilhdrtghomhculdfmrghmihhluc flohnktggrmdenucffohhmrghinhepfiholhhnvghlvghkthhurhihrdhplhdpphhoshht ghhrvghsqhhlrdhorhhgnecukfhppedujeekrddvfeehrdehhedrudeifeenucfrrghrrg hmpehmrghilhhfrhhomhepkhhjohhntggrsehfrghsthhmrghilhdrtghomhenucevlhhu shhtvghrufhiiigvpedt X-ME-Proxy: Received: from alfa.kjonca (178235055163.warszawa.vectranet.pl [178.235.55.163]) by mail.messagingengine.com (Postfix) with ESMTPA id 860B08005C; Fri, 13 Dec 2019 10:05:37 -0500 (EST) Received: from kjonca by alfa.kjonca with local (Exim 4.93) (envelope-from ) id 1ifmVa-001c8V-U4; Fri, 13 Dec 2019 16:05:35 +0100 From: kjonca@fastmail.com (Kamil =?iso-8859-2?Q?Jo=F1ca?=) To: Tom Lane Cc: Michael Paquier , pgsql-bugs@lists.postgresql.org Subject: Re: Random crashes - segmentation fault References: <871rucdwkt.fsf@alfa.kjonca> <20191113125832.GZ1549@paquier.xyz> <87tv77digm.fsf@alfa.kjonca> <6161.1573657623@sss.pgh.pa.us> Date: Fri, 13 Dec 2019 16:05:34 +0100 In-Reply-To: <6161.1573657623@sss.pgh.pa.us> (Tom Lane's message of "Wed, 13 Nov 2019 10:07:03 -0500") Message-ID: <87r218z2o1.fsf@alfa.kjonca> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Tom Lane writes: > kjonca@fastmail.com (Kamil =?iso-8859-2?Q?Jo=F1ca?=) writes: >> Michael Paquier writes: >>> Could it be possible to see a backtrace of the crash? There is > >> Erm. Only thing I can do is to configure for debug future crashes. Could you >> tell me what and how to configure to get backtrace? > > There's some accumulated wisdom at > > https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend > > I'd suggest that before worrying about that, you should install 12.1 > (official release is tomorrow) and see if the crashes go away. There's > not much info in this report, but it could match any of several > already-fixed bugs. > 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" TRAP: FailedAssertion("!(result->tdrefcount == -1)", File: "/build/postgresql-12-123lrX/postgresql-12-12.1/build/../src/backend/utils/cache/typcache.c", Line: 2621) --8<---------------cut here---------------end--------------->8--- I have core dump. KJ > regards, tom lane > -- http://wolnelektury.pl/wesprzyj/teraz/