yahoo-eng-team team mailing list archive

[Sergii Kashaba <1262360@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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)

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
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):
  New

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