[postgis-users] St_Union crashing

David Rowley dgrowleyml at gmail.com
Wed Jul 31 15:07:09 PDT 2013


On Thu, Aug 1, 2013 at 10:01 AM, Bborie Park <dustymugs at gmail.com> wrote:

>
> Sure. I've created a smallish recreation script with about 2000 16x16
>> rasters which still crashes with me.
>>
>> http://www.davidrowley.co.uk/files/st_union_crash.sql
>>
>> Just send ctrl+C while the St_Union is in progress.
>>
>> I get:
>>
>> test=# SELECT ST_Union(rast) FROM rasttest;
>> Cancel request sent
>> server closed the connection unexpectedly
>>         This probably means the server terminated abnormally
>>         before or while processing the request.
>> The connection to the server was lost. Attempting reset: Succeeded.
>>
>>
> I just noticed that this is happening when you're aborting the ST_Union().
> I can't replicate it in Linux no longer how long I let the statement run. I
> wonder if this is an issue related to the issues with PostGIS compiled with
> gcc < 4.8.0 vs gcc >= 4.8.0 for Windows.
>
>
If you have access to any other 64bit builds for windows, I'd be willing to
find out for you.

David


> -bborie
>
> _______________________________________________
> 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/20130801/f5fd536a/attachment.html>


More information about the postgis-users mailing list