コマンドラインからの復元エラー（重複メール）

[hosna]

以下のエラーが発生しました：

EXCEPTION: psql が失敗しました：DETAIL: キー (lower(email::text))=({REDACTED}@yahoo.com) が重複しています。

これをどのように修正すればよいでしょうか？

[hosna]

これはおそらくこれに関連していると思います：

So many broken users due to corrupt database

I have a real issue with many of my users. The users can be seen in admin panel like this: [Screenshot from 2019-12-12 20-00-31] But when I try to reveal their email address, It wont show anything to me. And also their public profile gives a 404 error. As far as I see, all of these users are almost inactive (they are active in terms of activation but inactive in terms of activity in forum). So I think maybe its been caused by a broken automatic inactive user removal in the very long past.