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