Problems with Mapserv and ArcSDE layer

Ivano Picco ivano.picco at AQUPI.TK
Tue May 15 08:27:05 PDT 2007


Hi all!, 
In the last days I made some performance and reliability tests on mapserv using CGI or 
FastCGI on Apache or Lighttpd and connection from Oracle (native and OGR) or ArcSDE.
I've found a problem on Oracle native connection with FastCGI related to the memory leak 
bug (1662) and on ArcSDE with CGI but I don't found anything  about this second on ml or 
trac.
This is the problem: 
Using a layer defined as this:
LAYER
    NAME "CTR-SDE"
    STATUS ON
    DEBUG ON
    DATA "ctr_sde.comuni,SHAPE"
    TYPE POLYGON
    CONNECTIONTYPE SDE
    CONNECTION "myserv,port:5153,esri_sde,sde,sde"
    PROCESSING "CLOSE_CONNECTION=DEFER"
    TEMPLATE "template.html"
    METADATA
      "WMS_SRS"    "EPSG:32632"
      "WMS_NAME"    "Comuni_SDE"
      "WMS_TITLE"    "Comuni_SDE"
      "WMS_ABSTRACT"    "Comuni SDE"
    END
    CLASS
      STYLE
        OUTLINECOLOR 0 0 0
        ANTIALIAS TRUE
      END
    END
  END
and after 5 minutes long stress test with 16 contemporary connection on mapserv with this 
URL :
http://mywebserv/cgi-bin/mapserv?VERSION=1.1.1&REQUEST=GetMap&WIDTH=550&HEIGHT=400&FORMAT=image/png&BBOX=225917.72,4878835.47,600524.92,5151277.07&TRANSPARENT=TRUE&BGCOLOR=0xFFFFFF&SRS=EPSG:32632&SERVICENAME=OGC:WMS&STYLES=&LAYERS=CTR-SDE
I see many cgi processes in memory. These processes still remain until web server restart. 
This doesn't happen using both Oracle connection type and the same stress test .
What do I do wrong?
Thanks,
sorry for my english,
Ivano


P.S. this is the output from mapserv -v:
MapServer version 4.10.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP 
OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER 
SUPPORTS=GEOS INPUT=EPPL7 INPUT=SDE INPUT=ORACLESPATIAL INPUT=OGR 
INPUT=GDAL INPUT=SHAPEFILE



More information about the MapServer-users mailing list