[postgis-tickets] [PostGIS] #5121: LTO enabled causes windows, freebsd and some github actions to fail

[PostGIS]

#5121: LTO enabled causes windows, freebsd and some github actions to fail
------------------------+---------------------------
  Reporter:  robe       |      Owner:  robe
      Type:  defect     |     Status:  new
  Priority:  blocker    |  Milestone:  PostGIS 3.3.0
 Component:  buildbots  |    Version:  master
Resolution:             |   Keywords:
------------------------+---------------------------

Comment (by robe):

 @sergeish,

 About github actions (not issues). I've added the screen shots to show
 what I mean.  The ticket thing there is a GH pull request which is fine.

 When I accidentally disabled LTO for all systems, all GH actions became
 green.
 A couple have been red for a while.

 # Regina accidentally disabling LTO entirely
 [[Image(disable_lto.png)]]

 When I changed to just disable for mingw, then those went red again though
 winnie was still happy :)

 # Regina changing to just disable for mingw windows
 [[Image(disable_lto_just_for_mingw.png)]]

 I was baffled with the errors on the GH actions cause they are each
 different so I thought they were caused by bad docker builds or a change
 in GDAL.

 1)
 CI (pg14-clang-geosmain-gdal34-proj71, usan_clang) and (pg13-clang-
 geos39-gdal31-proj71, usan_clang)
  couldn't find GDALALL checking for library containing GDALAllRegister...
 no
 Error: Process completed with exit code 1.

 2)CI (pg13-geos39-gdal31-proj71, usan_gcc)  psql:/src/postgis/regress/00
 -regress-install/share/contrib/postgis/sfcgal.sql:52: ERROR:  could not
 load library "/src/postgis/regress/00-regress-
 install/lib/postgis_sfcgal-3.so": /src/postgis/regress/00-regress-
 install/lib/postgis_sfcgal-3.so: undefined symbol:
 __ubsan_handle_mul_overflow

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5121#comment:12>
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.