[PostGIS] #6141: GHA crashing when installing raster

[PostGIS]

#6141: GHA crashing when installing raster
----------------------+---------------------------
  Reporter:  robe     |      Owner:  robe
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.7.0
 Component:  raster   |    Version:  master
Resolution:           |   Keywords:
----------------------+---------------------------
Description changed by robe:

Old description:

> Since commit [fb915a6/git]
>
> GHA some runs CI at least (pg18-geosmain-gdal311-proj96,
> pg17-geos313-gdal39-proj94,pg16-geos312-gdal37-proj921, (pg19-geosmain-
> gdalmaster-proj98, tests)  ] have been failing but not all have been
> failing with:
> https://github.com/postgis/postgis/actions/runs/34256040959/job/102161980677
>
> It doesn't seem isolated to coverage or tests or garden, but I do notice
> it is happening with those running gdal 3.7 or higher.  It is not
> happening on winnie or debbie though which are running the newest so
> presume it must be some extra compile switch maybe that GHA has
> triggering it.
>
> {{{
> RUNTESTFLAGS: --verbose --sfcgal --topology --raster
> RUNTESTFLAGS_INTERNAL: --after-create-db-script
> ./raster/test/regress/hooks/hook-before-create-raster.sql --before-
> upgrade-script ./raster/test/regress/hooks/hook-before-upgrade-raster.sql
> --before-upgrade-script ./topology/test/regress/hooks/hook-before-
> upgrade-topology.sql --after-create-db-script ./regress/hooks/hook-after-
> create-db.sql --before-upgrade-script ./regress/hooks/hook-before-
> upgrade.sql --after-upgrade-script ./regress/hooks/hook-after-upgrade-
> check-sql-object-resolution.sql --after-upgrade-script ./regress/hooks
> /hook-after-upgrade.sql --after-create-script   ./regress/hooks/hook-
> after-create.sql --before-uninstall-script ./regress/hooks/hook-before-
> uninstall.sql --after-upgrade-script ./topology/test/regress/hooks/hook-
> after-upgrade-topology.sql --after-upgrade-script
> ./raster/test/regress/hooks/hook-after-upgrade-raster.sql
> Creating database 'postgis_reg-3.7'.
> Running after-create-db-script ./raster/test/regress/hooks/hook-before-
> create-raster.sql
> Running after-create-db-script ./regress/hooks/hook-after-create-db.sql
> Loading PostGIS in 'postgis_reg-3.7 using scripts from
> /src/postgis/regress/00-regress-install/share/contrib/postgis'
> Loading Topology into 'postgis_reg-3.7'
> Loading Raster into 'postgis_reg-3.7'
>  failed (Error encountered loading /src/postgis/regress/00-regress-
> install/share/contrib/postgis/rtpostgis.sql:
> /tmp/pgis_reg/regress_log.tmp)
> -----------------------------------------------------------------------------
> NOTICE:  schema "public" already exists, skipping
> psql:/src/postgis/regress/00-regress-
> install/share/contrib/postgis/rtpostgis.sql:109: server closed the
> connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> psql:/src/postgis/regress/00-regress-
> install/share/contrib/postgis/rtpostgis.sql:109: error: connection to
> server was lost
> -----------------------------------------------------------------------------
> make: *** [regress/runtest.mk:24: check-regress] Error 1
>
> }}}

New description:

 Since commit [fb915a676/git]

 GHA some runs CI at least (pg18-geosmain-gdal311-proj96,
 pg17-geos313-gdal39-proj94,pg16-geos312-gdal37-proj921, (pg19-geosmain-
 gdalmaster-proj98, tests)  ] have been failing but not all have been
 failing with:
 https://github.com/postgis/postgis/actions/runs/34256040959/job/102161980677

 It doesn't seem isolated to coverage or tests or garden, but I do notice
 it is happening with those running gdal 3.7 or higher.  It is not
 happening on winnie or debbie though which are running the newest so
 presume it must be some extra compile switch maybe that GHA has triggering
 it.

 {{{
 RUNTESTFLAGS: --verbose --sfcgal --topology --raster
 RUNTESTFLAGS_INTERNAL: --after-create-db-script
 ./raster/test/regress/hooks/hook-before-create-raster.sql --before-
 upgrade-script ./raster/test/regress/hooks/hook-before-upgrade-raster.sql
 --before-upgrade-script ./topology/test/regress/hooks/hook-before-upgrade-
 topology.sql --after-create-db-script ./regress/hooks/hook-after-create-
 db.sql --before-upgrade-script ./regress/hooks/hook-before-upgrade.sql
 --after-upgrade-script ./regress/hooks/hook-after-upgrade-check-sql-
 object-resolution.sql --after-upgrade-script ./regress/hooks/hook-after-
 upgrade.sql --after-create-script   ./regress/hooks/hook-after-create.sql
 --before-uninstall-script ./regress/hooks/hook-before-uninstall.sql
 --after-upgrade-script ./topology/test/regress/hooks/hook-after-upgrade-
 topology.sql --after-upgrade-script ./raster/test/regress/hooks/hook-
 after-upgrade-raster.sql
 Creating database 'postgis_reg-3.7'.
 Running after-create-db-script ./raster/test/regress/hooks/hook-before-
 create-raster.sql
 Running after-create-db-script ./regress/hooks/hook-after-create-db.sql
 Loading PostGIS in 'postgis_reg-3.7 using scripts from
 /src/postgis/regress/00-regress-install/share/contrib/postgis'
 Loading Topology into 'postgis_reg-3.7'
 Loading Raster into 'postgis_reg-3.7'
  failed (Error encountered loading /src/postgis/regress/00-regress-
 install/share/contrib/postgis/rtpostgis.sql:
 /tmp/pgis_reg/regress_log.tmp)
 -----------------------------------------------------------------------------
 NOTICE:  schema "public" already exists, skipping
 psql:/src/postgis/regress/00-regress-
 install/share/contrib/postgis/rtpostgis.sql:109: server closed the
 connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
 psql:/src/postgis/regress/00-regress-
 install/share/contrib/postgis/rtpostgis.sql:109: error: connection to
 server was lost
 -----------------------------------------------------------------------------
 make: *** [regress/runtest.mk:24: check-regress] Error 1

 }}}

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