[SRU] barbican-manage db upgrade fails with MySQL8
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ubuntu Cloud Archive |
Invalid
|
Undecided
|
Unassigned | ||
Ussuri |
Fix Released
|
Undecided
|
Unassigned | ||
Victoria |
Fix Released
|
Undecided
|
Unassigned | ||
barbican (Ubuntu) |
Fix Released
|
Critical
|
Chris MacNaughton | ||
Focal |
Fix Released
|
Critical
|
Chris MacNaughton | ||
Groovy |
Fix Released
|
Critical
|
Chris MacNaughton |
Bug Description
[Impact]
New installations of OpenStack Barbican with Mysql8 fail with a traceback when trying to initialize the database
[Test Case]
Use the OpenStack charms to deploy Barbican on Ubuntu Focal. Using Focal is expected to have a traceback and with this change is expected to setup successfully.
[Regression Potential]
The regression potential for this is minimal as the package currently does not work at all with mysql8 which ships with Ubuntu Focal.
The proposed change is a cherry-pick from upstream that resolves this issue by rebasing the old migrations into a single larger migration. This
only affects new deploys that would normally step through all of the old
migrations so shouldn't affect running deploys.
-------
Running
barbican-manage db upgrade fails with the following traceback when the DB is mysql8:
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
ERROR: (pymysql.
[SQL: ALTER TABLE secret_acls CHANGE creator_only project_access BOOL NULL]
Seems this is a known issue with alembic [0]
Changed in barbican (Ubuntu Focal): | |
assignee: | nobody → Chris MacNaughton (chris.macnaughton) |
Changed in barbican (Ubuntu Groovy): | |
assignee: | nobody → Chris MacNaughton (chris.macnaughton) |
summary: |
- barbican-manage db upgrade fails with MySQL8 + [SRU] barbican-manage db upgrade fails with MySQL8 |
description: | updated |
Changed in cloud-archive: | |
status: | New → Fix Committed |
status: | Fix Committed → Invalid |
It looks like this is fixed upstream so we may just need to get this into the focal package. https:/ /storyboard. openstack. org/#!/ story/2007732