[Openstack-operators] Problem deleting user

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


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

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?


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