Signature Ticket

La Tierra Media y el ticket que la amenaza.

Javier Sánchez JAST

Inicia la aventura para salvar la Tierra Media del poder de Sauron y el Ticket Único.

Acompañado del poderoso hechicero GERA, el gris....

...y la Comunidad del Ticket

Un Ticket para gobernarlos a todos:

What are the steps to reproduce your issue?Trying to install an Odoo app What is the current behavior that you observe? RPC_Error: Odoo Server Error What would be your expected behavior in this case? Apps downloading and working properly as required

El Traceback:

psycopg2.errors.ProgramLimitExceeded: index row size 2760 exceeds btree version 4 maximum 2704 for index "res_groups_name_uniq" DETAIL: Index row references tuple (11,93) in relation "res_groups". HINT: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing.

RPC_ERROR Odoo Server Error Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/tools/cache.py", line 99, in lookup r = d[key] File "<decorator-gen-5>", line 2, in __getitem__ File "/home/odoo/src/odoo/17.0/odoo/tools/func.py", line 87, in locked return func(inst, *args, **kwargs) File "/home/odoo/src/odoo/17.0/odoo/tools/lru.py", line 34, in __getitem__ a = self.d[obj] KeyError: ('ir.model.data', <function IrModelData._xmlid_lookup at 0x7f4f3a098b80>, 'base.user_admin') During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/tools/safe_eval.py", line 365, in safe_eval return unsafe_eval(c, globals_dict, locals_dict) File "", line 1, in <module> File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 538, in id_get res = self.model_id_get(id_str, raise_if_not_found) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 544, in model_id_get return self.env['ir.model.data']._xmlid_to_res_model_res_id(id_str, raise_if_not_found=raise_if_not_found) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_model.py", line 2189, in _xmlid_to_res_model_res_id return self._xmlid_lookup(xmlid) File "<decorator-gen-43>", line 2, in _xmlid_lookup File "/home/odoo/src/odoo/17.0/odoo/tools/cache.py", line 104, in lookup value = d[key] = self.method(*args, **kwargs) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_model.py", line 2182, in _xmlid_lookup raise ValueError('External ID not found in the system: %s' % xmlid) ValueError: External ID not found in the system: base.user_admin During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 556, in _tag_root f(rec) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 426, in _tag_record f_val = _eval_xml(self, field, env) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 117, in _eval_xml return safe_eval(a_eval, idref2) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 39, in <lambda> safe_eval = lambda expr, ctx={}: s_eval(expr, ctx, nocopy=True) File "/home/odoo/src/odoo/17.0/odoo/tools/safe_eval.py", line 379, in safe_eval raise ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr)) ValueError: <class 'ValueError'>: "External ID not found in the system: base.user_admin" while evaluating "[(4, ref('base.user_root')), (4, ref('base.user_admin'))]" The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1765, in _serve_db return service_model.retrying(self._serve_ir_http, self.env) File "/home/odoo/src/odoo/17.0/odoo/service/model.py", line 133, in retrying result = func() File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1792, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1996, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) File "/home/odoo/src/odoo/17.0/addons/website/models/ir_http.py", line 235, in _dispatch response = super()._dispatch(endpoint) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_http.py", line 222, in _dispatch result = endpoint(**request.params) File "/home/odoo/src/odoo/17.0/odoo/http.py", line 722, in route_wrapper result = endpoint(self, *args, **params_ok) File "/home/odoo/src/odoo/17.0/addons/web/controllers/dataset.py", line 24, in call_kw return self._call_kw(model, method, args, kwargs) File "/home/odoo/src/odoo/17.0/addons/web/controllers/dataset.py", line 20, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/home/odoo/src/odoo/17.0/odoo/api.py", line 468, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/home/odoo/src/odoo/17.0/odoo/api.py", line 453, in _call_kw_multi result = method(recs, *args, **kwargs) File "/home/odoo/src/custom/trial/saas_trial/models/module.py", line 143, in button_immediate_install return super(IrModuleModule, self).button_immediate_install() File "<decorator-gen-77>", line 2, in button_immediate_install File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_module.py", line 75, in check_and_log return method(self, *args, **kwargs) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_module.py", line 466, in button_immediate_install return self._button_immediate_function(self.env.registry[self._name].button_install) File "/home/odoo/src/custom/trial/saas_trial/models/module.py", line 109, in _button_immediate_function res = super(IrModuleModule, self)._button_immediate_function(function) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_module.py", line 590, in _button_immediate_function registry = modules.registry.Registry.new(self._cr.dbname, update_module=True) File "<decorator-gen-16>", line 2, in new File "/home/odoo/src/odoo/17.0/odoo/tools/func.py", line 87, in locked return func(inst, *args, **kwargs) File "/home/odoo/src/odoo/17.0/odoo/modules/registry.py", line 113, in new odoo.modules.load_modules(registry, force_demo, status, update_module) File "/home/odoo/src/odoo/17.0/odoo/modules/loading.py", line 480, in load_modules processed_modules += load_marked_modules(env, graph, File "/home/odoo/src/odoo/17.0/odoo/modules/loading.py", line 364, in load_marked_modules loaded, processed = load_module_graph( File "/home/odoo/src/odoo/17.0/odoo/modules/loading.py", line 227, in load_module_graph load_data(env, idref, mode, kind='data', package=package) File "/home/odoo/src/odoo/17.0/odoo/modules/loading.py", line 71, in load_data tools.convert_file(env, package.name, filename, idref, mode, noupdate, kind) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 627, in convert_file convert_xml_import(env, module, fp, idref, mode, noupdate) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 693, in convert_xml_import obj.parse(doc.getroot()) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 613, in parse self._tag_root(de) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 556, in _tag_root f(rec) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 569, in _tag_root raise ParseError('while parsing %s:%s, somewhere inside\n%s' % ( odoo.tools.convert.ParseError: while parsing /home/odoo/src/odoo/17.0/addons/account/security/account_security.xml:59, somewhere inside <record id="group_account_manager" model="res.groups"> <field name="name">Billing Administrator</field> <field name="category_id" ref="base.module_category_accounting_accounting"/> <field name="implied_ids" eval="[(4, ref('group_account_invoice'))]"/> <field name="users" eval="[(4, ref('base.user_root')), (4, ref('base.user_admin'))]"/> </record> The above server error caused the following client error: RPC_ERROR: Odoo Server Error at makeErrorFromResponse (https://signature-ticket-20240314-jast.odoo.com/web/assets/164b8da/web.assets_web.min.js:2876:163) at XMLHttpRequest.<anonymous> (https://signature-ticket-20240314-jast.odoo.com/web/assets/164b8da/web.assets_web.min.js:2880:13)

¿Qué HACEMOS?

Se intentó replicar el problema instalando una nueva app, pero...

...apareció un monstruo diferente.

Llegamos a Isildur:

RPC_ERROR Odoo Server Error Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/tools/cache.py", line 99, in lookup r = d[key] File "<decorator-gen-5>", line 2, in __getitem__ File "/home/odoo/src/odoo/17.0/odoo/tools/func.py", line 87, in locked return func(inst, *args, **kwargs) File "/home/odoo/src/odoo/17.0/odoo/tools/lru.py", line 34, in __getitem__ a = self.d[obj] KeyError: ('ir.model.data', <function IrModelData._xmlid_lookup at 0x7f4f3a098b80>, 'base.user_admin') During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/tools/safe_eval.py", line 365, in safe_eval return unsafe_eval(c, globals_dict, locals_dict) File "", line 1, in <module> File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 538, in id_get res = self.model_id_get(id_str, raise_if_not_found) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 544, in model_id_get return self.env['ir.model.data']._xmlid_to_res_model_res_id(id_str, raise_if_not_found=raise_if_not_found) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_model.py", line 2189, in _xmlid_to_res_model_res_id return self._xmlid_lookup(xmlid) File "<decorator-gen-43>", line 2, in _xmlid_lookup File "/home/odoo/src/odoo/17.0/odoo/tools/cache.py", line 104, in lookup value = d[key] = self.method(*args, **kwargs) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_model.py", line 2182, in _xmlid_lookup raise ValueError('External ID not found in the system: %s' % xmlid) ValueError: External ID not found in the system: base.user_admin During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 556, in _tag_root f(rec) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 426, in _tag_record f_val = _eval_xml(self, field, env) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 117, in _eval_xml return safe_eval(a_eval, idref2) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 39, in <lambda> safe_eval = lambda expr, ctx={}: s_eval(expr, ctx, nocopy=True) File "/home/odoo/src/odoo/17.0/odoo/tools/safe_eval.py", line 379, in safe_eval raise ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr)) ValueError: <class 'ValueError'>: "External ID not found in the system: base.user_admin" while evaluating "[(4, ref('base.user_root')), (4, ref('base.user_admin'))]" The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1765, in _serve_db return service_model.retrying(self._serve_ir_http, self.env) File "/home/odoo/src/odoo/17.0/odoo/service/model.py", line 133, in retrying result = func() File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1792, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) File "/home/odoo/src/odoo/17.0/odoo/http.py", line 1996, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) File "/home/odoo/src/odoo/17.0/addons/website/models/ir_http.py", line 235, in _dispatch response = super()._dispatch(endpoint) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_http.py", line 222, in _dispatch result = endpoint(**request.params) File "/home/odoo/src/odoo/17.0/odoo/http.py", line 722, in route_wrapper result = endpoint(self, *args, **params_ok) File "/home/odoo/src/odoo/17.0/addons/web/controllers/dataset.py", line 24, in call_kw return self._call_kw(model, method, args, kwargs) File "/home/odoo/src/odoo/17.0/addons/web/controllers/dataset.py", line 20, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/home/odoo/src/odoo/17.0/odoo/api.py", line 468, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/home/odoo/src/odoo/17.0/odoo/api.py", line 453, in _call_kw_multi result = method(recs, *args, **kwargs) File "/home/odoo/src/custom/trial/saas_trial/models/module.py", line 143, in button_immediate_install return super(IrModuleModule, self).button_immediate_install() File "<decorator-gen-77>", line 2, in button_immediate_install File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_module.py", line 75, in check_and_log return method(self, *args, **kwargs) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_module.py", line 466, in button_immediate_install return self._button_immediate_function(self.env.registry[self._name].button_install) File "/home/odoo/src/custom/trial/saas_trial/models/module.py", line 109, in _button_immediate_function res = super(IrModuleModule, self)._button_immediate_function(function) File "/home/odoo/src/odoo/17.0/odoo/addons/base/models/ir_module.py", line 590, in _button_immediate_function registry = modules.registry.Registry.new(self._cr.dbname, update_module=True) File "<decorator-gen-16>", line 2, in new File "/home/odoo/src/odoo/17.0/odoo/tools/func.py", line 87, in locked return func(inst, *args, **kwargs) File "/home/odoo/src/odoo/17.0/odoo/modules/registry.py", line 113, in new odoo.modules.load_modules(registry, force_demo, status, update_module) File "/home/odoo/src/odoo/17.0/odoo/modules/loading.py", line 480, in load_modules processed_modules += load_marked_modules(env, graph, File "/home/odoo/src/odoo/17.0/odoo/modules/loading.py", line 364, in load_marked_modules loaded, processed = load_module_graph( File "/home/odoo/src/odoo/17.0/odoo/modules/loading.py", line 227, in load_module_graph load_data(env, idref, mode, kind='data', package=package) File "/home/odoo/src/odoo/17.0/odoo/modules/loading.py", line 71, in load_data tools.convert_file(env, package.name, filename, idref, mode, noupdate, kind) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 627, in convert_file convert_xml_import(env, module, fp, idref, mode, noupdate) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 693, in convert_xml_import obj.parse(doc.getroot()) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 613, in parse self._tag_root(de) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 556, in _tag_root f(rec) File "/home/odoo/src/odoo/17.0/odoo/tools/convert.py", line 569, in _tag_root raise ParseError('while parsing %s:%s, somewhere inside\n%s' % ( odoo.tools.convert.ParseError: while parsing /home/odoo/src/odoo/17.0/addons/account/security/account_security.xml:59, somewhere inside <record id="group_account_manager" model="res.groups"> <field name="name">Billing Administrator</field> <field name="category_id" ref="base.module_category_accounting_accounting"/> <field name="implied_ids" eval="[(4, ref('group_account_invoice'))]"/> <field name="users" eval="[(4, ref('base.user_root')), (4, ref('base.user_admin'))]"/> </record> The above server error caused the following client error: RPC_ERROR: Odoo Server Error at makeErrorFromResponse (https://signature-ticket-20240314-jast.odoo.com/web/assets/164b8da/web.assets_web.min.js:2876:163) at XMLHttpRequest.<anonymous> (https://signature-ticket-20240314-jast.odoo.com/web/assets/164b8da/web.assets_web.min.js:2880:13)

psycopg2.errors.ProgramLimitExceeded: index row size 2760 exceeds btree version 4 maximum 2704 for index "res_groups_name_uniq" DETAIL: Index row references tuple (11,93) in relation "res_groups". HINT: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing.

¿Y ahora?

Se veía tan inocente...

res_groups_name_uniq

...pero escondía un obscuro secreto.

¿Imaginan cuál?

¡Vencimos a Saruman, sigamos adelante!

Llegamos a Minas Tirith, pero necesitaremos ayuda extra antes de continuar...

¡¡Regresó GERA, el blanco!

¡Es momento de acabar con Sauron!

¿Victoria?

Falta algo importante para destruir a Sauron para siempre...

¿Por qué desapareció el usuario admin?

GRACIAS

Era archivar, no eliminar