concurrent error during installation of many options

[Ferdinand]

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

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Dr.Ferdinand,

I have applied same scenario as you have applied but I got different error message from you have got.

Would you please give list which option select your end so I can reproduce same at my end.

Thanks and waiting for your reply.

[Ferdinand (office-chricar)]

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

[Thibaut DIRLIK (Logica) (thibaut-dirlik)]

I also have the problem, not everytime...

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello Dr.Ferdinand,

I have try again with updated code of trunk with following revision but I didn't face same error .

Server - 3783
GTK - 1995
Addons - 5509

Would you please try again with updated code.

Thanks and waiting for your reply.