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 1jMXPa-0002Zq-Pm for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Apr 2020 13:40:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jMXPZ-0007Ms-Bg for pgsql-bugs@arkaria.postgresql.org; Thu, 09 Apr 2020 13:40:05 +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 1jMXPZ-0007Ml-51 for pgsql-bugs@lists.postgresql.org; Thu, 09 Apr 2020 13:40:05 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jMXPW-0002YO-Qh for pgsql-bugs@lists.postgresql.org; Thu, 09 Apr 2020 13:40:04 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 039De0aA027447; Thu, 9 Apr 2020 09:40:00 -0400 From: Tom Lane To: Johannes Mols cc: Michael Paquier , Hamid Akhtar , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16351: PostgreSQL closing connection during requests with segmentation fault In-reply-to: References: <16351-5cac06fa29fc19e1@postgresql.org> <1650.1586355059@sss.pgh.pa.us> <20200409014835.GN1606@paquier.xyz> Comments: In-reply-to Johannes Mols message dated "Thu, 09 Apr 2020 11:35:43 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <27445.1586439600.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 09 Apr 2020 09:40:00 -0400 Message-ID: <27446.1586439600@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Johannes Mols writes: > I did, but I'm unable to do so. The wiki asks me to enable debug package= s > as described here: https://wiki.ubuntu.com/DebuggingProgramCrash > I then found the postgresql-10-dbg package here: > https://www.ubuntuupdates.org/package/postgresql/trusty-pgdg/main/base/p= ostgresql-10-dbg > ... > The following packages have unmet dependencies: > postgresql-10-dbg : Depends: postgresql-10 (=3D 10.8-1.pgdg14.04+1) but > 10.12-0ubuntu0.18.04.1 is to be installed That's the wrong repo, evidently. You got the code from the PGDG repository, so you need to get the matching debug-symbol package from the same place. I gather you don't have the PGDG repo enabled by default. I'm not a debian/ubuntu person so I'm not sure about the exact commands to enable a non-default repo for apt-get. It looks like there may be a version skew problem as well. 10.12 is the latest v10 release, 10.8 is, um, not. If you are still on 10.8 then it would behoove you to first update to 10.12 and see if maybe we already fixed the bug. In any case, you have to find a debug-symbol package that *exactly* matches your installed code, or it's worthless. regards, tom lane