Timeout issue between mapserver and postgresql

zze-SIGALE PORTANERI F ext RD-BIZZ-SOP fportaneri.ext at RD.FRANCETELECOM.COM
Wed Apr 5 08:26:56 EDT 2006


Hi list,

I have a dual server configuration with :
	server 1:  Cartoweb 3 + php 5.0.3  + mapserver 4.6.0 
	server 2:  postgresql 8.0.3 + postgis 0.9.1 

Everything is OK during the first part of the session, the cartoweb well
displays the mapserver generated maps thought the postgis data, the
connection is OK.

After some time (let say 10 refresh of the about 20 layers mapfile), I
have a timeout issue :  The message is the following

FATAL ServerContext - Error in msPOSTGISLayerOpen(): couldnt make
connection to DB with connect string 'host=XXX.XXX.XXX.XXX dbname=ddddd
user=uuuuu password=pppppp'. 
Error reported was 'could not connect to server: Connection timed out Is
the server running on host "XXX.XXX.XXX.XXX" and accepting TCP/IP
connections on port 5432? '. 

The strange thing is that when this happen, I still can open a new
session (new browser window) in parallel and access to the same data (so
the database is still up and running).

Any idea to where investigate?

Thanks in advance,
Franck
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060405/42bd9eb2/attachment.html


More information about the mapserver-users mailing list