yahoo-eng-team team mailing list archive

[Dave Chen <wei.d.chen@xxxxxxxxx>]

Public bug reported:

Since the endpoint_group_id of table project_endpoint_group has a
foreign key reference with the id of endpoint_group, so if we want to
delete endpoint_group we need delete associated project_endpoint_group
at first, or else, it will hit follow exceptions:

{"error": {"message": "An unexpected error prevented the server from
fulfilling your request: (IntegrityError) (1451, 'Cannot delete or
update a parent row: a foreign key constraint fails
(`keystone`.`project_endpoint_group`, CONSTRAINT
`project_endpoint_group_ibfk_1` FOREIGN KEY (`endpoint_group_id`)
REFERENCES `endpoint_group` (`id`))') 'DELETE FROM endpoint_group WHERE
endpoint_group.id = %s' ('d5c86622fea04c43b0c0e3b540417e1f',) (Disable
debug mode to suppress these details.)", "code": 500, "title": "Internal
Server Error"}}

** Affects: keystone
     Importance: Undecided
     Assignee: Dave Chen (wei-d-chen)
         Status: New

** Changed in: keystone
     Assignee: (unassigned) => Dave Chen (wei-d-chen)

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

Title:
  Delete endpoint_group should remove project_endpoint_group at first

Status in OpenStack Identity (Keystone):
  New

Bug description:
  Since the endpoint_group_id of table project_endpoint_group has a
  foreign key reference with the id of endpoint_group, so if we want to
  delete endpoint_group we need delete associated project_endpoint_group
  at first, or else, it will hit follow exceptions:

  {"error": {"message": "An unexpected error prevented the server from
  fulfilling your request: (IntegrityError) (1451, 'Cannot delete or
  update a parent row: a foreign key constraint fails
  (`keystone`.`project_endpoint_group`, CONSTRAINT
  `project_endpoint_group_ibfk_1` FOREIGN KEY (`endpoint_group_id`)
  REFERENCES `endpoint_group` (`id`))') 'DELETE FROM endpoint_group
  WHERE endpoint_group.id = %s' ('d5c86622fea04c43b0c0e3b540417e1f',)
  (Disable debug mode to suppress these details.)", "code": 500,
  "title": "Internal Server Error"}}

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