Bug#895388: Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns
Ari Pollak
ari at debian.org
Tue Apr 10 21:30:15 UTC 2018
Package: libsfcgal1
Version: 1.3.3-1
Severity: serious
I have postgresql-9.6-postgis-2.3 installed (no longer in Debian
buster, but was in stretch, current stable). After upgrading libsfcgal1
and trying to use postgis on my existing Postgres 9.6 server, I get an
error when trying to access a table with a geography column:
ari at ari:~ % psql
ari=# \d+
location_order_providers
ERROR: could not load library
"/usr/lib/postgresql/9.6/lib/postgis-2.3.so":
/usr/lib/x86_64-linux-gnu/libSFCGAL.so.1: undefined symbol:
_ZN4CGAL11NULL_VECTORE
That would be fine if I could upgrade the database to Postgres 10, since
the new postgresql-10-postgis-2.4 package doesn't depend on libsfcgal1,
but I can't do that with the missing symbol:
ari at ari:~ % sudo pg_upgradecluster 9.6 main
Stopping old
cluster...
Disabling connections to the old cluster during
upgrade...
Restarting old cluster with restricted
connections...
Creating new PostgreSQL cluster 10/main .
...
Disabling connections to the new cluster during upgrade...
Roles, databases, schemas, ACLs...
pg_dump: [archiver (db)] query failed: ERROR: could not load library
"/usr/lib/postgresql/9.6/lib/postgis-2.3.so":
/usr/lib/x86_64-linux-gnu/libSFCGAL.so.1: undefined symbol:
_ZN4CGAL11NULL_VECTORE
If I downgrade libsfcgal1, all of that works fine.
-- System Information:
Debian Release: buster/sid
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable-debug'), (500,
'testing-debug'), (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.15.0-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8),
LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages libsfcgal1 depends on:
ii libboost-atomic1.62.0 1.62.0+dfsg-5
ii libboost-chrono1.62.0 1.62.0+dfsg-5
ii libboost-date-time1.62.0 1.62.0+dfsg-5
ii libboost-filesystem1.62.0 1.62.0+dfsg-5
ii libboost-program-options1.62.0 1.62.0+dfsg-5
ii libboost-serialization1.62.0 1.62.0+dfsg-5
ii libboost-system1.62.0 1.62.0+dfsg-5
ii libboost-test1.62.0 1.62.0+dfsg-5
ii libboost-thread1.62.0 1.62.0+dfsg-5
ii libboost-timer1.62.0 1.62.0+dfsg-5
ii libc6 2.27-3
ii libgcc1 1:8-20180402-1
ii libgmp10 2:6.1.2+dfsg-3
ii libmpfr6 4.0.1-1
ii libstdc++6 8-20180402-1
libsfcgal1 recommends no packages.
libsfcgal1 suggests no packages.
-- no debconf information
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-grass-devel/attachments/20180410/d4d3130d/attachment.html>
More information about the Pkg-grass-devel
mailing list