Skip to Content

Contributors

Re: Travis logs full of "INFO openerp_test odoo.schema: Keep unexpected index"

On 22 Aug 2021, at 18:52, Raphaël Valyi wrote:


> Hello contributors,

> since 2 or 3 days ago max, on several OCA 12.0 builds one can see logs 

> full of "Keep unexpected index" log messages such as:

> 2021-08-22 13:29:16,607 7203  INFO  openerp_template odoo.schema: Keep 

> unexpected index ir_model_data_date_update_index on table 

> ir_model_data   1024 2021-08-22 13:29:16,607 7203  INFO  

> openerp_template odoo.schema: Keep unexpected index 

> ir_model_data_date_init_index on table ir_model_data   1025 2021-08-22 

> 13:29:16,608 7203  INFO  openerp_template odoo.schema: Keep unexpected 

> index ir_model_data_create_uid_index on table ir_model_data   1026 

> 2021-08-22 13:29:16,608 7203  INFO  openerp_template odoo.schema: Keep 

> unexpected index ir_model_data_create_date_index on table 

> ir_model_data   1027 2021-08-22 13:29:16,608 7203  INFO  

> openerp_template odoo.schema: Keep unexpected index 

> ir_model_data_write_uid_index on table ir_model_data   1028 2021-08-22 

> 13:29:16,608 7203  INFO  openerp_template odoo.schema: Keep unexpected 

> index ir_model_data_write_date_index on table ir_model_data

It’s from this change in the ORM:
- 
https://github.com/odoo/odoo/commit/13f02a60c8706b808a57535ac9648a1b0c0741a9
- 
https://github.com/odoo/odoo/commit/b4647cbf1e483bcc42ff9962851f94c751e5eebb

Must have been merged recently.

I’ve encountered it in 13.0 and have disabled it locally as it was 
spamming our
logs, too.

Olaf

-- 
Olaf Wagner -- elego Software Solutions GmbH -- http://www.elegosoft.com
                Gustav-Meyer-Allee 25 / Gebäude 12, 13355 Berlin, 
Germany
Geschäftsführer: Olaf Wagner | Sitz: Berlin
Handelregister: Amtsgericht Charlottenburg HRB 77719 | USt-IdNr: 
DE163214194

by Olaf Wagner - 08:20 - 22 Aug 2021

Reference

  • Travis logs full of "INFO openerp_test odoo.schema: Keep unexpected index"
    Hello contributors,

    since 2 or 3 days ago max, on several OCA 12.0 builds one can see logs full of "Keep unexpected index" log messages such as:

    2021-08-22 13:29:16,607 7203 INFO openerp_template odoo.schema: Keep unexpected index ir_model_data_date_update_index on table ir_model_data
    10242021-08-22 13:29:16,607 7203 INFO openerp_template odoo.schema: Keep unexpected index ir_model_data_date_init_index on table ir_model_data
    10252021-08-22 13:29:16,608 7203 INFO openerp_template odoo.schema: Keep unexpected index ir_model_data_create_uid_index on table ir_model_data
    10262021-08-22 13:29:16,608 7203 INFO openerp_template odoo.schema: Keep unexpected index ir_model_data_create_date_index on table ir_model_data
    10272021-08-22 13:29:16,608 7203 INFO openerp_template odoo.schema: Keep unexpected index ir_model_data_write_uid_index on table ir_model_data
    10282021-08-22 13:29:16,608 7203 INFO openerp_template odoo.schema: Keep unexpected index ir_model_data_write_date_index on table ir_model_data

    --

    some examples among many:

    The strange logs are there but the build is still successful.

    The problem is that these "unexepected index" messages make the logs so verbose that the test job is killed because we are exhausting the log length quota in repos with lots of tests like OCA/l10n-brazil:
    "The job exceeded the maximum log length, and has been terminated."

    I can see no recent change in the Odoo 12.0 branch nor OCA/maintainer-quality-tools that could explain such changes. Seems there is no psycopg update either.

    Any idea how to fix this? This is blocking lot's of PR in repos such as OCA/l10n-brazil but I'm sure other repos will soon be blocked too.

    Best regards. 


    Raphaël Valyi
    Founder and consultant


    by "Raphaël Valyi" <rvalyi@akretion.com> - 06:50 - 22 Aug 2021