I am trying to upgrade my odoo 17 to 18 in my staging branch, so that i can merge my locally tested custom addons later.
But during the upgrade process i get teh following error:
2025-05-22 11:08:23,502 21 CRITICAL db_2831167 odoo.service.server: Failed to initialize database `db_2831167`.
Traceback (most recent call last):
File "/home/odoo/src/odoo/18.0/odoo/service/server.py", line 1328, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "<decorator-gen-13>", line 2, in new
File "/home/odoo/src/odoo/18.0/odoo/tools/func.py", line 97, in locked
return func(inst, *args, **kwargs)
File "/home/odoo/src/odoo/18.0/odoo/modules/registry.py", line 127, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/home/odoo/src/odoo/18.0/odoo/modules/loading.py", line 480, in load_modules
processed_modules += load_marked_modules(env, graph,
File "/home/odoo/src/odoo/18.0/odoo/modules/loading.py", line 365, in load_marked_modules
loaded, processed = load_module_graph(
File "/home/odoo/src/odoo/18.0/odoo/modules/loading.py", line 182, in load_module_graph
migrations.migrate_module(package, 'pre')
File "/home/odoo/src/odoo/18.0/odoo/modules/migration.py", line 222, in migrate_module
exec_script(self.cr, installed_version, pyfile, pkg.name, stage, stageformat[stage] % version)
File "/home/odoo/src/odoo/18.0/odoo/modules/migration.py", line 259, in exec_script
mod.migrate(cr, installed_version)
File "/tmp/tmps1mp_ped/migrations/documents/saas~17.5.1.4/pre-migrate.py", line 73, in migrate
check_or_raise_large_groups(cr, internal_id)
File "/tmp/tmps1mp_ped/migrations/documents/saas~17.5.1.4/pre-migrate.py", line 1363, in check_or_raise_large_groups
raise util.MigrationError(f"""
odoo.upgrade.util.exceptions.UpgradeError:
Many-member groups used on Documents Workspaces:
- [51 users]: "Code Backup" (id=575, company=None) with groups:
* READ: "User" (id=105)
* WRITE: "User" (id=105)
- [51 users]: "PV-Sol Accountzuweisung" (id=680, company=None) with groups:
* READ: "User" (id=105)
* WRITE: "User" (id=105)
- [51 users]: "NAME TBD" (id=895, company=None) with groups:
* READ: "User" (id=105)
* WRITE: "User" (id=105)
- [51 users]: "Produktmanagement" (id=907, company=None) with groups:
* READ: "User" (id=105)
* WRITE: "User" (id=105)
- [51 users]: "Gerüststellung" (id=1044, company=None) with groups:
* READ: "User" (id=105)
* WRITE: "User" (id=105)
- [51 users]: "Weitere Gewerke" (id=1069, company=None) with groups:
* READ: "User" (id=105)
* WRITE: "User" (id=105)
- [51 users]: "DC-Montage" (id=1070, company=Servicum GmbH) with groups:
* WRITE: "User" (id=105)
* READ: "User" (id=105)
- [51 users]: "AC-Montage" (id=1071, company=Servicum GmbH) with groups:
* READ: "User" (id=105)
* WRITE: "User" (id=105)
Upgrading as-is would have two downsides:
1. The access rights panel could get *very* hard to manage (adding or removing members among a large list)
2. The Documents application can become slow to use
Several options are available, possibly in combination:
1. Adapting your configuration:
* If restricting is not that important, remove the group configuration on the folder
* If restricting is important:
* Use another group with fewer members instead / reduce the number of members of the group
* Set the group as user-specific (read/write) so users keep access to their own documents only
2. Ask Odoo Support to enable one of the following settings (this can be done after 1 too) using
the ODOO_UPG_18_DOCUMENTS_FOLDERS_LARGE_GROUPS_RIGHTS key with the following possible values:
* SET_USER_SPECIFIC: Set these folders groups configuration as USER_SPECIFIC for READ AND WRITE automatically
* SET_NOBODY: Set these folders as restricted access, only users with the new Documents group
"System Administrator" will be able to view and edit these folders (including access rights)
after the upgrade.
* ACCEPT_AS_IS: Confirm that the current configuration is what you need and upgrade as-is.
as it is mentioned here i have removed the folder rights of each one shown in the error. still i get the errors for the same folders, even though they are cleared in live then i set up the staging branch adn upgraded. how to solve this?
Any help would be appreciated.
