Skip to content

[13.0] queue_job: error when upgrade base #227

Closed

Description

@abdallamohamedcore

Hello
I have issue appear when i try to upgrade base if module queue_job is installed as below

2020-05-18 08:38:47,937 101 INFO migration-database-mig-test-1102394 odoo.addons.base.models.ir_model: Deleting 1906@ir.model.fields.selection (base.selection__ir_model_fields__ttype__job_serialized) 
2020-05-18 08:38:47,940 101 ERROR migration-database-mig-test-1102394 odoo.sql_db: bad query: UPDATE "ir_model_fields" SET "ttype"=NULL WHERE "ttype"='job_serialized'
ERROR: null value in column "ttype" violates not-null constraint
DETAIL:  Failing row contains (10232, kwargs, null, queue.job, null, null, null, 508, Kwargs, null, null, t, null, null, f, t, f, f, null, base, null, null, t, null, null, null, null, null, t, null, null, 1, 2019-08-08 20:09:28.850875, null, null, t, null).
 
2020-05-18 08:38:47,946 101 WARNING migration-database-mig-test-1102394 odoo.modules.loading: Transient module states were reset 
2020-05-18 08:38:47,947 101 ERROR migration-database-mig-test-1102394 odoo.modules.registry: Failed to load registry 
Traceback (most recent call last):
  File "/home/odoo/src/odoo/odoo/modules/registry.py", line 86, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/home/odoo/src/odoo/odoo/modules/loading.py", line 472, in load_modules
    env['ir.model.data']._process_end(processed_modules)
  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_model.py", line 1986, in _process_end
    record.unlink()
  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_model.py", line 1208, in unlink
    self.env.cr.execute(query, [selection.value])
  File "/home/odoo/src/odoo/odoo/sql_db.py", line 164, in wrapper
    return f(self, *args, **kwargs)
  File "/home/odoo/src/odoo/odoo/sql_db.py", line 241, in execute
    res = self._obj.execute(query, params)
psycopg2.IntegrityError: null value in column "ttype" violates not-null constraint
DETAIL:  Failing row contains (10232, kwargs, null, queue.job, null, null, null, 508, Kwargs, null, null, t, null, null, f, t, f, f, null, base, null, null, t, null, null, null, null, null, t, null, null, 1, 2019-08-08 20:09:28.850875, null, null, t, null).

Activity

  1. guewen commented on May 19, 2020

    @guewen
    Member

    Hello,

    I could not reproduce it on my end by installing queue_job, then upgrading base.
    Do you have steps to reproduce?

  2. guewen commented on Aug 11, 2020

    @guewen
    Member

    I had the same error in a build. A correction is coming.

    2020-08-11 13:10:51,932 167 INFO sample odoo.modules.loading: 297 modules loaded in 529.51s, 0 queries
    2020-08-11 13:10:53,159 167 INFO sample odoo.addons.base.models.ir_model: Deleting 4@ir.model.fields.selection (base.selection__ir_model_fields__ttype__job_serialized)
    2020-08-11 13:10:53,163 167 ERROR sample odoo.sql_db: bad query: UPDATE "ir_model_fields" SET "ttype"=NULL WHERE "ttype"='job_serialized'
    ERROR: null value in column "ttype" violates not-null constraint
    DETAIL:  Failing row contains (4296, record_ids, null, queue.job, null, null, null, 266, Record, null, null, t, null, null, f, t, f, f, null, base, null, null, t, null, null, null, null, null, t, null, null, 1, 2020-08-11 13:03:09.913127, null, null).
    
    2020-08-11 13:10:53,168 167 WARNING sample odoo.modules.loading: Transient module states were reset
    2020-08-11 13:10:53,170 167 ERROR sample odoo.modules.registry: Failed to load registry
    Traceback (most recent call last):
      File "/odoo/src/odoo/modules/registry.py", line 86, in new
        odoo.modules.load_modules(registry._db, force_demo, status, update_module)
      File "/odoo/src/odoo/modules/loading.py", line 472, in load_modules
        env['ir.model.data']._process_end(processed_modules)
      File "/odoo/src/odoo/addons/base/models/ir_model.py", line 1990, in _process_end
        record.unlink()
      File "/odoo/src/odoo/addons/base/models/ir_model.py", line 1208, in unlink
        self.env.cr.execute(query, [selection.value])
      File "/odoo/src/odoo/sql_db.py", line 168, in wrapper
        return f(self, *args, **kwargs)
      File "/odoo/src/odoo/sql_db.py", line 245, in execute
        res = self._obj.execute(query, params)
    psycopg2.IntegrityError: null value in column "ttype" violates not-null constraint
    DETAIL:  Failing row contains (4296, record_ids, null, queue.job, null, null, null, 266, Record, null, null, t, null, null, f, t, f, f, null, base, null, null, t, null, null, null, null, null, t, null, null, 1, 2020-08-11 13:03:09.913127, null, null).
    
  3. guewen commented on Aug 11, 2020

    @guewen
    Member

    @abdallamohamedcore did you encounter this with Odoo 13.0 or a more ancient version?

  4. added 2 commits that reference this issue on Aug 11, 2020
    4aa2496
    b6fb951
  5. added a commit that references this issue on Oct 16, 2020
    6d38201
  6. added a commit that references this issue on Apr 19, 2021
    68bf8ea
  7. added a commit that references this issue on Oct 25, 2021
    9e47403
  8. added 2 commits that reference this issue on Nov 23, 2023
    ede4d98
    78e73b7
  9. added a commit that references this issue on Nov 25, 2023
    9f569a8
  10. added 2 commits that reference this issue on Sep 19, 2024
    f98f5e8
    f142c1e
  11. added a commit that references this issue on Oct 7, 2024
    50208fa
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions