[postgis-devel] Odd behavior in an upgrade

[Michael Brannigan]

I recently performed an upgrade on my Ubuntu 12.04.5 LTS server:

The following was the upgrade info in the apt/history.log

Start-Date: 2015-10-12  17:23:12
Commandline: apt-get upgrade
Upgrade: grub-legacy-ec2:amd64 (0.6.3-0ubuntu1.19, 0.6.3-0ubuntu1.22),
libgtk2.0-common:amd64 (2.24.10-0ubuntu6.1, 2.24.10-0ubuntu6.2),
postgresql-9.3:amd64 (9.3.9-1.pgdg12.4+1, 9.3.10-1.pgdg12.4+1),
libldap-2.4-2:amd64 (2.4.28-1.1ubuntu4.5, 2.4.28-1.1ubuntu4.6),
liblwgeom-2.1.7:amd64 (2.1.7+dfsg-3~94.git954a8d0.pgdg12.4+1,
2.1.8+dfsg-1~95.git18216c0.pgdg12.4+1), libcomerr2:amd64 (1.42-1ubuntu2.2,
1.42-1ubuntu2.3), libicu48:amd64 (4.8.1.1-3ubuntu0.5, 4.8.1.1-3ubuntu0.6),
cloud-init:amd64 (0.6.3-0ubuntu1.19, 0.6.3-0ubuntu1.22), comerr-dev:amd64
(2.1-1.42-1ubuntu2.2, 2.1-1.42-1ubuntu2.3),
postgresql-9.3-postgis-scripts:amd64
(2.1.7+dfsg-3~94.git954a8d0.pgdg12.4+1,
2.1.8+dfsg-5~97.git43a09cc.pgdg12.4+1), apport:amd64 (2.0.1-0ubuntu17.9,
2.0.1-0ubuntu17.11), libfreetype6:amd64 (2.4.8-1ubuntu2.2,
2.4.8-1ubuntu2.3), postgresql-client:amd64 (9.4+169.pgdg12.4+1,
9.4+170.pgdg12.4+1), e2fsprogs:amd64 (1.42-1ubuntu2.2, 1.42-1ubuntu2.3),
postgresql-contrib-9.3:amd64 (9.3.9-1.pgdg12.4+1, 9.3.10-1.pgdg12.4+1),
postgresql-plpython-9.3:amd64 (9.3.9-1.pgdg12.4+1, 9.3.10-1.pgdg12.4+1),
udev:amd64 (175-0ubuntu9.9, 175-0ubuntu9.10), python-problem-report:amd64
(2.0.1-0ubuntu17.9, 2.0.1-0ubuntu17.11), postgresql-common:amd64
(169.pgdg12.4+1, 170.pgdg12.4+1), postgresql-client-9.3:amd64
(9.3.9-1.pgdg12.4+1, 9.3.10-1.pgdg12.4+1), postgresql-client-9.4:amd64
(9.4.4-1.pgdg12.4+1, 9.4.5-1.pgdg12.4+1), e2fslibs:amd64 (1.42-1ubuntu2.2,
1.42-1ubuntu2.3), libudev0:amd64 (175-0ubuntu9.9, 175-0ubuntu9.10),
libpq-dev:amd64 (9.4.4-1.pgdg12.4+1, 9.4.5-1.pgdg12.4+1),
postgresql-client-common:amd64 (169.pgdg12.4+1, 170.pgdg12.4+1),
libpq5:amd64 (9.4.4-1.pgdg12.4+1, 9.4.5-1.pgdg12.4+1), python-apport:amd64
(2.0.1-0ubuntu17.9, 2.0.1-0ubuntu17.11), libss2:amd64 (1.42-1ubuntu2.2,
1.42-1ubuntu2.3), linux-libc-dev:amd64 (3.2.0-90.128, 3.2.0-91.129),
logentries:amd64 (1.4.22, 1.4.23), libgtk2.0-bin:amd64 (2.24.10-0ubuntu6.1,
2.24.10-0ubuntu6.2), libgtk2.0-0:amd64 (2.24.10-0ubuntu6.1,
2.24.10-0ubuntu6.2), newrelic-sysmond:amd64 (2.1.0.124, 2.2.0.125)
End-Date: 2015-10-12  17:23:52

​After upgrading, the following error messages were in my application logs:
django.db.utils.OperationalError: could not load library
"/usr/lib/postgresql/9.3/lib/postgis-2.1.so": liblwgeom-2.1.7.so: cannot
open shared object file: No such file or directory


​To fix the issue, I had to do the following
# dpkg --force-depends -r liblwgeom-2.1.7
# apt-get install liblwgeom-2.1.7
Start-Date: 2015-10-12  18:12:36
Commandline: apt-get install liblwgeom-2.1.7
Install: liblwgeom-2.1.7:amd64 (2.1.8+dfsg-1~95.git18216c0.pgdg12.4+1)
End-Date: 2015-10-12  18:12:38

# dpkg -r postgresql-9.3-postgis-2.1
# dpkg -r postgresql-9.3-postgis-scripts
# apt-get install postgresql-9.3-postgis-2.1
# apt-get install postgresql-9.3-postgis-scripts
Start-Date: 2015-10-12  18:16:25
Commandline: apt-get install postgresql-9.3-postgis-2.1
Install: liblwgeom-2.1.8:amd64 (2.1.8+dfsg-5~97.git43a09cc.pgdg12.4+1,
automatic), postgresql-9.3-postgis-scripts:amd64
(2.1.8+dfsg-5~97.git43a09cc.pgdg12.4+1, automatic),
postgresql-9.3-postgis-2.1:amd64 (2.1.8+dfsg-5~97.git43a09cc.pgdg12.4+1)
Remove: liblwgeom-2.1.7:amd64 (2.1.8+dfsg-1~95.git18216c0.pgdg12.4+1)
End-Date: 2015-10-12  18:16:28

​It is almost as if the dependency of postgresql-9.3-postgis-2.1 was
incorrect with liblwgeom-2.1.7 or that postgresql-9.3-postgis-2.1 needed to
b​e upgraded, but apt-get upgrade didn't upgrade it in the first place.



-- 

Mike Brannigan - Senior DevOps Engineer
C: 630.347.2698
www.spothero.com <http://spothero.com/> | @*SpotHero*
<https://twitter.com/SpotHero> | LinkedIn
<https://www.linkedin.com/in/mikebrannigan>

Don't have the free SpotHero app?
iPhone Download
<https://itunes.apple.com/us/app/spothero-parking-best-parking/id499097243?mt=8>
 | Android Download
<https://play.google.com/store/apps/details?id=com.spothero.spothero>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20151012/ccb6abfc/attachment.html>