Community mailing list archives

community@mail.odoo.com

Re: Is Odoo keep connections to DB open?

by
Andi Becker
- 11/18/2015 06:37:56
Set this on a lower value when you are trying to use odoo on digitsalocean as otherwise memory is full very fast and backen no more loading completely

Andi
(Andreas Becker)

LisAndi Co. Ltd.
15/21 M.2 Viset Road
Rawai, Muang, Phuket
83130 Thailand

+66 (0)81 606 3378
+66 (0)76 38 33 08
+49 (0)711 50 88788 50 -2
+49 (0)711 50 88788 59 Fax

Skype: lisandi
GoogleTalk: andi@lisandi.com
GoogleTalk: cocopapa
Youtube: apapococ
Facebook: andibecker
Flickr: andibecker


On Nov 18, 2015, at 10:42, Manami Hashi <manami@roomsfor.hk> wrote:

Hi,

As for matter of the title,
according to this link https://www.odoo.com/es_ES/forum/help-1/question/postgresql-idle-connections-and-docker-72778
the official strategy of Odoo seems to be to keep DB connections open.

I tested and found out the following things:
- when the number of connections reaches the limit of 'db_maxconn', it seems that the oldest connections are automatically closed.
- the number of connection limit can be extended to 'db_maxconn' * 'workers'.


Thanks!

----------------------------
Manami Hashi
Rooms For (Hong Kong) Limitd
Phone: +852-3483-1950
Mobile: +852-6177-2085
manami@roomsfor.hk
www.openerp-asia.net

On 11/9/2015 5:20 PM, Manami Hashi wrote:
<blockquote cite="mid:56406563.1070308@roomsfor.hk" type="cite"> Hi,

Our customer using Amazon RDS as the DB server receives DB connection leaks and their Odoo hangs up.
According to the old thread https://bugs.launchpad.net/openobject-server/+bug/463219, the official strategy is to keep connections to DB open, isn't it?

And, is the only way to avoid DB connection leaks limiting the value of db_maxconn? Do you have any ideas?

Thanks,
----------------------------
Manami Hashi
Rooms For (Hong Kong) Limitd
Phone: +852-3483-1950
Mobile: +852-6177-2085
manami@roomsfor.hk
www.openerp-asia.net


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe