Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
TransactionRollbackError
1 Vastaa
10767 Näkymät
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
Hylkää
Avatar
Jainesh Shah(Aktiv Software)
Paras vastaus

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
Hylkää
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?

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
TransactionRollbackError: a possible solution
TransactionRollbackError
Avatar
0
toukok. 16
17741