Horton

Re: [sqlsmith] Unpinning error in parallel worker

Jonathan Rudenberg <jonathan@titanous.com>

View thread View on postgr.es
From: Jonathan Rudenberg <jonathan@titanous.com>
To: Thomas Munro <thomas.munro@enterprisedb.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Andreas Seltenreich <seltenreich@gmx.de>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-04-17T23:43:50Z
Lists: pgsql-hackers

Attachments

On Tue, Apr 17, 2018, at 19:31, Thomas Munro wrote:
> On Wed, Apr 18, 2018 at 11:01 AM, Jonathan Rudenberg
> <jonathan@titanous.com> wrote:
> > On Tue, Apr 17, 2018, at 18:38, Thomas Munro wrote:
> >> Thanks, that would be much appreciated, as would any clues about what
> >> workload you're running.  Do you know what the query plan looks like
> >> for the queries that crashed?
> >
> > Yep, I think I know approximately what it looked like, I've attached a lightly redacted plan. All of the hung queries were running some variant of this plan as far as I can tell.
> 
> Hmm, that isn't a parallel query.  I was expecting to see "Gather" and
> "Parallel" in there.

Oops, I'm really sorry about that. I only have the first part of the hung queries, and there are a few variants. Here's one that's parallel.

Commits

  1. Use English, instead of internal names, for translatable messages.

  2. Plug race in dsa_attach.