openerp-india team mailing list archive

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

unfortunataly it's too time consuming to reconstruct the situation - As
I said, most options, and I believe it's coming from the new threading
feature of the server

"TransactionRollbackError: could not serialize access due to concurrent
update"

IMHO such conflicts must be handled gracefuilly by the server.

I assign it to the server

** Also affects: openobject-server
   Importance: Undecided
       Status: New

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

Title:
  concurrent error during installation of many options

Status in OpenERP Addons (modules):
  Incomplete
Status in OpenERP Server:
  New

Bug description:
  trying to install many of the offered modules I get this

  view.sales.by.month.tree(tree)',"reports_by_module"=E'Quotation / Order' where id = 149
  Traceback (most recent call last):
    File "/home/srv/openerp/instances/trunk/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
  CONTEXT:  SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"

  [2011-11-02 18:24:57,588][test61] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/osv/osv.py", line 120, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/osv/osv.py", line 172, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/osv/osv.py", line 163, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/srv/openerp/instances/trunk/openobject-addons/base_setup/base_setup.py", line 312, in apply_cb
      self.pool = pooler.restart_pool(cr.dbname, update_module=True)[1]
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/pooler.py", line 39, in restart_pool
      registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/modules/registry.py", line 160, in new
      openerp.modules.load_modules(registry.db, force_demo, status, update_module)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/modules/loading.py", line 336, in load_modules
      processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/modules/loading.py", line 251, in load_marked_modules
      loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/modules/loading.py", line 210, in load_module_graph
      modobj.write(cr, 1, [module_id], {'state': 'installed', 'latest_version': ver})
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/osv/orm.py", line 3895, in write
      self.pool.get(object)._store_set_values(cr, user, todo, fields_to_recompute, context)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/osv/orm.py", line 4220, in _store_set_values
      ','.join(upd0) + ' where id = %s', upd1)
    File "/home/srv/openerp/instances/trunk/openobject-server/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/srv/openerp/instances/trunk/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
  CONTEXT:  SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"

  
  Nevertheless using "Apply sheduled updates" the remaining modules were installed correctly

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