← Back to team overview

openerp-india team mailing list archive

[Bug 885368] [NEW] concurrent error during installation of many options

 

Public bug reported:

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

** Affects: openobject-addons
     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):
  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


Follow ups

References