[Openstack-operators] Problem deleting user

Jonathan Proulx jon at jonproulx.com
Wed Aug 22 19:50:10 UTC 2012


Ok,

by first removing this user's  roles with:
keystone user-role-remove --user e41118cbc397458e963897e05d8ad529
--tenant 9f13bf11e06e4d81b44c8c3e62d4362b --role
c375a84c8ad94994a4126c72df2ca8cf

I was then able to delete, but I don't see any way to list a user's
roles (and think deleting a user should clean this up rather than
error out)

Are my expectations off or is something else wrong here?

-Jon

On Wed, Aug 22, 2012 at 3:31 PM, Jonathan Proulx <jon at jonproulx.com> wrote:
> Hi All,
>
> I having an issue deleting a user:
>
> # keystone user-delete e41118cbc397458e963897e05d8ad529
> 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'
> ('e41118cbc397458e963897e05d8ad529',) (HTTP 500)
>
> this is an older test account so I may have doe something weird when
> creating it.
>
> Presumably there's something better than hand cleaning the database I
> can do here.
>
> -Jon



More information about the OpenStack-operators mailing list