[postgis-devel] Issue 119 in postgis: ST_AsSVG crashedDBbackendwith large geometries.

[Courtin Olivier]

On Mar 10, 2009, at 12:30 AM, Obe, Regina wrote:

Regina,
> I retested on my same box (blowing out my whole svn and  
> redownloading from scratch and still run into the same issues.).
>
> I'll be able to test on windows aond my other OpenSUSe tomorrow.
>

Ok let me know...
> Anyrate I am running
> "POSTGIS="1.4.0SVN" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.0, 21 Dec  
> 2007" USE_STATS"  (also verifeid it was built minutes ago)
>
> "PostgreSQL 8.3.1 on i686-pc-linux-gnu, compiled by GCC gcc (SUSE  
> Linux) 4.3.1 20080507 (prerelease) [gcc-4_3-branch revision 135036]"
>
> I wonder if its my gcc or something that is the culprit.  Below is  
> list of things that works and what crashes. Seems to crash when it  
> gets to polygons. If others could test on their platforms that would  
> be super.
>
Do you have the same one with following compilation procedure ?
CFLAGS="-g -O0" ./configure
make clean
make
sudo make install
> --polygon crashes server
>         SELECT ST_AsSVG(foo1.the_geom)
>
>                         FROM ((SELECT  
> ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j)  As the_geom
>                 FROM generate_series(-10,50,10) As i
>                         CROSS JOIN generate_series(40,70, 20) As j))  
> As foo1;
>

Could you create a postgis database foo and then run as a postgres user:

echo "SELECT ST_AsSVG(foo1.the_geom) FROM ((SELECT  
ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j)  As the_geom FROM  
generate_series(-10,50,10) As i CROSS JOIN generate_series(40,70, 20)  
As j)) As foo1;" | valgrind --leak-check=yes -v --run-libc-freeres=no  
--show-reachable=yes --log-file=valgrindlog /usr/local/pgsql/bin/ 
postgres --single -D /var/pgsql/data foo

and so valgrindlog file could be interresting...

--
Olivier