[postgis-users] St_Union crashing

[David Rowley]

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

> You can find experimental builds at...
>
> http://winnie.postgis.net/download/windows/pg92/buildbot/
>
>
Thanks,

OK, I've tried 2 more versions and I don't get any error with either of
them:

 POSTGIS="2.1.0rc1 r11662" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0,
6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8"
LIBJSON="UNKNOWN"
 TOPOLOGY RASTER


 POSTGIS="2.0.4SVN r11708" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0,
6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8"
LIBJSON="UNKNOWN"
 (core procs from "2.0.3 r11132" need upgrade) TOPOLOGY (topology procs
from "2.0.1 r9979" need upgrade) RASTER (raster procs from "2.0.3 r11132"
need upgrade)

So I guess the problem is void since it's been fixed in the latest minor
version. I've not looked at the postgis source, but I did notice that the
Gdal version went from 1.9.2 to 1.10.0 since 2.0.3. Perhaps the problem
could be there...

David


> -bborie
>
>
> On Wed, Jul 31, 2013 at 3:07 PM, David Rowley <dgrowleyml at gmail.com>wrote:
>
>> 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
>>>
>>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>>
>
> _______________________________________________
> 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/700f59a8/attachment.html>