[UMN_MAPSERVER-USERS] CGI Error - 4.4 Windows Binaries

Fri Dec 3 11:15:38 EST 2004

Hi Fernando,

I made more tests this morning with some wierd results:

First, sometimes it works sometimes not, depending of either the zoom level or the layers activated.

If I ask for one oracle spatial layer, I got the error each time and instantly.
If I ask for an other type of layer than oracle spatial, all work fine.
If I ask for mixed type of layers with oracle spatial included, it become complicated...it seems that the order of the layers in the mapfile have an effect; if the first layer found (and asked) in the mapfile is oracle spatial, it get an error.  If it's a raster or something else, it works most of the time.

I ran FileMon to see if this is a permission or file not found issue and it's not.

I checked IIS log file and when I get an error, the http status code is 502:
2004-12-03 15:43:00 131.235.233.138 131.235.233.138 80 GET /cgi-bin/mapserv.exe 502 0 391 -
When this happens, the sc-bytes number is always 391
I searched for the meaning of http 502 and found this from the w3c.org website:
Service temporarily overloaded 502 (TO BE DISCUSSED) 
The server cannot process the request due to a high load (whether HTTP servicing or other requests). The implication is that this is a temporary condition which maybe alleviated at other times. 
OR
502 Bad Gateway
The server, while acting as a gateway or proxy, received an invalid response from the upstream server it accessed in attempting to fulfill the request. 

First I thought that the reason is because my dev workstation is inside our firewall and Oracle Database is outside...but I tested with an Oracle database inside our firewall and the result is the same.

When I shift to previous version (4.3 with oracle spatial downloaded from maptools.org) all work fine.
Now I'm lost...

I download my binaries from Howard site at : http://hobu.stat.iastate.edu/mapserver/
Here's the mapserv -v result:
MapServer version 4.4.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=PDF OUTPUT=SWF SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE

How could you have such a complete log from mapserver ? When I got the error, I have no line add to my mapserver log...
I'm on Windows 2000 SP4 with IIS 5.0

Thank you very much for your help Fernando.  If someone other than Fernando has any idea of what I could do to find the solution, you're welcome!

Nicolas

-----Message d'origine-----
De : Fernando S. [mailto:simon at inf.univali.br] 
Envoyé : Friday, December 03, 2004 5:31 AM
À : Fortin,Nicolas [SteFoy]
Cc : MAPSERVER-USERS at LISTS.UMN.EDU
Objet : Re: RE : [UMN_MAPSERVER-USERS] CGI Error - 4.4 Windows Binaries (Oracle, SDE, and others)

Hi Nicolas,
    I tried to reproduce your system here, but the mapserver ran without 
problems. I tried call mapserver to draw one raster layer and one oracle 
layer. In both cases draw correctly.
   This is the mapserver log for cgi requests:
For raster layer:
CGI Request 1 on process 24964
msDrawRasterLayerLow(raster): entering.
msDrawGDAL(): src=1236,745,133,133, dst=0,0,555,555
msDrawMap(): Layer 1 (raster), 0.078s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.079s

For Oracle Spatial Layer:
CGI Request 1 on process 24965
msOracleSpatialLayerOpen called with: geom from bairros msOracleSpatialLayerOpen. Shared connection not available. Creating one.
msConnPoolRegister(Bairros,XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msOracleSpatialLayerFreeItemInfo was called. msOracleSpatialLayerInitItemInfo was called. msOracleSpatialLayerWhichShapes was called. msOracleSpatialLayerFreeItemInfo was called. msOracleSpatialLayerClose was called. Layer connection: themis/themis at lca msOracleSpatialLayerClose. Cleaning Oracle handlers.
msConnPoolRelease(Bairros,XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msConnPoolClose(XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msOracleSpatialLayerClose. Cleaning layerinfo handlers.
msDrawMap(): Layer 19 (Bairros), 0.149s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.151s

For both in the same map:
CGI Request 1 on process 24966
msDrawRasterLayerLow(raster): entering.
msDrawGDAL(): src=1236,745,133,133, dst=0,0,555,555
msDrawMap(): Layer 1 (raster), 0.087s
msOracleSpatialLayerOpen called with: geom from bairros msOracleSpatialLayerOpen. Shared connection not available. Creating one.
msConnPoolRegister(Bairros,XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msOracleSpatialLayerFreeItemInfo was called. msOracleSpatialLayerInitItemInfo was called. msOracleSpatialLayerWhichShapes was called. msOracleSpatialLayerFreeItemInfo was called. msOracleSpatialLayerClose was called. Layer connection: themis/themis at lca msOracleSpatialLayerClose. Cleaning Oracle handlers.
msConnPoolRelease(Bairros,XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msConnPoolClose(XXXXXXXX/XXXXXXXXXXX at XXXXX,0x8313210)
msOracleSpatialLayerClose. Cleaning layerinfo handlers.
msDrawMap(): Layer 19 (Bairros), 0.231s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.320s

    Here I'm using mapserver running in my desktop Linux (Slackware) and 
this is my version: MapServer version 4.4.0 OUTPUT=GIF OUTPUT=PNG 
OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF SUPPORTS=PROJ SUPPORTS=FREETYPE 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
SUPPORTS=WFS_CLIENT SUPPORTS=FASTCGI INPUT=TIFF INPUT=EPPL7 
INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=MSDEBUG
    So, what occur when you draw layers separately? I will try to 
reproduce the same in my windows, but where you download your mapserver 
version?
    Thanks

---------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
LCA - http://g10.cttmar.univali.br
---------------------------------------------

Fortin,Nicolas [SteFoy] wrote:

>Hi Fernando and List,
>
>I use an ASP page that call mapserver CGI with the correct mapfile.  I 
>use mapserver html template to test my services. It's not query mode 
>but simple GetMap requests.
>
>One weird thing I saw with some testing :
>If I ask for two layers, a raster and an oracle spatial one by example, 
>all work fine and I get an image! If I ask ONLY for oracle spatial 
>layers (1 or more), I get the CGI error message...
>
>So I think the problem is not really the connection cause the layer(s) 
>appear when it's not alone and with another type of Data.
>
>Calling mapserver directly with the usual parameter gives the same 
>result.
>
>What's wrong with this? If anybody could help me solve this...
>
>What's FastCGI ?
>
>Nicolas
>
>  
>