credativ team mailing list archive

["Stefan Rijnhart \(Therp\)" <1045388@xxxxxxxxxxxxxxxxxx>]

Hi Quentin,

thank you for this very complete bug report.

It seems like the migration scripts from the base module are not being
run. At least the logs do not mention it. You should see something like
the following line in your logs:

openerp.modules.migration: module base: Running migration [>6.x.x.x]
pre-migration

Also, the queries that you run manually are in the base module's pre-
migration.py.

That can be explained by the following: I see references to the
following directory in your log: /home/quentin/.virtualenvs/openerp-
server-6.1/local/lib/python2.7/site-
packages/openerp-6.1_20120902_231958-py2.7.egg, which looks like you are
running a nightly build from OpenERP-server, not OpenUpgrade-server.
(but then, how can the other migration scripts find the OpenUpgrade
lib?)

Can you weed out your python environment and try again?

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