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

Robert Nix robert at urban4m.com
Mon Mar 31 09:44:00 PDT 2014

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:


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

More information about the postgis-users mailing list