I am currently hosting a dozen of Odoo databases on one server. I use docker, with one container containing postgresql and five with odoo services. There is not many visitors yet. I use a recent pull of Odoo 8 from github and 9.4 version of postgres (it was the same with 9.1)
My problem is, after a dozen of hours I have almost an hundred of idle process in the postgres container, all related with the Odoo databases. It seems the connections to postgres never close.
I checked SELECT * FROM pg_stat_activity;, it seems the idle query is always COMMIT or ROLLBACK. Do you have any idea where the problem comes and how I can improve the situation? Do you think it's related on the use of docker?
Credit to @panos_xrg and @reis_pt for pointing me in the good direction https://twitter.com/panos_xrg/status/556460140149633026 https://twitter.com/reis_pt/status/556456989170339841
It seems it's the official strategy of Odoo to keep connection to postgres open, at least if what was said in this very old thread https://bugs.launchpad.net/openobject-server/+bug/463219 is still true.
I have a dozen of odoo services connected to the same postgres, each having five database to manage with 4 workers. I still can't found how many connections are opened for each services/database/workers and under which conditions but it doesn't seems to be really controled and it finally reach the 100 connections which is the limit of my postgres configuration.
In the F3 fork @panos_xrg decided to automatically close all connections older that 300seconds https://github.com/xrg/openerp-server/commit/b215015ba0453a. After playing a little with the odoo config, I found that there is a way to achieve the same thing which the official Odoo, it's the db_maxconn parameter.
When the number of opened connection in an odoo service reach the db_maxconn limit, it's seems the oldest connections are automatically closed. Looks like the way to go for me, and I guess that the rules are :
-The sum of all db_maxconn settings for each odoo services connected to the same postgres shall be less that this postgres maxconn configuration.
-The db_maxconn settings for an odoo service shall be high enough to manage the concurrent requests on this service.
So I'll try to set a db_maxconn settings to 10 on each of my odoo services, and I hope this will resolve the problem. I guess this is an important information to have in mind when you want like me to make many odoo services connected to same postgres, and not one big odoo service connected to one postgres (like Odoo SA if I'm not mistaking) nor several odoo services having each their own postgres (like most of the other odoo hosting).
About This Community
|Asked: 1/10/15, 6:21 AM|
|Seen: 5937 times|
|Last updated: 10/11/16, 10:38 AM|