Opened 2 years ago
Closed 2 years ago
#5291 closed defect (fixed)
berrie64 crashing on postgis raster tests
Reported by: | robe | Owned by: | robe |
---|---|---|---|
Priority: | high | Milestone: | PostGIS 3.4.0 |
Component: | raster | Version: | master |
Keywords: | Cc: |
Description
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.
Note:
See TracTickets
for help on using tickets.
reboot appears to have fixed the issue.