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