1. Mailing Lists
  2. Contributors
  3. Increased Queue Job Failures – Need Advice

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

New workgroup: OCA internal tools

odoo para manufactura

Avatar

Increased Queue Job Failures – Need Advice

by "Emanuel Cino" <emanuel@compassion.ch> - 13/02/2025 11:00:11
Hello everyone,

We use queue jobs in our Odoo 14 instance for various operations, and they have worked well so far. However, we've recently noticed an increasing number of failures with the following errors:

  1. psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block
  2. psycopg2.errors.SerializationFailure: could not serialize access due to concurrent update

This issue may have started after updating the queue_job module to the latest version in branch 14.0, though we're not certain. No other changes have been made to our server configuration.

Since we’re unsure how to resolve this, does anyone have experience with this module and the best server configuration for handling parallel job execution? The errors typically occur when multiple jobs run in parallel or when users work on the same models as the running jobs.

Any insights or recommendations would be greatly appreciated!

Thanks,

Emanuel

Follow-Ups