Reviewed: https://review.openstack.org/536869
Committed:
https://git.openstack.org/cgit/openstack/keystone/commit/?id=59b1aacdbaba72df62167793ea2b3ed2ba5b303f
Submitter: Zuul
Branch: master
commit 59b1aacdbaba72df62167793ea2b3ed2ba5b303f
Author: Colleen Murphy <colleen.mur...@suse.de>
Date: Tue Jan 23 16:36:15 2018 +0100
Fix column rename migration for mariadb 10.2
MariaDB 10.2 introduced an issue where an automatic check constraint is
applied to boolean columns and is not automatically updated on a column
rename alter operation[1]. A similar issue preventing dropping such a
column was already fixed[2], so this patch changes the migration to drop
and readd the column instead of attempting a column rename.
Unfortunately since the mistake was already made, it is possible for
deployments out in the wild to have made it past the expand step and be
currently stuck in the contract step. To accomodate them, we add the new
column as part of the contract step if necessary. Again, since there
should be no data in this table, we don't need to worry about online
upgrades here.
[1] https://jira.mariadb.org/browse/MDEV-13508
[2] https://jira.mariadb.org/browse/MDEV-11114
Change-Id: Icbd58464182b082854fb5d73ccc93c900ede020c
Closes-bug: #1744948
** Changed in: keystone
Status: In Progress => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1744948
Title:
allow_application_credential_creation contraint issue with suse +
mariadb 10.2
Status in OpenStack Identity (keystone):
Fix Released
Status in openstack-ansible:
In Progress
Bug description:
In master, a problem seem to have appeared recently.
In our tests, we run the following task [1], running a db_sync --contract.
That task runs the same for centos, ubuntu, and suse.
However on SUSE (maybe a different version of mysql is packaged, I have to
check) I get the following issue [2]: Unknown column
'allow_application_credential_creation' in 'CHECK'"
Checking what's happening on that db I can see on SUSE there is well a
CHECK constraint on the table [3], that's not present after the whole
process on ubuntu [4].
So long story short: Constraint problem prevents renaming the column +
distro packaging bug?
[1]:
http://logs.openstack.org/90/535790/2/check/openstack-ansible-functional-opensuse-423/5d2b02e/job-output.txt.gz#_2018-01-23_11_35_03_934688
[2]: http://paste.openstack.org/show/650942/
[3]: http://paste.openstack.org/show/650965/
[4]: http://paste.openstack.org/show/650967/
To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1744948/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
