fast-cgi

Fernando Simon fsimon at UNIVALI.BR
Thu Apr 28 15:55:16 EDT 2005 

Hi,
    The problem was solved, the "ifdef" in SDOPointObj was wrong. This
is a internal maporaclespatial object (only used for Oracle Spatial),
and for this object the OCI need the z value. Now I'm finishing the
tests, after this I will commit the code. So tomorrow you can use cvs
version of maporaclespatial with --disable flag. :)
    Just a little question that I saw in the code, the Oracle Spatial
is the unique that read and set the real z value for point object?
The PostGIS, Proj, OGR and MYSql set, by default, the z value to
zero, it's right?
    Thanks.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://g10.cttmar.univali.br - UNIVALI/CTTMAR
------------------------------------------------------------------------


Citando huub fleuren <hfl at HOME.NL>:

> Hallo Fernando,
>
> Well, i have the complete picture, thanks to you, so thank you.
> Wicked option this USE_POINT_Z_M
>
> Back to the original problem.
> I see that, after a little use of the application, there are 8
> mapserver.fcgi's in memory, every request still increases
> memoryusage
>
> Also, i don't get the feeling that fcgi really is faster.
> I suppose i 'll look a little more into it tomorrow.
>
> its AZ - SPORTING PORTUGAL for the moment ;-)
>
>
> Thanks again.
> Greetings, Huub
>
> Thursday, April 28, 2005, 7:32:45 PM, you wrote:
>
> FS> Hi,
> FS>     I don't believe that exist dependence between the Oracle
> and
> FS> Mapserver, the access uses the OCI calls and Mapserver access
> FS> maporaclespatial directly.
> FS>     I believe that it's just a problem with the flag. Here in
> my tests
> FS> worked perfectly using the --enable.
> FS>     Just a hint, to compile with the Oracle Spatial support in
> Windows
> FS> I reccomend the MVisual Studio 6.0 with last patch or 7.0
> version.
> FS>     You can see the 1244 bug
> FS> (http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1244) to see
> the
> FS> history about this problem.
> FS>     Thanks.
>
> FS>
>
------------------------------------------------------------------------
> FS> Fernando Simon
> FS> Mapserver and Oracle Spatial developer
> FS> G10 - Laboratorio de Computacao Aplicada - Brazil
> FS> http://g10.cttmar.univali.br - UNIVALI/CTTMAR
> FS>
>
------------------------------------------------------------------------
>
> FS> Citando huub fleuren <hfl at HOME.NL>:
>
> >> Hallo Fernando,
> >>
> >> well obviously it was disabled in the makefile
> >> what could be the difference with our situations ?
> >> any other dependence ?
> >>
> >> # If you want to use shape Z and M parameter this option must
> be
> >> set.
> >> # It's OFF by default.
> >> #USE_POINT_Z_M=-DUSE_POINT_Z_M
> >> USE_POINT_Z_M=
> >>
> >>
> >>
> >> Thursday, April 28, 2005, 4:30:42 PM, you wrote:
> >>
> >> FS> Hi,
> >> FS>     I saw this problem in my tests. It's related with 1244
> bug.
> >> Im my
> >> FS> tests the data only appear if I specify a
> --enable-point-z-m
> >> flag.
> >> FS> I'm checking the last version of maporaclespatial.c, but for
> me
> >> it's
> >> FS> nice, without problem.
> >> FS>     Can be a another problem ? (another code in the
> source?)
> >> FS>     Any tests with --disable-point-z-m flag?
> >> FS>     Thanks.
> >>
> >> FS>
> >>
> FS>
>
------------------------------------------------------------------------
> >> FS> Fernando Simon
> >> FS> Mapserver and Oracle Spatial developer
> >> FS> G10 - Laboratorio de Computacao Aplicada - Brazil
> >> FS> http://g10.cttmar.univali.br - UNIVALI/CTTMAR
> >> FS>
> >>
> FS>
>
------------------------------------------------------------------------
> >>
> >>
> >>
> >> FS> Citando huub fleuren <hfl at HOME.NL>:
> >>
> >> >> Hi List,
> >> >>
> >> >> I managed to compile mapserver4_6beta1 from cvs with the
> latest
> >> >> maporaclespatial.c
> >> >> (with Microsoft (R) 32-bit C/C++ Optimizing Compiler Version
> >> >> 12.00.8168 for 80x86)
> >> >> using makefile.vc that comes with the source distribution
> 4.4.2
> >> >>
> >> >> fcgi-2.4.0
> >> >> gdal-1.2.6
> >> >> gdwin32
> >> >> mapserver.head
> >> >> oracle10g
> >> >> proj-4.4.9
> >> >> regex-0.12
> >> >>
> >> >> The resulting server works with the demodata (canada) and
> also
> >> a
> >> >> shapefile in the used EPSG:28992
> >> >>
> >> >> But, I get no image if i use OracleSpatial layers
> >> >>
> >> >> compare:
> >> >> (the black lines are a from a shapefile).
> >> >>
> >> FS>
> >>
> FS>
>
http://213.197.234.107/cgi-bin/mapserv-4_5/mapserv.exe?map=test.map&service=wms&request=GetMap&version=1.1.1&layers=ref1,gemeenten&srs=EPSG:28992&bbox=108557.14285714285,476500,143442.85714285714,498500&width=684&height=280&format=image/gif&transparent=TRUE
> >> >>
> >> FS>
> >>
> FS>
>
http://213.197.234.107/cgi-bin/mapserv-4_6beta/mapserv.exe?map=test.map&service=wms&request=GetMap&version=1.1.1&layers=ref1,gemeenten&srs=EPSG:28992&bbox=108557.14285714285,476500,143442.85714285714,498500&width=684&height=280&format=image/gif&transparent=TRUE
> >> >>
> >> >>
> >> >> below some information
> >> >> the only difference is WMS CLIENT WFS SERVER/CLIENT
> >> >> i don't expect to need it
> >> >>
> >> >>
> >> >> Microsoft Windows 2000 [Version 5.00.2195]
> >> >>
> >> >> mapserv -v
> >> >>
> >> >> MapServer version 4.5 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG
> >> OUTPUT=WBMP
> >> >> SUPPORTS=PROJ
> >> >> SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
> >> >> SUPPORTS=WFS_SERVER
> >> >> INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
> >> >> DEBUG=MSDEBUG
> >> >>
> >> >>
> >> >> MapServer version 4.6.0-beta1 OUTPUT=GIF OUTPUT=PNG
> OUTPUT=JPEG
> >> >> OUTPUT=WBMP
> >> >> OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE
> SUPPORTS=WMS_SERVER
> >> >> INPUT=ORACLESPATIAL
> >> >> INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=MSDEBUG
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> Wednesday, April 27, 2005, 2:48:49 PM, you wrote:
> >> >>
> >> >> FS> Hi Hubb,
> >> >> FS>     I saw this problem with an old version of
> >> >> maporaclespatial.c. But in
> >> >> FS> my tests I saw that the same problem with memory occour
> >> without
> >> >> Oracle
> >> >> FS> Spatial connection, near +0.5% (I have 512Mb in my
> system)
> >> for
> >> >> every
> >> >> FS> fastcgi request.
> >> >> FS>     I updated a big fix to the maporaclespatial.c in the
> >> last
> >> >> month, I
> >> >> FS> don't know what version Bart used. But I believe that
> the
> >> last
> >> >> version
> >> >> FS> can solve the memory problem. I will check the last
> version
> >> >> with
> >> >> FS> fastcgis support.
> >> >> FS>     About the error message, it's occour when the system
> >> can't
> >> >> allocate
> >> >> FS> more memory to mapserver (maporaclespatial.c).
> >> >> FS>     Bart, what version of maporaclespatial.c was used?
> >> >> FS>     Thanks.
> >> >>
> >> >> FS>
> >> >>
> >> FS>
> >>
> FS>
>
------------------------------------------------------------------------
> >> >> FS> Fernando Simon
> >> >> FS> Mapserver and Oracle Spatial developer
> >> >> FS> G10 - Laboratorio de Computacao Aplicada - Brazil
> >> >> FS> http://g10.cttmar.univali.br - UNIVALI/CTTMAR
> >> >> FS>
> >> >>
> >> FS>
> >>
> FS>
>
------------------------------------------------------------------------
> >> >>
> >> >> FS> Huub wrote:
> >> >>
> >> >> >> Hi list (Bart),
> >> >> >>
> >> >> >> i'm looking at a few thing concerning fastcgi and oracle
> >> >> spatial.
> >> >> >>
> >> >> >> We're using OracleSpatial10g and fastcgi in a 4.5
> compile,
> >> >> actually it
> >> >> >> was compiled by Bart van den Eijnden :-) from recent
> sources
> >> >> >> We found that every maprefresh uses more and more memory,
> >> it's
> >> >> never
> >> >> >> released.
> >> >> >> Maybe that this has got something to do with the included
> >> error
> >> >> >>
> >> >> >> fastcgi is supposed to keep open connections, but i think
> it
> >> >> does
> >> >> >> something more.
> >> >> >> just now i stopped apache and memoryusage dropped from
> 2.5Gb
> >> to
> >> >> 300Mb ....
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> <?xml version='1.0' encoding="ISO-8859-1" standalone="no"
> ?>
> >> >> >> <!DOCTYPE ServiceExceptionReport SYSTEM
> >> >> >>
> >> >>
> >>
> "http://schemas.opengeospatial.net/wms/1.1.1/exception_1_1_1.dtd">
> >> >> >> <ServiceExceptionReport version="1.1.1">
> >> >> >> <ServiceException>
> >> >> >> msDrawMap(): Image handling error. Failed to draw layer
> >> named
> >> >> >> &#39;hn_auto&#39;.
> >> >> >> msOracleSpatialLayerWhichShapes(): OracleSpatial error.
> >> *Cannot
> >> >> >> allocate items buffer*
> >> >> >> </ServiceException>
> >> >> >> </ServiceExceptionReport>
> >> >> >>
> >> >> >>
> >> >> >> i found this in the archives
> >> >> >>
> >> >>
> >> FS>
> >>
> FS>
>
(http://mapserver.gis.umn.edu/wilma/mapserver-dev/0409/msg00149.html)
> >> >> >> where the error is 'thrown'
> >> >> >>
> >> >> >> > /* allocate enough space for items */
> >> >> >> > if (layer->numitems > 0) {
> >> >> >> > layerinfo->items = (item_text_array *)malloc(
> >> >> >> > sizeof(item_text_array) * layer->numitems );
> >> >> >> > if (layerinfo->items == NULL)  {
> >> >> >> > msSetError( MS_ORACLESPATIALERR,
> >> >> >> > "Cannot allocate items buffer",
> >> >> >> > "msOracleSpatialLayerWhichShapes()" );
> >> >> >> > return MS_FAILURE;
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >>
> >> >>  huub
> >> >>
> >>
> >>
> >>
> >>
> >> FS> -------------------------------------------------
> >> FS>   Univali - Webmail - http://webmail.univali.br
> >>
> >>
> >>
> >> --
> >>
> >>  huub
> >>
>
>
>
>
> FS> -------------------------------------------------
> FS>   Univali - Webmail - http://webmail.univali.br
>
>
>
> --
>
>  huub
>




-------------------------------------------------
  Univali - Webmail - http://webmail.univali.br

More information about the mapserver-dev mailing list