[postgis-users] Postgres segfaults on some geometry functions
David TECHER
davidtecher at yahoo.fr
Tue May 11 09:30:55 PDT 2004
perhaps you should tell what is the srid
--- Havard Tveite <havard.tveite at nlh.no> a écrit : >
I am on Solaris 2.7, GCC 3.3.2, Postgres 7.4.1, GEOS
> 1.0.0, Postgis
> 0.8.1 (I had to compile postgis with -fPIC in the
> CXXFLAGS to be able to
> build shared libraries).
>
> I seem to be having problems with geometry functions
> that return
> geometry. All geometric predicates seem to run fine,
> and so does
> other "geometry"-functions such as isempty and
> geometrytype.
>
> I have tested:
> select buffer('POLYGON((0.5 0.5,0.5 1.5,1.5 1.5,1.5
> 0.5,0.5 0.5))',5);
> select geomunion( 'POLYGON((0.5 0.5,0.5 1.5,1.5
> 1.5,1.5 0.5,0.5 0.5))', 'POLYGON((0 0,0 1,1 1,1 0,0
> 0))');
> select intersection('POLYGON((0.5 0.5,0.5 1.5,1.5
> 1.5,1.5 0.5,0.5 0.5))', 'POLYGON((0 0,0 1,1 1,1 0,0
> 0))');
> and all fail with the following response:
> "
> 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: Failed.
> "
> Postgresql recovers from the failure.
>
> The postgresql log does not show much, even with
> debug5 set. This is
> the result with "notice":
> 2004-05-11 17:35:25 LOG: statement: select
> buffer('POLYGON((0.5 0.5,0.5 1.5,1.5
> 1.5,1.5 0.5,0.5 0.5))',5);
> 2004-05-11 17:35:31 LOG: server process (PID 9006)
> was terminated by signal 11
> 2004-05-11 17:35:31 LOG: terminating any other
> active server processes
> 2004-05-11 17:35:31 LOG: all server processes
> terminated; reinitializing
> 2004-05-11 17:35:31 LOG: connection received:
> host=[local] port=
> 2004-05-11 17:35:31 FATAL: the database system is
> starting up
>
> What could be the problem?
>
> --
> Håvard Tveite
> Department of Mathematical Sciences and Technology
> Agricultural University of Norway
> Drøbakveien 14, POBox 5003, N-1432 Ås, NORWAY
> Phone: +47 64948857 Fax: +47 64948810
> http://www.nlh.no/imt
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users
Yahoo! Mail : votre e-mail personnel et gratuit qui vous suit partout !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/
Dialoguez en direct avec vos amis grâce à Yahoo! Messenger !Téléchargez Yahoo! Messenger sur http://fr.messenger.yahoo.com
More information about the postgis-users
mailing list