BUG #14950: RPM EPEL PostGIS24_10 install breaks "yum update"

From: kop(at)meme(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: kop(at)meme(dot)com
Subject: BUG #14950: RPM EPEL PostGIS24_10 install breaks "yum update"
Date: 2017-12-06 16:18:39
Message-ID: 20171206161839.21687.47438@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14950
Logged by: Karl Pinc
Email address: kop(at)meme(dot)com
PostgreSQL version: 10.1
Operating system: RHEL 7
Description:

Hi,

Installing PostGIS on RHEL 7 from the PG repos breaks yum, to the point
where no further yum updates can be done. Not being able to apply security
updates is bad. :)

The work-around seems to be to un-install libgeotiff, which un-installs
PostGIS, then "yum update", then re-install PostGIS.

The PG RPM repos contain a PostGIS rpm. To install this the epel repo must
be enabled. But dependencies break and yum won't upgrade anything after
installation of PostGIS.

Here's what happens if you try to install PostGIS without epel enabled:

-----------------<snip>---------------
# yum install postgis24_10
Loaded plugins: langpacks, product-id, search-disabled-repos,
subscription-
: manager
Resolving Dependencies
--> Running transaction check
---> Package postgis24_10.x86_64 0:2.4.2-1.rhel7 will be installed
--> Processing Dependency: gdal-libs >= 1.9.0 for package:
postgis24_10-2.4.2-1.rhel7.x86_64
--> Processing Dependency: libgdal.so.1()(64bit) for package:
postgis24_10-2.4.2-1.rhel7.x86_64
--> Finished Dependency Resolution
Error: Package: postgis24_10-2.4.2-1.rhel7.x86_64 (pgdg10)
Requires: libgdal.so.1()(64bit)
Error: Package: postgis24_10-2.4.2-1.rhel7.x86_64 (pgdg10)
Requires: gdal-libs >= 1.9.0
**********************************************************************
yum can be configured to try to resolve such errors by temporarily
enabling
disabled repos and searching for missing dependencies.
To enable this functionality please set 'notify_only=0' in
/etc/yum/pluginconf.d/search-disabled-repos.conf
**********************************************************************

Error: Package: postgis24_10-2.4.2-1.rhel7.x86_64 (pgdg10)
Requires: libgdal.so.1()(64bit)
Error: Package: postgis24_10-2.4.2-1.rhel7.x86_64 (pgdg10)
Requires: gdal-libs >= 1.9.0
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
-----------------<snip>---------------

Enable the epel repo and PostGIS installs, like so:
-----------------<snip>---------------
# yum install postgis24_10
Loaded plugins: langpacks, product-id, search-disabled-repos,
subscription-
: manager
epel/x86_64/metalink | 16 kB 00:00

Resolving Dependencies
--> Running transaction check
---> Package postgis24_10.x86_64 0:2.4.2-1.rhel7 will be installed
--> Processing Dependency: gdal-libs >= 1.9.0 for package:
postgis24_10-2.4.2-1.rhel7.x86_64
--> Processing Dependency: libgdal.so.1()(64bit) for package:
postgis24_10-2.4.2-1.rhel7.x86_64
--> Running transaction check
---> Package gdal-libs.x86_64 0:1.11.4-1.el7 will be installed
--> Processing Dependency: libgeotiff.so.1.2()(64bit) for package:
gdal-libs-1.11.4-1.el7.x86_64
--> Running transaction check
---> Package libgeotiff.x86_64 0:1.2.5-14.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository
Size
================================================================================
Installing:
postgis24_10 x86_64 2.4.2-1.rhel7 pgdg10
6.3 M
Installing for dependencies:
gdal-libs x86_64 1.11.4-1.el7 epel
4.4 M
libgeotiff x86_64 1.2.5-14.el7 epel
545 k

Transaction Summary
================================================================================
Install 1 Package (+2 Dependent packages)

Total download size: 11 M
Installed size: 120 M
Is this ok [y/d/N]: y
Downloading packages:
gdal-libs-1.11.4-1.el7.x86_64. FAILED

http://mirror.es.its.nyu.edu/epel/7/x86_64/Packages/g/gdal-libs-1.11.4-1.el7.x86_64.rpm:
[Errno 12] Timeout on
http://mirror.es.its.nyu.edu/epel/7/x86_64/Packages/g/gdal-libs-1.11.4-1.el7.x86_64.rpm:
(28, 'Connection timed out after 30001 milliseconds')
Trying other mirror.
(1/3): libgeotiff-1.2.5-14.el7.x86_64.rpm | 545 kB 00:00

(2/3): gdal-libs-1.11.4-1.el7.x86_64.rpm | 4.4 MB 00:00

(3/3): postgis24_10-2.4.2-1.rhel7.x86_64.rpm | 6.3 MB 00:01

--------------------------------------------------------------------------------
Total 368 kB/s | 11 MB 00:31

Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : libgeotiff-1.2.5-14.el7.x86_64
1/3
Installing : gdal-libs-1.11.4-1.el7.x86_64
2/3
Installing : postgis24_10-2.4.2-1.rhel7.x86_64
3/3
Verifying : gdal-libs-1.11.4-1.el7.x86_64
1/3
Verifying : postgis24_10-2.4.2-1.rhel7.x86_64
2/3
Verifying : libgeotiff-1.2.5-14.el7.x86_64
3/3

Installed:
postgis24_10.x86_64 0:2.4.2-1.rhel7

Dependency Installed:
gdal-libs.x86_64 0:1.11.4-1.el7 libgeotiff.x86_64 0:1.2.5-14.el7

Complete!
-----------------<snip>---------------

But then, if you try to update your system with yum, it never works:
-----------------<snip>---------------
# yum update
Loaded plugins: langpacks, product-id, search-disabled-repos,
subscription-
: manager
Resolving Dependencies
--> Running transaction check
---> Package libgeotiff.x86_64 0:1.2.5-14.el7 will be updated
--> Processing Dependency: libgeotiff.so.1.2()(64bit) for package:
gdal-libs-1.11.4-1.el7.x86_64
---> Package libgeotiff.x86_64 0:1.4.0-1.rhel7 will be an update
--> Finished Dependency Resolution
Error: Package: gdal-libs-1.11.4-1.el7.x86_64 (@epel)
Requires: libgeotiff.so.1.2()(64bit)
Removing: libgeotiff-1.2.5-14.el7.x86_64 (@epel)
libgeotiff.so.1.2()(64bit)
Updated By: libgeotiff-1.4.0-1.rhel7.x86_64 (pgdg10)
Not found
**********************************************************************
yum can be configured to try to resolve such errors by temporarily
enabling
disabled repos and searching for missing dependencies.
To enable this functionality please set 'notify_only=0' in
/etc/yum/pluginconf.d/search-disabled-repos.conf
**********************************************************************

Error: Package: gdal-libs-1.11.4-1.el7.x86_64 (@epel)
Requires: libgeotiff.so.1.2()(64bit)
Removing: libgeotiff-1.2.5-14.el7.x86_64 (@epel)
libgeotiff.so.1.2()(64bit)
Updated By: libgeotiff-1.4.0-1.rhel7.x86_64 (pgdg10)
Not found
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
-----------------<snip>---------------

Regards,
Karl

Browse pgsql-bugs by date

  From Date Subject
Next Message radudragusi 2017-12-06 16:19:09 BUG #14951: Install Error on Windows server 2008 R2
Previous Message Tomas Vondra 2017-12-06 13:33:36 Re: BUG #14932: SELECT DISTINCT val FROM table gets stuck in an infinite loop