Bug#895388: Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns
On Wed, Apr 11, 2018 at 09:43:59AM +0300, Adrian Bunk wrote: > Control: reopen -1 > Control: severity -1 serious > > On Wed, Apr 11, 2018 at 07:04:40AM +0200, Sebastiaan Couwenberg wrote: > > 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. > > This bug is not about postgis databases, it is about a broken library. > > > The postgis package in unstable will be rebuilt with the new sfcgal once > > that migrates to testing. > > Does that work for you? > > I would expect linking to fail due to this bug. I think I'm wrong on the latter: As a plugin it would link but fail with the same error when trying to use it. Either way, SFCGAL no longer linked with CGAL is a pretty fatal bug. cu Adrian -- "Is there not promise of rain?" Ling Tan asked suddenly out of the darkness. There had been need of rain for many days. "Only a promise," Lao Er said. Pearl S. Buck - Dragon Seed ___ Pkg-grass-devel mailing list Pkg-grass-devel@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel
Processed: Re: Bug#895388: Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns
Processing control commands: > reopen -1 Bug #895388 {Done: Sebastiaan Couwenberg} [libsfcgal1] Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns Bug reopened Ignoring request to alter fixed versions of bug #895388 to the same values previously set > severity -1 serious Bug #895388 [libsfcgal1] Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns Severity set to 'serious' from 'normal' -- 895388: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=895388 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems ___ Pkg-grass-devel mailing list Pkg-grass-devel@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel
Bug#895388: Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns
Control: reopen -1 Control: severity -1 serious On Wed, Apr 11, 2018 at 07:04:40AM +0200, Sebastiaan Couwenberg wrote: > 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. This bug is not about postgis databases, it is about a broken library. > The postgis package in unstable will be rebuilt with the new sfcgal once > that migrates to testing. Does that work for you? I would expect linking to fail due to this bug. > Kind Regards, > > Bas cu Adrian -- "Is there not promise of rain?" Ling Tan asked suddenly out of the darkness. There had been need of rain for many days. "Only a promise," Lao Er said. Pearl S. Buck - Dragon Seed ___ Pkg-grass-devel mailing list Pkg-grass-devel@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel
Processed: Re: Bug#895388: Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns
Processing commands for cont...@bugs.debian.org: > severity 895388 normal Bug #895388 [libsfcgal1] Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns Severity set to 'normal' from 'serious' > tags 895388 wontfix Bug #895388 [libsfcgal1] Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns Added tag(s) wontfix. > thanks Stopping processing here. Please contact me if you need assistance. -- 895388: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=895388 Debian Bug Tracking System Contact ow...@bugs.debian.org with problems ___ Pkg-grass-devel mailing list Pkg-grass-devel@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel
Bug#895388: Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns
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.01.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.01.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.01.62.0+dfsg-5 ii libc6 2.27-3 ii libgcc1 1:8-20180402-1 ii libgmp102:6.1.2+dfsg-3 ii libmpfr64.0.1-1 ii libstdc++6 8-20180402-1 libsfcgal1 recommends no packages. libsfcgal1 suggests no packages. -- no debconf information ___ Pkg-grass-devel mailing list Pkg-grass-devel@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel