{"action":"created","issue":{"url":"https://api.github.com/repos/odoo/odoo/issues/4257","labels_url":"https://api.github.com/repos/odoo/odoo/issues/4257/labels{/name}","comments_url":"https://api.github.com/repos/odoo/odoo/issues/4257/comments","events_url":"https://api.github.com/repos/odoo/odoo/issues/4257/events","html_url":"https://github.com/odoo/odoo/issues/4257","id":52032698,"number":4257,"title":"[8.0] concurrent update of picking in huge transactions.","user":{"login":"nhomar","id":338634,"avatar_url":"https://avatars.githubusercontent.com/u/338634?v=3","gravatar_id":"","url":"https://api.github.com/users/nhomar","html_url":"https://github.com/nhomar","followers_url":"https://api.github.com/users/nhomar/followers","following_url":"https://api.github.com/users/nhomar/following{/other_user}","gists_url":"https://api.github.com/users/nhomar/gists{/gist_id}","starred_url":"https://api.github.com/users/nhomar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nhomar/subscriptions","organizations_url":"https://api.github.com/users/nhomar/orgs","repos_url":"https://api.github.com/users/nhomar/repos","events_url":"https://api.github.com/users/nhomar/events{/privacy}","received_events_url":"https://api.github.com/users/nhomar/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/odoo/odoo/labels/OE","name":"OE","color":"a24689"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2014-12-15T20:12:11Z","updated_at":"2015-04-26T12:30:21Z","closed_at":null,"body":"In v8.0 we have transactions that expend something like 30 or 40 minutes to be computed with only 300 lines of Products in a sales order.\r\n\r\nAfter a while, several time it happens that the process is broken with the traceback below.\r\n\r\nWe have a little complex enviroment:\r\n\r\n- Pack, pick and deliver warehouse output strategy.\r\n- Invoice from delivery.\r\n- +10000 product.product elements (1 product - 1 variant).\r\n- Running enviroment with 7 workers.\r\nblah blah!.\r\n\r\nIt is almost unusable, but the main issue is the incorrect management of sequences, we need to find a solution for it.\r\n\r\nRegards.\r\n\r\n```\r\n2014-12-15 17:06:11,740 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,742 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,743 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,786 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,787 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,841 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,843 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,843 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,881 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,884 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,930 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,930 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,932 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,966 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:11,970 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,014 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,022 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,024 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,063 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,066 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,099 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,106 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,306 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:12,357 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:14,191 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:15,732 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:15,742 14118 DEBUG None openerp.http.rpc.request: db.list time:0.006s mem: 880480k -> 880480k (diff: 0k)(True,)\r\n2014-12-15 17:06:18,689 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:18,828 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,019 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,029 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,126 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,136 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,223 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,321 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,349 14118 INFO production openerp.service.common: successful login from 'nhomar@vauxoo.com' using database 'production'\r\n2014-12-15 17:06:19,350 14118 DEBUG production openerp.http.rpc.request: common.login time:0.108s mem: 880480k -> 880480k (diff: 0k)(u'production', u'nhomar@vauxoo.com', '*')\r\n2014-12-15 17:06:19,402 14118 ERROR production openerp.sql_db: bad query: INSERT INTO \"stock_move\" (\"id\", \"origin\", \"product_uos_qty\", \"product_uom\", \"product_uom_qty\", \"date\", \"product_uos\", \"partner_id\", \"picking_type_id\", \"location_id\", \"company_id\", \"priority\", \"state\", \"weight_uom_id\", \"date_expected\", \"procurement_id\", \"warehouse_id\", \"propagate\", \"move_dest_id\", \"procure_method\", \"product_id\", \"name\", \"partially_available\", \"invoice_state\", \"location_dest_id\", \"group_id\", \"rule_id\", \"create_uid\", \"write_uid\", \"create_date\", \"write_date\") VALUES(nextval('stock_move_id_seq'), 'SO-046904:WH: Packing Zone -> Output', 40.0, 21, 40.0, '2014-12-15 23:04:36', 21, 2226, 5, 1521, 1, '1', 'draft', 3, '2014-12-15 23:04:36', 31988, 1, true, 62181, 'make_to_stock', 18212, 'WH: Packing Zone -> Output', false, 'none', 16, 421, 8, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id\r\nTraceback (most recent call last):\r\n  File \"/home/runbot/instance/odoo/openerp/sql_db.py\", line 234, in execute\r\n    res = self._obj.execute(query, params)\r\nTransactionRollbackError: could not serialize access due to concurrent update\r\nCONTEXT:  SQL statement \"SELECT 1 FROM ONLY \"public\".\"res_users\" x WHERE \"id\" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x\"\r\n\r\n2014-12-15 17:06:19,402 14118 ERROR production openerp.http: Exception during JSON request handling.\r\nTraceback (most recent call last):\r\n  File \"/home/runbot/instance/odoo/openerp/http.py\", line 518, in _handle_exception\r\n    return super(JsonRequest, self)._handle_exception(exception)\r\n  File \"/home/runbot/instance/odoo/openerp/http.py\", line 539, in dispatch\r\n    result = self._call_function(**self.params)\r\n  File \"/home/runbot/instance/odoo/openerp/http.py\", line 295, in _call_function\r\n    return checked_call(self.db, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/service/model.py\", line 113, in wrapper\r\n    return f(dbname, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/http.py\", line 292, in checked_call\r\n    return self.endpoint(*a, **kw)\r\n  File \"/home/runbot/instance/odoo/openerp/http.py\", line 755, in __call__\r\n    return self.method(*args, **kw)\r\n  File \"/home/runbot/instance/odoo/openerp/http.py\", line 388, in response_wrap\r\n    response = f(*args, **kw)\r\n  File \"/home/runbot/instance/odoo/addons/web/controllers/main.py\", line 953, in call_button\r\n    action = self._call_kw(model, method, args, {})\r\n  File \"/home/runbot/instance/odoo/addons/web/controllers/main.py\", line 941, in _call_kw\r\n    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/portal_sale/portal_sale.py\", line 67, in action_button_confirm\r\n    return super(sale_order, self).action_button_confirm(cr, uid, ids, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/sale/sale.py\", line 598, in action_button_confirm\r\n    self.signal_workflow(cr, uid, ids, 'order_confirm')\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/models.py\", line 3483, in signal_workflow\r\n    result[res_id] = workflow.trg_validate(uid, self._name, res_id, signal, cr)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/__init__.py\", line 85, in trg_validate\r\n    return WorkflowService.new(cr, uid, res_type, res_id).validate(signal)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/service.py\", line 91, in validate\r\n    res2 = wi.validate(signal)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/instance.py\", line 75, in validate\r\n    wi.process(signal=signal, force_running=force_running, stack=stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 120, in process\r\n    ok = self._split_test(activity['split_mode'], signal, stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 248, in _split_test\r\n    self._join_test(t[0], t[1], stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 257, in _join_test\r\n    WorkflowItem.create(self.session, self.record, activity, inst_id, stack=stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 95, in create\r\n    workflow_item.process(stack=stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 120, in process\r\n    ok = self._split_test(activity['split_mode'], signal, stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 248, in _split_test\r\n    self._join_test(t[0], t[1], stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 257, in _join_test\r\n    WorkflowItem.create(self.session, self.record, activity, inst_id, stack=stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 95, in create\r\n    workflow_item.process(stack=stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 120, in process\r\n    ok = self._split_test(activity['split_mode'], signal, stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 248, in _split_test\r\n    self._join_test(t[0], t[1], stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 257, in _join_test\r\n    WorkflowItem.create(self.session, self.record, activity, inst_id, stack=stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 95, in create\r\n    workflow_item.process(stack=stack)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 116, in process\r\n    if not self._execute(activity, stack):\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 162, in _execute\r\n    returned_action = self.wkf_expr_execute(activity)\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 313, in wkf_expr_execute\r\n    return self.wkf_expr_eval_expr(activity['action'])\r\n  File \"/home/runbot/instance/odoo/openerp/workflow/workitem.py\", line 291, in wkf_expr_eval_expr\r\n    result = eval(line, env, nocopy=True)\r\n  File \"/home/runbot/instance/odoo/openerp/tools/safe_eval.py\", line 313, in safe_eval\r\n    return eval(c, globals_dict, locals_dict)\r\n  File \"\", line 1, in <module>\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 235, in wrapper\r\n    return new_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 552, in new_api\r\n    result = method(self._model, cr, uid, self.ids, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/sale/sale.py\", line 720, in action_ship_create\r\n    proc_id = procurement_obj.create(cr, uid, vals, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/procurement_jit/procurement_jit.py\", line 30, in create\r\n    self.run(cr, uid, [procurement_id], context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/stock/procurement.py\", line 219, in run\r\n    self.pool.get('stock.move').action_confirm(cr, uid, move_to_confirm_ids, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/delivery/stock.py\", line 183, in action_confirm\r\n    res = super(stock_move, self).action_confirm(cr, uid, ids, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/mrp/stock.py\", line 151, in action_confirm\r\n    return super(StockMove, self).action_confirm(cr, uid, move_ids, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/stock/stock.py\", line 2117, in action_confirm\r\n    self._create_procurement(cr, uid, move, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/stock/stock.py\", line 1891, in _create_procurement\r\n    return self.pool.get(\"procurement.order\").create(cr, uid, self._prepare_procurement_from_move(cr, uid, move, context=context))\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/procurement_jit/procurement_jit.py\", line 30, in create\r\n    self.run(cr, uid, [procurement_id], context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/stock/procurement.py\", line 219, in run\r\n    self.pool.get('stock.move').action_confirm(cr, uid, move_to_confirm_ids, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/delivery/stock.py\", line 183, in action_confirm\r\n    res = super(stock_move, self).action_confirm(cr, uid, ids, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/mrp/stock.py\", line 151, in action_confirm\r\n    return super(StockMove, self).action_confirm(cr, uid, move_ids, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/stock/stock.py\", line 2117, in action_confirm\r\n    self._create_procurement(cr, uid, move, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/stock/stock.py\", line 1891, in _create_procurement\r\n    return self.pool.get(\"procurement.order\").create(cr, uid, self._prepare_procurement_from_move(cr, uid, move, context=context))\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/procurement_jit/procurement_jit.py\", line 30, in create\r\n    self.run(cr, uid, [procurement_id], context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/stock/procurement.py\", line 210, in run\r\n    res = super(procurement_order, self).run(cr, uid, new_ids, autocommit=autocommit, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/procurement/procurement.py\", line 206, in run\r\n    res = self._run(cr, uid, procurement, context=context or {})\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/purchase_requisition/purchase_requisition.py\", line 418, in _run\r\n    return super(procurement_order, self)._run(cr, uid, procurement, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/purchase/purchase.py\", line 1200, in _run\r\n    return super(procurement_order, self)._run(cr, uid, procurement, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/mrp/procurement.py\", line 53, in _run\r\n    return super(procurement_order, self)._run(cr, uid, procurement, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/addons/stock/procurement.py\", line 204, in _run\r\n    move_obj.create(cr, SUPERUSER_ID, move_dict, context=context)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 237, in wrapper\r\n    return old_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 332, in old_api\r\n    result = method(recs, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/models.py\", line 3999, in create\r\n    record = self.browse(self._create(old_vals))\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 235, in wrapper\r\n    return new_api(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/api.py\", line 464, in new_api\r\n    result = method(self._model, cr, uid, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/models.py\", line 4137, in _create\r\n    tuple([u[2] for u in updates if len(u) > 2])\r\n  File \"/home/runbot/instance/odoo/openerp/sql_db.py\", line 158, in wrapper\r\n    return f(self, *args, **kwargs)\r\n  File \"/home/runbot/instance/odoo/openerp/sql_db.py\", line 234, in execute\r\n    res = self._obj.execute(query, params)\r\nValueError: \"could not serialize access due to concurrent update\r\nCONTEXT:  SQL statement \"SELECT 1 FROM ONLY \"public\".\"res_users\" x WHERE \"id\" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x\"\r\n\" while evaluating\r\nu'action_ship_create()'\r\n2014-12-15 17:06:19,447 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,456 14118 DEBUG None openerp.http.rpc.request: db.list time:0.006s mem: 880480k -> 880480k (diff: 0k)(True,)\r\n2014-12-15 17:06:19,457 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,526 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,649 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,789 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:19,871 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:20,021 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - old# 285 new# 285]\r\n2014-12-15 17:06:20,367 14118 DEBUG production openerp.modules.registry: Multiprocess signaling check: [Registry - old# 3 new# 3] [Cache - o\r\n```"},"comment":{"url":"https://api.github.com/repos/odoo/odoo/issues/comments/96373517","html_url":"https://github.com/odoo/odoo/issues/4257#issuecomment-96373517","issue_url":"https://api.github.com/repos/odoo/odoo/issues/4257","id":96373517,"user":{"login":"orchidinfosys","id":2189864,"avatar_url":"https://avatars.githubusercontent.com/u/2189864?v=3","gravatar_id":"","url":"https://api.github.com/users/orchidinfosys","html_url":"https://github.com/orchidinfosys","followers_url":"https://api.github.com/users/orchidinfosys/followers","following_url":"https://api.github.com/users/orchidinfosys/following{/other_user}","gists_url":"https://api.github.com/users/orchidinfosys/gists{/gist_id}","starred_url":"https://api.github.com/users/orchidinfosys/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/orchidinfosys/subscriptions","organizations_url":"https://api.github.com/users/orchidinfosys/orgs","repos_url":"https://api.github.com/users/orchidinfosys/repos","events_url":"https://api.github.com/users/orchidinfosys/events{/privacy}","received_events_url":"https://api.github.com/users/orchidinfosys/received_events","type":"User","site_admin":false},"created_at":"2015-04-26T12:30:21Z","updated_at":"2015-04-26T12:30:21Z","body":"Further investigation, found that\r\nIf it set realtime costing method enabled and lot number with minimal transaction , then its fine.\r\nIf the volume is more and each invoice having number of lines, its taking too much time and it increases with the database size. Real Time costing and lot number make the issue."}}