Opened 5 years ago

Closed 5 years ago

#4650 closed defect (fixed)

Can't install postgis_sfcgal

Reported by: robe Owned by: strk
Priority: blocker Milestone: PostGIS 3.1.0
Component: build Version: master
Keywords: Cc:

Description

I'm rerunning again to make sure its not a PG 13 issue.

But debbie started failing after commit [9ed7d8436/git]

    Further simplification and unification of extension Makefiles (details)

Commit 9ed7d8436b902f6086b54e753006bd14a87aba4d by Sandro Santilli

Further simplification and unification of extension Makefiles

The file was modified	extensions/postgis_topology/Makefile.in
The file was modified	extensions/postgis/Makefile.in
The file was modified	extensions/postgis_raster/Makefile.in
The file was modified	extensions/postgis_sfcgal/Makefile.in

Error she's showing is:

18:12:02 Checking for shp2pgsql ... found
18:12:02 Checking for pgsql2shp ... found
18:12:02 TMPDIR is /var/lib/jenkins/workspace/postgis/tmp/3_1_pg13w64
18:12:02 Creating database 'postgis_reg' 
18:12:04 Preparing db 'postgis_reg' using: CREATE EXTENSION postgis SCHEMA public
18:12:06 Preparing db 'postgis_reg' using: CREATE EXTENSION postgis_sfcgal SCHEMA public
18:12:06 Died at ../run_test.pl line 1462.
18:12:06  failed (Error encountered creating EXTENSION POSTGIS_SFCGAL: /var/lib/jenkins/workspace/postgis/tmp/3_1_pg13w64/regress_log)
18:12:06 -----------------------------------------------------------------------------
18:12:06 NOTICE:  schema "public" already exists, skipping
18:12:06 CREATE SCHEMA
18:12:06 CREATE EXTENSION
18:12:06 ERROR:  function postgis_sfcgal_version() does not exist
18:12:06 -----------------------------------------------------------------------------
18:12:06 make[2]: *** [Makefile:39: check] Error 1
18:12:06 make[2]: Leaving directory '/var/lib/jenkins/workspace/postgis/branches/3.1/regress/sfcgal'
18:12:06 make[1]: *** [Makefile:48: check-regress] Error 2
18:12:06 make[1]: Leaving directory '/var/lib/jenkins/workspace/postgis/branches/3.1/regress'
18:12:06 make: *** [GNUmakefile:20: check-regress] Error 1

Change History (3)

comment:1 by robe, 5 years ago

CREATE EXTENSION postgis_sfcgal seems to run okay on my local pc pg12 run so not sure where this is failing on debbie.

I'll look at tomorrow. I thought bessies were failing too but I think that was the 2.3 run which is not supported on PG 11.

comment:2 by robe, 5 years ago

Seeing this issue on winnie as well, but I can't trigger it on my local.

https://winnie.postgis.net:444/job/PostGIS_EDB_Regress_winnie/10438/consoleFull

make[2]: Leaving directory '/projects/postgis/branches/3.1/regress/core'
make -C sfcgal check
make[2]: Entering directory '/projects/postgis/branches/3.1/regress/sfcgal'
/usr/bin/perl ../run_test.pl --sfcgal --extension -v regress_sfcgal approximatemedialaxis.sql
PATH is /projects/postgresql/rel/pg11w64gcc81/bin:/projects/postgresql/rel/pg11w64gcc81/bin:/projects/CGAL/rel-cgal-4.11w64gcc81/bin:/projects/CGAL/rel-sfcgal-1.3.2w64gcc81/bin:/projects/boost/rel-1_53_0w64gcc81/lib:/projects/pcre/rel-8.33w64gcc81/include:/projects/pcre/rel-8.33w64gcc81/lib:/projects/protobuf/rel-3.2.0w64gcc81/bin:/projects/protobuf/rel-3.2.0w64gcc81/lib:/projects/xsltproc:/projects/gtkw64gcc81/bin:/projects/geos/rel-3.8.0w64gcc81/bin:/projects/gdal/rel-2.4.3w64gcc81/bin:/projects/rel-libiconv-1.15w64gcc81/lib:/projects/rel-libiconv-1.15w64gcc81/include:/projects/rel-libiconv-1.15w64gcc81/bin:/projects/proj/rel-5.2.0w64gcc81/bin:/projects/libxml/rel-libxml2-2.9.9w64gcc81/bin:/projects/zlib/rel-zlib-1.2.11w64gcc81/bin:/projects/zlib/rel-zlib-1.2.11w64gcc81/lib:/mingw64/bin:/usr/local/bin:/usr/bin:/bin:/c/Windows/System32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0/:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl:/projects/postgresql/rel/pg11w64gcc81/bin:/projects/postgresql/rel/pg11w64gcc81/lib
Checking for shp2pgsql ... found
Checking for pgsql2shp ... found
TMPDIR is /projects/postgis/tmp/3.1.0dev_pg11_geos3.8.0_gdal2.4.3w64
Creating database 'postgis_reg' 
Preparing db 'postgis_reg' using: CREATE EXTENSION postgis SCHEMA public
Preparing db 'postgis_reg' using: CREATE EXTENSION postgis_sfcgal SCHEMA public
Died at ../run_test.pl line 1463.
 failed (Error encountered creating EXTENSION POSTGIS_SFCGAL: /projects/postgis/tmp/3.1.0dev_pg11_geos3.8.0_gdal2.4.3w64/regress_log)
-----------------------------------------------------------------------------
NOTICE:  schema "public" already exists, skipping
CREATE SCHEMA
CREATE EXTENSION
ERROR:  function postgis_sfcgal_version() does not exist
-----------------------------------------------------------------------------
make[2]: *** [Makefile:39: check] Error 1
make[2]: Leaving directory '/projects/postgis/branches/3.1/regress/sfcgal'
make[1]: *** [Makefile:48: check-regress] Error 2
make[1]: Leaving directory '/projects/postgis/branches/3.1/regress'
make: *** [GNUmakefile:20: check-regress] Error 1

comment:3 by Sandro Santilli <strk@…>, 5 years ago

Resolution: fixed
Status: assignedclosed

In 2534f03/git:

Fix sfcgal extension build scripts

Fixes #4650

Note: See TracTickets for help on using tickets.