[BUG] [17.0] Error messages on Odoo logs

[jabelchi]

Module

bi_sql_editor

Describe the bug

On Odoo start, a number of errors are recorded on the log. However, the module seems to work properly.

To Reproduce

Tested in 17.0:

Steps to reproduce the behavior:

1. Reboot Odoo
2. Read the logs.
   Examples of messages recorded:
   2025-10-20 16:18:15,271 24396 INFO (database-name) odoo.addons.base.models.ir_model: Model 'x_bi_sql_view.ord_cancel' is backed by table 'x_bi_sql_view_ord_cancel' which is not a regular table (<TableKind.View: 'v'>), disabling automatic schema management
   2025-10-20 16:18:15,272 24396 INFO (database-name) odoo.addons.base.models.ir_model: Model 'x_bi_sql_view.pnd_srv_tsk_clsd' is backed by table 'x_bi_sql_view_pnd_srv_tsk_clsd' which is not a regular table (<TableKind.View: 'v'>), disabling automatic schema management
   2025-10-20 16:18:15,273 24396 INFO (database-name) odoo.addons.base.models.ir_model: Model 'x_bi_sql_view.projectes' is backed by table 'x_bi_sql_view_projectes' which is not a regular table (<TableKind.Materialized: 'm'>), disabling automatic schema management

Expected behavior
If everything is fine, no log errors need to be recorded.

[gdgellatly]

Those are not errors, they are info logs. However yes they are annoying.

@legalsylvain what do you think of something like this for bi sql editor? We currently use this as a server wide module.

import logging


class _SuppressNonRegularTableFilter(logging.Filter):
    """Suppress "not a regular table, disabling automatic schema management"
    info logs.
    """

    def filter(self, record):
        try:
            msg = record.getMessage()
        except Exception:
            return True
        if (
            "is not a regular table" in msg
            and "disabling automatic schema management" in msg
        ):
            return False
        return True


class _SuppressKeepUnexpectedIndexFilter(logging.Filter):
    """Suppress "Keep unexpected index ... on table ..." info logs from odoo.schema."""

    def filter(self, record):
        try:
            msg = record.getMessage()
        except Exception:
            return True
        if "Keep unexpected index" in msg and " on table " in msg:
            return False
        return True


def install():
    """Install log filters to suppress known noisy messages."""
    ir_model_logger = logging.getLogger("odoo.addons.base.models.ir_model")
    if not any(
        isinstance(f, _SuppressNonRegularTableFilter) for f in ir_model_logger.filters
    ):
        ir_model_logger.addFilter(_SuppressNonRegularTableFilter())

    schema_logger = logging.getLogger("odoo.schema")
    if not any(
        isinstance(f, _SuppressKeepUnexpectedIndexFilter) for f in schema_logger.filters
    ):
        schema_logger.addFilter(_SuppressKeepUnexpectedIndexFilter())

sorry just the table filter.

[legalsylvain]

Why not create a dedicated OCA module with that code ?

[github-actions]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.