AppArmor Config Status column has incorrect migration version
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
StarlingX |
Fix Released
|
Medium
|
Jagatguru Prasad Mishra |
Bug Description
Brief Description
-----------------
During upgrade migrations are run using sysinv-dbsync.
There is a new column i_host.
The migration for this new column was added to https:/
However, the migration version of the system is already at 127. So the column never gets created.
sysinv=# select * from migrate_version;
repository_id | repository_path | version
-------
sysinv | /usr/lib64/
(1 row)
Severity
-----------------
Critical
Steps to Reproduce
-----------------
AIO-SX upgrade from stx6 to stx8 to stx9
Expected Behavior
-----------------
Migration works
Actual Behavior
-----------------
Migration does not work
Reproducibility
-----------------
100%
System Configuration
-----------------
AIO-SX
Example:
Load info (eg: 2022-03-
2022-12-06
Last Pass
N/A
Timestamp/Logs
sysadmin@
sysinv 2023-12-06 20:56:40.945 10711 INFO sysinv.cmd.upgrade [-] Called 'update_
sysinv 2023-12-06 20:56:40.946 10711 INFO sysinv.cmd.upgrade [-] Updating upgrades data in sysinv database
sysinv 2023-12-06 20:56:45.440 10711 WARNING oslo_config.cfg [-] Deprecated: Option "sql_connection" from group "DEFAULT" is deprecated. Use option "connection" from group "database".
sysinv 2023-12-06 20:56:45.442 10711 WARNING oslo_db.
sysinv 2023-12-06 20:56:45.610 10711 WARNING oslo_db.
LINE 1: ...onfig_target, i_host.apparmor AS i_host_apparmor, i_host.app...
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
2023-12-06 20:56:45.610 10711 ERROR oslo_db.
sysinv 2023-12-06 20:56:45.612 10711 CRITICAL sysinv [-] Unhandled error: oslo_db.
LINE 1: ...onfig_target, i_host.apparmor AS i_host_apparmor, i_host.app...
sysadmin@
apparmor | character varying(64) | | |
sysadmin@
sysinv 2023-12-06 21:19:13.035 12269 WARNING oslo_config.cfg [-] Deprecated: Option "sql_connection" from group "DEFAULT" is deprecated. Use option "connection" from group "database".
sysinv 2023-12-06 21:19:13.036 12269 WARNING oslo_db.
sysadmin@
apparmor | character varying(64) | | |
Alarms
N/A
Test Activity
-----------------
Developer Testing
Workaround
-----------------
Move new column into new version file so it can be migrated.
Changed in starlingx: | |
importance: | Undecided → Medium |
assignee: | nobody → Jagatguru Prasad Mishra (jmishra) |
summary: |
- Incorrect migration version for AppArmor Config Status column in i_host + AppArmor Config Status column has incorrect migration version |
tags: | added: stx.9.0 stx.update |
Fix proposed to branch: master /review. opendev. org/c/starlingx /config/ +/903170
Review: https:/