Re: BUG #16351: PostgreSQL closing connection during requests with segmentation fault

I did, but I'm unable to do so. The wiki asks me to enable debug packages
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/postgresql-10-dbg
However, when I try to install it I get the following error:

ubuntu(at)vm:~$ sudo apt-get install postgresql-10-dbg
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
postgresql-10-dbg : Depends: postgresql-10 (= 10.8-1.pgdg14.04+1) but
10.12-0ubuntu0.18.04.1 is to be installed
E: Unable to correct problems, you have held broken packages.

I can't make a lot of sense of that, since: postgresql-10 is already the
newest version (10.12-0ubuntu0.18.04.1).
It might just be me not being very knowledgeable with Linux, but the
instructions to install all of this and finally get a stack trace are not
clear to me at all.
I would really like to get to the bottom of this since the database is now
also closing connections with my data collection services in the middle of
transactions.

About your question about the version: 10.12 is the first and only version
I have installed. When I installed it about a month ago, this was the
newest version, at least from the instructions that I looked at.
Should I try to upgrade to 12.x?

Best regards,
Johannes

On Thu, Apr 9, 2020 at 3:48 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:

> On Wed, Apr 08, 2020 at 04:58:04PM +0200, Johannes Mols wrote:
> > I've tried to that but I'm unfortunately struggling to install the debug
> > symbols (https://wiki.ubuntu.com/DebuggingProgramCrash).
> > I can't seem to figure out how to do this. Is there any guide that is
> > easier to understand for someone who isn't crazy knowledgeable about
> Linux?
> > I would really like to provide you with the information you need, I have
> no
> > idea how to solve this myself and if it is a bug or if something went
> wrong
> > on my end.
>
> Did you try to install the debug symbols using the commands on the
> wiki and what kind of failure did you see then? When it comes to
> Ubuntu and Debian, there are a set of -debug RPMs which can be
> installed to introduce all the debug symbols which are needed to get a
> clear stack trace from a Postgres backend. Also, your bug report
> mentions Postgres 10.12. Is that a new issue with this minor version?
> Were things working as you expected with older versions?
> --
> Michael
>