getting ERROR: could not serialize access due to concurrent update.

Question

error1: 2023-10-31 07:26:51,082 173170 ERROR support odoo.sql_db: bad query: UPDATE "website_menu" SET "write_uid"=39,"write_date"=(now() at time zone 'UTC') WHERE id IN (9)  ERROR: could not serialize access due to concurrent update
error2: psycopg2.extensions.TransactionRollbackError: could not serialize access due to concurrent update

this happens after purchase at ecommerce which have customization, may I have the opinions of the experts here on where to check specifically on this. I am goi

Jainesh Shah(Aktiv Software) · Accepted Answer

Hi UiTM Shah Alam,

This message means that two or more users are trying to update the same record in the database at the same time. The database is unable to complete the updates because they conflict with each other.

This error can occur for a number of reasons, such as:

1.Two users are trying to edit the same record at the same time.
2.A cron job is trying to update a record while a user is editing the record.
3.A third-party module is trying to update a record while a user is editing the r

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!