Re: [BUGS] signal 11 segfaults with parallel workers - Mailing list pgsql-bugs

From Amit Kapila
Subject Re: [BUGS] signal 11 segfaults with parallel workers
Date
Msg-id CAA4eK1JcGmgJw5qPKWAOB5K+K7GFSe+SJQ-OQQLf1tPjXtJiAg@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] signal 11 segfaults with parallel workers  (Rick Otten <rottenwindfish@gmail.com>)
List pgsql-bugs
On Mon, Jul 31, 2017 at 6:35 AM, Rick Otten <rottenwindfish@gmail.com> wrote:
> Ok, I got a core this time at 23:00 when the database went down.
> Here is the basic backtrace:
>
>
> The query that took it down this time (based on the pid reported in the
> stacktrace) does indeed spin out a parallel plan, but it is a simple query.
> I was surprised to see the multicorn library mentioned in this trace, it has
> nothing to do with the multicorn FDW installed on the system.
>

We load all the libraries in parallel workers which are loaded by the
main backend.  This is to ensure that master and worker backends have
exactly the same guc's defined in the worker.

> I've run the query several times in the last few minutes and can't get it to
> generate a core again.
>

Did the query take the parallel plan during execution?  The above
symptom shows that it should crash if you run the same query after
restarting the server.

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com


-- 
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: Rick Otten
Date:
Subject: Re: [BUGS] signal 11 segfaults with parallel workers
Next
From: Andres Freund
Date:
Subject: Re: [BUGS] signal 11 segfaults with parallel workers