Re: BUG #16351: PostgreSQL closing connection during requests withsegmentation fault
| От | Johannes Mols |
|---|---|
| Тема | Re: BUG #16351: PostgreSQL closing connection during requests withsegmentation fault |
| Дата | |
| Msg-id | CAOiYe5sAtdkAUxBCjvPt1jywqizGEubXBmcnxtiW9335hSGE+Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #16351: PostgreSQL closing connection during requests withsegmentation fault (Michael Paquier <michael@paquier.xyz>) |
| Ответы |
Re: BUG #16351: PostgreSQL closing connection during requests with segmentation fault
Re: BUG #16351: PostgreSQL closing connection during requests with segmentation fault |
| Список | pgsql-bugs |
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:
I can't make a lot of sense of that, since: postgresql-10 is already the newest version (10.12-0ubuntu0.18.04.1).ubuntu@vm:~$ sudo apt-get install postgresql-10-dbgReading package lists... DoneBuilding dependency treeReading state information... DoneSome packages could not be installed. This may mean that you haverequested an impossible situation or if you are using the unstabledistribution that some required packages have not yet been createdor 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 installedE: Unable to correct problems, you have held broken packages.
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@paquier.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
В списке pgsql-bugs по дате отправления: