[Bug 998137] Re: [SRU] Keystone user tenant membership not always removed

[Brian Murray]

Putting everything in one place, here is the test case:

ubuntu at ip-10-252-87-70:~$ tenant_id=$(keystone tenant-create --name testingtenant | grep id | awk '{ print $4 }')
ubuntu at ip-10-252-87-70:~$ user_id=$(keystone user-create --name testinguser --pass testing --tenant_id $tenant_id | grep id | awk '{ print $4 }')
ubuntu at ip-10-252-87-70:~$ echo $user_id
e5e045e898694f46a55fb9483a1c03c4
ubuntu at ip-10-252-87-70:~$ keystone user-delete $user_id
No handlers could be found for logger "keystoneclient.client"
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_tenant_membership`, CONSTRAINT `user_tenant_membership_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))') 'DELETE FROM user WHERE user.id = %s' ('e5e045e898694f46a55fb9483a1c03c4',) (HTTP 500)
ubuntu at ip-10-252-87-70:~$ keystone user-delete $user_id
No handlers could be found for logger "keystoneclient.client"
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_tenant_membership`, CONSTRAINT `user_tenant_membership_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))') 'DELETE FROM user WHERE user.id = %s' ('e5e045e898694f46a55fb9483a1c03c4',) (HTTP 500)
ubuntu at ip-10-252-87-70:~$ keystone user-delete $user_id
No handlers could be found for logger "keystoneclient.client"
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_tenant_membership`, CONSTRAINT `user_tenant_membership_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))') 'DELETE FROM user WHERE user.id = %s' ('e5e045e898694f46a55fb9483a1c03c4',) (HTTP 500)
ubuntu at ip-10-252-87-70:~$ keystone user-delete $user_id
No handlers could be found for logger "keystoneclient.client"
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_tenant_membership`, CONSTRAINT `user_tenant_membership_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))') 'DELETE FROM user WHERE user.id = %s' ('e5e045e898694f46a55fb9483a1c03c4',) (HTTP 500)
ubuntu at ip-10-252-87-70:~$ keystone user-delete $user_id
ubuntu at ip-10-252-87-70:~$

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to keystone in Ubuntu.
https://bugs.launchpad.net/bugs/998137

Title:
  [SRU] Keystone user tenant membership not always removed

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