[postgis-users] crashing PostgreSQL connections

James Marca jmarca at translab.its.uci.edu
Tue May 17 12:43:41 PDT 2005


At approximately Wed, May 04, 2005 at 11:39:10AM +0200, Markus Schaber wrote:
> Hi, James,
> 
> James Marca wrote:
> 
> > james at emma:~$ psql -U slash -d crash -c "SELECT 'SRID=32611;POINT(414160.003328498 3726591.60052614))'::geometry;"
> > server closed the connection unexpectedly
> >         This probably means the server terminated abnormally
> >         before or while processing the request.
> > connection to server was lost
> 
> I cannot reproduce this behaviour with current 1.0.1CVS branch, I get
> "ERROR:  parse error - invalid geometry"

Markus you were absolutely correct.  I recompiled PostGIS to 1.0 and
the bugs I reported are gone. My current "postgis_full_version()
reads:

 POSTGIS="1.0.0" GEOS="2.1.0" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
 DBPROC="0.3.0" RELPROC="0.3.0"

and the crashes I got before are now just handled as errors, as
you said.  

Sorry about the noise!

James




More information about the postgis-users mailing list