Обсуждение: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -

Поиск
Список
Период
Сортировка

RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -

От
"Lorenz, Christopher"
Дата:
Hi,

since we have upgrade from postgis 2.4.6 to 2.4.7-3 of PostgreSQL 9.6. on our RHEL7 enviroment we have trouble with the
gdallibrary. There migth be a bug or  something. The Problem also appears with PostgreSQL 10. 

If we call Postgis_Full_Version() we get the folowing error:

FEHLER:  konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden: libgdal.so.20: Kann die
Shared-Object-Dateinicht öffnen: Datei oder Verzeichnis nicht gefunden 
(english: can't load libgdal.so.20 - File not found)

So I've checked the sharded libraries:

ldd /usr/pgsql-9.6/lib/rtpostgis-2.4.so
        linux-vdso.so.1 =>  (0x00007fffabb87000)
        libgdal.so.20 => not found
....

During the last update the new package was installed:
gdal23-libs.x86_64              2.3.2-7.rhel7
postgis24_96.x86_64             2.4.7-3.rhel7

but the path was not in librarypath,  so I added it manualy:
echo '/usr/gdal23/lib/' > /etc/ld.so.conf.d/fix-pgdg-gdal.conf
ldconfig
ldd /usr/pgsql-9.6/lib/rtpostgis-2.4.so  | grep gdal
        libgdal.so.20 => /usr/gdal23/lib/libgdal.so.20 (0x00007fecad2c8000)

Now I restartet the server but there is something more:

SELECT Postgis_Full_Version();
FEHLER:  konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden: /usr/gdal23/lib/libgdal.so.20: undefined
symbol:ecs_SetReportErrorFunction 

Is it a bug or misconfiguration myself?

When I downgrad to postgis24_96-2.4.6-4.rhel7.x86_64, everthing works fine, postgris uses 1.11

Regards,

Christopher Lorenz

Re: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4-

От
Devrim Gündüz
Дата:
Hi,

On Tue, 2019-06-25 at 09:34 +0000, Lorenz, Christopher wrote:
> since we have upgrade from postgis 2.4.6 to 2.4.7-3 of PostgreSQL 9.6. on our
> RHEL7 enviroment we have trouble with the gdal library. There migth be a bug
> or  something. The Problem also appears with PostgreSQL 10.
>
> If we call Postgis_Full_Version() we get the folowing error:
>
> FEHLER:  konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden:
> libgdal.so.20: Kann die Shared-Object-Datei nicht öffnen: Datei oder
> Verzeichnis nicht gefunden
> (english: can't load libgdal.so.20 - File not found)

I pushed gdal23 2.3.2-8 package to repositories, which fixes this issue.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Вложения

AW: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -

От
"Lorenz, Christopher"
Дата:
Hi Devrim,

Updating the packages to gdal23-libs-2.3.2-8 and postgis24_96-2.4.7-4 solved the problem with the missing
library/ldconfig.


The issue with the undefined symbol still exists with current packages on our systems:

select PostGIS_Full_Version();
FEHLER:  konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden: /usr/gdal23/lib/libgdal.so.20: undefined
symbol:ecs_SetReportErrorFunction
 
KONTEXT:  SQL-Anweisung »SELECT public.postgis_gdal_version()«

Regards,

Christopher Lorenz

-----Ursprüngliche Nachricht-----
Von: Devrim Gündüz <devrim@gunduz.org> 
Gesendet: Donnerstag, 27. Juni 2019 20:34
An: Lorenz, Christopher <Christopher.Lorenz@ZIT-BB.Brandenburg.de>; 'pgsql-pkg-yum@lists.postgresql.org'
<pgsql-pkg-yum@lists.postgresql.org>
Betreff: Re: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis 2.4 -


Hi,

On Tue, 2019-06-25 at 09:34 +0000, Lorenz, Christopher wrote:
> since we have upgrade from postgis 2.4.6 to 2.4.7-3 of PostgreSQL 9.6. on our
> RHEL7 enviroment we have trouble with the gdal library. There migth be a bug
> or  something. The Problem also appears with PostgreSQL 10.
> 
> If we call Postgis_Full_Version() we get the folowing error:
> 
> FEHLER:  konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden:
> libgdal.so.20: Kann die Shared-Object-Datei nicht öffnen: Datei oder
> Verzeichnis nicht gefunden
> (english: can't load libgdal.so.20 - File not found)

I pushed gdal23 2.3.2-8 package to repositories, which fixes this issue.

Regards,
-- 
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: AW: RHEL 7: problem with gdal 2.3 postgresql 9.6/10 and postgis2.4 -

От
Devrim Gündüz
Дата:
Hi Christopher,

On Fri, 2019-06-28 at 10:12 +0000, Lorenz, Christopher wrote:
> Updating the packages to gdal23-libs-2.3.2-8 and postgis24_96-2.4.7-4 solved
> the problem with the missing library/ldconfig.

Great!

> The issue with the undefined symbol still exists with current packages on our
> systems:
>
> select PostGIS_Full_Version();
> FEHLER:  konnte Bibliothek »/usr/pgsql-9.6/lib/rtpostgis-2.4.so« nicht laden:
> /usr/gdal23/lib/libgdal.so.20: undefined symbol: ecs_SetReportErrorFunction
> KONTEXT:  SQL-Anweisung »SELECT public.postgis_gdal_version()«

I cannot reproduce this on CentOS 7 and Fedora 30:

postgres=# create extension postgis;
CREATE EXTENSION
postgres=# select PostGIS_Full_Version();

 postgis_full_version

------------------------------------------------------------------------------
------------------------------------------------------------------------------
-----------------------
 POSTGIS="2.4.7 r17330" PGSQL="96" GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel
. 4.9.3, 15 August 2016" GDAL="GDAL 2.3.2, released 2018/09/21" LIBXML="2.9.1"
 LIBJSON="0.11" RASTER
(1 row)

I'll setup a fresh machine and test again.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Вложения