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  ERROR: duplicate key value violates unique constraint “consumers_username_key”
2020-06-18 13:10:50.602 CDT  DETAIL: Key (username)=(default:p050274) already exists.