A user, Alex_Gruzglin, reports that new users cannot join their Discourse forum due to an internal server error when accepting invitations. The error log shows a PG::UniqueViolation related to the user_emails_pkey constraint, indicating a duplicate ID issue. pfaffman suggests the problem may stem from a corrupted index in PostgreSQL and advises checking the PostgreSQL version (found in /var/discourse/shared/standalone/postgres_data/PG_VERSION) and attempting to rebuild the index or resolve duplicate entries. Alex_Gruzglin acknowledges the helpful guidance.
Help!
I’m an admin of a Discuss forum in PractiTest.
Recently new users cannot log in, they receive an error message “Something went wrong, perhaps the username or email is already registered. Try the forgot password link.”.
When I invite the new users, they get the invitation email, but after feeling all details have an “Internal Server Error” message.
I checked error logs, and this is what I see for invitation acceptance attempt:
It sounds like you have a corrupt index, which I haven’t seen in a while. The solution is to try to rebuild the index and if it fails delete or fix the duplicate entries. It requires understanding some stuff about sql and indexes and discourse.
You can search for “corrupt index”
It could be something else. I thought this hasn’t happened to anyone on postgres 13. How old is you forum.