Public bug reported: 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/ ** Affects: keystone Importance: Undecided Status: New -- 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): New 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
