On 03/26/2011 08:00 AM, [email protected] wrote:
Send dev mailing list submissions to [email protected]To subscribe or unsubscribe via the World Wide Web, visit http://lists.openstreetmap.org/listinfo/dev or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of dev digest..." Today's Topics: 1. Tirex and postgres seem to become disconnected (Stephen Westrip) 2. Re: Tirex and postgres seem to become disconnected (Jon Burgess) ---------------------------------------------------------------------- Message: 1 Date: Fri, 25 Mar 2011 16:32:07 +0000 From: Stephen Westrip<[email protected]> To: [email protected] Subject: [OSM-dev] Tirex and postgres seem to become disconnected Message-ID: <[email protected]> Content-Type: text/plain; charset="windows-1252" Hi, I posted an entry a while ago asking for help regarding the rendering of high detail tiles that always timed out. I got some helpful advice and I have done some further investigation it looks like the Postgres process, which is on a separate server, get disconnected from the Tirex process before either has timed out. What I am seeing is the Postgres processes on the database server running for many minutes and the Tirex processes on the rendering server timing out after 10 minutes (the default in tirex.conf). It also looks like the Postgres process, before the Tirex process times out, disconnects from the Tirex process. What all this means is that I cannot render any tiles from levels 1-12 and that the database server gets very overloaded with Postgres processes. Does anyone have any ideas as to what might be causing this and more importantly does anyone know how to fix it!!? Many thanks, Stephen Westrip * * Stephen Westrip ? Metafour UK Ltd ? 2 Berghem Mews, London W14 0HN ? registered in England: 01528556 tel: 020 7912 2000 ? direct: 020 7912 2015 ? mobile: 07807 212209 ? website: www.metafour.com This email is private& confidential; if you received it in error, please notify us and delete it from your system -------------- next part -------------- An HTML attachment was scrubbed... URL:<http://lists.openstreetmap.org/pipermail/dev/attachments/20110325/09a843c2/attachment-0001.html> ------------------------------ Message: 2 Date: Fri, 25 Mar 2011 17:59:46 +0000 From: Jon Burgess<[email protected]> To: Stephen Westrip<[email protected]> Cc: [email protected] Subject: Re: [OSM-dev] Tirex and postgres seem to become disconnected Message-ID:<[email protected]> Content-Type: text/plain; charset="UTF-8" On Fri, 2011-03-25 at 16:32 +0000, Stephen Westrip wrote:Hi, I posted an entry a while ago asking for help regarding the rendering of high detail tiles that always timed out. I got some helpful advice and I have done some further investigation it looks like the Postgres process, which is on a separate server, get disconnected from the Tirex process before either has timed out. What I am seeing is the Postgres processes on the database server running for many minutes and the Tirex processes on the rendering server timing out after 10 minutes (the default in tirex.conf). It also looks like the Postgres process, before the Tirex process times out, disconnects from the Tirex process. What all this means is that I cannot render any tiles from levels 1-12 and that the database server gets very overloaded with Postgres processes. Does anyone have any ideas as to what might be causing this and more importantly does anyone know how to fix it!!?Some possibilities: - Is postgresql "statement_timeout" set? - Is there a firewall configured on either host? This might be dropping the connection due to inactivity. Try setting the postgresql 'tcp_keepalives_idle=300' which should make it send a keepalive packet every 5 minutes (or maybe try something even smaller). Jon ------------------------------ _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev End of dev Digest, Vol 72, Issue 34 ***********************************
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
