deleting tenants and users does not take care of foreign keys

Bug #972502 reported by J. Daniel Schmidt
This bug report is a duplicate of:  Bug #959294: [SRU] Can't delete users. Edit Remove
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
In Progress
Undecided
J. Daniel Schmidt

Bug Description

When deleting tenants and users leaves behind foreign keys for tenant_id and user_id in the tables user_tenant_membership and metadata (maybe also in token).

We deleted the (devstack) demo tenant/project. As a result the admin user could no longer login.

These two errors were shown on the dashboard login page:
* Error: An unexpected error prevented the server from fulfilling your request. argument of type 'NoneType' is not iterable (HTTP 500)

* Error: You are not authorized for any projects.

The database schema lacks cascade statements to take care of the cleanup.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to keystone (master)

Fix proposed to branch: master
Review: https://review.openstack.org/6161

Changed in keystone:
assignee: nobody → J. Daniel Schmidt (jdsn)
status: New → In Progress
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.