[OSM-dev] help

Tom E. enterlit at comcast.net
Sat Mar 26 15:01:04 GMT 2011


On 03/26/2011 08:00 AM, dev-request at openstreetmap.org wrote:
> Send dev mailing list submissions to
> 	dev at openstreetmap.org
>
> 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
> 	dev-request at openstreetmap.org
>
> You can reach the person managing the list at
> 	dev-owner at openstreetmap.org
>
> 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<steve.westrip at metafour.com>
> To: dev at openstreetmap.org
> Subject: [OSM-dev] Tirex and postgres seem to become disconnected
> Message-ID:
> 	<AANLkTikQ+ZMLHmPXnok9h6mN-9su8W56bqF+hcRYyOCo at mail.gmail.com>
> 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<jburgess777 at gmail.com>
> To: Stephen Westrip<steve.westrip at metafour.com>
> Cc: dev at openstreetmap.org
> Subject: Re: [OSM-dev] Tirex and postgres seem to become disconnected
> Message-ID:<1301075986.4193.10.camel at shark.nightingale.homedns.org>
> 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
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>
>
> End of dev Digest, Vol 72, Issue 34
> ***********************************
>




More information about the dev mailing list