OpenUpgrade: Migrate Database odoo from v11 to v12

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

OpenUpgrade: Migrate Database odoo from v11 to v12

1 Reply

6037 Views

migration openupgrade odoov11 odooV12

Rihene

Hello my Friends;

I am trying to migrate an odoo database from the version 11 to the version12.

So, i am using OpenUpgrade.

But, the problem is that when i try to launch the process i got this error:

2019-07-26 13:46:36,059 9902 INFO ? odoo: Odoo version 12.0
2019-07-26 13:46:36,060 9902 INFO ? odoo: Using configuration file at /etc/odoo12.conf
2019-07-26 13:46:36,060 9902 INFO ? odoo: addons paths: ['/opt/OpenUpgrade/addons', '/opt/OpenUpgrade/odoo/addons']
2019-07-26 13:46:36,060 9902 INFO ? odoo: database: odoo12@default:default
2019-07-26 13:46:36,109 9902 CRITICAL ? odoo.modules.module: Couldn't load module base
2019-07-26 13:46:36,109 9902 CRITICAL ? odoo.modules.module: module 'odoo.tools' has no attribute 'yaml_import'
2019-07-26 13:46:36,110 9902 ERROR ? odoo.service.server: Failed to load server-wide module `base`.
Traceback (most recent call last):
File "/opt/OpenUpgrade/odoo/service/server.py", line 1063, in load_server_wide_modules
odoo.modules.module.load_openerp_module(m)
File "/opt/OpenUpgrade/odoo/modules/module.py", line 368, in load_openerp_module
__import__('odoo.addons.' + module_name)
File "<frozen importlib._bootstrap>", line 971, in _find_and_load
File "<frozen importlib._bootstrap>", line 955, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 656, in _load_unlocked
File "<frozen importlib._bootstrap>", line 626, in _load_backward_compatible
File "/opt/OpenUpgrade/odoo/modules/module.py", line 82, in load_module
exec(open(modfile, 'rb').read(), new_mod.__dict__)
File "<string>", line 5, in <module>
File "/opt/OpenUpgrade/odoo/addons/base/models/__init__.py", line 7, in <module>
from . import ir_model
File "/opt/OpenUpgrade/odoo/addons/base/models/ir_model.py", line 17, in <module>
from openupgradelib import openupgrade
File "/usr/local/lib/python3.6/dist-packages/openupgradelib/openupgrade.py", line 84, in <module>
yaml_import = tools.yaml_import
AttributeError: module 'odoo.tools' has no attribute 'yaml_import'
2019-07-26 13:46:36,138 9902 INFO database-demo odoo.modules.loading: loading 1 modules...
2019-07-26 13:46:36,147 9902 ERROR database-demo odoo.modules.migration: module base: Each pre-migration file must have a "migrate(cr, installed_version)" function
2019-07-26 13:46:36,150 9902 INFO database-demo odoo.modules.registry: module base: creating or updating database tables
2019-07-26 13:46:36,151 9902 ERROR database-demo odoo.sql_db: bad query: b"\n SELECT c.relname\n FROM pg_class c\n JOIN pg_namespace n ON (n.oid = c.relnamespace)\n WHERE c.relname IN ()\n AND c.relkind IN ('r', 'v', 'm')\n AND n.nspname = 'public'\n "
ERROR: syntax error at or near ")"
LINE 5: WHERE c.relname IN ()
^

Need your help please.

Thanks a lot in advance.

Best regards.

Kirubanidhi Rajarathinam

Please help this issue

ICTPACK SOLUTIONS LTD

I had this problem solved it by installing pyyaml==3.13 using pip.

Hope this helps!

Kirubanidhi Rajarathinam

