Archives
Contributors
Travis logs full of "INFO openerp_test odoo.schema: Keep unexpected index"
Hello contributors,
--
some examples among many:
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_data10242021-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_data10252021-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_data10262021-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_data10272021-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_data10282021-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
A) OCA/product-attribute (3 days ago): https://app.travis-ci.com/github/OCA/product-attribute/jobs/532742269
The strange logs are there but the build is still successful.
B) OCA/l10n-brazil (a few hours ago): https://app.travis-ci.com/github/OCA/l10n-brazil/jobs/533085576
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
Follow-Ups
-
Re: Travis logs full of "INFO openerp_test odoo.schema: Keep unexpected index"
Wow! fx from Sébastien Alix already coming in Odoo https://github.com/odoo/odoo/pull/75387On Mon, Aug 23, 2021 at 1:02 AM Raphaël Valyi <rvalyi@akretion.com> wrote:Hello contributors,So here is the temporary workaround I'm proposing in .travis.yml. At least it works for us in OCA/l10n-brazil: https://github.com/OCA/l10n-brazil/pull/1587/commits/d43e0eb3329a8116628259a1b6f5ec556e59efb5It basically just cd into the repo dir and reverts the commit.Example of build fixed https://app.travis-ci.com/github/OCA/l10n-brazil/builds/235949881I think I already used my quota :-p to bother Odoo SA about the pŕoblem created by this commit, so if somebody has got some good contact with the Odoo devs and can do the escalation dance thing to report them...Regards.On Sun, Aug 22, 2021 at 5:27 PM Raphaël Valyi <rvalyi@akretion.com> wrote:Hello Olaf,Okay so you found it: the "Keep unexpected index" comes from these recent Odoo changes indeed. In v12.0, the commit was made on June 4:https://github.com/odoo/odoo/commit/13f02a60c8706b808a57535ac9648a1b0c0741a9and the same day for OCB:I didn't have it in my source and it wasn't indexed in odoo/odoo that's why I didn't find it with grep.Now In Github it seems these commits are from June 4 and this is also why I didn't suspect this as we have builds much later than this date passing normally.But looking in this page it's actually clear that it was pushed by Robodoo 3 days ago:(in v13 and v14 here https://github.com/odoo/odoo/pull/66700 )So now I guess we should work on 2 fronts:- do the Odoo SA Github dance to tell Odoo SA their commit creates problems. But this could take months before being heard (I'm optimistic)...
- hack a palliative fix in Travis to avoid blocking the PR's in the meantime. I'll try that for now and update you.
On Sun, Aug 22, 2021 at 3:22 PM Olaf Wagner <wagner@elegosoft.com> wrote: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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Raphaël ValyiFounder and consultant--Raphaël ValyiFounder and consultant_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Raphaël ValyiFounder and consultant
by "Raphaël Valyi" <rvalyi@akretion.com> - 05:40 - 23 Aug 2021 -
Re: Travis logs full of "INFO openerp_test odoo.schema: Keep unexpected index"
Hello contributors,So here is the temporary workaround I'm proposing in .travis.yml. At least it works for us in OCA/l10n-brazil: https://github.com/OCA/l10n-brazil/pull/1587/commits/d43e0eb3329a8116628259a1b6f5ec556e59efb5It basically just cd into the repo dir and reverts the commit.Example of build fixed https://app.travis-ci.com/github/OCA/l10n-brazil/builds/235949881I think I already used my quota :-p to bother Odoo SA about the pŕoblem created by this commit, so if somebody has got some good contact with the Odoo devs and can do the escalation dance thing to report them...Regards.On Sun, Aug 22, 2021 at 5:27 PM Raphaël Valyi <rvalyi@akretion.com> wrote:Hello Olaf,Okay so you found it: the "Keep unexpected index" comes from these recent Odoo changes indeed. In v12.0, the commit was made on June 4:https://github.com/odoo/odoo/commit/13f02a60c8706b808a57535ac9648a1b0c0741a9and the same day for OCB:I didn't have it in my source and it wasn't indexed in odoo/odoo that's why I didn't find it with grep.Now In Github it seems these commits are from June 4 and this is also why I didn't suspect this as we have builds much later than this date passing normally.But looking in this page it's actually clear that it was pushed by Robodoo 3 days ago:(in v13 and v14 here https://github.com/odoo/odoo/pull/66700 )So now I guess we should work on 2 fronts:- do the Odoo SA Github dance to tell Odoo SA their commit creates problems. But this could take months before being heard (I'm optimistic)...
- hack a palliative fix in Travis to avoid blocking the PR's in the meantime. I'll try that for now and update you.
On Sun, Aug 22, 2021 at 3:22 PM Olaf Wagner <wagner@elegosoft.com> wrote: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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Raphaël ValyiFounder and consultant--Raphaël ValyiFounder and consultant
by "Raphaël Valyi" <rvalyi@akretion.com> - 06:01 - 23 Aug 2021 -
Re: Travis logs full of "INFO openerp_test odoo.schema: Keep unexpected index"
Hello Olaf,Okay so you found it: the "Keep unexpected index" comes from these recent Odoo changes indeed. In v12.0, the commit was made on June 4:https://github.com/odoo/odoo/commit/13f02a60c8706b808a57535ac9648a1b0c0741a9and the same day for OCB:I didn't have it in my source and it wasn't indexed in odoo/odoo that's why I didn't find it with grep.Now In Github it seems these commits are from June 4 and this is also why I didn't suspect this as we have builds much later than this date passing normally.But looking in this page it's actually clear that it was pushed by Robodoo 3 days ago:(in v13 and v14 here https://github.com/odoo/odoo/pull/66700 )So now I guess we should work on 2 fronts:- do the Odoo SA Github dance to tell Odoo SA their commit creates problems. But this could take months before being heard (I'm optimistic)...
- hack a palliative fix in Travis to avoid blocking the PR's in the meantime. I'll try that for now and update you.
On Sun, Aug 22, 2021 at 3:22 PM Olaf Wagner <wagner@elegosoft.com> wrote: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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
--Raphaël ValyiFounder and consultant
by "Raphaël Valyi" <rvalyi@akretion.com> - 10:31 - 22 Aug 2021 -
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