[postgis-users] Postgres segfaults on some geometry functions

[Paul Ramsey]

All three of those worked for me just fine on Linux, similar version 
profile. It is possible we are having some platform problems, GEOS is 
undertested on Solaris.


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))');
dra_conflation=# 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))');
                                 geomunion
--------------------------------------------------------------------------
  SRID=-1;POLYGON((0.5 1,0.5 1.5,1.5 1.5,1.5 0.5,1 0.5,1 0,0 0,0 1,0.5 1))
(1 row)

dra_conflation=# 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))');
                     intersection
----------------------------------------------------
  SRID=-1;POLYGON((0.5 0.5,0.5 1,1 1,1 0.5,0.5 0.5))
(1 row)


Havard Tveite wrote:

> 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?
> 


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_