This question has been flagged
1 Reply
5661 Views

hi,

i have installed the version 7 of odoo, and all work fine, but in log file i encountered this error:

2014-11-17 10:01:45,350 30416 ERROR database openerp.sql_db: bad query: update ir_config_parameter set "value"='http://175.28.38.245:8069',write_uid=1,write_date=(now() at time zone 'UTC') where id IN (1)
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/openerp-7.0_20140804_231303-py2.7.egg/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
TransactionRollbackError: no se pudo serializar el acceso debido a un update concurrente

2014-11-17 10:01:45,352 30416 ERROR database openerp.addons.base.res.res_users: Failed to update web.base.url configuration parameter
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/openerp-7.0_20140804_231303-py2.7.egg/openerp/addons/base/res/res_users.py", line 466, in authenticate
    ICP.set_param(cr, uid, 'web.base.url', base)
  File "/usr/local/lib/python2.7/dist-packages/openerp-7.0_20140804_231303-py2.7.egg/openerp/addons/base/ir/ir_config_parameter.py", line 94, in set_param
    self.write(cr, uid, ids, {'value': value}, context=context)
  File "/usr/local/lib/python2.7/dist-packages/openerp-7.0_20140804_231303-py2.7.egg/openerp/osv/orm.py", line 4230, in write
    'where id IN %s', upd1 + [sub_ids])
  File "/usr/local/lib/python2.7/dist-packages/openerp-7.0_20140804_231303-py2.7.egg/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/openerp-7.0_20140804_231303-py2.7.egg/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
TransactionRollbackError: no se pudo serializar el acceso debido a un update concurrente

why i give that error? how i can solve it?

thanks in advance.

Avatar
Discard

@Zouhair Can you specify while doing what operation you faced this error? This kind of error comes when more than one entity tries to access same record at a time. All those entities tries to access same record or try to update it at same time which throws this error.

Best Answer

A possible solution: https://www.odoo.com/forum/help-1/question/transactionrollbackerror-a-possible-solution-69070

Avatar
Discard