ddt Error actualización #7

New issue

Closed

opened 2021-08-09 13:30:25 +00:00 by snt · 1 comment

snt commented

2021-08-09 13:30:25 +00:00

Owner

En la atualización de la basde datos de la ddt desde la 8.0 a la 9.0 hice una chapucilla que ha dejado algunos restos en forma de restos de campos y vistas huérfanas.

No hacen dañoa, pero habrá que limpiarlas en algún momento, mirando los scripts de OpenUpgrade 9.0

Los modelos que fallan son relativos a stock, quant, stock_history y varios de account relacionados.

En la atualización de la basde datos de la ddt desde la 8.0 a la 9.0 hice una chapucilla que ha dejado algunos restos en forma de restos de campos y vistas huérfanas. No hacen dañoa, pero habrá que limpiarlas en algún momento, mirando los scripts de OpenUpgrade 9.0 Los modelos que fallan son relativos a stock, quant, stock_history y varios de account relacionados.

snt added the

bug

label 2021-08-09 13:30:25 +00:00

snt self-assigned this 2021-08-09 13:30:25 +00:00

snt commented

2021-09-14 12:46:57 +00:00

Author

Owner

dejo la traza del error para que no se pierda:


2021-08-04 10:03:42,017 6565 INFO ddt8 openerp.sql_db: bad query: 
        INSERT INTO mail_followers (
            res_id, channel_id, res_model
        )
        SELECT id, id, 'mail.channel'
        FROM mail_channel
        WHERE channel_type = 'channel'
        
2021-08-04 10:03:42,017 6565 ERROR ddt8 OpenUpgrade: mail: error in migration script mail/migrations/9.0.1.0/post-migration.py: IntegrityError('llave duplicada viola restricci\xc3\xb3n de unicidad \xc2\xabmail_followers_mail_followers_res_channel_res_model_id_uniq\xc2\xbb\nDETALLE:  Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801).\n',)
2021-08-04 10:03:42,017 6565 ERROR ddt8 OpenUpgrade: llave duplicada viola restricción de unicidad «mail_followers_mail_followers_res_channel_res_model_id_uniq»
DETALLE:  Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801).
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/openupgradelib/openupgrade.py", line 1876, in wrapped_function
    if use_env2 else cr, version)
  File "/home/odoo/OpenUpgrade/addons/mail/migrations/9.0.1.0/post-migration.py", line 198, in migrate
    """
  File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 154, in wrapper
    return f(self, *args, **kwargs)
  File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 233, in execute
    res = self._obj.execute(query, params)
IntegrityError: llave duplicada viola restricción de unicidad «mail_followers_mail_followers_res_channel_res_model_id_uniq»
DETALLE:  Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801).

Traceback (most recent call last):
  File "/usr/lib/python2.7/logging/__init__.py", line 859, in emit
    msg = self.format(record)
  File "/usr/lib/python2.7/logging/__init__.py", line 732, in format
    return fmt.format(record)
  File "/home/odoo/OpenUpgrade/openerp/netsvc.py", line 108, in format
    return DBFormatter.format(self, record)
  File "/home/odoo/OpenUpgrade/openerp/netsvc.py", line 102, in format
    return logging.Formatter.format(self, record)
  File "/usr/lib/python2.7/logging/__init__.py", line 471, in format
    record.message = record.getMessage()
  File "/usr/lib/python2.7/logging/__init__.py", line 335, in getMessage
    msg = msg % self.args
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 31: ordinal not in range(128)
Logged from file loading.py, line 217
2021-08-04 10:03:42,023 6565 ERROR ddt8 openerp.modules.registry: Failed to load registry
Traceback (most recent call last):
  File "/home/odoo/OpenUpgrade/openerp/modules/registry.py", line 390, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 446, in load_modules
    force, status, report, loaded_modules, update_module, models_to_check, upg_registry)
  File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 331, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check, upg_registry=upg_registry
  File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 214, in load_module_graph
    migrations.migrate_module(package, 'post')
  File "/home/odoo/OpenUpgrade/openerp/modules/migration.py", line 170, in migrate_module
    mod.migrate(self.cr, installed_version)
  File "/usr/local/lib/python2.7/dist-packages/openupgradelib/openupgrade.py", line 1876, in wrapped_function
    if use_env2 else cr, version)
  File "/home/odoo/OpenUpgrade/addons/mail/migrations/9.0.1.0/post-migration.py", line 198, in migrate
    """
  File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 154, in wrapper
    return f(self, *args, **kwargs)
  File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 233, in execute
    res = self._obj.execute(query, params)
