Hi,<div><br><div>no problem with :</div><div><br></div><div><div>"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"</div><div>
<br></div><div>"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"</div><div><br></div><div>"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)"</div>
<div><br></div><div><br></div><div>Fred</div><div><br></div><div><br><br><div class="gmail_quote">On Tue, Jul 10, 2012 at 1:06 PM, Nicolas Ribot <span dir="ltr"><<a href="mailto:nicolas.ribot@gmail.com" target="_blank">nicolas.ribot@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">> Ticket submitted:<br>
><br>
> <a href="http://trac.osgeo.org/postgis/ticket/1903" target="_blank">http://trac.osgeo.org/postgis/ticket/1903</a><br>
><br>
> 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.<br>
><br>
<br>
</div>Hi,<br>
Made some tests with different versions:<br>
_____________________________________<br>
Test 1: Pgis 1.5.3<br>
<br>
postgis_full_version<br>
--------------------------------------------------------------------------------------------------<br>
POSTGIS="1.5.3" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March<br>
2012" LIBXML="2.7.3" USE_STATS<br>
(1 row)<br>
<br>
Time: 16.980 ms<br>
postgis15=# select version();<br>
<br>
version<br>
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
PostgreSQL 9.1.1 on x86_64-apple-darwin11.1.0, compiled by<br>
i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc.<br>
build 5658) (LLVM build 2335.15.00), 64-bit<br>
(1 row)<br>
<br>
=> Passed.<br>
<br>
<br>
_____________________________________<br>
Test 2:<br>
Same Postgresql, postgis 2.0:<br>
POSTGIS="2.0.0" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March<br>
2012" LIBXML="2.7.3" USE_STATS (procs from 2.0 r7948 need upgrade)<br>
<br>
=> passed<br>
_____________________________________<br>
Test 3: postgis 1.5.4<br>
<div class="im">POSTGIS="1.5.4" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March<br>
2012" LIBXML="2.7.8" USE_STATS<br>
<br>
</div>=> crashes:<br>
<br>
server process (PID 11035) was terminated by signal 11: Segmentation fault<br>
psql:/Users/nicolas/Downloads/test.sql:289: connection to server was lost<br>
<div class="im">LOG: terminating any other active server processes<br>
</div><div class="im">LOG: all server processes terminated; reinitializing<br>
</div>LOG: database system was interrupted; last known up at 2012-07-10 14:02:44 CEST<br>
<div class="im">LOG: database system was not properly shut down; automatic recovery in progress<br>
</div>LOG: consistent recovery state reached at 1E/92D6D278<br>
LOG: redo starts at 1E/92D6D278<br>
LOG: record with zero length at 1E/932A6558<br>
LOG: redo done at 1E/932A6518<br>
LOG: last completed transaction was at log time 2012-07-10 14:05:10.908316+02<br>
<div class="im HOEnZb">LOG: database system is ready to accept connections<br>
<br>
<br>
</div><span class="HOEnZb"><font color="#888888">Nicolas<br>
</font></span><div class="HOEnZb"><div class="h5">_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br></div></div></div>