fast-cgi
Fernando Simon
fsimon at UNIVALI.BR
Thu Apr 28 13:32:45 EDT 2005
Hi,
I don't believe that exist dependence between the Oracle and
Mapserver, the access uses the OCI calls and Mapserver access
maporaclespatial directly.
I believe that it's just a problem with the flag. Here in my tests
worked perfectly using the --enable.
Just a hint, to compile with the Oracle Spatial support in Windows
I reccomend the MVisual Studio 6.0 with last patch or 7.0 version.
You can see the 1244 bug
(http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1244) to see the
history about this problem.
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 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> 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>:
>
> >> 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>
>
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>
>
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> 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> 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
> >> >> 'hn_auto'.
> >> >> msOracleSpatialLayerWhichShapes(): OracleSpatial error.
> *Cannot
> >> >> allocate items buffer*
> >> >> </ServiceException>
> >> >> </ServiceExceptionReport>
> >> >>
> >> >>
> >> >> i found this in the archives
> >> >>
> >>
> 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
>
-------------------------------------------------
Univali - Webmail - http://webmail.univali.br
More information about the mapserver-dev
mailing list