sybyl@sybyl-IdeaPad-3-15IIL05-Ua:~/OpenUpgrade$ /usr/bin/python3.7 ./odoo-bin -d live_jalaram -c /opt/odoo/odoo12.0/etc/odoo-12.conf --update all --stop-after-init --data-dir '/home/sybyl/.local/share/Odoo'
2023-02-07 10:30:33,752 42167 INFO ? odoo: Odoo version 12.0
2023-02-07 10:30:33,752 42167 INFO ? odoo: Using configuration file at /opt/odoo/odoo12.0/etc/odoo-12.conf
2023-02-07 10:30:33,752 42167 INFO ? odoo: addons paths: ['/home/sybyl/.local/share/Odoo/addons/12.0', '/opt/odoo/odoo12.0/odoo/addons', '/opt/odoo/odoo12.0/odoo/odoo/addons', '/home/sybyl/OpenUpgrade/addons', '/home/sybyl/OpenUpgrade/odoo/addons', '/home/sybyl/odoo/OpenUpgrade/scripts']
2023-02-07 10:30:33,752 42167 INFO ? odoo: database: odoo_12@localhost:5432
2023-02-07 10:30:33,762 42167 CRITICAL ? odoo.modules.module: Couldn't load module web
2023-02-07 10:30:33,762 42167 CRITICAL ? odoo.modules.module: odoo.addons.web.__spec__ is None
2023-02-07 10:30:33,762 42167 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/sybyl/OpenUpgrade/odoo/service/server.py", line 1111, in load_server_wide_modules
odoo.modules.module.load_openerp_module(m)
File "/home/sybyl/OpenUpgrade/odoo/modules/module.py", line 368, in load_openerp_module
__import__('odoo.addons.' + module_name)
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 668, in _load_unlocked
File "<frozen importlib._bootstrap>", line 638, in _load_backward_compatible
File "/home/sybyl/OpenUpgrade/odoo/modules/module.py", line 82, in load_module
exec(open(modfile, 'rb').read(), new_mod.__dict__)
File "<string>", line 4, in <module>
File "/opt/odoo/odoo12.0/odoo/addons/web/controllers/__init__.py", line 4, in <module>
from . import main, pivot
File "/opt/odoo/odoo12.0/odoo/addons/web/controllers/main.py", line 58, in <module>
loader = jinja2.PackageLoader('odoo.addons.web', "views")
File "/usr/local/lib/python3.7/dist-packages/jinja2/loaders.py", line 292, in __init__
spec = importlib.util.find_spec(package_name)
File "/usr/lib/python3.7/importlib/util.py", line 114, in find_spec
raise ValueError('{}.__spec__ is None'.format(name))
ValueError: odoo.addons.web.__spec__ is None
2023-02-07 10:30:34,019 42167 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2023-02-07 10:30:34,119 42167 ERROR ? odoo.sql_db: bad query: CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1
ERROR: relation "base_registry_signaling" already exists

2023-02-07 10:30:34,119 42167 ERROR ? odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/home/sybyl/OpenUpgrade/odoo/modules/registry.py", line 83, in new
registry.setup_signaling()
File "/home/sybyl/OpenUpgrade/odoo/modules/registry.py", line 403, in setup_signaling
cr.execute("CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1")
File "/home/sybyl/OpenUpgrade/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/home/sybyl/OpenUpgrade/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.DuplicateTable: relation "base_registry_signaling" already exists

2023-02-07 10:30:34,119 42167 CRITICAL ? odoo.service.server: Failed to initialize database `live_jalaram`.
Traceback (most recent call last):
File "/home/sybyl/OpenUpgrade/odoo/service/server.py", line 1164, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "/home/sybyl/OpenUpgrade/odoo/modules/registry.py", line 83, in new
registry.setup_signaling()
File "/home/sybyl/OpenUpgrade/odoo/modules/registry.py", line 403, in setup_signaling
cr.execute("CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1")
File "/home/sybyl/OpenUpgrade/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/home/sybyl/OpenUpgrade/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.DuplicateTable: relation "base_registry_signaling" already exists

This question has been flagged