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 -- 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