[网站宕机 :(] 升级\重建失败 - 数据库迁移问题？

[JammyDodger]

它似乎认为您有两个名为 racerx 的用户。我认为这里有一个关于类似问题的帖子：

@Paulus_Schoutsen

我们也有 8 位用户拥有重复的 username_lower（太多名叫 mike 和 marco 的用户）。我们通过更新 username 和 username_lower 来重命名他们。从用户数据中我们注意到，第一次损坏发生在 2019 年 12 月。

这里还有一个最近的帖子：

PG::UniqueViolation Problem during 3.1.0.beta4 upgrade

Thanks for your reply. Yes, I am able to start / enter the app, I am also doing as you suggested. discourse=# REINDEX TABLE users; ERROR: could not create unique index "index_users_on_username_lower" DETAIL: Key (username_lower)=(mostafa11) is duplicated. The problem is duplicates keep coming, I have a lot of user over 300K. Is there any way to check how many duplicates or list all of them? For fixing, I was updating the username_lower like this: I was appending some number at the end. U…