[postgis-users] crash on ST_Clip()

[Bborie Park]

Steve,

You'll have to provide more details before anyone can reproduce what
you're seeing.  If you can provide the spatial information of that tile
and that box that crashes, we could then try to duplicate it.

Also, you'll want to provide the version info of PostgreSQL, GDAL and GEOS.

-bborie

On 04/25/2012 01:29 PM, Stephen Crawford wrote:
> Well I tried the same query for just one of the tiles that I know
> intersects the the_geom but it crashed.  Then i simplified it further by
> using just a box instead of a multipolygon and it still crashed.
> 
> On 4/25/2012 3:22 PM, Paul Ramsey wrote:
>> Find the exact geometry pair that is causing the crash and file a
>> ticket. (Yes, disconnecting means the backend went boom, that's a
>> crash).
>> P
>>
>> On Wed, Apr 25, 2012 at 12:15 PM, Stephen Crawford<src176 at psu.edu> 
>> wrote:
>>> All,
>>>
>>> I have a query which works on my desktop Windows (postgis2.0 RC) but
>>> crashes
>>> on Linux (postgis2.0 official release).  And by crash i mean
>>> disconnects me
>>> from the server.
>>>
>>> INSERT INTO result_raster_table (observation_date, rast)
>>> SELECT r.observation_date, ST_Clip(r.rast,g.the_geom,-9999) AS rast
>>> FROM raster_table r, geom_table g
>>> WHERE r.observation_date = '2012-03-09';
>>>
>>> 'raster_table ' holds tiles, 187 of which make up one
>>> observation_date, and
>>> 'geom_table' is just one record, the union of ~23 Eastern US states.
>>>
>>> Any thoughts?
>>>
>>> Thanks,
>>> Steve
>>>
>>> -- 
>>> Stephen Crawford
>>> Center for Environmental Informatics
>>> The Pennsylvania State University
>>> src176 at psu.edu
>>> 814.865.9905
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu