[postgis-users] Postgres segfaults on some geometry functions

Havard Tveite havard.tveite at nlh.no
Tue May 11 09:06:30 PDT 2004


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



More information about the postgis-users mailing list