subject:"Bug#895388\: marked as done \(Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns\)"

Bug#895388: marked as done (Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns)

2018-04-11 Thread Debian Bug Tracking System

Your message dated Wed, 11 Apr 2018 11:15:34 +
with message-id 
and subject line Bug#895388: fixed in sfcgal 1.3.4-2
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.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
--- End Message ---
--- Begin Message ---
Source: sfcgal
Source-Version: 1.3.4-2

We believe that the bug you reported is fixed in the latest version of
sfcgal, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 895...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Bas Couwenberg  (supplier of updated sfcgal package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@ftp-master.debian.org)


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512

Format: 1.8
Date: Wed, 11 Apr 2018 12:04:16 +0200
Source: sfcgal
Binary: libsfcgal1 libsfcgal-osg1 libsfcgal-dev
Architecture: source amd64
Version: 1.3.4-2
Distribution: unstable
Urgency: medium
Maintainer: Debian GIS Project 
Changed-By: Bas Couwenberg 
Description:
 libsfcgal-dev - Library for ISO 19107:2013 and OGC SFA 1.2 for 3D operations 
(dev
 libsfcgal-osg1 - Library for ISO 19107:2013 and OGC SFA 1.2 for 3D operations 
(Ope
 libsfcgal1 - Library for ISO 19107:2013 and OGC SFA 1.2 for 3D

Bug#895388: marked as done (Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns)

2018-04-10 Thread Debian Bug Tracking System

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.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
--- 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 ---

Bug#895388: marked as done (Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns)

Bug#895388: marked as done (Symbol removal prevents upgrade of postgres 9.6 cluster with postgis columns)

2 matches

Site Navigation

Mail list logo

Footer information