Error on introspection - Error during processing:(sqlite3.OperationalError) no such column in Red Hat OpenStack Platform

Solution In Progress - Updated -

Issue

After an upgrade from OSP 8 to OSP 9, openstack baremeteal introspection status yields the following error message:

    [stack@undercloud rh]$ openstack baremetal introspection status
    b8dba4df-3987-4942-82ab-adf7337072eb
    +----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Field | Value

    |
    +----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
    | error | Unexpected exception OperationalError during processing:
    (sqlite3.OperationalError) no such column: rule_conditions_1.invert
    [SQL: u'SELECT rules.uuid AS |
    | | rules_uuid, rules.created_at AS rules_created_at,
    rules.description AS rules_description, rules.disabled AS
    rules_disabled, rule_conditions_1.id AS |
    | | rule_conditions_1_id, rule_conditions_1.rule AS
    rule_conditions_1_rule, rule_conditions_1.op AS rule_conditions_1_op,
    rule_conditions_1.multiple AS |
    | | rule_conditions_1_multiple, rule_conditions_1.invert AS
    rule_conditions_1_invert, rule_conditions_1.field AS
    rule_conditions_1_field, |
    | | rule_conditions_1.params AS rule_conditions_1_params,
    rule_actions_1.id AS rule_actions_1_id, rule_actions_1.rule AS
    rule_actions_1_rule, |
    | | rule_actions_1.action AS rule_actions_1_action,
    rule_actions_1.params AS rule_actions_1_params \nFROM rules LEFT OUTER
    JOIN rule_conditions AS |
    | | rule_conditions_1 ON rules.uuid = rule_conditions_1.rule
    LEFT OUTER JOIN rule_actions AS rule_actions_1 ON rules.uuid =
    rule_actions_1.rule ORDER BY |
    | | rules.created_at, rule_conditions_1.id,
    rule_actions_1.id']
    |
    | finished | True

    |
    +----------+------------------------------------------------------------------------------------------------------------------------------

Environment

Red Hat OpenStack Platform 9.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.