yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1186353] Re: Drop Credentials constraint migration does not specify schema

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Wed, 17 Jul 2013 12:06:40 -0000
Reply-to: Bug 1186353 <1186353@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Changed in: keystone
       Status: Fix Committed => Fix Released

** Changed in: keystone
    Milestone: None => havana-2

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1186353

Title:
  Drop Credentials constraint  migration does not specify schema

Status in OpenStack Identity (Keystone):
  Fix Released

Bug description:
  THe SQL executed for the Mysql drop contraint  is

  select CONSTRAINT_NAME from "
                      "INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS "
                      "where table_name = 'credential'

  
  However, if there are multipl databases which each have a constraints table, this will select all of the constraints for all of the tables.  THe query needs to be scoped in by the name of the schema:

  So an additional CONSTRAINT_SCHEMA = `keystone`  needs to be in the
  SQL (assuming the database name is keystone).

  
  This just causes the migration to fail, but does not otherwise negatively effect the database.

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1186353/+subscriptions