I had a customer with strange issues of OpenERP - the main problem was long life of OpenERP/PostgreSQL sessions. The fix was not hard - using pgBouncer in transaction mode with short server life time (ten minutes).
It may be a good idea to explain fully in the post what is the problem, what has been resolved and a detailed method with references to pgbouncer docs. Just telling that there has been a problem does not help :)
I have not enough informations now, and I know so this article is too short. It is just note - you can use pgbouncer in transaction mode with OpenERP. The customer originally reported memory leaks of Postgres processes - these processes had more allocated memory than 1GB. I checked it, and I found so this memory was allocated but now it is in free block list. There was not possible to set connection max life on OpenERP - so I had do this fix on Postgres side with pgBouncer.
Pavel, do you confirm it was configured in transaction pool mode? If this is the case, it would be interesting indeed. I'm trying to make openerp work with pgbouncer in trasaction mode, but I'm still having problems.
@Guido - I cannot to recheck it now due the customer is from Tasmania and I am from Central Europe and I am not in communication with them - but last message was transactional pool mode and no problems.
And what kind of problems did you have that you solved?
ReplyDeleteAlthough this system has 32GB (and database 4GB) there was not free mem after 1hour. The PostgreSQL processes holds too much memory in free blocks.
ReplyDeleteIt may be a good idea to explain fully in the post what is the problem, what has been resolved and a detailed method with references to pgbouncer docs. Just telling that there has been a problem does not help :)
ReplyDeleteI have not enough informations now, and I know so this article is too short. It is just note - you can use pgbouncer in transaction mode with OpenERP.
ReplyDeleteThe customer originally reported memory leaks of Postgres processes - these processes had more allocated memory than 1GB. I checked it, and I found so this memory was allocated but now it is in free block list. There was not possible to set connection max life on OpenERP - so I had do this fix on Postgres side with pgBouncer.
Pavel, do you confirm it was configured in transaction pool mode?
ReplyDeleteIf this is the case, it would be interesting indeed.
I'm trying to make openerp work with pgbouncer in trasaction mode, but I'm still having problems.
@Guido - I cannot to recheck it now due the customer is from Tasmania and I am from Central Europe and I am not in communication with them - but last message was transactional pool mode and no problems.
ReplyDelete