[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