Postgres segfaults on raster query
Scott
public at postholer.com
Thu Jan 18 22:12:07 PST 2024
Thanks for the tip! I found the root of the problem.
When I ran pg_config it returned config info for pg 15. That's great,
but this db is running on pg 13!
Not long ago, apt upgrade added pg 15, which I did not want. I thought I
removed, purged it. Apparently not.
I just physically moved the /usr/lib/postgresql/15. Now pg_config
returns pg 13 info.
Obviously, there was no postgis installed on pg 15.
pg_config is returning the correct info...now. Restarted the db and all
is well.
On 1/18/24 21:06, Regina Obe wrote:
>> This seems… odd to me? In what context is putting postgis into the preload a
>> requirement?
>>
>> P
>>
>>> On Jan 18, 2024, at 8:20 PM, Scott <public at postholer.com> wrote:
>>>
>>> Bam!
>>>
>>> That was it. Thanks Regina, you rock!
>>>
>>> On 1/18/24 20:16, Regina Obe wrote:
>>>> ALTER SYSTEM SET shared_preload_libraries = 'postgis-3';
>
> The only time I've seen it be a requirement is with mobilitydb, where they are relying on the postgis-3 library to be already loaded and are dynamically linking to it.
> I recall I used to see reference to the postgis-3 when I'd do
>
> ldd /usr/lib/postgresql/16/lib/libMobilityDB-1.1.so
> When it's not preloaded, mobilitydb crashes in a similar fashion which is why I thought about this.
> Though I'm not seeing reference to that anymore though (or maybe I only saw is on windows), but it still relies on postgis-3 to load.
>
> So when Scott said it works if he runs postgis_full_version() before hand, got me thinking, it must be relying on postgis already loaded and postgis_full_version() loads postgis lib first.
>
> But for postgis_raster that should not be required, since postgis_raster has the liblwgeom baked into it so it never links directly to postgis-3 or at least shouldn't be.
>
> @Scott,
>
> Can you run an ldd check on your postgis_raster-3?
>
> If you don't know where it is
>
> pg_config | grep PKGLIBDIR
>
> Should tell you the folder
>
> Mine looks like below -- verify you don't have reference to postgis-3.so
>
> ldd /usr/lib/postgresql/16/lib/postgis_raster-3.so
>
> linux-vdso.so.1 (0x00007ffd7efda000)
> libgdal.so.34 => /lib/x86_64-linux-gnu/libgdal.so.34 (0x00007f73f3b59000)
> libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 (0x00007f73f3b0c000)
> libproj.so.25 => /lib/x86_64-linux-gnu/libproj.so.25 (0x00007f73f370b000)
> libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f73f362c000)
> libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f73f344a000)
> libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f73f342b000)
> libcurl-gnutls.so.4 => /lib/x86_64-linux-gnu/libcurl-gnutls.so.4 (0x00007f73f336e000)
> libodbc.so.2 => /lib/x86_64-linux-gnu/libodbc.so.2 (0x00007f73f32fd000)
> libodbcinst.so.2 => /lib/x86_64-linux-gnu/libodbcinst.so.2 (0x00007f73f32e5000)
> libxml2.so.2 => /lib/x86_64-linux-gnu/libxml2.so.2 (0x00007f73f3133000)
> libcrypto.so.3 => /lib/x86_64-linux-gnu/libcrypto.so.3 (0x00007f73f2cac000)
> liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007f73f2c7c000)
> libdeflate.so.0 => /lib/x86_64-linux-gnu/libdeflate.so.0 (0x00007f73f2c66000)
> liblz4.so.1 => /lib/x86_64-linux-gnu/liblz4.so.1 (0x00007f73f2c40000)
> libblosc.so.1 => /lib/x86_64-linux-gnu/libblosc.so.1 (0x00007f73f2c30000)
> libarmadillo.so.12 => /lib/libarmadillo.so.12 (0x00007f73f2c1e000)
> libqhull_r.so.8.0 => /lib/x86_64-linux-gnu/libqhull_r.so.8.0 (0x00007f73f2ba8000)
> libxerces-c-3.2.so => /lib/x86_64-linux-gnu/libxerces-c-3.2.so (0x00007f73f280d000)
> libjpeg.so.62 => /lib/x86_64-linux-gnu/libjpeg.so.62 (0x00007f73f2778000)
> libtiff.so.6 => /lib/x86_64-linux-gnu/libtiff.so.6 (0x00007f73f26eb000)
> libgeotiff.so.5 => /lib/x86_64-linux-gnu/libgeotiff.so.5 (0x00007f73f26b5000)
> libheif.so.1 => /lib/x86_64-linux-gnu/libheif.so.1 (0x00007f73f25dc000)
> libpng16.so.16 => /lib/x86_64-linux-gnu/libpng16.so.16 (0x00007f73f25a6000)
> libzstd.so.1 => /lib/x86_64-linux-gnu/libzstd.so.1 (0x00007f73f24e5000)
> libaec.so.0 => /lib/x86_64-linux-gnu/libaec.so.0 (0x00007f73f24d9000)
> libpoppler.so.126 => /lib/x86_64-linux-gnu/libpoppler.so.126 (0x00007f73f2144000)
> libgif.so.7 => /lib/x86_64-linux-gnu/libgif.so.7 (0x00007f73f2139000)
> libnetcdf.so.19 => /lib/x86_64-linux-gnu/libnetcdf.so.19 (0x00007f73f1f3d000)
> libcfitsio.so.10 => /lib/x86_64-linux-gnu/libcfitsio.so.10 (0x00007f73f1c21000)
> libhdf5_serial.so.103 => /lib/x86_64-linux-gnu/libhdf5_serial.so.103 (0x00007f73f1868000)
> libwebp.so.7 => /lib/x86_64-linux-gnu/libwebp.so.7 (0x00007f73f17e9000)
> libsqlite3.so.0 => /lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007f73f1679000)
> libpq.so.5 => /lib/x86_64-linux-gnu/libpq.so.5 (0x00007f73f1622000)
> libopenjp2.so.7 => /lib/x86_64-linux-gnu/libopenjp2.so.7 (0x00007f73f15be000)
> libkmlbase.so.1 => /lib/x86_64-linux-gnu/libkmlbase.so.1 (0x00007f73f15a1000)
> libkmldom.so.1 => /lib/x86_64-linux-gnu/libkmldom.so.1 (0x00007f73f14ff000)
> libkmlengine.so.1 => /lib/x86_64-linux-gnu/libkmlengine.so.1 (0x00007f73f14c5000)
> libfyba.so.0 => /lib/x86_64-linux-gnu/libfyba.so.0 (0x00007f73f146d000)
> libpcre2-8.so.0 => /lib/x86_64-linux-gnu/libpcre2-8.so.0 (0x00007f73f13d2000)
> libspatialite.so.8 => /lib/x86_64-linux-gnu/libspatialite.so.8 (0x00007f73f0c2c000)
> libmariadb.so.3 => /lib/x86_64-linux-gnu/libmariadb.so.3 (0x00007f73f0bd6000)
> libfreexl.so.1 => /lib/x86_64-linux-gnu/libfreexl.so.1 (0x00007f73f0bc5000)
> libogdi.so.4.1 => /lib/libogdi.so.4.1 (0x00007f73f0ba6000)
> libexpat.so.1 => /lib/x86_64-linux-gnu/libexpat.so.1 (0x00007f73f0b7b000)
> libjson-c.so.5 => /lib/x86_64-linux-gnu/libjson-c.so.5 (0x00007f73f0b68000)
> libdfalt.so.0 => /lib/libdfalt.so.0 (0x00007f73f0ac0000)
> libmfhdfalt.so.0 => /lib/libmfhdfalt.so.0 (0x00007f73f0a97000)
> libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f73f0841000)
> libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f73f081b000)
> /lib64/ld-linux-x86-64.so.2 (0x00007f73f5604000)
> libgeos.so.3.13.0 => /usr/local/lib/libgeos.so.3.13.0 (0x00007f73f0501000)
> libnghttp2.so.14 => /lib/x86_64-linux-gnu/libnghttp2.so.14 (0x00007f73f04d2000)
> libidn2.so.0 => /lib/x86_64-linux-gnu/libidn2.so.0 (0x00007f73f049f000)
> librtmp.so.1 => /lib/x86_64-linux-gnu/librtmp.so.1 (0x00007f73f0480000)
> libssh2.so.1 => /lib/x86_64-linux-gnu/libssh2.so.1 (0x00007f73f0438000)
> libpsl.so.5 => /lib/x86_64-linux-gnu/libpsl.so.5 (0x00007f73f0424000)
> libnettle.so.8 => /lib/x86_64-linux-gnu/libnettle.so.8 (0x00007f73f03d2000)
> libgnutls.so.30 => /lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007f73f01b9000)
> libgssapi_krb5.so.2 => /lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007f73f0166000)
> libldap-2.5.so.0 => /lib/x86_64-linux-gnu/libldap-2.5.so.0 (0x00007f73f0107000)
> liblber-2.5.so.0 => /lib/x86_64-linux-gnu/liblber-2.5.so.0 (0x00007f73f00f5000)
> libbrotlidec.so.1 => /lib/x86_64-linux-gnu/libbrotlidec.so.1 (0x00007f73f00e7000)
> libltdl.so.7 => /lib/x86_64-linux-gnu/libltdl.so.7 (0x00007f73f00dc000)
> libicuuc.so.72 => /lib/x86_64-linux-gnu/libicuuc.so.72 (0x00007f73efed7000)
> libsnappy.so.1 => /lib/x86_64-linux-gnu/libsnappy.so.1 (0x00007f73efecb000)
> libblas.so.3 => /lib/x86_64-linux-gnu/libblas.so.3 (0x00007f73efe5b000)
> liblapack.so.3 => /lib/x86_64-linux-gnu/liblapack.so.3 (0x00007f73ef75b000)
> libarpack.so.2 => /lib/x86_64-linux-gnu/libarpack.so.2 (0x00007f73ef711000)
> libsuperlu.so.6 => /lib/x86_64-linux-gnu/libsuperlu.so.6 (0x00007f73ef69b000)
> libLerc.so.4 => /lib/x86_64-linux-gnu/libLerc.so.4 (0x00007f73ef602000)
> libjbig.so.0 => /lib/x86_64-linux-gnu/libjbig.so.0 (0x00007f73ef5ef000)
> libsharpyuv.so.0 => /lib/x86_64-linux-gnu/libsharpyuv.so.0 (0x00007f73ef5e7000)
> libfreetype.so.6 => /lib/x86_64-linux-gnu/libfreetype.so.6 (0x00007f73ef51b000)
> libfontconfig.so.1 => /lib/x86_64-linux-gnu/libfontconfig.so.1 (0x00007f73ef4d0000)
> liblcms2.so.2 => /lib/x86_64-linux-gnu/liblcms2.so.2 (0x00007f73ef46d000)
> libnss3.so => /lib/x86_64-linux-gnu/libnss3.so (0x00007f73ef30e000)
> libsmime3.so => /lib/x86_64-linux-gnu/libsmime3.so (0x00007f73ef2df000)
> libplc4.so => /lib/x86_64-linux-gnu/libplc4.so (0x00007f73ef2d8000)
> libnspr4.so => /lib/x86_64-linux-gnu/libnspr4.so (0x00007f73ef296000)
> libhdf5_serial_hl.so.100 => /lib/x86_64-linux-gnu/libhdf5_serial_hl.so.100 (0x00007f73ef272000)
> libbz2.so.1.0 => /lib/x86_64-linux-gnu/libbz2.so.1.0 (0x00007f73ef25d000)
> libcurl.so.4 => /lib/x86_64-linux-gnu/libcurl.so.4 (0x00007f73ef19d000)
> libsz.so.2 => /lib/x86_64-linux-gnu/libsz.so.2 (0x00007f73ef198000)
> libssl.so.3 => /lib/x86_64-linux-gnu/libssl.so.3 (0x00007f73ef0ed000)
> libminizip.so.1 => /lib/x86_64-linux-gnu/libminizip.so.1 (0x00007f73ef0df000)
> liburiparser.so.1 => /lib/x86_64-linux-gnu/liburiparser.so.1 (0x00007f73ef0c4000)
> libfyut.so.0 => /lib/x86_64-linux-gnu/libfyut.so.0 (0x00007f73ef0b9000)
> libfygm.so.0 => /lib/x86_64-linux-gnu/libfygm.so.0 (0x00007f73ef0b0000)
> librttopo.so.1 => /lib/x86_64-linux-gnu/librttopo.so.1 (0x00007f73ef03b000)
> libtirpc.so.3 => /lib/x86_64-linux-gnu/libtirpc.so.3 (0x00007f73ef00c000)
> libunistring.so.5 => /lib/x86_64-linux-gnu/libunistring.so.5 (0x00007f73eee5a000)
> libhogweed.so.6 => /lib/x86_64-linux-gnu/libhogweed.so.6 (0x00007f73eee11000)
> libgmp.so.10 => /lib/x86_64-linux-gnu/libgmp.so.10 (0x00007f73eed8d000)
> libp11-kit.so.0 => /lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007f73eebef000)
> libtasn1.so.6 => /lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007f73eebda000)
> libkrb5.so.3 => /lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007f73eeafc000)
> libk5crypto.so.3 => /lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007f73eeacf000)
> libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007f73eeac9000)
> libkrb5support.so.0 => /lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007f73eeabb000)
> libsasl2.so.2 => /lib/x86_64-linux-gnu/libsasl2.so.2 (0x00007f73eea9f000)
> libbrotlicommon.so.1 => /lib/x86_64-linux-gnu/libbrotlicommon.so.1 (0x00007f73eea7a000)
> libicudata.so.72 => /lib/x86_64-linux-gnu/libicudata.so.72 (0x00007f73ecca8000)
> libgfortran.so.5 => /lib/x86_64-linux-gnu/libgfortran.so.5 (0x00007f73ec9d5000)
> libnssutil3.so => /lib/x86_64-linux-gnu/libnssutil3.so (0x00007f73ec9a2000)
> libplds4.so => /lib/x86_64-linux-gnu/libplds4.so (0x00007f73ec99d000)
> libffi.so.8 => /lib/x86_64-linux-gnu/libffi.so.8 (0x00007f73ec98e000)
> libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007f73ec987000)
> libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f73ec976000)
>
> You also want to make sure the geos version it is linked to is the same as the geos version postgis-3 links to.
> Another thought I have is maybe it's relying on postgis for the geos, which is different from the one GDAL is compiled with.
> Not sure what happens in such a scenario. Because gdal brings in a dependency to GEOS and postgis_raster itself has a direct dependency to geos via the baked in liblwgeom.
>
>
More information about the postgis-users
mailing list