Can't login after updating gitlab docker image from 15.11 to latest

I was having the issue found here:

and after updating docker on this machine from 19.0 to 24.0, gitlab can now start, but all users get a 500 error at login, and in the production.log file, at every login I see this:

ActiveRecord::StatementInvalid (PG::CheckViolation: ERROR:  new row for relation "users" violates check constraint "check_0dd5948e38"
DETAIL:  Failing row contains (12, user@email.com passwordhash, null, null, null, 8, 2023-07-14 00:16:51.423988, 2023-07-13 15:46:06.931353, 10.253.10.116, 10.253.10.116, 2021-06-03 13:44:38.467339, 2023-07-14 00:16:51.494883, User Name, f, 100000, 1, null, username, t, f, active, 2, null, null, null, null, null, 2021-06-03 13:44:38.38):

since I can’t login, there isn’t much else I can do to debug this. downgrading isn’t an option since now the issue persists in 15.11 now

Hi @Whsitler :wave: , welcome to the GitLab Community Forum! :tada:

Based on the error message, it sounds like you’re hitting this problem constraint errors after update from 15.11 to 16.10 (PG::CheckViolation: ERROR: new row for relation "users" violates check constraint "check_0dd5948e38") (#416242) · Issues · GitLab.org / GitLab · GitLab

Can you try the solution suggested here and let us know how it goes?