Hi i'm trying to migrate my database fromt odoo v12CE to v13CE, but i'm getting this error, can someone help me?
sudo -u melvin ./odoo-bin -d migration --update all --stop-after-init --data-dir=/tmp
2021-02-09 23:42:47,218 22079 INFO ? odoo: Odoo version 13.0
2021-02-09 23:42:47,218 22079 INFO ? odoo: Using configuration file at /home/melvin/.odoorc
2021-02-09 23:42:47,218 22079 INFO ? odoo: addons paths: ['/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/addons', '/tmp/addons/13.0', '/home/melvin/Área de Trabalho/Project/odoo-14.0/odoo/addons', '/home/melvin/Área de Trabalho/Project/odoo-14.0/addons']
2021-02-09 23:42:47,219 22079 INFO ? odoo: database: default@default:default
2021-02-09 23:42:47,406 22079 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf
2021-02-09 23:42:47,573 22079 CRITICAL ? odoo.modules.module: Couldn't load module web
2021-02-09 23:42:47,573 22079 CRITICAL ? odoo.modules.module: cannot import name 'time' from 'odoo.tools.safe_eval' (/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/tools/safe_eval.py)
2021-02-09 23:42:47,573 22079 ERROR ? odoo.service.server: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/service/server.py", line 1138, in load_server_wide_modules
odoo.modules.module.load_openerp_module(m)
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/modules/module.py", line 376, in load_openerp_module
__import__('odoo.addons.' + module_name)
File "/home/melvin/Área de Trabalho/Project/odoo-14.0/addons/web/__init__.py", line 4, in <module>
from . import controllers
File "/home/melvin/Área de Trabalho/Project/odoo-14.0/addons/web/controllers/__init__.py", line 4, in <module>
from . import main, pivot
File "/home/melvin/Área de Trabalho/Project/odoo-14.0/addons/web/controllers/main.py", line 41, in <module>
from odoo.tools.safe_eval import safe_eval, time
ImportError: cannot import name 'time' from 'odoo.tools.safe_eval' (/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/tools/safe_eval.py)
2021-02-09 23:42:47,585 22079 ERROR ? odoo.sql_db: bad query: CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1
ERROR: relation "base_registry_signaling" already exists
2021-02-09 23:42:47,585 22079 ERROR ? odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/modules/registry.py", line 83, in new
registry.setup_signaling()
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/modules/registry.py", line 433, in setup_signaling
cr.execute("CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1")
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
psycopg2.errors.DuplicateTable: relation "base_registry_signaling" already exists
2021-02-09 23:42:47,586 22079 CRITICAL ? odoo.service.server: Failed to initialize database `migration`.
Traceback (most recent call last):
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/service/server.py", line 1190, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/modules/registry.py", line 83, in new
registry.setup_signaling()
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/modules/registry.py", line 433, in setup_signaling
cr.execute("CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1")
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/home/melvin/Área de Trabalho/Project/OpenUpgrade-13.0/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
psycopg2.errors.DuplicateTable: relation "base_registry_signaling" already exists
2021-02-09 23:42:47,587 22079 INFO ? odoo.service.server: Initiating shutdown
2021-02-09 23:42:47,587 22079 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
Let me know, How could we resolve this error while upgrade the database backup?
Please assist me, I am struck with this error.
Hi,
You can fix the issue while running this psql query in corresponding db.
drop sequence base_registry_signaling;