I did, but I'm unable to do so. The wiki asks me to enable debug packages as described here:
https://wiki.ubuntu.com/DebuggingProgramCrashHowever, when I try to install it I get the following error:
ubuntu@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 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