Date: Tue, 19 Nov 2019 09:57:02 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Adam Scott <adam.c.scott@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16122: segfault pg_detoast_datum (datum=0x0) at fmgr.c:1833
 numrange query
Message-ID: <20191119005702.GA1614@paquier.xyz>
References: <16122-eb35bc248c806c15@postgresql.org>
 <20191118045020.GC1543@paquier.xyz>
 <CA+s62-PWUgGJ7XaXnvFEcT9FeeVjHwojjtzP3i7LeuuoLDxZ+g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="HcAYCG3uE/tztfnV"
Content-Disposition: inline
In-Reply-To: 
 <CA+s62-PWUgGJ7XaXnvFEcT9FeeVjHwojjtzP3i7LeuuoLDxZ+g@mail.gmail.com>
Precedence: bulk


--HcAYCG3uE/tztfnV
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Nov 18, 2019 at 02:51:25PM -0800, Adam Scott wrote:
>> Did you see that after updating to 10.11.  If you used 10.10 or
>> an older version, did the problem happen?
>
> Originally this first was discovered on Centos 7, PG 10.10, then loaded t=
he
> 40gb table on 10.11 on Ubuntu.

Which means that prior 10.9 you used this query, but did not notice
anything?  Or is 10.10 the first version in the 10.X series you used?

>> Seeing the plan of your query may help as well.  Could you run EXPLAIN
>> on it or does it crash before?  Perhaps a parallel plan is involved
>> here?
> Explain plan works fine with no crash

I was also wondering about the shape of the plan selected here.  The
crash happens when doing some selectivity on the clause when working
on a plan, but it could help.

> I've done a binary search to find out where the error occurs in the data,
> but no luck.  It seems intermittent now.  Finally, I was able to reproduce
> the error repeatably with a blank table:
>=20
> Stop and start postgres from fresh, and then run this query (notice, I
> removed a sarg from the originally supplied query):
> select id from natica_hdu_test
> WHERE
> "dec_range" <@ '[88.9999998611111,90.0000001388889)';

Thanks.  I can see that you have provided a dump on the other part of
the thread.  Let's continue from that.
--
Michael

--HcAYCG3uE/tztfnV
Content-Type: application/pgp-signature; name="signature.asc"

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3TPd4ACgkQnvQgOdby
QH0HDQ/+NRLwjf2E07rLkLKAZvD9SfrgrlxKzUCmNd1/bw2F1acQmePVyi3TRceJ
N+vR4eUoUeCAhPahpPd4AeNopMJ+xzOyq2rYzMOdwakenFqST5Fk8U3A4pwew9r0
G0CLJ0to6UNb99aynMmF+65sBnLYLkNf6fMoDmfGaXqKuYqKclSDfic/Mqyau4kI
7n4NDsXyA/wwBVVHp8ZeSE/GueNPH1ev5KvG5un4yVgdL0uaPb2DFoPxE1VbRz4L
vOglrDr7DEl6jHm8Cgp6PCooql+keTJ2DvMcRuA8R89eGGSmli7Yenm81+wx0dCs
zzeFZ4WQDqVH+6NEAXSmqgpPVoCsCPLo7BCVEuRuA4lkazQTR5l+oz/oelMnbGlt
7dxZ7N+sTZt/yRFM8tr8sJ9Hc2+U6kNSeeaBjxYIjvZdYdNt8GxN3v2sIYa9xbGQ
irRQD2M09IrRkco/w/4MYxgbCCNpAxcuMDTNE+Yn/fcoEDVCXGjfPie0buxICpHc
OXTlUhqHW0CPhWCjKWUJMymwQdMlJP/zffY0UHvwoxxbDJ4BbQzWPDWwyP0bSfOI
iEaG6TNUIBrxD2D6RMjGBQYgMl3Rkmedlpbl8h1Qsjvt+iPZfekww8x9/FGNs9iG
X9vEghPNfn+dURDN6IE9yRm0pO3/x8883uyEiw/YeIBroRr8Qik=
=fL55
-----END PGP SIGNATURE-----

--HcAYCG3uE/tztfnV--