Your message dated Wed, 11 Apr 2018 07:04:40 +0200
with message-id <3083a8e7-2ebd-fe80-0688-e6c46ce18...@xs4all.nl>
and subject line Re: Bug#895388: Symbol removal prevents upgrade of postgres
9.6 cluster with postgis columns
has caused the Debian Bug report #895388,
regarding Symbol removal prevents upgrade of postgres 9.6 cluster with postgis
columns
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
895388: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=895388
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
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@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@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
--- End Message ---
--- Begin Message ---
severity 895388 normal
tags 895388 wontfix
thanks
On 04/10/2018 11:30 PM, Ari Pollak wrote:
> 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:
>
> [...]
>
> 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:
>
> [...]
>
> If I downgrade libsfcgal1, all of that works fine.
Upgrading postgis databases is not supported by the Debian package. You
need to recreate the postgis databases, or use the symlink hacks.
The postgis package in unstable will be rebuilt with the new sfcgal once
that migrates to testing.
Kind Regards,
Bas
--- End Message ---
_______________________________________________
Pkg-grass-devel mailing list
Pkg-grass-devel@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel
