2017-09-21 18:01:43 |
Guang Yee |
bug |
|
|
added bug |
2017-09-21 20:15:24 |
Samuel de Medeiros Queiroz |
keystone: status |
New |
Confirmed |
|
2017-09-21 20:27:50 |
Samuel de Medeiros Queiroz |
keystone: importance |
Undecided |
High |
|
2017-09-21 20:36:10 |
Samuel de Medeiros Queiroz |
keystone: assignee |
|
Samuel de Medeiros Queiroz (samueldmq) |
|
2017-09-21 20:52:23 |
Samuel de Medeiros Queiroz |
summary |
Unable to delete domain with projects in it |
Unable to delete domain with users in it |
|
2017-09-21 21:40:40 |
OpenStack Infra |
keystone: status |
Confirmed |
In Progress |
|
2017-10-13 19:34:13 |
Lance Bragstad |
description |
Attempting to delete a domain which contains users and projects may yield an UnexpectedError similiar to this
Sep 21 19:37:17 vagrant-openSUSE-Leap devstack@keystone.service[23894]: DEBUG keystone.common.sql.core [None req-707ec264-b10c-4079-94bb-2af01db58aab None None] Conflict project: (pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (`keystone`.`user`, CONSTRAINT `user_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `project` (`id`))') [SQL: u'DELETE FROM project WHERE project.id = %(id)s'] [parameters: {'id': u'63d2d5446e364f00b3181bf49c62c5b8'}] {{(pid=23897) wrapper /opt/stack/keystone/keystone/common/sql/core.py:550}}
Sep 21 19:37:17 vagrant-openSUSE-Leap devstack@keystone.service[23894]: WARNING keystone.common.wsgi [None req-707ec264-b10c-4079-94bb-2af01db58aab None None] An unexpected error prevented the server from fulfilling your request.: UnexpectedError: An unexpected error prevented the server from fulfilling your request.
Steps to reproduce:
1. Install devstack
2. create a domain 'foo'
openstack domain create foo
3. create a user in domain 'foo'
openstack user create --password equifax --domain foo foo_user
4. create a project in domain 'foo'
openstack project create --domain foo foo_project
5. enable domain user 'foo_user' access to project 'foo_project'
openstack role add --user foo_user --project foo_project admin
6. now disable domain 'foo'
openstack domain set --disable foo
7. attempt to delete domain 'foo' will yield an expected error mentioned above
openstack domain delete foo |
Attempting to delete a domain which contains users and projects may yield an UnexpectedError similiar to this
Sep 21 19:37:17 vagrant-openSUSE-Leap devstack@keystone.service[23894]: DEBUG keystone.common.sql.core [None req-707ec264-b10c-4079-94bb-2af01db58aab None None] Conflict project: (pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (`keystone`.`user`, CONSTRAINT `user_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `project` (`id`))') [SQL: u'DELETE FROM project WHERE project.id = %(id)s'] [parameters: {'id': u'63d2d5446e364f00b3181bf49c62c5b8'}] {{(pid=23897) wrapper /opt/stack/keystone/keystone/common/sql/core.py:550}}
Sep 21 19:37:17 vagrant-openSUSE-Leap devstack@keystone.service[23894]: WARNING keystone.common.wsgi [None req-707ec264-b10c-4079-94bb-2af01db58aab None None] An unexpected error prevented the server from fulfilling your request.: UnexpectedError: An unexpected error prevented the server from fulfilling your request.
Steps to reproduce:
1. Install devstack
2. create a domain 'foo'
openstack domain create foo
3. create a user in domain 'foo'
openstack user create --password equifax --domain foo foo_user
4. create a project in domain 'foo'
openstack project create --domain foo foo_project
5. enable domain user 'foo_user' access to project 'foo_project'
openstack role add --user foo_user --project foo_project admin
6. now disable domain 'foo'
openstack domain set --disable foo
7. attempt to delete domain 'foo' will yield an expected error mentioned above
openstack domain delete foo
This was introduced in: https://github.com/openstack/keystone/commit/2bd88d30e1d2873470af7f40db45a99e07e12ce6 |
|
2017-10-13 21:25:07 |
Lance Bragstad |
nominated for series |
|
keystone/newton |
|
2017-10-13 21:25:07 |
Lance Bragstad |
bug task added |
|
keystone/newton |
|
2017-10-13 21:25:07 |
Lance Bragstad |
nominated for series |
|
keystone/ocata |
|
2017-10-13 21:25:07 |
Lance Bragstad |
bug task added |
|
keystone/ocata |
|
2017-10-13 21:25:07 |
Lance Bragstad |
nominated for series |
|
keystone/pike |
|
2017-10-13 21:25:07 |
Lance Bragstad |
bug task added |
|
keystone/pike |
|
2017-10-13 21:25:16 |
Lance Bragstad |
keystone/newton: importance |
Undecided |
High |
|
2017-10-13 21:25:18 |
Lance Bragstad |
keystone/ocata: importance |
Undecided |
Medium |
|
2017-10-13 21:25:22 |
Lance Bragstad |
keystone/pike: importance |
Undecided |
Medium |
|
2017-10-13 21:25:25 |
Lance Bragstad |
keystone/ocata: importance |
Medium |
High |
|
2017-10-13 21:25:31 |
Lance Bragstad |
keystone/pike: importance |
Medium |
High |
|
2017-10-13 21:25:39 |
Lance Bragstad |
keystone/newton: status |
New |
Confirmed |
|
2017-10-13 21:25:43 |
Lance Bragstad |
keystone/pike: status |
New |
Confirmed |
|
2017-10-13 21:25:45 |
Lance Bragstad |
keystone/ocata: status |
New |
Confirmed |
|
2017-11-21 15:43:17 |
Lance Bragstad |
keystone/newton: status |
Confirmed |
Won't Fix |
|
2018-01-22 06:21:18 |
OpenStack Infra |
keystone: assignee |
Samuel de Medeiros Queiroz (samueldmq) |
CHARLES WANG (charleswang007) |
|
2018-01-24 12:55:34 |
Colleen Murphy |
keystone: milestone |
|
queens-rc1 |
|
2018-01-30 22:29:26 |
OpenStack Infra |
keystone: assignee |
CHARLES WANG (charleswang007) |
Colleen Murphy (krinkle) |
|
2018-02-08 23:15:25 |
OpenStack Infra |
keystone: status |
In Progress |
Fix Released |
|
2018-02-08 23:20:55 |
OpenStack Infra |
keystone/pike: status |
Confirmed |
In Progress |
|
2018-02-08 23:20:55 |
OpenStack Infra |
keystone/pike: assignee |
|
Colleen Murphy (krinkle) |
|
2018-02-12 08:28:29 |
OpenStack Infra |
keystone/ocata: status |
Confirmed |
In Progress |
|
2018-02-12 08:28:29 |
OpenStack Infra |
keystone/ocata: assignee |
|
Colleen Murphy (krinkle) |
|
2018-02-12 21:18:42 |
OpenStack Infra |
keystone/pike: status |
In Progress |
Fix Committed |
|
2018-02-15 05:28:40 |
OpenStack Infra |
keystone/ocata: status |
In Progress |
Fix Committed |
|
2022-03-15 10:57:14 |
Ji Chengke |
keystone/pike: status |
Fix Committed |
Fix Released |
|