Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
TransactionRollbackError
1 Rispondi
10633 Visualizzazioni
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
Abbandona
Avatar
Jainesh Shah(Aktiv Software)
Risposta migliore

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
Abbandona
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?

Post correlati Risposte Visualizzazioni Attività
TransactionRollbackError: a possible solution
TransactionRollbackError
Avatar
0
mag 16
17690