credativ team mailing list archive

["Ferdinand @ Camptocamp" <904839@xxxxxxxxxxxxxxxxxx>]

I have got this error "could not serialize access due to concurrent update" during database update
after rerunning it worked again
IMHO a multi threading issue

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

Title:
  could not serialize access due to concurrent update

Status in OpenERP Server:
  Incomplete

Bug description:
  Hi,
  With the current trunk version I installed sale, purchase and some hr modules. After that I installed base_crypt and if I try to install any module after that I get this error:

  Client Traceback (most recent call last):
    File "/home/openerp/bazaar/trunk/openerp-web/addons/web/common/http.py", line 154, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/home/openerp/bazaar/trunk/openerp-web/addons/web/controllers/main.py", line 975, in load
      return self.fields_view_get(req, model, view_id, view_type, toolbar=toolbar)
    File "/home/openerp/bazaar/trunk/openerp-web/addons/web/controllers/main.py", line 863, in fields_view_get
      fvg = Model.fields_view_get(view_id, view_type, context, toolbar, submenu)
    File "/home/openerp/bazaar/trunk/openerp-web/addons/web/common/openerplib/main.py", line 430, in proxy
      *args)
    File "/home/openerp/bazaar/trunk/openerp-web/addons/web/common/openerplib/main.py", line 306, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/home/openerp/bazaar/trunk/openerp-web/addons/web/common/openerplib/main.py", line 276, in send
      raise fault

  
  Server Traceback (most recent call last):
    File "/home/openerp/bazaar/trunk/openerp-web/addons/web/common/openerplib/main.py", line 257, in send
      result = openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/openerp/projects/openERP/development/lptrunk/openobject-server/openerp/netsvc.py", line 325, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/openerp/projects/openERP/development/lptrunk/openobject-server/openerp/service/web_services.py", line 577, in dispatch
      security.check(db,uid,passwd)
    File "/home/openerp/projects/openERP/development/lptrunk/openobject-server/openerp/service/security.py", line 42, in check
      return user_obj.check(db, uid, passwd)
    File "/home/openerp/bazaar/trunk/openobject-addons/base_crypt/crypt.py", line 250, in check
      res = self._login(cr, db, stored_login, passwd)
    File "/home/openerp/bazaar/trunk/openobject-addons/base_crypt/crypt.py", line 216, in _login
      (int(id), encrypted_pw.encode('utf-8')))
    File "/home/openerp/projects/openERP/development/lptrunk/openobject-server/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/openerp/projects/openERP/development/lptrunk/openobject-server/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  TransactionRollbackError: could not serialize access due to concurrent update

  The log in the server side is :
  [2011-12-15 16:49:50,138][?] ERROR:db.cursor:bad query: UPDATE res_users SET date=now() WHERE id=1 AND password=E'$1$BHoLYuDO$MEAz2nXpUdMYQ2/rskWen/' AND active RETURNING id
  Traceback (most recent call last):
    File "/home/openerp/projects/openERP/development/lptrunk/openobject-server/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  TransactionRollbackError: could not serialize access due to concurrent update

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/904839/+subscriptions