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.

Change History (1)

comment:1 by robe, 2 years ago

Resolution: fixed
Status: newclosed

reboot appears to have fixed the issue.

Note: See TracTickets for help on using tickets.