Re: [BUGS] Segfault 11 on PG10 with max_parallel_workers_per_gather>3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] Segfault 11 on PG10 with max_parallel_workers_per_gather>3
Date
Msg-id 23727.1508964117@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] Segfault 11 on PG10 with max_parallel_workers_per_gather>3  (Stefan Tzeggai <tzeggai@empirica-systeme.de>)
Responses Re: [BUGS] Segfault 11 on PG10 with max_parallel_workers_per_gather>3  (Stefan Tzeggai <tzeggai@empirica-systeme.de>)
Re: [BUGS] PG10 Segfault 11 on default Ubuntu 16.04 installs  (Stefan Tzeggai <tzeggai@empirica-systeme.de>)
List pgsql-bugs
Stefan Tzeggai <tzeggai@empirica-systeme.de> writes:
> I also tried to get a sensible stack trace. I attached 9 gdb to all
> postgres-pids and when I triggered the crash, two of the gdb had some
> output and produced something on 'bt'. Attached..

Those look like normal operation --- SIGUSR1 isn't a crash condition,
it's what PG normally uses to wake up a sleeping process.  If you
want to attach gdb before provoking the crash, you need to tell it
to ignore SIGUSR1 (I think "handle SIGUSR1 pass nostop noprint"
is the right incantation).

It might be easier to enable core files ("ulimit -c unlimited" before
starting the postmaster) and then gdb the core files.

> If I would be able to dump the relevant data from my db and I would be
> able to reproduce the crash with it on a fresh PG10 install - Would
> anyone have time to look at it? I guess its would no more than 50Mb...

Sure, I or somebody else would look at it.
        regards, tom lane


-- 
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: Stefan Tzeggai
Date:
Subject: Re: [BUGS] Segfault 11 on PG10 with max_parallel_workers_per_gather>3
Next
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14872: libpq requires a home directory