Hi, no problem with :
"POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.6" USE_STATS" "POSTGIS="1.5.3" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.8" USE_STATS" "POSTGIS="2.0.0 r9605" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" LIBJSON="UNKNOWN" (core procs from "2.0.0beta2 r9428" need upgrade) (topology procs from "2.0.0beta2 r9428" need upgrade) (raster procs from "2.0.0beta2 r9428" need upgrade)" Fred On Tue, Jul 10, 2012 at 1:06 PM, Nicolas Ribot <nicolas.ri...@gmail.com>wrote: > > Ticket submitted: > > > > http://trac.osgeo.org/postgis/ticket/1903 > > > > But the crash problem seems not to happen for everyone. At least, the > attached SQL file will crash my PostgreSQL 1.5.4 on Mac OS X 10.7.4 every > time. But not for Paul. Would some of you be able to test it on your setup, > to see if we can spot a pattern or connection? Thanks. > > > > Hi, > Made some tests with different versions: > _____________________________________ > Test 1: Pgis 1.5.3 > > postgis_full_version > > -------------------------------------------------------------------------------------------------- > POSTGIS="1.5.3" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March > 2012" LIBXML="2.7.3" USE_STATS > (1 row) > > Time: 16.980 ms > postgis15=# select version(); > > version > > -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > PostgreSQL 9.1.1 on x86_64-apple-darwin11.1.0, compiled by > i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. > build 5658) (LLVM build 2335.15.00), 64-bit > (1 row) > > => Passed. > > > _____________________________________ > Test 2: > Same Postgresql, postgis 2.0: > POSTGIS="2.0.0" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March > 2012" LIBXML="2.7.3" USE_STATS (procs from 2.0 r7948 need upgrade) > > => passed > _____________________________________ > Test 3: postgis 1.5.4 > POSTGIS="1.5.4" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March > 2012" LIBXML="2.7.8" USE_STATS > > => crashes: > > server process (PID 11035) was terminated by signal 11: Segmentation fault > psql:/Users/nicolas/Downloads/test.sql:289: connection to server was lost > LOG: terminating any other active server processes > LOG: all server processes terminated; reinitializing > LOG: database system was interrupted; last known up at 2012-07-10 > 14:02:44 CEST > LOG: database system was not properly shut down; automatic recovery in > progress > LOG: consistent recovery state reached at 1E/92D6D278 > LOG: redo starts at 1E/92D6D278 > LOG: record with zero length at 1E/932A6558 > LOG: redo done at 1E/932A6518 > LOG: last completed transaction was at log time 2012-07-10 > 14:05:10.908316+02 > LOG: database system is ready to accept connections > > > Nicolas > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users