<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19120">
</head>
<body>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011">Hi,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011">I can repeat this problem with Mapserver 6.0.1 on Windows Vista 32-bit. I defined one PostGIS test layer without metadata and GetCapabilities fails after
a long waiting. With DEBUG 5 the last line in MS_ERRORFILE that appears is this</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011">msPostGISLayerIsOpen called.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011">Adding "wms_extent" corrects the situation. Same mapfile does work on Linux and it used to work for me on Windows too with Mapserver 5.x.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011"></span></font><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="022361913-22092011">-Jukka Rahkonen-</span></font></div>
<br>
<blockquote style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px" dir="ltr">
<div dir="ltr" lang="fi" class="OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>Lähettäjä:</b> Andreas Douvalis [mailto:anddreas2@yahoo.gr]
<br>
<b>Lähetetty:</b> 22. syyskuuta 2011 10:14<br>
<b>Vastaanottaja:</b> Rahkonen Jukka<br>
<b>Aihe:</b> Σχετ: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem<br>
</font><br>
</div>
<div></div>
<div style="BACKGROUND-COLOR: #fff; FONT-FAMILY: arial, helvetica, sans-serif; COLOR: #000; FONT-SIZE: 10pt">
<div style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 10pt">
<div class="MsoNormal"><span style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; mso-ansi-language: EN-GB" lang="EN-GB">No problem with pgsql</span><O:P></O:P></div>
<div class="MsoNormal"><span style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; mso-ansi-language: EN-GB" lang="EN-GB"><br style="mso-special-character: line-break">
<!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break">
<!--[endif]--><span><O:P></O:P></span></span></div>
<div class="MsoNormal"><span style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; mso-ansi-language: EN-GB" lang="EN-GB"><span>It takes 78 ms the sql of the layer that it doesn't work with wms get map request.
<O:P></O:P></span></span></div>
<div class="MsoNormal"><span style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; mso-ansi-language: EN-GB" lang="EN-GB"><O:P></O:P></span></div>
<div class="MsoNormal"><span style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; mso-ansi-language: EN-GB" lang="EN-GB">Unfortunately
<span style="mso-spacerun: yes"> </span>there is no debug error </span><span style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 10pt; mso-ansi-language: EN-US" lang="EN-US">to check the query that mapserver runs. </span><span style="FONT-FAMILY: Arial; COLOR: black; FONT-SIZE: 13.5pt; mso-ansi-language: EN-US" lang="EN-US"><O:P></O:P></span></div>
</div>
<div style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 10pt"><br>
</div>
<div style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 10pt">
<div style="FONT-FAMILY: 'times new roman', 'new york', times, serif; FONT-SIZE: 12pt">
<font size="2" face="Arial">
<hr size="1">
<b><span style="FONT-WEIGHT: bold">Απο:</span></b> Rahkonen Jukka <Jukka.Rahkonen@mmmtike.fi><br>
<b><span style="FONT-WEIGHT: bold">Προς:</span></b> 'anddreas2' <anddreas2@yahoo.gr>; "'mapserver-users@lists.osgeo.org'" <mapserver-users@lists.osgeo.org><br>
<b><span style="FONT-WEIGHT: bold">Στάλθηκε:</span></b> 9:32 π.μ. Πέμπτη, 22 Σεπτεμβρίου 2011<br>
<b><span style="FONT-WEIGHT: bold">Θεμα:</span></b> Re: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem<br>
</font><br>
Hi,<br>
<br>
Basically it means that the SQL query for getting the extents of your layer is slow.<br>
Set timing on with \timing on in your psql window and run query<br>
select st_extent(geom) from titles;<br>
<a href="http://postgis.refractions.net/docs/ST_Extent.html" target="_blank">http://postgis.refractions.net/docs/ST_Extent.html</a><br>
How long does it take? Do vacuum analyze for the table and try again to see if there has been some trouble with indexes.<br>
Anyway, it is always faster to get extents from the metadata line than from PostGIS, but normally it should not take very long. For me it takes 1500 ms with a table of 300000 polygons.<br>
<br>
-Jukka Rahkonen-<br>
<br>
<br>
<br>
> -----Alkuperäinen viesti-----<br>
> Lähettäjä: <a href="mailto:mapserver-users-bounces@lists.osgeo.org" ymailto="mailto:mapserver-users-bounces@lists.osgeo.org">
mapserver-users-bounces@lists.osgeo.org</a> <br>
> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" ymailto="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>] Puolesta anddreas2<br>
> Lähetetty: 22. syyskuuta 2011 8:52<br>
> Vastaanottaja: <a href="mailto:mapserver-users@lists.osgeo.org" ymailto="mailto:mapserver-users@lists.osgeo.org">
mapserver-users@lists.osgeo.org</a><br>
> Aihe: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem<br>
> <br>
> I found the solution:<br>
> <br>
> Just set THE wms_extent METADATA in the layer section and it <br>
> works. Without<br>
> Layers wms_extent it crashes.<br>
> <br>
> (Jesus, I spent three days of my life for this stupid thing. <br>
> I tested with<br>
> all versions of postgis (1.5, 1.4) postgresql (8.4,9.0,9.1). <br>
> I am think it<br>
> is ms4w problem).<br>
> <br>
> --<br>
> View this message in context: <br>
> <a href="http://osgeo-org.1803224.n2.nabble.com/Mapserver-6-WMS-PostGIS" target="_blank">
http://osgeo-org.1803224.n2.nabble.com/Mapserver-6-WMS-PostGIS</a><br>
> -Problem-tp6387007p6819004.html<br>
> Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
> _______________________________________________<br>
> mapserver-users mailing list<br>
> <a href="mailto:mapserver-users@lists.osgeo.org" ymailto="mailto:mapserver-users@lists.osgeo.org">
mapserver-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">
http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
> <br>
<br>
</div>
</div>
</div>
</blockquote>
</body>
</html>