[postgis-tickets] [PostGIS] #5291: berrie64 crashing on postgis raster tests

[PostGIS]

#5291: berrie64 crashing on postgis raster tests
--------------------+---------------------------
 Reporter:  robe    |      Owner:  robe
     Type:  defect  |     Status:  new
 Priority:  high    |  Milestone:  PostGIS 3.4.0
Component:  raster  |    Version:  master
 Keywords:          |
--------------------+---------------------------
 berrie seems to be okay so might be something specific about berrie64.

 The crashing query is:


 {{{
                 SELECT ST_Neighborhood(rast1.rast,
 ST_Centroid(rast1.rast::geometry), 100, 100, false)

                         , ST_AsEWKT(rast1.rast::geometry) As ref1_geom,
 ST_AsEWKT(rast2.rast::geometry) As ref2_geom

                                         FROM (
                         (SELECT
 ST_SetSRID(ST_SetValue(ST_AddBand(ST_MakeEmptyRaster( 10, 10, (i-1)*10,
 (i-1)*10, 0.0005, -0.0005, 0*i, 0*i), '64BF'), i, (i+1),42949.12345),4326)
 As rast
                                 FROM generate_series(1,2) As i)
                  ) As rast1 CROSS JOIN (
                         (SELECT
 ST_SetSRID(ST_SetValue(ST_AddBand(ST_MakeEmptyRaster( 10, 10, (i-1)*10,
 (i-1)*10, 0.0005, -0.0005, 0*i, 0*i), '32BUI'), i, (i+1),42949),4326) As
 rast
                                 FROM generate_series(1,2) As i)
                  ) As rast2
                                         LIMIT 2;
 }}}


 What's odd about this is that the query passes and runs but then next
 output is


 {{{
 WARNING:  terminating connection due to immediate shutdown command
                         UPDATE raster_garden_log33 SET log_end =
 clock_timestamp()
                 FROM (SELECT logid FROM raster_garden_log33 ORDER BY logid
 DESC limit 1) As foo
                 WHERE raster_garden_log33.logid = foo.logid  AND
 raster_garden_log33.log_end IS NULL;
 server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
 connection to server was lost
 }}}


 Same maybe this is just server exhaustion and berrie64 needs a reboot.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5291>
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.