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

[Bborie Park]

Strange that you're getting a process termination. The problem with loading
out-db rasters was just resolved in 2.0.5 and 2.1.2...

http://postgis.net/2014/03/31/postgis-2.1.2

The specific ticket is #2607...

Can you trying upgrading and see if the problem persists? I've never seen
the process terminate whenever I've hit the open file limit.

-bborie


On Mon, Mar 31, 2014 at 9:44 AM, Robert Nix <robert at urban4m.com> wrote:

> 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
> )
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140331/b1c3380b/attachment.html>