Comment 14 for bug 998137

Revision history for this message
Brian Murray (brian-murray) wrote :

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

ubuntu@ip-10-252-87-70:~$ tenant_id=$(keystone tenant-create --name testingtenant | grep id | awk '{ print $4 }')
ubuntu@ip-10-252-87-70:~$ user_id=$(keystone user-create --name testinguser --pass testing --tenant_id $tenant_id | grep id | awk '{ print $4 }')
ubuntu@ip-10-252-87-70:~$ echo $user_id
e5e045e898694f46a55fb9483a1c03c4
ubuntu@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@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@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@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@ip-10-252-87-70:~$ keystone user-delete $user_id
ubuntu@ip-10-252-87-70:~$