yahoo-eng-team team mailing list archive

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

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

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

Title:
  Unable to delete domain if user from other domain was added

Status in OpenStack Identity (Keystone):
  Fix Released

Bug description:
  I tried a use case where I 
  1. Have list of users (in the LDAP) in the default domain 
  2. Create domain
  3. Add member role to user  for the new domain
  4. Remove role
  5. Try do delete domain

  And there I got the problem
  {"domain": {"enabled": false, "id": "5bc213efd70e4ec197c8a85350b127e3", "links": {"self": "http://127.0.0.1:5000/v3/domains/5bc213efd70e4ec197c8a85350b127e3"}, "name": "test-domain"}}####Delete domain
  HTTP/1.1 500 Internal Server Error
  Vary: X-Auth-Token
  Content-Type: application/json
  Content-Length: 450
  Date: Wed, 18 Dec 2013 19:47:47 GMT

  {"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`.`user_domain_metadata`, CONSTRAINT
  `user_domain_metadata_ibfk_2` FOREIGN KEY (`domain_id`) REFERENCES
  `domain` (`id`))') 'DELETE FROM domain WHERE domain.id = %s'
  ('5bc213efd70e4ec197c8a85350b127e3',)", "code": 500, "title":
  "Internal Server Error"}}####List domains

  mysql> select * from domain where id="5bc213efd70e4ec197c8a85350b127e3";
  +----------------------------------+-------------+---------+-------+
  | id                               | name        | enabled | extra |
  +----------------------------------+-------------+---------+-------+
  | 5bc213efd70e4ec197c8a85350b127e3 | test-domain |       0 | {}    |
  +----------------------------------+-------------+---------+-------+
  1 row in set (0.00 sec)
  mysql> select * from user_domain_metadata;
  +----------------------------------+----------------------------------+---------------+
  | user_id                          | domain_id                        | data          |
  +----------------------------------+----------------------------------+---------------+
  | d0c8e779e094463cabc425f1d222e7e0 | 5bc213efd70e4ec197c8a85350b127e3 | {"roles": []} |
  +----------------------------------+----------------------------------+---------------+
  1 row in set (0.00 sec)

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