From: Stephen Frost <sfrost@snowman.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: "could not reattach to shared memory" on buildfarm member dory
Date: Mon, 23 Apr 2018 19:18:55 -0400
Message-ID: <20180423231855.GK27724@tamriel.snowman.net> (raw)
In-Reply-To: <25495.1524517820@sss.pgh.pa.us>
References: <25495.1524517820@sss.pgh.pa.us>
Greetings,
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> So far, dory has failed three times with essentially identical symptoms:
>
> 2018-04-23 19:57:10.624 GMT [2240] FATAL: could not reattach to shared memory (key=0000000000000190, addr=00000000018E0000): error code 487
> 2018-04-23 15:57:10.657 EDT [8836] ERROR: lost connection to parallel worker
> 2018-04-23 15:57:10.657 EDT [8836] STATEMENT: select count(*) from tenk1 group by twenty;
> 2018-04-23 15:57:10.660 EDT [3820] LOG: background worker "parallel worker" (PID 2240) exited with exit code 1
>
> Now how can this be? We've successfully reserved and released the address
> range we want to use, so it *should* be free at the instant we try to map.
Yeah, that's definitely interesting.
> I guess the good news is that we're seeing this in a reasonably
> reproducible fashion, so there's some hope of digging down to find
> out the actual cause.
I've asked Heath to take a look at the system again and see if there's
any Windows logs or such that might help us understand what's happening.
AV was disabled on the box, so don't think it's that, at least.
Thanks!
Stephen
Attachments:
[application/pgp-signature] signature.asc (818B, ../20180423231855.GK27724@tamriel.snowman.net/2-signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: sfrost@snowman.net, tgl@sss.pgh.pa.us, pgsql-hackers@lists.postgresql.org
Subject: Re: "could not reattach to shared memory" on buildfarm member dory
In-Reply-To: <20180423231855.GK27724@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox