The full logs is:
odoo.sql_db: bad query:
INSERT INTO "ir_model" ("model", "name", "order", "info", "state", "transient", "is_mail_thread", "is_mail_activity", "is_mail_blacklist") VALUES ('product.transfer.internal' '{"en_US": "Product Internal Transfer"}', 'id', ' Main super-class for regular database-persisted Odoo models.
Odoo models are created by inheriting from this class::
class user(Model):
...
The system will later instantiate the class once per database (on
which the class'' module is installed).
', 'base', false, true, true, false), ('product.transfer.internal.line', '{"en_US": "Product list for Product Internal Transfer"}', 'id', ' Main super-class for regular database-persisted Odoo models.
Odoo models are created by inheriting from this class::
class user(Model):
...
The system will later instantiate the class once per database (on
which the class'' module is installed).
', 'base', false, false, false, false), ('stock.location.product', '{"en_US": "stock.location.product"}', 'id', ' Main super-class for regular database-persisted Odoo models.
Odoo models are created by inheriting from this class::
class user(Model):
...
The system will later instantiate the class once per database (on
which the class'' module is installed).
', 'base', false, false, false, false)
ON CONFLICT (model) DO UPDATE SET ("model", "name", "order", "info", "state", "transient", "is_mail_thread", "is_mail_activity", "is_mail_blacklist") = (EXCLUDED."model", EXCLUDED."name", EXCLUDED."order", EXCLUDED."info", EXCLUDED."state", EXCLUDED."transient", EXCLUDED."is_mail_thread", EXCLUDED."is_mail_activity", EXCLUDED."is_mail_blacklist")
RETURNING id
ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
2023-08-08 17:41:05,161 55543 WARNING Gissah_KSA odoo.modules.loading: Transient module states were reset
2023-08-08 17:41:05,168 55543 ERROR Gissah_KSA odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/odoo16/odoo16-server/odoo/modules/registry.py", line 90, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/odoo16/odoo16-server/odoo/modules/loading.py", line 488, in load_modules
processed_modules += load_marked_modules(cr, graph,
File "/odoo16/odoo16-server/odoo/modules/loading.py", line 372, in load_marked_modules
loaded, processed = load_module_graph(
File "/odoo16/odoo16-server/odoo/modules/loading.py", line 208, in load_module_graph
registry.init_models(cr, model_names, {'module': package.name}, new_install)
File "/odoo16/odoo16-server/odoo/modules/registry.py", line 529, in init_models
env['ir.model']._reflect_models(model_names)
File "/odoo16/odoo16-server/odoo/addons/base/models/ir_model.py", line 396, in _reflect_models
ids = upsert_en(self, cols, rows, ['model'])
File "/odoo16/odoo16-server/odoo/addons/base/models/ir_model.py", line 152, in upsert_en
model.env.cr.execute(query, params)
File "/odoo16/odoo16-server/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
psycopg2.errors.InvalidColumnReference: there is no unique or exclusion constraint matching the ON CONFLICT specification
2023-08-08 17:41:05,171 55543 ERROR Gissah_KSA odoo.http: Exception during request handling.
Traceback (most recent call last):
File "/odoo16/odoo16-server/odoo/http.py", line 1998, in __call__
response = request._serve_db()
File "/odoo16/odoo16-server/odoo/http.py", line 1584, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/odoo16/odoo16-server/odoo/service/model.py", line 133, in retrying
result = func()
File "/odoo16/odoo16-server/odoo/http.py", line 1611, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/odoo16/odoo16-server/odoo/http.py", line 1815, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/odoo16/odoo16-server/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/odoo16/odoo16-server/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/odoo16/odoo16-server/addons/web/controllers/dataset.py", line 46, in call_button
action = self._call_kw(model, method, args, kwargs)
File "/odoo16/odoo16-server/addons/web/controllers/dataset.py", line 33, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/odoo16/odoo16-server/odoo/api.py", line 461, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/odoo16/odoo16-server/odoo/api.py", line 448, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "", line 2, in button_immediate_install
File "/odoo16/odoo16-server/odoo/addons/base/models/ir_module.py", line 74, in check_and_log
return method(self, *args, **kwargs)
File "/odoo16/odoo16-server/odoo/addons/base/models/ir_module.py", line 456, in button_immediate_install
return self._button_immediate_function(type(self).button_install)
File "/odoo16/odoo16-server/odoo/addons/base/models/ir_module.py", line 580, in _button_immediate_function
registry = modules.registry.Registry.new(self._cr.dbname, update_module=True)
File "", line 2, in new
File "/odoo16/odoo16-server/odoo/tools/func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "/odoo16/odoo16-server/odoo/modules/registry.py", line 90, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/odoo16/odoo16-server/odoo/modules/loading.py", line 488, in load_modules
processed_modules += load_marked_modules(cr, graph,
File "/odoo16/odoo16-server/odoo/modules/loading.py", line 372, in load_marked_modules
loaded, processed = load_module_graph(
File "/odoo16/odoo16-server/odoo/modules/loading.py", line 208, in load_module_graph
registry.init_models(cr, model_names, {'module': package.name}, new_install)
File "/odoo16/odoo16-server/odoo/modules/registry.py", line 529, in init_models
env['ir.model']._reflect_models(model_names)
File "/odoo16/odoo16-server/odoo/addons/base/models/ir_model.py", line 396, in _reflect_models
ids = upsert_en(self, cols, rows, ['model'])
File "/odoo16/odoo16-server/odoo/addons/base/models/ir_model.py", line 152, in upsert_en
model.env.cr.execute(query, params)
File "/odoo16/odoo16-server/odoo/sql_db.py", line 321, in execute
res = self._obj.execute(query, params)
psycopg2.errors.InvalidColumnReference: there is no unique or exclusion constraint matching the ON CONFLICT specification
