credativ team mailing list archive

Thread
Date
[Bug 1045388] Re: ir.sequence does not exist

To: credativ@xxxxxxxxxxxxxxxxxxx
From: Quentin Gérôme <1045388@xxxxxxxxxxxxxxxxxx>
Date: Mon, 03 Sep 2012 15:23:59 -0000
Reply-to: Bug 1045388 <1045388@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Attachment added: "openerp-server.conf"
   https://bugs.launchpad.net/bugs/1045388/+attachment/3290716/+files/openerp-server.conf

** Description changed:

  Versions
  ------------
  openupgrade-server : rev 3990
  openupgrade-addons : rev 6605
  
  Description
  ----------------
- I try to duplicate a sale order or to validate an invoice and the system crashes with this beautiful error : 
+ I try to duplicate a sale order or to validate an invoice and the system crashes with this beautiful error :
  
  Server Traceback (most recent call last):
-   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/web/common/http.py", line 593, in send
-     return openerp.netsvc.dispatch_rpc(service_name, method, args)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/netsvc.py", line 360, in dispatch_rpc
-     result = ExportService.getService(service_name).dispatch(method, params)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/service/web_services.py", line 586, in dispatch
-     res = fn(db, uid, *params)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 121, in wrapper
-     return f(self, dbname, *args, **kwargs)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 196, in exec_workflow
-     res = self.exec_workflow_cr(cr, uid, obj, method, *args)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 189, in exec_workflow_cr
-     return wf_service.trg_validate(uid, obj, args[0], method, cr)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_service.py", line 124, in trg_validate
-     res2 = instance.validate(cr, id, ident, signal)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/instance.py", line 48, in validate
-     workitem.process(cr, witem, ident, signal, force_running, stack=stack)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 61, in process
-     ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 176, in _split_test
-     _join_test(cr, t[0], t[1], ident, stack)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 184, in _join_test
-     create(cr,[activity], inst_id, ident, stack)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 41, in create
-     process(cr, res, ident, stack=stack)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 53, in process
-     result = _execute(cr, workitem, activity, ident, stack)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 107, in _execute
-     returned_action = wkf_expr.execute(cr, ident, workitem, activity)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_expr.py", line 68, in execute
-     return _eval_expr(cr, ident, workitem, activity['action'])
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
-     ret = eval(line, env, nocopy=True)
-   File "/home/quentin/.virtualenvs/nqi/server/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 "/home/quentin/.virtualenvs/nqi/server/openerp/osv/orm.py", line 368, in function_proxy
-     return attr(self._cr, self._uid, [self._id], *args, **kwargs)
-   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/account_invoice.py", line 961, in action_move_create
-     move_obj.post(cr, uid, [move_id], context=ctx)
-   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/account.py", line 1327, in post
-     new_name = obj_sequence.next_by_id(cr, uid, journal.sequence_id.id, c)
-   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/base/ir/ir_sequence.py", line 216, in next_by_id
-     return self._next(cr, uid, ids, context)
-   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/ir_sequence.py", line 57, in _next
-     return super(ir_sequence, self)._next(cr, uid, seq_ids, context)
-   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/base/ir/ir_sequence.py", line 201, in _next
-     cr.execute("SELECT nextval('ir_sequence_%03d')" % seq['id'])
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/sql_db.py", line 152, in wrapper
-     return f(self, *args, **kwargs)
-   File "/home/quentin/.virtualenvs/nqi/server/openerp/sql_db.py", line 212, in execute
-     res = self._obj.execute(query, params)
+   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/web/common/http.py", line 593, in send
+     return openerp.netsvc.dispatch_rpc(service_name, method, args)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/netsvc.py", line 360, in dispatch_rpc
+     result = ExportService.getService(service_name).dispatch(method, params)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/service/web_services.py", line 586, in dispatch
+     res = fn(db, uid, *params)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 121, in wrapper
+     return f(self, dbname, *args, **kwargs)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 196, in exec_workflow
+     res = self.exec_workflow_cr(cr, uid, obj, method, *args)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 189, in exec_workflow_cr
+     return wf_service.trg_validate(uid, obj, args[0], method, cr)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_service.py", line 124, in trg_validate
+     res2 = instance.validate(cr, id, ident, signal)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/instance.py", line 48, in validate
+     workitem.process(cr, witem, ident, signal, force_running, stack=stack)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 61, in process
+     ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 176, in _split_test
+     _join_test(cr, t[0], t[1], ident, stack)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 184, in _join_test
+     create(cr,[activity], inst_id, ident, stack)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 41, in create
+     process(cr, res, ident, stack=stack)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 53, in process
+     result = _execute(cr, workitem, activity, ident, stack)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 107, in _execute
+     returned_action = wkf_expr.execute(cr, ident, workitem, activity)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_expr.py", line 68, in execute
+     return _eval_expr(cr, ident, workitem, activity['action'])
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
+     ret = eval(line, env, nocopy=True)
+   File "/home/quentin/.virtualenvs/nqi/server/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 "/home/quentin/.virtualenvs/nqi/server/openerp/osv/orm.py", line 368, in function_proxy
+     return attr(self._cr, self._uid, [self._id], *args, **kwargs)
+   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/account_invoice.py", line 961, in action_move_create
+     move_obj.post(cr, uid, [move_id], context=ctx)
+   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/account.py", line 1327, in post
+     new_name = obj_sequence.next_by_id(cr, uid, journal.sequence_id.id, c)
+   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/base/ir/ir_sequence.py", line 216, in next_by_id
+     return self._next(cr, uid, ids, context)
+   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/ir_sequence.py", line 57, in _next
+     return super(ir_sequence, self)._next(cr, uid, seq_ids, context)
+   File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/base/ir/ir_sequence.py", line 201, in _next
+     cr.execute("SELECT nextval('ir_sequence_%03d')" % seq['id'])
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/sql_db.py", line 152, in wrapper
+     return f(self, *args, **kwargs)
+   File "/home/quentin/.virtualenvs/nqi/server/openerp/sql_db.py", line 212, in execute
+     res = self._obj.execute(query, params)
  ProgrammingError: relation "ir_sequence_007" does not exist
  LINE 1: SELECT nextval('ir_sequence_007')
