I just changed the username of a person xxx on their demand. they wanted to take an inactive username yyy. so first I changed the inactive username yyy to somthing else like yyy1 and then changed that person username from xxx to yyy. at this point, first, the user couldnt post anything and I saw the following error in the logs: Job exception: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_users_on_username_lower" DETAIL: Key (username_lower)=(mina) already exists. I tried to change back the username to what was before, now all of their history is gone. What exactly did go wrong here?

Now I cant even open their profile page. Is there somthing I can do to heal this in the meantime? [Screenshot%20from%202019-11-05%2022-48-23] [Screenshot%20from%202019-11-05%2022-45-16]

I’m working on going through the steps you outlined right now. I’ll let you know what I find.

[image] hosna: Job exception: PG::UniqueViolation: ERROR: duplicate key value violates unique constraint “index_users_on_username_lower” DETAIL: Key (username_lower)=(mina) already exists. btw idk why im getting error on this user (username_lower)=(mina) at all. I have never done any change to it and seems it is an inactive user. However I see a wierd behaviour on their profile too. If I open their notification page, I get a 404 error.

Ok, I ran through the steps. If I did anything different from what you did, let me know. There are two users: xxx (active account) yyy (inactive account) Change yyy to yyy1 Change xxx to yyy ( :white_check_mark: worked for me) Try posting using the new yyy account ( :white_check_mark: worked for me) Change yyy back to xxx ( :white_check_mark: worked for me, no loss of user history) I didn’t have any issues through the whole process. One thing to note is that after you change a user’s username from the user admin page, you will need to refresh the page before the “Show public profile” button will navigate to the correct user. Can you check your /admin/logs/staff_action_logs to see if all of the logged username changes make sense? Clicking on the avatars of the listed usernames should take you to their current and correct user page.

[image] tshenry: Clicking on the avatars of the listed usernames should take you to their current and correct user page. Yes clicking on the avatar takes me to their page. however, it sems to me that their page is kind of inactive. for example I cant display their email or impersonate their account: [Screenshot%20from%202019-11-05%2023-55-48] this is what I did so far: [image] according to what I see in this report, first I changed fatemeh to fatemeh12 . then changed fatemeh_baghdadi to fatemeh . after a while, the user told me that they cant post anything. so I thought maybe there was somthing wrong in the process of changing username and tried to change the username to somthing that hasnt been used so far. so I changed fatemeh (previously fatemeh_baghdadi) to fatemeh74. then I saw that their history got cleared totaly and I got nervous. So I tried to change back the username to what was in the begining from fatemeh74 to fatemeh_baghdadi . and again from fatemeh_baghdadi to fatemeh_baghdadi5 but nothing get better. now I have two diffrent user fatemeh74 and fatemeh_baghdadi5 which theoritically should be one person but actually they are 2 person, one seems to be not working correctly.

I’m trying my best to follow along here. It sounds like a very odd situation! Can you clarify what you mean when you say that their history was totally cleared? Should fatemeh_baghdadi5 have various topics and replies listed under the activity section of their profile? If that is the case, are those posts now associated with the fatemeh74 account? They should exist somewhere on the site and be associated with a specific user. From an anonymous user perspective, I’m not able to find a user with the username fatemeh74 on your site. There is a background job called EnsureDbConsistency that runs every 12 hours. It might be interesting to either trigger it manually from sidekiq, or wait and see if everything gets fixed automatically in the next 12 hours. If you do end up having two accounts that should be one, you should be able to merge them. I would definitely take a backup before attempting that, however. It’s really hard to understand what’s going on without having direct access to everything, but hopefully we can get it figured out!

[image] tshenry: Can you clarify what you mean when you say that their history was totally cleared? at the moment that I changed the username, I went to their profile and saw no posts, etc. but it got fixed after a while. however now fatemeh74 which actually seems to be the correct person, is kind of inactive. I mean as you see, we cant see their profile page, while their post and other things are present. like this: [image] معنی این جمله لطفا کمک سوال کلی نباید بگید جز به جز توضیح بدید دوستان متوجه شن آرمینا 🤣 [image] tshenry: If you do end up having two accounts that should be one, you should be able to merge them. They are not actually one, I checked their email and their id and theyre completely diffrent. However according to the steps I changed the usernames, they should be the same and actually I shouldnt have two users here. [image] tshenry: There is a background job called EnsureDbConsistency that runs every 12 hours. It might be interesting to either trigger it manually from sidekiq where is this exactly?

[image] hosna: I mean as you see, we cant see their profile page, while their post and other things are present. like this: Thanks for posting that example. That’s definitely concerning. [image] hosna: where is this exactly? You can find it listed at /sidekiq/scheduler. It’s worth a shot, but based on what you just posted, it sounds like there might be a deeper issue.

[image] tshenry: It’s worth a shot, but based on what you just posted, it sounds like there might be a deeper issue. Unfortunately you are right. It didnt fix my problem.

Critical Error: changed username, user got broken

Product Support

hosna (hosna) November 6, 2019, 9:14pm 20

I’m OK with sending a copy of my database, if that might help finding the problem.

Topic		Replies	Views
Username already exist error Self-hosting	3	1234	December 11, 2019
So many broken users due to corrupt database Product Support	16	1719	April 27, 2020
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	24	2617	January 26, 2021
Update quotes and mentions when username is changed Feature	22	5113	February 19, 2021
Username change wipes post history in user profile Product Support	9	2274	July 5, 2016

Critical Error: changed username, user got broken

Related topics