[postgis-users] crash on ST_Clip()

[Paul Ramsey]

In order to fix a problem, developers must reproduce it. What do we
need to reproduce it: the offending SQL and the data itself. In ideal
test cases the users can embed the data statically into a single SQL
statement. In others they provide minimal versions of the offending
tables. Try to make reproducing the problem as easy as possible for
others, and the odds of it being fixed go up. Create a ticket with the
SQL and description and attach your data to it.
<http://trac.osgeo.org/postgis>

P.

On Wed, Apr 25, 2012 at 1:29 PM, Stephen Crawford <src176 at psu.edu> 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
>
>
> --
> 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