[postgis-users] 'server closed the connection unexpectedly' problem

[strk at refractions.net]

On Fri, Jan 28, 2005 at 10:36:26AM -0800, Ionut Iordache wrote:
> Hello,
> 
> srn> MM.. this is the second weird bug report related to points, but I
> srn> can't reproduce this as well (PGGIS-1.0.0RC2 / PGSQL-7.4.3).
> 
> srn> Can you try RC2, creating a *new* db ?
> srn> Can reproduce the bug on a single record ?
> srn> What OS are you using ? Which compiler used to build postgis ?
> 
> srn> --strk;
> 
> Yes, I can reproduce the bug on a single point in a brand new db, with
> my current postgis version...
> 
> I'll give it a try with RC2, although if it works it will be really
> painful to transfer again the 45GB or more of data that I loaded before
> extensively testing my release :(
> 
> I should have mentioned in my initial post, my os is Solaris 8 (sparc)
> and everything compiled with gcc 3.4.1.
> 
> Anyway, is there anything more that I can do to troubleshot this
> problem? It's very frustrating because even with debug5 enabled in the
> logs, there's no hint about what goes wrong... I have the suspicion
> that things break when postgres tries to actually load and use symbols
> from liblwgeom.so.1.0

You can use a memory debugger, gdb or valgrind. Attached to the
postgres process. You might want to follow the thread with subject:
``Crash when creating index on ( int, geom )''. There Mark Cave-Ayland
is helping in running gdb.

> 
> The only anomaly during compilation was that I had to specifically
> link it against the gcc library because my configuration uses sun's
> linker and it couldn't find a symbol (eprintf if I remember correctly)
> defined in a static gcc library.

asprintf, probably, which is a GNU extension.
lwgeom/vsprintf.c contains it's implementation, anyway, so you
shouldn't get a warning (it is defined in lwgeom/compat.h).

--strk;

> 
> Regards,
> Dorel
> 
> 
> Friday, January 28, 2005, 12:04:20 AM, you wrote:
> 
> srn> On Thu, Jan 27, 2005 at 12:48:37PM -0800, Ionut Iordache wrote:
> >> Hello,
> >> 
> >> I recently loaded large quantities of point data (close to half a
> >> billion records) into postgresql-7.4.6 with postgis-cvs version 1.0.0
> >> (as of 2005/01/13) and although the geometry creation and table
> >> loading went smoothly, I can't use any of the postgis functions on the
> >> POINT geometry columns!
> >> 
> >> For example, when I try to run something like SELECT X(point_geom)
> >> FROM raw_data LIMIT 10; , I get the following error message:
> >> 
> >> 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.
> >> 
> >> The same thing happens when I try to execute the Distance function for
> >> example. But if I do a SELECT AsText(point_geom), the records show up
> >> just fine...
> >> 
> >> The log is not showing anything suspicious, except reporting that the
> >> child process was terminated by signal 10.
> >> I compiled postgres with LDFLAGS = -lstdc++ -lgcc and enabled geos and
> >> proj4 in postgis.
> >> 
> >> Thanks for you assistance!
> 
> 
> 
> >> 
> >> -- 
> >> Best regards,
> >> -----------------------------------------------
> >> Dorel Ionut Iordache - <ionut at eps.berkeley.edu>
> >> UC Berkeley - Earth & Planetary Science Dept.
> >> 
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> srn> _______________________________________________
> srn> postgis-users mailing list
> srn> postgis-users at postgis.refractions.net
> srn> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> -- 
> Best regards,
> -----------------------------------------------
> Dorel Ionut Iordache - <ionut at eps.berkeley.edu>
> UC Berkeley - Earth & Planetary Science Dept.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users