IntegrityError: llave duplicada viola restricción de unicidad «mail_followers_mail_followers_res_channel_res_model_id_uniq»
DETALLE:  Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801).

2021-08-04 10:03:42,023 6565 CRITICAL ddt8 openerp.service.server: Failed to initialize database `ddt8`.
Traceback (most recent call last):
  File "/home/odoo/OpenUpgrade/openerp/service/server.py", line 894, in preload_registries
    registry = RegistryManager.new(dbname, update_module=update_module)
  File "/home/odoo/OpenUpgrade/openerp/modules/registry.py", line 390, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 446, in load_modules
    force, status, report, loaded_modules, update_module, models_to_check, upg_registry)
  File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 331, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check, upg_registry=upg_registry
  File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 214, in load_module_graph
    migrations.migrate_module(package, 'post')
  File "/home/odoo/OpenUpgrade/openerp/modules/migration.py", line 170, in migrate_module
    mod.migrate(self.cr, installed_version)
  File "/usr/local/lib/python2.7/dist-packages/openupgradelib/openupgrade.py", line 1876, in wrapped_function
    if use_env2 else cr, version)
  File "/home/odoo/OpenUpgrade/addons/mail/migrations/9.0.1.0/post-migration.py", line 198, in migrate
    """
  File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 154, in wrapper
    return f(self, *args, **kwargs)
  File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 233, in execute
    res = self._obj.execute(query, params)
IntegrityError: llave duplicada viola restricción de unicidad «mail_followers_mail_followers_res_channel_res_model_id_uniq»
DETALLE:  Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801).

Como consecuencia, todos los registros antiguos han perdido los seguidores del muro, no es crítico ni urgente.

dejo la traza del error para que no se pierda: ``` 2021-08-04 10:03:42,017 6565 INFO ddt8 openerp.sql_db: bad query: INSERT INTO mail_followers ( res_id, channel_id, res_model ) SELECT id, id, 'mail.channel' FROM mail_channel WHERE channel_type = 'channel' 2021-08-04 10:03:42,017 6565 ERROR ddt8 OpenUpgrade: mail: error in migration script mail/migrations/9.0.1.0/post-migration.py: IntegrityError('llave duplicada viola restricci\xc3\xb3n de unicidad \xc2\xabmail_followers_mail_followers_res_channel_res_model_id_uniq\xc2\xbb\nDETALLE: Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801).\n',) 2021-08-04 10:03:42,017 6565 ERROR ddt8 OpenUpgrade: llave duplicada viola restricción de unicidad «mail_followers_mail_followers_res_channel_res_model_id_uniq» DETALLE: Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801). Traceback (most recent call last): File "/usr/local/lib/python2.7/dist-packages/openupgradelib/openupgrade.py", line 1876, in wrapped_function if use_env2 else cr, version) File "/home/odoo/OpenUpgrade/addons/mail/migrations/9.0.1.0/post-migration.py", line 198, in migrate """ File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 154, in wrapper return f(self, *args, **kwargs) File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 233, in execute res = self._obj.execute(query, params) IntegrityError: llave duplicada viola restricción de unicidad «mail_followers_mail_followers_res_channel_res_model_id_uniq» DETALLE: Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801). Traceback (most recent call last): File "/usr/lib/python2.7/logging/__init__.py", line 859, in emit msg = self.format(record) File "/usr/lib/python2.7/logging/__init__.py", line 732, in format return fmt.format(record) File "/home/odoo/OpenUpgrade/openerp/netsvc.py", line 108, in format return DBFormatter.format(self, record) File "/home/odoo/OpenUpgrade/openerp/netsvc.py", line 102, in format return logging.Formatter.format(self, record) File "/usr/lib/python2.7/logging/__init__.py", line 471, in format record.message = record.getMessage() File "/usr/lib/python2.7/logging/__init__.py", line 335, in getMessage msg = msg % self.args UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 31: ordinal not in range(128) Logged from file loading.py, line 217 2021-08-04 10:03:42,023 6565 ERROR ddt8 openerp.modules.registry: Failed to load registry Traceback (most recent call last): File "/home/odoo/OpenUpgrade/openerp/modules/registry.py", line 390, in new openerp.modules.load_modules(registry._db, force_demo, status, update_module) File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 446, in load_modules force, status, report, loaded_modules, update_module, models_to_check, upg_registry) File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 331, in load_marked_modules perform_checks=perform_checks, models_to_check=models_to_check, upg_registry=upg_registry File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 214, in load_module_graph migrations.migrate_module(package, 'post') File "/home/odoo/OpenUpgrade/openerp/modules/migration.py", line 170, in migrate_module mod.migrate(self.cr, installed_version) File "/usr/local/lib/python2.7/dist-packages/openupgradelib/openupgrade.py", line 1876, in wrapped_function if use_env2 else cr, version) File "/home/odoo/OpenUpgrade/addons/mail/migrations/9.0.1.0/post-migration.py", line 198, in migrate """ File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 154, in wrapper return f(self, *args, **kwargs) File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 233, in execute res = self._obj.execute(query, params) IntegrityError: llave duplicada viola restricción de unicidad «mail_followers_mail_followers_res_channel_res_model_id_uniq» DETALLE: Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801). 2021-08-04 10:03:42,023 6565 CRITICAL ddt8 openerp.service.server: Failed to initialize database `ddt8`. Traceback (most recent call last): File "/home/odoo/OpenUpgrade/openerp/service/server.py", line 894, in preload_registries registry = RegistryManager.new(dbname, update_module=update_module) File "/home/odoo/OpenUpgrade/openerp/modules/registry.py", line 390, in new openerp.modules.load_modules(registry._db, force_demo, status, update_module) File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 446, in load_modules force, status, report, loaded_modules, update_module, models_to_check, upg_registry) File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 331, in load_marked_modules perform_checks=perform_checks, models_to_check=models_to_check, upg_registry=upg_registry File "/home/odoo/OpenUpgrade/openerp/modules/loading.py", line 214, in load_module_graph migrations.migrate_module(package, 'post') File "/home/odoo/OpenUpgrade/openerp/modules/migration.py", line 170, in migrate_module mod.migrate(self.cr, installed_version) File "/usr/local/lib/python2.7/dist-packages/openupgradelib/openupgrade.py", line 1876, in wrapped_function if use_env2 else cr, version) File "/home/odoo/OpenUpgrade/addons/mail/migrations/9.0.1.0/post-migration.py", line 198, in migrate """ File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 154, in wrapper return f(self, *args, **kwargs) File "/home/odoo/OpenUpgrade/openerp/sql_db.py", line 233, in execute res = self._obj.execute(query, params) IntegrityError: llave duplicada viola restricción de unicidad «mail_followers_mail_followers_res_channel_res_model_id_uniq» DETALLE: Ya existe la llave (res_model, res_id, channel_id)=(mail.channel, 9801, 9801). ``` Como consecuencia, todos los registros antiguos han perdido los seguidores del muro, no es crítico ni urgente.

snt closed this issue

2025-05-08 12:39:33 +00:00