Re: [BUGS] Segmentation fault mayhem - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: [BUGS] Segmentation fault mayhem
Date
Msg-id CAH2-Wz=LRzrL5ep+cQhSB_7394PCzxrxsFbRqTY5Qzt21F6yCg@mail.gmail.com
Whole thread Raw
In response to [BUGS] Segmentation fault mayhem  (Sebastian Gröbler<sebastian.groebler@quandoo.com>)
List pgsql-bugs
On Mon, Sep 25, 2017 at 11:19 AM, Sebastian Gröbler
<sebastian.groebler@quandoo.com> wrote:
> The selected table has about a million records and there is no index on the
> fields in the where clause.
> The pnc_type is a custom type, pnc_reference_id is a varchar(50) and
> pnc_mdi_id is a uuid.
> Running the query we were not able to reproduce the problem but we saw that
> postgres would use the parallel query feature.

This was fixed in the latest point release:

"Prevent crash when passing fixed-length pass-by-reference data types
to parallel worker processes (Tom Lane)"

I'm less sure about the other one, but it seems likely that it was
fixed, too (I recall bugs in this area that I was less involved in
fixing).

You should be keeping up with the latest point release if at all possible.

--
Peter Geoghegan


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Sebastian Gröbler
Date:
Subject: [BUGS] Segmentation fault mayhem
Next
From: Andres Freund
Date:
Subject: Re: [BUGS] Segmentation fault mayhem