CriptoMart/obook
2
0
Fork 0
Code Issues Pull requests Releases Wiki Activity

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
Copy link

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
Copy link

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
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
12.0
16.0
14.0
13.0
master
No results found.
Labels
Clear labels   
bug

Something is not working

  
duplicate

This issue or pull request already exists

  
enhancement

New feature

  
help wanted

Need some help

  
invalid

Something is wrong

  
question

More information is needed

  
wontfix

This won't be fixed

No labels
bug
duplicate
enhancement
help wanted
invalid
question
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
snt
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: CriptoMart/obook#7
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?