- 
  
  Additional information
  -------------------------------
  
  I've done the migration with a 6.0 database and you can find in
  attachment my opener-server.conf and logfile of the migration
  
+ After the pg_restore I had to run these commands:
+ * ALTER TABLE ir_model_fields ADD column serialization_field_id int references ir_model_fields on delete cascade;
+ * UPDATE ir_module_module set certificate=NULL;
  
  Regards,

-- 
You received this bug notification because you are a member of
OpenUpgrade Committers, which is subscribed to OpenUpgrade Server.
https://bugs.launchpad.net/bugs/1045388

Title:
  ir.sequence does not exist

Status in OpenUpgrade Server:
  New

Bug description:
  Versions
  ------------
  openupgrade-server : rev 3990
  openupgrade-addons : rev 6605

  Description
  ----------------
  I try to duplicate a sale order or to validate an invoice and the system crashes with this beautiful error :

  Server Traceback (most recent call last):
    File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/web/common/http.py", line 593, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/netsvc.py", line 360, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/service/web_services.py", line 586, in dispatch
      res = fn(db, uid, *params)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 196, in exec_workflow
      res = self.exec_workflow_cr(cr, uid, obj, method, *args)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 189, in exec_workflow_cr
      return wf_service.trg_validate(uid, obj, args[0], method, cr)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_service.py", line 124, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 176, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 184, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 53, in process
      result = _execute(cr, workitem, activity, ident, stack)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 107, in _execute
      returned_action = wkf_expr.execute(cr, ident, workitem, activity)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_expr.py", line 68, in execute
      return _eval_expr(cr, ident, workitem, activity['action'])
    File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/home/quentin/.virtualenvs/nqi/server/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 "/home/quentin/.virtualenvs/nqi/server/openerp/osv/orm.py", line 368, in function_proxy
      return attr(self._cr, self._uid, [self._id], *args, **kwargs)
    File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/account_invoice.py", line 961, in action_move_create
      move_obj.post(cr, uid, [move_id], context=ctx)
    File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/account.py", line 1327, in post
      new_name = obj_sequence.next_by_id(cr, uid, journal.sequence_id.id, c)
    File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/base/ir/ir_sequence.py", line 216, in next_by_id
      return self._next(cr, uid, ids, context)
    File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/ir_sequence.py", line 57, in _next
      return super(ir_sequence, self)._next(cr, uid, seq_ids, context)
    File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/base/ir/ir_sequence.py", line 201, in _next
      cr.execute("SELECT nextval('ir_sequence_%03d')" % seq['id'])
    File "/home/quentin/.virtualenvs/nqi/server/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/home/quentin/.virtualenvs/nqi/server/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: relation "ir_sequence_007" does not exist
  LINE 1: SELECT nextval('ir_sequence_007')

  Additional information
  -------------------------------

  I've done the migration with a 6.0 database and you can find in
  attachment my opener-server.conf and logfile of the migration

  After the pg_restore I had to run these commands:
  * ALTER TABLE ir_model_fields ADD column serialization_field_id int references ir_model_fields on delete cascade;
  * UPDATE ir_module_module set certificate=NULL;

  Regards,

To manage notifications about this bug go to:
https://bugs.launchpad.net/openupgrade-server/+bug/1045388/+subscriptions
References

[Bug 1045388] [NEW] ir.sequence does not exist
From: Quentin Gérôme, 2012-09-03