Error 500 - Table 'orgs' is already defined for this MetaData instance

[bashgeek]

Hello,
since the last update last night to 1.18.6.m1698245-1+9.1 we are getting the following messages in our server logs every few minutes.

Thank you.

Apr 13 07:07:52 server uwsgi[306399]: /usr/share/grommunio-admin-api/orm/domains.py:23: SAWarning: This declarative base already contains a class with the same class name and module name as orm.domains.Orgs, and will be replaced in the string-lookup table.
Apr 13 07:07:52 server uwsgi[306399]:   class Orgs(DataModel, DB.Base):
Apr 13 07:07:52 server uwsgi[306399]: [2026-04-13 07:07:52,132] ERROR in errors: Traceback (most recent call last):
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/flask/app.py", line 1820, in full_dispatch_request
Apr 13 07:07:52 server uwsgi[306399]:     rv = self.dispatch_request()
Apr 13 07:07:52 server uwsgi[306399]:          ^^^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/flask/app.py", line 1796, in dispatch_request
Apr 13 07:07:52 server uwsgi[306399]:     return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/share/grommunio-admin-api/api/core.py", line 204, in wrapper
Apr 13 07:07:52 server uwsgi[306399]:     return call()
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/share/grommunio-admin-api/api/core.py", line 169, in call
Apr 13 07:07:52 server uwsgi[306399]:     ret = func(*args, **kwargs)
Apr 13 07:07:52 server uwsgi[306399]:           ^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/share/grommunio-admin-api/endpoints/service.py", line 31, in getUserSyncPolicy
Apr 13 07:07:52 server uwsgi[306399]:     from orm.domains import Domains
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/share/grommunio-admin-api/orm/domains.py", line 23, in <module>
Apr 13 07:07:52 server uwsgi[306399]:     class Orgs(DataModel, DB.Base):
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_api.py", line 76, in __init__
Apr 13 07:07:52 server uwsgi[306399]:     _as_declarative(reg, cls, dict_)
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_base.py", line 126, in _as_declarative
Apr 13 07:07:52 server uwsgi[306399]:     return _MapperConfig.setup_mapping(registry, cls, dict_, None, {})
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_base.py", line 183, in setup_mapping
Apr 13 07:07:52 server uwsgi[306399]:     return cfg_cls(registry, cls_, dict_, table, mapper_kw)
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_base.py", line 331, in __init__
Apr 13 07:07:52 server uwsgi[306399]:     self._setup_table(table)
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_base.py", line 854, in _setup_table
Apr 13 07:07:52 server uwsgi[306399]:     table_cls(
Apr 13 07:07:52 server uwsgi[306399]:   File "<string>", line 2, in __new__
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/util/deprecations.py", line 375, in warned
Apr 13 07:07:52 server uwsgi[306399]:     return fn(*args, **kwargs)
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 596, in __new__
Apr 13 07:07:52 server uwsgi[306399]:     raise exc.InvalidRequestError(
Apr 13 07:07:52 server uwsgi[306399]: sqlalchemy.exc.InvalidRequestError: Table 'orgs' is already defined for this MetaData instance.  Specify 'extend_existing=True' to redefine options and columns on an existing Table object.
Apr 13 07:07:52 server uwsgi[306399]: [ERROR] (grommunio Admin API) Traceback (most recent call last):
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/flask/app.py", line 1820, in full_dispatch_request
Apr 13 07:07:52 server uwsgi[306399]:     rv = self.dispatch_request()
Apr 13 07:07:52 server uwsgi[306399]:          ^^^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/flask/app.py", line 1796, in dispatch_request
Apr 13 07:07:52 server uwsgi[306399]:     return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/share/grommunio-admin-api/api/core.py", line 204, in wrapper
Apr 13 07:07:52 server uwsgi[306399]:     return call()
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/share/grommunio-admin-api/api/core.py", line 169, in call
Apr 13 07:07:52 server uwsgi[306399]:     ret = func(*args, **kwargs)
Apr 13 07:07:52 server uwsgi[306399]:           ^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/share/grommunio-admin-api/endpoints/service.py", line 31, in getUserSyncPolicy
Apr 13 07:07:52 server uwsgi[306399]:     from orm.domains import Domains
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/share/grommunio-admin-api/orm/domains.py", line 23, in <module>
Apr 13 07:07:52 server uwsgi[306399]:     class Orgs(DataModel, DB.Base):
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_api.py", line 76, in __init__
Apr 13 07:07:52 server uwsgi[306399]:     _as_declarative(reg, cls, dict_)
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_base.py", line 126, in _as_declarative
Apr 13 07:07:52 server uwsgi[306399]:     return _MapperConfig.setup_mapping(registry, cls, dict_, None, {})
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_base.py", line 183, in setup_mapping
Apr 13 07:07:52 server uwsgi[306399]:     return cfg_cls(registry, cls_, dict_, table, mapper_kw)
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_base.py", line 331, in __init__
Apr 13 07:07:52 server uwsgi[306399]:     self._setup_table(table)
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/decl_base.py", line 854, in _setup_table
Apr 13 07:07:52 server uwsgi[306399]:     table_cls(
Apr 13 07:07:52 server uwsgi[306399]:   File "<string>", line 2, in __new__
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/util/deprecations.py", line 375, in warned
Apr 13 07:07:52 server uwsgi[306399]:     return fn(*args, **kwargs)
Apr 13 07:07:52 server uwsgi[306399]:            ^^^^^^^^^^^^^^^^^^^
Apr 13 07:07:52 server uwsgi[306399]:   File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 596, in __new__
Apr 13 07:07:52 server uwsgi[306399]:     raise exc.InvalidRequestError(
Apr 13 07:07:52 server uwsgi[306399]: sqlalchemy.exc.InvalidRequestError: Table 'orgs' is already defined for this MetaData instance.  Specify 'extend_existing=True' to redefine options and columns on an existing Table object.
Apr 13 07:07:52 server uwsgi[306399]: [2026-04-13 07:07:52,133] WARNING in errors: GET /api/v1/service/syncPolicy/user@domain.tld? from ::1 -> 500 '{"message":"The server encountered an error while processing the request."}\n'
Apr 13 07:07:52 server uwsgi[306399]: [WARNING] (grommunio Admin API) GET /api/v1/service/syncPolicy/user@domain.tld? from ::1 -> 500 '{"message":"The server encountered an error while processing the request."}\n'

[grantma]

Could you please give us more background information about your setup, and how this user is syncing their device with grommunio? Also, have you tried restarting the grommunio-admin-api service to clear and reinitialize the ORM DB mapper, and see if this keeps recurring?

[bashgeek]

Could you please give us more background information about your setup, and how this user is syncing their device with grommunio? Also, have you tried restarting the grommunio-admin-api service to clear and reinitialize the ORM DB mapper, and see if this keeps recurring?

A restart didn't solve the issue, it affected all mailboxes and clients from what I can see.

However, with the just released 1.18.7.m053c4b4-1+10.1 version the issue is gone completely, thanks!