Re: psql 9.3 automatic recovery in progress

> On 10 Oct 2016, at 21:43, Periko Support <pheriko(dot)support(at)gmail(dot)com> wrote:
>
> For the life time in odoo session, can u point me where I can manage that setting?
>
> The configuration /etc/openerp-server.conf doesn't have any parameter for that.
>
> That must be in a odoo file...?
>
> Thanks.
>
> On Mon, Oct 10, 2016 at 12:25 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
>
> 2016-10-10 21:12 GMT+02:00 Periko Support <pheriko(dot)support(at)gmail(dot)com>:
> Andreo u got a good observation here.
>
> I got a script that run every hour why?
>
> Odoo got some issues with IDLE connections, if we don't check our current psql connections after a while the system eat all connections and a lot of them are IDLE and stop answering users, we create a script that runs every hour, this is:

That's all part of Odoo (formerly known as OpenERP), isn't it? Did you contact them about this behaviour yet? Might just be that they're familiar with the problem and have a solution for it.

I suspect the Python script you're running was implemented as a rather rough workaround by people from allianzgrp who knew just enough to be harmful. (Kill -9 on a database process, jeez! Keyboards should have an electroshock feature for people like that…)

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.