** Also affects: keystone/juno
Importance: Undecided
Status: New
** Changed in: keystone/juno
Importance: Undecided => High
** Changed in: keystone/juno
Assignee: (unassigned) => Steve Martinelli (stevemar)
** Changed in: keystone/juno
Status: New => In Progress
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1399768
Title:
migration of endpoint_filter fails due to foreign key constraint
Status in OpenStack Identity (Keystone):
Fix Committed
Status in Keystone juno series:
In Progress
Bug description:
keystone-manage db_sync --extension endpoint_filter 2
fails with
2014-12-05 13:54:39.295 11241 TRACE keystone OperationalError:
(OperationalError) (1005, "Can't create table 'keystone.project_endpoint_group'
(errno: 150)") '\nCREATE TABLE project_endpoint_group (\n\tendpoint_group_id
VARCHAR(64) NOT NULL, \n\tproject_id VARCHAR(64) NOT NULL, \n\tPRIMARY KEY
(endpoint_group_id, project_id), \n\tFOREIGN KEY(endpoint_group_id) REFERENCES
endpoint_group (id)\n)\n\n' ()
Migration 1 fails executing the below sql.
CREATE TABLE project_endpoint_group (endpoint_group_id VARCHAR(64) NOT NULL,
project_id VARCHAR(64) NOT NULL, PRIMARY KEY (endpoint_group_id, project_id),
FOREIGN KEY(endpoint_group_id) REFERENCES endpoint_group (id));
ERROR 1005 (HY000): Can't create table 'keystone.project_endpoint_group'
(errno: 150)
Removing the clause FOREIGN KEY(endpoint_group_id) REFERENCES
endpoint_group (id)) makes it work.
THis is on Fedora 20 and I mariadb flavor of MySQL.
To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1399768/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
