[postgis-tickets] [PostGIS] #4000: unpackaged--2.5.0dev upgrade test fails due to postgis.backend being redefined

[PostGIS]

#4000: unpackaged--2.5.0dev upgrade test fails due to postgis.backend being
redefined
---------------------+---------------------------
 Reporter:  strk     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.5.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 {{{
 cd regress
 ./run_test.pl -v --sfcgal --upgrade --extension --upgrade-path
 unpackaged--
 2.5.0dev regress_sfcgal.sql

 Upgrade path: unpackaged --> 2.5.0dev
 PATH is
 /home/strk/perl5/bin:/home/strk/perl5/bin:/home/strk/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/usr/lib/go-1.8/bin:/home/strk/bin:/home/strk/go/bin:/home/strk/bin:/home/strk/go/bin
 Checking for shp2pgsql ... found
 Checking for pgsql2shp ... found
 Checking for raster2pgsql ... found
 TMPDIR is /tmp/pgis_reg
 Creating database 'postgis_reg'
 Loading PostGIS into 'postgis_reg'
   /usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-
 install/share/contrib/postgis/postgis.sql
   /usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-
 install/share/contrib/postgis/postgis_comments.sql
   /usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-
 install/share/contrib/postgis/postgis_proc_set_search_path.sql
 Loading Raster into 'postgis_reg'
   /usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-
 install/share/contrib/postgis/rtpostgis.sql
   /usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-
 install/share/contrib/postgis/raster_comments.sql
   /usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-
 install/share/contrib/postgis/rtpostgis_proc_set_search_path.sql
 Loading SFCGAL into 'postgis_reg'
   /usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-
 install/share/contrib/postgis/sfcgal.sql
   /usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-
 install/share/contrib/postgis/sfcgal_comments.sql
 Upgrading PostGIS in 'postgis_reg' using: CREATE EXTENSION postgis VERSION
 '2.5.0dev' FROM unpackaged
 Upgrading PostGIS SFCGAL in 'postgis_reg' using: CREATE EXTENSION
 postgis_sfcgal VERSION '2.5.0dev' FROM unpackaged
 PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
 6.3.0-12ubuntu2) 6.3.0 20170406, 64-bit
   Postgis 2.5.0dev - r16335 - 2018-01-18 21:56:50
   scripts 2.5.0dev r16335
   raster scripts 2.5.0dev r16335
   GEOS: 3.7.0dev-CAPI-1.11.0 c60c5e3d
   PROJ: Rel. 4.9.3, 15 August 2016
   SFCGAL: 1.3.0
   GDAL: GDAL 2.3.0dev, released 2017/99/99

 Running tests

  regress_sfcgal .. failed (diff expected obtained:
 /tmp/pgis_reg/test_1_diff)
 -----------------------------------------------------------------------------
 --- regress_sfcgal_expected     2018-01-18 11:03:16.489351339 +0100
 +++ /tmp/pgis_reg/test_1_out    2018-01-20 08:15:48.911376245 +0100
 @@ -1,4 +1,5 @@
  postgis_sfcgal_version|1
 +WARNING:  'postgis.backend' is already set and cannot be changed until
 you reconnect
  ST_Tesselate|GEOMETRYCOLLECTION(POINT(4 4),TIN(((0 1,1 0,1 1,0 1)),((0
 1,0 0,1 0,0 1))))
  ST_3DArea|1
  ST_Extrude_point|LINESTRING Z (0 0 0,1 0 0)
 -----------------------------------------------------------------------------
  uninstall .. ok (4581)

 Run tests: 2
 Failed: 1
 }}}

 The bug is also exposed by Debbie:
 https://debbie.postgis.net/job/PostGIS_Regress/8456/console

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4000>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.