openerp-india team mailing list archive

["ajay javiya \(OpenERP\)" <aja@xxxxxxxxxxx>]

Hello Damián,
We have traced  the issue at our end and the message shown on the server is valid due to concurrent  transaction happens when you rapidly moves record on kanban view . The message  "TransactionRollbackError: could not serialize access due to concurrent update" itself is explanatory. i understand your concern.
And the proposed solution on comment #6 can not be adopted  as we should not force commit all concurrent transactions.
Instead better solution is block the kanban record while some record is still processing this will never lead to concurrent transactions on server via kanban, So i am transferring bug to web team. 
Thank you for understanding.

** Project changed: openobject-server => openerp-web

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/985787

Title:
  [Trunk/6.1]Kanban view: "could not serialize access due to concurrent
  update"

Status in OpenERP Web:
  Confirmed

Bug description:
  With the Project App installed, in the Kanban view of Task, when
  moving task between Stages sometimes I get the following error

  Client Traceback (most recent call last):
    File "/home/openerp-damian/.addons/web/common/http.py", line 180, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/home/openerp-damian/.addons/web/controllers/main.py", line 971, in save
      r = m.write([id], data, req.session.eval_context(req.context))
    File "/home/openerp-damian/.addons/web/common/openerplib/main.py", line 250, in proxy
      args, kw)
    File "/home/openerp-damian/.addons/web/common/openerplib/main.py", line 117, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/home/openerp-damian/.addons/web/common/http.py", line 611, in send
      raise fault

  
  Server Traceback (most recent call last):
    File "/home/openerp-damian/.addons/web/common/http.py", line 592, in send
      result = openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 586, in dispatch
      res = fn(db, uid, *params)
    File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 167, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 164, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/openerp-damian/.addons/project/project.py", line 1050, in write
      result = super(task,self).write(cr, uid, ids, vals, context=context)
    File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3917, in write
      'where id IN %s', upd1 + [sub_ids])
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  TransactionRollbackError: could not serialize access due to concurrent update

  Maybe is because moving the task between stages faster than the update
  is performed in the server.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-web/+bug/985787/+subscriptions