yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

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

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

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

Title:
  Credential table in the backed still has foreign key reference to id
  column in tenant table (which is dropped).

Status in OpenStack Identity (Keystone):
  Fix Released

Bug description:
  Credential table in the backed still has foreign key reference to id
  column in tenant table

  sqlite> .schema credential
  CREATE TABLE credential (
  	id VARCHAR(64) NOT NULL, 
  	user_id VARCHAR(64) NOT NULL, 
  	project_id VARCHAR(64), 
  	blob TEXT NOT NULL, 
  	type VARCHAR(255) NOT NULL, 
  	extra TEXT, 
  	PRIMARY KEY (id), 
  	FOREIGN KEY(user_id) REFERENCES user (id), 
  	FOREIGN KEY(project_id) REFERENCES tenant (id)
  );

  There is a bug in the sql migration code where we drop the foreign key constraint.
  https://github.com/openstack/keystone/blob/master/keystone/common/sql/migrate_repo/versions/023_drop_credential_constraints.py

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