This question has been flagged
1 Reply
14180 Views

Hi

I'm launching odoo on production level, I already read deployment documentation and got this behaviour on server:

2016-12-13 18:53:02,673 1432 INFO ? openerp.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 1 connections to 'user=odoomexy password=xxxxxxxxxxxxxxxx dbname=mexytul'

2016-12-13 18:53:02,674 1432 DEBUG ? openerp.service.server: WorkerCron (1432) mexytul time:0.012s mem: 319148k -> 319148k (diff: 0k)

2016-12-13 18:53:02,674 1432 DEBUG ? openerp.service.server: WorkerCron (1432) polling for jobs

After this error on log, some system users can not work on odoo, odoo is closing the connection.

I think this line is the problem:

2016-12-13 18:53:02,674 1432 DEBUG ? openerp.service.server: WorkerCron (1432) mexytul time:0.012s mem: 319148k -> 319148k (diff: 0k)

It seems that memory is running out (mem: 319148k -> 319148k) but I can't figure out the reason. This is odoo conf file:

[options] ; This is the password that allows database operations: ;
admin_passwd = admin

db_host = False

db_port = False

db_user = odoomexy

db_password = FOO

addons_path = /opt/odoo/foo

logfile=/var/log/odoo/foo

log_level=debug

workers = 17

max_cron_threads = 2

db_maxconn = 64

limit_time_cpu = 6000

limit_time_real = 12000

limit_memory_hard = 2684354560

limit_memory_soft = 2147483648

longpolling_port = 8072

limit_request = 8192

proxy_mode = False


I'm planning to get 2GB of memory per worker, but on error log it's not even 600MB before closing the connection.


These are server features:

8 cores 2.4ghz

32 gb RAM

DDR4

intel Xeon E5 v3

OS Ubuntu Server 14.04 lts


Any help would be highly appreciated.

Avatar
Discard
Best Answer

Your calculation of the number of workers based in the number of cores is ok but the configured minimum and maximun ram of around 2gb per worker exceeds the total amount of ram in the system. So there are some workers that will unable to run properly. You would need to low down your ram parameters or your number of workers so the total ram for workers fits in the current server ram.

Current workers ram

17 x 2gb = 34gb

Hope this helps you

Avatar
Discard
Author

Thanks friend, I will test it.