Skip to Content
This question has been flagged
TransactionRollbackError
1 Respondre
10618 Vistes
Avatar
UiTM Shah Alam

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 going through logs. this serialization failure seems to make downtime on our production once.


 

Avatar
Descartar
Avatar
Jainesh Shah(Aktiv Software)
Best 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 record.


To resolve this error, you need to identify the users or processes that are trying to update the record at the same time.


If you are unable to identify the users or processes that are trying to update the record at the same time, you can try the following:


1. Restart your Odoo server

2. Upgrade your Odoo database

3. Contact Us for support


Feel free to contact us for further assistance

Hope this answer helps you.

Thanks & Regards,
Email: odoo@aktivsoftware.com     

Skype: kalpeshmaheshwari

Avatar
Descartar
Auto-Matt

Hi
I'm observing similar on my custom module. I have found the part of the code that is doing the insert into database multiple times in the same time (due to a lot of required updates in the same moment) and I wuold like to remove the error. What is the best approach?

Related Posts Respostes Vistes Activitat
TransactionRollbackError: a possible solution
TransactionRollbackError
Avatar
0
de maig 16
17684