Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fAkjm-0002vA-25 for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Apr 2018 23:19:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fAkjj-0004Rz-ND for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Apr 2018 23:19:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fAkjj-0004Rp-Fw for pgsql-hackers@lists.postgresql.org; Mon, 23 Apr 2018 23:19:07 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fAkjb-0003hQ-Og for pgsql-hackers@lists.postgresql.org; Mon, 23 Apr 2018 23:19:06 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id BC7FD5F79C; Mon, 23 Apr 2018 19:18:55 -0400 (EDT) Date: Mon, 23 Apr 2018 19:18:55 -0400 From: Stephen Frost To: Tom Lane Cc: pgsql-hackers@lists.postgresql.org Subject: Re: "could not reattach to shared memory" on buildfarm member dory Message-ID: <20180423231855.GK27724@tamriel.snowman.net> References: <25495.1524517820@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="cNJ0mG4Q6+QCvBh5" Content-Disposition: inline In-Reply-To: <25495.1524517820@sss.pgh.pa.us> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --cNJ0mG4Q6+QCvBh5 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Tom Lane (tgl@sss.pgh.pa.us) wrote: > So far, dory has failed three times with essentially identical symptoms: >=20 > 2018-04-23 19:57:10.624 GMT [2240] FATAL: could not reattach to shared m= emory (key=3D0000000000000190, addr=3D00000000018E0000): error code 487 > 2018-04-23 15:57:10.657 EDT [8836] ERROR: lost connection to parallel wo= rker > 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 work= er" (PID 2240) exited with exit code 1 >=20 > 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 --cNJ0mG4Q6+QCvBh5 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJa3mnfAAoJEO1sijiDR2RVnOMP/RQiTwtWcHIT54P1i/NF2HgR GFMauzhSPsbpuHFUZeRWPINYYQbdFRP9kQI5yIr8I6YCWV1x4EPLEuJ0Qy1bDGGJ dDPR3sueFXUDceUHhz9jkpgg0u4s/4em9gfT9e1wP4Oiv8zjWBTcIHjVSXa0Ex/n JeRYp8Fl0xt2A5J1bwDdD6l+BkC1N0M/MrUCK2jAl59GRUOfZmi0QLf6x/p+7OAh rjfAYNpkHBAN6y+sm1v8txGjMBYQ1PyKsSmj2MHpwx+1SQ42K4+9vhiqObB9HC3j Sy90oAuYX8h5rVXD7LKefBsS3IRmpTD/CBn9+gBG6H9KmFObnc7425PqVkL10JH9 IAmveoicjzNaQqiIFGR+kFMrAH5f12YhloS2/BX0EwL/rprWj1fXf0XQzXqYo07l Cc7aD1XZlf/IZB6lItUqkL4P9ep7EBiDa91dc3XQFn8FNDJEAr7h/FXSgUEn7Oi0 0u3CXSNsIPeTZKRerHJ1e8V4BNXfZEnbyNLelIvSkI7URs3k1M59rxgrkv3uk4+E 6AggeYhQSjtMgT7m4qRITiNRjE6uhCA91YMu80g2nMUMJ8XB7CLVu3q+EZrZ/EmS fdISA6Fz0BuPZvc/uJgKC5p8OX5xyRwRc97tG5bG5/GWi/ZV/cjZvz72nE1iiQGO uZeQckJz08/SC41zJbS/ =cbiw -----END PGP SIGNATURE----- --cNJ0mG4Q6+QCvBh5--