AW: [MS4W-Users] Issues while installing MS4W

[m at zeiteisen.net]

Hi Jeff, thanks for the again quick response! :)

I just made the change an re-run make but it cames back with the
same/similar error:

Message on the browser:
msDrawMap(): Image handling error. Failed to draw layer named 'buildings3'.
msPostGISLayerWhichShapes(): Query error. Error executing query. Check
server logs

Messages in error-log, debug 5:
[Fri Aug  7 14:08:22 2020].319000 CGI Request 1 on process 6788
[Fri Aug  7 14:08:22 2020].320000 msDrawMap(): rendering using outputformat
named png (AGG/PNG).
[Fri Aug  7 14:08:22 2020].320000 msDrawMap(): WMS/WFS set-up and query,
0.000s
[Fri Aug  7 14:08:22 2020].830000 msDrawMap(): Layer 12 (land3), 0.510s
[Fri Aug  7 14:14:17 2020].349000 msPostGISLayerWhichShapes(): Error (out of
memory for query result
) executing query: select "name"::text,ST_AsBinary(("geometry"),'NDR') as
geom,"osm_id"::text from (select geometry,osm_id, name as name from
osm_new_buildings) as foo where "geometry" &&
ST_GeomFromText('POLYGON((-8970456.38311057
3202053.95495146,-8970456.38311057 19593253.9036238,7420743.56556178
19593253.9036238,7420743.56556178 3202053.95495146,-8970456.38311057
3202053.95495146))',3857)
[Fri Aug  7 14:14:17 2020].349000 msPostGISLayerWhichShapes(): Query error.
Error executing query. Check server logs
[Fri Aug  7 14:14:17 2020].349000 msDrawMap(): Image handling error. Failed
to draw layer named 'buildings3'.
[Fri Aug  7 14:14:17 2020].350000 mapserv request processing time (msLoadMap
not incl.): 355.031s
[Fri Aug  7 14:14:17 2020].350000 msFreeMap(): freeing map at 00ACF7F8.


It takes around 6min.. ah okay you can see timing it the log.

May one more idea...?

Thanks a lot and regards,
Markus


-----Ursprüngliche Nachricht-----
Von: MS4W-Users <ms4w-users-bounces at lists.ms4w.com> Im Auftrag von Jeff
McKenna via MS4W-Users
Gesendet: Freitag, 7. August 2020 13:32
An: Discussions for MS4W (MapServer for Windows) <ms4w-users at lists.ms4w.com>
Cc: Jeff McKenna <jmckenna at gatewaygeomatics.com>
Betreff: Re: [MS4W-Users] Issues while installing MS4W

Hi Markus,

Please see Step9 of the document
(https://github.com/mapserver/mapserver/wiki/RenderingOsmDataWindows#map-gen
),
specifically the second bullet point:

  - Next open the file /basemaps/Makefile in Notepad++
      change line#13 to:
              OSM_PREFIX?=osm_new_


You will then have to re-run 'make'


Thank you for using MS4W.
"MS4W: open doors as well as windows"


--
Jeff McKenna
MapServer Consulting and Training Services co-founder of FOSS4G
http://gatewaygeo.com/




On 2020-08-07 8:08 a.m., Markus via MS4W-Users wrote:
> 
> Hello all!
> 
> I hope anybody can help me..
> 
> I am trying to setup my personal MS4W mapserver but facing some issues 
> related to the database, I guess.
> 
> I used the HowTo 
> https://github.com/mapserver/mapserver/wiki/RenderingOsmDataWindows
> 
> When it come to mapfile creation then I see the map file containing 
> table names like e.g. osm_buildings instead of osm_new_buildings.
> 
> In the Postgres DB they are all with _/new/_ hence I changed all table 
> name entries in the map file to include _/new/_ manually but I get error 
> messages.
> 
> Manually changing this worked on a test laptop with a small set 
> (germany-latest.osm.pbf) but it does not work on my main machine where I 
> want to get europe-latest.osm.bz2 in place.
> 
> I get  similar errors when I test with shp2img.
> 
> The errors are related to memory but I don´t believe thatthis is really 
> the problem also as I have 16GB RAM installed and ist not utilized more 
> than 20%.
> 
> Hence I guess it has to do with the tables or so.
> 
> No other errors popped up while working through the HowTo.
> 
> Some specs:
> 
> Windows 10
> 
> I7 -3520 2.9
> 
> 2TB SSD drive 50% utilized
> 
> 16BG RAM
> 
> PostgreSQL 10
> 
> MS4W 4.0.3
> 
> I hope anybody can give me a steer on where to look..
> 
> Thanks a lot and regards,
> 
> Markus
> 

_______________________________________________
MS4W-Users mailing list
MS4W-Users at lists.ms4w.com
https://lists.ms4w.com/mailman/listinfo/ms4w-users