This is exactly the problem I recently had with my corrupt index. I ended up inspecting these account, often found they were the same (same email address), renamed one and then merged them. It took quite a bit of work as it was mostly manual, but now I have a shiny new index ![]()
Edit: oops, my problem was in the users table. Same duplicate key issue though.