1. Mailing Lists
  2. Contributors
  3. Re: odoo seems not to close database connections

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: Performance issues for all users in Odoo 9 when a single user creates a heavy request

odoo seems not to close database connections

Avatar

Re: odoo seems not to close database connections

by
Accomodata, Jos De Graeve
- 14/11/2017 15:44:46
Hello Robert,


In the odoo.conf you can set the "db_maxconn" parameter.  This controls how many DB connections each worker uses.  If you don't have too much odoo instances, this might do the trick.

If you run a lot of odoo instances on a single DB server, use pgbouncer.  It acts as a connection proxy and will close idle connections for you.

regards,



Jos De Graeve - Apertoso business ICT


Guido Gezellelaan 16 - B-9800 Deinze - Belgium
 
Phone: +32 9 381 64 50
Mobile: +32 475 54 68 80

2017-11-14 14:47 GMT+01:00 robert rottermann <robert@redcor.ch>:
Hi there

I am running sever odoo in docker instances

all of them linked to the same container running the database.

Now when I wanted to added an otter site in a container linked against 
the same postgres server, I get an error saying that there are to many 
connections open.

Checking the database running a query like

select count(pid) from pg_stat_activity;
  count
-------
    100
(1 row)

all of them are idle, but it looks that I can not open any more.


what can I do (next to raise the number of connections?)

thanks for your input

robert

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe


Reference