When trying to post payments to one of the bank accounts in Open ERP it refuses to post and I get the following message:
This problem has happened before but disappeared by itself before I managed to report it.
Same problem with IE and Chrome browser
OpenERP Server Error
--------------------------------------------------------------------------------
Client Traceback (most recent call last):
File "/usr/lib/pymodules/python2.6/openerp/addons/web/http.py", line 195, in dispatch
response["result"] = method(self, **self.params)
File "/usr/lib/pymodules/python2.6/openerp/addons/web/controllers/main.py", line 1083, in call_button
action = self._call_kw(req, model, method, args, {})
File "/usr/lib/pymodules/python2.6/openerp/addons/web/controllers/main.py", line 1071, in _call_kw
return getattr(req.session.model(model), method)(*args, **kwargs)
File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 43, in proxy
result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 31, in proxy_method
result = self.session.send(self.service_name, method, *args)
File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 104, in send
raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)
Server Traceback (most recent call last):
File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 90, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/usr/lib/pymodules/python2.6/openerp/netsvc.py", line 295, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/usr/lib/pymodules/python2.6/openerp/service/web_services.py", line 614, in dispatch
res = fn(db, uid, *params)
File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 169, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 123, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 179, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 166, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/pymodules/python2.6/openerp/addons/account_voucher/account_voucher.py", line 826, in button_proforma_voucher
wf_service.trg_validate(uid, 'account.voucher', vid, 'proforma_voucher', cr)
File "/usr/lib/pymodules/python2.6/openerp/workflow/wkf_service.py", line 119, in trg_validate
res2 = instance.validate(cr, id, ident, signal)
File "/usr/lib/pymodules/python2.6/openerp/workflow/instance.py", line 43, in validate
workitem.process(cr, witem, ident, signal, force_running, stack=stack)
File "/usr/lib/pymodules/python2.6/openerp/workflow/workitem.py", line 60, in process
ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
File "/usr/lib/pymodules/python2.6/openerp/workflow/workitem.py", line 175, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/usr/lib/pymodules/python2.6/openerp/workflow/workitem.py", line 183, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/usr/lib/pymodules/python2.6/openerp/workflow/workitem.py", line 40, in create
process(cr, res, ident, stack=stack)
File "/usr/lib/pymodules/python2.6/openerp/workflow/workitem.py", line 52, in process
result = _execute(cr, workitem, activity, ident, stack)
File "/usr/lib/pymodules/python2.6/openerp/workflow/workitem.py", line 106, in _execute
returned_action = wkf_expr.execute(cr, ident, workitem, activity)
File "/usr/lib/pymodules/python2.6/openerp/workflow/wkf_expr.py", line 67, in execute
return _eval_expr(cr, ident, workitem, activity['action'])
File "/usr/lib/pymodules/python2.6/openerp/workflow/wkf_expr.py", line 57, in _eval_expr
ret = eval(line, env, nocopy=True)
File "/usr/lib/pymodules/python2.6/openerp/tools/safe_eval.py", line 241, in safe_eval
return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
File "", line 1, in <module>
File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 374, in function_proxy
return attr(self._cr, self._uid, [self._id], *args, **kwargs)
File "/usr/lib/pymodules/python2.6/openerp/addons/account_voucher/account_voucher.py", line 830, in proforma_voucher
self.action_move_line_create(cr, uid, ids, context=context)
File "/usr/lib/pymodules/python2.6/openerp/addons/account_voucher/account_voucher.py", line 1287, in action_move_line_create
move_id = move_pool.create(cr, uid, self.account_move_get(cr, uid, voucher.id, context=context), context=context)
File "/usr/lib/pymodules/python2.6/openerp/addons/account_voucher/account_voucher.py", line 967, in account_move_get
name = seq_obj.next_by_id(cr, uid, voucher_brw.journal_id.sequence_id.id, context=c)
File "/usr/lib/pymodules/python2.6/openerp/addons/base/ir/ir_sequence.py", line 222, in next_by_id
return self._next(cr, uid, ids, context)
File "/usr/lib/pymodules/python2.6/openerp/addons/account/ir_sequence.py", line 57, in _next
return super(ir_sequence, self)._next(cr, uid, seq_ids, context)
File "/usr/lib/pymodules/python2.6/openerp/addons/base/ir/ir_sequence.py", line 210, in _next
cr.execute("SELECT number_next FROM ir_sequence WHERE id=%s FOR UPDATE NOWAIT", (seq['id'],))
File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 162, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 227, in execute
res = self._obj.execute(query, params)
OperationalError: could not obtain lock on row in relation "ir_sequence"