fast-cgi

huub fleuren hfl at HOME.NL
Thu Apr 28 15:38:37 EDT 2005 

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

More information about the mapserver-dev mailing list