← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1744948] Re: allow_application_credential_creation contraint issue with suse + mariadb 10.2

 

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.murphy@xxxxxxx>
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


References