Re: [postgis-users] buffer(the_geom, 0) crashes the database
Benoît Andrieu wrote: (cut) --- Microsoft Visual C++ Runtime Library --- Assertion failed! Program: C:\PostgreSQL\bin\postgres.exe File: ../../source/headers/geos/noding/SegmentString.h Line: 175 Expression: pts->size() > 1 For information on how your program can cause an assertion failure, see the Visual C++ documentation on asserts Yeah, this is a GEOS assertion and so the problem lies outside of PostGIS :( Stefan, have you tried upgrading to the latest GEOS 3.0.3? There are a number of useful bugfixes in there which may help. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] buffer(the_geom, 0) crashes the database
El Martes 20 Enero 2009 12:13, Stefan Zweig escribió:
> hi mark,
>
> the file i have upload includes just a single query. it includes the
> geometry (a multipolygon of russia) that crashes with buffer(the_geom, 0)
> in wkt representation. so it is nothing more than select
> buffer(geomfromtext('MULTIPOLYGON(.)',4326),0) i think without having
> the actual coordinates of this MULTIPOLYGON it won't be possible to debug.
>
Then maybe it is a memory problem
--
María Arias de Reyna Domínguez
Emergya Consultoría
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] buffer(the_geom, 0) crashes the database
hi mark,
the file i have upload includes just a single query. it includes the geometry
(a multipolygon of russia) that crashes with buffer(the_geom, 0) in wkt
representation. so it is nothing more than select
buffer(geomfromtext('MULTIPOLYGON(.)',4326),0)
i think without having the actual coordinates of this MULTIPOLYGON it won't be
possible to debug.
regards,
stefan
> -Ursprüngliche Nachricht-
> Von: "Mark Cave-Ayland"
> Gesendet: 20.01.09 11:31:31
> An: PostGIS Users Discussion
> Betreff: Re: [postgis-users] buffer(the_geom, 0) crashes the database
> Stefan Zweig wrote:
>
> > Hi list,
> >
> > my postgis version is: "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel.
> > 4.6.0, 21 Dec 2007" USE_STATS"
> > and the following query lets completely crash my postgre database:
> >
> > i have pasted the whole query to this link. unfortunately it can only be
> > download 10 times:
> > http://rapidshare.com/files/186468552/buffer.txt.html
> >
> > i guess the error comes from the geos module.
> >
> > regards,
> > stefan
>
>
> Hi Stefan,
>
> The file seems awfully large; is what you have uploaded just a single
> query or a complete table? If it's the complete table, then posting just
> the SQL part may allow people to help you.
>
>
> ATB,
>
> Mark.
>
> --
> Mark Cave-Ayland
> Sirius Corporation - The Open Source Experts
> http://www.siriusit.co.uk
> T: +44 870 608 0063
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
__
Deutschlands größte Online-Videothek schenkt Ihnen 12.000 Videos!*
http://entertainment.web.de/de/entertainment/maxdome/index.html
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] buffer(the_geom, 0) crashes the database
Hi all, I agree with the fact that the file is a bit too large... ^^ I have seen one thing : there is a missing ) and a missing ; at the end of the query : 66.6869435)))',0) should be 66.6869435)))'),0); But with the corrected query, postgre is crashing making an abortion of the windows service You can see the detailed error below my message. So I don't know... Sorry ! Regards, Benoît Andrieu b...@ixsea.com benoit.andr...@gmail.com --- Microsoft Visual C++ Runtime Library --- Assertion failed! Program: C:\PostgreSQL\bin\postgres.exe File: ../../source/headers/geos/noding/SegmentString.h Line: 175 Expression: pts->size() > 1 For information on how your program can cause an assertion failure, see the Visual C++ documentation on asserts (Press Retry to debug the application - JIT must be enabled) --- Abort Retry Ignore --- - Original Message - From: "Mark Cave-Ayland" To: "PostGIS Users Discussion" Sent: Tuesday, January 20, 2009 11:25 AM Subject: Re: [postgis-users] buffer(the_geom, 0) crashes the database Stefan Zweig wrote: Hi list, my postgis version is: "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS" and the following query lets completely crash my postgre database: i have pasted the whole query to this link. unfortunately it can only be download 10 times: http://rapidshare.com/files/186468552/buffer.txt.html i guess the error comes from the geos module. regards, stefan Hi Stefan, The file seems awfully large; is what you have uploaded just a single query or a complete table? If it's the complete table, then posting just the SQL part may allow people to help you. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] buffer(the_geom, 0) crashes the database
Stefan Zweig wrote: Hi list, my postgis version is: "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS" and the following query lets completely crash my postgre database: i have pasted the whole query to this link. unfortunately it can only be download 10 times: http://rapidshare.com/files/186468552/buffer.txt.html i guess the error comes from the geos module. regards, stefan Hi Stefan, The file seems awfully large; is what you have uploaded just a single query or a complete table? If it's the complete table, then posting just the SQL part may allow people to help you. ATB, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] buffer(the_geom, 0) crashes the database
Hi list, my postgis version is: "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS" and the following query lets completely crash my postgre database: i have pasted the whole query to this link. unfortunately it can only be download 10 times: http://rapidshare.com/files/186468552/buffer.txt.html i guess the error comes from the geos module. regards, stefan __ Deutschlands größte Online-Videothek schenkt Ihnen 12.000 Videos!* http://entertainment.web.de/de/entertainment/maxdome/index.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
