[postgis-users] Accessing lots of missing outdb/offline rasters appear to cause PostgreSQL to crash

[Robert Nix]

After 1001 of these errors:

2014-03-31 15:50:51 UTC ERROR:  rt_band_load_offline_data: Cannot open 
offline raster: /...


I get:

SELECT: rt_api.c:8659: rt_raster_from_band: Assertion `((void *)0) != 
raster' failed.
2014-03-31 15:50:52 UTC LOG:  server process (PID 8385) was terminated by 
signal 6: Aborted


Eventually resulting in:

2014-03-31 15:50:52 UTC FATAL:  the database system is in recovery mode


Requiring bouncing the postgres service.

I'm not sure if this is an issue with PostGIS or PostgreSQL itself.

I'm accessing the rasters from within a sql function, essentially:

st_setbandnodatavalue(
  st_snaptogrid(
    st_setsrid(_rast,4326),
    gridx:=st_upperleftx(_rast),
    gridy:=st_upperlefty(_rast)
  ),
  0.0
)


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140331/03c7cf22/attachment.html>