Failed to create admin - duplicate user in database

We had a strange issue with a user i set up recently. He seemed to get locked out of our test kingdom I just created during a password reset he had. I thought i could removed him as a user and then add back. But getting a basic UI error “failed to create admin”. The database log shows a duplicate key constraint. Is there a way to clean up the database and remove him or what is a better process to re-add a user?

2020-06-18 13:10:50.602 CDT [77776] ERROR: duplicate key value violates unique constraint “consumers_username_key”
2020-06-18 13:10:50.602 CDT [77776] DETAIL: Key (username)=(default:p050274) already exists.