Re: PostgreSQL 12 crash with segmentation violation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Marcel Ruff <ruff(at)netwake(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL 12 crash with segmentation violation
Date: 2019-11-04 14:24:48
Message-ID: 32521.1572877488@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> On 2019-Nov-04, Marcel Ruff wrote:
>> Now I have upgraded to postgresql 12 and get a crash about once per day,
>> ...
>> How can I track down the problem?

> The first you need to do is obtain a crash dump. This page may help:

> https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Getting_a_trace_from_a_reproducibly_crashing_backend

Also, as long as you're building from source anyway, you might pull down
v12 branch tip from our git repo, or use a nightly snapshot tarball [1]
to see if the problem's already fixed.

regards, tom lane

[1] https://www.postgresql.org/ftp/snapshot/12/

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message LM 2019-11-05 14:35:01 explain statements question
Previous Message Alvaro Herrera 2019-11-04 12:37:53 Re: PostgreSQL 12 crash with segmentation violation