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