1. Mailing Lists
  2. Connectors
  3. Re: Configuration with multiple Odoo nodes

Connectors mailing list archives

connectors@odoo-community.org

Browse archives

Re: Configuration with multiple Odoo nodes

ERROR: could not serialize access due to concurrent update

Avatar

Re: Configuration with multiple Odoo nodes

by
Open Source Integrators, Maxime Chambreuil
- 10/07/2019 21:32:25
I am not sure to get it.

If I have the following configuration:

load-balancer:
1 zone with Odoo HTTP Node 1 and 2

Odoo HTTP node 1:
max_cron_threads = 0
server_wide_modules = web
workers = 5

Odoo HTTP node 2:
max_cron_threads = 0
server_wide_modules = web
workers = 5

Odoo JOB:
max_cron_threads = 1
server_wide_modules = web,queue_job
workers = 5
[queue_job]
channels = root:5
scheme = https
host = load-balancer
port = 443

am I getting it right?

MAXIME CHAMBREUIL
PROJECT MANAGER/CONSULTANT
O: 1.855.877.2377 EXT. 710
M: 602.427.5632
E: MChambreuil@OpenSourcelntegrators.com
P.O. BOX 940, HIGLEY, AZ 85236



On Tue, Jul 2, 2019 at 6:27 AM Guewen Baconnier <guewen.baconnier@camptocamp.com> wrote:
Hello,

Usually we have one or several nodes for HTTP workers (exposed by a load balancer to users) and cron workers, and a different node for the jobrunner and its worker.
The workers of the jobrunner node are not exposed to users and are used for the jobs only. Typically, the number of workers in this node will be equal to the capacity we configure in the job channels root (root:8 means 8 workers).

By design, you cannot have more than one jobrunner. However, the jobrunner can use the workers of many nodes if you want so, by configuring ODOO_QUEUE_JOB_HOST on a load balancer doing the dispatch to the nodes [0]. We never needed to do this to be honest.

Have a nice day,
Guewen


On Sat, Jun 29, 2019 at 4:12 PM Maxime Chambreuil <mchambreuil@opensourceintegrators.com> wrote:
Hello,

I am running an Odoo 12 environment with multiple Odoo servers and the connector.

What do you suggest in terms of job runner configuration?
Do you allow all the nodes to have job runners? Does this create concurrent update issues?
Or do you configure the job runner on one node? How do you configure this node and the others?

Thank you. Have a great week-end.

MAXIME CHAMBREUIL
PROJECT MANAGER/CONSULTANT
O: 1.855.877.2377 EXT. 710
M: 602.427.5632
E: MChambreuil@OpenSourcelntegrators.com
P.O. BOX 940, HIGLEY, AZ 85236

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

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

Reference