yahoo-eng-team team mailing list archive

[OpenStack Infra <1546562@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.openstack.org/281921
Committed: https://git.openstack.org/cgit/openstack/keystone/commit/?id=15ca0f27f13031afa591e1c07846bd1fe9d92b15
Submitter: Jenkins
Branch:    master

commit 15ca0f27f13031afa591e1c07846bd1fe9d92b15
Author: Alexander Makarov <amakarov@xxxxxxxxxxxx>
Date:   Thu Feb 18 18:57:40 2016 +0300

    Implied roles index with cascading delete
    
    Currently, when deleting a role that has an implied role, only one
    is removed from the database. This is because the initial FKs that
    were created did not take delete and update into account.
    
    Change-Id: I09ef96cf9e4a863337399ae880e0511125f5239c
    Closes-Bug: 1546562


** Changed in: keystone
       Status: In Progress => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1546562

Title:
  deleting role with implied role fails

Status in OpenStack Identity (keystone):
  Fix Released

Bug description:
  Create two  roles.  Make one imply the other (need curl for now)

  
  $ openstack role delete identity_policy_manager
  ERROR: openstack An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-a2b89f42-ad24-4985-a599-33cc182d8f80)

  
  Looking in the log

  Feb 17 14:05:44 ayoung541 admin: 2016-02-17 14:05:44.042 31 ERROR
  keystone.common.wsgi [req-a2b89f42-ad24-4985-a599-33cc182d8f80
  6259462f07a940f19b1ad8d36ee42612 b0fa955539c442cc838067a55605102d -
  default default] (pymysql.err.IntegrityError) (1451, u'Cannot delete
  or update a parent row: a foreign key constraint fails
  (`keystone`.`implied_role`, CONSTRAINT
  `implied_role_prior_role_id_fkey` FOREIGN KEY (`prior_role_id`)
  REFERENCES `role` (`id`))') [SQL: u'DELETE FROM role WHERE role.id =
  %(id)s'] [parameters: {'id': u'142340f53b624665a86641cf13135615'}]

  This is supposed to be a cascading delete.

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