Error on introspection - Error during processing:(sqlite3.OperationalError) no such column in Red Hat OpenStack Platform
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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
