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

[Robert Nix]

Thanks for the help, Bborie,

Based on your comment about nulls, I dove into the queries and discovered 
that, in fact, it was due to an unexpected null shape in a call to st_clip. 
Thanks for that. It really helped me to narrow down the issue.

It still feels like there's a but in postgresql server since that assertion 
shouldn't cause the perma-recovery mode that ends up happening when lots of 
those assertions occur every second. It's almost like a race condition in 
the recovery process.

Anyway, if i can get the time, i'll post that question to the pgsql group.

Thanks again

On Monday, March 31, 2014 12:44:00 PM UTC-4, Robert Nix 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
> )
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140401/a680aa80/attachment-0001.html>