← Back to team overview

credativ team mailing list archive

  1. credativ team
  2. Mailing list archive
  3. Message #04964

[Bug 1045388] [NEW] ir.sequence does not exist

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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,

** Affects: openupgrade-server
     Importance: Undecided
         Status: New

-- 
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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next