Date: Thu, 6 Sep 2018 14:58:36 -0700
From: Michael Paquier <michael@paquier.xyz>
To: code@jeremyevans.net, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15367: Crash in pg_fe_scram_free when using foreign tables
Message-ID: <20180906215836.GP2726@paquier.xyz>
References: <153626613985.23143.4743626885618266803@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="58yjuNbz5lCTNNJH"
Content-Disposition: inline
In-Reply-To: <153626613985.23143.4743626885618266803@wrigleys.postgresql.org>
Precedence: bulk


--58yjuNbz5lCTNNJH
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, Sep 06, 2018 at 08:35:39PM +0000, PG Bug reporting form wrote:
> If necessary I can build a debug version of PostgreSQL and try using that in
> production so I can get a better backtrace if it crashes again. However,
> considering that the crash is rare in my environment, it's unlikely I will
> be able to produce a better backtrace for the error quickly.

That would be nice.  From what I can see this would be a race condition,
which is not obvious by looking at the code.  Testing with a two-node
deployment where the first node has a foreign table which connects to a
second node, using SCRAM authentication, holding the physical table,
then doing many foreign scans across many clients don't show any
problem.  Did libpq complain at some point in the session where the
crash happened about any error?
--
Michael

--58yjuNbz5lCTNNJH
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAluRowwACgkQnvQgOdby
QH1s8w//Qjtmh5wzP3dZcHWZN0givZkYnQOg0Tt6plf2PGm8BicYCsr2bDMvlCFB
JFHnAjjR+pmwqPZ9vJ4hRKFxfnSrYoGddnZ3L2px0QA7xFG9hlMraQgSgMHqEU3j
kIIpRSHvZup0sdzuMPAO32ckDB8IZ/FIoYlqVfwYWSiB925csex8jf+0k9LnZ22x
Azs2LyA8Z3Ab+HmE9hUmduahrHJ6cfzRFVTFQcZq6mX0jVg2eNpdwjzYsYo+9+Vh
FgANBI18vAT8Ay6hA4umhKr0lkKLW1V8+Ouf+q0xjaKGJonZtFhObvhomv9VPc42
A5jkV1RG3en78eq5YiAJxLqVYnhSMNPUKqAYpg9j0HdCiHOsI2gJwwbsIvinueG+
J6BJKmmUhFxeWy8S4tTOEp+TFgn6uYA7u9ZLDBuLSUKkIQ7HMzGM1QCgenr+xINF
uShh5dVJD5kEo1xyizB3cV4Lcdlct60AlxkSBbyjZhSDSdgEw/DJZHdWYJORxXHC
kD5UYQV0Qx7RgQPwOmH9p54rfYP1Rzrxo5WvseHsypUkhToffC1s6VrCLJaMS4g8
yBksuOFHJEFtxuQt2BEQ+zHU3rqTD/0r1xNCSVwevNf2/pX4Ru7nw5UcsuS3Glm5
YYgbJNrz9Fs/mTIa6P2gWu5IvweAY8tjsZlvVayPXqrSX/y0OxE=
=wiM9
-----END PGP SIGNATURE-----

--58yjuNbz5lCTNNJH--