This question has been flagged
1 Reply
7441 Views

I get to see the TransactionRollBackError in Odoo V13 when updating the record set using the write() operation. logs as below.



2020-08-10 23:13:07,609 11322 ERROR ek_openerp_dev odoo.sql_db: bad query: UPDATE "id_pk_status" SET "Is_Active"='N',"write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (283150)
ERROR: could not serialize access due to concurrent update
 
Traceback (most recent call last):
  File "/current/electrickiwi/addons/kenel/models/peod.py", line 141, in vae_bilng_pduct
    obj = pool.browse(vals['id_pk_status']).read()[0]
  File "/var/www/electrickiwi-nest/current/core/addons/nest_migration_utils/helpers/old_cr.py", line 51, in old_cursor
    result = method(*args, **kwargs)
  File "/current/odoo/odoo/models.py", line 2893, in read
    self._read(stored_fields)
  File "/current/odoo/odoo/models.py", line 2953, in _read
    self.flush(fields, self)
  File "/current/odoo/odoo/models.py", line 5419, in flush
    process(self.env[model_name], id_vals)
  File "/current/odoo/odoo/models.py", line 5374, in process
    recs._write(vals)
  File "/current/odoo/odoo/models.py", line 3619, in _write
    cr.execute(query, params + [sub_ids])
  File "/current/odoo/odoo/sql_db.py", line 163, in wrapper
    return f(self, *args, **kwargs)
  File "/current/odoo/odoo/sql_db.py", line 240, in execute
    res = self._obj.execute(query, params)
psycopg2.extensions.TransactionRollbackError: could not serialize access due to concurrent update

Avatar
Discard

i think you only need to kill existing processes and then restart server.