Обсуждение: pg11 centos7 postgis24 broken due to libgeos
On a brand new centos7 VM, built earlier this week, I just attempted to upgrade to PG11: [pryzbyj@database ~]$ sudo cat /var/lib/pgsql/loadable_libraries.txt could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so": /usr/pgsql-11/lib/postgis-2.4.so:undefined symbol: geod_polygon_init [pryzbyj@database ~]$ rpm -qa |grep geos geos36-3.6.3-1.rhel7.x86_64 [pryzbyj@database ~]$ rpm -qf /usr/pgsql-11/lib/postgis-2.4.so postgis24_11-2.4.5-1.rhel7.1.x86_64 I can't see that symbol is available in PGDG 11 repo in geos36 nor 37. When the package is built which has that symbol, it'll be necessary to have a versioned dependency. Justin
Want to mention that this is still an issue. On Thu, Oct 18, 2018 at 11:40:19AM -0500, Justin Pryzby wrote: > On a brand new centos7 VM, built earlier this week, I just attempted to upgrade > to PG11: > > [pryzbyj@database ~]$ sudo cat /var/lib/pgsql/loadable_libraries.txt > could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so": /usr/pgsql-11/lib/postgis-2.4.so:undefined symbol: geod_polygon_init > > [pryzbyj@database ~]$ rpm -qa |grep geos > geos36-3.6.3-1.rhel7.x86_64 > > [pryzbyj@database ~]$ rpm -qf /usr/pgsql-11/lib/postgis-2.4.so > postgis24_11-2.4.5-1.rhel7.1.x86_64 > > I can't see that symbol is available in PGDG 11 repo in geos36 nor 37. > > When the package is built which has that symbol, it'll be necessary to have a > versioned dependency.
Hi, On Mon, 2018-10-29 at 08:17 -0500, Justin Pryzby wrote: > Want to mention that this is still an issue. Per discussion with upstream, I think I will have to release our GDAL package to fix this issue. That will likely happen tomorrow. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Вложения
On Mon, Oct 29, 2018 at 03:33:18PM +0000, Devrim Gündüz wrote: > On Mon, 2018-10-29 at 08:17 -0500, Justin Pryzby wrote: > > Want to mention that this is still an issue. > > Per discussion with upstream, I think I will have to release our GDAL package > to fix this issue. That will likely happen tomorrow. Checking back about this. Do you mean you're planning on building an updated GDAL package? Thanks, -- Justin Pryzby System Administrator Telsasoft +1-952-707-8581
On Wed, Nov 14, 2018 at 12:34:40PM -0600, Justin Pryzby wrote:
> On Mon, Oct 29, 2018 at 03:33:18PM +0000, Devrim Gündüz wrote:
> > On Mon, 2018-10-29 at 08:17 -0500, Justin Pryzby wrote:
> > > Want to mention that this is still an issue.
> >
> > Per discussion with upstream, I think I will have to release our GDAL package
> > to fix this issue. That will likely happen tomorrow.
I realized that a transition I already did to PG11 was running centos7 and
works just fine (with postgis and all its libs).
The issue appears to be this:
[pryzbyj@database ~]$ sudo cat /var/lib/pgsql/loadable_libraries.txt
could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so":
/usr/pgsql-11/lib/postgis-2.4.so:undefined symbol: geod_polygon_init
[pryzbyj@database ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so|grep proj
libproj.so.0 => /lib64/libproj.so.0 (0x00007f5ef6681000)
[pryzbyj@database ~]$ rpm -qf /lib64/libproj.so.0
proj-4.8.0-4.el7.x86_64
[pryzbyj@database ~]$ rpm -qa |grep proj
proj-nad-4.8.0-4.el7.x86_64
proj49-4.9.3-3.rhel7.x86_64
proj-4.8.0-4.el7.x86_64
On the working server, libproj.so.0 finds proj49 (both servers have both
libraries installed).
[pryzbyj@database ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so |grep proj
libproj.so.12 => /usr/proj49/lib/libproj.so.12 (0x00007f219c649000)
The postgis24_11 pacakge is pulling in proj/epel, and the PGDG proj49 doesn't
satisfy the dependency.
I worked around the problem on one of the failing servers by copying an older
postgis RPM out of /var/cache on the working server:
package postgis24_11-2.4.5-1.rhel7.1.x86_64 (which is newer than postgis24_11-2.4.5-1.rhel7.x86_64) is already
installed
Hope that helps.
Justin
On Thu, Nov 15, 2018 at 02:50:19PM -0600, Justin Pryzby wrote:
> On Wed, Nov 14, 2018 at 12:34:40PM -0600, Justin Pryzby wrote:
> > On Mon, Oct 29, 2018 at 03:33:18PM +0000, Devrim Gündüz wrote:
> > > On Mon, 2018-10-29 at 08:17 -0500, Justin Pryzby wrote:
> > > > Want to mention that this is still an issue.
> > >
> > > Per discussion with upstream, I think I will have to release our GDAL package
> > > to fix this issue. That will likely happen tomorrow.
>
> I realized that a transition I already did to PG11 was running centos7 and
> works just fine (with postgis and all its libs).
>
> The issue appears to be this:
>
> [pryzbyj@database ~]$ sudo cat /var/lib/pgsql/loadable_libraries.txt
> could not load library "$libdir/postgis-2.4": ERROR: could not load library "/usr/pgsql-11/lib/postgis-2.4.so":
/usr/pgsql-11/lib/postgis-2.4.so:undefined symbol: geod_polygon_init
>
> [pryzbyj@database ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so|grep proj
> libproj.so.0 => /lib64/libproj.so.0 (0x00007f5ef6681000)
>
> [pryzbyj@database ~]$ rpm -qf /lib64/libproj.so.0
> proj-4.8.0-4.el7.x86_64
>
> [pryzbyj@database ~]$ rpm -qa |grep proj
> proj-nad-4.8.0-4.el7.x86_64
> proj49-4.9.3-3.rhel7.x86_64
> proj-4.8.0-4.el7.x86_64
>
> On the working server, libproj.so.0 finds proj49 (both servers have both
> libraries installed).
>
> [pryzbyj@database ~]$ ldd /usr/pgsql-11/lib/postgis-2.4.so |grep proj
> libproj.so.12 => /usr/proj49/lib/libproj.so.12 (0x00007f219c649000)
Sorry, what I should have said was:
libproj is libproj.so.12 and not so.0.
Justin